++ rg -v '#' /usr/share/zoneinfo/zone.tab ++ awk '{print $3}' ++ shuf ++ head -n1 + TZ=Pacific/Gambier + echo 'Choosen random timezone Pacific/Gambier' + ln -snf /usr/share/zoneinfo/Pacific/Gambier /etc/localtime Choosen random timezone Pacific/Gambier + echo Pacific/Gambier + dpkg -i package_folder/clickhouse-common-static_24.12.2.20238.altinityantalya+msan_amd64.deb Selecting previously unselected package clickhouse-common-static. (Reading database ... 48425 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static_24.12.2.20238.altinityantalya+msan_amd64.deb ... Unpacking clickhouse-common-static (24.12.2.20238.altinityantalya+msan) ... Setting up clickhouse-common-static (24.12.2.20238.altinityantalya+msan) ... + dpkg -i package_folder/clickhouse-common-static-dbg_24.12.2.20238.altinityantalya+msan_amd64.deb Selecting previously unselected package clickhouse-common-static-dbg. (Reading database ... 48452 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static-dbg_24.12.2.20238.altinityantalya+msan_amd64.deb ... Unpacking clickhouse-common-static-dbg (24.12.2.20238.altinityantalya+msan) ... Setting up clickhouse-common-static-dbg (24.12.2.20238.altinityantalya+msan) ... + dpkg -i package_folder/clickhouse-server_24.12.2.20238.altinityantalya+msan_amd64.deb Selecting previously unselected package clickhouse-server. (Reading database ... 48459 files and directories currently installed.) Preparing to unpack .../clickhouse-server_24.12.2.20238.altinityantalya+msan_amd64.deb ... Unpacking clickhouse-server (24.12.2.20238.altinityantalya+msan) ... Setting up clickhouse-server (24.12.2.20238.altinityantalya+msan) ... ClickHouse binary is already located at /usr/bin/clickhouse Symlink /usr/bin/clickhouse-server already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-server to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-client to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-local to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-benchmark to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-obfuscator to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-git-import to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-compressor to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-format to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-extract-from-config already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-extract-from-config to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-keeper already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-keeper-converter already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper-converter to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-disks to /usr/bin/clickhouse. Creating symlink /usr/bin/ch to /usr/bin/clickhouse. Creating symlink /usr/bin/chl to /usr/bin/clickhouse. Creating symlink /usr/bin/chc to /usr/bin/clickhouse. Creating clickhouse group if it does not exist. groupadd -r clickhouse Creating clickhouse user if it does not exist. useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse clickhouse Will set ulimits for clickhouse user in /etc/security/limits.d/clickhouse.conf. Creating config directory /etc/clickhouse-server/config.d that is used for tweaks of main server configuration. Creating config directory /etc/clickhouse-server/users.d that is used for tweaks of users configuration. Config file /etc/clickhouse-server/config.xml already exists, will keep it and extract path info from it. /etc/clickhouse-server/config.xml has /var/lib/clickhouse/ as data path. /etc/clickhouse-server/config.xml has /var/log/clickhouse-server/ as log path. Users config file /etc/clickhouse-server/users.xml already exists, will keep it and extract users info from it. Log directory /var/log/clickhouse-server/ already exists. Creating data directory /var/lib/clickhouse/. Creating pid directory /var/run/clickhouse-server. chown -R clickhouse:clickhouse '/var/log/clickhouse-server/' chown -R clickhouse:clickhouse '/var/run/clickhouse-server' chown clickhouse:clickhouse '/var/lib/clickhouse/' Password for the default user is an empty string. See /etc/clickhouse-server/users.xml and /etc/clickhouse-server/users.d to change it. Setting capabilities for clickhouse binary. This is optional. chown -R clickhouse:clickhouse '/etc/clickhouse-server' ClickHouse has been successfully installed. Start clickhouse-server with: sudo clickhouse start Start clickhouse-client with: clickhouse-client + dpkg -i package_folder/clickhouse-client_24.12.2.20238.altinityantalya+msan_amd64.deb Selecting previously unselected package clickhouse-client. (Reading database ... 48476 files and directories currently installed.) Preparing to unpack .../clickhouse-client_24.12.2.20238.altinityantalya+msan_amd64.deb ... Unpacking clickhouse-client (24.12.2.20238.altinityantalya+msan) ... Setting up clickhouse-client (24.12.2.20238.altinityantalya+msan) ... + ln -s /repo/tests/clickhouse-test /usr/bin/clickhouse-test + source /repo/tests/docker_scripts/utils.lib ++ sysctl kernel.core_pattern=core.%e.%p-%P kernel.core_pattern = core.%e.%p-%P ++ sysctl fs.suid_dumpable=1 fs.suid_dumpable = 1 + /repo/tests/config/install.sh + DEST_SERVER_PATH=/etc/clickhouse-server + DEST_CLIENT_PATH=/etc/clickhouse-client +++ dirname /repo/tests/config/install.sh ++ cd /repo/tests/config ++ pwd -P + SRC_PATH=/repo/tests/config + '[' 0 -ge 2 ']' + FAST_TEST=0 + NO_AZURE=0 + [[ 0 -gt 0 ]] + echo 'Going to install test configs from /repo/tests/config into /etc/clickhouse-server' Going to install test configs from /repo/tests/config into /etc/clickhouse-server + mkdir -p /etc/clickhouse-server/config.d/ + mkdir -p /etc/clickhouse-server/users.d/ + mkdir -p /etc/clickhouse-client + ln -sf /repo/tests/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/database_catalog_drop_table_concurrency.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/clusters.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/graphite.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/grpc_protocol.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/transactions.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/encryption.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/CORS.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/session_log.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/nlp.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/display_name.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/backups.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/block_number.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/serverwide_trace_collector.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/rocksdb.xml /etc/clickhouse-server/config.d/ + '[' 0 '!=' 1 ']' + ln -sf /repo/tests/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/readonly.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/access_management.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/filelog.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/marks.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/limits.yaml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /repo/tests/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/ints_dictionary.xml /etc/clickhouse-server/ + ln -sf /repo/tests/config/strings_dictionary.xml /etc/clickhouse-server/ + ln -sf /repo/tests/config/decimals_dictionary.xml /etc/clickhouse-server/ + ln -sf /repo/tests/config/executable_dictionary.xml /etc/clickhouse-server/ + ln -sf /repo/tests/config/executable_pool_dictionary.xml /etc/clickhouse-server/ + ln -sf /repo/tests/config/test_function.xml /etc/clickhouse-server/ + ln -sf /repo/tests/config/top_level_domains /etc/clickhouse-server/ + ln -sf /repo/tests/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/regions_names_en.txt /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/regions_names_es.txt /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/ext-en.txt /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/ext-ru.txt /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/lem-en.bin /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/server.key /etc/clickhouse-server/ + ln -sf /repo/tests/config/server.crt /etc/clickhouse-server/ + ln -sf /repo/tests/config/dhparam.pem /etc/clickhouse-server/ + ln -sf --backup=simple --suffix=_original.xml /repo/tests/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/ + [[ -n '' ]] + rm -f /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + ln -sf /repo/tests/config/config.d/zookeeper.xml /etc/clickhouse-server/config.d/ + [[ -n '' ]] + rm -f /etc/clickhouse-server/config.d/cannot_allocate_thread_injection.xml + value=0 + sed --follow-symlinks -i 's|[01]|0|' /etc/clickhouse-server/config.d/keeper_port.xml + value=48840704 + sed --follow-symlinks -i 's|[[:digit:]]\+|48840704|' /etc/clickhouse-server/config.d/keeper_port.xml + value=49381376 + sed --follow-symlinks -i 's|[[:digit:]]\+|49381376|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n '' ]] + [[ '' == \1 ]] + [[ '' == \1 ]] + [[ 1 == \1 ]] + [[ 0 != \1 ]] + ln -sf /repo/tests/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/ + ln -sf /repo/tests/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + ln -sf /repo/tests/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/ + [[ '' == \1 ]] + ln -sf /repo/tests/config/client_config.xml /etc/clickhouse-client/config.xml + /repo/tests/docker_scripts/setup_minio.sh stateful + azurite-blob --blobHost 0.0.0.0 --blobPort 10000 --silent --inMemoryPersistence + export MINIO_ROOT_USER=clickhouse + MINIO_ROOT_USER=clickhouse + export MINIO_ROOT_PASSWORD=clickhouse + MINIO_ROOT_PASSWORD=clickhouse + main stateful + local query_dir ++ check_arg stateful ++ local query_dir ++ '[' '!' 1 -eq 1 ']' ++ case "$1" in ++ query_dir=1_stateful ++ echo 1_stateful + query_dir=1_stateful + '[' '!' -f ./minio ']' + start_minio + mkdir -p ./minio_data + ./minio --version minio version RELEASE.2024-08-03T04-33-23Z (commit-id=6efb56851c40da88d1ca15112e2d686a4ecec6b3) Runtime: go1.22.5 linux/amd64 License: GNU AGPLv3 - https://www.gnu.org/licenses/agpl-3.0.html Copyright: 2015-2024 MinIO, Inc. + wait_for_it + local counter=0 + ./minio server --address :11111 ./minio_data + local max_counter=60 + local url=http://localhost:11111 + params=('--silent' '--verbose') + local params + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 0 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 (node:203) [DEP0040] DeprecationWarning: The `punycode` module is deprecated. Please use a userland alternative instead. (Use `node --trace-deprecation ...` to show where the warning was created) In-memory extent storage is enabled with a limit of 15667.21 MB (16428259328 bytes, 50% of total memory). Azurite Blob service is starting on 0.0.0.0:10000 Azurite Blob service successfully listens on http://0.0.0.0:10000 INFO: Formatting 1st pool, 1 set(s), 1 drives per set. INFO: WARNING: Host local has more than 0 drives of set. A host failure will result in data becoming unavailable. MinIO Object Storage Server Copyright: 2015-2025 MinIO, Inc. License: GNU AGPLv3 - https://www.gnu.org/licenses/agpl-3.0.html Version: RELEASE.2024-08-03T04-33-23Z (go1.22.5 linux/amd64) API: http://172.17.0.2:11111 http://127.0.0.1:11111 WebUI: http://172.17.0.2:38551 http://127.0.0.1:38551 Docs: https://min.io/docs/minio/linux/index.html + counter=1 + curl --silent --verbose http://localhost:11111 + grep AccessDenied AccessDeniedAccess Denied./1832EF989D8AF3C97dc7eb22d3288ec80374614e9088e31d3668a6922ead55932dd2a8e56373820f + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 226 root 8u IPv6 36196 0t0 TCP *:11111 (LISTEN) minio 226 root 9u IPv4 36195 0t0 TCP localhost:11111 (LISTEN) minio 226 root 10u IPv6 36197 0t0 TCP localhost:11111 (LISTEN) + sleep 5 + setup_minio stateful + local test_type=stateful + ./mc alias set clickminio http://localhost:11111 clickhouse clickhouse Added `clickminio` successfully. + ./mc admin user add clickminio test testtest Added user `test` successfully. + ./mc admin policy attach clickminio readwrite --user=test Attached Policies: [readwrite] To User: test + ./mc mb --ignore-existing clickminio/test Bucket created successfully `clickminio/test`. + '[' stateful = stateless ']' + upload_data 1_stateful /repo/tests/ + local query_dir=1_stateful + local test_path=/repo/tests/ + local data_path=/repo/tests//queries/1_stateful/data_minio + '[' -d /repo/tests//queries/1_stateful/data_minio ']' + setup_aws_credentials + local minio_root_user=clickhouse + local minio_root_password=clickhouse + mkdir -p /root/.aws + cat + MC_ADMIN_PID=319 + ./mc admin trace clickminio + config_logs_export_cluster /etc/clickhouse-server/config.d/system_logs_export.yaml + set +x File /tmp/export-logs-config.sh does not exist, do not setup + cache_policy= + '[' 1 -eq 1 ']' + cache_policy=SLRU Using cache policy: SLRU + echo 'Using cache policy: SLRU' + '[' SLRU = SLRU ']' + sudo cat /etc/clickhouse-server/config.d/storage_conf.xml + sed 's|LRU|SLRU|' + mv /etc/clickhouse-server/config.d/storage_conf.xml.tmp /etc/clickhouse-server/config.d/storage_conf.xml + [[ -n '' ]] + start + [[ -n '' ]] + counter=0 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + timeout 120 sudo -E -u clickhouse /usr/bin/clickhouse-server --config /etc/clickhouse-server/config.xml --daemon --pid-file /var/run/clickhouse-server/clickhouse-server.pid + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + timeout 120 sudo -E -u clickhouse /usr/bin/clickhouse-server --config /etc/clickhouse-server/config.xml --daemon --pid-file /var/run/clickhouse-server/clickhouse-server.pid + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + timeout 120 sudo -E -u clickhouse /usr/bin/clickhouse-server --config /etc/clickhouse-server/config.xml --daemon --pid-file /var/run/clickhouse-server/clickhouse-server.pid + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + timeout 120 sudo -E -u clickhouse /usr/bin/clickhouse-server --config /etc/clickhouse-server/config.xml --daemon --pid-file /var/run/clickhouse-server/clickhouse-server.pid + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + timeout 120 sudo -E -u clickhouse /usr/bin/clickhouse-server --config /etc/clickhouse-server/config.xml --daemon --pid-file /var/run/clickhouse-server/clickhouse-server.pid + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + timeout 120 sudo -E -u clickhouse /usr/bin/clickhouse-server --config /etc/clickhouse-server/config.xml --daemon --pid-file /var/run/clickhouse-server/clickhouse-server.pid + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + timeout 120 sudo -E -u clickhouse /usr/bin/clickhouse-server --config /etc/clickhouse-server/config.xml --daemon --pid-file /var/run/clickhouse-server/clickhouse-server.pid + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + timeout 120 sudo -E -u clickhouse /usr/bin/clickhouse-server --config /etc/clickhouse-server/config.xml --daemon --pid-file /var/run/clickhouse-server/clickhouse-server.pid + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + timeout 120 sudo -E -u clickhouse /usr/bin/clickhouse-server --config /etc/clickhouse-server/config.xml --daemon --pid-file /var/run/clickhouse-server/clickhouse-server.pid + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + timeout 120 sudo -E -u clickhouse /usr/bin/clickhouse-server --config /etc/clickhouse-server/config.xml --daemon --pid-file /var/run/clickhouse-server/clickhouse-server.pid + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + timeout 120 sudo -E -u clickhouse /usr/bin/clickhouse-server --config /etc/clickhouse-server/config.xml --daemon --pid-file /var/run/clickhouse-server/clickhouse-server.pid + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + timeout 120 sudo -E -u clickhouse /usr/bin/clickhouse-server --config /etc/clickhouse-server/config.xml --daemon --pid-file /var/run/clickhouse-server/clickhouse-server.pid + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + timeout 120 sudo -E -u clickhouse /usr/bin/clickhouse-server --config /etc/clickhouse-server/config.xml --daemon --pid-file /var/run/clickhouse-server/clickhouse-server.pid + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + timeout 120 sudo -E -u clickhouse /usr/bin/clickhouse-server --config /etc/clickhouse-server/config.xml --daemon --pid-file /var/run/clickhouse-server/clickhouse-server.pid + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + timeout 120 sudo -E -u clickhouse /usr/bin/clickhouse-server --config /etc/clickhouse-server/config.xml --daemon --pid-file /var/run/clickhouse-server/clickhouse-server.pid + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' 1 + setup_logs_replication + set +x File /tmp/export-logs-config.sh does not exist, do not setup + clickhouse-client --query 'SHOW DATABASES' INFORMATION_SCHEMA default information_schema system + clickhouse-client --query 'CREATE DATABASE datasets' + clickhouse-client + clickhouse-client --query 'SHOW TABLES FROM datasets' hits_v1 visits_v1 + [[ -n '' ]] + clickhouse-client --query 'CREATE DATABASE test' + clickhouse-client --query 'SHOW TABLES FROM test' + [[ -n '' ]] + clickhouse-client --query 'RENAME TABLE datasets.hits_v1 TO test.hits' + clickhouse-client --query 'RENAME TABLE datasets.visits_v1 TO test.visits' + clickhouse-client --query 'CREATE TABLE test.hits_s3 (WatchID UInt64, JavaEnable UInt8, Title String, GoodEvent Int16, EventTime DateTime, EventDate Date, CounterID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RegionID UInt32, UserID UInt64, CounterClass Int8, OS UInt8, UserAgent UInt8, URL String, Referer String, URLDomain String, RefererDomain String, Refresh UInt8, IsRobot UInt8, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32), RefererRegions Array(UInt32), ResolutionWidth UInt16, ResolutionHeight UInt16, ResolutionDepth UInt8, FlashMajor UInt8, FlashMinor UInt8, FlashMinor2 String, NetMajor UInt8, NetMinor UInt8, UserAgentMajor UInt16, UserAgentMinor FixedString(2), CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, MobilePhone UInt8, MobilePhoneModel String, Params String, IPNetworkID UInt32, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, IsArtifical UInt8, WindowClientWidth UInt16, WindowClientHeight UInt16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 UInt8, SilverlightVersion2 UInt8, SilverlightVersion3 UInt32, SilverlightVersion4 UInt16, PageCharset String, CodeVersion UInt32, IsLink UInt8, IsDownload UInt8, IsNotBounce UInt8, FUniqID UInt64, HID UInt32, IsOldCounter UInt8, IsEvent UInt8, IsParameter UInt8, DontCountHits UInt8, WithHash UInt8, HitColor FixedString(1), UTCEventTime DateTime, Age UInt8, Sex UInt8, Income UInt8, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), RemoteIP UInt32, RemoteIP6 FixedString(16), WindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage FixedString(2), BrowserCountry FixedString(2), SocialNetwork String, SocialAction String, HTTPError UInt16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, FetchTiming Int32, RedirectTiming Int32, DOMInteractiveTiming Int32, DOMContentLoadedTiming Int32, DOMCompleteTiming Int32, LoadEventStartTiming Int32, LoadEventEndTiming Int32, NSToDOMContentLoadedTiming Int32, FirstPaintTiming Int32, RedirectCount Int8, SocialSourceNetworkID UInt8, SocialSourcePage String, ParamPrice Int64, ParamOrderID String, ParamCurrency FixedString(3), ParamCurrencyID UInt16, GoalsReached Array(UInt32), OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, RefererHash UInt64, URLHash UInt64, CLID UInt32, YCLID UInt64, ShareService String, ShareURL String, ShareTitle String, ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64), IslandID FixedString(16), RequestNum UInt32, RequestTry UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate) ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''s3_cache'\''' + clickhouse-client --max_memory_usage 30G --max_memory_usage_for_user 30G --query 'INSERT INTO test.hits_s3 SELECT * FROM test.hits SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16' + clickhouse-client --query 'SHOW TABLES FROM test' hits hits_s3 visits + clickhouse-client --query 'SELECT count() FROM test.hits' 8873898 + clickhouse-client --query 'SELECT count() FROM test.visits' 1676861 + export -f run_tests + run_tests + set -x + read -ra ADDITIONAL_OPTIONS + [[ -n '' ]] + [[ -n '' ]] + [[ -n '' ]] + [[ -n '' ]] + set +e + TEST_ARGS=(-j 2 --testname --shard --zookeeper --check-zookeeper-session --no-stateless --hung-check --print-time --capture-client-stacktrace --queries "/repo/tests/queries" "${ADDITIONAL_OPTIONS[@]}" "$SKIP_TESTS_OPTION") + [[ -n '' ]] + clickhouse-test -j 2 --testname --shard --zookeeper --check-zookeeper-session --no-stateless --hung-check --print-time --capture-client-stacktrace --queries /repo/tests/queries --hung-check --print-time '' + ts '%Y-%m-%d %H:%M:%S' + tee test_output/test_result.txt 2025-04-03 13:32:40 Using queries from '/repo/tests/queries' directory 2025-04-03 13:32:40 Connecting to ClickHouse server... OK 2025-04-03 13:32:40 Connected to server 24.12.2.20238.altinityantalya @ 7fd01c857261d6d4c5e006184de135bdd9bc54b7 HEAD 2025-04-03 13:32:41 Won't run stateless tests because they were manually disabled. 2025-04-03 13:32:41 Found 133 parallel tests and 6 sequential tests 2025-04-03 13:32:46 Running about 66 stateful tests (Process-4). 2025-04-03 13:32:46 00096_obfuscator_save_load: [ OK ] 5.25 sec. 2025-04-03 13:32:47 00032_aggregate_key64: [ OK ] 1.23 sec. 2025-04-03 13:32:54 Running about 66 stateful tests (Process-3). 2025-04-03 13:32:54 00160_decode_xml_component: [ OK ] 12.96 sec. 2025-04-03 13:32:55 00073_uniq_array: [ OK ] 1.48 sec. 2025-04-03 13:32:57 00052_group_by_in: [ OK ] 1.49 sec. 2025-04-03 13:32:59 00060_move_to_prewhere_and_sets: [ OK ] 2.58 sec. 2025-04-03 13:33:00 00066_sorting_distributed_many_replicas: [ OK ] 0.98 sec. 2025-04-03 13:33:01 00015_totals_and_no_aggregate_functions: [ OK ] 1.13 sec. 2025-04-03 13:33:03 00005_filtering: [ OK ] 1.44 sec. 2025-04-03 13:33:10 00030_array_enumerate_uniq: [ OK ] 6.99 sec. 2025-04-03 13:33:12 00082_quantiles: [ OK ] 24.95 sec. 2025-04-03 13:33:13 00151_order_by_read_in_order: [ OK ] 1.34 sec. 2025-04-03 13:33:18 00148_monotonic_functions_and_index: [ OK ] 7.60 sec. 2025-04-03 13:33:21 00093_prewhere_array_join: [ OK ] 8.00 sec. 2025-04-03 13:33:40 00041_aggregating_materialized_view: [ OK ] 22.73 sec. 2025-04-03 13:33:46 00042_any_left_join: [ OK ] 5.95 sec. 2025-04-03 13:33:47 00055_index_and_not: [ OK ] 1.05 sec. 2025-04-03 13:33:50 00089_position_functions_with_non_constant_arg: [ OK ] 28.80 sec. 2025-04-03 13:33:59 00071_merge_tree_optimize_aio: [ OK ] 11.77 sec. 2025-04-03 13:34:03 00090_thread_pool_deadlock: [ OK ] 12.36 sec. 2025-04-03 13:34:04 00022_merge_prewhere: [ OK ] 1.74 sec. 2025-04-03 13:34:22 00091_prewhere_two_conditions: [ OK ] 17.92 sec. 2025-04-03 13:34:27 00061_storage_buffer: [ OK ] 4.34 sec. 2025-04-03 13:34:33 00147_global_in_aggregate_function: [ OK ] 5.74 sec. 2025-04-03 13:34:34 00076_system_columns_bytes: [ OK ] 1.03 sec. 2025-04-03 13:34:35 00031_array_enumerate_uniq: [ OK ] 1.13 sec. 2025-04-03 13:34:36 00167_parallel_parsing_with_names_and_types: [ OK ] 36.92 sec. 2025-04-03 13:34:39 00145_aggregate_functions_statistics: [ OK ] 3.14 sec. 2025-04-03 13:34:40 00172_early_constant_folding: [ OK ] 0.98 sec. 2025-04-03 13:34:41 00153_aggregate_arena_race: [ OK ] 5.84 sec. 2025-04-03 13:34:42 00021_2_select_with_in: [ OK ] 1.68 sec. 2025-04-03 13:34:43 00183_prewhere_conditions_order: [ OK ] 1.08 sec. 2025-04-03 13:34:44 00048_min_max: [ OK ] 0.93 sec. 2025-04-03 13:34:45 00174_distinct_in_order: [ OK ] 4.49 sec. 2025-04-03 13:34:50 00046_uniq_upto_distributed: [ OK ] 4.89 sec. 2025-04-03 13:34:51 00176_distinct_limit_by_limit_bug_43377: [ OK ] 1.03 sec. 2025-04-03 13:34:56 00038_uniq_state_merge2: [ OK ] 4.89 sec. 2025-04-03 13:35:04 00181_cross_join_compression: [ OK ] 19.58 sec. 2025-04-03 13:35:06 00059_merge_sorting_empty_array_joined: [ OK ] 1.79 sec. 2025-04-03 13:35:49 00167_read_bytes_from_fs: [ OK ] 42.79 sec. 2025-04-03 13:35:50 00004_top_counters: [ OK ] 1.44 sec. 2025-04-03 13:35:51 00098_primary_key_memory_allocated: [ OK ] 0.99 sec. 2025-04-03 13:35:54 00014_filtering_arrays: [ OK ] 2.33 sec. 2025-04-03 13:35:55 00081_group_by_without_key_and_totals: [ OK ] 1.63 sec. 2025-04-03 13:36:03 00072_compare_date_and_string_index: [ OK ] 7.70 sec. 2025-04-03 13:36:14 00159_parallel_formatting_http: [ OK ] 78.33 sec. 2025-04-03 13:36:19 00023_totals_limit: [ OK ] 4.60 sec. 2025-04-03 13:36:20 00080_array_join_and_union: [ OK ] 1.13 sec. 2025-04-03 13:36:21 00007_uniq: [ OK ] 0.93 sec. 2025-04-03 13:36:32 00169_contingency: [ OK ] 29.25 sec. 2025-04-03 13:36:32 00176_bson_parallel_parsing: [ SKIPPED ] 0.00 sec. 2025-04-03 13:36:32 Reason: disabled 2025-04-03 13:36:34 00008_uniq: [ OK ] 1.74 sec. 2025-04-03 13:37:01 00078_group_by_arrays: [ OK ] 40.34 sec. 2025-04-03 13:37:06 00182_simple_squashing_transform_bug: [ OK ] 4.57 sec. 2025-04-03 13:37:13 00092_obfuscator: [ OK ] 6.51 sec. 2025-04-03 13:37:23 00159_parallel_formatting_tsv_and_friends: [ OK ] 48.40 sec. 2025-04-03 13:37:25 00086_array_reduce: [ OK ] 12.26 sec. 2025-04-03 13:37:31 00040_aggregating_materialized_view: [ OK ] 6.14 sec. 2025-04-03 13:37:33 00047_bar: [ OK ] 1.83 sec. 2025-04-03 13:37:35 00062_loyalty: [ OK ] 1.73 sec. 2025-04-03 13:37:41 00161_parallel_parsing_with_names: [ OK ] 18.68 sec. 2025-04-03 13:37:46 00033_aggregate_key_string: [ OK ] 5.05 sec. 2025-04-03 13:37:54 00036_aggregate_hashed: [ OK ] 7.91 sec. 2025-04-03 13:37:56 00087_where_0: [ OK ] 1.15 sec. 2025-04-03 13:38:24 00084_external_aggregation: [ OK ] 49.05 sec. 2025-04-03 13:38:47 00165_jit_aggregate_functions: [ OK ] 22.64 sec. 2025-04-03 13:38:48 00021_1_select_with_in: [ OK ] 0.98 sec. 2025-04-03 13:39:06 00063_loyalty_joins: [ OK ] 18.54 sec. 2025-04-03 13:39:08 00035_aggregate_keys128: [ OK ] 1.94 sec. 2025-04-03 13:39:09 00001_count_hits: [ OK ] 0.93 sec. 2025-04-03 13:39:22 00044_any_left_join_string: [ OK ] 12.36 sec. 2025-04-03 13:39:24 00016_any_if_distributed_cond_always_false: [ OK ] 2.34 sec. 2025-04-03 13:39:33 00178_quantile_ddsketch: [ OK ] 9.05 sec. 2025-04-03 13:39:34 00141_transform: [ OK ] 0.98 sec. 2025-04-03 13:39:35 00039_primary_key: [ OK ] 1.04 sec. 2025-04-03 13:39:37 00159_parallel_formatting_json_and_friends_2: [ OK ] 101.29 sec. 2025-04-03 13:39:38 00021_3_select_with_in: [ OK ] 1.08 sec. 2025-04-03 13:39:46 00177_memory_bound_merging: [ OK ] 10.92 sec. 2025-04-03 13:40:33 00172_hits_joins: [ OK ] 46.55 sec. 2025-04-03 13:40:35 00050_min_max: [ OK ] 2.05 sec. 2025-04-03 13:40:37 00043_any_left_join: [ OK ] 2.44 sec. 2025-04-03 13:40:45 00020_distinct_order_by_distributed: [ OK ] 7.25 sec. 2025-04-03 13:40:47 00088_global_in_one_shard_and_rows_before_limit: [ OK ] 1.73 sec. 2025-04-03 13:40:48 00012_sorting_distributed: [ OK ] 1.48 sec. 2025-04-03 13:40:52 00159_parallel_formatting_csv_and_friends: [ OK ] 73.56 sec. 2025-04-03 13:41:04 00037_uniq_state_merge1: [ OK ] 12.01 sec. 2025-04-03 13:41:09 00065_loyalty_with_storage_join: [ OK ] 5.19 sec. 2025-04-03 13:41:10 00017_aggregation_uninitialized_memory: [ OK ] 0.94 sec. 2025-04-03 13:41:11 00163_column_oriented_formats: [ OK ] 23.14 sec. 2025-04-03 13:41:12 00013_sorting_of_nested: [ OK ] 2.03 sec. 2025-04-03 13:41:13 00142_system_columns: [ OK ] 0.93 sec. 2025-04-03 13:41:13 00045_uniq_upto: [ OK ] 2.08 sec. 2025-04-03 13:42:41 00024_random_counters: [ OK ] 87.61 sec. 2025-04-03 13:42:44 00056_view: [ OK ] 2.94 sec. 2025-04-03 13:42:48 00083_array_filter: [ OK ] 3.79 sec. 2025-04-03 13:42:56 00079_array_join_not_used_joined_column: [ OK ] 7.80 sec. 2025-04-03 13:42:57 00085_monotonic_evaluation_segfault: [ OK ] 1.08 sec. 2025-04-03 13:42:57 00159_parallel_formatting_json_and_friends_1: [ OK ] 104.50 sec. 2025-04-03 13:42:59 00075_left_array_join: [ OK ] 2.14 sec. 2025-04-03 13:42:59 00143_transform_non_const_default: [ OK ] 1.79 sec. 2025-04-03 13:43:03 00175_counting_resources_in_subqueries: [ OK ] 3.74 sec. 2025-04-03 13:43:05 00067_union_all: [ OK ] 1.59 sec. 2025-04-03 13:43:06 00011_sorting: [ OK ] 1.13 sec. 2025-04-03 13:43:07 00164_quantileBfloat16: [ OK ] 7.70 sec. 2025-04-03 13:43:08 00006_agregates: [ OK ] 1.28 sec. 2025-04-03 13:43:08 00054_merge_tree_partitions: [ OK ] 2.14 sec. 2025-04-03 13:43:14 00051_min_max_array: [ OK ] 5.74 sec. 2025-04-03 13:43:17 00034_aggregate_key_fixed_string: [ OK ] 2.79 sec. 2025-04-03 13:43:17 00094_order_by_array_join_limit: [ OK ] 9.40 sec. 2025-04-03 13:43:18 00002_count_visits: [ OK ] 1.09 sec. 2025-04-03 13:43:21 00144_functions_of_aggregation_states: [ OK ] 2.69 sec. 2025-04-03 13:43:27 00049_max_string_if: [ OK ] 6.00 sec. 2025-04-03 13:43:33 00149_quantiles_timing_distributed: [ OK ] 6.40 sec. 2025-04-03 13:43:34 00166_explain_estimate: [ OK ] 1.18 sec. 2025-04-03 13:43:41 00139_like: [ OK ] 23.39 sec. 2025-04-03 13:43:45 00154_avro: [ OK ] 3.84 sec. 2025-04-03 13:43:51 00156_max_execution_speed_sample_merge: [ OK ] 6.15 sec. 2025-04-03 13:43:52 00068_subquery_in_prewhere: [ OK ] 1.19 sec. 2025-04-03 13:43:54 00010_quantiles_segfault: [ OK ] 1.69 sec. 2025-04-03 13:43:56 00077_log_tinylog_stripelog: [ OK ] 22.05 sec. 2025-04-03 13:44:06 00171_grouping_aggregated_transform_bug: [ OK ] 9.61 sec. 2025-04-03 13:44:06 00074_full_join: [ OK ] 12.41 sec. 2025-04-03 13:44:16 00173_group_by_use_nulls: [ OK ] 9.81 sec. 2025-04-03 13:44:29 00095_hyperscan_profiler: [ OK ] 12.32 sec. 2025-04-03 13:44:30 00162_mmap_compression_none: [ OK ] 24.20 sec. 2025-04-03 13:44:31 00009_uniq_distributed: [ OK ] 2.49 sec. 2025-04-03 13:44:32 00097_constexpr_in_index: [ OK ] 0.99 sec. 2025-04-03 13:44:50 00053_replicate_segfault: [ OK ] 19.54 sec. 2025-04-03 13:44:59 00146_aggregate_function_uniq: [ OK ] 9.25 sec. 2025-04-03 13:45:06 00175_obfuscator_schema_inference: [ OK ] 7.20 sec. 2025-04-03 13:45:08 00184_parallel_hash_returns_same_res_as_hash: [ OK ] 35.37 sec. 2025-04-03 13:45:08 00150_quantiles_timing_precision: [ OK ] 2.04 sec. 2025-04-03 13:45:08 2025-04-03 13:45:08 60 tests passed. 1 tests skipped. 747.87 s elapsed (Process-4). 2025-04-03 13:45:09 00069_duplicate_aggregation_keys: [ OK ] 0.99 sec. 2025-04-03 13:45:09 2025-04-03 13:45:09 72 tests passed. 0 tests skipped. 748.09 s elapsed (Process-3). 2025-04-03 13:45:09 Running 6 stateful tests (MainProcess). 2025-04-03 13:45:55 00180_no_seek_avoiding_when_reading_from_cache: [ OK ] 46.11 sec. 2025-04-03 13:47:05 00170_s3_cache: [ OK ] 70.39 sec. 2025-04-03 13:47:57 00158_cache_dictionary_has: [ OK ] 51.33 sec. 2025-04-03 13:53:39 00157_cache_dictionary: [ FAIL ] 342.18 sec. 2025-04-03 13:53:39 Reason: return code: 160 2025-04-03 13:53:39 [9b07dd047ace] 2025.04.04 00:53:39.070466 [ 2180 ] {1abc0649-1d8b-447f-b9c8-8f73b7470529} executeQuery: Code: 160. DB::Exception: Estimated query execution time (1014.92752 seconds) is too long. Maximum: 600. Estimated rows to process: 1000000 (335872 read in 340.88574 seconds).: While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (TOO_SLOW) (version 24.12.2.20238.altinityantalya (altinity build)) (from [::1]:47840) (comment: 00157_cache_dictionary.sql) (in query: INSERT INTO test.hits_1m SELECT * FROM test.hits LIMIT 1000000 SETTINGS min_insert_block_size_rows = 0, min_insert_block_size_bytes = 0, max_block_size = 8192, max_insert_threads = 1, max_threads = 1, max_parallel_replicas=1;), Stack trace (when copying this message, always include the lines below): 2025-04-03 13:53:39 2025-04-03 13:53:39 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x00000000456f0e49 2025-04-03 13:53:39 1. ./build_docker/./src/Common/Exception.cpp:105: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000206e3853 2025-04-03 13:53:39 2. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x00000000088de1d5 2025-04-03 13:53:39 3. ./src/Common/Exception.h:123: DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type, std::type_identity::type, std::type_identity::type>, double&, int&&, unsigned long&, unsigned long&, double&) @ 0x0000000034b23987 2025-04-03 13:53:39 4. ./build_docker/./src/QueryPipeline/ExecutionSpeedLimits.cpp:87: DB::ExecutionSpeedLimits::throttle(unsigned long, unsigned long, unsigned long, unsigned long, DB::OverflowMode) const @ 0x0000000034b22e6d 2025-04-03 13:53:39 5. ./build_docker/./src/QueryPipeline/ReadProgressCallback.cpp:131: DB::ReadProgressCallback::onProgress(unsigned long, unsigned long, std::list> const&) @ 0x0000000034b212d5 2025-04-03 13:53:39 6. ./build_docker/./src/Processors/Executors/ExecutionThreadContext.cpp:64: DB::ExecutionThreadContext::executeTask() @ 0x000000003f76f223 2025-04-03 13:53:39 7. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:290: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x000000003f73a234 2025-04-03 13:53:39 8. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:256: DB::PipelineExecutor::executeImpl(unsigned long, bool) @ 0x000000003f737fe3 2025-04-03 13:53:39 9. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:127: DB::PipelineExecutor::execute(unsigned long, bool) @ 0x000000003f737a15 2025-04-03 13:53:39 10. ./build_docker/./src/Processors/Executors/CompletedPipelineExecutor.cpp:49: void std::__function::__policy_invoker::__call_impl::ThreadFromGlobalPoolImpl(DB::CompletedPipelineExecutor::execute()::$_0&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000003f735505 2025-04-03 13:53:39 11. ./contrib/llvm-project/libcxx/include/__functional/function.h:848: ? @ 0x00000000209872ca 2025-04-03 13:53:39 12. ./contrib/llvm-project/libcxx/include/__functional/invoke.h:359: ? @ 0x0000000020999a64 2025-04-03 13:53:39 13. ? @ 0x00007fea763e5ac3 2025-04-03 13:53:39 14. ? @ 0x00007fea76477850 2025-04-03 13:53:39 2025-04-03 13:53:39 Received exception from server (version 24.12.2): 2025-04-03 13:53:39 Code: 160. DB::Exception: Received from localhost:9000. DB::Exception: Estimated query execution time (1014.92752 seconds) is too long. Maximum: 600. Estimated rows to process: 1000000 (335872 read in 340.88574 seconds).: While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (TOO_SLOW) 2025-04-03 13:53:39 (query: INSERT INTO test.hits_1m SELECT * FROM test.hits LIMIT 1000000 2025-04-03 13:53:39 SETTINGS min_insert_block_size_rows = 0, min_insert_block_size_bytes = 0, max_block_size = 8192, max_insert_threads = 1, max_threads = 1, max_parallel_replicas=1;) 2025-04-03 13:53:39 , result: 2025-04-03 13:53:39 2025-04-03 13:53:39 2025-04-03 13:53:39 2025-04-03 13:53:39 stdout: 2025-04-03 13:53:39 2025-04-03 13:53:39 2025-04-03 13:53:39 Settings used in the test: --max_insert_threads 3 --group_by_two_level_threshold 222889 --group_by_two_level_threshold_bytes 1 --distributed_aggregation_memory_efficient 0 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 1993425 --max_read_buffer_size 821145 --prefer_localhost_replica 1 --max_block_size 31351 --max_joined_block_size_rows 19310 --max_threads 3 --optimize_append_index 0 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 0 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 31 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 36948417 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 1443730242 --local_filesystem_read_method read --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 3 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 4 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 0 --max_bytes_before_remerge_sort 2161300204 --min_compress_block_size 2198084 --max_compress_block_size 2731901 --merge_tree_compact_parts_min_granules_to_multibuffer_read 29 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 8642545 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone Africa/Khartoum --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.47 --prefer_external_sort_block_bytes 0 --cross_join_min_rows_to_compress 100000000 --cross_join_min_bytes_to_compress 0 --min_external_table_block_size_bytes 0 --max_parsing_threads 10 --optimize_functions_to_subcolumns 1 --parallel_replicas_local_plan 1 --query_plan_join_swap_table auto --output_format_native_write_json_as_string 1 --enable_vertical_final 1 2025-04-03 13:53:39 2025-04-03 13:53:39 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.019446747851141755 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 7377163035 --index_granularity_bytes 4051943 --merge_max_block_size 10354 --index_granularity 63226 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 46637 --primary_key_compress_block_size 87956 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --min_bytes_for_full_part_storage 0 --compact_parts_max_bytes_to_buffer 414169447 --compact_parts_max_granules_to_buffer 4 --compact_parts_merge_max_bytes_to_prefetch_part 13702413 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 82 --old_parts_lifetime 33 --prewarm_mark_cache 1 --use_const_adaptive_granularity 1 --enable_index_granularity_compression 1 --use_primary_key_cache 0 --prewarm_primary_key_cache 0 2025-04-03 13:53:39 2025-04-03 13:53:39 Database: test_nsiv6j9t 2025-04-03 13:53:44 00152_insert_different_granularity: [ OK ] 5.36 sec. 2025-04-03 13:53:46 00140_rename: [ OK ] 2.10 sec. 2025-04-03 13:53:46 2025-04-03 13:53:46 Having 1 errors! 5 tests passed. 0 tests skipped. 517.81 s elapsed (MainProcess). 2025-04-03 13:53:46 Checking the hung queries: done 2025-04-03 13:53:46 2025-04-03 13:53:46 No queries hung. 2025-04-03 13:53:46 All tests have finished. + set -e + echo 'Files in current directory' + ls -la ./ Files in current directory total 127160 drwxr-xr-x 1 root root 4096 Apr 3 13:30 . drwxr-xr-x 1 root root 4096 Apr 3 13:30 .. lrwxrwxrwx 1 root root 7 Sep 11 2024 bin -> usr/bin drwxr-xr-x 2 root root 4096 Apr 18 2022 boot drwxr-xr-x 14 root root 3840 Apr 3 13:30 dev -rwxr-xr-x 1 root root 0 Apr 3 13:30 .dockerenv drwxr-xr-x 1 root root 4096 Apr 3 13:30 etc drwxr-xr-x 2 root root 4096 Apr 18 2022 home lrwxrwxrwx 1 root root 7 Sep 11 2024 lib -> usr/lib lrwxrwxrwx 1 root root 9 Sep 11 2024 lib32 -> usr/lib32 lrwxrwxrwx 1 root root 9 Sep 11 2024 lib64 -> usr/lib64 lrwxrwxrwx 1 root root 10 Sep 11 2024 libx32 -> usr/libx32 -rwxr-xr-x 1 root root 26927256 Jan 15 12:53 mc drwxr-xr-x 2 root root 4096 Sep 11 2024 media -rwxr-xr-x 1 root root 103174296 Jan 15 12:53 minio drwxr-xr-x 4 root root 4096 Apr 3 13:30 minio_data drwxr-xr-x 2 root root 4096 Sep 11 2024 mnt drwxr-xr-x 1 root root 4096 Jan 14 12:08 opt -rw-r--r-- 1 root root 0 Feb 14 2024 .package-cache-mutate drwxrwxr-x 2 1000 1000 4096 Apr 3 13:30 package_folder dr-xr-xr-x 313 root root 0 Apr 3 13:30 proc drwxrwxr-x 17 1000 1000 4096 Apr 3 13:27 repo -rw-rw-r-- 1 root root 863 Jan 15 12:27 requirements.txt drwx------ 1 root root 4096 Apr 3 13:30 root drwxr-xr-x 1 root root 4096 Apr 3 13:30 run lrwxrwxrwx 1 root root 8 Sep 11 2024 sbin -> usr/sbin -rwxrwxr-x 1 root root 10851 Jan 14 12:07 setup_export_logs.sh drwxr-xr-x 2 root root 4096 Sep 11 2024 srv dr-xr-xr-x 13 root root 0 Apr 3 13:30 sys drwxrwxr-x 2 1000 1000 4096 Apr 3 13:32 test_output drwxrwxrwt 1 root root 4096 Apr 3 13:53 tmp drwxr-xr-x 1 root root 4096 Sep 11 2024 usr drwxr-xr-x 1 root root 4096 Sep 11 2024 var + echo 'Files in root directory' + ls -la / Files in root directory total 127160 drwxr-xr-x 1 root root 4096 Apr 3 13:30 . drwxr-xr-x 1 root root 4096 Apr 3 13:30 .. lrwxrwxrwx 1 root root 7 Sep 11 2024 bin -> usr/bin drwxr-xr-x 2 root root 4096 Apr 18 2022 boot drwxr-xr-x 14 root root 3840 Apr 3 13:30 dev -rwxr-xr-x 1 root root 0 Apr 3 13:30 .dockerenv drwxr-xr-x 1 root root 4096 Apr 3 13:30 etc drwxr-xr-x 2 root root 4096 Apr 18 2022 home lrwxrwxrwx 1 root root 7 Sep 11 2024 lib -> usr/lib lrwxrwxrwx 1 root root 9 Sep 11 2024 lib32 -> usr/lib32 lrwxrwxrwx 1 root root 9 Sep 11 2024 lib64 -> usr/lib64 lrwxrwxrwx 1 root root 10 Sep 11 2024 libx32 -> usr/libx32 -rwxr-xr-x 1 root root 26927256 Jan 15 12:53 mc drwxr-xr-x 2 root root 4096 Sep 11 2024 media -rwxr-xr-x 1 root root 103174296 Jan 15 12:53 minio drwxr-xr-x 4 root root 4096 Apr 3 13:30 minio_data drwxr-xr-x 2 root root 4096 Sep 11 2024 mnt drwxr-xr-x 1 root root 4096 Jan 14 12:08 opt -rw-r--r-- 1 root root 0 Feb 14 2024 .package-cache-mutate drwxrwxr-x 2 1000 1000 4096 Apr 3 13:30 package_folder dr-xr-xr-x 313 root root 0 Apr 3 13:30 proc drwxrwxr-x 17 1000 1000 4096 Apr 3 13:27 repo -rw-rw-r-- 1 root root 863 Jan 15 12:27 requirements.txt drwx------ 1 root root 4096 Apr 3 13:30 root drwxr-xr-x 1 root root 4096 Apr 3 13:30 run lrwxrwxrwx 1 root root 8 Sep 11 2024 sbin -> usr/sbin -rwxrwxr-x 1 root root 10851 Jan 14 12:07 setup_export_logs.sh drwxr-xr-x 2 root root 4096 Sep 11 2024 srv dr-xr-xr-x 13 root root 0 Apr 3 13:30 sys drwxrwxr-x 2 1000 1000 4096 Apr 3 13:32 test_output drwxrwxrwt 1 root root 4096 Apr 3 13:53 tmp drwxr-xr-x 1 root root 4096 Sep 11 2024 usr drwxr-xr-x 1 root root 4096 Sep 11 2024 var + /repo/tests/docker_scripts/process_functional_tests_result.py 2025-04-03 13:53:47,078 File /repo/tests/broken_tests.json with broken tests found 2025-04-03 13:53:47,078 Find files in result folder test_result.txt,run.log,minio.log 2025-04-03 13:53:47,080 Is flaky check: False 2025-04-03 13:53:47,080 Result parsed 2025-04-03 13:53:47,080 Result written File /repo/tests/analyzer_tech_debt.txt with broken tests found Broken tests in the list: 3 Broken tests in the list: 3 + sudo clickhouse stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 is running. Sent terminate signal to process with pid 346. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + [[ -n '' ]] + kill 319 + rg -Fa '' /var/log/clickhouse-server/clickhouse-server.log + : + zstd --threads=0 + rm /var/log/clickhouse-server/clickhouse-server.log + mv /var/log/clickhouse-server/stderr.log /test_output/ + [[ -n '' ]] + [[ -n '' ]] + collect_core_dumps + find . -type f -maxdepth 1 -name 'core.*' + read -r core