+ 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 + source /stress_tests.lib ++ sysctl kernel.core_pattern=core.%e.%p-%P kernel.core_pattern = core.%e.%p-%P ++ OK='\tOK\t\N\t' ++ FAIL='\tFAIL\t\N\t' ++ FAILURE_CONTEXT_LINES=100 ++ FAILURE_CONTEXT_MAX_LINE_WIDTH=300 + install_packages package_folder + dpkg -i package_folder/clickhouse-common-static_24.3.5.48.altinityfips+ubsan_amd64.deb Selecting previously unselected package clickhouse-common-static. (Reading database ... 49227 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static_24.3.5.48.altinityfips+ubsan_amd64.deb ... Unpacking clickhouse-common-static (24.3.5.48.altinityfips+ubsan) ... Setting up clickhouse-common-static (24.3.5.48.altinityfips+ubsan) ... + dpkg -i package_folder/clickhouse-common-static-dbg_24.3.5.48.altinityfips+ubsan_amd64.deb Selecting previously unselected package clickhouse-common-static-dbg. (Reading database ... 49256 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static-dbg_24.3.5.48.altinityfips+ubsan_amd64.deb ... Unpacking clickhouse-common-static-dbg (24.3.5.48.altinityfips+ubsan) ... Setting up clickhouse-common-static-dbg (24.3.5.48.altinityfips+ubsan) ... + dpkg -i package_folder/clickhouse-server_24.3.5.48.altinityfips+ubsan_amd64.deb Selecting previously unselected package clickhouse-server. (Reading database ... 49265 files and directories currently installed.) Preparing to unpack .../clickhouse-server_24.3.5.48.altinityfips+ubsan_amd64.deb ... Unpacking clickhouse-server (24.3.5.48.altinityfips+ubsan) ... Setting up clickhouse-server (24.3.5.48.altinityfips+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/' groupadd -r clickhouse-bridge useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse-bridge clickhouse-bridge chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-odbc-bridge' chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-library-bridge' 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.3.5.48.altinityfips+ubsan_amd64.deb Selecting previously unselected package clickhouse-client. (Reading database ... 49282 files and directories currently installed.) Preparing to unpack .../clickhouse-client_24.3.5.48.altinityfips+ubsan_amd64.deb ... Unpacking clickhouse-client (24.3.5.48.altinityfips+ubsan) ... Setting up clickhouse-client (24.3.5.48.altinityfips+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' + 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/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/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/reverse_dns_query_function.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/ + '[' /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/ + value=1 + sed --follow-symlinks -i 's|[01]|1|' /etc/clickhouse-server/config.d/keeper_port.xml + value=36417536 + sed --follow-symlinks -i 's|[[:digit:]]\+|36417536|' /etc/clickhouse-server/config.d/keeper_port.xml + value=35700736 + sed --follow-symlinks -i 's|[[:digit:]]\+|35700736|' /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/ + [[ -n '' ]] + ARM=aarch64 ++ uname -m + OS=x86_64 x86_64 Adding azure configuration + [[ -n 1 ]] + echo x86_64 + [[ '' -eq 1 ]] + [[ x86_64 == \a\a\r\c\h\6\4 ]] + echo 'Adding azure configuration' + 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=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=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 allow_experimental_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 + 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 + echo '1' + local total_mem ++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo + total_mem=32086448 + total_mem=32856522752 + 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 + local max_users_mem + max_users_mem=9856956825 + echo 'Setting max_memory_usage_for_user=9856956825 and max_memory_usage for queries to 10G' + cat Setting max_memory_usage_for_user=9856956825 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 Azurite Blob service is starting on 0.0.0.0:10000 Azurite Blob service successfully listens on http://0.0.0.0:10000 minio version RELEASE.2022-01-03T18-22-58Z + wait_for_it + local counter=0 + ./minio server --address :11111 ./minio_data + local max_counter=60 + local url=http://localhost:11111 + params=('--silent' '--verbose') + local params + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 0 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=1 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 1 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=2 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 2 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=3 + grep AccessDenied + curl --silent --verbose http://localhost:11111 + [[ 3 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=4 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 4 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=5 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 5 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=6 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 6 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=7 + grep AccessDenied + curl --silent --verbose http://localhost:11111 + [[ 7 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=8 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 8 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=9 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 9 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=10 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 10 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 API: http://172.17.0.2:11111 http://127.0.0.1:11111 Console: http://172.17.0.2:34983 http://127.0.0.1:34983 Documentation: https://docs.min.io WARNING: Console endpoint is listening on a dynamic port (34983), please use --console-address ":PORT" to choose a static port. + counter=11 + grep AccessDenied + curl --silent --verbose http://localhost:11111 AccessDeniedAccess Denied./17F0CA91379326E63243e3c0-db63-4405-b30b-f11a80c41326 + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 290 root 10u IPv6 39185 0t0 TCP *: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 set clickminio readwrite user=test Policy `readwrite` is set on user `test` + ./mc mb clickminio/test Bucket created successfully `clickminio/test`. + '[' stateless = stateless ']' + ./mc policy 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 ++ ls /usr/share/clickhouse-test/queries/0_stateless/data_minio + for file in $(ls "${data_path}") + echo 02366_data.jsonl + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl clickminio/test/02366_data.jsonl 02366_data.jsonl `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl` -> `clickminio/test/02366_data.jsonl` Total: 0 B, Transferred: 0 B, Speed: 0 B/s + for file in $(ls "${data_path}") + echo 02731.arrow + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow clickminio/test/02731.arrow 02731.arrow `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow` -> `clickminio/test/02731.arrow` Total: 0 B, Transferred: 3.82 MiB, Speed: 111.25 MiB/s 02731.parquet + for file in $(ls "${data_path}") + echo 02731.parquet + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet clickminio/test/02731.parquet `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet` -> `clickminio/test/02731.parquet` Total: 0 B, Transferred: 1.57 MiB, Speed: 108.81 MiB/s 02876.parquet + for file in $(ls "${data_path}") + echo 02876.parquet + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02876.parquet clickminio/test/02876.parquet `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02876.parquet` -> `clickminio/test/02876.parquet` Total: 0 B, Transferred: 293 B, Speed: 42.51 KiB/s a.tsv + for file in $(ls "${data_path}") + echo a.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv clickminio/test/a.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv` -> `clickminio/test/a.tsv` Total: 0 B, Transferred: 24 B, Speed: 3.15 KiB/s b.tsv + for file in $(ls "${data_path}") + echo b.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv clickminio/test/b.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv` -> `clickminio/test/b.tsv` Total: 0 B, Transferred: 33 B, Speed: 3.50 KiB/s c.tsv + for file in $(ls "${data_path}") + echo c.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv clickminio/test/c.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv` -> `clickminio/test/c.tsv` Total: 0 B, Transferred: 33 B, Speed: 3.96 KiB/s tsv_with_header.tsv + for file in $(ls "${data_path}") + echo tsv_with_header.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv clickminio/test/tsv_with_header.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv` -> `clickminio/test/tsv_with_header.tsv` Total: 0 B, Transferred: 44 B, Speed: 4.98 KiB/s + setup_aws_credentials + local minio_root_user=clickhouse + local minio_root_password=clickhouse + mkdir -p /root/.aws + cat + config_logs_export_cluster /etc/clickhouse-server/config.d/system_logs_export.yaml + set +x File /tmp/export-logs-config.sh does not exist, do not setup + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root 127.0.0.1 - - [31/Aug/2024:10:49:53 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:10:49:53 +0000] "PUT /devstoreaccount1/cont/rwfxblijusjtouqygnvuwoggchxeejka?blockid=cmdeexopfidonxnnvrabugzxotfalmqurzdozdvqpdfsfkcjjgjenyceuyoyhspt&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:10:49:53 +0000] "PUT /devstoreaccount1/cont/rwfxblijusjtouqygnvuwoggchxeejka?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:10:49:53 +0000] "GET /devstoreaccount1/cont/rwfxblijusjtouqygnvuwoggchxeejka HTTP/1.1" 206 4 127.0.0.1 - - [31/Aug/2024:10:49:53 +0000] "GET /devstoreaccount1/cont/rwfxblijusjtouqygnvuwoggchxeejka HTTP/1.1" 206 2 127.0.0.1 - - [31/Aug/2024:10:49:53 +0000] "DELETE /devstoreaccount1/cont/rwfxblijusjtouqygnvuwoggchxeejka HTTP/1.1" 202 - + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ 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 thread apply all backtrace full info registers 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 571 + 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=571 + 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 = 571. The process with pid = 571 is running. Sent terminate signal to process with pid 571. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 571. The process with pid = 571 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 571. The process with pid = 571 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 571. The process with pid = 571 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 571. The process with pid = 571 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 571. The process with pid = 571 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 571. The process with pid = 571 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 571. The process with pid = 571 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 571. The process with pid = 571 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 571. The process with pid = 571 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 571. The process with pid = 571 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 571. The process with pid = 571 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 571. The process with pid = 571 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 571. The process with pid = 571 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 571. The process with pid = 571 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 ']' + 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 - - [31/Aug/2024:10:51:24 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [31/Aug/2024:10:51:24 +0000] "PUT /devstoreaccount1/cont/llqqjpecfzqaggkmurjkxhwpqdrkxsmt?blockid=ykzanyrhutjqewjghzbkgmznyodyrdtnomfxchkvgbpaspcugohijyqbckhabgik&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:10:51:24 +0000] "PUT /devstoreaccount1/cont/llqqjpecfzqaggkmurjkxhwpqdrkxsmt?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:10:51:24 +0000] "GET /devstoreaccount1/cont/llqqjpecfzqaggkmurjkxhwpqdrkxsmt HTTP/1.1" 206 4 127.0.0.1 - - [31/Aug/2024:10:51:24 +0000] "GET /devstoreaccount1/cont/llqqjpecfzqaggkmurjkxhwpqdrkxsmt HTTP/1.1" 206 2 127.0.0.1 - - [31/Aug/2024:10:51:24 +0000] "DELETE /devstoreaccount1/cont/llqqjpecfzqaggkmurjkxhwpqdrkxsmt 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' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 15 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=16 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 16 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=17 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 17 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=18 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 18 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=19 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 19 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=20 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 20 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=21 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 21 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=22 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 22 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=23 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 23 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=24 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 24 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=25 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 25 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=26 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 26 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=27 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 27 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=28 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 28 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=29 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ 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 thread apply all backtrace full info registers 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 1406 + 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' + clickhouse-client --query 'CREATE TABLE test.hits_s3 (WatchID UInt64, JavaEnable UInt8, Title String, GoodEvent Int16, EventTime DateTime, EventDate Date, CounterID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RegionID UInt32, UserID UInt64, CounterClass Int8, OS UInt8, UserAgent UInt8, URL String, Referer String, URLDomain String, RefererDomain String, Refresh UInt8, IsRobot UInt8, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32), RefererRegions Array(UInt32), ResolutionWidth UInt16, ResolutionHeight UInt16, ResolutionDepth UInt8, FlashMajor UInt8, FlashMinor UInt8, FlashMinor2 String, NetMajor UInt8, NetMinor UInt8, UserAgentMajor UInt16, UserAgentMinor FixedString(2), CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, MobilePhone UInt8, MobilePhoneModel String, Params String, IPNetworkID UInt32, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, IsArtifical UInt8, WindowClientWidth UInt16, WindowClientHeight UInt16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 UInt8, SilverlightVersion2 UInt8, SilverlightVersion3 UInt32, SilverlightVersion4 UInt16, PageCharset String, CodeVersion UInt32, IsLink UInt8, IsDownload UInt8, IsNotBounce UInt8, FUniqID UInt64, HID UInt32, IsOldCounter UInt8, IsEvent UInt8, IsParameter UInt8, DontCountHits UInt8, WithHash UInt8, HitColor FixedString(1), UTCEventTime DateTime, Age UInt8, Sex UInt8, Income UInt8, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), RemoteIP UInt32, RemoteIP6 FixedString(16), WindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage FixedString(2), BrowserCountry FixedString(2), SocialNetwork String, SocialAction String, HTTPError UInt16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, FetchTiming Int32, RedirectTiming Int32, DOMInteractiveTiming Int32, DOMContentLoadedTiming Int32, DOMCompleteTiming Int32, LoadEventStartTiming Int32, LoadEventEndTiming Int32, NSToDOMContentLoadedTiming Int32, FirstPaintTiming Int32, RedirectCount Int8, SocialSourceNetworkID UInt8, SocialSourcePage String, ParamPrice Int64, ParamOrderID String, ParamCurrency FixedString(3), ParamCurrencyID UInt16, GoalsReached Array(UInt32), OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, RefererHash UInt64, URLHash UInt64, CLID UInt32, YCLID UInt64, ShareService String, ShareURL String, ShareTitle String, ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64), IslandID FixedString(16), RequestNum UInt32, RequestTry UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate) ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''s3_cache'\''' + clickhouse-client --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='\''s3_cache'\''' + 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='\''s3_cache'\''' + clickhouse-client --query 'INSERT INTO test.hits_s3 SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0' + clickhouse-client --query 'INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0' + clickhouse-client --query 'INSERT INTO test.visits SELECT * FROM datasets.visits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0' + 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=1406 + 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 = 1406. The process with pid = 1406 is running. Sent terminate signal to process with pid 1406. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1406. The process with pid = 1406 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1406. The process with pid = 1406 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1406. The process with pid = 1406 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + export USE_S3_STORAGE_FOR_MERGE_TREE=1 + USE_S3_STORAGE_FOR_MERGE_TREE=1 + export RANDOMIZE_OBJECT_KEY_TYPE=1 + RANDOMIZE_OBJECT_KEY_TYPE=1 + 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 Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server' + mkdir -p /etc/clickhouse-server/config.d/ + mkdir -p /etc/clickhouse-server/users.d/ + mkdir -p /etc/clickhouse-client + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/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/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/reverse_dns_query_function.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/ + '[' /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/ + value=0 + sed --follow-symlinks -i 's|[01]|0|' /etc/clickhouse-server/config.d/keeper_port.xml + value=10153984 + sed --follow-symlinks -i 's|[[:digit:]]\+|10153984|' /etc/clickhouse-server/config.d/keeper_port.xml + value=5222400 + sed --follow-symlinks -i 's|[[:digit:]]\+|5222400|' /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/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + object_key_types_options=("generate-suffix" "generate-full-key" "generate-template-key") + object_key_type=generate-suffix + [[ -n 1 ]] + [[ 1 -eq 1 ]] + object_key_type=generate-template-key + case $object_key_type in + ln -sf /usr/share/clickhouse-test/config/config.d/storage_metadata_with_full_object_key.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/s3_storage_policy_with_template_object_key.xml /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + ARM=aarch64 ++ uname -m + OS=x86_64 x86_64 Adding azure configuration + [[ -n 1 ]] + echo x86_64 + [[ '' -eq 1 ]] + [[ x86_64 == \a\a\r\c\h\6\4 ]] + echo 'Adding azure configuration' + 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=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 allow_experimental_block_number_column block_number + value=1 + sudo cat /etc/clickhouse-server/config.d/block_number.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml + 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 + echo '1' + local total_mem ++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo + total_mem=32086448 + total_mem=32856522752 + 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=9856956825 + echo 'Setting max_memory_usage_for_user=9856956825 and max_memory_usage for queries to 10G' + cat Setting max_memory_usage_for_user=9856956825 and max_memory_usage for queries to 10G + cat + sudo cat /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sed 's|
s3
|
s3
default|' + mv /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml.tmp /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + 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 + '[' 1 -eq 1 ']' + sudo echo 'true' + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root 127.0.0.1 - - [31/Aug/2024:11:04:05 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - + sleep 0.5 127.0.0.1 - - [31/Aug/2024:11:04:05 +0000] "PUT /devstoreaccount1/cont/osrneqtnkffhixghrvzrpydumyapesxl?blockid=xihryzhejxvqdeddskpardpucgrbliooljatxrdvgxbmkegxnvozdeqwstbclfjb&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:11:04:05 +0000] "PUT /devstoreaccount1/cont/osrneqtnkffhixghrvzrpydumyapesxl?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:11:04:05 +0000] "GET /devstoreaccount1/cont/osrneqtnkffhixghrvzrpydumyapesxl HTTP/1.1" 206 4 127.0.0.1 - - [31/Aug/2024:11:04:05 +0000] "GET /devstoreaccount1/cont/osrneqtnkffhixghrvzrpydumyapesxl HTTP/1.1" 206 2 127.0.0.1 - - [31/Aug/2024:11:04:05 +0000] "DELETE /devstoreaccount1/cont/osrneqtnkffhixghrvzrpydumyapesxl HTTP/1.1" 202 - + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ 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 thread apply all backtrace full info registers 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 2722 + 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 2024-08-31 13:05:07,272 Run func tests '/usr/bin/clickhouse-test --global_time_limit=1200 ' 2024-08-31 13:05:07,774 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_1 --client-option join_use_nulls=1 join_algorithm='parallel_hash' use_query_cache=1 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 --global_time_limit=1200 ' 2024-08-31 13:05:08,275 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_2', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 --global_time_limit=1200 ' 2024-08-31 13:05:08,776 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_3 --client-option join_algorithm='partial_merge' use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-08-31 13:05:09,277 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 http_make_head_request=0 --global_time_limit=1200 ' 2024-08-31 13:05:09,778 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_5', 's1', 'r1')" --database=test_5 --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='full_sorting_merge' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-08-31 13:05:10,279 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=1 --global_time_limit=1200 ' 2024-08-31 13:05:10,781 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_7 --client-option join_use_nulls=1 join_algorithm='grace_hash' use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-08-31 13:05:11,282 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_8', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 --global_time_limit=1200 ' 2024-08-31 13:05:11,782 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_9 --client-option join_algorithm='auto' max_rows_in_join=1000 use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-08-31 13:05:12,284 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 use_query_cache=1 --global_time_limit=1200 ' 2024-08-31 13:05:12,785 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_11', 's1', 'r1')" --database=test_11 --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='parallel_hash' use_query_cache=1 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 --global_time_limit=1200 ' 2024-08-31 13:05:13,286 Run func tests '/usr/bin/clickhouse-test --order=random --client-option use_query_cache=1 implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 http_make_head_request=1 --global_time_limit=1200 ' 2024-08-31 13:05:13,787 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 --global_time_limit=1200 ' 2024-08-31 13:05:14,288 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_14', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 use_query_cache=1 --global_time_limit=1200 ' 2024-08-31 13:05:14,790 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_merge' group_by_use_nulls=1 optimize_trivial_approximate_count_query=1 --global_time_limit=1200 ' 2024-08-31 13:05:15,291 Will wait functests to finish 2024-08-31 13:05:15,291 Finished 8 from 16 processes 2024-08-31 13:05:20,296 Finished 8 from 16 processes 2024-08-31 13:05:25,300 Finished 8 from 16 processes 2024-08-31 13:05:30,304 Finished 8 from 16 processes 2024-08-31 13:05:35,308 Finished 8 from 16 processes 2024-08-31 13:05:40,312 Finished 8 from 16 processes 2024-08-31 13:05:45,316 Finished 8 from 16 processes 2024-08-31 13:05:50,320 Finished 8 from 16 processes 2024-08-31 13:05:55,324 Finished 8 from 16 processes 2024-08-31 13:06:00,328 Finished 8 from 16 processes 2024-08-31 13:06:05,332 Finished 8 from 16 processes 2024-08-31 13:06:10,336 Finished 8 from 16 processes 2024-08-31 13:06:15,340 Finished 8 from 16 processes 2024-08-31 13:06:20,344 Finished 8 from 16 processes 2024-08-31 13:06:25,348 Finished 8 from 16 processes 2024-08-31 13:06:30,352 Finished 8 from 16 processes 2024-08-31 13:06:35,356 Finished 8 from 16 processes 2024-08-31 13:06:40,360 Finished 8 from 16 processes 2024-08-31 13:06:45,364 Finished 8 from 16 processes 2024-08-31 13:06:50,368 Finished 8 from 16 processes 2024-08-31 13:06:55,372 Finished 8 from 16 processes 2024-08-31 13:07:00,376 Finished 8 from 16 processes 2024-08-31 13:07:05,381 Finished 8 from 16 processes 2024-08-31 13:07:10,384 Finished 8 from 16 processes 2024-08-31 13:07:15,388 Finished 8 from 16 processes 2024-08-31 13:07:20,392 Finished 8 from 16 processes 2024-08-31 13:07:25,396 Finished 8 from 16 processes 2024-08-31 13:07:30,400 Finished 8 from 16 processes 2024-08-31 13:07:35,404 Finished 8 from 16 processes 2024-08-31 13:07:40,408 Finished 8 from 16 processes 2024-08-31 13:07:45,413 Finished 8 from 16 processes 2024-08-31 13:07:50,416 Finished 8 from 16 processes 2024-08-31 13:07:55,420 Finished 8 from 16 processes 2024-08-31 13:08:00,424 Finished 8 from 16 processes 2024-08-31 13:08:05,428 Finished 8 from 16 processes 2024-08-31 13:08:10,432 Finished 8 from 16 processes 2024-08-31 13:08:15,436 Finished 8 from 16 processes 2024-08-31 13:08:20,440 Finished 8 from 16 processes 2024-08-31 13:08:25,444 Finished 8 from 16 processes 2024-08-31 13:08:30,448 Finished 8 from 16 processes 2024-08-31 13:08:35,452 Finished 8 from 16 processes 2024-08-31 13:08:40,457 Finished 8 from 16 processes 2024-08-31 13:08:45,460 Finished 8 from 16 processes 2024-08-31 13:08:50,464 Finished 8 from 16 processes 2024-08-31 13:08:55,468 Finished 8 from 16 processes 2024-08-31 13:09:00,472 Finished 8 from 16 processes 2024-08-31 13:09:05,478 Finished 8 from 16 processes 2024-08-31 13:09:10,480 Finished 8 from 16 processes 2024-08-31 13:09:15,484 Finished 8 from 16 processes 2024-08-31 13:09:20,488 Finished 8 from 16 processes 2024-08-31 13:09:25,492 Finished 8 from 16 processes 2024-08-31 13:09:30,496 Finished 8 from 16 processes 2024-08-31 13:09:35,500 Finished 8 from 16 processes 2024-08-31 13:09:40,504 Finished 8 from 16 processes 2024-08-31 13:09:45,508 Finished 8 from 16 processes 2024-08-31 13:09:50,509 Finished 8 from 16 processes 2024-08-31 13:09:55,512 Finished 8 from 16 processes 2024-08-31 13:10:00,512 Finished 8 from 16 processes 2024-08-31 13:10:05,516 Finished 8 from 16 processes 2024-08-31 13:10:10,520 Finished 8 from 16 processes 2024-08-31 13:10:15,524 Finished 8 from 16 processes 2024-08-31 13:10:20,528 Finished 8 from 16 processes 2024-08-31 13:10:25,532 Finished 8 from 16 processes 2024-08-31 13:10:30,536 Finished 8 from 16 processes 2024-08-31 13:10:35,540 Finished 8 from 16 processes 2024-08-31 13:10:40,544 Finished 8 from 16 processes 2024-08-31 13:10:45,544 Finished 8 from 16 processes 2024-08-31 13:10:50,548 Finished 8 from 16 processes 2024-08-31 13:10:55,552 Finished 8 from 16 processes 2024-08-31 13:11:00,557 Finished 8 from 16 processes 2024-08-31 13:11:05,560 Finished 8 from 16 processes 2024-08-31 13:11:10,564 Finished 8 from 16 processes 2024-08-31 13:11:15,569 Finished 8 from 16 processes 2024-08-31 13:11:20,574 Finished 8 from 16 processes 2024-08-31 13:11:25,576 Finished 8 from 16 processes 2024-08-31 13:11:30,580 Finished 8 from 16 processes 2024-08-31 13:11:35,584 Finished 8 from 16 processes 2024-08-31 13:11:40,588 Finished 8 from 16 processes 2024-08-31 13:11:45,593 Finished 8 from 16 processes 2024-08-31 13:11:50,596 Finished 8 from 16 processes 2024-08-31 13:11:55,600 Finished 8 from 16 processes 2024-08-31 13:12:00,605 Finished 8 from 16 processes 2024-08-31 13:12:05,610 Finished 8 from 16 processes 2024-08-31 13:12:10,612 Finished 8 from 16 processes 2024-08-31 13:12:15,616 Finished 8 from 16 processes 2024-08-31 13:12:20,620 Finished 8 from 16 processes 2024-08-31 13:12:25,624 Finished 8 from 16 processes 2024-08-31 13:12:30,628 Finished 8 from 16 processes 2024-08-31 13:12:35,633 Finished 8 from 16 processes 2024-08-31 13:12:40,635 Finished 8 from 16 processes 2024-08-31 13:12:45,640 Finished 8 from 16 processes 2024-08-31 13:12:50,643 Finished 8 from 16 processes 2024-08-31 13:12:55,648 Finished 8 from 16 processes 2024-08-31 13:13:00,652 Finished 8 from 16 processes 2024-08-31 13:13:05,656 Finished 8 from 16 processes 2024-08-31 13:13:10,660 Finished 8 from 16 processes 2024-08-31 13:13:15,664 Finished 8 from 16 processes 2024-08-31 13:13:20,668 Finished 8 from 16 processes 2024-08-31 13:13:25,673 Finished 8 from 16 processes 2024-08-31 13:13:30,676 Finished 8 from 16 processes 2024-08-31 13:13:35,679 Finished 8 from 16 processes 2024-08-31 13:13:40,684 Finished 8 from 16 processes 2024-08-31 13:13:45,687 Finished 8 from 16 processes 2024-08-31 13:13:50,692 Finished 8 from 16 processes 2024-08-31 13:13:55,696 Finished 8 from 16 processes 2024-08-31 13:14:00,700 Finished 8 from 16 processes 2024-08-31 13:14:05,705 Finished 8 from 16 processes 2024-08-31 13:14:10,708 Finished 8 from 16 processes 2024-08-31 13:14:15,712 Finished 8 from 16 processes 2024-08-31 13:14:20,716 Finished 8 from 16 processes 2024-08-31 13:14:25,720 Finished 8 from 16 processes 2024-08-31 13:14:30,724 Finished 8 from 16 processes 2024-08-31 13:14:35,728 Finished 8 from 16 processes 2024-08-31 13:14:40,732 Finished 8 from 16 processes 2024-08-31 13:14:45,734 Finished 8 from 16 processes 2024-08-31 13:14:50,736 Finished 8 from 16 processes 2024-08-31 13:14:55,740 Finished 8 from 16 processes 2024-08-31 13:15:00,744 Finished 8 from 16 processes 2024-08-31 13:15:05,748 Finished 8 from 16 processes 2024-08-31 13:15:10,752 Finished 8 from 16 processes 2024-08-31 13:15:15,756 Finished 8 from 16 processes 2024-08-31 13:15:20,761 Finished 8 from 16 processes 2024-08-31 13:15:25,764 Finished 8 from 16 processes 2024-08-31 13:15:30,768 Finished 8 from 16 processes 2024-08-31 13:15:35,772 Finished 8 from 16 processes 2024-08-31 13:15:40,776 Finished 8 from 16 processes 2024-08-31 13:15:45,779 Finished 8 from 16 processes 2024-08-31 13:15:50,781 Finished 8 from 16 processes 2024-08-31 13:15:55,784 Finished 8 from 16 processes 2024-08-31 13:16:00,788 Finished 8 from 16 processes 2024-08-31 13:16:05,792 Finished 8 from 16 processes 2024-08-31 13:16:10,796 Finished 8 from 16 processes 2024-08-31 13:16:15,800 Finished 8 from 16 processes 2024-08-31 13:16:20,804 Finished 8 from 16 processes 2024-08-31 13:16:25,808 Finished 8 from 16 processes 2024-08-31 13:16:30,812 Finished 8 from 16 processes 2024-08-31 13:16:35,816 Finished 8 from 16 processes 2024-08-31 13:16:40,816 Finished 8 from 16 processes 2024-08-31 13:16:45,822 Finished 8 from 16 processes 2024-08-31 13:16:50,824 Finished 8 from 16 processes 2024-08-31 13:16:55,828 Finished 8 from 16 processes 2024-08-31 13:17:00,832 Finished 8 from 16 processes 2024-08-31 13:17:05,836 Finished 8 from 16 processes 2024-08-31 13:17:10,840 Finished 8 from 16 processes 2024-08-31 13:17:15,844 Finished 8 from 16 processes 2024-08-31 13:17:20,848 Finished 8 from 16 processes 2024-08-31 13:17:25,852 Finished 8 from 16 processes 2024-08-31 13:17:30,856 Finished 8 from 16 processes 2024-08-31 13:17:35,860 Finished 8 from 16 processes 2024-08-31 13:17:40,864 Finished 8 from 16 processes 2024-08-31 13:17:45,868 Finished 8 from 16 processes 2024-08-31 13:17:50,872 Finished 8 from 16 processes 2024-08-31 13:17:55,876 Finished 8 from 16 processes 2024-08-31 13:18:00,880 Finished 8 from 16 processes 2024-08-31 13:18:05,884 Finished 8 from 16 processes 2024-08-31 13:18:10,889 Finished 8 from 16 processes 2024-08-31 13:18:15,892 Finished 8 from 16 processes 2024-08-31 13:18:20,896 Finished 8 from 16 processes 2024-08-31 13:18:25,900 Finished 8 from 16 processes 2024-08-31 13:18:30,904 Finished 8 from 16 processes 2024-08-31 13:18:35,909 Finished 8 from 16 processes 2024-08-31 13:18:40,912 Finished 8 from 16 processes 2024-08-31 13:18:45,916 Finished 8 from 16 processes 2024-08-31 13:18:50,920 Finished 8 from 16 processes 2024-08-31 13:18:55,925 Finished 8 from 16 processes 2024-08-31 13:19:00,928 Finished 8 from 16 processes 2024-08-31 13:19:05,932 Finished 8 from 16 processes 2024-08-31 13:19:10,936 Finished 8 from 16 processes 2024-08-31 13:19:15,940 Finished 8 from 16 processes 2024-08-31 13:19:20,944 Finished 8 from 16 processes 2024-08-31 13:19:25,948 Finished 8 from 16 processes 2024-08-31 13:19:30,952 Finished 8 from 16 processes 2024-08-31 13:19:35,956 Finished 8 from 16 processes 2024-08-31 13:19:40,960 Finished 8 from 16 processes 2024-08-31 13:19:45,964 Finished 8 from 16 processes 2024-08-31 13:19:50,968 Finished 8 from 16 processes 2024-08-31 13:19:55,972 Finished 8 from 16 processes 2024-08-31 13:20:00,976 Finished 8 from 16 processes 2024-08-31 13:20:05,980 Finished 8 from 16 processes 2024-08-31 13:20:10,984 Finished 8 from 16 processes 2024-08-31 13:20:15,989 Finished 8 from 16 processes 2024-08-31 13:20:20,992 Finished 8 from 16 processes 2024-08-31 13:20:25,997 Finished 8 from 16 processes 2024-08-31 13:20:31,000 Finished 8 from 16 processes 2024-08-31 13:20:36,004 Finished 8 from 16 processes 2024-08-31 13:20:41,008 Finished 8 from 16 processes 2024-08-31 13:20:46,012 Finished 8 from 16 processes 2024-08-31 13:20:51,016 Finished 8 from 16 processes 2024-08-31 13:20:56,020 Finished 8 from 16 processes 2024-08-31 13:21:01,024 Finished 8 from 16 processes 2024-08-31 13:21:06,028 Finished 8 from 16 processes 2024-08-31 13:21:11,032 Finished 8 from 16 processes 2024-08-31 13:21:16,036 Finished 8 from 16 processes 2024-08-31 13:21:21,040 Finished 8 from 16 processes 2024-08-31 13:21:26,044 Finished 8 from 16 processes 2024-08-31 13:21:31,048 Finished 8 from 16 processes 2024-08-31 13:21:36,052 Finished 8 from 16 processes 2024-08-31 13:21:41,056 Finished 8 from 16 processes 2024-08-31 13:21:46,060 Finished 8 from 16 processes 2024-08-31 13:21:51,064 Finished 8 from 16 processes 2024-08-31 13:21:56,069 Finished 8 from 16 processes 2024-08-31 13:22:01,072 Finished 8 from 16 processes 2024-08-31 13:22:06,076 Finished 8 from 16 processes 2024-08-31 13:22:11,081 Finished 8 from 16 processes 2024-08-31 13:22:16,084 Finished 8 from 16 processes 2024-08-31 13:22:21,088 Finished 8 from 16 processes 2024-08-31 13:22:26,092 Finished 8 from 16 processes 2024-08-31 13:22:31,095 Finished 8 from 16 processes 2024-08-31 13:22:36,100 Finished 8 from 16 processes 2024-08-31 13:22:41,104 Finished 8 from 16 processes 2024-08-31 13:22:46,108 Finished 8 from 16 processes 2024-08-31 13:22:51,112 Finished 8 from 16 processes 2024-08-31 13:22:56,116 Finished 8 from 16 processes 2024-08-31 13:23:01,120 Finished 8 from 16 processes 2024-08-31 13:23:06,124 Finished 8 from 16 processes 2024-08-31 13:23:11,128 Finished 8 from 16 processes 2024-08-31 13:23:16,133 Finished 8 from 16 processes 2024-08-31 13:23:21,137 Finished 8 from 16 processes 2024-08-31 13:23:26,140 Finished 8 from 16 processes 2024-08-31 13:23:31,144 Finished 8 from 16 processes 2024-08-31 13:23:36,148 Finished 8 from 16 processes 2024-08-31 13:23:41,152 Finished 8 from 16 processes 2024-08-31 13:23:46,157 Finished 8 from 16 processes 2024-08-31 13:23:51,160 Finished 8 from 16 processes 2024-08-31 13:23:56,164 Finished 8 from 16 processes 2024-08-31 13:24:01,168 Finished 8 from 16 processes 2024-08-31 13:24:06,173 Finished 8 from 16 processes 2024-08-31 13:24:11,176 Finished 8 from 16 processes 2024-08-31 13:24:16,181 Finished 8 from 16 processes 2024-08-31 13:24:21,184 Finished 8 from 16 processes 2024-08-31 13:24:26,189 Finished 8 from 16 processes 2024-08-31 13:24:31,194 Finished 8 from 16 processes 2024-08-31 13:24:36,196 Finished 8 from 16 processes 2024-08-31 13:24:41,200 Finished 8 from 16 processes 2024-08-31 13:24:46,204 Finished 8 from 16 processes 2024-08-31 13:24:51,208 Finished 8 from 16 processes 2024-08-31 13:24:56,213 Finished 8 from 16 processes 2024-08-31 13:25:01,217 Finished 8 from 16 processes 2024-08-31 13:25:06,220 Finished 8 from 16 processes 2024-08-31 13:25:11,224 Finished 9 from 16 processes 2024-08-31 13:25:16,228 Finished 9 from 16 processes 2024-08-31 13:25:21,232 Finished 9 from 16 processes 2024-08-31 13:25:26,236 Finished 9 from 16 processes 2024-08-31 13:25:31,240 Finished 9 from 16 processes 2024-08-31 13:25:36,244 Finished 12 from 16 processes 2024-08-31 13:25:41,248 Finished 13 from 16 processes 2024-08-31 13:25:46,252 Finished 13 from 16 processes 2024-08-31 13:25:51,253 Finished 13 from 16 processes 2024-08-31 13:25:56,257 Finished 13 from 16 processes 2024-08-31 13:26:01,258 Finished 13 from 16 processes 2024-08-31 13:26:06,260 Finished 14 from 16 processes 2024-08-31 13:26:11,265 Finished 14 from 16 processes 2024-08-31 13:26:16,268 Finished 14 from 16 processes 2024-08-31 13:26:21,272 Finished 14 from 16 processes 2024-08-31 13:26:26,277 Finished 14 from 16 processes 2024-08-31 13:26:31,282 Finished 14 from 16 processes 2024-08-31 13:26:36,284 Finished 14 from 16 processes 2024-08-31 13:26:41,285 Finished 14 from 16 processes 2024-08-31 13:26:46,288 Finished 14 from 16 processes 2024-08-31 13:26:51,292 Finished 14 from 16 processes 2024-08-31 13:26:56,297 Finished 14 from 16 processes 2024-08-31 13:27:01,300 Finished 14 from 16 processes 2024-08-31 13:27:06,305 Finished 14 from 16 processes 2024-08-31 13:27:11,308 Finished 14 from 16 processes 2024-08-31 13:27:16,313 Finished 14 from 16 processes 2024-08-31 13:27:21,316 Finished 14 from 16 processes 2024-08-31 13:27:26,320 Finished 14 from 16 processes 2024-08-31 13:27:31,324 Finished 14 from 16 processes 2024-08-31 13:27:36,328 Finished 14 from 16 processes 2024-08-31 13:27:41,333 Finished 14 from 16 processes 2024-08-31 13:27:46,339 Finished 14 from 16 processes 2024-08-31 13:27:51,344 Finished 14 from 16 processes 2024-08-31 13:27:56,348 Finished 15 from 16 processes 2024-08-31 13:28:01,353 Finished 15 from 16 processes 2024-08-31 13:28:06,356 Finished 15 from 16 processes 2024-08-31 13:28:11,360 Finished 15 from 16 processes 2024-08-31 13:28:16,364 Finished 15 from 16 processes 2024-08-31 13:28:21,368 Finished 15 from 16 processes 2024-08-31 13:28:26,369 Finished 15 from 16 processes 2024-08-31 13:28:31,372 Finished 15 from 16 processes 2024-08-31 13:28:36,377 Finished 15 from 16 processes 2024-08-31 13:28:41,382 Finished 15 from 16 processes 2024-08-31 13:28:46,384 Finished 15 from 16 processes 2024-08-31 13:28:51,388 Finished 15 from 16 processes 2024-08-31 13:28:56,392 Finished 15 from 16 processes 2024-08-31 13:29:01,396 Finished 15 from 16 processes 2024-08-31 13:29:06,401 Finished 15 from 16 processes 2024-08-31 13:29:11,405 Finished 15 from 16 processes 2024-08-31 13:29:16,410 Finished 15 from 16 processes 2024-08-31 13:29:21,413 Finished 15 from 16 processes 2024-08-31 13:29:26,416 Finished 15 from 16 processes 2024-08-31 13:29:31,421 Finished 15 from 16 processes 2024-08-31 13:29:36,424 Finished 15 from 16 processes 2024-08-31 13:29:41,424 Finished 15 from 16 processes 2024-08-31 13:29:46,428 Finished 15 from 16 processes 2024-08-31 13:29:51,432 Finished 15 from 16 processes 2024-08-31 13:29:56,436 Finished 15 from 16 processes 2024-08-31 13:30:01,440 Finished 15 from 16 processes 2024-08-31 13:30:06,444 All processes finished 2024-08-31 13:30:06,444 Compressing stress logs 2024-08-31 13:30:06,458 Logs compressed 2024-08-31 13:30:06,459 Will terminate gdb (if any) 2024-08-31 13:30:06,459 Running command: kill -TERM $(pidof gdb) 2024-08-31 13:30:06,462 Running command: timeout 50s tail --pid=$(pidof gdb) -f /dev/null || kill -9 $(pidof gdb) ||: Quit 2024-08-31 13:30:07,479 Running command: kill -CONT $(cat /var/run/clickhouse-server/clickhouse-server.pid) && clickhouse client -q 'SELECT 1 FORMAT Null' 2024-08-31 13:30:07,744 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 2024-08-31 13:30:07,958 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 2024-08-31 13:30:08,123 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 2024-08-31 13:30:08,287 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 2024-08-31 13:30:08,452 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 2024-08-31 13:30:08,616 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 2024-08-31 13:30:08,781 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 2024-08-31 13:30:08,945 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 2024-08-31 13:30:09,110 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 2024-08-31 13:30:09,274 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 2024-08-31 13:30:09,439 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 2024-08-31 13:30:09,604 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 2024-08-31 13:30:09,768 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 2024-08-31 13:30:11,483 Checking if some queries hung Using queries from '/usr/share/clickhouse-test/queries' directory Connecting to ClickHouse server... OK Connected to server 24.3.5.48.altinityfips @ f030c602050d371934c7b7609b7a8228fb1c7779 HEAD Running 1 stateless tests (MainProcess). 00001_select_1: [ OK ] 1 tests passed. 0 tests skipped. 0.21 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. 45307 0.087 2.64 MiB 0.026 1 126 ['Debug'] 0.993 Key {} is removed from metadata 2. 42799 0.082 2.41 MiB 0.024 1 1292 ['Debug'] 0.004 Submitting key {} for removal 3. 27507 0.053 8.27 MiB 0.083 10801 889 ['Information'] 0.003 Setting download as failed: {} 4. 25750 0.05 2.87 MiB 0.029 1750 879 ['Trace'] 0 Bypassing cache because file segment state is `PARTIALLY_DOWNLOADED_NO_CONTINUATION` and downloaded part already used 5. 16651 0.032 1.50 MiB 0.015 1 2038 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 6. 16402 0.032 1.28 MiB 0.013 7869 688 ['Trace'] 0.001 No space left in cache to reserve {} bytes, will continue without cache download 7. 15980 0.031 920.73 KiB 0.009 1 134 ['Trace'] 0 Access granted: {}{} 8. 14688 0.028 430.06 KiB 0.004 1 2037 ['Trace'] 0 Aggregation method: {} 9. 11819 0.023 2.24 MiB 0.022 1 60 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 10. 11532 0.022 1.73 MiB 0.017 3 60 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 11. 11463 0.022 123.14 KiB 0.001 1 1791 ['Trace'] 0 Aggregating 12. 10021 0.019 17.63 MiB 0.177 1 88 ['Trace'] 0 Query {} to stage {}{} 13. 9969 0.019 17.77 MiB 0.179 1 88 ['Trace'] 0.001 Query {} from stage {} to stage {}{} 14. 9283 0.018 941.93 KiB 0.009 2241 587 ['Trace'] 0 Predownload failed because of space limit. Will read from remote filesystem starting from offset: {} 15. 9161 0.018 258.55 KiB 0.003 1 60 ['Debug'] 0 Processed in {} sec. 16. 7636 0.015 633.36 KiB 0.006 1 1728 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 17. 7278 0.014 592.20 KiB 0.006 1 53 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 18. 7075 0.014 316.31 KiB 0.003 1 1 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 19. 6493 0.012 553.05 KiB 0.005 56 40 ['Trace'] 0 Reading {} ranges in{}order from part {}, approx. {} rows starting from {} 20. 5759 0.011 256.76 KiB 0.003 1 70 ['Debug'] 0.127 Peak memory usage{}: {}. 21. 5219 0.01 703.34 KiB 0.007 1 735 ['Information'] 0 Sorting and writing part of data into temporary file {} 22. 5219 0.01 903.60 KiB 0.009 1 728 ['Information'] 0 Done writing part of data into temporary file {}, compressed {}, uncompressed {} 23. 4734 0.009 531.65 KiB 0.005 4 67 ['Debug'] 0.999 {} Authenticated with global context as user {} 24. 4734 0.009 385.78 KiB 0.004 4 67 ['Debug'] 0.999 {} Authenticating user '{}' from {} 25. 4727 0.009 517.02 KiB 0.005 3 60 ['Debug'] 1 {} Creating session context with user_id: {} 26. 4707 0.009 413.70 KiB 0.004 4 62 ['Debug'] 0.999 {} Logout, user_id: {} 27. 4532 0.009 533.68 KiB 0.005 287 335 ['Trace'] 0.583 Renaming temporary part {} to {} with tid {}. 28. 4327 0.008 204.96 KiB 0.002 1 317 ['Trace'] 0.57 filled checksums {} 29. 4279 0.008 296.81 KiB 0.003 280 671 ['Trace'] 0.729 Trying to reserve {} using storage policy from min volume index {} 30. 3913 0.008 527.34 KiB 0.005 1 254 ['Debug'] 0 Writing part of aggregation data into temporary file {} 31. 3913 0.008 175.25 KiB 0.002 1 254 ['Debug'] 0 Max size of temporary block: {} rows, {}. 32. 3912 0.008 962.57 KiB 0.009 1 254 ['Debug'] 0 Written part in {:.3f} sec., {} rows, {} uncompressed, {} compressed, {:.3f} uncompressed bytes per row, {:.3f} compressed bytes per row, compression rate: {:.3f} ({:.3f} rows/sec., {}/sec. uncompressed, {}/sec. compressed) 33. 3853 0.007 3.98 MiB 0.04 1 246 ['Debug'] 0.955 Objects with paths [{}] were removed from S3 34. 3804 0.007 446.76 KiB 0.004 1 47 ['Trace'] 0 PREWHERE condition was split into {} steps: {} 35. 3664 0.007 774.59 KiB 0.008 1 181 ['Debug'] 0 {}:{}: sampleColumns {} '{}' 36. 3599 0.007 338.18 KiB 0.003 1 32 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 37. 3505 0.007 162.78 KiB 0.002 228 65 ['Debug'] 0.001 Key condition: {} 38. 3440 0.007 398.41 KiB 0.004 222 65 ['Debug'] 0.001 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 39. 3431 0.007 5.96 MiB 0.06 1 213 ['Debug'] 0.976 metadata and objects were removed for [{}], only metadata were removed for [{}]. 40. 3312 0.006 389.09 KiB 0.004 1 21 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 41. 3284 0.006 169.97 KiB 0.002 194 64 ['Trace'] 0.002 Spreading mark ranges among streams (default reading) 42. 3279 0.006 126.35 KiB 0.001 192 63 ['Debug'] 0.002 Reading approx. {} rows with {} streams 43. 3133 0.006 70.37 KiB 0.001 1 848 ['Trace'] 0 Merging aggregated data 44. 2966 0.006 395.31 KiB 0.004 63 27 ['Debug'] 0 Part: {}, sum_marks: {}, approx mark size: {}, prefetch_step_bytes: {}, prefetch_step_marks: {}, (ranges: {}) 45. 2670 0.005 106.90 KiB 0.001 1 980 ['Trace'] 0 Converting aggregation data to two-level. 46. 2542 0.005 466.69 KiB 0.005 2 44 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {} 47. 2538 0.005 3.64 MiB 0.037 2 44 ['Trace'] 1 Request URI: {} 48. 2536 0.005 380.49 KiB 0.004 1 278 ['Debug'] 0 Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.) 49. 2536 0.005 125.14 KiB 0.001 1 278 ['Trace'] 0 Merging partially aggregated blocks (bucket = {}). 50. 2496 0.005 51.19 KiB 0.001 2 44 ['Debug'] 0.07 Done processing query 51. 2467 0.005 143.67 KiB 0.001 16 16 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 52. 2467 0.005 88.85 KiB 0.001 16 16 ['Trace'] 1 Flushed system log up to offset {} 53. 2438 0.005 222.05 KiB 0.002 1 902 ['Debug'] 0 Merge sorted {} blocks, {} rows in {} sec., {} rows/sec., {}/sec 54. 2386 0.005 226.04 KiB 0.002 1 60 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 55. 2386 0.005 78.28 KiB 0.001 1 60 ['Trace'] 1 TCP Request. Address: {} 56. 2360 0.005 62.23 KiB 0.001 1 55 ['Debug'] 1 Done processing connection. 57. 2360 0.005 69.12 KiB 0.001 58 389 ['Trace'] 0 Found (LEFT) boundary mark: {} 58. 2360 0.005 72.04 KiB 0.001 58 389 ['Trace'] 0 Found (RIGHT) boundary mark: {} 59. 2360 0.005 160.54 KiB 0.002 58 389 ['Trace'] 0 Running binary search on index range for part {} ({} marks) 60. 2360 0.005 75.27 KiB 0.001 58 389 ['Trace'] 0 Found {} range in {} steps 61. 2300 0.004 281.30 KiB 0.003 63 27 ['Debug'] 0 Sum marks: {}, threads: {}, min_marks_per_thread: {}, min prefetch step marks: {}, prefetches limit: {}, total_size_approx: {} 62. 2094 0.004 259.70 KiB 0.003 1 182 ['Debug'] 0 {}:{}: {} - '{}' 63. 1751 0.003 141.93 KiB 0.001 1 24 ['Information'] 0 Write-through cache is stopped as cache limit is reached and nothing can be evicted 64. 1751 0.003 672.56 KiB 0.007 1 24 ['Debug'] 0 Failed to reserve space in cache (size: {}, file segment info: {} 65. 1726 0.003 56.74 KiB 0.001 39 50 ['Debug'] 0 MinMax index condition: {} 66. 1610 0.003 128.78 KiB 0.001 1 760 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={} 67. 1593 0.003 117.99 KiB 0.001 50 373 ['Trace'] 0 Used generic exclusion search over index for part {} with {} steps 68. 1567 0.003 113.50 KiB 0.001 1 54 ['Trace'] 0 The min valid primary key position for moving to the tail of PREWHERE is {} 69. 1428 0.003 175.37 KiB 0.002 1 1 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 70. 1200 0.002 92.58 KiB 0.001 1 48 ['Trace'] 0 Query span trace_id for opentelemetry log: {} 71. 1199 0.002 50.43 KiB 0 1 669 ['Information'] 0 There are {} temporary sorted parts to merge 72. 1141 0.002 358.07 KiB 0.004 1 413 ['Trace'] 0.002 {}Keys: {}, datatype: {}, kind: {}, strictness: {}, right header: {} 73. 1104 0.002 324.06 KiB 0.003 1 29 ['Debug'] 0.003 After join block: '{}' 74. 1104 0.002 201.75 KiB 0.002 1 29 ['Debug'] 0.003 Before join block: '{}' 75. 969 0.002 44.73 KiB 0 1 532 ['Debug'] 0 Aggregated. {} to {} rows (from {}) 76. 964 0.002 18.83 KiB 0 1 597 ['Trace'] 0 Aggregating in order 77. 885 0.002 28.19 KiB 0 1 63 ['Debug'] 0.006 min_marks_for_concurrent_read={} 78. 872 0.002 59.78 KiB 0.001 1 329 ['Debug'] 1 Execute load job '{}' in {} 79. 872 0.002 20.43 KiB 0 1 601 ['Debug'] 1 Stop worker in {} 80. 872 0.002 60.64 KiB 0.001 1 329 ['Debug'] 1 Finish load job '{}' with status {} 81. 872 0.002 29.79 KiB 0 1 362 ['Debug'] 0.549 Spawn loader worker #{} in {} 82. 872 0.002 62.34 KiB 0.001 1 40 ['Debug'] 0 Schedule load job '{}' into {} 83. 808 0.002 57.56 KiB 0.001 1 331 ['Trace'] 0.004 {}Join data is being destroyed, {} bytes and {} rows in hash table 84. 779 0.001 6.85 KiB 0 2 40 ['Trace'] 0 No tables 85. 775 0.001 25.73 KiB 0 1 359 ['Debug'] 0.501 Change current priority: {} -> {} 86. 734 0.001 108.74 KiB 0.001 1 4 ['Trace'] 1 Creating part at path {} 87. 704 0.001 36.69 KiB 0 105 378 ['Debug'] 0.884 Selected {} parts from {} to {} 88. 692 0.001 23.62 KiB 0 1 34 ['Debug'] 0 Selected MergeAlgorithm: {} 89. 692 0.001 56.44 KiB 0.001 1 34 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {} 90. 689 0.001 21.90 KiB 0 19 17 ['Debug'] 0 Requested flush up to offset {} 91. 679 0.001 88.46 KiB 0.001 1 34 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec. 92. 676 0.001 43.09 KiB 0 102 34 ['Trace'] 0 Merged {} parts: [{}, {}] -> {} 93. 633 0.001 84.04 KiB 0.001 277 215 ['Debug'] 0.979 Removing {} parts from filesystem (serially): Parts: [{}] 94. 630 0.001 15.14 KiB 0 1 162 ['Trace'] 0 Skipping {} {} bucket {} 95. 623 0.001 12.88 KiB 0 1 304 ['Trace'] 0 Joining file bucket {} 96. 596 0.001 79.93 KiB 0.001 1 101 ['Debug'] 0 {}:{}: '{}' 97. 525 0.001 41.67 KiB 0 1 114 ['Debug'] 0.503 Prioritize load job '{}': {} -> {} 98. 521 0.001 65.90 KiB 0.001 1 330 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {} 99. 519 0.001 102.39 KiB 0.001 1 329 ['Information'] 1 Removing metadata {} of dropped table {} 100. 519 0.001 38.52 KiB 0 1 41 ['Debug'] 0 Waiting for table {} to be finally dropped Top messages without format string (fmt::runtime): count pattern runtime_message line 1. 5 PocoExceptionCodeecodeNetExcepti Poco::Exception. Code: 1000, e.code() = 107, Net Exception: Socket is not connected, Stack trace (when copying this message, always include the lines below): 0. std::exception::capture() @ 0x0000000018191275 1. ./build_docker/./base/poco/Foundation/src/Ex ('/Exception.cpp',222) 2. 4 CodeDBExceptionSyntaxerrorfailed Code: 62. DB::Exception: Syntax error: failed at position 32 ('DROP'): DROP COLUMN c. Expected one of: ALTER command, token, OpeningRoundBracket: In scope SELECT formatQuery('ALTER TABLE a (DROP COLUMN b), DROP COLUMN c'). (SYNTAX_ERROR) (version 24.3.5.48 ('/executeQuery.cpp',218) 3. 2 CodeDBExceptionPathisrelativewhi Code: 395. DB::Exception: Path is relative: : while executing 'FUNCTION throwIf(_CAST(1_UInt8, 'UInt8'_String) :: 1, 'Path is relative: '_String :: 2) -> throwIf(_CAST(1_UInt8, 'UInt8'_String), 'Path is relative: '_String) UInt8 : 3'. (FUNCTION_THROW_IF_VA ('/executeQuery.cpp',218) 4. 2 voidDBStorageReplicatedMergeTree void DB::StorageReplicatedMergeTree::mutationsUpdatingTask(): Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. std::exception::capture() @ 0x00000000181912 ('/Exception.cpp',222) 5. 2 CodeDBExceptionReceivedfromlocal Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (for query) exceeded: would use 20.80 MiB (attempt to allocate chunk of 1049344 bytes), maximum: 20.00 MiB.: While executing AggregatingTransform: while pushing to view tes ('/executeQuery.cpp',218) 6. 1 PocoExceptionCodeecodeBadURIsynt Poco::Exception. Code: 1000, e.code() = 0, Bad URI syntax: URI contains invalid characters (version 24.3.5.48.altinityfips (altinity build)) (from [::1]:33610) (comment: 00990_request_splitting.sql) (in query: SELECT * FROM url('http://127.0.0.1:1337/? HTT ('/executeQuery.cpp',218) 7. 1 CodeDBExceptionBadURIsyntaxURIco Code: 1000. DB::Exception: Bad URI syntax: URI contains invalid characters. (POCO_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. std::exception::capture() @ 0x0000000018191275 1. ./build_docker/./base/poco/Foundati ('/TCPHandler.cpp',701) 8. 1 IfthesignaturecheckfailedThiscou If the signature check failed. This could be because of a time skew. Attempting to adjust the signer. ('/AWSLogger.cpp',71) 9. 1 PocoExceptionCodeecodeNotfoundbo Poco::Exception. Code: 1000, e.code() = 0, Not found: boundary, Stack trace (when copying this message, always include the lines below): 0. std::exception::capture() @ 0x0000000018191275 1. ./build_docker/./base/poco/Foundation/src/Exception.cpp:28: Poco: ('/Exception.cpp',222) 10. 1 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() @ 0x0000000018191275 1. ./build_docker/./base/poco/Foun ('/Exception.cpp',222) Top messages not matching their format strings: message_format_string count() any_message 1. Query {} to stage {}{} 67 Query SELECT _CAST(1, 'UInt8') AS `equals(0, isValidUTF8('�('))` FROM system.numbers AS __table1 LIMIT _CAST(10, 'UInt64') to stage Complete 2. Query {} from stage {} to stage {}{} 67 Query SELECT _CAST(1, 'UInt8') AS `equals(0, isValidUTF8('�('))` FROM system.numbers AS __table1 LIMIT _CAST(10, 'UInt64') from stage FetchColumns to stage Complete 3. {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 35 /var/lib/clickhouse/disks/s3_disk/store/b32/b32772e3-d312-42e3-953e-46384994925b/tmp_merge_201403_1_1_1/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 1 similar messages) 4. 3 Poco::Exception. Code: 1000, e.code() = 0, Not found: boundary, Stack trace (when copying this message, always include the lines below): 0. std::exception::capture() @ 0x0000000018191275 1. ./build_docker/./base/poco/Foundation/src/Exception.cpp:28: Poco::Exception::Exception(String const&, int) @ 0x0000000036921c45 2. ./build_docker/./base/poco/Foundation/src/Exception.cpp:146: Poco::NotFoundException::NotFoundException(String const&, int) @ 0x000000003692833b 3. ./build_docker/./base/poco/Net/src/NameValueCollection.cpp:65: Poco::Net::NameValueCollection::operator[](String const&) const @ 0x0000000036736753 4. ./build_docker/./src/Server/HTTP/HTMLForm.cpp:103: DB::HTMLForm::load(Poco::Net::HTTPRequest const&, DB::ReadBuffer&, DB::HTMLForm::PartHandler&) @ 0x000000003347f430 5. ./build_docker/./src/Server/HTTPHandler.cpp:1168: DB::DynamicQueryHandler::getQuery(DB::HTTPServerRequest&, DB::HTMLForm&, std::shared_ptr) @ 0x0000000033390ab4 6. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:714: DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional&, StrongTypedef const&) @ 0x00000000333844d1 7. ./build_docker/./src/Server/HTTPHandler.cpp:1091: DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&, StrongTypedef const&) @ 0x000000003338bb2f 8. ./build_docker/./src/Server/HTTP/HTTPServerConnection.cpp:71: DB::HTTPServerConnection::run() @ 0x0000000033487a72 9. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x00000000367670fe 10. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: Poco::Net::TCPServerDispatcher::run() @ 0x000000003676821a 11. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x00000000369d4030 12. ./base/poco/Foundation/include/Poco/AutoPtr.h:205: Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000369cf131 13. ? @ 0x00007fa8375b6ac3 14. ? @ 0x00007fa837648850 (version 24.3.5.48.altinityfips (altinity build)) Top short messages: c message_format_string substr(any(message), 1, 120) min_length_without_exception_boilerplate 1. 596 {}:{}: '{}' src/Processors/Transforms/MergeJoinTransform.cpp:836: ' Int32(size = 1) String(size = 1) Int32(size = 1) String(size = 1 30 2. 6 Bad SSH public key provided Code: 706. DB::Exception: Bad SSH public key provided. (LIBSSH_ERROR) (version 24.3.5.48.altinityfips (altinity build)) 29 3. 4 Creating {}: {} Creating table test_nhgivyhj.tbl1: CREATE TABLE IF NOT EXISTS test_nhgivyhj.tbl1 UUID 'ead33897-bc21-4030-b040-649dd5814 951 4. 2 Path to archive is empty Code: 36. DB::Exception: Path to archive is empty. (BAD_ARGUMENTS) (version 24.3.5.48.altinityfips (altinity build)) (fr 25 5. 2 Substitution {} is not set Code: 456. DB::Exception: Substitution `s` is not set. (UNKNOWN_QUERY_PARAMETER) (version 24.3.5.48.altinityfips (altini 29 6. 1 {} Server has databases (for example `test_5`) with Ordinary engine, which was deprecated. To convert this database to the 386 7. 1 Froze {} parts Froze 1 parts -13 Top messages by level: (0.00020393086358949102,'Metadata on replica is not up to date with common metadata in Zookeeper. It means that this replica still not applied some of previous alters. Probably too many alters executing concurrently (highly not recommended). You can retry this error') Error (0.000013467132501192803,'Sanity check: \'{}\' value is too high ({}). Reduced to {}') Warning (0.05292005910147292,'Setting download as failed: {}') Information (0.08716505317593462,'Key {} is removed from metadata') Debug (0.049539808843673525,'Bypassing cache because file segment state is `PARTIALLY_DOWNLOADED_NO_CONTINUATION` and downloaded part already used') Trace 2024-08-31 13:30:18,065 Stress test finished + echo -e 'Test script exit code\tOK\t\N\t' + grep -Fa OK + rg -Fa 'No queries hung' /test_output/test_results.tsv 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=2722 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2722. The process with pid = 2722 is running. Sent terminate signal to process with pid 2722. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2722. The process with pid = 2722 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2722. The process with pid = 2722 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2722. The process with pid = 2722 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2722. The process with pid = 2722 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2722. The process with pid = 2722 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2722. The process with pid = 2722 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2722. The process with pid = 2722 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2722. The process with pid = 2722 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 + 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 127.0.0.1 - - [31/Aug/2024:11:30:26 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [31/Aug/2024:11:30:26 +0000] "PUT /devstoreaccount1/cont/ogkwokapkrsrwdwizivkpzwkjpcroszu?blockid=zqylsdpexktvcldezynxardpvxehxbyiiwpifavkewjarhbvvdsfkpjkkekkgtcd&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:11:30:26 +0000] "PUT /devstoreaccount1/cont/ogkwokapkrsrwdwizivkpzwkjpcroszu?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:11:30:26 +0000] "GET /devstoreaccount1/cont/ogkwokapkrsrwdwizivkpzwkjpcroszu HTTP/1.1" 206 4 127.0.0.1 - - [31/Aug/2024:11:30:26 +0000] "GET /devstoreaccount1/cont/ogkwokapkrsrwdwizivkpzwkjpcroszu HTTP/1.1" 206 2 127.0.0.1 - - [31/Aug/2024:11:30:26 +0000] "DELETE /devstoreaccount1/cont/ogkwokapkrsrwdwizivkpzwkjpcroszu HTTP/1.1" 202 - + 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' 1 + attach_gdb_to_clickhouse ++ 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 thread apply all backtrace full info registers 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 24304 + 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=24304 + 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 = 24304. The process with pid = 24304 is running. Sent terminate signal to process with pid 24304. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 24304. The process with pid = 24304 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 24304. The process with pid = 24304 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 24304. The process with pid = 24304 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 ++ trim_server_logs fatal_messages.txt ++ head -n 100 /test_output/fatal_messages.txt ++ grep -Eo ' \[ [0-9]+ \] \{.*' ++ escaped ++ clickhouse local -S 's String' --input-format=LineAsString -q 'select substr(s, 1, 300) from table format CustomSeparated settings format_custom_row_after_delimiter='\''\\\\n'\''' + echo -e 'Fatal message in clickhouse-server.log (see fatal_messages.txt)\tFAIL\t\N\t [ 571 ] {} KeeperServer: Can\'\''t start NON-SECURE keeper server in FIPS mode, please check the config.\\n [ 571 ] {} KeeperServer: Can\'\''t start NON-SECURE keeper server in FIPS mode, please check the config.\\n [ 1406 ] {} KeeperServer: Can\'\''t start NON-SECURE keeper server in FIPS mode, please check the config.\\n [ 2722 ] {} KeeperServer: Can\'\''t start NON-SECURE keeper server in FIPS mode, please check the config.\\n [ 24304 ] {} KeeperServer: Can\'\''t start NON-SECURE keeper server in FIPS mode, please check the config.\\n [ 24304 ] {} KeeperServer: Can\'\''t start NON-SECURE keeper server in FIPS mode, please check the config.\\n [ 1406 ] {} KeeperServer: Can\'\''t start NON-SECURE keeper server in FIPS mode, please check the config.\\n [ 2722 ] {} KeeperServer: Can\'\''t start NON-SECURE keeper server in FIPS mode, please check the config.\\n' + '[' -s /test_output/fatal_messages.txt ']' + rg -Faz '########################################' /test_output/fatal_messages.txt /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 + clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.query_log format TSVWithNamesAndTypes' + zstd --threads=0 Processing configuration file '/etc/clickhouse-server/config.xml'. Merging configuration file '/etc/clickhouse-server/config.d/CORS.xml'. Merging configuration file '/etc/clickhouse-server/config.d/asynchronous_metrics_update_period_s.xml'. Merging configuration file '/etc/clickhouse-server/config.d/azure_storage_conf.xml'. Merging configuration file '/etc/clickhouse-server/config.d/backoff_failed_mutation.xml'. Merging configuration file '/etc/clickhouse-server/config.d/backups.xml'. Merging configuration file '/etc/clickhouse-server/config.d/blob_storage_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/block_number.xml'. Merging configuration file '/etc/clickhouse-server/config.d/clusters.xml'. Merging configuration file '/etc/clickhouse-server/config.d/compressed_marks_and_index.xml'. Merging configuration file '/etc/clickhouse-server/config.d/core.xml'. Merging configuration file '/etc/clickhouse-server/config.d/custom_disks_base_path.xml'. Merging configuration file '/etc/clickhouse-server/config.d/custom_settings_prefixes.xml'. Merging configuration file '/etc/clickhouse-server/config.d/database_atomic.xml'. Merging configuration file '/etc/clickhouse-server/config.d/disable_s3_env_credentials.xml'. Merging configuration file '/etc/clickhouse-server/config.d/display_name.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_access_control_improvements.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_async_load_databases.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_keeper_map.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_wait_for_shutdown_replicated_tables.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_zero_copy_replication.xml'. Merging configuration file '/etc/clickhouse-server/config.d/encryption.xml'. Merging configuration file '/etc/clickhouse-server/config.d/filesystem_cache_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/filesystem_caches_path.xml'. Merging configuration file '/etc/clickhouse-server/config.d/forbidden_headers.xml'. Merging configuration file '/etc/clickhouse-server/config.d/graphite.xml'. Merging configuration file '/etc/clickhouse-server/config.d/graphite_alternative.xml'. Merging configuration file '/etc/clickhouse-server/config.d/handlers.yaml'. Merging configuration file '/etc/clickhouse-server/config.d/keeper_port.xml'. Merging configuration file '/etc/clickhouse-server/config.d/legacy_geobase.xml'. Merging configuration file '/etc/clickhouse-server/config.d/listen.xml'. Merging configuration file '/etc/clickhouse-server/config.d/logger_trace.xml'. Merging configuration file '/etc/clickhouse-server/config.d/logging_no_rotate.xml'. Merging configuration file '/etc/clickhouse-server/config.d/lost_forever_check.xml'. Merging configuration file '/etc/clickhouse-server/config.d/macros.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_concurrent_queries.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_num_to_warn.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_server_memory_usage.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree_old_dirs_cleanup.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree_settings.xml'. Merging configuration file '/etc/clickhouse-server/config.d/named_collection.xml'. Merging configuration file '/etc/clickhouse-server/config.d/nlp.xml'. Merging configuration file '/etc/clickhouse-server/config.d/prometheus.xml'. Merging configuration file '/etc/clickhouse-server/config.d/query_masking_rules.xml'. Merging configuration file '/etc/clickhouse-server/config.d/query_masking_rules.xml_original.xml'. Merging configuration file '/etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml'. Merging configuration file '/etc/clickhouse-server/config.d/secure_ports.xml'. Merging configuration file '/etc/clickhouse-server/config.d/session_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/ssl_certs.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02944.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02961.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02963.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_metadata_with_full_object_key.xml'. Merging configuration file '/etc/clickhouse-server/config.d/system_unfreeze.xml'. Merging configuration file '/etc/clickhouse-server/config.d/tcp_with_proxy.xml'. Merging configuration file '/etc/clickhouse-server/config.d/test_cluster_with_incorrect_pw.xml'. Merging configuration file '/etc/clickhouse-server/config.d/text_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/top_level_domains_lists.xml'. Merging configuration file '/etc/clickhouse-server/config.d/top_level_domains_path.xml'. Merging configuration file '/etc/clickhouse-server/config.d/transactions.xml'. Merging configuration file '/etc/clickhouse-server/config.d/validate_tcp_client_information.xml'. Merging configuration file '/etc/clickhouse-server/config.d/zero_copy_destructive_operations.xml'. Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_fault_injection.xml'. Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_write.xml'. 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 - - [31/Aug/2024:11:31:25 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - + for table in query_log trace_log + clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.trace_log format TSVWithNamesAndTypes' + zstd --threads=0 Processing configuration file '/etc/clickhouse-server/config.xml'. Merging configuration file '/etc/clickhouse-server/config.d/CORS.xml'. Merging configuration file '/etc/clickhouse-server/config.d/asynchronous_metrics_update_period_s.xml'. Merging configuration file '/etc/clickhouse-server/config.d/azure_storage_conf.xml'. Merging configuration file '/etc/clickhouse-server/config.d/backoff_failed_mutation.xml'. Merging configuration file '/etc/clickhouse-server/config.d/backups.xml'. Merging configuration file '/etc/clickhouse-server/config.d/blob_storage_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/block_number.xml'. Merging configuration file '/etc/clickhouse-server/config.d/clusters.xml'. Merging configuration file '/etc/clickhouse-server/config.d/compressed_marks_and_index.xml'. Merging configuration file '/etc/clickhouse-server/config.d/core.xml'. Merging configuration file '/etc/clickhouse-server/config.d/custom_disks_base_path.xml'. Merging configuration file '/etc/clickhouse-server/config.d/custom_settings_prefixes.xml'. Merging configuration file '/etc/clickhouse-server/config.d/database_atomic.xml'. Merging configuration file '/etc/clickhouse-server/config.d/disable_s3_env_credentials.xml'. Merging configuration file '/etc/clickhouse-server/config.d/display_name.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_access_control_improvements.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_async_load_databases.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_keeper_map.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_wait_for_shutdown_replicated_tables.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_zero_copy_replication.xml'. Merging configuration file '/etc/clickhouse-server/config.d/encryption.xml'. Merging configuration file '/etc/clickhouse-server/config.d/filesystem_cache_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/filesystem_caches_path.xml'. Merging configuration file '/etc/clickhouse-server/config.d/forbidden_headers.xml'. Merging configuration file '/etc/clickhouse-server/config.d/graphite.xml'. Merging configuration file '/etc/clickhouse-server/config.d/graphite_alternative.xml'. Merging configuration file '/etc/clickhouse-server/config.d/handlers.yaml'. Merging configuration file '/etc/clickhouse-server/config.d/keeper_port.xml'. Merging configuration file '/etc/clickhouse-server/config.d/legacy_geobase.xml'. Merging configuration file '/etc/clickhouse-server/config.d/listen.xml'. Merging configuration file '/etc/clickhouse-server/config.d/logger_trace.xml'. Merging configuration file '/etc/clickhouse-server/config.d/logging_no_rotate.xml'. Merging configuration file '/etc/clickhouse-server/config.d/lost_forever_check.xml'. Merging configuration file '/etc/clickhouse-server/config.d/macros.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_concurrent_queries.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_num_to_warn.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_server_memory_usage.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree_old_dirs_cleanup.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree_settings.xml'. Merging configuration file '/etc/clickhouse-server/config.d/named_collection.xml'. Merging configuration file '/etc/clickhouse-server/config.d/nlp.xml'. Merging configuration file '/etc/clickhouse-server/config.d/prometheus.xml'. Merging configuration file '/etc/clickhouse-server/config.d/query_masking_rules.xml'. Merging configuration file '/etc/clickhouse-server/config.d/query_masking_rules.xml_original.xml'. Merging configuration file '/etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml'. Merging configuration file '/etc/clickhouse-server/config.d/secure_ports.xml'. Merging configuration file '/etc/clickhouse-server/config.d/session_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/ssl_certs.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02944.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02961.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02963.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_metadata_with_full_object_key.xml'. Merging configuration file '/etc/clickhouse-server/config.d/system_unfreeze.xml'. Merging configuration file '/etc/clickhouse-server/config.d/tcp_with_proxy.xml'. Merging configuration file '/etc/clickhouse-server/config.d/test_cluster_with_incorrect_pw.xml'. Merging configuration file '/etc/clickhouse-server/config.d/text_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/top_level_domains_lists.xml'. Merging configuration file '/etc/clickhouse-server/config.d/top_level_domains_path.xml'. Merging configuration file '/etc/clickhouse-server/config.d/transactions.xml'. Merging configuration file '/etc/clickhouse-server/config.d/validate_tcp_client_information.xml'. Merging configuration file '/etc/clickhouse-server/config.d/zero_copy_destructive_operations.xml'. Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_fault_injection.xml'. Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_write.xml'. 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 - - [31/Aug/2024:11:31:29 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - + 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 ']' + rg 'OOM in dmesg|Signal 9' /test_output/check_status.tsv + collect_core_dumps + find . -type f -maxdepth 1 -name 'core.*' + read -r core