[ Dec 6 21:14:36 Enabled. ] [ Dec 6 21:14:36 Rereading configuration. ] [ Dec 6 21:14:39 Rereading configuration. ] [ Dec 6 21:14:48 Executing start method ("/opt/oxide/lib/svc/manifest/clickhouse.sh"). ] + set -o errexit + set -o pipefail + . /lib/svc/share/smf_include.sh ++ SMF_EXIT_OK=0 ++ SMF_EXIT_NODAEMON=94 ++ SMF_EXIT_ERR_FATAL=95 ++ SMF_EXIT_ERR_CONFIG=96 ++ SMF_EXIT_MON_DEGRADE=97 ++ SMF_EXIT_MON_OFFLINE=98 ++ SMF_EXIT_ERR_NOSMF=99 ++ SMF_EXIT_ERR_PERM=100 ++ svcprop -c -p config/listen_addr svc:/oxide/clickhouse:default + LISTEN_ADDR=fd00:1122:3344:101::e ++ svcprop -c -p config/listen_port svc:/oxide/clickhouse:default + LISTEN_PORT=8123 ++ svcprop -c -p config/store svc:/oxide/clickhouse:default + DATASTORE=/data + args=("--config-file" "/opt/oxide/clickhouse/config.xml" "--" "--path" "${DATASTORE}" "--listen_host" "$LISTEN_ADDR" "--http_port" "$LISTEN_PORT") + 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 [ Dec 6 21:14:49 Method "start" exited with status 0. ] Processing configuration file '/opt/oxide/clickhouse/config.xml'. Logging trace to /var/tmp/clickhouse-server.log Logging errors to /var/tmp/clickhouse-server.errlog 2024.12.06 21:14:49.804704 [ 1 ] {} Application: Will watch for the process with pid 23677 2024.12.06 21:14:49.805318 [ 1 ] {} Application: Forked a child process to watch 2024.12.06 21:14:50.063106 [ 1 ] {} Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: ), PID 23677 2024.12.06 21:14:50.063844 [ 1 ] {} Application: starting up 2024.12.06 21:14:50.064577 [ 1 ] {} Application: OS name: SunOS, version: 5.11, architecture: i86pc 2024.12.06 21:14:50.152180 [ 1 ] {} Application: Available RAM: 95.88 GiB; physical cores: 48; logical cores: 48. 2024.12.06 21:14:50.185636 [ 1 ] {} Application: rlimit on number of file descriptors is 65536 2024.12.06 21:14:50.185711 [ 1 ] {} Application: Initializing DateLUT. 2024.12.06 21:14:50.185728 [ 1 ] {} Application: Initialized DateLUT with time zone 'UTC'. 2024.12.06 21:14:50.185803 [ 1 ] {} Context: Setting up /data/tmp/ to store temporary data in it 2024.12.06 21:14:50.186203 [ 1 ] {} Application: Initializing interserver credentials. 2024.12.06 21:14:50.187877 [ 1 ] {} ConfigReloader: Loading config '/opt/oxide/clickhouse/config.xml' Processing configuration file '/opt/oxide/clickhouse/config.xml'. Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. 2024.12.06 21:14:50.188660 [ 1 ] {} ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration 2024.12.06 21:14:50.189535 [ 1 ] {} 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) 2024.12.06 21:14:50.189558 [ 1 ] {} 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) 2024.12.06 21:14:50.189573 [ 1 ] {} Application: Merges and mutations memory limit is set to 47.94 GiB 2024.12.06 21:14:50.189763 [ 1 ] {} BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.06 21:14:50.190689 [ 1 ] {} BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads 2024.12.06 21:14:50.197061 [ 1 ] {} BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.06 21:14:50.197944 [ 1 ] {} BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.06 21:14:50.199393 [ 1 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.12.06 21:14:50.199464 [ 1 ] {} ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration 2024.12.06 21:14:50.201129 [ 1 ] {} ConfigReloader: Loading config '/opt/oxide/clickhouse/config.xml' Processing configuration file '/opt/oxide/clickhouse/config.xml'. Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. 2024.12.06 21:14:50.201633 [ 1 ] {} ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration 2024.12.06 21:14:50.206183 [ 1 ] {} ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration 2024.12.06 21:14:50.206929 [ 1 ] {} Access(user directories): Added users_xml access storage 'users_xml', path: /opt/oxide/clickhouse/config.xml 2024.12.06 21:14:50.208653 [ 1 ] {} Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin 2024.12.06 21:14:50.209099 [ 1 ] {} Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 2024.12.06 21:14:50.209531 [ 1 ] {} Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 2024.12.06 21:14:50.209918 [ 1 ] {} Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 2024.12.06 21:14:50.211392 [ 1 ] {} DNSCacheUpdater: Update period 15 seconds 2024.12.06 21:14:50.211420 [ 1 ] {} Application: Loading metadata from /data/ 2024.12.06 21:14:50.211496 [ 127 ] {} DNSResolver: Updating DNS cache 2024.12.06 21:14:50.211682 [ 127 ] {} DNSResolver: Updated DNS cache 2024.12.06 21:14:50.227370 [ 1 ] {} DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. 2024.12.06 21:14:50.227398 [ 1 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000154943 sec 2024.12.06 21:14:50.227443 [ 1 ] {} ReferentialDeps: No tables 2024.12.06 21:14:50.227458 [ 1 ] {} LoadingDeps: No tables 2024.12.06 21:14:50.228645 [ 1 ] {} DatabaseAtomic (system): Starting up tables. 2024.12.06 21:14:50.229703 [ 1 ] {} SystemLog: Creating system.query_log from query_log 2024.12.06 21:14:50.241573 [ 1 ] {} SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config 2024.12.06 21:14:50.241622 [ 1 ] {} SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config 2024.12.06 21:14:50.241645 [ 1 ] {} SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config 2024.12.06 21:14:50.241658 [ 1 ] {} SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config 2024.12.06 21:14:50.241689 [ 1 ] {} SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config 2024.12.06 21:14:50.241710 [ 1 ] {} SystemLog: Creating system.metric_log from metric_log 2024.12.06 21:14:50.244410 [ 1 ] {} SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config 2024.12.06 21:14:50.244461 [ 1 ] {} SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config 2024.12.06 21:14:50.244484 [ 1 ] {} SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log 2024.12.06 21:14:50.244673 [ 1 ] {} SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config 2024.12.06 21:14:50.244692 [ 1 ] {} SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config 2024.12.06 21:14:50.244732 [ 1 ] {} SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config 2024.12.06 21:14:50.244753 [ 1 ] {} SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config 2024.12.06 21:14:50.244765 [ 1 ] {} SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config 2024.12.06 21:14:50.244795 [ 1 ] {} SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config 2024.12.06 21:14:50.244812 [ 1 ] {} SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config 2024.12.06 21:14:50.272146 [ 1 ] {} DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. 2024.12.06 21:14:50.277684 [ 1 ] {} DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. 2024.12.06 21:14:50.277718 [ 1 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.3041e-05 sec 2024.12.06 21:14:50.277732 [ 1 ] {} ReferentialDeps: No tables 2024.12.06 21:14:50.277743 [ 1 ] {} LoadingDeps: No tables 2024.12.06 21:14:50.277768 [ 1 ] {} DatabaseAtomic (default): Starting up tables. 2024.12.06 21:14:50.277987 [ 1 ] {} UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /data/user_defined/ 2024.12.06 21:14:50.278032 [ 1 ] {} UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded 2024.12.06 21:14:50.278046 [ 1 ] {} Application: Loaded metadata. 2024.12.06 21:14:50.278057 [ 1 ] {} 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). 2024.12.06 21:14:50.278069 [ 1 ] {} Application: TaskStats is not implemented for this OS. IO accounting will be disabled. 2024.12.06 21:14:50.287966 [ 1 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.12.06 21:14:50.288200 [ 1 ] {} AsynchronousMetrics: MemoryTracking: was 24.78 MiB, peak 24.78 MiB, free memory in arenas 0.00 B, will set to 117.12 MiB (RSS), difference: 92.35 MiB 2024.12.06 21:14:50.289235 [ 1 ] {} AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.8951e-05 sec. 2024.12.06 21:14:50.290309 [ 1 ] {} Application: Listening for http://[fd00:1122:3344:101::e]:8123 2024.12.06 21:14:50.290407 [ 1 ] {} Application: Listening for native protocol (tcp): [fd00:1122:3344:101::e]:9000 2024.12.06 21:14:50.290425 [ 1 ] {} Application: Ready for connections. 2024.12.06 21:14:50.342430 [ 3 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:36697 2024.12.06 21:14:50.342942 [ 3 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.343001 [ 3 ] {} TCP-Session: 4c0c3e1f-1edf-48cb-bf76-24ef9ac229a9 Authenticating user 'default' from [fd00:1122:3344:101::b]:36697 2024.12.06 21:14:50.343034 [ 3 ] {} TCP-Session: 4c0c3e1f-1edf-48cb-bf76-24ef9ac229a9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.343056 [ 3 ] {} TCP-Session: 4c0c3e1f-1edf-48cb-bf76-24ef9ac229a9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.343144 [ 3 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.12.06 21:14:50.343171 [ 3 ] {} 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 2024.12.06 21:14:50.343195 [ 3 ] {} 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 2024.12.06 21:14:50.343609 [ 4 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:40500 2024.12.06 21:14:50.343738 [ 4 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.343766 [ 4 ] {} TCP-Session: da196d27-1709-438c-8a52-1d7a6a7b07d6 Authenticating user 'default' from [fd00:1122:3344:101::b]:40500 2024.12.06 21:14:50.343790 [ 4 ] {} TCP-Session: da196d27-1709-438c-8a52-1d7a6a7b07d6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.343817 [ 4 ] {} TCP-Session: da196d27-1709-438c-8a52-1d7a6a7b07d6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.344425 [ 5 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:63950 2024.12.06 21:14:50.344431 [ 253 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:55857 2024.12.06 21:14:50.344511 [ 254 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:46412 2024.12.06 21:14:50.344544 [ 5 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.344752 [ 5 ] {} TCP-Session: 6c90413b-bb5c-45b5-850c-435231e5b328 Authenticating user 'default' from [fd00:1122:3344:101::b]:63950 2024.12.06 21:14:50.344809 [ 255 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:43168 2024.12.06 21:14:50.344892 [ 5 ] {} TCP-Session: 6c90413b-bb5c-45b5-850c-435231e5b328 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.344899 [ 253 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.344928 [ 5 ] {} TCP-Session: 6c90413b-bb5c-45b5-850c-435231e5b328 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.344877 [ 254 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.345078 [ 255 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.345111 [ 254 ] {} TCP-Session: c5bcfa1d-f9fe-4629-a187-ca06e4f6d8ff Authenticating user 'default' from [fd00:1122:3344:101::b]:46412 2024.12.06 21:14:50.345153 [ 256 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:57349 2024.12.06 21:14:50.345183 [ 253 ] {} TCP-Session: ad5539c7-476a-4a99-bcd3-4400e1d0c14b Authenticating user 'default' from [fd00:1122:3344:101::b]:55857 2024.12.06 21:14:50.345208 [ 255 ] {} TCP-Session: 6bebbf78-496c-4c9e-8630-19b3a84af67d Authenticating user 'default' from [fd00:1122:3344:101::b]:43168 2024.12.06 21:14:50.345236 [ 257 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:40306 2024.12.06 21:14:50.345324 [ 255 ] {} TCP-Session: 6bebbf78-496c-4c9e-8630-19b3a84af67d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.345374 [ 254 ] {} TCP-Session: c5bcfa1d-f9fe-4629-a187-ca06e4f6d8ff Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.345368 [ 256 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.345458 [ 253 ] {} TCP-Session: ad5539c7-476a-4a99-bcd3-4400e1d0c14b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.345389 [ 255 ] {} TCP-Session: 6bebbf78-496c-4c9e-8630-19b3a84af67d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.345530 [ 257 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.345559 [ 253 ] {} TCP-Session: ad5539c7-476a-4a99-bcd3-4400e1d0c14b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.345577 [ 256 ] {} TCP-Session: 87027eb6-5320-480b-b221-595707b24d09 Authenticating user 'default' from [fd00:1122:3344:101::b]:57349 2024.12.06 21:14:50.345684 [ 254 ] {} TCP-Session: c5bcfa1d-f9fe-4629-a187-ca06e4f6d8ff Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.345735 [ 256 ] {} TCP-Session: 87027eb6-5320-480b-b221-595707b24d09 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.345760 [ 257 ] {} TCP-Session: b6be55de-a78c-4f73-b56e-bdf04e70bcc0 Authenticating user 'default' from [fd00:1122:3344:101::b]:40306 2024.12.06 21:14:50.345853 [ 257 ] {} TCP-Session: b6be55de-a78c-4f73-b56e-bdf04e70bcc0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.345884 [ 256 ] {} TCP-Session: 87027eb6-5320-480b-b221-595707b24d09 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.345911 [ 257 ] {} TCP-Session: b6be55de-a78c-4f73-b56e-bdf04e70bcc0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.673211 [ 258 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:53772 2024.12.06 21:14:50.673365 [ 258 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.673415 [ 258 ] {} TCP-Session: c9c195a0-cbdf-4041-b24e-735f2a53f584 Authenticating user 'default' from [fd00:1122:3344:101::e]:53772 2024.12.06 21:14:50.673438 [ 258 ] {} TCP-Session: c9c195a0-cbdf-4041-b24e-735f2a53f584 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.673453 [ 258 ] {} TCP-Session: c9c195a0-cbdf-4041-b24e-735f2a53f584 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.673525 [ 258 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.12.06 21:14:50.673552 [ 258 ] {} 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 2024.12.06 21:14:50.673586 [ 258 ] {} 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 2024.12.06 21:14:50.674042 [ 259 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:41270 2024.12.06 21:14:50.674106 [ 260 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:63624 2024.12.06 21:14:50.674312 [ 261 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:43133 2024.12.06 21:14:50.674340 [ 259 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.674437 [ 260 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.674475 [ 259 ] {} TCP-Session: 20c747f6-602c-4c50-a4b3-65855daca09c Authenticating user 'default' from [fd00:1122:3344:101::e]:41270 2024.12.06 21:14:50.674617 [ 261 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.674616 [ 260 ] {} TCP-Session: b64bc66c-b924-4ec6-aabe-2b95e2a13b6d Authenticating user 'default' from [fd00:1122:3344:101::e]:63624 2024.12.06 21:14:50.674636 [ 259 ] {} TCP-Session: 20c747f6-602c-4c50-a4b3-65855daca09c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.674656 [ 262 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:61757 2024.12.06 21:14:50.674682 [ 261 ] {} TCP-Session: e721f8b5-f96f-4500-8331-e5c8d8fa75f8 Authenticating user 'default' from [fd00:1122:3344:101::e]:43133 2024.12.06 21:14:50.674633 [ 263 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:65333 2024.12.06 21:14:50.674726 [ 260 ] {} TCP-Session: b64bc66c-b924-4ec6-aabe-2b95e2a13b6d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.674727 [ 259 ] {} TCP-Session: 20c747f6-602c-4c50-a4b3-65855daca09c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.674769 [ 264 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:61989 2024.12.06 21:14:50.674806 [ 261 ] {} TCP-Session: e721f8b5-f96f-4500-8331-e5c8d8fa75f8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.674837 [ 265 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:59368 2024.12.06 21:14:50.674842 [ 260 ] {} TCP-Session: b64bc66c-b924-4ec6-aabe-2b95e2a13b6d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.675264 [ 263 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.675274 [ 265 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.675336 [ 264 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.675145 [ 261 ] {} TCP-Session: e721f8b5-f96f-4500-8331-e5c8d8fa75f8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.675387 [ 265 ] {} TCP-Session: 8de6140e-93fb-426a-8630-701923f187f0 Authenticating user 'default' from [fd00:1122:3344:101::e]:59368 2024.12.06 21:14:50.675430 [ 264 ] {} TCP-Session: 25a28817-0a63-4c15-b217-8ce1a256b540 Authenticating user 'default' from [fd00:1122:3344:101::e]:61989 2024.12.06 21:14:50.675429 [ 263 ] {} TCP-Session: 5b07104e-b01d-4230-8152-8d23df2dc7e7 Authenticating user 'default' from [fd00:1122:3344:101::e]:65333 2024.12.06 21:14:50.675536 [ 265 ] {} TCP-Session: 8de6140e-93fb-426a-8630-701923f187f0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.675647 [ 264 ] {} TCP-Session: 25a28817-0a63-4c15-b217-8ce1a256b540 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.675684 [ 265 ] {} TCP-Session: 8de6140e-93fb-426a-8630-701923f187f0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.675742 [ 264 ] {} TCP-Session: 25a28817-0a63-4c15-b217-8ce1a256b540 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.675790 [ 262 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.675810 [ 263 ] {} TCP-Session: 5b07104e-b01d-4230-8152-8d23df2dc7e7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.675884 [ 263 ] {} TCP-Session: 5b07104e-b01d-4230-8152-8d23df2dc7e7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.675889 [ 262 ] {} TCP-Session: bd379abe-aa32-4a1f-b864-c6ae101c5127 Authenticating user 'default' from [fd00:1122:3344:101::e]:61757 2024.12.06 21:14:50.676000 [ 262 ] {} TCP-Session: bd379abe-aa32-4a1f-b864-c6ae101c5127 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.676042 [ 262 ] {} TCP-Session: bd379abe-aa32-4a1f-b864-c6ae101c5127 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.882311 [ 266 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:58439 2024.12.06 21:14:50.882487 [ 266 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.882518 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Authenticating user 'default' from [fd00:1122:3344:101::d]:58439 2024.12.06 21:14:50.882563 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.882579 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.882653 [ 266 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.12.06 21:14:50.882692 [ 266 ] {} 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 2024.12.06 21:14:50.882710 [ 266 ] {} 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 2024.12.06 21:14:50.883181 [ 267 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:51322 2024.12.06 21:14:50.883257 [ 268 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:44123 2024.12.06 21:14:50.883693 [ 267 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.883683 [ 270 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:33117 2024.12.06 21:14:50.883709 [ 269 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:45437 2024.12.06 21:14:50.883739 [ 267 ] {} TCP-Session: 1f92a211-9b1e-4aa8-b8dc-1b79c7a2a714 Authenticating user 'default' from [fd00:1122:3344:101::d]:51322 2024.12.06 21:14:50.883706 [ 268 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.884518 [ 271 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:59419 2024.12.06 21:14:50.884595 [ 272 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:53171 2024.12.06 21:14:50.884635 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Authenticating user 'default' from [fd00:1122:3344:101::d]:44123 2024.12.06 21:14:50.884632 [ 270 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.885592 [ 271 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.885588 [ 270 ] {} TCP-Session: 07452ec3-32e7-4198-9470-27c2fd651cf8 Authenticating user 'default' from [fd00:1122:3344:101::d]:33117 2024.12.06 21:14:50.885566 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.885849 [ 269 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.885866 [ 272 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.885909 [ 273 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:61749 2024.12.06 21:14:50.885927 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.885998 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:50.886108 [ 269 ] {} TCP-Session: 7dbac14b-a92e-4f13-8871-46bf88cc01bc Authenticating user 'default' from [fd00:1122:3344:101::d]:45437 2024.12.06 21:14:50.886218 [ 272 ] {} TCP-Session: d0aea904-86d0-46d0-b9df-a351de5466cc Authenticating user 'default' from [fd00:1122:3344:101::d]:53171 2024.12.06 21:14:50.886316 [ 267 ] {} TCP-Session: 1f92a211-9b1e-4aa8-b8dc-1b79c7a2a714 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.886349 [ 274 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:43682 2024.12.06 21:14:50.886355 [ 270 ] {} TCP-Session: 07452ec3-32e7-4198-9470-27c2fd651cf8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.886322 [ 273 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.886401 [ 272 ] {} TCP-Session: d0aea904-86d0-46d0-b9df-a351de5466cc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.886434 [ 271 ] {} TCP-Session: 1b85a1e9-5b58-4095-8160-99e46f4ce6d3 Authenticating user 'default' from [fd00:1122:3344:101::d]:59419 2024.12.06 21:14:50.886455 [ 269 ] {} TCP-Session: 7dbac14b-a92e-4f13-8871-46bf88cc01bc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.886522 [ 272 ] {} TCP-Session: d0aea904-86d0-46d0-b9df-a351de5466cc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.886531 [ 267 ] {} TCP-Session: 1f92a211-9b1e-4aa8-b8dc-1b79c7a2a714 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.886667 [ 273 ] {} TCP-Session: d31aab08-bc24-4af9-be0d-660c0897944c Authenticating user 'default' from [fd00:1122:3344:101::d]:61749 2024.12.06 21:14:50.886688 [ 269 ] {} TCP-Session: 7dbac14b-a92e-4f13-8871-46bf88cc01bc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.886599 [ 271 ] {} TCP-Session: 1b85a1e9-5b58-4095-8160-99e46f4ce6d3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.887320 [ 273 ] {} TCP-Session: d31aab08-bc24-4af9-be0d-660c0897944c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.888584 [ 271 ] {} TCP-Session: 1b85a1e9-5b58-4095-8160-99e46f4ce6d3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.888595 [ 273 ] {} TCP-Session: d31aab08-bc24-4af9-be0d-660c0897944c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.888667 [ 270 ] {} TCP-Session: 07452ec3-32e7-4198-9470-27c2fd651cf8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.888678 [ 274 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:50.888759 [ 274 ] {} TCP-Session: a29bbc38-05b0-4329-9bde-d0cd27d65f38 Authenticating user 'default' from [fd00:1122:3344:101::d]:43682 2024.12.06 21:14:50.888803 [ 274 ] {} TCP-Session: a29bbc38-05b0-4329-9bde-d0cd27d65f38 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.888900 [ 274 ] {} TCP-Session: a29bbc38-05b0-4329-9bde-d0cd27d65f38 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:50.890544 [ 266 ] {6f725a64-2245-4b68-bc6e-39bed9c69e59} executeQuery: (from [fd00:1122:3344:101::d]:58439) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) 2024.12.06 21:14:50.947807 [ 266 ] {6f725a64-2245-4b68-bc6e-39bed9c69e59} executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:58439) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse 2. DB::Exception::Exception, std::allocator > >(int, FormatStringHelperImpl, std::allocator > >::type>, std::__cxx11::basic_string, std::allocator >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string, std::allocator > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse 10. std::__detail::_MakeUniq::__single_object std::make_unique&, std::shared_ptr&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse 11. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse 13. DB::executeQuery(std::__cxx11::basic_string, std::allocator > const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 2024.12.06 21:14:50.949133 [ 266 ] {6f725a64-2245-4b68-bc6e-39bed9c69e59} TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse 2. DB::Exception::Exception, std::allocator > >(int, FormatStringHelperImpl, std::allocator > >::type>, std::__cxx11::basic_string, std::allocator >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string, std::allocator > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse 10. std::__detail::_MakeUniq::__single_object std::make_unique&, std::shared_ptr&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse 11. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse 13. DB::executeQuery(std::__cxx11::basic_string, std::allocator > const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 2024.12.06 21:14:50.949243 [ 266 ] {6f725a64-2245-4b68-bc6e-39bed9c69e59} TCPHandler: Processed in 0.06584104 sec. 2024.12.06 21:14:50.949913 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:50.950079 [ 266 ] {a4d7b2fb-702e-4824-b7e2-58ae7599e505} executeQuery: (from [fd00:1122:3344:101::d]:58439) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) 2024.12.06 21:14:50.950367 [ 266 ] {a4d7b2fb-702e-4824-b7e2-58ae7599e505} executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:58439) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse 2. DB::Exception::Exception, std::allocator > >(int, FormatStringHelperImpl, std::allocator > >::type>, std::__cxx11::basic_string, std::allocator >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string, std::allocator > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse 10. std::__detail::_MakeUniq::__single_object std::make_unique&, std::shared_ptr&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse 11. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse 13. DB::executeQuery(std::__cxx11::basic_string, std::allocator > const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 2024.12.06 21:14:50.950483 [ 266 ] {a4d7b2fb-702e-4824-b7e2-58ae7599e505} TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse 2. DB::Exception::Exception, std::allocator > >(int, FormatStringHelperImpl, std::allocator > >::type>, std::__cxx11::basic_string, std::allocator >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string, std::allocator > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse 10. std::__detail::_MakeUniq::__single_object std::make_unique&, std::shared_ptr&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse 11. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse 13. DB::executeQuery(std::__cxx11::basic_string, std::allocator > const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 2024.12.06 21:14:50.950563 [ 266 ] {a4d7b2fb-702e-4824-b7e2-58ae7599e505} TCPHandler: Processed in 0.000769732 sec. 2024.12.06 21:14:50.950792 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:50.952026 [ 266 ] {36a4eb83-42b6-4bd8-a98d-4cc15cfaa5a6} executeQuery: (from [fd00:1122:3344:101::d]:58439) DROP DATABASE IF EXISTS oximeter (stage: Complete) 2024.12.06 21:14:50.952671 [ 266 ] {36a4eb83-42b6-4bd8-a98d-4cc15cfaa5a6} TCPHandler: Processed in 0.001927672 sec. 2024.12.06 21:14:50.952897 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:50.953026 [ 268 ] {c812709b-56da-4aa7-a299-58fb689d58d8} executeQuery: (from [fd00:1122:3344:101::d]:44123) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) 2024.12.06 21:14:50.953153 [ 268 ] {c812709b-56da-4aa7-a299-58fb689d58d8} ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* 2024.12.06 21:14:50.963585 [ 268 ] {c812709b-56da-4aa7-a299-58fb689d58d8} DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. 2024.12.06 21:14:50.963644 [ 268 ] {c812709b-56da-4aa7-a299-58fb689d58d8} TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.6702e-05 sec 2024.12.06 21:14:50.963660 [ 268 ] {c812709b-56da-4aa7-a299-58fb689d58d8} ReferentialDeps: No tables 2024.12.06 21:14:50.963673 [ 268 ] {c812709b-56da-4aa7-a299-58fb689d58d8} LoadingDeps: No tables 2024.12.06 21:14:50.963697 [ 268 ] {c812709b-56da-4aa7-a299-58fb689d58d8} DatabaseAtomic (oximeter): Starting up tables. 2024.12.06 21:14:50.963763 [ 268 ] {c812709b-56da-4aa7-a299-58fb689d58d8} TCPHandler: Processed in 0.01095133 sec. 2024.12.06 21:14:50.963965 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:50.964163 [ 266 ] {953cd99d-e64d-4519-aa61-f474b74767d4} executeQuery: (from [fd00:1122:3344:101::d]:58439) /* The version table contains metadata about the `oximeter` database */ CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) 2024.12.06 21:14:50.964236 [ 266 ] {953cd99d-e64d-4519-aa61-f474b74767d4} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version 2024.12.06 21:14:50.972910 [ 266 ] {953cd99d-e64d-4519-aa61-f474b74767d4} StoragePolicy (default): Storage policy default created, total volumes 1 2024.12.06 21:14:50.978985 [ 266 ] {953cd99d-e64d-4519-aa61-f474b74767d4} oximeter.version (b6c60fe8-ad03-4c2d-bbfb-b10ecb8c5b9b): Loading data parts 2024.12.06 21:14:50.979669 [ 266 ] {953cd99d-e64d-4519-aa61-f474b74767d4} oximeter.version (b6c60fe8-ad03-4c2d-bbfb-b10ecb8c5b9b): There are no data parts 2024.12.06 21:14:50.986106 [ 266 ] {953cd99d-e64d-4519-aa61-f474b74767d4} TCPHandler: Processed in 0.022208864 sec. 2024.12.06 21:14:50.986486 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:50.986816 [ 268 ] {a0a251d6-78e4-401e-99e3-846c263bd913} executeQuery: (from [fd00:1122:3344:101::d]:44123) /* The measurement tables contain all individual samples from each timeseries. * * Each table stores a single datum type, and otherwise contains nearly the same * structure. The primary sorting key is on the timeseries name, key, and then * timestamp, so that all timeseries from the same schema are grouped, followed * by all samples from the same timeseries. * * This reflects that one usually looks up the _key_ in one or more field table, * and then uses that to index quickly into the measurements tables. */ 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) 2024.12.06 21:14:50.986914 [ 268 ] {a0a251d6-78e4-401e-99e3-846c263bd913} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool 2024.12.06 21:14:50.999814 [ 268 ] {a0a251d6-78e4-401e-99e3-846c263bd913} oximeter.measurements_bool (5eadeaa4-10a4-4060-8869-584671cc1c31): Loading data parts 2024.12.06 21:14:51.000252 [ 248 ] {} AsynchronousMetrics: MemoryTracking: was 121.47 MiB, peak 121.47 MiB, free memory in arenas 0.00 B, will set to 133.48 MiB (RSS), difference: 12.02 MiB 2024.12.06 21:14:51.000353 [ 268 ] {a0a251d6-78e4-401e-99e3-846c263bd913} oximeter.measurements_bool (5eadeaa4-10a4-4060-8869-584671cc1c31): There are no data parts 2024.12.06 21:14:51.002498 [ 268 ] {a0a251d6-78e4-401e-99e3-846c263bd913} TCPHandler: Processed in 0.016163255 sec. 2024.12.06 21:14:51.002777 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.003026 [ 266 ] {751ac2fe-fce1-40f3-a340-b20ddd81798e} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.003092 [ 266 ] {751ac2fe-fce1-40f3-a340-b20ddd81798e} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 2024.12.06 21:14:51.006628 [ 266 ] {751ac2fe-fce1-40f3-a340-b20ddd81798e} oximeter.measurements_i8 (f8b21880-a024-4894-877e-792d7f6338cf): Loading data parts 2024.12.06 21:14:51.006895 [ 266 ] {751ac2fe-fce1-40f3-a340-b20ddd81798e} oximeter.measurements_i8 (f8b21880-a024-4894-877e-792d7f6338cf): There are no data parts 2024.12.06 21:14:51.009318 [ 266 ] {751ac2fe-fce1-40f3-a340-b20ddd81798e} TCPHandler: Processed in 0.006629929 sec. 2024.12.06 21:14:51.009525 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.009735 [ 268 ] {7ca25d2b-f6e9-453c-b909-e7181aec3dcb} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.009808 [ 268 ] {7ca25d2b-f6e9-453c-b909-e7181aec3dcb} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 2024.12.06 21:14:51.013405 [ 268 ] {7ca25d2b-f6e9-453c-b909-e7181aec3dcb} oximeter.measurements_u8 (da0f2a9f-852c-4ab0-b837-e1e5a3851f18): Loading data parts 2024.12.06 21:14:51.013635 [ 268 ] {7ca25d2b-f6e9-453c-b909-e7181aec3dcb} oximeter.measurements_u8 (da0f2a9f-852c-4ab0-b837-e1e5a3851f18): There are no data parts 2024.12.06 21:14:51.016394 [ 268 ] {7ca25d2b-f6e9-453c-b909-e7181aec3dcb} TCPHandler: Processed in 0.006928133 sec. 2024.12.06 21:14:51.016597 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.016812 [ 266 ] {664b73c8-6a00-4f33-a259-ce3d9a4099c3} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.016884 [ 266 ] {664b73c8-6a00-4f33-a259-ce3d9a4099c3} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 2024.12.06 21:14:51.020203 [ 266 ] {664b73c8-6a00-4f33-a259-ce3d9a4099c3} oximeter.measurements_i16 (3611ba76-02bc-4a55-aa33-6237b44c3c0c): Loading data parts 2024.12.06 21:14:51.020400 [ 266 ] {664b73c8-6a00-4f33-a259-ce3d9a4099c3} oximeter.measurements_i16 (3611ba76-02bc-4a55-aa33-6237b44c3c0c): There are no data parts 2024.12.06 21:14:51.022901 [ 266 ] {664b73c8-6a00-4f33-a259-ce3d9a4099c3} TCPHandler: Processed in 0.006355625 sec. 2024.12.06 21:14:51.023117 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.023310 [ 268 ] {f78d8d7a-b7c9-4826-8e6f-c8c2e353de6c} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.023377 [ 268 ] {f78d8d7a-b7c9-4826-8e6f-c8c2e353de6c} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 2024.12.06 21:14:51.027054 [ 268 ] {f78d8d7a-b7c9-4826-8e6f-c8c2e353de6c} oximeter.measurements_u16 (7f31df56-121b-4641-93bc-5d98b473d8a9): Loading data parts 2024.12.06 21:14:51.027375 [ 268 ] {f78d8d7a-b7c9-4826-8e6f-c8c2e353de6c} oximeter.measurements_u16 (7f31df56-121b-4641-93bc-5d98b473d8a9): There are no data parts 2024.12.06 21:14:51.029653 [ 268 ] {f78d8d7a-b7c9-4826-8e6f-c8c2e353de6c} TCPHandler: Processed in 0.006589179 sec. 2024.12.06 21:14:51.029861 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.030388 [ 266 ] {f632fa2c-9326-45fe-b896-284bdd677ee3} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.030450 [ 266 ] {f632fa2c-9326-45fe-b896-284bdd677ee3} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 2024.12.06 21:14:51.033754 [ 266 ] {f632fa2c-9326-45fe-b896-284bdd677ee3} oximeter.measurements_i32 (75e487b5-fec3-45d6-803e-32f627b88b33): Loading data parts 2024.12.06 21:14:51.033960 [ 266 ] {f632fa2c-9326-45fe-b896-284bdd677ee3} oximeter.measurements_i32 (75e487b5-fec3-45d6-803e-32f627b88b33): There are no data parts 2024.12.06 21:14:51.036344 [ 266 ] {f632fa2c-9326-45fe-b896-284bdd677ee3} TCPHandler: Processed in 0.006549117 sec. 2024.12.06 21:14:51.036567 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.036803 [ 268 ] {e35c9857-b719-4f55-9a56-80f187ce2d41} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.036886 [ 268 ] {e35c9857-b719-4f55-9a56-80f187ce2d41} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 2024.12.06 21:14:51.040563 [ 268 ] {e35c9857-b719-4f55-9a56-80f187ce2d41} oximeter.measurements_u32 (a5d5e565-43c8-4135-be55-b40e6f4b4c1e): Loading data parts 2024.12.06 21:14:51.040789 [ 268 ] {e35c9857-b719-4f55-9a56-80f187ce2d41} oximeter.measurements_u32 (a5d5e565-43c8-4135-be55-b40e6f4b4c1e): There are no data parts 2024.12.06 21:14:51.043212 [ 268 ] {e35c9857-b719-4f55-9a56-80f187ce2d41} TCPHandler: Processed in 0.00670791 sec. 2024.12.06 21:14:51.043426 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.043650 [ 266 ] {e6138992-def9-47be-9237-163c3905810d} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.043714 [ 266 ] {e6138992-def9-47be-9237-163c3905810d} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 2024.12.06 21:14:51.049354 [ 266 ] {e6138992-def9-47be-9237-163c3905810d} oximeter.measurements_i64 (ad0cb5b4-815c-43d9-9981-2803ac396f43): Loading data parts 2024.12.06 21:14:51.049556 [ 266 ] {e6138992-def9-47be-9237-163c3905810d} oximeter.measurements_i64 (ad0cb5b4-815c-43d9-9981-2803ac396f43): There are no data parts 2024.12.06 21:14:51.053900 [ 266 ] {e6138992-def9-47be-9237-163c3905810d} TCPHandler: Processed in 0.010538483 sec. 2024.12.06 21:14:51.054118 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.054317 [ 268 ] {8ea44e89-08c3-4f41-8b9c-1fc32adffa9e} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.054383 [ 268 ] {8ea44e89-08c3-4f41-8b9c-1fc32adffa9e} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 2024.12.06 21:14:51.056343 [ 268 ] {8ea44e89-08c3-4f41-8b9c-1fc32adffa9e} oximeter.measurements_u64 (52d0dc58-fe48-49e5-a79b-29e4382b7021): Loading data parts 2024.12.06 21:14:51.056560 [ 268 ] {8ea44e89-08c3-4f41-8b9c-1fc32adffa9e} oximeter.measurements_u64 (52d0dc58-fe48-49e5-a79b-29e4382b7021): There are no data parts 2024.12.06 21:14:51.060916 [ 268 ] {8ea44e89-08c3-4f41-8b9c-1fc32adffa9e} TCPHandler: Processed in 0.006859112 sec. 2024.12.06 21:14:51.061126 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.061403 [ 266 ] {46191b4b-5e19-4a88-a259-f4b2cbdb2d55} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.061481 [ 266 ] {46191b4b-5e19-4a88-a259-f4b2cbdb2d55} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 2024.12.06 21:14:51.068425 [ 266 ] {46191b4b-5e19-4a88-a259-f4b2cbdb2d55} oximeter.measurements_f32 (8635d9cc-99e1-40e4-9d9a-731a40a72e29): Loading data parts 2024.12.06 21:14:51.068620 [ 266 ] {46191b4b-5e19-4a88-a259-f4b2cbdb2d55} oximeter.measurements_f32 (8635d9cc-99e1-40e4-9d9a-731a40a72e29): There are no data parts 2024.12.06 21:14:51.071159 [ 266 ] {46191b4b-5e19-4a88-a259-f4b2cbdb2d55} TCPHandler: Processed in 0.010096255 sec. 2024.12.06 21:14:51.071390 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.071582 [ 268 ] {d182fb73-9adc-45fb-81d6-76f0c3c03277} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.071648 [ 268 ] {d182fb73-9adc-45fb-81d6-76f0c3c03277} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 2024.12.06 21:14:51.075324 [ 268 ] {d182fb73-9adc-45fb-81d6-76f0c3c03277} oximeter.measurements_f64 (d71c17d4-58f9-4b4c-a503-e16c262b229b): Loading data parts 2024.12.06 21:14:51.075532 [ 268 ] {d182fb73-9adc-45fb-81d6-76f0c3c03277} oximeter.measurements_f64 (d71c17d4-58f9-4b4c-a503-e16c262b229b): There are no data parts 2024.12.06 21:14:51.078186 [ 268 ] {d182fb73-9adc-45fb-81d6-76f0c3c03277} TCPHandler: Processed in 0.006853622 sec. 2024.12.06 21:14:51.078381 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.078597 [ 266 ] {3c442e4d-850d-4070-96aa-d4867871c3a5} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.078661 [ 266 ] {3c442e4d-850d-4070-96aa-d4867871c3a5} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string 2024.12.06 21:14:51.082178 [ 266 ] {3c442e4d-850d-4070-96aa-d4867871c3a5} oximeter.measurements_string (1cbceb75-1ab9-4002-a527-473200e03196): Loading data parts 2024.12.06 21:14:51.082344 [ 266 ] {3c442e4d-850d-4070-96aa-d4867871c3a5} oximeter.measurements_string (1cbceb75-1ab9-4002-a527-473200e03196): There are no data parts 2024.12.06 21:14:51.084947 [ 266 ] {3c442e4d-850d-4070-96aa-d4867871c3a5} TCPHandler: Processed in 0.006619099 sec. 2024.12.06 21:14:51.085168 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.085395 [ 268 ] {4dccb1af-c785-4fbe-ad64-b166c4176cb1} executeQuery: (from [fd00:1122:3344:101::d]:44123) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* * NOTE: Right now we can't unambiguously record a nullable byte array. * Arrays cannot be nested in `Nullable()` types, and encoding the array as * a string isn't palatable for a few reasons. * See: https://github.com/oxidecomputer/omicron/issues/4551 for more * details. */ datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.12.06 21:14:51.085478 [ 268 ] {4dccb1af-c785-4fbe-ad64-b166c4176cb1} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes 2024.12.06 21:14:51.091028 [ 268 ] {4dccb1af-c785-4fbe-ad64-b166c4176cb1} oximeter.measurements_bytes (f6d8b107-5217-48eb-8757-94b1b80e8536): Loading data parts 2024.12.06 21:14:51.091305 [ 268 ] {4dccb1af-c785-4fbe-ad64-b166c4176cb1} oximeter.measurements_bytes (f6d8b107-5217-48eb-8757-94b1b80e8536): There are no data parts 2024.12.06 21:14:51.095596 [ 268 ] {4dccb1af-c785-4fbe-ad64-b166c4176cb1} TCPHandler: Processed in 0.010494162 sec. 2024.12.06 21:14:51.095812 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.096110 [ 266 ] {372e6c71-7c76-4417-95f8-461600fa75fb} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.096201 [ 266 ] {372e6c71-7c76-4417-95f8-461600fa75fb} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 2024.12.06 21:14:51.098235 [ 266 ] {372e6c71-7c76-4417-95f8-461600fa75fb} oximeter.measurements_cumulativei64 (8c245486-e834-4604-807b-8d91f2f7257d): Loading data parts 2024.12.06 21:14:51.098417 [ 266 ] {372e6c71-7c76-4417-95f8-461600fa75fb} oximeter.measurements_cumulativei64 (8c245486-e834-4604-807b-8d91f2f7257d): There are no data parts 2024.12.06 21:14:51.102433 [ 266 ] {372e6c71-7c76-4417-95f8-461600fa75fb} TCPHandler: Processed in 0.006686139 sec. 2024.12.06 21:14:51.102661 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.102909 [ 268 ] {8c4d0984-735f-472a-86a0-3ee79b9d267d} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.102997 [ 268 ] {8c4d0984-735f-472a-86a0-3ee79b9d267d} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 2024.12.06 21:14:51.105060 [ 268 ] {8c4d0984-735f-472a-86a0-3ee79b9d267d} oximeter.measurements_cumulativeu64 (d2f9fa43-3117-441f-8917-87b0b2b04d9e): Loading data parts 2024.12.06 21:14:51.105254 [ 268 ] {8c4d0984-735f-472a-86a0-3ee79b9d267d} oximeter.measurements_cumulativeu64 (d2f9fa43-3117-441f-8917-87b0b2b04d9e): There are no data parts 2024.12.06 21:14:51.109269 [ 268 ] {8c4d0984-735f-472a-86a0-3ee79b9d267d} TCPHandler: Processed in 0.006672539 sec. 2024.12.06 21:14:51.109477 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.109700 [ 266 ] {c5710a7a-d6f5-47da-84ae-64d61ffcb764} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.109764 [ 266 ] {c5710a7a-d6f5-47da-84ae-64d61ffcb764} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 2024.12.06 21:14:51.111888 [ 266 ] {c5710a7a-d6f5-47da-84ae-64d61ffcb764} oximeter.measurements_cumulativef32 (e1a7b06f-795b-4796-8610-11530e9b7f73): Loading data parts 2024.12.06 21:14:51.112072 [ 266 ] {c5710a7a-d6f5-47da-84ae-64d61ffcb764} oximeter.measurements_cumulativef32 (e1a7b06f-795b-4796-8610-11530e9b7f73): There are no data parts 2024.12.06 21:14:51.116139 [ 266 ] {c5710a7a-d6f5-47da-84ae-64d61ffcb764} TCPHandler: Processed in 0.00671265 sec. 2024.12.06 21:14:51.116366 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.116569 [ 268 ] {f51e77c6-1aee-41ea-bf62-17ceb7c3a607} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.116639 [ 268 ] {f51e77c6-1aee-41ea-bf62-17ceb7c3a607} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 2024.12.06 21:14:51.118704 [ 268 ] {f51e77c6-1aee-41ea-bf62-17ceb7c3a607} oximeter.measurements_cumulativef64 (9b5f01fa-f4e7-4d65-834c-5ee704f74654): Loading data parts 2024.12.06 21:14:51.118869 [ 268 ] {f51e77c6-1aee-41ea-bf62-17ceb7c3a607} oximeter.measurements_cumulativef64 (9b5f01fa-f4e7-4d65-834c-5ee704f74654): There are no data parts 2024.12.06 21:14:51.123048 [ 268 ] {f51e77c6-1aee-41ea-bf62-17ceb7c3a607} TCPHandler: Processed in 0.00673656 sec. 2024.12.06 21:14:51.123287 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.123715 [ 266 ] {9d07652e-acc3-4aa0-ad6e-ce76b9ef7385} executeQuery: (from [fd00:1122:3344:101::d]:58439) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* * NOTE: Array types cannot be Nullable, see * https://clickhouse.com/docs/en/sql-reference/data-types/nullable * for more details. * * This means we need to use empty arrays to indicate a missing value. This * is unfortunate, and at this point relies on the fact that an * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need * to figure out another way to represent missing samples here. */ 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) 2024.12.06 21:14:51.123843 [ 266 ] {9d07652e-acc3-4aa0-ad6e-ce76b9ef7385} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 2024.12.06 21:14:51.129189 [ 266 ] {9d07652e-acc3-4aa0-ad6e-ce76b9ef7385} oximeter.measurements_histogrami8 (10e72da4-b107-420a-b315-a680399cf817): Loading data parts 2024.12.06 21:14:51.129399 [ 266 ] {9d07652e-acc3-4aa0-ad6e-ce76b9ef7385} oximeter.measurements_histogrami8 (10e72da4-b107-420a-b315-a680399cf817): There are no data parts 2024.12.06 21:14:51.135565 [ 266 ] {9d07652e-acc3-4aa0-ad6e-ce76b9ef7385} TCPHandler: Processed in 0.012331563 sec. 2024.12.06 21:14:51.135804 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.136132 [ 268 ] {744d5d1e-e50a-45e9-aa15-91b07d66eec2} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.136231 [ 268 ] {744d5d1e-e50a-45e9-aa15-91b07d66eec2} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 2024.12.06 21:14:51.142375 [ 268 ] {744d5d1e-e50a-45e9-aa15-91b07d66eec2} oximeter.measurements_histogramu8 (c050f00e-a651-45fa-84c5-1ee6165872d4): Loading data parts 2024.12.06 21:14:51.142584 [ 268 ] {744d5d1e-e50a-45e9-aa15-91b07d66eec2} oximeter.measurements_histogramu8 (c050f00e-a651-45fa-84c5-1ee6165872d4): There are no data parts 2024.12.06 21:14:51.148989 [ 268 ] {744d5d1e-e50a-45e9-aa15-91b07d66eec2} TCPHandler: Processed in 0.013255807 sec. 2024.12.06 21:14:51.149204 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.149619 [ 266 ] {712ae69c-367b-4eb2-98d2-b3f16fd454ed} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.149719 [ 266 ] {712ae69c-367b-4eb2-98d2-b3f16fd454ed} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 2024.12.06 21:14:51.156267 [ 266 ] {712ae69c-367b-4eb2-98d2-b3f16fd454ed} oximeter.measurements_histogrami16 (f726a387-9580-44b2-8f3d-037db6d0e642): Loading data parts 2024.12.06 21:14:51.156473 [ 266 ] {712ae69c-367b-4eb2-98d2-b3f16fd454ed} oximeter.measurements_histogrami16 (f726a387-9580-44b2-8f3d-037db6d0e642): There are no data parts 2024.12.06 21:14:51.162421 [ 266 ] {712ae69c-367b-4eb2-98d2-b3f16fd454ed} TCPHandler: Processed in 0.013283058 sec. 2024.12.06 21:14:51.162642 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.162965 [ 268 ] {b11260a6-9d06-4419-8689-0f6222f4f5b7} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.163061 [ 268 ] {b11260a6-9d06-4419-8689-0f6222f4f5b7} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 2024.12.06 21:14:51.168587 [ 268 ] {b11260a6-9d06-4419-8689-0f6222f4f5b7} oximeter.measurements_histogramu16 (527be356-2aec-44c4-b942-056c29c0a48b): Loading data parts 2024.12.06 21:14:51.168818 [ 268 ] {b11260a6-9d06-4419-8689-0f6222f4f5b7} oximeter.measurements_histogramu16 (527be356-2aec-44c4-b942-056c29c0a48b): There are no data parts 2024.12.06 21:14:51.171333 [ 268 ] {b11260a6-9d06-4419-8689-0f6222f4f5b7} TCPHandler: Processed in 0.008757793 sec. 2024.12.06 21:14:51.171547 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.171901 [ 266 ] {92ff6395-d73c-4f80-8ad2-1f98077748b2} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.171993 [ 266 ] {92ff6395-d73c-4f80-8ad2-1f98077748b2} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 2024.12.06 21:14:51.177043 [ 266 ] {92ff6395-d73c-4f80-8ad2-1f98077748b2} oximeter.measurements_histogrami32 (e6a57afe-64f4-4362-8539-824725f392cf): Loading data parts 2024.12.06 21:14:51.177220 [ 266 ] {92ff6395-d73c-4f80-8ad2-1f98077748b2} oximeter.measurements_histogrami32 (e6a57afe-64f4-4362-8539-824725f392cf): There are no data parts 2024.12.06 21:14:51.181500 [ 266 ] {92ff6395-d73c-4f80-8ad2-1f98077748b2} TCPHandler: Processed in 0.010018714 sec. 2024.12.06 21:14:51.181699 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.181968 [ 268 ] {e31b3fc2-fc50-4c25-9018-ba3fff497669} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.182053 [ 268 ] {e31b3fc2-fc50-4c25-9018-ba3fff497669} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 2024.12.06 21:14:51.184436 [ 268 ] {e31b3fc2-fc50-4c25-9018-ba3fff497669} oximeter.measurements_histogramu32 (b5124c25-a425-4cdf-bebe-933d996d9592): Loading data parts 2024.12.06 21:14:51.184650 [ 268 ] {e31b3fc2-fc50-4c25-9018-ba3fff497669} oximeter.measurements_histogramu32 (b5124c25-a425-4cdf-bebe-933d996d9592): There are no data parts 2024.12.06 21:14:51.188908 [ 268 ] {e31b3fc2-fc50-4c25-9018-ba3fff497669} TCPHandler: Processed in 0.007262949 sec. 2024.12.06 21:14:51.189105 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.189396 [ 266 ] {0fa162c9-d2c0-40bb-a67c-db6b855b7254} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.189471 [ 266 ] {0fa162c9-d2c0-40bb-a67c-db6b855b7254} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 2024.12.06 21:14:51.191667 [ 266 ] {0fa162c9-d2c0-40bb-a67c-db6b855b7254} oximeter.measurements_histogrami64 (557cd8b7-e420-4958-aa62-8b726679181c): Loading data parts 2024.12.06 21:14:51.191851 [ 266 ] {0fa162c9-d2c0-40bb-a67c-db6b855b7254} oximeter.measurements_histogrami64 (557cd8b7-e420-4958-aa62-8b726679181c): There are no data parts 2024.12.06 21:14:51.195825 [ 266 ] {0fa162c9-d2c0-40bb-a67c-db6b855b7254} TCPHandler: Processed in 0.006772061 sec. 2024.12.06 21:14:51.196049 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.196319 [ 268 ] {37682c23-210f-4783-b9e6-82a61429d667} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.196401 [ 268 ] {37682c23-210f-4783-b9e6-82a61429d667} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 2024.12.06 21:14:51.198587 [ 268 ] {37682c23-210f-4783-b9e6-82a61429d667} oximeter.measurements_histogramu64 (5fcb42a8-362e-48b3-944e-5f72ad7166c8): Loading data parts 2024.12.06 21:14:51.198759 [ 268 ] {37682c23-210f-4783-b9e6-82a61429d667} oximeter.measurements_histogramu64 (5fcb42a8-362e-48b3-944e-5f72ad7166c8): There are no data parts 2024.12.06 21:14:51.202725 [ 268 ] {37682c23-210f-4783-b9e6-82a61429d667} TCPHandler: Processed in 0.00673026 sec. 2024.12.06 21:14:51.202929 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.203274 [ 266 ] {5027e26c-2ef5-4205-80cf-4013bcc96f0e} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.203351 [ 266 ] {5027e26c-2ef5-4205-80cf-4013bcc96f0e} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 2024.12.06 21:14:51.205652 [ 266 ] {5027e26c-2ef5-4205-80cf-4013bcc96f0e} oximeter.measurements_histogramf32 (7e92fb42-47a8-416e-9854-c0ab0d8f83b3): Loading data parts 2024.12.06 21:14:51.205817 [ 266 ] {5027e26c-2ef5-4205-80cf-4013bcc96f0e} oximeter.measurements_histogramf32 (7e92fb42-47a8-416e-9854-c0ab0d8f83b3): There are no data parts 2024.12.06 21:14:51.209630 [ 266 ] {5027e26c-2ef5-4205-80cf-4013bcc96f0e} TCPHandler: Processed in 0.006766202 sec. 2024.12.06 21:14:51.209846 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.210117 [ 268 ] {3a082c14-e5e8-4a96-b600-ddcd5a5ad4a2} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.210202 [ 268 ] {3a082c14-e5e8-4a96-b600-ddcd5a5ad4a2} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 2024.12.06 21:14:51.212473 [ 268 ] {3a082c14-e5e8-4a96-b600-ddcd5a5ad4a2} oximeter.measurements_histogramf64 (42a4ae53-e2dc-4c16-a219-c5ea748fb4dd): Loading data parts 2024.12.06 21:14:51.212669 [ 268 ] {3a082c14-e5e8-4a96-b600-ddcd5a5ad4a2} oximeter.measurements_histogramf64 (42a4ae53-e2dc-4c16-a219-c5ea748fb4dd): There are no data parts 2024.12.06 21:14:51.216412 [ 268 ] {3a082c14-e5e8-4a96-b600-ddcd5a5ad4a2} TCPHandler: Processed in 0.006619529 sec. 2024.12.06 21:14:51.216606 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.216902 [ 266 ] {2d02d8fe-38fa-4469-bd84-ec20df567703} executeQuery: (from [fd00:1122:3344:101::d]:58439) /* The field tables store named dimensions of each timeseries. * * As with the measurement tables, there is one field table for each field data * type. Fields are deduplicated by using the "replacing merge tree", though * this behavior **must not** be relied upon for query correctness. * * The index for the fields differs from the measurements, however. Rows are * sorted by timeseries name, then field name, field value, and finally * timeseries key. This reflects the most common pattern for looking them up: * by field name and possibly value, within a timeseries. The resulting keys are * usually then used to look up measurements. * * NOTE: We may want to consider a secondary index on these tables, sorting by * timeseries name and then key, since it would improve lookups where one * already has the key. Realistically though, these tables are quite small and * so performance benefits will be low in absolute terms. * * TTL: We use a materialized column to expire old field table records. This * column is generated automatically by the database whenever a new row is * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` * query. Since these tables are `ReplacingMergeTree`s, that means the last * record will remain during a deduplication, which will have the last * timestamp. ClickHouse will then expire old data for us, similar to the * measurement tables. */ 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) 2024.12.06 21:14:51.216997 [ 266 ] {2d02d8fe-38fa-4469-bd84-ec20df567703} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool 2024.12.06 21:14:51.219534 [ 266 ] {2d02d8fe-38fa-4469-bd84-ec20df567703} oximeter.fields_bool (f7b1eb06-a847-4af5-8224-3f980af8aff2): Loading data parts 2024.12.06 21:14:51.219694 [ 266 ] {2d02d8fe-38fa-4469-bd84-ec20df567703} oximeter.fields_bool (f7b1eb06-a847-4af5-8224-3f980af8aff2): There are no data parts 2024.12.06 21:14:51.223267 [ 266 ] {2d02d8fe-38fa-4469-bd84-ec20df567703} TCPHandler: Processed in 0.00672526 sec. 2024.12.06 21:14:51.223529 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.223766 [ 268 ] {0985ec82-bc4f-417b-8879-d097ad60f61f} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.223849 [ 268 ] {0985ec82-bc4f-417b-8879-d097ad60f61f} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 2024.12.06 21:14:51.225896 [ 268 ] {0985ec82-bc4f-417b-8879-d097ad60f61f} oximeter.fields_i8 (3de05a82-b2dc-4671-bd9f-632544df5bd5): Loading data parts 2024.12.06 21:14:51.226093 [ 268 ] {0985ec82-bc4f-417b-8879-d097ad60f61f} oximeter.fields_i8 (3de05a82-b2dc-4671-bd9f-632544df5bd5): There are no data parts 2024.12.06 21:14:51.230069 [ 268 ] {0985ec82-bc4f-417b-8879-d097ad60f61f} TCPHandler: Processed in 0.006604068 sec. 2024.12.06 21:14:51.230284 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.230506 [ 266 ] {06cc30ce-c565-47f4-b9a0-2f872c1ea026} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.230566 [ 266 ] {06cc30ce-c565-47f4-b9a0-2f872c1ea026} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 2024.12.06 21:14:51.232590 [ 266 ] {06cc30ce-c565-47f4-b9a0-2f872c1ea026} oximeter.fields_u8 (d48af4ee-5a07-45f2-a6b4-a4d5057deecb): Loading data parts 2024.12.06 21:14:51.232757 [ 266 ] {06cc30ce-c565-47f4-b9a0-2f872c1ea026} oximeter.fields_u8 (d48af4ee-5a07-45f2-a6b4-a4d5057deecb): There are no data parts 2024.12.06 21:14:51.236807 [ 266 ] {06cc30ce-c565-47f4-b9a0-2f872c1ea026} TCPHandler: Processed in 0.006579318 sec. 2024.12.06 21:14:51.237038 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.237230 [ 268 ] {1d7c33c7-31b3-4a92-9b26-240375b6745f} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.237300 [ 268 ] {1d7c33c7-31b3-4a92-9b26-240375b6745f} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 2024.12.06 21:14:51.239322 [ 268 ] {1d7c33c7-31b3-4a92-9b26-240375b6745f} oximeter.fields_i16 (a44b4af4-6219-459d-93f0-64c7c03b9fbf): Loading data parts 2024.12.06 21:14:51.239553 [ 268 ] {1d7c33c7-31b3-4a92-9b26-240375b6745f} oximeter.fields_i16 (a44b4af4-6219-459d-93f0-64c7c03b9fbf): There are no data parts 2024.12.06 21:14:51.243605 [ 268 ] {1d7c33c7-31b3-4a92-9b26-240375b6745f} TCPHandler: Processed in 0.006620309 sec. 2024.12.06 21:14:51.243796 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.244013 [ 266 ] {9559bd8e-fd52-4801-b289-885145a6a755} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.244087 [ 266 ] {9559bd8e-fd52-4801-b289-885145a6a755} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 2024.12.06 21:14:51.246095 [ 266 ] {9559bd8e-fd52-4801-b289-885145a6a755} oximeter.fields_u16 (58cabf91-3a29-4a77-b4ae-7d520d87d5bf): Loading data parts 2024.12.06 21:14:51.246287 [ 266 ] {9559bd8e-fd52-4801-b289-885145a6a755} oximeter.fields_u16 (58cabf91-3a29-4a77-b4ae-7d520d87d5bf): There are no data parts 2024.12.06 21:14:51.248264 [ 277 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:60424 2024.12.06 21:14:51.249264 [ 277 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:51.249299 [ 277 ] {} TCP-Session: 396b2250-27c8-4e76-a011-4a62534d2c9f Authenticating user 'default' from [fd00:1122:3344:101::c]:60424 2024.12.06 21:14:51.249329 [ 277 ] {} TCP-Session: 396b2250-27c8-4e76-a011-4a62534d2c9f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.249378 [ 277 ] {} TCP-Session: 396b2250-27c8-4e76-a011-4a62534d2c9f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.249446 [ 277 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.12.06 21:14:51.249474 [ 277 ] {} 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 2024.12.06 21:14:51.249521 [ 277 ] {} 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 2024.12.06 21:14:51.249904 [ 278 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:58640 2024.12.06 21:14:51.250081 [ 278 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:51.250079 [ 279 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:40927 2024.12.06 21:14:51.250114 [ 278 ] {} TCP-Session: 65497183-75af-4461-ad51-b323d829db69 Authenticating user 'default' from [fd00:1122:3344:101::c]:58640 2024.12.06 21:14:51.250216 [ 280 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:61006 2024.12.06 21:14:51.250376 [ 278 ] {} TCP-Session: 65497183-75af-4461-ad51-b323d829db69 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.250380 [ 279 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:51.250447 [ 278 ] {} TCP-Session: 65497183-75af-4461-ad51-b323d829db69 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.250378 [ 281 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:49257 2024.12.06 21:14:51.250595 [ 282 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:50000 2024.12.06 21:14:51.250672 [ 279 ] {} TCP-Session: 4adfdd53-b897-4d5c-92aa-b17068923f13 Authenticating user 'default' from [fd00:1122:3344:101::c]:40927 2024.12.06 21:14:51.250698 [ 280 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:51.251057 [ 279 ] {} TCP-Session: 4adfdd53-b897-4d5c-92aa-b17068923f13 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.251155 [ 283 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:61857 2024.12.06 21:14:51.251200 [ 279 ] {} TCP-Session: 4adfdd53-b897-4d5c-92aa-b17068923f13 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.251243 [ 284 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:65104 2024.12.06 21:14:51.251087 [ 281 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:51.251305 [ 266 ] {9559bd8e-fd52-4801-b289-885145a6a755} TCPHandler: Processed in 0.007549484 sec. 2024.12.06 21:14:51.251470 [ 280 ] {} TCP-Session: 4c1dfd62-0257-4fe6-a925-95af93e5d065 Authenticating user 'default' from [fd00:1122:3344:101::c]:61006 2024.12.06 21:14:51.251473 [ 281 ] {} TCP-Session: e11526ae-4312-476e-bea7-414ad3557419 Authenticating user 'default' from [fd00:1122:3344:101::c]:49257 2024.12.06 21:14:51.251637 [ 280 ] {} TCP-Session: 4c1dfd62-0257-4fe6-a925-95af93e5d065 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.251681 [ 281 ] {} TCP-Session: e11526ae-4312-476e-bea7-414ad3557419 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.251729 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.251749 [ 280 ] {} TCP-Session: 4c1dfd62-0257-4fe6-a925-95af93e5d065 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.251757 [ 281 ] {} TCP-Session: e11526ae-4312-476e-bea7-414ad3557419 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.252032 [ 268 ] {4cb23a3b-b493-4580-b9e9-56f9197d7e15} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.252135 [ 268 ] {4cb23a3b-b493-4580-b9e9-56f9197d7e15} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 2024.12.06 21:14:51.256011 [ 283 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:51.256098 [ 283 ] {} TCP-Session: 13716185-ed3c-4170-a7e7-43d0ae3d196d Authenticating user 'default' from [fd00:1122:3344:101::c]:61857 2024.12.06 21:14:51.256117 [ 283 ] {} TCP-Session: 13716185-ed3c-4170-a7e7-43d0ae3d196d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.256131 [ 283 ] {} TCP-Session: 13716185-ed3c-4170-a7e7-43d0ae3d196d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.256139 [ 284 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:51.256212 [ 284 ] {} TCP-Session: b9256c18-f821-4abd-b47d-61c39ef0a4dc Authenticating user 'default' from [fd00:1122:3344:101::c]:65104 2024.12.06 21:14:51.256238 [ 284 ] {} TCP-Session: b9256c18-f821-4abd-b47d-61c39ef0a4dc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.256306 [ 284 ] {} TCP-Session: b9256c18-f821-4abd-b47d-61c39ef0a4dc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.256782 [ 282 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:51.256826 [ 282 ] {} TCP-Session: d8d4633f-9886-4c13-b44d-dd0325da94ba Authenticating user 'default' from [fd00:1122:3344:101::c]:50000 2024.12.06 21:14:51.256874 [ 282 ] {} TCP-Session: d8d4633f-9886-4c13-b44d-dd0325da94ba Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.256908 [ 282 ] {} TCP-Session: d8d4633f-9886-4c13-b44d-dd0325da94ba Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.256937 [ 268 ] {4cb23a3b-b493-4580-b9e9-56f9197d7e15} oximeter.fields_i32 (a2fe09c4-6511-4fab-bdd9-8558e3e3bac7): Loading data parts 2024.12.06 21:14:51.257241 [ 268 ] {4cb23a3b-b493-4580-b9e9-56f9197d7e15} oximeter.fields_i32 (a2fe09c4-6511-4fab-bdd9-8558e3e3bac7): There are no data parts 2024.12.06 21:14:51.259729 [ 268 ] {4cb23a3b-b493-4580-b9e9-56f9197d7e15} TCPHandler: Processed in 0.008119043 sec. 2024.12.06 21:14:51.259958 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.260186 [ 266 ] {e79119ac-4eda-40b1-8527-a64d7c1ea91b} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.260252 [ 266 ] {e79119ac-4eda-40b1-8527-a64d7c1ea91b} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 2024.12.06 21:14:51.263788 [ 266 ] {e79119ac-4eda-40b1-8527-a64d7c1ea91b} oximeter.fields_u32 (c6851621-d47c-4851-96c4-4b60094043dd): Loading data parts 2024.12.06 21:14:51.264011 [ 266 ] {e79119ac-4eda-40b1-8527-a64d7c1ea91b} oximeter.fields_u32 (c6851621-d47c-4851-96c4-4b60094043dd): There are no data parts 2024.12.06 21:14:51.266523 [ 266 ] {e79119ac-4eda-40b1-8527-a64d7c1ea91b} TCPHandler: Processed in 0.006639879 sec. 2024.12.06 21:14:51.266777 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.267026 [ 268 ] {a9a8b66a-214e-4651-993c-4f5f9e44cd88} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.267143 [ 268 ] {a9a8b66a-214e-4651-993c-4f5f9e44cd88} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 2024.12.06 21:14:51.270608 [ 268 ] {a9a8b66a-214e-4651-993c-4f5f9e44cd88} oximeter.fields_i64 (c3601aee-2048-4326-a789-e1c21a43eba9): Loading data parts 2024.12.06 21:14:51.270842 [ 268 ] {a9a8b66a-214e-4651-993c-4f5f9e44cd88} oximeter.fields_i64 (c3601aee-2048-4326-a789-e1c21a43eba9): There are no data parts 2024.12.06 21:14:51.273301 [ 268 ] {a9a8b66a-214e-4651-993c-4f5f9e44cd88} TCPHandler: Processed in 0.006584058 sec. 2024.12.06 21:14:51.273553 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.273797 [ 266 ] {071c9d72-3b7b-4083-90cd-b8730772a040} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.273849 [ 266 ] {071c9d72-3b7b-4083-90cd-b8730772a040} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 2024.12.06 21:14:51.277513 [ 266 ] {071c9d72-3b7b-4083-90cd-b8730772a040} oximeter.fields_u64 (22a56fe4-0225-4925-a9bd-b77d8f68f520): Loading data parts 2024.12.06 21:14:51.277710 [ 266 ] {071c9d72-3b7b-4083-90cd-b8730772a040} oximeter.fields_u64 (22a56fe4-0225-4925-a9bd-b77d8f68f520): There are no data parts 2024.12.06 21:14:51.280334 [ 266 ] {071c9d72-3b7b-4083-90cd-b8730772a040} TCPHandler: Processed in 0.006857472 sec. 2024.12.06 21:14:51.280589 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.280826 [ 268 ] {b255e295-bad3-49e5-89e3-7549bf203ebc} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.280924 [ 268 ] {b255e295-bad3-49e5-89e3-7549bf203ebc} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr 2024.12.06 21:14:51.284639 [ 268 ] {b255e295-bad3-49e5-89e3-7549bf203ebc} oximeter.fields_ipaddr (d35e1587-c56d-41ab-b0ba-a91f733cdaa9): Loading data parts 2024.12.06 21:14:51.284889 [ 268 ] {b255e295-bad3-49e5-89e3-7549bf203ebc} oximeter.fields_ipaddr (d35e1587-c56d-41ab-b0ba-a91f733cdaa9): There are no data parts 2024.12.06 21:14:51.287901 [ 268 ] {b255e295-bad3-49e5-89e3-7549bf203ebc} TCPHandler: Processed in 0.007376721 sec. 2024.12.06 21:14:51.288097 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.288340 [ 266 ] {415e2440-ae20-495f-b4da-ffdf68f30a94} executeQuery: (from [fd00:1122:3344:101::d]:58439) 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) 2024.12.06 21:14:51.288423 [ 266 ] {415e2440-ae20-495f-b4da-ffdf68f30a94} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string 2024.12.06 21:14:51.294465 [ 266 ] {415e2440-ae20-495f-b4da-ffdf68f30a94} oximeter.fields_string (343984b9-b893-4af4-9045-9f912231ba92): Loading data parts 2024.12.06 21:14:51.294665 [ 266 ] {415e2440-ae20-495f-b4da-ffdf68f30a94} oximeter.fields_string (343984b9-b893-4af4-9045-9f912231ba92): There are no data parts 2024.12.06 21:14:51.299364 [ 266 ] {415e2440-ae20-495f-b4da-ffdf68f30a94} TCPHandler: Processed in 0.011322465 sec. 2024.12.06 21:14:51.299626 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.299871 [ 268 ] {f8586239-0f51-4a20-b433-c35463e5c220} executeQuery: (from [fd00:1122:3344:101::d]:44123) 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) 2024.12.06 21:14:51.299959 [ 268 ] {f8586239-0f51-4a20-b433-c35463e5c220} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid 2024.12.06 21:14:51.306630 [ 268 ] {f8586239-0f51-4a20-b433-c35463e5c220} oximeter.fields_uuid (956c3398-09af-4831-9dc5-03d47a327612): Loading data parts 2024.12.06 21:14:51.306841 [ 268 ] {f8586239-0f51-4a20-b433-c35463e5c220} oximeter.fields_uuid (956c3398-09af-4831-9dc5-03d47a327612): There are no data parts 2024.12.06 21:14:51.310936 [ 268 ] {f8586239-0f51-4a20-b433-c35463e5c220} TCPHandler: Processed in 0.011384386 sec. 2024.12.06 21:14:51.311182 [ 266 ] {} TCP-Session: 2c48ed9f-23d7-4458-947d-f99f2e2ad7d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.311491 [ 266 ] {737d7273-3983-4c8c-9e36-a71e15aa1c0d} executeQuery: (from [fd00:1122:3344:101::d]:58439) /* The timeseries schema table stores the extracted schema for the samples * oximeter collects. */ 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) 2024.12.06 21:14:51.311576 [ 266 ] {737d7273-3983-4c8c-9e36-a71e15aa1c0d} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema 2024.12.06 21:14:51.314256 [ 266 ] {737d7273-3983-4c8c-9e36-a71e15aa1c0d} oximeter.timeseries_schema (170f830b-7c5a-4889-8861-cee262533a56): Loading data parts 2024.12.06 21:14:51.314475 [ 266 ] {737d7273-3983-4c8c-9e36-a71e15aa1c0d} oximeter.timeseries_schema (170f830b-7c5a-4889-8861-cee262533a56): There are no data parts 2024.12.06 21:14:51.319940 [ 266 ] {737d7273-3983-4c8c-9e36-a71e15aa1c0d} TCPHandler: Processed in 0.008828345 sec. 2024.12.06 21:14:51.320134 [ 268 ] {} TCP-Session: 5f64437b-45d2-49a7-9395-24050a0dcb73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.06 21:14:51.320385 [ 268 ] {1d0f88c7-cfa8-490e-98a6-f6d556269852} executeQuery: (from [fd00:1122:3344:101::d]:44123) INSERT INTO oximeter.version (*) VALUES (stage: Complete) 2024.12.06 21:14:51.321616 [ 268 ] {1d0f88c7-cfa8-490e-98a6-f6d556269852} ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version 2024.12.06 21:14:51.329972 [ 276 ] {1d0f88c7-cfa8-490e-98a6-f6d556269852} oximeter.version (b6c60fe8-ad03-4c2d-bbfb-b10ecb8c5b9b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.06 21:14:51.330082 [ 276 ] {1d0f88c7-cfa8-490e-98a6-f6d556269852} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.20 GiB. 2024.12.06 21:14:51.334967 [ 276 ] {1d0f88c7-cfa8-490e-98a6-f6d556269852} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.06 21:14:51.335458 [ 276 ] {1d0f88c7-cfa8-490e-98a6-f6d556269852} oximeter.version (b6c60fe8-ad03-4c2d-bbfb-b10ecb8c5b9b): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.12.06 21:14:51.335843 [ 268 ] {1d0f88c7-cfa8-490e-98a6-f6d556269852} executeQuery: Read 1 rows, 16.00 B in 0.015559 sec., 64.27148274310689 rows/sec., 1.00 KiB/sec. 2024.12.06 21:14:51.336134 [ 268 ] {1d0f88c7-cfa8-490e-98a6-f6d556269852} TCPHandler: Processed in 0.016055933 sec. 2024.12.06 21:14:51.337116 [ 285 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:39673 2024.12.06 21:14:51.338419 [ 285 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:51.338456 [ 285 ] {} TCP-Session: f9d62020-4563-43cc-83f2-9158db128558 Authenticating user 'default' from [fd00:1122:3344:101::a]:39673 2024.12.06 21:14:51.338480 [ 285 ] {} TCP-Session: f9d62020-4563-43cc-83f2-9158db128558 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.338529 [ 285 ] {} TCP-Session: f9d62020-4563-43cc-83f2-9158db128558 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.338580 [ 285 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.12.06 21:14:51.338605 [ 285 ] {} 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 2024.12.06 21:14:51.338652 [ 285 ] {} 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 2024.12.06 21:14:51.339188 [ 286 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:38739 2024.12.06 21:14:51.339258 [ 287 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:43174 2024.12.06 21:14:51.339537 [ 286 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:51.339550 [ 287 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:51.339596 [ 286 ] {} TCP-Session: b7ee1b54-610f-4703-a7d3-2ed0b6825bf8 Authenticating user 'default' from [fd00:1122:3344:101::a]:38739 2024.12.06 21:14:51.339570 [ 288 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:49255 2024.12.06 21:14:51.339654 [ 289 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:35720 2024.12.06 21:14:51.339687 [ 287 ] {} TCP-Session: cd8a75a6-c3bc-4a70-b738-6f70688b03dd Authenticating user 'default' from [fd00:1122:3344:101::a]:43174 2024.12.06 21:14:51.339702 [ 286 ] {} TCP-Session: b7ee1b54-610f-4703-a7d3-2ed0b6825bf8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.339749 [ 290 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:49498 2024.12.06 21:14:51.340032 [ 286 ] {} TCP-Session: b7ee1b54-610f-4703-a7d3-2ed0b6825bf8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.340113 [ 287 ] {} TCP-Session: cd8a75a6-c3bc-4a70-b738-6f70688b03dd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.340267 [ 290 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:51.340283 [ 287 ] {} TCP-Session: cd8a75a6-c3bc-4a70-b738-6f70688b03dd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.340329 [ 290 ] {} TCP-Session: 5855f065-ee37-418e-a92f-1ce15cf80acb Authenticating user 'default' from [fd00:1122:3344:101::a]:49498 2024.12.06 21:14:51.340368 [ 292 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:62493 2024.12.06 21:14:51.340377 [ 291 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:40949 2024.12.06 21:14:51.340400 [ 290 ] {} TCP-Session: 5855f065-ee37-418e-a92f-1ce15cf80acb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.340558 [ 290 ] {} TCP-Session: 5855f065-ee37-418e-a92f-1ce15cf80acb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.345194 [ 288 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:51.345249 [ 288 ] {} TCP-Session: f13ed27f-234b-4050-9954-f2a56c31d9a5 Authenticating user 'default' from [fd00:1122:3344:101::a]:49255 2024.12.06 21:14:51.345261 [ 292 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:51.345348 [ 288 ] {} TCP-Session: f13ed27f-234b-4050-9954-f2a56c31d9a5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.345353 [ 292 ] {} TCP-Session: e6523a08-e506-4071-ab59-1f55830de421 Authenticating user 'default' from [fd00:1122:3344:101::a]:62493 2024.12.06 21:14:51.345368 [ 288 ] {} TCP-Session: f13ed27f-234b-4050-9954-f2a56c31d9a5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.345429 [ 292 ] {} TCP-Session: e6523a08-e506-4071-ab59-1f55830de421 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.345493 [ 291 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:51.345507 [ 292 ] {} TCP-Session: e6523a08-e506-4071-ab59-1f55830de421 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.345604 [ 291 ] {} TCP-Session: ad6ed762-159d-485e-9c04-25f1f6ce4079 Authenticating user 'default' from [fd00:1122:3344:101::a]:40949 2024.12.06 21:14:51.345636 [ 291 ] {} TCP-Session: ad6ed762-159d-485e-9c04-25f1f6ce4079 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.345677 [ 291 ] {} TCP-Session: ad6ed762-159d-485e-9c04-25f1f6ce4079 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.346048 [ 289 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.06 21:14:51.346092 [ 289 ] {} TCP-Session: 4fa61b61-646d-4a10-94b9-9da500748dfa Authenticating user 'default' from [fd00:1122:3344:101::a]:35720 2024.12.06 21:14:51.346114 [ 289 ] {} TCP-Session: 4fa61b61-646d-4a10-94b9-9da500748dfa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:51.346169 [ 289 ] {} TCP-Session: 4fa61b61-646d-4a10-94b9-9da500748dfa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.06 21:14:52.000172 [ 248 ] {} AsynchronousMetrics: MemoryTracking: was 136.71 MiB, peak 136.71 MiB, free memory in arenas 0.00 B, will set to 141.16 MiB (RSS), difference: 4.45 MiB 2024.12.06 21:14:57.745068 [ 243 ] {} SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 2024.12.06 21:14:57.745149 [ 244 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 488 entries to flush up to offset 488 2024.12.06 21:14:57.745205 [ 243 ] {} SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog 2024.12.06 21:14:57.745310 [ 244 ] {} SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog 2024.12.06 21:14:57.752752 [ 244 ] {} system.asynchronous_metric_log (5b947737-a0f7-4253-937a-62c4063c4b41): Loading data parts 2024.12.06 21:14:57.753139 [ 244 ] {} system.asynchronous_metric_log (5b947737-a0f7-4253-937a-62c4063c4b41): There are no data parts 2024.12.06 21:14:57.763120 [ 244 ] {} system.asynchronous_metric_log (5b947737-a0f7-4253-937a-62c4063c4b41): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.06 21:14:57.763194 [ 244 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.20 GiB. 2024.12.06 21:14:57.766612 [ 244 ] {} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.06 21:14:57.767222 [ 244 ] {} system.asynchronous_metric_log (5b947737-a0f7-4253-937a-62c4063c4b41): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.12.06 21:14:57.767862 [ 244 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 488 2024.12.06 21:14:57.777239 [ 243 ] {} system.metric_log (616b9259-da85-482a-ae16-1c47ae22f4f6): Loading data parts 2024.12.06 21:14:57.777450 [ 243 ] {} system.metric_log (616b9259-da85-482a-ae16-1c47ae22f4f6): There are no data parts 2024.12.06 21:14:57.803083 [ 243 ] {} system.metric_log (616b9259-da85-482a-ae16-1c47ae22f4f6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.06 21:14:57.803126 [ 243 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.20 GiB. 2024.12.06 21:14:57.810270 [ 243 ] {} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.06 21:14:57.811004 [ 243 ] {} system.metric_log (616b9259-da85-482a-ae16-1c47ae22f4f6): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.12.06 21:14:57.813341 [ 243 ] {} SystemLog (system.metric_log): Flushed system log up to offset 8 2024.12.06 21:14:58.000256 [ 248 ] {} AsynchronousMetrics: MemoryTracking: was 146.20 MiB, peak 150.20 MiB, free memory in arenas 0.00 B, will set to 151.02 MiB (RSS), difference: 4.82 MiB 2024.12.06 21:15:00.245043 [ 242 ] {} SystemLog (system.query_log): Flushing system log, 90 entries to flush up to offset 90 2024.12.06 21:15:00.245160 [ 242 ] {} SystemLog (system.query_log): Creating new table system.query_log for QueryLog 2024.12.06 21:15:00.251340 [ 242 ] {} system.query_log (9c1befc3-ccce-4119-810d-a572454d203b): Loading data parts 2024.12.06 21:15:00.251596 [ 242 ] {} system.query_log (9c1befc3-ccce-4119-810d-a572454d203b): There are no data parts 2024.12.06 21:15:00.259992 [ 242 ] {} system.query_log (9c1befc3-ccce-4119-810d-a572454d203b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.06 21:15:00.260055 [ 242 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.19 GiB. 2024.12.06 21:15:00.262282 [ 242 ] {} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.06 21:15:00.262636 [ 242 ] {} system.query_log (9c1befc3-ccce-4119-810d-a572454d203b): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.12.06 21:15:00.263191 [ 242 ] {} SystemLog (system.query_log): Flushed system log up to offset 90 2024.12.06 21:15:01.000175 [ 248 ] {} AsynchronousMetrics: MemoryTracking: was 155.20 MiB, peak 155.20 MiB, free memory in arenas 0.00 B, will set to 151.41 MiB (RSS), difference: -3.79 MiB