+ 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.10512.altinitytest+ubsan_amd64.deb Selecting previously unselected package clickhouse-common-static. (Reading database ... 48696 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static_24.8.14.10512.altinitytest+ubsan_amd64.deb ... Unpacking clickhouse-common-static (24.8.14.10512.altinitytest+ubsan) ... Setting up clickhouse-common-static (24.8.14.10512.altinitytest+ubsan) ... + dpkg -i package_folder/clickhouse-common-static-dbg_24.8.14.10512.altinitytest+ubsan_amd64.deb Selecting previously unselected package clickhouse-common-static-dbg. (Reading database ... 48723 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static-dbg_24.8.14.10512.altinitytest+ubsan_amd64.deb ... Unpacking clickhouse-common-static-dbg (24.8.14.10512.altinitytest+ubsan) ... Setting up clickhouse-common-static-dbg (24.8.14.10512.altinitytest+ubsan) ... + dpkg -i package_folder/clickhouse-server_24.8.14.10512.altinitytest+ubsan_amd64.deb Selecting previously unselected package clickhouse-server. (Reading database ... 48730 files and directories currently installed.) Preparing to unpack .../clickhouse-server_24.8.14.10512.altinitytest+ubsan_amd64.deb ... Unpacking clickhouse-server (24.8.14.10512.altinitytest+ubsan) ... Setting up clickhouse-server (24.8.14.10512.altinitytest+ubsan) ... 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.10512.altinitytest+ubsan_amd64.deb Selecting previously unselected package clickhouse-client. (Reading database ... 48747 files and directories currently installed.) Preparing to unpack .../clickhouse-client_24.8.14.10512.altinitytest+ubsan_amd64.deb ... Unpacking clickhouse-client (24.8.14.10512.altinitytest+ubsan) ... Setting up clickhouse-client (24.8.14.10512.altinitytest+ubsan) ... + 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 + SRC_PATH=/usr/share/clickhouse-test/config + echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server' 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=0 + sed --follow-symlinks -i 's|[01]|0|' /etc/clickhouse-server/config.d/keeper_port.xml + value=66342912 + sed --follow-symlinks -i 's|[[:digit:]]\+|66342912|' /etc/clickhouse-server/config.d/keeper_port.xml + value=13817856 + sed --follow-symlinks -i 's|[[:digit:]]\+|13817856|' /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=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + 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=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 + 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 Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G + 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 + local counter=0 + local max_counter=60 + local url=http://localhost:11111 + params=('--silent' '--verbose') + local params + ./minio server --address :11111 ./minio_data + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 0 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio 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:33495 http://127.0.0.1:33495 Docs: https://min.io/docs/minio/linux/index.html + counter=1 + grep AccessDenied + curl --silent --verbose http://localhost:11111 AccessDeniedAccess Denied./18628F3557B466307dc7eb22d3288ec80374614e9088e31d3668a6922ead55932dd2a8e56373820f + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 274 root 8u IPv6 20234 0t0 TCP *:11111 (LISTEN) minio 274 root 9u IPv4 20233 0t0 TCP localhost:11111 (LISTEN) minio 274 root 10u IPv6 20235 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/02731.parquet` -> `clickminio/test/02731.parquet` `/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/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/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_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: 173.83 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 + export CLICKHOUSE_MAX_THREADS=8 + CLICKHOUSE_MAX_THREADS=8 + export CLICKHOUSE_MAX_CONCURRENT_QUERIES=4 + CLICKHOUSE_MAX_CONCURRENT_QUERIES=4 + 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' 127.0.0.1 - - [06/Sep/2025:02:04:35 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 404 - 127.0.0.1 - - [06/Sep/2025:02:04:35 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [06/Sep/2025:02:04:35 +0000] "PUT /devstoreaccount1/cont/ryawjdtnyirfrdchsmhnfdyyqtjirrsf HTTP/1.1" 201 - 127.0.0.1 - - [06/Sep/2025:02:04:35 +0000] "GET /devstoreaccount1/cont/ryawjdtnyirfrdchsmhnfdyyqtjirrsf HTTP/1.1" 206 4 127.0.0.1 - - [06/Sep/2025:02:04:35 +0000] "GET /devstoreaccount1/cont/ryawjdtnyirfrdchsmhnfdyyqtjirrsf HTTP/1.1" 206 2 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 127.0.0.1 - - [06/Sep/2025:02:04:35 +0000] "DELETE /devstoreaccount1/cont/ryawjdtnyirfrdchsmhnfdyyqtjirrsf HTTP/1.1" 202 - + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + 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=0 + [[ 0 = \1 ]] ++ kill -l SIGRTMIN + RTMIN=34 + echo ' set follow-fork-mode parent handle SIGHUP nostop noprint pass handle SIGINT nostop noprint pass handle SIGQUIT nostop noprint pass handle SIGPIPE nostop noprint pass handle SIGTERM nostop noprint pass handle SIGUSR1 nostop noprint pass handle SIGUSR2 nostop noprint pass handle SIG34 nostop noprint pass info signals continue backtrace full info registers p top' 1 KiB of the 'stack: p/x *(uint64_t[128]*)$sp maintenance info sections thread apply all backtrace full disassemble /s up disassemble /s up disassemble /s p "done" detach quit ' + sleep 5 + ts '%Y-%m-%d %H:%M:%S' ++ cat /var/run/clickhouse-server/clickhouse-server.pid + gdb -batch -command script.gdb -p 408 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + 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=408 + clickhouse stop --max-tries 90 --do-not-kill script.gdb:13: Error in sourced command file: No stack. /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408. The process with pid = 408 is running. Sent terminate signal to process with pid 408. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408. The process with pid = 408 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408. The process with pid = 408 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408. The process with pid = 408 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408. The process with pid = 408 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408. The process with pid = 408 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408. The process with pid = 408 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408. The process with pid = 408 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408. The process with pid = 408 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408. The process with pid = 408 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= + '[' 0 -eq 1 ']' + cache_policy=LRU + echo 'Using cache policy: LRU' Using cache policy: LRU + '[' LRU = SLRU ']' + 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 127.0.0.1 - - [06/Sep/2025:02:05:19 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - 127.0.0.1 - - [06/Sep/2025:02:05:19 +0000] "PUT /devstoreaccount1/cont/ainnkdthjbtnjuoysogvmbxavadcviot HTTP/1.1" 201 - 127.0.0.1 - - [06/Sep/2025:02:05:19 +0000] "GET /devstoreaccount1/cont/ainnkdthjbtnjuoysogvmbxavadcviot HTTP/1.1" 206 4 127.0.0.1 - - [06/Sep/2025:02:05:19 +0000] "GET /devstoreaccount1/cont/ainnkdthjbtnjuoysogvmbxavadcviot HTTP/1.1" 206 2 127.0.0.1 - - [06/Sep/2025:02:05:19 +0000] "DELETE /devstoreaccount1/cont/ainnkdthjbtnjuoysogvmbxavadcviot HTTP/1.1" 202 - + 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 + 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' 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=0 + [[ 0 = \1 ]] ++ kill -l SIGRTMIN + RTMIN=34 + echo ' set follow-fork-mode parent handle SIGHUP nostop noprint pass handle SIGINT nostop noprint pass handle SIGQUIT nostop noprint pass handle SIGPIPE nostop noprint pass handle SIGTERM nostop noprint pass handle SIGUSR1 nostop noprint pass handle SIGUSR2 nostop noprint pass handle SIG34 nostop noprint pass info signals continue backtrace full info registers p top' 1 KiB of the 'stack: p/x *(uint64_t[128]*)$sp maintenance info sections thread apply all backtrace full disassemble /s up disassemble /s up disassemble /s p "done" detach quit ' + sleep 5 + ts '%Y-%m-%d %H:%M:%S' ++ cat /var/run/clickhouse-server/clickhouse-server.pid + gdb -batch -command script.gdb -p 1256 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + 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 1587361 bytes), maximum: 9.18 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.: (avg_value_size_hint = 127.9769287109375, avg_chars_size = 143.972314453125, limit = 8192): (while reading column Title): (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 176 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 1050160 bytes), maximum: 9.18 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.: (while reading column GoalsReached): (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=1256 + clickhouse stop --max-tries 90 --do-not-kill script.gdb:13: Error in sourced command file: No stack. /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1256. The process with pid = 1256 is running. Sent terminate signal to process with pid 1256. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1256. The process with pid = 1256 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1256. The process with pid = 1256 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1256. The process with pid = 1256 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1256. The process with pid = 1256 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1256. The process with pid = 1256 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1256. The process with pid = 1256 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1256. The process with pid = 1256 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1256. The process with pid = 1256 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1256. The process with pid = 1256 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1256. The process with pid = 1256 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 + 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/ Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + 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=0 + sed --follow-symlinks -i 's|[01]|0|' /etc/clickhouse-server/config.d/keeper_port.xml + value=41500672 + sed --follow-symlinks -i 's|[[:digit:]]\+|41500672|' /etc/clickhouse-server/config.d/keeper_port.xml + value=18694144 + sed --follow-symlinks -i 's|[[:digit:]]\+|18694144|' /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=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + 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=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + 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=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + 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=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 + 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 Setting max_server_memory_usage_to_ram_ratio to 0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat 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 + [[ '' == \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 + '[' LRU = SLRU ']' ++ date +%-d + '[' 0 -eq 1 ']' + 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 127.0.0.1 - - [06/Sep/2025:02:07:26 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - 127.0.0.1 - - [06/Sep/2025:02:07:26 +0000] "PUT /devstoreaccount1/cont/vnwmzismomilomeidjdofgxhapuzrvav HTTP/1.1" 201 - 127.0.0.1 - - [06/Sep/2025:02:07:26 +0000] "GET /devstoreaccount1/cont/vnwmzismomilomeidjdofgxhapuzrvav HTTP/1.1" 206 4 127.0.0.1 - - [06/Sep/2025:02:07:26 +0000] "GET /devstoreaccount1/cont/vnwmzismomilomeidjdofgxhapuzrvav HTTP/1.1" 206 2 127.0.0.1 - - [06/Sep/2025:02:07:26 +0000] "DELETE /devstoreaccount1/cont/vnwmzismomilomeidjdofgxhapuzrvav HTTP/1.1" 202 - + 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 + 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' 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: fault injected (threads=1, jobs=1). (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 + IS_ASAN=0 + [[ 0 = \1 ]] ++ kill -l SIGRTMIN + RTMIN=34 + echo ' set follow-fork-mode parent handle SIGHUP nostop noprint pass handle SIGINT nostop noprint pass handle SIGQUIT nostop noprint pass handle SIGPIPE nostop noprint pass handle SIGTERM nostop noprint pass handle SIGUSR1 nostop noprint pass handle SIGUSR2 nostop noprint pass handle SIG34 nostop noprint pass info signals continue backtrace full info registers p top' 1 KiB of the 'stack: p/x *(uint64_t[128]*)$sp maintenance info sections thread apply all backtrace full disassemble /s up disassemble /s up disassemble /s p "done" detach quit ' + sleep 5 + ts '%Y-%m-%d %H:%M:%S' ++ cat /var/run/clickhouse-server/clickhouse-server.pid + gdb -batch -command script.gdb -p 2615 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + stress --hung-check --drop-databases --output-folder test_output --skip-func-tests '' --global-time-limit 1200 2025-09-06 04:07:48,898 Run func tests '/usr/bin/clickhouse-test --client-option ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-09-06 04:07:49,400 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 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-09-06 04:07:49,901 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 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' 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-09-06 04:07:50,402 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 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-09-06 04:07:50,903 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=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-09-06 04:07:51,404 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' 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-09-06 04:07:51,906 Run func tests '/usr/bin/clickhouse-test --order=random --client-option memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-09-06 04:07:52,407 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 http_make_head_request=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-09-06 04:07:52,908 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 optimize_trivial_approximate_count_query=1 http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-09-06 04:07:53,410 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_9 --client-option join_algorithm='auto' max_rows_in_join=1000 group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-09-06 04:07:53,911 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' http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-09-06 04:07:54,412 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-09-06 04:07:54,914 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' implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 http_make_head_request=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-09-06 04:07:55,416 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_13 --client-option join_use_nulls=1 join_algorithm='partial_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-09-06 04:07:55,917 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' optimize_trivial_approximate_count_query=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-09-06 04:07:56,418 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_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 --global_time_limit=1200 ' 2025-09-06 04:07:56,919 Will wait functests to finish 2025-09-06 04:07:56,920 Finished 8 from 16 processes 2025-09-06 04:08:01,925 Finished 9 from 16 processes 2025-09-06 04:08:06,928 Finished 9 from 16 processes 2025-09-06 04:08:11,933 Finished 9 from 16 processes 2025-09-06 04:08:16,937 Finished 9 from 16 processes 2025-09-06 04:08:21,941 Finished 9 from 16 processes 2025-09-06 04:08:26,945 Finished 9 from 16 processes 2025-09-06 04:08:31,949 Finished 9 from 16 processes 2025-09-06 04:08:36,953 Finished 9 from 16 processes 2025-09-06 04:08:41,958 Finished 9 from 16 processes 2025-09-06 04:08:46,961 Finished 9 from 16 processes 2025-09-06 04:08:51,965 Finished 9 from 16 processes 2025-09-06 04:08:56,969 Finished 9 from 16 processes 2025-09-06 04:09:01,971 Finished 9 from 16 processes 2025-09-06 04:09:06,976 Finished 9 from 16 processes 2025-09-06 04:09:11,981 Finished 9 from 16 processes 2025-09-06 04:09:16,985 Finished 9 from 16 processes 2025-09-06 04:09:21,989 Finished 9 from 16 processes 2025-09-06 04:09:26,993 Finished 9 from 16 processes 2025-09-06 04:09:31,997 Finished 9 from 16 processes 2025-09-06 04:09:37,001 Finished 9 from 16 processes 2025-09-06 04:09:42,005 Finished 9 from 16 processes 2025-09-06 04:09:47,009 Finished 9 from 16 processes 2025-09-06 04:09:52,013 Finished 9 from 16 processes 2025-09-06 04:09:57,017 Finished 9 from 16 processes 2025-09-06 04:10:02,021 Finished 9 from 16 processes 2025-09-06 04:10:07,025 Finished 9 from 16 processes 2025-09-06 04:10:12,029 Finished 9 from 16 processes 2025-09-06 04:10:17,033 Finished 9 from 16 processes 2025-09-06 04:10:22,037 Finished 9 from 16 processes 2025-09-06 04:10:27,041 Finished 9 from 16 processes 2025-09-06 04:10:32,045 Finished 9 from 16 processes 2025-09-06 04:10:37,049 Finished 9 from 16 processes 2025-09-06 04:10:42,053 Finished 9 from 16 processes 2025-09-06 04:10:47,057 Finished 9 from 16 processes 2025-09-06 04:10:52,061 Finished 9 from 16 processes 2025-09-06 04:10:57,065 Finished 9 from 16 processes 2025-09-06 04:11:02,069 Finished 9 from 16 processes 2025-09-06 04:11:07,073 Finished 9 from 16 processes 2025-09-06 04:11:12,077 Finished 9 from 16 processes 2025-09-06 04:11:17,081 Finished 9 from 16 processes 2025-09-06 04:11:22,085 Finished 9 from 16 processes 2025-09-06 04:11:27,089 Finished 9 from 16 processes 2025-09-06 04:11:32,093 Finished 9 from 16 processes 2025-09-06 04:11:37,097 Finished 9 from 16 processes 2025-09-06 04:11:42,101 Finished 9 from 16 processes 2025-09-06 04:11:47,105 Finished 9 from 16 processes 2025-09-06 04:11:52,109 Finished 9 from 16 processes 2025-09-06 04:11:57,113 Finished 9 from 16 processes 2025-09-06 04:12:02,117 Finished 9 from 16 processes 2025-09-06 04:12:07,121 Finished 9 from 16 processes 2025-09-06 04:12:12,125 Finished 9 from 16 processes 2025-09-06 04:12:17,129 Finished 9 from 16 processes 2025-09-06 04:12:22,133 Finished 9 from 16 processes 2025-09-06 04:12:27,137 Finished 9 from 16 processes 2025-09-06 04:12:32,141 Finished 9 from 16 processes 2025-09-06 04:12:37,145 Finished 9 from 16 processes 2025-09-06 04:12:42,149 Finished 9 from 16 processes 2025-09-06 04:12:47,153 Finished 9 from 16 processes 2025-09-06 04:12:52,157 Finished 9 from 16 processes 2025-09-06 04:12:57,161 Finished 9 from 16 processes 2025-09-06 04:13:02,165 Finished 9 from 16 processes 2025-09-06 04:13:07,169 Finished 9 from 16 processes 2025-09-06 04:13:12,173 Finished 9 from 16 processes 2025-09-06 04:13:17,177 Finished 9 from 16 processes 2025-09-06 04:13:22,181 Finished 9 from 16 processes 2025-09-06 04:13:27,185 Finished 9 from 16 processes 2025-09-06 04:13:32,190 Finished 9 from 16 processes 2025-09-06 04:13:37,193 Finished 9 from 16 processes 2025-09-06 04:13:42,197 Finished 9 from 16 processes 2025-09-06 04:13:47,201 Finished 9 from 16 processes 2025-09-06 04:13:52,205 Finished 9 from 16 processes 2025-09-06 04:13:57,209 Finished 9 from 16 processes 2025-09-06 04:14:02,213 Finished 9 from 16 processes 2025-09-06 04:14:07,217 Finished 9 from 16 processes 2025-09-06 04:14:12,221 Finished 9 from 16 processes 2025-09-06 04:14:17,225 Finished 9 from 16 processes 2025-09-06 04:14:22,229 Finished 9 from 16 processes 2025-09-06 04:14:27,233 Finished 9 from 16 processes 2025-09-06 04:14:32,237 Finished 9 from 16 processes 2025-09-06 04:14:37,241 Finished 9 from 16 processes 2025-09-06 04:14:42,245 Finished 9 from 16 processes 2025-09-06 04:14:47,249 Finished 9 from 16 processes 2025-09-06 04:14:52,253 Finished 9 from 16 processes 2025-09-06 04:14:57,257 Finished 9 from 16 processes 2025-09-06 04:15:02,261 Finished 9 from 16 processes 2025-09-06 04:15:07,265 Finished 9 from 16 processes 2025-09-06 04:15:12,269 Finished 9 from 16 processes 2025-09-06 04:15:17,273 Finished 9 from 16 processes 2025-09-06 04:15:22,277 Finished 9 from 16 processes 2025-09-06 04:15:27,281 Finished 9 from 16 processes 2025-09-06 04:15:32,285 Finished 9 from 16 processes 2025-09-06 04:15:37,289 Finished 9 from 16 processes 2025-09-06 04:15:42,293 Finished 9 from 16 processes 2025-09-06 04:15:47,297 Finished 9 from 16 processes 2025-09-06 04:15:52,301 Finished 9 from 16 processes 2025-09-06 04:15:57,305 Finished 9 from 16 processes 2025-09-06 04:16:02,309 Finished 9 from 16 processes 2025-09-06 04:16:07,313 Finished 9 from 16 processes 2025-09-06 04:16:12,317 Finished 9 from 16 processes 2025-09-06 04:16:17,321 Finished 9 from 16 processes 2025-09-06 04:16:22,325 Finished 9 from 16 processes 2025-09-06 04:16:27,329 Finished 9 from 16 processes 2025-09-06 04:16:32,333 Finished 9 from 16 processes 2025-09-06 04:16:37,337 Finished 9 from 16 processes 2025-09-06 04:16:42,341 Finished 9 from 16 processes 2025-09-06 04:16:47,345 Finished 9 from 16 processes 2025-09-06 04:16:52,349 Finished 9 from 16 processes 2025-09-06 04:16:57,353 Finished 9 from 16 processes 2025-09-06 04:17:02,357 Finished 9 from 16 processes 2025-09-06 04:17:07,361 Finished 9 from 16 processes 2025-09-06 04:17:12,365 Finished 9 from 16 processes 2025-09-06 04:17:17,369 Finished 9 from 16 processes 2025-09-06 04:17:22,373 Finished 9 from 16 processes 2025-09-06 04:17:27,377 Finished 9 from 16 processes 2025-09-06 04:17:32,381 Finished 9 from 16 processes 2025-09-06 04:17:37,385 Finished 9 from 16 processes 2025-09-06 04:17:42,389 Finished 9 from 16 processes 2025-09-06 04:17:47,393 Finished 9 from 16 processes 2025-09-06 04:17:52,397 Finished 9 from 16 processes 2025-09-06 04:17:57,401 Finished 9 from 16 processes 2025-09-06 04:18:02,405 Finished 9 from 16 processes 2025-09-06 04:18:07,409 Finished 9 from 16 processes 2025-09-06 04:18:12,413 Finished 9 from 16 processes 2025-09-06 04:18:17,417 Finished 9 from 16 processes 2025-09-06 04:18:22,421 Finished 9 from 16 processes 2025-09-06 04:18:27,425 Finished 9 from 16 processes 2025-09-06 04:18:32,429 Finished 9 from 16 processes 2025-09-06 04:18:37,433 Finished 9 from 16 processes 2025-09-06 04:18:42,437 Finished 9 from 16 processes 2025-09-06 04:18:47,441 Finished 9 from 16 processes 2025-09-06 04:18:52,445 Finished 9 from 16 processes 2025-09-06 04:18:57,449 Finished 9 from 16 processes 2025-09-06 04:19:02,453 Finished 10 from 16 processes 2025-09-06 04:19:07,457 Finished 10 from 16 processes 2025-09-06 04:19:12,461 Finished 10 from 16 processes 2025-09-06 04:19:17,465 Finished 11 from 16 processes 2025-09-06 04:19:22,469 Finished 11 from 16 processes 2025-09-06 04:19:27,473 Finished 11 from 16 processes 2025-09-06 04:19:32,477 Finished 11 from 16 processes 2025-09-06 04:19:37,481 Finished 11 from 16 processes 2025-09-06 04:19:42,485 Finished 11 from 16 processes 2025-09-06 04:19:47,489 Finished 11 from 16 processes 2025-09-06 04:19:52,493 Finished 11 from 16 processes 2025-09-06 04:19:57,493 Finished 11 from 16 processes 2025-09-06 04:20:02,495 Finished 11 from 16 processes 2025-09-06 04:20:07,497 Finished 12 from 16 processes 2025-09-06 04:20:12,502 Finished 12 from 16 processes 2025-09-06 04:20:17,507 Finished 12 from 16 processes 2025-09-06 04:20:22,509 Finished 12 from 16 processes 2025-09-06 04:20:27,514 Finished 12 from 16 processes 2025-09-06 04:20:32,515 Finished 12 from 16 processes 2025-09-06 04:20:37,520 Finished 12 from 16 processes 2025-09-06 04:20:42,525 Finished 12 from 16 processes 2025-09-06 04:20:47,529 Finished 12 from 16 processes 2025-09-06 04:20:52,533 Finished 12 from 16 processes 2025-09-06 04:20:57,538 Finished 12 from 16 processes 2025-09-06 04:21:02,541 Finished 12 from 16 processes 2025-09-06 04:21:07,545 Finished 12 from 16 processes 2025-09-06 04:21:12,549 Finished 12 from 16 processes 2025-09-06 04:21:17,553 Finished 12 from 16 processes 2025-09-06 04:21:22,557 Finished 12 from 16 processes 2025-09-06 04:21:27,562 Finished 12 from 16 processes 2025-09-06 04:21:32,565 Finished 12 from 16 processes 2025-09-06 04:21:37,569 Finished 12 from 16 processes 2025-09-06 04:21:42,574 Finished 12 from 16 processes 2025-09-06 04:21:47,579 Finished 12 from 16 processes 2025-09-06 04:21:52,581 Finished 12 from 16 processes 2025-09-06 04:21:57,581 Finished 12 from 16 processes 2025-09-06 04:22:02,587 Finished 12 from 16 processes 2025-09-06 04:22:07,589 Finished 12 from 16 processes 2025-09-06 04:22:12,594 Finished 12 from 16 processes 2025-09-06 04:22:17,597 Finished 12 from 16 processes 2025-09-06 04:22:22,602 Finished 12 from 16 processes 2025-09-06 04:22:27,607 Finished 12 from 16 processes 2025-09-06 04:22:32,609 Finished 12 from 16 processes 2025-09-06 04:22:37,613 Finished 12 from 16 processes 2025-09-06 04:22:42,615 Finished 12 from 16 processes 2025-09-06 04:22:47,617 Finished 12 from 16 processes 2025-09-06 04:22:52,621 Finished 12 from 16 processes 2025-09-06 04:22:57,623 Finished 12 from 16 processes 2025-09-06 04:23:02,625 Finished 12 from 16 processes 2025-09-06 04:23:07,627 Finished 12 from 16 processes 2025-09-06 04:23:12,633 Finished 12 from 16 processes 2025-09-06 04:23:17,636 Finished 12 from 16 processes 2025-09-06 04:23:22,641 Finished 12 from 16 processes 2025-09-06 04:23:27,645 Finished 12 from 16 processes 2025-09-06 04:23:32,650 Finished 12 from 16 processes 2025-09-06 04:23:37,653 Finished 12 from 16 processes 2025-09-06 04:23:42,657 Finished 12 from 16 processes 2025-09-06 04:23:47,661 Finished 12 from 16 processes 2025-09-06 04:23:52,665 Finished 12 from 16 processes 2025-09-06 04:23:57,669 Finished 12 from 16 processes 2025-09-06 04:24:02,670 Finished 12 from 16 processes 2025-09-06 04:24:07,676 Finished 12 from 16 processes 2025-09-06 04:24:12,681 Finished 12 from 16 processes 127.0.0.1 - - [06/Sep/2025:02:24:13 +0000] "PUT /devstoreaccount1/cont/ajdhlnnflpbanfjacadvgsmjeoefwsdy HTTP/1.1" 201 - 127.0.0.1 - - [06/Sep/2025:02:24:14 +0000] "PUT /devstoreaccount1/cont/khebpecuotabpjaksmunkzvijinpcimc HTTP/1.1" 201 - 127.0.0.1 - - [06/Sep/2025:02:24:14 +0000] "PUT /devstoreaccount1/cont/rlklfxyubozzysqdjcwdeflihfnszdxn HTTP/1.1" 201 - 127.0.0.1 - - [06/Sep/2025:02:24:14 +0000] "PUT /devstoreaccount1/cont/qrpezuwaxxiryttxqakehiidpgoyfzpy HTTP/1.1" 201 - 127.0.0.1 - - [06/Sep/2025:02:24:14 +0000] "PUT /devstoreaccount1/cont/oygwtizppiioxqkiazpysupkuqiuqigm HTTP/1.1" 201 - 127.0.0.1 - - [06/Sep/2025:02:24:14 +0000] "PUT /devstoreaccount1/cont/hexibjwcyxvbrdzheutltgnywjrhfwht HTTP/1.1" 201 - 127.0.0.1 - - [06/Sep/2025:02:24:14 +0000] "PUT /devstoreaccount1/cont/keltidmedrdplhbonezwkibiotjcgzry HTTP/1.1" 201 - 127.0.0.1 - - [06/Sep/2025:02:24:14 +0000] "PUT /devstoreaccount1/cont/qgjfqwrxyhomvogstaoxhikjafpgmzat HTTP/1.1" 201 - 127.0.0.1 - - [06/Sep/2025:02:24:14 +0000] "PUT /devstoreaccount1/cont/dthwsvkyatoifxoylonlqwzdslfkpwrf HTTP/1.1" 201 - 127.0.0.1 - - [06/Sep/2025:02:24:14 +0000] "PUT /devstoreaccount1/cont/ewvgypghacyrafsrossftdzhteotwwrl HTTP/1.1" 201 - 127.0.0.1 - - [06/Sep/2025:02:24:14 +0000] "GET /devstoreaccount1/cont/rlklfxyubozzysqdjcwdeflihfnszdxn HTTP/1.1" 206 80 127.0.0.1 - - [06/Sep/2025:02:24:14 +0000] "GET /devstoreaccount1/cont/khebpecuotabpjaksmunkzvijinpcimc HTTP/1.1" 206 746 2025-09-06 04:24:17,682 Finished 12 from 16 processes 2025-09-06 04:24:22,685 Finished 12 from 16 processes 2025-09-06 04:24:27,689 Finished 12 from 16 processes 2025-09-06 04:24:32,693 Finished 12 from 16 processes 2025-09-06 04:24:37,697 Finished 12 from 16 processes 2025-09-06 04:24:42,701 Finished 12 from 16 processes 2025-09-06 04:24:47,705 Finished 12 from 16 processes 2025-09-06 04:24:52,706 Finished 12 from 16 processes 127.0.0.1 - - [06/Sep/2025:02:24:56 +0000] "GET /devstoreaccount1/cont/rlklfxyubozzysqdjcwdeflihfnszdxn HTTP/1.1" 206 80 127.0.0.1 - - [06/Sep/2025:02:24:56 +0000] "GET /devstoreaccount1/cont/khebpecuotabpjaksmunkzvijinpcimc HTTP/1.1" 206 746 2025-09-06 04:24:57,712 Finished 12 from 16 processes 2025-09-06 04:25:02,717 Finished 12 from 16 processes 2025-09-06 04:25:07,722 Finished 12 from 16 processes 2025-09-06 04:25:12,725 Finished 12 from 16 processes 2025-09-06 04:25:17,729 Finished 12 from 16 processes 2025-09-06 04:25:22,733 Finished 12 from 16 processes 2025-09-06 04:25:27,737 Finished 12 from 16 processes 2025-09-06 04:25:32,741 Finished 12 from 16 processes 2025-09-06 04:25:37,745 Finished 12 from 16 processes 2025-09-06 04:25:42,750 Finished 12 from 16 processes 2025-09-06 04:25:47,755 Finished 12 from 16 processes 2025-09-06 04:25:52,760 Finished 12 from 16 processes 2025-09-06 04:25:57,765 Finished 12 from 16 processes 2025-09-06 04:26:02,769 Finished 12 from 16 processes 2025-09-06 04:26:07,769 Finished 12 from 16 processes 2025-09-06 04:26:12,773 Finished 12 from 16 processes 2025-09-06 04:26:17,777 Finished 12 from 16 processes 2025-09-06 04:26:22,781 Finished 12 from 16 processes 2025-09-06 04:26:27,785 Finished 12 from 16 processes 2025-09-06 04:26:32,789 Finished 12 from 16 processes 2025-09-06 04:26:37,793 Finished 12 from 16 processes 2025-09-06 04:26:42,797 Finished 12 from 16 processes 2025-09-06 04:26:47,801 Finished 12 from 16 processes 2025-09-06 04:26:52,805 Finished 12 from 16 processes 2025-09-06 04:26:57,806 Finished 12 from 16 processes 2025-09-06 04:27:02,811 Finished 12 from 16 processes 2025-09-06 04:27:07,816 Finished 12 from 16 processes 2025-09-06 04:27:12,817 Finished 12 from 16 processes 2025-09-06 04:27:17,821 Finished 12 from 16 processes 2025-09-06 04:27:22,825 Finished 12 from 16 processes 2025-09-06 04:27:27,829 Finished 12 from 16 processes 2025-09-06 04:27:32,831 Finished 12 from 16 processes 2025-09-06 04:27:37,833 Finished 12 from 16 processes 2025-09-06 04:27:42,834 Finished 12 from 16 processes 2025-09-06 04:27:47,834 Finished 12 from 16 processes 2025-09-06 04:27:52,837 Finished 12 from 16 processes 2025-09-06 04:27:57,842 Finished 13 from 16 processes 2025-09-06 04:28:02,845 Finished 13 from 16 processes 2025-09-06 04:28:07,849 Finished 13 from 16 processes 2025-09-06 04:28:12,853 Finished 13 from 16 processes 2025-09-06 04:28:17,857 Finished 13 from 16 processes 2025-09-06 04:28:22,861 Finished 13 from 16 processes 2025-09-06 04:28:27,866 Finished 14 from 16 processes 2025-09-06 04:28:32,869 Finished 14 from 16 processes 2025-09-06 04:28:37,873 Finished 14 from 16 processes 2025-09-06 04:28:42,877 Finished 15 from 16 processes 2025-09-06 04:28:47,881 Finished 15 from 16 processes 2025-09-06 04:28:52,885 Finished 15 from 16 processes 2025-09-06 04:28:57,889 Finished 15 from 16 processes 2025-09-06 04:29:02,893 Finished 15 from 16 processes 2025-09-06 04:29:07,898 Finished 15 from 16 processes 2025-09-06 04:29:12,903 Finished 15 from 16 processes 2025-09-06 04:29:17,905 Finished 15 from 16 processes 2025-09-06 04:29:22,909 Finished 15 from 16 processes 2025-09-06 04:29:27,914 Finished 15 from 16 processes 2025-09-06 04:29:32,917 Finished 15 from 16 processes 2025-09-06 04:29:37,921 Finished 15 from 16 processes 2025-09-06 04:29:42,925 Finished 15 from 16 processes 2025-09-06 04:29:47,929 Finished 15 from 16 processes 2025-09-06 04:29:52,934 Finished 15 from 16 processes 2025-09-06 04:29:57,937 Finished 15 from 16 processes 2025-09-06 04:30:02,941 Finished 15 from 16 processes 2025-09-06 04:30:07,946 Finished 15 from 16 processes 2025-09-06 04:30:12,951 Finished 15 from 16 processes 2025-09-06 04:30:17,953 Finished 15 from 16 processes 2025-09-06 04:30:22,958 Finished 15 from 16 processes 2025-09-06 04:30:27,963 Finished 15 from 16 processes 2025-09-06 04:30:32,965 Finished 15 from 16 processes 2025-09-06 04:30:37,970 Finished 15 from 16 processes 2025-09-06 04:30:42,975 Finished 15 from 16 processes 2025-09-06 04:30:47,977 Finished 15 from 16 processes 2025-09-06 04:30:52,981 Finished 15 from 16 processes 2025-09-06 04:30:57,982 Finished 15 from 16 processes 2025-09-06 04:31:02,987 Finished 15 from 16 processes 2025-09-06 04:31:07,989 Finished 15 from 16 processes 2025-09-06 04:31:12,994 All processes finished 2025-09-06 04:31:12,994 Compressing stress logs 2025-09-06 04:31:13,015 Logs compressed 2025-09-06 04:31:13,015 Will terminate gdb (if any) 2025-09-06 04:31:13,015 Running command: kill -TERM $(pidof gdb) 2025-09-06 04:31:13,018 Running command: timeout 50s tail --pid=$(pidof gdb) -f /dev/null || kill -9 $(pidof gdb) ||: 2025-09-06 04:31:14,035 Running command: kill -CONT $(cat /var/run/clickhouse-server/clickhouse-server.pid) && clickhouse client -q 'SELECT 1 FORMAT Null' 2025-09-06 04:31:14,351 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-09-06 04:31:14,716 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-09-06 04:31:14,931 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-09-06 04:31:15,146 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-09-06 04:31:15,310 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-09-06 04:31:15,525 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-09-06 04:31:15,739 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-09-06 04:31:15,954 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-09-06 04:31:16,169 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-09-06 04:31:16,384 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-09-06 04:31:16,598 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-09-06 04:31:16,813 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-09-06 04:31:17,028 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.018455938 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-09-06 04:32:17,871 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.10512.altinitytest @ f6c53af9730619e8f58bf3b144f970d5134a810e HEAD Running 1 stateless tests (MainProcess). 00001_select_1: [ OK ] 1 tests passed. 0 tests skipped. 0.22 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. 12811 0.057 1.30 MiB 0.045 1 78 ['Trace'] 0.19 Checking existence of path: {} 2. 7429 0.033 1.11 MiB 0.038 4346 88 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 3. 6713 0.03 189.43 KiB 0.006 1 88 ['Debug'] 0.123 Processed in {} sec. 4. 6625 0.029 1.29 MiB 0.044 1 89 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 5. 6008 0.027 159.15 KiB 0.005 1 109 ['Trace'] 0.001 Query to stage {}{} 6. 5962 0.026 730.98 KiB 0.025 1 6 ['Trace'] 1 Creating part at path {} 7. 5952 0.026 267.92 KiB 0.009 1 3 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 8. 5933 0.026 297.86 KiB 0.01 1 109 ['Trace'] 0.001 Query from stage {} to stage {}{} 9. 5482 0.024 385.57 KiB 0.013 1 600 ['Trace'] 0.781 Reserved {} on local disk {}, having unreserved {}. 10. 5321 0.024 369.02 KiB 0.012 151 565 ['Trace'] 0.781 Trying to reserve {} using storage policy from min volume index {} 11. 4790 0.021 222.87 KiB 0.007 4790 97 ['Debug'] 0.998 Authenticating user '{}' from {} 12. 4788 0.021 537.71 KiB 0.018 4788 97 ['Debug'] 0.998 {} Authenticated with global context as user {} 13. 4775 0.021 349.73 KiB 0.012 4775 88 ['Debug'] 1 Creating session context with user_id: {} 14. 4773 0.021 419.50 KiB 0.014 4773 96 ['Debug'] 0.998 {} Logout, user_id: {} 15. 4750 0.021 552.38 KiB 0.019 147 202 ['Trace'] 0.71 Renaming temporary part {} to {} with tid {}. 16. 4471 0.02 98.25 KiB 0.003 167 521 ['Trace'] 1 Execution took {} ms. 17. 4176 0.019 196.34 KiB 0.007 1 199 ['Trace'] 0.533 filled checksums {} 18. 4138 0.018 137.75 KiB 0.005 1 88 ['Trace'] 1 TCP Request. Address: {} 19. 4138 0.018 370.62 KiB 0.012 1 88 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 20. 4109 0.018 108.34 KiB 0.004 1 87 ['Debug'] 1 Done processing connection. 21. 4076 0.018 378.80 KiB 0.013 1 34 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 22. 3589 0.016 312.44 KiB 0.01 32 410 ['Trace'] 0.994 Insert entry {} to queue with type {} 23. 3059 0.014 243.76 KiB 0.008 1 76 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 24. 3046 0.014 149.87 KiB 0.005 1 112 ['Debug'] 0.267 Peak memory usage{}: {}. 25. 2873 0.013 690.32 KiB 0.023 11 27 ['Debug'] 0 ZooKeeperRetriesControl: {}: {}: retry_count={}/{} timeout={}ms error={} message={} 26. 2827 0.013 565.65 KiB 0.019 10 25 ['Trace'] 0 ZooKeeperRetriesControl: {}: setUserError: error={} message={} 27. 2200 0.01 126.28 KiB 0.004 16 39 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 28. 2198 0.01 78.10 KiB 0.003 16 39 ['Trace'] 1 Flushed system log up to offset {} 29. 2010 0.009 171.64 KiB 0.006 43 503 ['Trace'] 1 Scheduling next merge selecting task after {}ms, current attempt status: {} 30. 1983 0.009 230.43 KiB 0.008 1 21 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 31. 1975 0.009 154.81 KiB 0.005 32 186 ['Trace'] 0.697 Part {} is not stored on zero-copy replicated disk, blobs can be removed 32. 1795 0.008 384.19 KiB 0.013 3 61 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {} 33. 1793 0.008 1.03 MiB 0.036 2 61 ['Trace'] 1 Request URI: {} 34. 1711 0.008 35.09 KiB 0.001 2 61 ['Debug'] 0.672 Done processing query 35. 1687 0.007 235.32 KiB 0.008 32 497 ['Trace'] 1 Checked {} partitions, found {} partitions with parts that may be merged: [{}] (max_total_size_to_merge={}, merge_with_ttl_allowed={}) 36. 1584 0.007 162.03 KiB 0.005 1 7 ['Trace'] 0.5 Adding file: {}, size: {} 37. 1479 0.007 88.10 KiB 0.003 132 122 ['Debug'] 0.234 There are {} detached tables. Start searching non used tables. 38. 1479 0.007 62.11 KiB 0.002 132 122 ['Debug'] 0.234 Found {} non used tables in detached tables. 39. 1433 0.006 54.56 KiB 0.002 29 45 ['Debug'] 0.816 Committing part {} to zookeeper 40. 1433 0.006 126.75 KiB 0.004 1 103 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 41. 1317 0.006 48.93 KiB 0.002 29 32 ['Debug'] 0.853 Part {} committed to zookeeper 42. 1194 0.005 26.82 KiB 0.001 1 103 ['Trace'] 0 Merging aggregated data 43. 1150 0.005 98.83 KiB 0.003 23 32 ['Trace'] 1 Trying to fetch with zero-copy replication, but disk is not provided, will try to select 44. 1150 0.005 25.83 KiB 0.001 23 14 ['Trace'] 1 Sending part {} 45. 1150 0.005 61.77 KiB 0.002 23 32 ['Debug'] 1 Download of part {} onto disk {} finished. 46. 1150 0.005 41.55 KiB 0.001 23 32 ['Trace'] 1 Checking disk {} with type {} 47. 1150 0.005 21.96 KiB 0.001 23 32 ['Debug'] 1 Downloading files {} 48. 1150 0.005 136.63 KiB 0.005 23 32 ['Debug'] 1 Fetching part {} from {}:{} 49. 1150 0.005 97.71 KiB 0.003 23 32 ['Trace'] 1 Disk for fetch is not provided, getting disk from reservation {} with type '{}' 50. 1150 0.005 51.66 KiB 0.002 23 32 ['Debug'] 1 Downloading part {} onto disk {}. 51. 1123 0.005 131.94 KiB 0.004 23 32 ['Debug'] 1 Fetched part {} from {}:{}{} 52. 1099 0.005 87.09 KiB 0.003 80 65 ['Trace'] 0 Reading {} ranges in{}order from part {}, approx. {} rows starting from {} 53. 1070 0.005 129.79 KiB 0.004 1 6 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 54. 1054 0.005 52.04 KiB 0.002 1 21 ['Trace'] 0 Merging partially aggregated blocks (bucket = {}). 55. 1054 0.005 158.41 KiB 0.005 1 21 ['Debug'] 0 Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.) 56. 1019 0.005 50.42 KiB 0.002 48 428 ['Debug'] 0.989 Selected {} parts from {} to {} 57. 939 0.004 27.92 KiB 0.001 1 105 ['Trace'] 0 Aggregation method: {} 58. 910 0.004 66.20 KiB 0.002 50 31 ['Debug'] 1 Skipping action for part {} because part {} already exists. 59. 850 0.004 48.99 KiB 0.002 32 405 ['Debug'] 0.993 Pulling {} entries to queue: {} - {} 60. 848 0.004 21.55 KiB 0.001 32 405 ['Debug'] 0.993 Pulled {} entries to queue. 61. 835 0.004 2.20 MiB 0.076 2 28 ['Error'] 0.986 Setting {} should not be changed 62. 818 0.004 59.29 KiB 0.002 29 49 ['Debug'] 0 Wrote block with ID '{}', {} rows{} 63. 785 0.003 26.82 KiB 0.001 1 34 ['Debug'] 0 Selected MergeAlgorithm: {} 64. 785 0.003 63.41 KiB 0.002 1 34 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {} 65. 738 0.003 96.24 KiB 0.003 1 32 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec. 66. 733 0.003 45.78 KiB 0.002 53 34 ['Trace'] 0 Merged {} parts: [{}, {}] -> {} 67. 704 0.003 20.63 KiB 0.001 44 396 ['Debug'] 0.993 Updating strategy picker state 68. 677 0.003 84.15 KiB 0.003 92 158 ['Debug'] 0.999 Removing {} parts from filesystem (serially): Parts: [{}] 69. 653 0.003 133.72 KiB 0.004 16 297 ['Information'] 1 Not executing log entry {} of type {} for part {} (actual part {})because another log entry {} of type {} for the same part ({}) is being processed. 70. 652 0.003 50.30 KiB 0.002 1 76 ['Trace'] 0 Query span trace_id for opentelemetry log: {} 71. 650 0.003 71.44 KiB 0.002 53 133 ['Trace'] 0.998 Found {} old parts to remove. Parts: [{}] 72. 637 0.003 70.88 KiB 0.002 53 122 ['Debug'] 0.998 Removing {} parts from memory: Parts: [{}] 73. 626 0.003 36.24 KiB 0.001 2 11 ['Trace'] 0.978 Loading config file '{}'. 74. 620 0.003 64.59 KiB 0.002 35 372 ['Debug'] 0.992 Strategy picker state updated, current replica: {}, active replicas: [{}] 75. 597 0.003 23.96 KiB 0.001 103 88 ['Debug'] 0 Key condition: {} 76. 582 0.003 25.58 KiB 0.001 102 88 ['Trace'] 0 Filtering marks by primary and secondary keys 77. 566 0.003 6.08 KiB 0 1 94 ['Trace'] 0 Aggregating 78. 561 0.002 64.33 KiB 0.002 103 88 ['Debug'] 0 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 79. 546 0.002 44.10 KiB 0.001 1 91 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 80. 542 0.002 65.94 KiB 0.002 10 30 ['Information'] 0 Block with ID {} {} as part {}; ignoring it. 81. 530 0.002 84.77 KiB 0.003 1 30 ['Debug'] 0 Deduplication path already exists: deduplication_path={} 82. 520 0.002 51.16 KiB 0.002 24 337 ['Trace'] 1 Scheduling next cleanup after {}ms (points: {}, interval: {}ms, ratio: {}, points per minute: {}) 83. 518 0.002 20.74 KiB 0.001 14 86 ['Trace'] 0.006 Sending external_roles with query: [{}] ({}) 84. 511 0.002 26.45 KiB 0.001 92 84 ['Trace'] 0 Spreading mark ranges among streams (default reading) 85. 434 0.002 13.87 KiB 0 10 77 ['Trace'] 0 Found {} range {}in {} steps 86. 434 0.002 12.46 KiB 0 10 77 ['Trace'] 0 Found (LEFT) boundary mark: {} 87. 434 0.002 12.89 KiB 0 10 77 ['Trace'] 0 Found (RIGHT) boundary mark: {} 88. 434 0.002 29.59 KiB 0.001 10 77 ['Trace'] 0 Running binary search on index range for part {} ({} marks) 89. 425 0.002 17.02 KiB 0.001 25 115 ['Debug'] 0.482 Will use old analyzer to prepare mutation 90. 419 0.002 1.66 MiB 0.057 22 83 ['Error'] 0.179 Cannot schedule a task: {} (threads={}, jobs={}) 91. 402 0.002 47.04 KiB 0.002 309 16 ['Trace'] 1 Executing log entry to merge parts {} to {} 92. 394 0.002 31.47 KiB 0.001 1 94 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={} 93. 380 0.002 11.86 KiB 0 20 13 ['Debug'] 0 Requested flush up to offset {} 94. 377 0.002 19.24 KiB 0.001 15 76 ['Trace'] 0.008 Connecting. Database: {}. User: {}{}{} 95. 353 0.002 16.20 KiB 0.001 14 70 ['Trace'] 0.008 Connected to {} server version {}.{}.{}. 96. 349 0.002 9.90 KiB 0 1 139 ['Debug'] 1 Stop worker in {} 97. 349 0.002 13.67 KiB 0 1 120 ['Debug'] 0.622 Spawn loader worker #{} in {} 98. 348 0.002 23.50 KiB 0.001 1 111 ['Debug'] 1 Finish load job '{}' with status {} 99. 348 0.002 24.88 KiB 0.001 1 111 ['Debug'] 1 Execute load job '{}' in {} 100. 348 0.002 25.90 KiB 0.001 1 45 ['Debug'] 0.239 Schedule load job '{}' into {} 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. 66 CodeDBExceptionReceivedfromDBExc Code: 439. DB::Exception: Received from 127.0.0.7:9000. DB::Exception: Cannot schedule a task: fault injected (threads=747, jobs=746). Stack trace: 0. std::exception::capture() @ 0x0000000018f2c98b 1. ./build_docker/./base/poco/Foundation/src/Exception.cp ('/executeQuery.cpp',221) 2. 39 voidDBReplicatedMergeTreeCleanup void DB::ReplicatedMergeTreeCleanupThread::run(): Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. std::exception::capture() @ 0x0000000018f2c98b 1. ./buil ('/Exception.cpp',273) 3. 33 autoDBStorageReplicatedMergeTree auto DB::StorageReplicatedMergeTree::processQueueEntry(ReplicatedMergeTreeQueue::SelectedEntryPtr)::(anonymous class)::operator()(LogEntryPtr &) const: Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this ('/Exception.cpp',273) 4. 24 voidDBStorageReplicatedMergeTree void DB::StorageReplicatedMergeTree::queueUpdatingTask(): Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. std::exception::capture() @ 0x0000000018f2c98b 1 ('/Exception.cpp',273) 5. 22 virtualboolDBReplicatedMergeMuta virtual bool DB::ReplicatedMergeMutateTaskBase::executeStep(): Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. std::exception::capture() @ 0x0000000018f2c ('/Exception.cpp',273) 6. 22 Exceptionwhileexecutingbackgroun Exception while executing background task {82e41346-68bd-41e6-aae4-39842f227f29::-7_0_44_1}: Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. std::exceptio ('/Exception.cpp',273) 7. 16 CodeCoordinationExceptionSession Code: 999. Coordination::Exception: Session expired (fault injected on recv). (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. std::exception::capture() @ 0x0000000018f2c98b 1. ./build_docker/./base/poco/Foun ('/Exception.cpp',273) 8. 6 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 0 ('/LoggerWrapper.h',43) 9. 4 CodeDBExceptionSyntaxerrorfailed Code: 62. DB::Exception: Syntax error: failed at position 1 ('BAD'): BAD SQL. Expected one of: Query, Query with output, EXPLAIN, EXPLAIN, SELECT query, possibly with UNION, list of union elements, SELECT query, subquery, possibly with UNION, SELECT subque ('/executeQuery.cpp',221) 10. 3 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',43) 11. 3 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',43) 12. 3 StartingClickHousealtinitytestre Starting ClickHouse 24.8.14.10512.altinitytest (revision: 4294967295, git hash: f6c53af9730619e8f58bf3b144f970d5134a810e, build id: 243794D988420F3C4CE8867FCCEFFF7317E24ED3), PID 408 ('',0) 13. 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) 14. 3 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 15. 3 statemachinecommitindexprecommit state machine commit index 0, precommit index 0, last log index 0 ('/LoggerWrapper.h',43) 16. 3 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',43) 17. 3 skippedconfiglatestconfig skipped config 1, latest config 1 ('/LoggerWrapper.h',43) 18. 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) 19. 3 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1 my id: 1, voting_member num peers: 0 ('/LoggerWrapper.h',43) 20. 3 Forkedachildprocesstowatch Forked a child process to watch ('',0) 21. 3 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 22. 3 startingup starting up ('',0) 23. 3 newelectiontimeoutrange new election timeout range: 0 - 0 ('/LoggerWrapper.h',43) 24. 3 PRIORITYdecaytargetmine [PRIORITY] decay, target 1 -> 1, mine 1 ('/LoggerWrapper.h',43) 25. 3 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 1 ('/LoggerWrapper.h',43) 26. 3 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',43) 27. 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) 28. 3 RaftASIOlistenerinitiatedonunsec Raft ASIO listener initiated on :::9234, unsecured ('/LoggerWrapper.h',43) 29. 3 newconfiglogidxprevlogidxcurconf new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0 ('/LoggerWrapper.h',43) 30. 3 numberofpendingcommitelements number of pending commit elements: 0 ('/LoggerWrapper.h',43) Top messages not matching their format strings: message_format_string count() any_message 1. 86 Forked a child process to watch 2. {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 3 /var/lib/clickhouse/store/1a3/1a3173cb-bf39-40f8-bab7-5893f45c8cef/tmp_insert_201403_8_8_0/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 9 similar messages) 3. Close WriteBufferFromAzureBlobStorage. {}. 1 Close WriteBufferFromAzureBlobStorage. ajdhlnnflpbanfjacadvgsmjeoefwsdy. (LogSeriesLimiter: on interval from 2025-09-06 04:07:26 to 2025-09-06 04:24:13 accepted series 1 / 1 for the logger WriteBufferFromAzureBlobStorage) Top short messages: c message_format_string substr(any(toValidUTF8(message)), 1, 120) min_length_without_exception_boilerplate 1. 16 {} ThreadFuzzer is enabled. Application will run slowly and unstable. 40 2. 6 Cannot TRUNCATE dictionary Code: 62. DB::Exception: Cannot TRUNCATE dictionary. (SYNTAX_ERROR) (version 24.8.14.10512.altinitytest (altinity build) 27 3. 2 Found {} on {} Found changelog_1_100000.bin on LocalLogDisk 18 4. 2 Creating {}: {} Creating table test_3.tbl: CREATE TABLE IF NOT EXISTS test_3.tbl UUID '1aca914f-8939-43a6-99c6-c17c29526a43' (`x` Int64) 164 Top messages by level: (0.0037022421842785504,'Setting {} should not be changed') Error (0.0013124116006544323,'ZooKeeper session has expired. Switching to a new session.') Warning (0.002895286402795082,'Not executing log entry {} of type {} for part {} (actual part {})because another log entry {} of type {} for the same part ({}) is being processed.') Information (0.029764253632409473,'Processed in {} sec.') Debug (0.05680170613508085,'Checking existence of path: {}') Trace 2025-09-06 04:32:19,891 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=2615 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2615. The process with pid = 2615 is running. Sent terminate signal to process with pid 2615. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2615. The process with pid = 2615 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2615. The process with pid = 2615 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2615. The process with pid = 2615 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2615. The process with pid = 2615 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2615. The process with pid = 2615 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2615. The process with pid = 2615 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2615. The process with pid = 2615 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 127.0.0.1 - - [06/Sep/2025:02:32:27 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - 127.0.0.1 - - [06/Sep/2025:02:32:27 +0000] "PUT /devstoreaccount1/cont/vayequjgmwxykpaxlfevaawoyqlrvmwd HTTP/1.1" 201 - 127.0.0.1 - - [06/Sep/2025:02:32:27 +0000] "GET /devstoreaccount1/cont/vayequjgmwxykpaxlfevaawoyqlrvmwd HTTP/1.1" 206 4 127.0.0.1 - - [06/Sep/2025:02:32:27 +0000] "GET /devstoreaccount1/cont/vayequjgmwxykpaxlfevaawoyqlrvmwd HTTP/1.1" 206 2 127.0.0.1 - - [06/Sep/2025:02:32:27 +0000] "DELETE /devstoreaccount1/cont/vayequjgmwxykpaxlfevaawoyqlrvmwd HTTP/1.1" 202 - + 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 127.0.0.1 - - [06/Sep/2025:02:32:28 +0000] "GET /devstoreaccount1/cont/ajdhlnnflpbanfjacadvgsmjeoefwsdy HTTP/1.1" 206 1 127.0.0.1 - - [06/Sep/2025:02:32:28 +0000] "GET /devstoreaccount1/cont/keltidmedrdplhbonezwkibiotjcgzry HTTP/1.1" 206 65 127.0.0.1 - - [06/Sep/2025:02:32:28 +0000] "GET /devstoreaccount1/cont/hexibjwcyxvbrdzheutltgnywjrhfwht HTTP/1.1" 206 155 127.0.0.1 - - [06/Sep/2025:02:32:28 +0000] "GET /devstoreaccount1/cont/qgjfqwrxyhomvogstaoxhikjafpgmzat HTTP/1.1" 206 1 127.0.0.1 - - [06/Sep/2025:02:32:28 +0000] "GET /devstoreaccount1/cont/ewvgypghacyrafsrossftdzhteotwwrl HTTP/1.1" 206 225 127.0.0.1 - - [06/Sep/2025:02:32:28 +0000] "GET /devstoreaccount1/cont/rlklfxyubozzysqdjcwdeflihfnszdxn HTTP/1.1" 206 80 127.0.0.1 - - [06/Sep/2025:02:32:28 +0000] "GET /devstoreaccount1/cont/oygwtizppiioxqkiazpysupkuqiuqigm HTTP/1.1" 206 3 127.0.0.1 - - [06/Sep/2025:02:32:28 +0000] "GET /devstoreaccount1/cont/dthwsvkyatoifxoylonlqwzdslfkpwrf HTTP/1.1" 206 10 + counter=3 + 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=7, jobs=7). (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)' Received exception from server (version 24.8.14): Code: 439. DB::Exception: Received from localhost:9000. DB::Exception: Cannot schedule a task: fault injected (threads=15, jobs=15). (CANNOT_SCHEDULE_TASK) (query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value)) ++ retry=2 ++ sleep 5 ++ '[' 2 -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=11, jobs=11). (CANNOT_SCHEDULE_TASK) (query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value)) ++ retry=3 ++ sleep 5 ++ '[' 3 -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=0 + [[ 0 = \1 ]] ++ kill -l SIGRTMIN + RTMIN=34 + echo ' set follow-fork-mode parent handle SIGHUP nostop noprint pass handle SIGINT nostop noprint pass handle SIGQUIT nostop noprint pass handle SIGPIPE nostop noprint pass handle SIGTERM nostop noprint pass handle SIGUSR1 nostop noprint pass handle SIGUSR2 nostop noprint pass handle SIG34 nostop noprint pass info signals continue backtrace full info registers p top' 1 KiB of the 'stack: p/x *(uint64_t[128]*)$sp maintenance info sections thread apply all backtrace full disassemble /s up disassemble /s up disassemble /s p "done" detach quit ' + sleep 5 + ts '%Y-%m-%d %H:%M:%S' ++ cat /var/run/clickhouse-server/clickhouse-server.pid + gdb -batch -command script.gdb -p 25477 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + 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=25477 + clickhouse stop --max-tries 90 --do-not-kill script.gdb:13: Error in sourced command file: No stack. /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 25477. The process with pid = 25477 is running. Sent terminate signal to process with pid 25477. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 25477. The process with pid = 25477 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 25477. The process with pid = 25477 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 25477. The process with pid = 25477 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 25477. The process with pid = 25477 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 25477. The process with pid = 25477 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 25477. The process with pid = 25477 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 25477. The process with pid = 25477 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' + grep SharedMergeTreePartCheckThread + 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 + 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/gdb.log /test_output/stress_run_logs.tar.zst /test_output/test_results.tsv + rg -Fa ' received signal ' /test_output/gdb.log + 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 - - [06/Sep/2025:02:33:00 +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 - - [06/Sep/2025:02:33:03 +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.metric_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 - - [06/Sep/2025:02:33:04 +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