+ ln -s /usr/share/clickhouse-test/ci/stress.py /usr/bin/stress + ln -s /usr/share/clickhouse-test/clickhouse-test /usr/bin/clickhouse-test + source /attach_gdb.lib ++ source /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 + source /stress_tests.lib ++ OK='\tOK\t\N\t' ++ FAIL='\tFAIL\t\N\t' ++ FAILURE_CONTEXT_LINES=100 ++ FAILURE_CONTEXT_MAX_LINE_WIDTH=300 + source /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 + install_packages package_folder + dpkg -i package_folder/clickhouse-common-static_24.8.14.10017.altinitytest+asan_amd64.deb Selecting previously unselected package clickhouse-common-static. (Reading database ... 48692 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static_24.8.14.10017.altinitytest+asan_amd64.deb ... Unpacking clickhouse-common-static (24.8.14.10017.altinitytest+asan) ... Setting up clickhouse-common-static (24.8.14.10017.altinitytest+asan) ... + dpkg -i package_folder/clickhouse-common-static-dbg_24.8.14.10017.altinitytest+asan_amd64.deb Selecting previously unselected package clickhouse-common-static-dbg. (Reading database ... 48719 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static-dbg_24.8.14.10017.altinitytest+asan_amd64.deb ... Unpacking clickhouse-common-static-dbg (24.8.14.10017.altinitytest+asan) ... Setting up clickhouse-common-static-dbg (24.8.14.10017.altinitytest+asan) ... + dpkg -i package_folder/clickhouse-server_24.8.14.10017.altinitytest+asan_amd64.deb Selecting previously unselected package clickhouse-server. (Reading database ... 48726 files and directories currently installed.) Preparing to unpack .../clickhouse-server_24.8.14.10017.altinitytest+asan_amd64.deb ... Unpacking clickhouse-server (24.8.14.10017.altinitytest+asan) ... Setting up clickhouse-server (24.8.14.10017.altinitytest+asan) ... 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.8.14.10017.altinitytest+asan_amd64.deb Selecting previously unselected package clickhouse-client. (Reading database ... 48743 files and directories currently installed.) Preparing to unpack .../clickhouse-client_24.8.14.10017.altinitytest+asan_amd64.deb ... Unpacking clickhouse-client (24.8.14.10017.altinitytest+asan) ... Setting up clickhouse-client (24.8.14.10017.altinitytest+asan) ... + export THREAD_FUZZER_CPU_TIME_PERIOD_US=1000 + THREAD_FUZZER_CPU_TIME_PERIOD_US=1000 + export THREAD_FUZZER_SLEEP_PROBABILITY=0.1 + THREAD_FUZZER_SLEEP_PROBABILITY=0.1 + export THREAD_FUZZER_SLEEP_TIME_US_MAX=100000 + THREAD_FUZZER_SLEEP_TIME_US_MAX=100000 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01 + THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01 + export THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01 + THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01 + export ZOOKEEPER_FAULT_INJECTION=1 + ZOOKEEPER_FAULT_INJECTION=1 + configure + export USE_DATABASE_ORDINARY=1 + USE_DATABASE_ORDINARY=1 + export EXPORT_S3_STORAGE_POLICIES=1 + EXPORT_S3_STORAGE_POLICIES=1 + /usr/share/clickhouse-test/config/install.sh + DEST_SERVER_PATH=/etc/clickhouse-server + DEST_CLIENT_PATH=/etc/clickhouse-client +++ dirname /usr/share/clickhouse-test/config/install.sh ++ cd /usr/share/clickhouse-test/config ++ pwd -P Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + SRC_PATH=/usr/share/clickhouse-test/config + echo 'Going to install test configs from /usr/share/clickhouse-test/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 /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_catalog_drop_table_concurrency.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/grpc_protocol.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/block_number.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/serverwide_trace_collector.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/rocksdb.xml /etc/clickhouse-server/config.d/ + '[' /etc/clickhouse-server = /etc/clickhouse-server ']' + ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/ + ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + rm -f /etc/clickhouse-server/config.d/zookeeper.xml + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/ + [[ -n '' ]] + rm -f /etc/clickhouse-server/config.d/cannot_allocate_thread_injection.xml + value=1 + sed --follow-symlinks -i 's|[01]|1|' /etc/clickhouse-server/config.d/keeper_port.xml + value=16410624 + sed --follow-symlinks -i 's|[[:digit:]]\+|16410624|' /etc/clickhouse-server/config.d/keeper_port.xml + value=50163712 + sed --follow-symlinks -i 's|[[:digit:]]\+|50163712|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/ + [[ '' == \1 ]] + [[ '' == \1 ]] + [[ -n 1 ]] + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|100000|10000|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value filtered_list keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value multi_read keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value check_not_exists keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value create_if_not_exists keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value use_compression zookeeper_fault_injection + value=1 + sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + randomize_config_boolean_value enable_block_number_column block_number + value=0 + sudo cat /etc/clickhouse-server/config.d/block_number.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml + randomize_config_boolean_value enable_block_offset_column block_number + value=0 + sudo cat /etc/clickhouse-server/config.d/block_number.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml + echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\''' + export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + sudo chown root: /var/lib/clickhouse + local total_mem ++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo + total_mem=32086444 + total_mem=32856518656 + max_server_memory_usage_to_ram_ratio=0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat Setting max_server_memory_usage_to_ram_ratio to 0.5 Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G + local max_users_mem + max_users_mem=9856955596 + echo 'Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G' + cat + cat + ./setup_minio.sh stateless + azurite-blob --blobHost 0.0.0.0 --blobPort 10000 --debug /azurite_log + export MINIO_ROOT_USER=clickhouse + MINIO_ROOT_USER=clickhouse + export MINIO_ROOT_PASSWORD=clickhouse + MINIO_ROOT_PASSWORD=clickhouse + main stateless + local query_dir ++ check_arg stateless ++ local query_dir ++ '[' '!' 1 -eq 1 ']' ++ case "$1" in ++ query_dir=0_stateless ++ echo 0_stateless + query_dir=0_stateless + '[' '!' -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 + ./minio server --address :11111 ./minio_data + local counter=0 + 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 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:43463 http://127.0.0.1:43463 Docs: https://min.io/docs/minio/linux/index.html + counter=1 + curl --silent --verbose http://localhost:11111 + grep AccessDenied AccessDeniedAccess Denied./1834C0E5D80A5FFF7dc7eb22d3288ec80374614e9088e31d3668a6922ead55932dd2a8e56373820f + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 274 root 8u IPv4 34133 0t0 TCP localhost:11111 (LISTEN) minio 274 root 9u IPv6 34134 0t0 TCP *:11111 (LISTEN) minio 274 root 10u IPv6 34135 0t0 TCP localhost:11111 (LISTEN) + sleep 5 + setup_minio stateless + local test_type=stateless + ./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`. + '[' stateless = stateless ']' + ./mc anonymous set public clickminio/test Access permission for `clickminio/test` is set to `public` + upload_data 0_stateless /usr/share/clickhouse-test + local query_dir=0_stateless + local test_path=/usr/share/clickhouse-test + local data_path=/usr/share/clickhouse-test/queries/0_stateless/data_minio + '[' -d /usr/share/clickhouse-test/queries/0_stateless/data_minio ']' + ./mc cp --recursive /usr/share/clickhouse-test/queries/0_stateless/data_minio/ clickminio/test/ `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl` -> `clickminio/test/02366_data.jsonl` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet` -> `clickminio/test/02731.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02876.parquet` -> `clickminio/test/02876.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive1.zip` -> `clickminio/test/03036_archive1.zip` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive1.tar` -> `clickminio/test/03036_archive1.tar` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow` -> `clickminio/test/02731.arrow` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive2.tar` -> `clickminio/test/03036_archive2.tar` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive2.zip` -> `clickminio/test/03036_archive2.zip` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive3.tar.gz` -> `clickminio/test/03036_archive3.tar.gz` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_compressed_file_archive.zip` -> `clickminio/test/03036_compressed_file_archive.zip` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_json_archive.zip` -> `clickminio/test/03036_json_archive.zip` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv` -> `clickminio/test/a.tsv` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv` -> `clickminio/test/b.tsv` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv` -> `clickminio/test/c.tsv` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/hive_partitioning/column0=Elizabeth/column1=Gordon/sample.parquet` -> `clickminio/test/hive_partitioning/column0=Elizabeth/column1=Gordon/sample.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/hive_partitioning/column0=Elizabeth/column1=Schmidt/sample.parquet` -> `clickminio/test/hive_partitioning/column0=Elizabeth/column1=Schmidt/sample.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/hive_partitioning/column0=Elizabeth/sample.parquet` -> `clickminio/test/hive_partitioning/column0=Elizabeth/sample.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/hive_partitioning/non_existing_column=Elizabeth/sample.parquet` -> `clickminio/test/hive_partitioning/non_existing_column=Elizabeth/sample.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/json_data` -> `clickminio/test/json_data` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv` -> `clickminio/test/tsv_with_header.tsv` Total: 5.42 MiB, Transferred: 5.42 MiB, Speed: 134.82 MiB/s + setup_aws_credentials + local minio_root_user=clickhouse + local minio_root_password=clickhouse + mkdir -p /root/.aws + cat + 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 + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root 127.0.0.1 - - [09/Apr/2025:20:37:43 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 404 - 127.0.0.1 - - [09/Apr/2025:20:37:43 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [09/Apr/2025:20:37:43 +0000] "PUT /devstoreaccount1/cont/wfbrrzaykkjfzmvctlfbiwoogeuhumal HTTP/1.1" 201 - + sleep 0.5 127.0.0.1 - - [09/Apr/2025:20:37:43 +0000] "GET /devstoreaccount1/cont/wfbrrzaykkjfzmvctlfbiwoogeuhumal HTTP/1.1" 206 4 127.0.0.1 - - [09/Apr/2025:20:37:43 +0000] "GET /devstoreaccount1/cont/wfbrrzaykkjfzmvctlfbiwoogeuhumal HTTP/1.1" 206 2 127.0.0.1 - - [09/Apr/2025:20:37:43 +0000] "DELETE /devstoreaccount1/cont/wfbrrzaykkjfzmvctlfbiwoogeuhumal HTTP/1.1" 202 - + counter=11 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ [[ hxB =~ e ]] ++ set_e=false ++ set +e ++ local total_retries=5 ++ shift ++ local retry=0 ++ '[' 0 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ false ++ return + IS_ASAN=1 + [[ 1 = \1 ]] + echo 'ASAN build detected. Not using gdb since it disables LeakSanitizer detections' ASAN build detected. Not using gdb since it disables LeakSanitizer detections + setup_logs_replication + set +x File /tmp/export-logs-config.sh does not exist, do not setup + clickhouse-client --query 'CREATE DATABASE datasets' + clickhouse-client --multiquery + clickhouse-client --query 'SHOW TABLES FROM datasets' hits_v1 visits_v1 + clickhouse-client --query 'CREATE DATABASE IF NOT EXISTS test' + stop_server + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=417 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 417. The process with pid = 417 is running. Sent terminate signal to process with pid 417. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 417. The process with pid = 417 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 417. The process with pid = 417 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 417. The process with pid = 417 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 417. The process with pid = 417 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 417. The process with pid = 417 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 417. The process with pid = 417 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 417. The process with pid = 417 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 417. The process with pid = 417 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 417. The process with pid = 417 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.initial.log + cache_policy= + '[' 1 -eq 1 ']' + cache_policy=SLRU + echo 'Using cache policy: SLRU' + '[' SLRU = SLRU ']' Using cache policy: 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 + sudo cat /etc/clickhouse-server/users.d/stress_tests_overrides.xml cat: /etc/clickhouse-server/users.d/stress_tests_overrides.xml: No such file or directory + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 127.0.0.1 - - [09/Apr/2025:20:38:23 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - 127.0.0.1 - - [09/Apr/2025:20:38:23 +0000] "PUT /devstoreaccount1/cont/jdflofsglrbrlikpeywafraueljhoeju HTTP/1.1" 201 - 127.0.0.1 - - [09/Apr/2025:20:38:23 +0000] "GET /devstoreaccount1/cont/jdflofsglrbrlikpeywafraueljhoeju HTTP/1.1" 206 4 127.0.0.1 - - [09/Apr/2025:20:38:23 +0000] "GET /devstoreaccount1/cont/jdflofsglrbrlikpeywafraueljhoeju HTTP/1.1" 206 2 127.0.0.1 - - [09/Apr/2025:20:38:23 +0000] "DELETE /devstoreaccount1/cont/jdflofsglrbrlikpeywafraueljhoeju HTTP/1.1" 202 - + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 15 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=16 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 16 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=17 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 17 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=18 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 18 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=19 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 19 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=20 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ [[ hxB =~ e ]] ++ set_e=false ++ set +e ++ local total_retries=5 ++ shift ++ local retry=0 ++ '[' 0 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ false ++ return + IS_ASAN=1 + [[ 1 = \1 ]] + echo 'ASAN build detected. Not using gdb since it disables LeakSanitizer detections' ASAN build detected. Not using gdb since it disables LeakSanitizer detections + clickhouse-client --query 'SHOW TABLES FROM datasets' hits_v1 visits_v1 + clickhouse-client --query 'SHOW TABLES FROM test' + [[ '' == \1 ]] + [[ '' == \1 ]] + TEMP_POLICY=default + 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='\''default'\''' + clickhouse-client --query 'CREATE TABLE test.hits (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='\''default'\''' + clickhouse-client --query 'CREATE TABLE test.visits (CounterID UInt32, StartDate Date, Sign Int8, IsNew UInt8, VisitID UInt64, UserID UInt64, StartTime DateTime, Duration UInt32, UTCStartTime DateTime, PageViews Int32, Hits Int32, IsBounce UInt8, Referer String, StartURL String, RefererDomain String, StartURLDomain String, EndURL String, LinkURL String, IsDownload UInt8, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, PlaceID Int32, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32), RefererRegions Array(UInt32), IsYandex UInt8, GoalReachesDepth Int32, GoalReachesURL Int32, GoalReachesAny Int32, SocialSourceNetworkID UInt8, SocialSourcePage String, MobilePhoneModel String, ClientEventTime DateTime, RegionID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RemoteIP UInt32, RemoteIP6 FixedString(16), IPNetworkID UInt32, SilverlightVersion3 UInt32, CodeVersion UInt32, ResolutionWidth UInt16, ResolutionHeight UInt16, UserAgentMajor UInt16, UserAgentMinor UInt16, WindowClientWidth UInt16, WindowClientHeight UInt16, SilverlightVersion2 UInt8, SilverlightVersion4 UInt16, FlashVersion3 UInt16, FlashVersion4 UInt16, ClientTimeZone Int16, OS UInt8, UserAgent UInt8, ResolutionDepth UInt8, FlashMajor UInt8, FlashMinor UInt8, NetMajor UInt8, NetMinor UInt8, MobilePhone UInt8, SilverlightVersion1 UInt8, Age UInt8, Sex UInt8, Income UInt8, JavaEnable UInt8, CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, BrowserLanguage UInt16, BrowserCountry UInt16, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), Params Array(String), Goals Nested(ID UInt32, Serial UInt32, EventTime DateTime, Price Int64, OrderID String, CurrencyID UInt32), WatchIDs Array(UInt64), ParamSumPrice Int64, ParamCurrency FixedString(3), ParamCurrencyID UInt16, ClickLogID UInt64, ClickEventID Int32, ClickGoodEvent Int32, ClickEventTime DateTime, ClickPriorityID Int32, ClickPhraseID Int32, ClickPageID Int32, ClickPlaceID Int32, ClickTypeID Int32, ClickResourceID Int32, ClickCost UInt32, ClickClientIP UInt32, ClickDomainID UInt32, ClickURL String, ClickAttempt UInt8, ClickOrderID UInt32, ClickBannerID UInt32, ClickMarketCategoryID UInt32, ClickMarketPP UInt32, ClickMarketCategoryName String, ClickMarketPPName String, ClickAWAPSCampaignName String, ClickPageName String, ClickTargetType UInt16, ClickTargetPhraseID UInt64, ClickContextType UInt8, ClickSelectType Int8, ClickOptions String, ClickGroupBannerID Int32, OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, FirstVisit DateTime, PredLastVisit Date, LastVisit Date, TotalVisits UInt32, TraficSource Nested(ID Int8, SearchEngineID UInt16, AdvEngineID UInt8, PlaceID UInt16, SocialSourceNetworkID UInt8, Domain String, SearchPhrase String, SocialSourcePage String), Attendance FixedString(16), CLID UInt32, YCLID UInt64, NormalizedRefererHash UInt64, SearchPhraseHash UInt64, RefererDomainHash UInt64, NormalizedStartURLHash UInt64, StartURLDomainHash UInt64, NormalizedEndURLHash UInt64, TopLevelDomain UInt64, URLScheme UInt64, OpenstatServiceNameHash UInt64, OpenstatCampaignIDHash UInt64, OpenstatAdIDHash UInt64, OpenstatSourceIDHash UInt64, UTMSourceHash UInt64, UTMMediumHash UInt64, UTMCampaignHash UInt64, UTMContentHash UInt64, UTMTermHash UInt64, FromHash UInt64, WebVisorEnabled UInt8, WebVisorActivity UInt32, ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64), Market Nested(Type UInt8, GoalID UInt32, OrderID String, OrderPrice Int64, PP UInt32, DirectPlaceID UInt32, DirectOrderID UInt32, DirectBannerID UInt32, GoodID String, GoodName String, GoodQuantity Int32, GoodPrice Int64), IslandID FixedString(16)) ENGINE = CollapsingMergeTree(Sign) PARTITION BY toYYYYMM(StartDate) ORDER BY (CounterID, StartDate, intHash32(UserID), VisitID) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''default'\''' + clickhouse-client --query 'INSERT INTO test.hits_s3 SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16' Received exception from server (version 24.8.14): Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (for user) exceeded: would use 9.18 GiB (attempt to allocate chunk of 1301504 bytes), maximum: 9.18 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.: (while reading column RemoteIP6): (while reading from part store/78e/78ebf6a1-d987-4579-b3ec-00c1a087b1f3/201403_1_1_2/ in table datasets.hits_v1 (78ebf6a1-d987-4579-b3ec-00c1a087b1f3) located on disk __tmp_internal_262634248876485800814430204900764312493 of type web, from mark 20 with max_rows_to_read = 8192): While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (MEMORY_LIMIT_EXCEEDED) (query: INSERT INTO test.hits_s3 SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16) + clickhouse-client --query 'INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16' Received exception from server (version 24.8.14): Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (for user) exceeded: would use 9.18 GiB (attempt to allocate chunk of 1081216 bytes), maximum: 9.18 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.: (avg_value_size_hint = 10.016845703125, avg_chars_size = 2.4202148437499997, limit = 8192): (while reading column UTMCampaign): (while reading from part store/78e/78ebf6a1-d987-4579-b3ec-00c1a087b1f3/201403_1_1_2/ in table datasets.hits_v1 (78ebf6a1-d987-4579-b3ec-00c1a087b1f3) located on disk __tmp_internal_262634248876485800814430204900764312493 of type web, from mark 496 with max_rows_to_read = 8192): While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (MEMORY_LIMIT_EXCEEDED) (query: INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16) + clickhouse-client --query 'INSERT INTO test.visits SELECT * FROM datasets.visits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16' + clickhouse-client --query 'DROP TABLE datasets.visits_v1 SYNC' + clickhouse-client --query 'DROP TABLE datasets.hits_v1 SYNC' + clickhouse-client --query 'SHOW TABLES FROM test' hits hits_s3 visits + clickhouse-client --query 'SYSTEM STOP THREAD FUZZER' + stop_server + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=1294 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1294. The process with pid = 1294 is running. Sent terminate signal to process with pid 1294. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1294. The process with pid = 1294 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1294. The process with pid = 1294 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1294. The process with pid = 1294 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1294. The process with pid = 1294 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1294. The process with pid = 1294 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1294. The process with pid = 1294 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1294. The process with pid = 1294 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1294. The process with pid = 1294 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1294. The process with pid = 1294 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1294. The process with pid = 1294 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + export RANDOMIZE_OBJECT_KEY_TYPE=1 + RANDOMIZE_OBJECT_KEY_TYPE=1 + export ZOOKEEPER_FAULT_INJECTION=1 + ZOOKEEPER_FAULT_INJECTION=1 + export THREAD_POOL_FAULT_INJECTION=1 + THREAD_POOL_FAULT_INJECTION=1 + configure + export USE_DATABASE_ORDINARY=1 + USE_DATABASE_ORDINARY=1 + export EXPORT_S3_STORAGE_POLICIES=1 + EXPORT_S3_STORAGE_POLICIES=1 + /usr/share/clickhouse-test/config/install.sh + DEST_SERVER_PATH=/etc/clickhouse-server + DEST_CLIENT_PATH=/etc/clickhouse-client +++ dirname /usr/share/clickhouse-test/config/install.sh ++ cd /usr/share/clickhouse-test/config ++ pwd -P Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + SRC_PATH=/usr/share/clickhouse-test/config + echo 'Going to install test configs from /usr/share/clickhouse-test/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 /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_catalog_drop_table_concurrency.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/grpc_protocol.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/block_number.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/serverwide_trace_collector.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/rocksdb.xml /etc/clickhouse-server/config.d/ + '[' /etc/clickhouse-server = /etc/clickhouse-server ']' + ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/ + ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + rm -f /etc/clickhouse-server/config.d/zookeeper.xml + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/config.d/cannot_allocate_thread_injection.xml /etc/clickhouse-server/config.d/ + value=1 + sed --follow-symlinks -i 's|[01]|1|' /etc/clickhouse-server/config.d/keeper_port.xml + value=39809024 + sed --follow-symlinks -i 's|[[:digit:]]\+|39809024|' /etc/clickhouse-server/config.d/keeper_port.xml + value=22151168 + sed --follow-symlinks -i 's|[[:digit:]]\+|22151168|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/ + [[ '' == \1 ]] + [[ '' == \1 ]] + [[ -n 1 ]] + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|100000|10000|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value filtered_list keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value multi_read keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value check_not_exists keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value create_if_not_exists keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value use_compression zookeeper_fault_injection + value=0 + sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + randomize_config_boolean_value enable_block_number_column block_number + value=1 + sudo cat /etc/clickhouse-server/config.d/block_number.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml + randomize_config_boolean_value enable_block_offset_column block_number + value=0 + sudo cat /etc/clickhouse-server/config.d/block_number.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml + echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\''' + export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + sudo chown root: /var/lib/clickhouse + local total_mem ++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo + total_mem=32086444 + total_mem=32856518656 + max_server_memory_usage_to_ram_ratio=0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat Setting max_server_memory_usage_to_ram_ratio to 0.5 + local max_users_mem + max_users_mem=9856955596 Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G + echo 'Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G' + cat + cat + [[ '' == \1 ]] + [[ '' == \1 ]] + sudo cat /etc/clickhouse-server/config.d/logger_trace.xml + sed 's|trace|test|' + mv /etc/clickhouse-server/config.d/logger_trace.xml.tmp /etc/clickhouse-server/config.d/logger_trace.xml + '[' 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 ++ date +%-d + '[' 1 -eq 1 ']' + sudo echo 'true' + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' 127.0.0.1 - - [09/Apr/2025:20:40:58 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 127.0.0.1 - - [09/Apr/2025:20:40:58 +0000] "PUT /devstoreaccount1/cont/szjbvxnazyfcahsyyxrkbjyorubzqmze HTTP/1.1" 201 - + '[' 9 -gt 120 ']' + clickhouse start --user root 127.0.0.1 - - [09/Apr/2025:20:40:58 +0000] "GET /devstoreaccount1/cont/szjbvxnazyfcahsyyxrkbjyorubzqmze HTTP/1.1" 206 4 127.0.0.1 - - [09/Apr/2025:20:40:58 +0000] "GET /devstoreaccount1/cont/szjbvxnazyfcahsyyxrkbjyorubzqmze HTTP/1.1" 206 2 127.0.0.1 - - [09/Apr/2025:20:40:58 +0000] "DELETE /devstoreaccount1/cont/szjbvxnazyfcahsyyxrkbjyorubzqmze HTTP/1.1" 202 - + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 15 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=16 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 16 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=17 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 17 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=18 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 18 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=19 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 19 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=20 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 20 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=21 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ [[ hxB =~ e ]] ++ set_e=false ++ set +e ++ local total_retries=5 ++ shift ++ local retry=0 ++ '[' 0 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' Received exception from server (version 24.8.14): Code: 439. DB::Exception: Received from localhost:9000. DB::Exception: Cannot schedule a task: failed to start the thread (threads=2, jobs=2). (CANNOT_SCHEDULE_TASK) (query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value)) ++ retry=1 ++ sleep 5 ++ '[' 1 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ false ++ return ASAN build detected. Not using gdb since it disables LeakSanitizer detections + IS_ASAN=1 + [[ 1 = \1 ]] + echo 'ASAN build detected. Not using gdb since it disables LeakSanitizer detections' + stress --hung-check --drop-databases --output-folder test_output --skip-func-tests '' --global-time-limit 1200 2025-04-09 22:41:14,759 Run func tests '/usr/bin/clickhouse-test --client-option ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-04-09 22:41:15,260 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_1 --client-option join_use_nulls=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-04-09 22:41:15,762 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_2', 's1', 'r1')" --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-04-09 22:41:16,263 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_3 --client-option join_algorithm='partial_merge' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-04-09 22:41:16,765 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-04-09 22:41:17,266 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_5', 's1', 'r1')" --database=test_5 --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='full_sorting_merge' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-04-09 22:41:17,767 Run func tests '/usr/bin/clickhouse-test --order=random --client-option use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 ignore_drop_queries_probability=0.5 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 ' 2025-04-09 22:41:18,269 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_7 --client-option join_use_nulls=1 join_algorithm='grace_hash' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-04-09 22:41:18,770 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_8', 's1', 'r1')" --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-04-09 22:41:19,272 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_9 --client-option join_algorithm='auto' max_rows_in_join=1000 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 ' 2025-04-09 22:41:19,773 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 optimize_trivial_approximate_count_query=1 http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-04-09 22:41:20,275 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_11', 's1', 'r1')" --database=test_11 --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 optimize_trivial_approximate_count_query=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-04-09 22:41:20,776 Run func tests '/usr/bin/clickhouse-test --order=random --client-option implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-04-09 22:41:21,277 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_13 --client-option join_use_nulls=1 join_algorithm='partial_merge' use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 ' 2025-04-09 22:41:21,778 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_14', 's1', 'r1')" --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' http_make_head_request=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-04-09 22:41:22,279 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_merge' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 ' 2025-04-09 22:41:22,781 Will wait functests to finish 2025-04-09 22:41:22,781 Finished 7 from 16 processes 2025-04-09 22:41:27,786 Finished 8 from 16 processes 2025-04-09 22:41:32,788 Finished 8 from 16 processes 2025-04-09 22:41:37,792 Finished 8 from 16 processes 2025-04-09 22:41:42,796 Finished 8 from 16 processes 2025-04-09 22:41:47,800 Finished 8 from 16 processes 2025-04-09 22:41:52,804 Finished 8 from 16 processes 2025-04-09 22:41:57,808 Finished 8 from 16 processes 2025-04-09 22:42:02,812 Finished 8 from 16 processes 2025-04-09 22:42:07,816 Finished 8 from 16 processes 2025-04-09 22:42:12,817 Finished 8 from 16 processes 2025-04-09 22:42:17,821 Finished 8 from 16 processes 2025-04-09 22:42:22,823 Finished 8 from 16 processes 2025-04-09 22:42:27,828 Finished 8 from 16 processes 2025-04-09 22:42:32,833 Finished 8 from 16 processes 2025-04-09 22:42:37,836 Finished 8 from 16 processes 2025-04-09 22:42:42,840 Finished 8 from 16 processes 2025-04-09 22:42:47,844 Finished 8 from 16 processes 2025-04-09 22:42:52,847 Finished 9 from 16 processes 2025-04-09 22:42:57,852 Finished 9 from 16 processes 2025-04-09 22:43:02,856 Finished 9 from 16 processes 2025-04-09 22:43:07,860 Finished 9 from 16 processes 2025-04-09 22:43:12,864 Finished 9 from 16 processes 2025-04-09 22:43:17,869 Finished 9 from 16 processes 2025-04-09 22:43:22,872 Finished 9 from 16 processes 2025-04-09 22:43:27,877 Finished 10 from 16 processes 2025-04-09 22:43:32,880 Finished 10 from 16 processes 2025-04-09 22:43:37,884 Finished 10 from 16 processes 2025-04-09 22:43:42,888 Finished 10 from 16 processes 2025-04-09 22:43:47,893 Finished 10 from 16 processes 2025-04-09 22:43:52,899 Finished 10 from 16 processes 2025-04-09 22:43:57,904 Finished 10 from 16 processes 2025-04-09 22:44:02,908 Finished 10 from 16 processes 2025-04-09 22:44:07,913 Finished 10 from 16 processes 2025-04-09 22:44:12,917 Finished 10 from 16 processes 2025-04-09 22:44:17,920 Finished 10 from 16 processes 2025-04-09 22:44:22,924 Finished 10 from 16 processes 2025-04-09 22:44:27,924 Finished 10 from 16 processes 2025-04-09 22:44:32,930 Finished 10 from 16 processes 2025-04-09 22:44:37,932 Finished 10 from 16 processes 2025-04-09 22:44:42,936 Finished 10 from 16 processes 2025-04-09 22:44:47,940 Finished 10 from 16 processes 2025-04-09 22:44:52,944 Finished 10 from 16 processes 2025-04-09 22:44:57,948 Finished 10 from 16 processes 2025-04-09 22:45:02,952 Finished 10 from 16 processes 2025-04-09 22:45:07,954 Finished 10 from 16 processes 2025-04-09 22:45:12,956 Finished 10 from 16 processes 2025-04-09 22:45:17,960 Finished 10 from 16 processes 2025-04-09 22:45:22,964 Finished 10 from 16 processes 2025-04-09 22:45:27,968 Finished 10 from 16 processes 2025-04-09 22:45:32,972 Finished 10 from 16 processes 2025-04-09 22:45:37,976 Finished 10 from 16 processes 2025-04-09 22:45:42,980 Finished 10 from 16 processes 2025-04-09 22:45:47,982 Finished 11 from 16 processes 2025-04-09 22:45:52,988 Finished 11 from 16 processes 2025-04-09 22:45:57,990 Finished 11 from 16 processes 2025-04-09 22:46:02,992 Finished 11 from 16 processes 2025-04-09 22:46:07,996 Finished 11 from 16 processes 2025-04-09 22:46:13,001 Finished 11 from 16 processes 2025-04-09 22:46:18,002 Finished 11 from 16 processes 2025-04-09 22:46:23,004 Finished 11 from 16 processes 2025-04-09 22:46:28,008 Finished 11 from 16 processes 2025-04-09 22:46:33,012 Finished 11 from 16 processes 2025-04-09 22:46:38,016 Finished 11 from 16 processes 2025-04-09 22:46:43,021 Finished 11 from 16 processes 2025-04-09 22:46:48,024 Finished 11 from 16 processes 2025-04-09 22:46:53,028 Finished 11 from 16 processes 2025-04-09 22:46:58,032 Finished 11 from 16 processes 2025-04-09 22:47:03,036 Finished 11 from 16 processes 2025-04-09 22:47:08,041 Finished 11 from 16 processes 2025-04-09 22:47:13,044 Finished 11 from 16 processes 2025-04-09 22:47:18,049 Finished 11 from 16 processes 2025-04-09 22:47:23,051 Finished 11 from 16 processes 2025-04-09 22:47:28,056 Finished 11 from 16 processes 2025-04-09 22:47:33,060 Finished 11 from 16 processes 2025-04-09 22:47:38,064 Finished 11 from 16 processes 2025-04-09 22:47:43,068 Finished 11 from 16 processes 2025-04-09 22:47:48,070 Finished 11 from 16 processes 2025-04-09 22:47:53,075 Finished 11 from 16 processes 2025-04-09 22:47:58,081 Finished 11 from 16 processes 2025-04-09 22:48:03,084 Finished 11 from 16 processes 2025-04-09 22:48:08,088 Finished 11 from 16 processes 2025-04-09 22:48:13,092 Finished 11 from 16 processes 2025-04-09 22:48:18,096 Finished 11 from 16 processes 2025-04-09 22:48:23,101 Finished 11 from 16 processes 2025-04-09 22:48:28,106 Finished 11 from 16 processes 2025-04-09 22:48:33,108 Finished 11 from 16 processes 2025-04-09 22:48:38,112 Finished 11 from 16 processes 2025-04-09 22:48:43,116 Finished 11 from 16 processes 2025-04-09 22:48:48,116 Finished 11 from 16 processes 2025-04-09 22:48:53,121 Finished 11 from 16 processes 2025-04-09 22:48:58,127 Finished 11 from 16 processes 2025-04-09 22:49:03,132 Finished 11 from 16 processes 2025-04-09 22:49:08,136 Finished 11 from 16 processes 2025-04-09 22:49:13,137 Finished 11 from 16 processes 2025-04-09 22:49:18,140 Finished 11 from 16 processes 2025-04-09 22:49:23,145 Finished 11 from 16 processes 2025-04-09 22:49:28,150 Finished 11 from 16 processes 2025-04-09 22:49:33,156 Finished 11 from 16 processes 2025-04-09 22:49:38,159 Finished 11 from 16 processes 2025-04-09 22:49:43,164 Finished 11 from 16 processes 2025-04-09 22:49:48,166 Finished 11 from 16 processes 2025-04-09 22:49:53,168 Finished 11 from 16 processes 2025-04-09 22:49:58,172 Finished 11 from 16 processes 2025-04-09 22:50:03,177 Finished 11 from 16 processes 2025-04-09 22:50:08,180 Finished 11 from 16 processes 2025-04-09 22:50:13,185 Finished 11 from 16 processes 2025-04-09 22:50:18,188 Finished 11 from 16 processes 2025-04-09 22:50:23,191 Finished 11 from 16 processes 2025-04-09 22:50:28,193 Finished 11 from 16 processes 2025-04-09 22:50:33,198 Finished 11 from 16 processes 2025-04-09 22:50:38,200 Finished 11 from 16 processes 2025-04-09 22:50:43,205 Finished 11 from 16 processes 2025-04-09 22:50:48,208 Finished 11 from 16 processes 2025-04-09 22:50:53,213 Finished 11 from 16 processes 2025-04-09 22:50:58,216 Finished 11 from 16 processes 2025-04-09 22:51:03,219 Finished 11 from 16 processes 2025-04-09 22:51:08,224 Finished 11 from 16 processes 2025-04-09 22:51:13,228 Finished 11 from 16 processes 2025-04-09 22:51:18,232 Finished 11 from 16 processes 2025-04-09 22:51:23,236 Finished 11 from 16 processes 2025-04-09 22:51:28,240 Finished 11 from 16 processes 2025-04-09 22:51:33,245 Finished 11 from 16 processes 2025-04-09 22:51:38,248 Finished 11 from 16 processes 2025-04-09 22:51:43,253 Finished 11 from 16 processes 2025-04-09 22:51:48,258 Finished 11 from 16 processes 2025-04-09 22:51:53,260 Finished 11 from 16 processes 2025-04-09 22:51:58,264 Finished 11 from 16 processes 2025-04-09 22:52:03,269 Finished 11 from 16 processes 2025-04-09 22:52:08,272 Finished 11 from 16 processes 2025-04-09 22:52:13,275 Finished 11 from 16 processes 2025-04-09 22:52:18,280 Finished 11 from 16 processes 2025-04-09 22:52:23,284 Finished 11 from 16 processes 2025-04-09 22:52:28,288 Finished 11 from 16 processes 2025-04-09 22:52:33,289 Finished 11 from 16 processes 2025-04-09 22:52:38,292 Finished 11 from 16 processes 2025-04-09 22:52:43,296 Finished 11 from 16 processes 2025-04-09 22:52:48,301 Finished 11 from 16 processes 2025-04-09 22:52:53,304 Finished 11 from 16 processes 2025-04-09 22:52:58,308 Finished 11 from 16 processes 2025-04-09 22:53:03,312 Finished 11 from 16 processes 2025-04-09 22:53:08,313 Finished 11 from 16 processes 2025-04-09 22:53:13,316 Finished 11 from 16 processes 2025-04-09 22:53:18,320 Finished 11 from 16 processes 2025-04-09 22:53:23,325 Finished 11 from 16 processes 2025-04-09 22:53:28,330 Finished 11 from 16 processes 2025-04-09 22:53:33,335 Finished 11 from 16 processes 2025-04-09 22:53:38,340 Finished 11 from 16 processes 2025-04-09 22:53:43,344 Finished 11 from 16 processes 2025-04-09 22:53:48,348 Finished 11 from 16 processes 2025-04-09 22:53:53,351 Finished 11 from 16 processes 2025-04-09 22:53:58,356 Finished 11 from 16 processes 2025-04-09 22:54:03,357 Finished 11 from 16 processes 2025-04-09 22:54:08,362 Finished 11 from 16 processes 2025-04-09 22:54:13,367 Finished 11 from 16 processes 2025-04-09 22:54:18,372 Finished 11 from 16 processes 2025-04-09 22:54:23,376 Finished 11 from 16 processes 2025-04-09 22:54:28,378 Finished 11 from 16 processes 2025-04-09 22:54:33,380 Finished 11 from 16 processes 2025-04-09 22:54:38,384 Finished 11 from 16 processes 2025-04-09 22:54:43,389 Finished 11 from 16 processes 2025-04-09 22:54:48,394 Finished 11 from 16 processes 2025-04-09 22:54:53,396 Finished 11 from 16 processes 2025-04-09 22:54:58,397 Finished 11 from 16 processes 2025-04-09 22:55:03,402 Finished 11 from 16 processes 2025-04-09 22:55:08,403 Finished 11 from 16 processes 2025-04-09 22:55:13,408 Finished 11 from 16 processes 2025-04-09 22:55:18,413 Finished 11 from 16 processes 2025-04-09 22:55:23,418 Finished 11 from 16 processes 2025-04-09 22:55:28,420 Finished 11 from 16 processes 2025-04-09 22:55:33,424 Finished 11 from 16 processes 2025-04-09 22:55:38,428 Finished 11 from 16 processes 2025-04-09 22:55:43,432 Finished 11 from 16 processes 2025-04-09 22:55:48,437 Finished 11 from 16 processes 2025-04-09 22:55:53,438 Finished 11 from 16 processes 2025-04-09 22:55:58,440 Finished 11 from 16 processes 2025-04-09 22:56:03,442 Finished 11 from 16 processes 2025-04-09 22:56:08,444 Finished 11 from 16 processes 2025-04-09 22:56:13,445 Finished 11 from 16 processes 2025-04-09 22:56:18,448 Finished 11 from 16 processes 2025-04-09 22:56:23,453 Finished 11 from 16 processes 2025-04-09 22:56:28,456 Finished 11 from 16 processes 2025-04-09 22:56:33,460 Finished 11 from 16 processes 2025-04-09 22:56:38,462 Finished 11 from 16 processes 2025-04-09 22:56:43,466 Finished 11 from 16 processes 2025-04-09 22:56:48,471 Finished 11 from 16 processes 2025-04-09 22:56:53,476 Finished 11 from 16 processes 2025-04-09 22:56:58,478 Finished 11 from 16 processes 2025-04-09 22:57:03,482 Finished 11 from 16 processes 2025-04-09 22:57:08,488 Finished 11 from 16 processes 2025-04-09 22:57:13,492 Finished 12 from 16 processes 2025-04-09 22:57:18,497 Finished 12 from 16 processes 2025-04-09 22:57:23,502 Finished 12 from 16 processes 2025-04-09 22:57:28,506 Finished 12 from 16 processes 2025-04-09 22:57:33,508 Finished 12 from 16 processes 2025-04-09 22:57:38,512 Finished 12 from 16 processes 2025-04-09 22:57:43,516 Finished 12 from 16 processes 2025-04-09 22:57:48,521 Finished 12 from 16 processes 2025-04-09 22:57:53,523 Finished 12 from 16 processes 2025-04-09 22:57:58,528 Finished 12 from 16 processes 2025-04-09 22:58:03,533 Finished 12 from 16 processes 2025-04-09 22:58:08,536 Finished 12 from 16 processes 2025-04-09 22:58:13,540 Finished 12 from 16 processes 2025-04-09 22:58:18,545 Finished 12 from 16 processes 2025-04-09 22:58:23,548 Finished 12 from 16 processes 2025-04-09 22:58:28,553 Finished 12 from 16 processes 2025-04-09 22:58:33,558 Finished 12 from 16 processes 2025-04-09 22:58:38,561 Finished 12 from 16 processes 2025-04-09 22:58:43,566 Finished 12 from 16 processes 2025-04-09 22:58:48,570 Finished 12 from 16 processes 2025-04-09 22:58:53,570 Finished 12 from 16 processes 2025-04-09 22:58:58,576 Finished 12 from 16 processes 2025-04-09 22:59:03,576 Finished 12 from 16 processes 2025-04-09 22:59:08,582 Finished 12 from 16 processes 2025-04-09 22:59:13,584 Finished 12 from 16 processes 2025-04-09 22:59:18,588 Finished 12 from 16 processes 2025-04-09 22:59:23,592 Finished 12 from 16 processes 2025-04-09 22:59:28,596 Finished 12 from 16 processes 2025-04-09 22:59:33,600 Finished 12 from 16 processes 2025-04-09 22:59:38,604 Finished 12 from 16 processes 2025-04-09 22:59:43,605 Finished 12 from 16 processes 2025-04-09 22:59:48,611 Finished 12 from 16 processes 2025-04-09 22:59:53,616 Finished 12 from 16 processes 2025-04-09 22:59:58,620 Finished 12 from 16 processes 2025-04-09 23:00:03,624 Finished 12 from 16 processes 2025-04-09 23:00:08,626 Finished 12 from 16 processes 2025-04-09 23:00:13,631 Finished 12 from 16 processes 2025-04-09 23:00:18,636 Finished 12 from 16 processes 2025-04-09 23:00:23,641 Finished 12 from 16 processes 2025-04-09 23:00:28,644 Finished 12 from 16 processes 2025-04-09 23:00:33,648 Finished 12 from 16 processes 2025-04-09 23:00:38,653 Finished 12 from 16 processes 2025-04-09 23:00:43,656 Finished 12 from 16 processes 2025-04-09 23:00:48,658 Finished 12 from 16 processes 2025-04-09 23:00:53,660 Finished 12 from 16 processes 2025-04-09 23:00:58,665 Finished 12 from 16 processes 2025-04-09 23:01:03,670 Finished 12 from 16 processes 2025-04-09 23:01:08,672 Finished 12 from 16 processes 2025-04-09 23:01:13,676 Finished 12 from 16 processes 2025-04-09 23:01:18,678 Finished 12 from 16 processes 2025-04-09 23:01:23,680 Finished 14 from 16 processes 2025-04-09 23:01:28,684 Finished 14 from 16 processes 2025-04-09 23:01:33,689 Finished 15 from 16 processes 2025-04-09 23:01:38,692 Finished 15 from 16 processes 2025-04-09 23:01:43,697 Finished 15 from 16 processes 2025-04-09 23:01:48,702 Finished 15 from 16 processes 2025-04-09 23:01:53,707 Finished 15 from 16 processes 2025-04-09 23:01:58,710 Finished 15 from 16 processes 2025-04-09 23:02:03,716 Finished 15 from 16 processes 2025-04-09 23:02:08,721 Finished 15 from 16 processes 2025-04-09 23:02:13,722 Finished 15 from 16 processes 2025-04-09 23:02:18,725 Finished 15 from 16 processes 2025-04-09 23:02:23,730 Finished 15 from 16 processes 2025-04-09 23:02:28,735 Finished 15 from 16 processes 2025-04-09 23:02:33,741 Finished 15 from 16 processes 2025-04-09 23:02:38,744 Finished 15 from 16 processes 2025-04-09 23:02:43,748 Finished 15 from 16 processes 2025-04-09 23:02:48,751 All processes finished 2025-04-09 23:02:48,751 Compressing stress logs 2025-04-09 23:02:48,781 Logs compressed 2025-04-09 23:02:48,781 Will terminate gdb (if any) 2025-04-09 23:02:48,781 Running command: kill -TERM $(pidof gdb) /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-04-09 23:02:48,785 Command returend 2, retrying /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-04-09 23:02:48,788 Command returend 2, retrying /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-04-09 23:02:49,794 Command returend 2, retrying /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-04-09 23:02:51,803 Command returend 2, retrying /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-04-09 23:02:54,807 Command returend 2, retrying 2025-04-09 23:02:58,808 Running command: timeout 50s tail --pid=$(pidof gdb) -f /dev/null || kill -9 $(pidof gdb) ||: tail: invalid PID: ‘’ /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-04-09 23:02:58,824 Running command: kill -CONT $(cat /var/run/clickhouse-server/clickhouse-server.pid) && clickhouse client -q 'SELECT 1 FORMAT Null' 2025-04-09 23:02:59,189 Running command: clickhouse client -q "SYSTEM STOP THREAD FUZZER" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-04-09 23:02:59,404 Running command: clickhouse client -q "SYSTEM START MERGES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-04-09 23:02:59,568 Running command: clickhouse client -q "SYSTEM START DISTRIBUTED SENDS" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-04-09 23:02:59,733 Running command: clickhouse client -q "SYSTEM START TTL MERGES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-04-09 23:02:59,898 Running command: clickhouse client -q "SYSTEM START MOVES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-04-09 23:03:00,063 Running command: clickhouse client -q "SYSTEM START FETCHES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-04-09 23:03:00,277 Running command: clickhouse client -q "SYSTEM START REPLICATED SENDS" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-04-09 23:03:00,492 Running command: clickhouse client -q "SYSTEM START REPLICATION QUEUES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-04-09 23:03:00,707 Running command: clickhouse client -q "SYSTEM DROP MARK CACHE" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-04-09 23:03:00,923 Running command: clickhouse client -q "KILL QUERY WHERE upper(query) LIKE 'WATCH %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-04-09 23:03:01,137 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'insert into tableB select %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-04-09 23:03:01,352 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'SELECT URL, uniq(SearchPhrase) AS u FROM test.hits GROUP BY URL ORDER BY u %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-04-09 23:03:01,567 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'SELECT (SELECT number FROM system.numbers WHERE number = 1000000000000)%'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 Received exception from server (version 24.8.14): Code: 159. DB::Exception: Received from localhost:9000. DB::Exception: Timeout exceeded: elapsed 60.070111878 seconds, maximum: 60. (TIMEOUT_EXCEEDED) (query: SELECT sleepEachRow(( SELECT maxOrDefault(300 - elapsed) + 1 FROM system.processes WHERE query NOT LIKE '%FROM system.processes%' AND elapsed < 300 ) / 300) FROM numbers(300) FORMAT Null SETTINGS function_sleep_max_microseconds_per_block = 0 ) 2025-04-09 23:04:02,617 Checking if some queries hung Using queries from '/usr/share/clickhouse-test/queries' directory Connecting to ClickHouse server... OK Connected to server 24.8.14.10017.altinitytest @ f815b6e62b10be9faf2d057424b34b1634967937 HEAD Running 1 stateless tests (MainProcess). 00001_select_1: [ OK ] 1 tests passed. 0 tests skipped. 0.42 s elapsed (MainProcess). Won't run stateful tests because test data wasn't loaded. Checking the hung queries: done No queries hung. All tests have finished. Top patterns of log messages: count count_% size size_% uniq_loggers uniq_threads levels background_% message_format_string 1. 12815 0.068 1.30 MiB 0.039 1 78 ['Trace'] 0.19 Checking existence of path: {} 2. 11969 0.063 1.79 MiB 0.053 4797 72 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 3. 10997 0.058 310.22 KiB 0.009 1 70 ['Debug'] 0.104 Processed in {} sec. 4. 10922 0.058 2.13 MiB 0.063 1 72 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 5. 7457 0.039 188.10 KiB 0.005 1 84 ['Trace'] 0 Query to stage {}{} 6. 7371 0.039 360.00 KiB 0.01 1 84 ['Trace'] 0 Query from stage {} to stage {}{} 7. 4817 0.025 540.97 KiB 0.016 4817 82 ['Debug'] 0.998 {} Authenticated with global context as user {} 8. 4817 0.025 220.60 KiB 0.006 4817 82 ['Debug'] 0.998 Authenticating user '{}' from {} 9. 4807 0.025 352.08 KiB 0.01 4807 72 ['Debug'] 1 Creating session context with user_id: {} 10. 4795 0.025 421.44 KiB 0.012 4795 82 ['Debug'] 0.998 {} Logout, user_id: {} 11. 4308 0.023 398.55 KiB 0.012 1 72 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 12. 4308 0.023 141.49 KiB 0.004 1 72 ['Trace'] 1 TCP Request. Address: {} 13. 4274 0.023 112.69 KiB 0.003 1 72 ['Debug'] 1 Done processing connection. 14. 4030 0.021 322.33 KiB 0.009 1 55 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 15. 3800 0.02 375.14 KiB 0.011 1 50 ['Trace'] 0 No query result found for query {} 16. 3757 0.02 264.30 KiB 0.008 1 547 ['Trace'] 0.774 Reserved {} on local disk {}, having unreserved {}. 17. 3692 0.019 175.84 KiB 0.005 1 177 ['Trace'] 0.612 filled checksums {} 18. 3686 0.019 255.66 KiB 0.007 174 520 ['Trace'] 0.775 Trying to reserve {} using storage policy from min volume index {} 19. 3667 0.019 435.28 KiB 0.013 172 168 ['Trace'] 0.617 Renaming temporary part {} to {} with tid {}. 20. 3080 0.016 289.70 KiB 0.008 1 43 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 21. 2574 0.014 301.64 KiB 0.009 1 22 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 22. 2264 0.012 129.73 KiB 0.004 17 39 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 23. 2260 0.012 80.16 KiB 0.002 17 39 ['Trace'] 1 Flushed system log up to offset {} 24. 2230 0.012 110.97 KiB 0.003 1 87 ['Debug'] 0.27 Peak memory usage{}: {}. 25. 1939 0.01 86.77 KiB 0.003 1 3 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 26. 1936 0.01 81.30 KiB 0.002 130 110 ['Debug'] 0.179 Found {} non used tables in detached tables. 27. 1936 0.01 115.33 KiB 0.003 130 110 ['Debug'] 0.179 There are {} detached tables. Start searching non used tables. 28. 1893 0.01 166.80 KiB 0.005 1 122 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 29. 1885 0.01 55.97 KiB 0.002 1 121 ['Trace'] 0 Aggregation method: {} 30. 1701 0.009 4.20 MiB 0.125 3 494 ['Error'] 1 Table is in readonly mode (replica path: {}) 31. 1683 0.009 37.80 KiB 0.001 1 121 ['Trace'] 0 Merging aggregated data 32. 1584 0.008 162.03 KiB 0.005 1 7 ['Trace'] 0.5 Adding file: {}, size: {} 33. 1336 0.007 366.77 KiB 0.011 2 3 ['Error'] 0 Number of arguments for function {} doesn't match: passed {}, should be {} 34. 1330 0.007 161.41 KiB 0.005 1 6 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 35. 1247 0.007 3.30 MiB 0.098 3 36 ['Error'] 0.986 Setting {} should not be changed 36. 1234 0.007 99.11 KiB 0.003 1 109 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 37. 1168 0.006 139.84 KiB 0.004 1 41 ['Trace'] 0 Stored query result of query {} 38. 1165 0.006 77.36 KiB 0.002 1 49 ['Debug'] 0 Will kill query {} (synchronously) 39. 1102 0.006 85.02 KiB 0.002 1 57 ['Trace'] 0 Query span trace_id for opentelemetry log: {} 40. 920 0.005 53.18 KiB 0.002 2 11 ['Trace'] 0.984 Loading config file '{}'. 41. 765 0.004 8.22 KiB 0 1 120 ['Trace'] 0 Aggregating 42. 655 0.003 99.53 KiB 0.003 1 25 ['Debug'] 0 Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.) 43. 655 0.003 32.27 KiB 0.001 1 25 ['Trace'] 0 Merging partially aggregated blocks (bucket = {}). 44. 649 0.003 52.83 KiB 0.002 75 45 ['Trace'] 0 Reading {} ranges in{}order from part {}, approx. {} rows starting from {} 45. 621 0.003 21.21 KiB 0.001 1 44 ['Debug'] 0 Selected MergeAlgorithm: {} 46. 621 0.003 51.78 KiB 0.002 1 44 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {} 47. 621 0.003 33.51 KiB 0.001 38 388 ['Debug'] 0.958 Selected {} parts from {} to {} 48. 598 0.003 78.39 KiB 0.002 1 42 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec. 49. 598 0.003 39.55 KiB 0.001 38 44 ['Trace'] 0 Merged {} parts: [{}, {}] -> {} 50. 588 0.003 65.59 KiB 0.002 80 56 ['Debug'] 0.978 Removing {} parts from filesystem (serially): Parts: [{}] 51. 540 0.003 50.78 KiB 0.001 33 20 ['Trace'] 0.97 Found {} old parts to remove. Parts: [{}] 52. 540 0.003 51.30 KiB 0.001 33 20 ['Debug'] 0.97 Removing {} parts from memory: Parts: [{}] 53. 498 0.003 505.51 KiB 0.015 2 41 ['Trace'] 1 Request URI: {} 54. 498 0.003 90.48 KiB 0.003 2 41 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {} 55. 495 0.003 15.82 KiB 0 115 58 ['Debug'] 0 Key condition: {} 56. 486 0.003 1.07 MiB 0.032 3 19 ['Error'] 0 Query was cancelled 57. 480 0.003 21.09 KiB 0.001 114 58 ['Trace'] 0 Filtering marks by primary and secondary keys 58. 480 0.003 14.93 KiB 0 20 14 ['Debug'] 0 Requested flush up to offset {} 59. 460 0.002 52.83 KiB 0.002 111 54 ['Debug'] 0 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 60. 399 0.002 20.65 KiB 0.001 93 53 ['Trace'] 0 Spreading mark ranges among streams (default reading) 61. 394 0.002 62.60 KiB 0.002 1 36 ['Debug'] 0.01 (internal) {} (stage: {}) 62. 388 0.002 30.95 KiB 0.001 1 102 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={} 63. 388 0.002 1.44 MiB 0.043 12 74 ['Error'] 0.095 Cannot schedule a task: {} (threads={}, jobs={}) 64. 377 0.002 6.63 KiB 0 343 84 ['Debug'] 0.13 Loading data parts 65. 356 0.002 13.94 KiB 0 1 127 ['Debug'] 0.635 Spawn loader worker #{} in {} 66. 356 0.002 10.10 KiB 0 1 157 ['Debug'] 1 Stop worker in {} 67. 355 0.002 25.42 KiB 0.001 1 128 ['Debug'] 1 Execute load job '{}' in {} 68. 355 0.002 26.46 KiB 0.001 1 41 ['Debug'] 0.234 Schedule load job '{}' into {} 69. 355 0.002 24.01 KiB 0.001 1 128 ['Debug'] 1 Finish load job '{}' with status {} 70. 354 0.002 14.17 KiB 0 13 84 ['Trace'] 0.003 Sending external_roles with query: [{}] ({}) 71. 346 0.002 7.10 KiB 0 2 41 ['Debug'] 0.003 Done processing query 72. 344 0.002 31.38 KiB 0.001 1 42 ['Debug'] 0.163 Prioritize load job '{}': {} -> {} 73. 340 0.002 7.64 KiB 0 336 59 ['Debug'] 0.062 There are no data parts 74. 335 0.002 38.60 KiB 0.001 1 37 ['Debug'] 0 Done waiting for the table {} to be dropped. The outcome: {} 75. 335 0.002 24.86 KiB 0.001 1 37 ['Debug'] 0 Waiting for table {} to be finally dropped 76. 302 0.002 21.82 KiB 0.001 1 236 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {} tables 77. 291 0.002 53.95 KiB 0.002 1 84 ['Information'] 1 Removing metadata {} of dropped table {} 78. 283 0.001 9.38 KiB 0 1 125 ['Debug'] 0.544 Change current priority: {} -> {} 79. 274 0.001 2.15 MiB 0.064 2 15 ['Error'] 0 Memory limit{}{} exceeded: would use {} (attempt to allocate chunk of {} bytes), maximum: {}.{}{} 80. 269 0.001 15.68 KiB 0 19 80 ['Trace'] 0.967 Finished loading {} part {} on disk {} 81. 269 0.001 13.84 KiB 0 19 80 ['Trace'] 0.967 Loading {} part {} from disk {} 82. 268 0.001 2.36 KiB 0 2 41 ['Trace'] 0.03 No tables 83. 264 0.001 21.32 KiB 0.001 1 3 ['Debug'] 1 Merging configuration file '{}'. 84. 259 0.001 11.13 KiB 0 1 3 ['Information'] 1 {} for session {} took {} ms 85. 258 0.001 123.75 KiB 0.004 2 2 ['Error'] 0 An incorrect number of arguments was specified for function '{}'. Expected {}, got {} 86. 249 0.001 50.18 KiB 0.001 1 28 ['Trace'] 0 PREWHERE condition was split into {} steps: {} 87. 240 0.001 31.82 KiB 0.001 3 23 ['Debug'] 0 {}, {} blocks, {} rows, {} bytes in {} sec., {} rows/sec., {}/sec. 88. 239 0.001 17.47 KiB 0.001 1 30 ['Trace'] 0 Condition {} moved to PREWHERE 89. 237 0.001 12.20 KiB 0 16 68 ['Trace'] 0 Connecting. Database: {}. User: {}{}{} 90. 226 0.001 9.27 KiB 0 10 10 ['Debug'] 0 Finished removing not used detached tables 91. 208 0.001 9.55 KiB 0 13 65 ['Trace'] 0 Connected to {} server version {}.{}.{}. 92. 199 0.001 3.11 KiB 0 14 15 ['Debug'] 1 Scheduling tasks 93. 199 0.001 45.00 KiB 0.001 14 15 ['Trace'] 1 scheduleTasks: initialized={}, size_before_filtering={}, queue_size={}, entries={}..{}, first_failed_task_name={}, current_tasks_size={}, last_current_task={}, last_skipped_entry_name={} 94. 199 0.001 6.02 KiB 0 194 73 ['Trace'] 1 dropAllData: waiting for locks. 95. 199 0.001 4.86 KiB 0 14 15 ['Debug'] 1 Waiting for queue updates 96. 199 0.001 11.47 KiB 0 194 73 ['Trace'] 1 dropAllData: removing data parts (count {}) from filesystem. 97. 196 0.001 5.74 KiB 0 13 12 ['Trace'] 1 Checking task {} 98. 196 0.001 9.95 KiB 0 13 12 ['Debug'] 1 Will schedule {} tasks starting from {} 99. 196 0.001 18.35 KiB 0.001 13 12 ['Debug'] 1 Will not execute task {}: {} 100. 194 0.001 9.28 KiB 0 194 73 ['Trace'] 1 dropAllData: removing all data parts from memory. count count_% size size_% uniq_loggers uniq_threads levels background_% message_format_string Top messages without format string (fmt::runtime): count pattern runtime_message line 1. 44 CodeDBExceptionReceivedfromDBExc Code: 439. DB::Exception: Received from 127.0.0.2:9000. DB::Exception: Cannot schedule a task: failed to start the thread (threads=1, jobs=0). Stack trace: 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, i ('/executeQuery.cpp',221) 2. 6 CodeDBExceptionSyntaxerrorfailed Code: 62. DB::Exception: Syntax error: failed at position 8 ('1'): 1. Max query size exceeded: '1'. (SYNTAX_ERROR) (version 24.8.14.10017.altinitytest (altinity build)) (from [::ffff:127.0.0.1]:44404) (comment: 00612_h) (in query: select ), Stack trace (wh ('/executeQuery.cpp',221) 3. 3 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',43) 4. 3 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',43) 5. 3 StartingClickHousealtinitytestre Starting ClickHouse 24.8.14.10017.altinitytest (revision: 4294967295, git hash: f815b6e62b10be9faf2d057424b34b1634967937, build id: FD5BEE2834F9323A2289DAAE666BE492EC075FED), PID 417 ('',0) 6. 3 newconfigurationlogidxprevlogidx new configuration: log idx 1, prev log idx 0 peer 1, DC ID 0, localhost:9234, voting member, 1 my id: 1, leader: 1, term: 1 ('/LoggerWrapper.h',43) 7. 3 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 8. 3 statemachinecommitindexprecommit state machine commit index 0, precommit index 0, last log index 0 ('/LoggerWrapper.h',43) 9. 3 Forkedachildprocesstowatch Forked a child process to watch ('',0) 10. 3 INITRAFTSERVERcommitindextermele === INIT RAFT SERVER === commit index 0 term 0 election timer allowed log store start 1, end 0 config log idx 0, prev log idx 0 -- ASYNC REPLICATION -- ('/LoggerWrapper.h',43) 11. 3 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 0 ('/LoggerWrapper.h',43) 12. 3 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1 my id: 1, voting_member num peers: 0 ('/LoggerWrapper.h',43) 13. 3 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 14. 3 RaftASIOlistenerinitiatedonunsec Raft ASIO listener initiated on :::9234, unsecured ('/LoggerWrapper.h',43) 15. 3 VOTEINITmyidmyrolecandidateterml [VOTE INIT] my id 1, my role candidate, term 1, log idx 0, log term 0, priority (target 1 / mine 1) ('/LoggerWrapper.h',43) 16. 3 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',43) 17. 3 ELECTIONTIMEOUTcurrentrolefollow [ELECTION TIMEOUT] current role: follower, log last term 0, state term 0, target p 1, my p 1, hb dead, pre-vote NOT done ('/LoggerWrapper.h',43) 18. 3 startingup starting up ('',0) 19. 3 parameterselectiontimeoutrangehe parameters: election timeout range 0 - 0, heartbeat 0, leadership expiry 0, max batch 100, backoff 50, snapshot distance 10000, enable randomized snapshot creation NO, log sync stop gap 99999, reserved logs 2147483647, client timeout 10000, auto forwarding ('/LoggerWrapper.h',43) 20. 3 PRIORITYdecaytargetmine [PRIORITY] decay, target 1 -> 1, mine 1 ('/LoggerWrapper.h',43) 21. 3 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 1 ('/LoggerWrapper.h',43) 22. 3 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',43) 23. 3 newelectiontimeoutrange new election timeout range: 0 - 0 ('/LoggerWrapper.h',43) 24. 3 numberofpendingcommitelements number of pending commit elements: 0 ('/LoggerWrapper.h',43) 25. 3 newconfiglogidxprevlogidxcurconf new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0 ('/LoggerWrapper.h',43) 26. 2 prevotetermisdifferentresetitto pre-vote term (0) is different, reset it to 1 ('/LoggerWrapper.h',43) 27. 2 CodeDBExceptionPathisrelativewhi Code: 395. DB::Exception: Path is relative: : while executing 'FUNCTION throwIf(_CAST(1_UInt8, 'UInt8'_String) :: 1, 'Path is relative: '_String :: 2) -> throwIf(_CAST(1_UInt8, 'UInt8'_String), 'Path is relative: '_String) UInt8 : 3'. (FUNCTION_THROW_IF_VA ('/executeQuery.cpp',221) 28. 2 CodeDBExceptionReceivedfromlocal Code: 439. DB::Exception: Received from localhost:9000. DB::Exception: Cannot schedule a task: failed to start the thread (threads=11, jobs=11). Stack trace: 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, ('/executeQuery.cpp',221) 29. 1 stdexceptionCodetypestdruntimeer std::exception. Code: 1001, type: std::runtime_error, e.what() = ran out of bytes (version 24.8.14.10017.altinitytest (altinity build)) (from [::1]:51784) (comment: 02688_aggregate_states.sql) (in query: SELECT '\x01\x01\x01'::AggregateFunction(groupBitmap ('/executeQuery.cpp',221) 30. 1 logTraceFunctionTest logTrace Function Test ('/logTrace.cpp',50) Top messages not matching their format strings: message_format_string count() any_message 1. 74 Forked a child process to watch 2. {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 2 /var/lib/clickhouse/store/6ae/6ae0e37f-2a7a-47e3-b83f-566cd41cae46/tmp_insert_201403_11_11_0/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 3 similar messages) Top short messages: c message_format_string substr(any(toValidUTF8(message)), 1, 120) min_length_without_exception_boilerplate 1. 17 {} ThreadFuzzer is enabled. Application will run slowly and unstable. 35 2. 11 Cannot TRUNCATE dictionary Code: 62. DB::Exception: Cannot TRUNCATE dictionary. (SYNTAX_ERROR) (version 24.8.14.10017.altinitytest (altinity build) 27 3. 5 Found {} on {} Found snapshot_9.bin.zstd on LocalSnapshotDisk 18 Top messages by level: (0.008960554595642463,'Table is in readonly mode (replica path: {})') Error (0.00012115976231615323,'Client has gone away.') Warning (0.0015908803573686206,'Have {} tables in drop queue ({} of them are in use), will try drop {} tables') Information (0.057930169834379874,'Processed in {} sec.') Debug (0.06750705887310886,'Checking existence of path: {}') Trace 2025-04-09 23:04:07,796 Stress test finished + echo -e 'Test script exit code\tOK\t\N\t' + rg -Fa 'No queries hung' /test_output/test_results.tsv + grep -Fa OK No queries hung OK \N + stop_server + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=2723 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2723. The process with pid = 2723 is running. Sent terminate signal to process with pid 2723. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2723. The process with pid = 2723 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2723. The process with pid = 2723 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2723. The process with pid = 2723 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2723. The process with pid = 2723 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2723. The process with pid = 2723 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2723. The process with pid = 2723 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2723. The process with pid = 2723 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2723. The process with pid = 2723 does not exist. Server stopped + return + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.stress.log + unset THREAD_FUZZER_CPU_TIME_PERIOD_US THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY THREAD_FUZZER_SLEEP_PROBABILITY THREAD_FUZZER_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX THREAD_POOL_FAULT_INJECTION + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root 127.0.0.1 - - [09/Apr/2025:21:04:16 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - 127.0.0.1 - - [09/Apr/2025:21:04:16 +0000] "PUT /devstoreaccount1/cont/edkdrdgfhyvfippojemiyifnmpwtmexy HTTP/1.1" 201 - 127.0.0.1 - - [09/Apr/2025:21:04:16 +0000] "GET /devstoreaccount1/cont/edkdrdgfhyvfippojemiyifnmpwtmexy HTTP/1.1" 206 4 127.0.0.1 - - [09/Apr/2025:21:04:16 +0000] "GET /devstoreaccount1/cont/edkdrdgfhyvfippojemiyifnmpwtmexy HTTP/1.1" 206 2 127.0.0.1 - - [09/Apr/2025:21:04:16 +0000] "DELETE /devstoreaccount1/cont/edkdrdgfhyvfippojemiyifnmpwtmexy HTTP/1.1" 202 - + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ [[ hxB =~ e ]] ++ set_e=false ++ set +e ++ local total_retries=5 ++ shift ++ local retry=0 ++ '[' 0 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ false ++ return + IS_ASAN=1 + [[ 1 = \1 ]] ASAN build detected. Not using gdb since it disables LeakSanitizer detections + echo 'ASAN build detected. Not using gdb since it disables LeakSanitizer detections' + check_server_start + clickhouse-client --query 'SELECT '\''Server successfully started'\'', '\''OK'\'', NULL, '\'''\''' + '[' -s /test_output/application_errors.txt ']' + rm /test_output/application_errors.txt rm: cannot remove '/test_output/application_errors.txt': No such file or directory + stop_server + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=40593 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 40593. The process with pid = 40593 is running. Sent terminate signal to process with pid 40593. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 40593. The process with pid = 40593 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 40593. The process with pid = 40593 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 40593. The process with pid = 40593 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 40593. The process with pid = 40593 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 40593. The process with pid = 40593 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 40593. The process with pid = 40593 is running. Waiting for server to stop Found pid = 41478 in the list of running processes. The process with pid = 41478 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + '[' -f /var/log/clickhouse-server/clickhouse-server.log ']' + '[' -f /var/log/clickhouse-server/stderr.log ']' + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.final.log + check_logs_for_critical_errors + sed -n '/WARNING:.*anitizer/,/^$/p' /var/log/clickhouse-server/stderr.log + rg -Fav -e 'ASan doesn'\''t fully support makecontext/swapcontext functions' -e DB::Exception /test_output/tmp + echo -e 'No sanitizer asserts\tOK\t\N\t' + rm -f /test_output/tmp + rg -Fa ' Application: Child process was terminated by signal 9' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No OOM messages in clickhouse-server.log\tOK\t\N\t' + rg -Fa 'Code: 49. DB::Exception: ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No logical errors\tOK\t\N\t' + '[' -s /test_output/logical_errors.txt ']' + rm /test_output/logical_errors.txt + rg --text 'Code: 499.*The specified key does not exist' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + grep -v a.myext + echo -e 'No lost s3 keys\tOK\t\N\t' + rg -Fa 'it is lost forever' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + grep SharedMergeTreePartCheckThread + echo -e 'No SharedMergeTree lost forever in clickhouse-server.log\tOK\t\N\t' + '[' -s /test_output/no_such_key_errors.txt ']' + rm /test_output/no_such_key_errors.txt + rg -Fa '########################################' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'Not crashed\tOK\t\N\t' + rg -Fa ' ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No fatal messages in clickhouse-server.log\tOK\t\N\t' + '[' -s /test_output/fatal_messages.txt ']' + rm /test_output/fatal_messages.txt + rg -Faz '########################################' /test_output/stress_run_logs.tar.zst /test_output/test_results.tsv + rg -Fa ' received signal ' /test_output/gdb.log /test_output/gdb.log: No such file or directory (os error 2) + dmesg -T + grep -q -F -e 'Out of memory: Killed process' -e 'oom_reaper: reaped process' -e oom-kill:constraint=CONSTRAINT_NONE /test_output/dmesg.log + echo -e 'No OOM in dmesg\tOK\t\N\t' + tar -chf /test_output/coordination.tar /var/lib/clickhouse/coordination tar: Removing leading `/' from member names tar: Removing leading `/' from hard link targets + collect_query_and_trace_logs + for table in query_log trace_log metric_log + clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.query_log format TSVWithNamesAndTypes' + zstd --threads=0 Logging trace to /var/log/clickhouse-server/clickhouse-server.log Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log 127.0.0.1 - - [09/Apr/2025:21:04:26 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - + for table in query_log trace_log metric_log + clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.trace_log format TSVWithNamesAndTypes' + zstd --threads=0 Logging trace to /var/log/clickhouse-server/clickhouse-server.log Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log 127.0.0.1 - - [09/Apr/2025:21:04:30 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - + for table in query_log trace_log metric_log + zstd --threads=0 + clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.metric_log format TSVWithNamesAndTypes' Logging trace to /var/log/clickhouse-server/clickhouse-server.log Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log 127.0.0.1 - - [09/Apr/2025:21:04:33 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - + mv /var/log/clickhouse-server/stderr.log /test_output/ + clickhouse-local --structure 'test String, res String, time Nullable(Float32), desc String' -q 'SELECT '\''failure'\'', test FROM table WHERE res != '\''OK'\'' order by (test like '\''%Sanitizer%'\'') DESC, (test like '\''%Killed by signal%'\'') DESC, (test like '\''%gdb.log%'\'') DESC, (test ilike '\''%possible deadlock%'\'') DESC, (test like '\''%start%'\'') DESC, (test like '\''%dmesg%'\'') DESC, (test like '\''%OOM%'\'') DESC, (test like '\''%Signal 9%'\'') DESC, (test like '\''%Fatal message%'\'') DESC, rowNumberInAllBlocks() LIMIT 1' + '[' -s /test_output/check_status.tsv ']' + echo -e 'success\tNo errors found' + rg 'OOM in dmesg|Signal 9' /test_output/check_status.tsv + collect_core_dumps + find . -type f -maxdepth 1 -name 'core.*' + read -r core