+ 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.47.altinitystable+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.47.altinitystable+ubsan_amd64.deb ... Unpacking clickhouse-common-static (24.3.5.47.altinitystable+ubsan) ... Setting up clickhouse-common-static (24.3.5.47.altinitystable+ubsan) ... + dpkg -i package_folder/clickhouse-common-static-dbg_24.3.5.47.altinitystable+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.47.altinitystable+ubsan_amd64.deb ... Unpacking clickhouse-common-static-dbg (24.3.5.47.altinitystable+ubsan) ... Setting up clickhouse-common-static-dbg (24.3.5.47.altinitystable+ubsan) ... + dpkg -i package_folder/clickhouse-server_24.3.5.47.altinitystable+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.47.altinitystable+ubsan_amd64.deb ... Unpacking clickhouse-server (24.3.5.47.altinitystable+ubsan) ... Setting up clickhouse-server (24.3.5.47.altinitystable+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.47.altinitystable+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.47.altinitystable+ubsan_amd64.deb ... Unpacking clickhouse-client (24.3.5.47.altinitystable+ubsan) ... Setting up clickhouse-client (24.3.5.47.altinitystable+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=0 + sed --follow-symlinks -i 's|[01]|0|' /etc/clickhouse-server/config.d/keeper_port.xml + value=26185728 + sed --follow-symlinks -i 's|[[:digit:]]\+|26185728|' /etc/clickhouse-server/config.d/keeper_port.xml + value=7665664 + sed --follow-symlinks -i 's|[[:digit:]]\+|7665664|' /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 x86_64 Adding azure configuration + OS=x86_64 + [[ -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=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value multi_read keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value check_not_exists keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value create_if_not_exists keeper_port + value=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=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=32086444 + total_mem=32856518656 + max_server_memory_usage_to_ram_ratio=0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat Setting max_server_memory_usage_to_ram_ratio to 0.5 Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G + local max_users_mem + max_users_mem=9856955596 + echo 'Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G' + cat + cat + ./setup_minio.sh stateless + azurite-blob --blobHost 0.0.0.0 --blobPort 10000 --debug /azurite_log + export MINIO_ROOT_USER=clickhouse + MINIO_ROOT_USER=clickhouse + export MINIO_ROOT_PASSWORD=clickhouse + MINIO_ROOT_PASSWORD=clickhouse + main stateless + local query_dir ++ check_arg stateless ++ local query_dir ++ '[' '!' 1 -eq 1 ']' ++ case "$1" in ++ query_dir=0_stateless ++ echo 0_stateless + query_dir=0_stateless + '[' '!' -f ./minio ']' + start_minio + mkdir -p ./minio_data + ./minio --version 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 + local max_counter=60 + local url=http://localhost:11111 + params=('--silent' '--verbose') + local params + ./minio server --address :11111 ./minio_data + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 0 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=1 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 1 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + 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 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 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 trying to connect to minio + [[ 6 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + 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 trying to connect to minio + [[ 8 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + 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:42167 http://127.0.0.1:42167 Documentation: https://docs.min.io WARNING: Console endpoint is listening on a dynamic port (42167), please use --console-address ":PORT" to choose a static port. + counter=11 + curl --silent --verbose http://localhost:11111 + grep AccessDenied AccessDeniedAccess Denied./17E47DC0274BB0B1e130a4d4-d8a9-45f8-b77a-d0ab1c9f50b8 + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 290 root 10u IPv6 38219 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 02366_data.jsonl + 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 `/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: 154.75 MiB/s + 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 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: 89.73 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: 38.38 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.60 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: 5.00 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: 4.89 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: 5.34 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 127.0.0.1 - - [22/Jul/2024:09:07:12 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - + sleep 0.5 127.0.0.1 - - [22/Jul/2024:09:07:12 +0000] "PUT /devstoreaccount1/cont/erthscyrrwlgxlnistdyunxqyczzguts?blockid=rdelhtdlsuhbmbszrfpsxguxyedxjbpskbfpnycoosuhlawnawlyphwhpwjsdhwn&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:09:07:12 +0000] "PUT /devstoreaccount1/cont/erthscyrrwlgxlnistdyunxqyczzguts?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:09:07:12 +0000] "GET /devstoreaccount1/cont/erthscyrrwlgxlnistdyunxqyczzguts HTTP/1.1" 206 4 127.0.0.1 - - [22/Jul/2024:09:07:12 +0000] "GET /devstoreaccount1/cont/erthscyrrwlgxlnistdyunxqyczzguts HTTP/1.1" 206 2 127.0.0.1 - - [22/Jul/2024:09:07:12 +0000] "DELETE /devstoreaccount1/cont/erthscyrrwlgxlnistdyunxqyczzguts HTTP/1.1" 202 - + counter=6 + 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 582 + 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 File /tmp/export-logs-config.sh does not exist, do not setup + set +x + 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=582 + 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 = 582. The process with pid = 582 is running. Sent terminate signal to process with pid 582. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 582. The process with pid = 582 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 582. The process with pid = 582 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 582. The process with pid = 582 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 582. The process with pid = 582 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 582. The process with pid = 582 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 582. The process with pid = 582 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 582. The process with pid = 582 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 582. The process with pid = 582 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 582. The process with pid = 582 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 582. The process with pid = 582 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 582. The process with pid = 582 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 582. The process with pid = 582 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 582. The process with pid = 582 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 582. The process with pid = 582 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.initial.log + cache_policy= + '[' 1 -eq 1 ']' + cache_policy=SLRU Using cache policy: SLRU + echo 'Using cache policy: SLRU' + '[' SLRU = SLRU ']' + sudo cat /etc/clickhouse-server/config.d/storage_conf.xml + sed 's|LRU|SLRU|' + mv /etc/clickhouse-server/config.d/storage_conf.xml.tmp /etc/clickhouse-server/config.d/storage_conf.xml + 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 127.0.0.1 - - [22/Jul/2024:09:08:35 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [22/Jul/2024:09:08:35 +0000] "PUT /devstoreaccount1/cont/xfgkpawagwowscydaadkdisgbhkzdmlg?blockid=hxofghealnylnpttxttbsezfhopoycxctdzxxtzvjthtadfqivvlytoakbzzlnrf&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:09:08:35 +0000] "PUT /devstoreaccount1/cont/xfgkpawagwowscydaadkdisgbhkzdmlg?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:09:08:35 +0000] "GET /devstoreaccount1/cont/xfgkpawagwowscydaadkdisgbhkzdmlg HTTP/1.1" 206 4 127.0.0.1 - - [22/Jul/2024:09:08:35 +0000] "GET /devstoreaccount1/cont/xfgkpawagwowscydaadkdisgbhkzdmlg HTTP/1.1" 206 2 127.0.0.1 - - [22/Jul/2024:09:08:35 +0000] "DELETE /devstoreaccount1/cont/xfgkpawagwowscydaadkdisgbhkzdmlg HTTP/1.1" 202 - + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root + 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' 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 1418 + 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=1418 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1418. The process with pid = 1418 is running. Sent terminate signal to process with pid 1418. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1418. The process with pid = 1418 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1418. The process with pid = 1418 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 + 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=0 + sed --follow-symlinks -i 's|[01]|0|' /etc/clickhouse-server/config.d/keeper_port.xml + value=45502464 + sed --follow-symlinks -i 's|[[:digit:]]\+|45502464|' /etc/clickhouse-server/config.d/keeper_port.xml + value=12699648 + sed --follow-symlinks -i 's|[[:digit:]]\+|12699648|' /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-suffix + case $object_key_type in + ln -sf /usr/share/clickhouse-test/config/config.d/s3_storage_policy_by_default.xml /etc/clickhouse-server/config.d/ + ARM=aarch64 ++ uname -m + OS=x86_64 + [[ -n 1 ]] + echo x86_64 + [[ '' -eq 1 ]] + [[ x86_64 == \a\a\r\c\h\6\4 ]] x86_64 Adding azure configuration + 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 script.gdb:13: Error in sourced command file: No stack. + 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=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value use_compression zookeeper_fault_injection + value=1 + sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + randomize_config_boolean_value 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=32086444 + total_mem=32856518656 + max_server_memory_usage_to_ram_ratio=0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat Setting max_server_memory_usage_to_ram_ratio to 0.5 Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G + local max_users_mem + max_users_mem=9856955596 + echo 'Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G' + cat + cat + 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 + '[' SLRU = SLRU ']' + sudo cat /etc/clickhouse-server/config.d/storage_conf.xml + sed 's|LRU|SLRU|' + mv /etc/clickhouse-server/config.d/storage_conf.xml.tmp /etc/clickhouse-server/config.d/storage_conf.xml ++ date +%-d + '[' 0 -eq 1 ']' + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root 127.0.0.1 - - [22/Jul/2024:09:21:46 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - + sleep 0.5 127.0.0.1 - - [22/Jul/2024:09:21:46 +0000] "PUT /devstoreaccount1/cont/cjudvrpvtfetnwwronpliqtyfalmzswo?blockid=mparxqhulbrdzbloofviwkjmmisaslvethizvzeecjfcgfklmmjyswdbezabmsup&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:09:21:46 +0000] "PUT /devstoreaccount1/cont/cjudvrpvtfetnwwronpliqtyfalmzswo?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:09:21:46 +0000] "GET /devstoreaccount1/cont/cjudvrpvtfetnwwronpliqtyfalmzswo HTTP/1.1" 206 4 127.0.0.1 - - [22/Jul/2024:09:21:46 +0000] "GET /devstoreaccount1/cont/cjudvrpvtfetnwwronpliqtyfalmzswo HTTP/1.1" 206 2 127.0.0.1 - - [22/Jul/2024:09:21:46 +0000] "DELETE /devstoreaccount1/cont/cjudvrpvtfetnwwronpliqtyfalmzswo 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' 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' 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 2728 + 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-07-22 11:22:44,241 Run func tests '/usr/bin/clickhouse-test --global_time_limit=1200 ' 2024-07-22 11:22:44,743 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 http_make_head_request=0 --global_time_limit=1200 ' 2024-07-22 11:22:45,244 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 use_query_cache=1 --global_time_limit=1200 ' 2024-07-22 11:22:45,745 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_3 --client-option join_algorithm='partial_merge' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-07-22 11:22:46,246 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 ' 2024-07-22 11:22:46,747 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 http_make_head_request=1 --global_time_limit=1200 ' 2024-07-22 11:22:47,248 Run func tests '/usr/bin/clickhouse-test --order=random --client-option use_query_cache=1 memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 --global_time_limit=1200 ' 2024-07-22 11:22:47,749 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_7 --client-option join_use_nulls=1 join_algorithm='grace_hash' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-07-22 11:22:48,251 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 use_query_cache=1 http_make_head_request=1 --global_time_limit=1200 ' 2024-07-22 11:22:48,752 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 http_make_head_request=1 --global_time_limit=1200 ' 2024-07-22 11:22:49,253 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 use_query_cache=1 --global_time_limit=1200 ' 2024-07-22 11:22:49,753 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 http_make_head_request=0 --global_time_limit=1200 ' 2024-07-22 11:22:50,255 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=0 --global_time_limit=1200 ' 2024-07-22 11:22:50,756 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_13 --client-option join_use_nulls=1 join_algorithm='partial_merge' use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-07-22 11:22:51,257 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-07-22 11:22:51,758 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_merge' group_by_use_nulls=1 http_make_head_request=0 --global_time_limit=1200 ' 2024-07-22 11:22:52,259 Will wait functests to finish 2024-07-22 11:22:52,260 Finished 10 from 16 processes 2024-07-22 11:22:57,261 Finished 10 from 16 processes 2024-07-22 11:23:02,265 Finished 10 from 16 processes 2024-07-22 11:23:07,269 Finished 10 from 16 processes 2024-07-22 11:23:12,274 Finished 10 from 16 processes 2024-07-22 11:23:17,277 Finished 10 from 16 processes 2024-07-22 11:23:22,281 Finished 10 from 16 processes 2024-07-22 11:23:27,285 Finished 10 from 16 processes 2024-07-22 11:23:32,289 Finished 10 from 16 processes 2024-07-22 11:23:37,293 Finished 10 from 16 processes 2024-07-22 11:23:42,297 Finished 10 from 16 processes 2024-07-22 11:23:47,301 Finished 10 from 16 processes 2024-07-22 11:23:52,305 Finished 10 from 16 processes 2024-07-22 11:23:57,309 Finished 10 from 16 processes 2024-07-22 11:24:02,313 Finished 10 from 16 processes 2024-07-22 11:24:07,317 Finished 10 from 16 processes 2024-07-22 11:24:12,321 Finished 10 from 16 processes 2024-07-22 11:24:17,325 Finished 10 from 16 processes 2024-07-22 11:24:22,329 Finished 10 from 16 processes 2024-07-22 11:24:27,333 Finished 10 from 16 processes 2024-07-22 11:24:32,337 Finished 10 from 16 processes 2024-07-22 11:24:37,341 Finished 10 from 16 processes 2024-07-22 11:24:42,345 Finished 10 from 16 processes 2024-07-22 11:24:47,349 Finished 10 from 16 processes 2024-07-22 11:24:52,354 Finished 10 from 16 processes 2024-07-22 11:24:57,357 Finished 10 from 16 processes 2024-07-22 11:25:02,361 Finished 10 from 16 processes 2024-07-22 11:25:07,365 Finished 10 from 16 processes 2024-07-22 11:25:12,370 Finished 10 from 16 processes 2024-07-22 11:25:17,373 Finished 10 from 16 processes 2024-07-22 11:25:22,378 Finished 10 from 16 processes 2024-07-22 11:25:27,381 Finished 10 from 16 processes 2024-07-22 11:25:32,385 Finished 10 from 16 processes 2024-07-22 11:25:37,389 Finished 10 from 16 processes 2024-07-22 11:25:42,393 Finished 10 from 16 processes 2024-07-22 11:25:47,397 Finished 10 from 16 processes 2024-07-22 11:25:52,401 Finished 10 from 16 processes 2024-07-22 11:25:57,405 Finished 10 from 16 processes 2024-07-22 11:26:02,409 Finished 10 from 16 processes 2024-07-22 11:26:07,415 Finished 10 from 16 processes 2024-07-22 11:26:12,417 Finished 10 from 16 processes 2024-07-22 11:26:17,421 Finished 10 from 16 processes 2024-07-22 11:26:22,425 Finished 10 from 16 processes 2024-07-22 11:26:27,430 Finished 10 from 16 processes 2024-07-22 11:26:32,435 Finished 10 from 16 processes 2024-07-22 11:26:37,437 Finished 10 from 16 processes 2024-07-22 11:26:42,441 Finished 10 from 16 processes 2024-07-22 11:26:47,445 Finished 10 from 16 processes 2024-07-22 11:26:52,449 Finished 10 from 16 processes 2024-07-22 11:26:57,453 Finished 10 from 16 processes 2024-07-22 11:27:02,457 Finished 10 from 16 processes 2024-07-22 11:27:07,461 Finished 10 from 16 processes 2024-07-22 11:27:12,466 Finished 10 from 16 processes 2024-07-22 11:27:17,470 Finished 10 from 16 processes 2024-07-22 11:27:22,473 Finished 10 from 16 processes 2024-07-22 11:27:27,477 Finished 10 from 16 processes 2024-07-22 11:27:32,483 Finished 10 from 16 processes 2024-07-22 11:27:37,485 Finished 10 from 16 processes 2024-07-22 11:27:42,489 Finished 10 from 16 processes 2024-07-22 11:27:47,493 Finished 10 from 16 processes 2024-07-22 11:27:52,499 Finished 10 from 16 processes 2024-07-22 11:27:57,501 Finished 10 from 16 processes 2024-07-22 11:28:02,507 Finished 10 from 16 processes 2024-07-22 11:28:07,509 Finished 10 from 16 processes 2024-07-22 11:28:12,513 Finished 10 from 16 processes 2024-07-22 11:28:17,517 Finished 10 from 16 processes 2024-07-22 11:28:22,521 Finished 10 from 16 processes 2024-07-22 11:28:27,525 Finished 10 from 16 processes 2024-07-22 11:28:32,529 Finished 10 from 16 processes 2024-07-22 11:28:37,533 Finished 10 from 16 processes 2024-07-22 11:28:42,537 Finished 10 from 16 processes 2024-07-22 11:28:47,541 Finished 10 from 16 processes 2024-07-22 11:28:52,545 Finished 10 from 16 processes 2024-07-22 11:28:57,549 Finished 10 from 16 processes 2024-07-22 11:29:02,553 Finished 10 from 16 processes 2024-07-22 11:29:07,557 Finished 10 from 16 processes 2024-07-22 11:29:12,563 Finished 10 from 16 processes 2024-07-22 11:29:17,565 Finished 10 from 16 processes 2024-07-22 11:29:22,569 Finished 10 from 16 processes 2024-07-22 11:29:27,573 Finished 10 from 16 processes 2024-07-22 11:29:32,577 Finished 10 from 16 processes 2024-07-22 11:29:37,581 Finished 10 from 16 processes 2024-07-22 11:29:42,585 Finished 10 from 16 processes 2024-07-22 11:29:47,589 Finished 10 from 16 processes 2024-07-22 11:29:52,593 Finished 10 from 16 processes 2024-07-22 11:29:57,597 Finished 10 from 16 processes 2024-07-22 11:30:02,601 Finished 10 from 16 processes 2024-07-22 11:30:07,605 Finished 10 from 16 processes 2024-07-22 11:30:12,609 Finished 10 from 16 processes 2024-07-22 11:30:17,613 Finished 10 from 16 processes 2024-07-22 11:30:22,618 Finished 10 from 16 processes 2024-07-22 11:30:27,621 Finished 10 from 16 processes 2024-07-22 11:30:32,625 Finished 10 from 16 processes 2024-07-22 11:30:37,629 Finished 10 from 16 processes 2024-07-22 11:30:42,633 Finished 10 from 16 processes 2024-07-22 11:30:47,637 Finished 10 from 16 processes 2024-07-22 11:30:52,641 Finished 10 from 16 processes 2024-07-22 11:30:57,645 Finished 10 from 16 processes 2024-07-22 11:31:02,649 Finished 10 from 16 processes 2024-07-22 11:31:07,653 Finished 10 from 16 processes 2024-07-22 11:31:12,657 Finished 10 from 16 processes 2024-07-22 11:31:17,660 Finished 10 from 16 processes 2024-07-22 11:31:22,665 Finished 10 from 16 processes 2024-07-22 11:31:27,670 Finished 10 from 16 processes 2024-07-22 11:31:32,673 Finished 10 from 16 processes 2024-07-22 11:31:37,677 Finished 10 from 16 processes 2024-07-22 11:31:42,681 Finished 10 from 16 processes 2024-07-22 11:31:47,687 Finished 10 from 16 processes 2024-07-22 11:31:52,689 Finished 10 from 16 processes 2024-07-22 11:31:57,693 Finished 10 from 16 processes 2024-07-22 11:32:02,697 Finished 10 from 16 processes 2024-07-22 11:32:07,701 Finished 10 from 16 processes 2024-07-22 11:32:12,705 Finished 10 from 16 processes 2024-07-22 11:32:17,708 Finished 10 from 16 processes 2024-07-22 11:32:22,713 Finished 10 from 16 processes 2024-07-22 11:32:27,717 Finished 10 from 16 processes 2024-07-22 11:32:32,721 Finished 10 from 16 processes 2024-07-22 11:32:37,725 Finished 10 from 16 processes 2024-07-22 11:32:42,729 Finished 11 from 16 processes 2024-07-22 11:32:47,735 Finished 11 from 16 processes 2024-07-22 11:32:52,737 Finished 11 from 16 processes 2024-07-22 11:32:57,741 Finished 11 from 16 processes 2024-07-22 11:33:02,745 Finished 11 from 16 processes 2024-07-22 11:33:07,749 Finished 11 from 16 processes 2024-07-22 11:33:12,753 Finished 11 from 16 processes 2024-07-22 11:33:17,759 Finished 11 from 16 processes 2024-07-22 11:33:22,761 Finished 11 from 16 processes 2024-07-22 11:33:27,765 Finished 11 from 16 processes 2024-07-22 11:33:32,769 Finished 11 from 16 processes 2024-07-22 11:33:37,773 Finished 11 from 16 processes 2024-07-22 11:33:42,779 Finished 11 from 16 processes 2024-07-22 11:33:47,781 Finished 11 from 16 processes 2024-07-22 11:33:52,785 Finished 11 from 16 processes 2024-07-22 11:33:57,791 Finished 11 from 16 processes 2024-07-22 11:34:02,793 Finished 11 from 16 processes 2024-07-22 11:34:07,798 Finished 11 from 16 processes 2024-07-22 11:34:12,801 Finished 11 from 16 processes 2024-07-22 11:34:17,806 Finished 11 from 16 processes 2024-07-22 11:34:22,809 Finished 11 from 16 processes 2024-07-22 11:34:27,813 Finished 11 from 16 processes 2024-07-22 11:34:32,817 Finished 11 from 16 processes 2024-07-22 11:34:37,821 Finished 11 from 16 processes 2024-07-22 11:34:42,826 Finished 11 from 16 processes 2024-07-22 11:34:47,832 Finished 11 from 16 processes 2024-07-22 11:34:52,833 Finished 11 from 16 processes 2024-07-22 11:34:57,837 Finished 11 from 16 processes 2024-07-22 11:35:02,841 Finished 11 from 16 processes 2024-07-22 11:35:07,845 Finished 11 from 16 processes 2024-07-22 11:35:12,849 Finished 11 from 16 processes 2024-07-22 11:35:17,853 Finished 11 from 16 processes 2024-07-22 11:35:22,857 Finished 11 from 16 processes 2024-07-22 11:35:27,863 Finished 11 from 16 processes 2024-07-22 11:35:32,865 Finished 11 from 16 processes 2024-07-22 11:35:37,869 Finished 11 from 16 processes 2024-07-22 11:35:42,873 Finished 11 from 16 processes 2024-07-22 11:35:47,874 Finished 11 from 16 processes 2024-07-22 11:35:52,877 Finished 11 from 16 processes 2024-07-22 11:35:57,882 Finished 11 from 16 processes 2024-07-22 11:36:02,885 Finished 12 from 16 processes 2024-07-22 11:36:07,889 Finished 12 from 16 processes 2024-07-22 11:36:12,893 Finished 12 from 16 processes 2024-07-22 11:36:17,897 Finished 12 from 16 processes 2024-07-22 11:36:22,900 Finished 12 from 16 processes 2024-07-22 11:36:27,901 Finished 12 from 16 processes 2024-07-22 11:36:32,905 Finished 12 from 16 processes 2024-07-22 11:36:37,909 Finished 12 from 16 processes 2024-07-22 11:36:42,913 Finished 12 from 16 processes 2024-07-22 11:36:47,919 Finished 12 from 16 processes 2024-07-22 11:36:52,921 Finished 12 from 16 processes 2024-07-22 11:36:57,925 Finished 12 from 16 processes 2024-07-22 11:37:02,926 Finished 12 from 16 processes 2024-07-22 11:37:07,931 Finished 12 from 16 processes 2024-07-22 11:37:12,933 Finished 12 from 16 processes 2024-07-22 11:37:17,937 Finished 12 from 16 processes 2024-07-22 11:37:22,943 Finished 12 from 16 processes 2024-07-22 11:37:27,945 Finished 12 from 16 processes 2024-07-22 11:37:32,949 Finished 12 from 16 processes 2024-07-22 11:37:37,951 Finished 12 from 16 processes 2024-07-22 11:37:42,953 Finished 12 from 16 processes 2024-07-22 11:37:47,957 Finished 12 from 16 processes 2024-07-22 11:37:52,961 Finished 12 from 16 processes 2024-07-22 11:37:57,965 Finished 12 from 16 processes 2024-07-22 11:38:02,971 Finished 12 from 16 processes 2024-07-22 11:38:07,973 Finished 12 from 16 processes 2024-07-22 11:38:12,977 Finished 12 from 16 processes 2024-07-22 11:38:17,981 Finished 12 from 16 processes 2024-07-22 11:38:22,987 Finished 12 from 16 processes 2024-07-22 11:38:27,991 Finished 12 from 16 processes 2024-07-22 11:38:32,996 Finished 12 from 16 processes 2024-07-22 11:38:37,997 Finished 12 from 16 processes 2024-07-22 11:38:43,003 Finished 12 from 16 processes 2024-07-22 11:38:48,005 Finished 12 from 16 processes 2024-07-22 11:38:53,009 Finished 12 from 16 processes 2024-07-22 11:38:58,013 Finished 12 from 16 processes 2024-07-22 11:39:03,014 Finished 12 from 16 processes 2024-07-22 11:39:08,017 Finished 12 from 16 processes 2024-07-22 11:39:13,022 Finished 12 from 16 processes 2024-07-22 11:39:18,025 Finished 12 from 16 processes 2024-07-22 11:39:23,029 Finished 12 from 16 processes 2024-07-22 11:39:28,033 Finished 12 from 16 processes 2024-07-22 11:39:33,037 Finished 12 from 16 processes 2024-07-22 11:39:38,041 Finished 12 from 16 processes 2024-07-22 11:39:43,045 Finished 12 from 16 processes 2024-07-22 11:39:48,049 Finished 12 from 16 processes 2024-07-22 11:39:53,053 Finished 12 from 16 processes 2024-07-22 11:39:58,057 Finished 12 from 16 processes 2024-07-22 11:40:03,061 Finished 12 from 16 processes 2024-07-22 11:40:08,065 Finished 12 from 16 processes 2024-07-22 11:40:13,068 Finished 12 from 16 processes 2024-07-22 11:40:18,073 Finished 12 from 16 processes 2024-07-22 11:40:23,077 Finished 12 from 16 processes 2024-07-22 11:40:28,081 Finished 12 from 16 processes 2024-07-22 11:40:33,085 Finished 12 from 16 processes 2024-07-22 11:40:38,089 Finished 12 from 16 processes 2024-07-22 11:40:43,093 Finished 12 from 16 processes 2024-07-22 11:40:48,097 Finished 12 from 16 processes 2024-07-22 11:40:53,101 Finished 12 from 16 processes 2024-07-22 11:40:58,105 Finished 12 from 16 processes 2024-07-22 11:41:03,109 Finished 12 from 16 processes 2024-07-22 11:41:08,113 Finished 12 from 16 processes 2024-07-22 11:41:13,117 Finished 12 from 16 processes 2024-07-22 11:41:18,123 Finished 12 from 16 processes 2024-07-22 11:41:23,125 Finished 12 from 16 processes 2024-07-22 11:41:28,130 Finished 12 from 16 processes 2024-07-22 11:41:33,133 Finished 12 from 16 processes 2024-07-22 11:41:38,137 Finished 12 from 16 processes 2024-07-22 11:41:43,141 Finished 12 from 16 processes 2024-07-22 11:41:48,142 Finished 12 from 16 processes 2024-07-22 11:41:53,146 Finished 12 from 16 processes 2024-07-22 11:41:58,149 Finished 12 from 16 processes 2024-07-22 11:42:03,153 Finished 12 from 16 processes 2024-07-22 11:42:08,157 Finished 12 from 16 processes 2024-07-22 11:42:13,161 Finished 12 from 16 processes 2024-07-22 11:42:18,163 Finished 12 from 16 processes 2024-07-22 11:42:23,168 Finished 12 from 16 processes 2024-07-22 11:42:28,173 Finished 12 from 16 processes 2024-07-22 11:42:33,177 Finished 12 from 16 processes 2024-07-22 11:42:38,181 Finished 12 from 16 processes 2024-07-22 11:42:43,185 Finished 12 from 16 processes 2024-07-22 11:42:48,191 Finished 13 from 16 processes 2024-07-22 11:42:53,194 Finished 13 from 16 processes 2024-07-22 11:42:58,199 Finished 13 from 16 processes 2024-07-22 11:43:03,204 Finished 14 from 16 processes 2024-07-22 11:43:08,209 Finished 15 from 16 processes 2024-07-22 11:43:13,215 Finished 15 from 16 processes 2024-07-22 11:43:18,220 Finished 15 from 16 processes 2024-07-22 11:43:23,223 Finished 15 from 16 processes 2024-07-22 11:43:28,228 Finished 15 from 16 processes 2024-07-22 11:43:33,234 Finished 15 from 16 processes 2024-07-22 11:43:38,234 Finished 15 from 16 processes 2024-07-22 11:43:43,236 Finished 15 from 16 processes 2024-07-22 11:43:48,241 Finished 15 from 16 processes 2024-07-22 11:43:53,245 Finished 15 from 16 processes 2024-07-22 11:43:58,249 Finished 15 from 16 processes 2024-07-22 11:44:03,253 Finished 15 from 16 processes 2024-07-22 11:44:08,257 Finished 15 from 16 processes 2024-07-22 11:44:13,262 Finished 15 from 16 processes 2024-07-22 11:44:18,263 Finished 15 from 16 processes 2024-07-22 11:44:23,265 Finished 15 from 16 processes 2024-07-22 11:44:28,267 Finished 15 from 16 processes 2024-07-22 11:44:33,269 All processes finished 2024-07-22 11:44:33,270 Compressing stress logs 2024-07-22 11:44:33,287 Logs compressed 2024-07-22 11:44:33,287 Will terminate gdb (if any) 2024-07-22 11:44:33,287 Running command: kill -TERM $(pidof gdb) 2024-07-22 11:44:33,291 Running command: timeout 50s tail --pid=$(pidof gdb) -f /dev/null || kill -9 $(pidof gdb) ||: Quit 2024-07-22 11:44:34,308 Running command: kill -CONT $(cat /var/run/clickhouse-server/clickhouse-server.pid) && clickhouse client -q 'SELECT 1 FORMAT Null' 2024-07-22 11:44:34,624 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-07-22 11:44:34,839 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-07-22 11:44:35,003 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-07-22 11:44:35,168 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-07-22 11:44:35,332 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-07-22 11:44:35,496 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-07-22 11:44:35,661 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-07-22 11:44:35,825 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-07-22 11:44:35,990 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-07-22 11:44:36,154 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-07-22 11:44:36,318 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-07-22 11:44:36,483 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-07-22 11:44:36,647 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-07-22 11:49:38,362 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.47.altinitystable @ b6642564dbf296d6e55b907d7af6c8087470b672 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. 54195 0.105 3.15 MiB 0.024 1 91 ['Debug'] 0.979 Key {} is removed from metadata 2. 51315 0.1 2.89 MiB 0.022 1 711 ['Debug'] 0.004 Submitting key {} for removal 3. 26655 0.052 7.99 MiB 0.061 8960 606 ['Information'] 0.002 Setting download as failed: {} 4. 22202 0.043 2.48 MiB 0.019 3151 560 ['Trace'] 0 Bypassing cache because file segment state is `PARTIALLY_DOWNLOADED_NO_CONTINUATION` and downloaded part already used 5. 18557 0.036 1.45 MiB 0.011 7053 557 ['Trace'] 0.001 No space left in cache to reserve {} bytes, will continue without cache download 6. 16708 0.032 1.55 MiB 0.012 1 507 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 7. 16192 0.031 2.13 MiB 0.016 1 454 ['Information'] 0 Sorting and writing part of data into temporary file {} 8. 16190 0.031 2.72 MiB 0.021 1 462 ['Information'] 0 Done writing part of data into temporary file {}, compressed {}, uncompressed {} 9. 14951 0.029 440.83 KiB 0.003 1 507 ['Trace'] 0 Aggregation method: {} 10. 12050 0.023 129.44 KiB 0.001 1 505 ['Trace'] 0 Aggregating 11. 9788 0.019 583.99 KiB 0.004 2 263 ['Trace'] 0 Access granted: {}{} 12. 9374 0.018 1.36 MiB 0.01 1 328 ['Debug'] 0 Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.) 13. 9374 0.018 462.74 KiB 0.003 1 328 ['Trace'] 0 Merging partially aggregated blocks (bucket = {}). 14. 9283 0.018 774.59 KiB 0.006 1 493 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 15. 8211 0.016 701.19 KiB 0.005 47 91 ['Trace'] 0 Reading {} ranges in{}order from part {}, approx. {} rows starting from {} 16. 7249 0.014 735.21 KiB 0.005 1922 478 ['Trace'] 0 Predownload failed because of space limit. Will read from remote filesystem starting from offset: {} 17. 7086 0.014 1.51 MiB 0.012 1 142 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 18. 7080 0.014 1.06 MiB 0.008 3 142 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 19. 5790 0.011 650.24 KiB 0.005 4 166 ['Debug'] 0.998 {} Authenticated with global context as user {} 20. 5790 0.011 481.69 KiB 0.004 4 166 ['Debug'] 0.998 {} Authenticating user '{}' from {} 21. 5773 0.011 631.42 KiB 0.005 3 155 ['Debug'] 1 {} Creating session context with user_id: {} 22. 5770 0.011 507.13 KiB 0.004 4 164 ['Debug'] 0.998 {} Logout, user_id: {} 23. 5548 0.011 156.66 KiB 0.001 1 140 ['Debug'] 0 Processed in {} sec. 24. 5547 0.011 245.33 KiB 0.002 1 213 ['Debug'] 0 Max size of temporary block: {} rows, {}. 25. 5547 0.011 747.54 KiB 0.006 1 213 ['Debug'] 0 Writing part of aggregation data into temporary file {} 26. 5547 0.011 1.33 MiB 0.01 1 213 ['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) 27. 4939 0.01 221.00 KiB 0.002 1 1 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 28. 4411 0.009 520.52 KiB 0.004 212 318 ['Trace'] 0.636 Renaming temporary part {} to {} with tid {}. 29. 4262 0.008 390.50 KiB 0.003 1 154 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 30. 4262 0.008 139.34 KiB 0.001 1 154 ['Trace'] 1 TCP Request. Address: {} 31. 4015 0.008 278.46 KiB 0.002 206 648 ['Trace'] 0.761 Trying to reserve {} using storage policy from min volume index {} 32. 3998 0.008 190.25 KiB 0.001 1 302 ['Trace'] 0.597 filled checksums {} 33. 3942 0.008 32.90 MiB 0.251 1 162 ['Trace'] 0.002 Query {} to stage {}{} 34. 3918 0.008 32.98 MiB 0.252 1 162 ['Trace'] 0.002 Query {} from stage {} to stage {}{} 35. 3667 0.007 146.82 KiB 0.001 1 463 ['Trace'] 0 Converting aggregation data to two-level. 36. 3644 0.007 2.47 MiB 0.019 1 310 ['Debug'] 0.904 Objects with paths [{}] were removed from S3 37. 3575 0.007 335.54 KiB 0.003 1 28 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 38. 3491 0.007 283.06 KiB 0.002 1 123 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 39. 3324 0.006 5.61 MiB 0.043 1 276 ['Debug'] 0.925 metadata and objects were removed for [{}], only metadata were removed for [{}]. 40. 3191 0.006 375.64 KiB 0.003 1 18 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 41. 3128 0.006 148.54 KiB 0.001 1 148 ['Debug'] 0.208 Peak memory usage{}: {}. 42. 2962 0.006 355.09 KiB 0.003 1 69 ['Trace'] 0 PREWHERE condition was split into {} steps: {} 43. 2731 0.005 4.54 MiB 0.035 2 127 ['Error'] 1 Database {} does not exist. Maybe you meant {}? 44. 2379 0.005 85.65 KiB 0.001 16 16 ['Trace'] 1 Flushed system log up to offset {} 45. 2379 0.005 138.31 KiB 0.001 16 16 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 46. 2334 0.005 212.73 KiB 0.002 1 437 ['Debug'] 0 Merge sorted {} blocks, {} rows in {} sec., {} rows/sec., {}/sec 47. 1995 0.004 406.16 KiB 0.003 2 83 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {} 48. 1989 0.004 660.96 KiB 0.005 2 83 ['Trace'] 1 Request URI: {} 49. 1873 0.004 79.14 KiB 0.001 1 438 ['Information'] 0 There are {} temporary sorted parts to merge 50. 1868 0.004 38.31 KiB 0 2 83 ['Debug'] 0.226 Done processing query 51. 1707 0.003 151.08 KiB 0.001 26 247 ['Trace'] 0.984 Insert entry {} to queue with type {} 52. 1681 0.003 77.41 KiB 0.001 1 432 ['Debug'] 0 Aggregated. {} to {} rows (from {}) 53. 1653 0.003 32.29 KiB 0 1 448 ['Trace'] 0 Aggregating in order 54. 1519 0.003 40.05 KiB 0 1 138 ['Debug'] 1 Done processing connection. 55. 1494 0.003 159.03 KiB 0.001 10 493 ['Trace'] 1 Cannot execute alter metadata {} with version {} because another alter {} must be executed before 56. 1439 0.003 176.52 KiB 0.001 1 2 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 57. 1408 0.003 210.09 KiB 0.002 1 5 ['Trace'] 1 Creating part at path {} 58. 1389 0.003 42.17 KiB 0 151 119 ['Debug'] 0.011 Key condition: {} 59. 1387 0.003 164.21 KiB 0.001 148 119 ['Debug'] 0.011 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 60. 1240 0.002 163.26 KiB 0.001 55 51 ['Debug'] 0 Part: {}, sum_marks: {}, approx mark size: {}, prefetch_step_bytes: {}, prefetch_step_marks: {}, (ranges: {}) 61. 1229 0.002 63.61 KiB 0 137 106 ['Trace'] 0.012 Spreading mark ranges among streams (default reading) 62. 1225 0.002 48.29 KiB 0 135 105 ['Debug'] 0.012 Reading approx. {} rows with {} streams 63. 1101 0.002 82.67 KiB 0.001 10 299 ['Trace'] 0 Used generic exclusion search over index for part {} with {} steps 64. 952 0.002 21.38 KiB 0 1 356 ['Trace'] 0 Merging aggregated data 65. 926 0.002 28.12 KiB 0 22 345 ['Trace'] 0 Found (RIGHT) boundary mark: {} 66. 926 0.002 27.13 KiB 0 22 345 ['Trace'] 0 Found (LEFT) boundary mark: {} 67. 926 0.002 26.55 KiB 0 22 345 ['Trace'] 0 Found {} range in {} steps 68. 926 0.002 64.04 KiB 0 22 345 ['Trace'] 0 Running binary search on index range for part {} ({} marks) 69. 878 0.002 31.78 KiB 0 42 31 ['Debug'] 0 Increasing prefetch step from {} to {} 70. 826 0.002 66.95 KiB 0 1 17 ['Information'] 0 Write-through cache is stopped as cache limit is reached and nothing can be evicted 71. 826 0.002 329.07 KiB 0.002 1 17 ['Debug'] 0 Failed to reserve space in cache (size: {}, file segment info: {} 72. 800 0.002 17.57 KiB 0 90 426 ['Trace'] 1 Execution took {} ms. 73. 779 0.002 28.55 KiB 0 24 86 ['Debug'] 0 MinMax index condition: {} 74. 756 0.001 64.32 KiB 0 23 143 ['Trace'] 0.455 Part {} local references is zero, will check blobs can be removed in zookeeper 75. 749 0.001 139.20 KiB 0.001 22 139 ['Trace'] 0.457 Removing zookeeper lock {} for part {} (files to keep: [{}]) 76. 731 0.001 56.40 KiB 0 1 83 ['Trace'] 0 Query span trace_id for opentelemetry log: {} 77. 727 0.001 38.16 KiB 0 65 391 ['Debug'] 0.972 Selected {} parts from {} to {} 78. 717 0.001 87.25 KiB 0.001 1 28 ['Trace'] 0 Have {} pending inserts with total {} bytes of data for query '{}' 79. 691 0.001 21.60 KiB 0 1 84 ['Debug'] 0.022 min_marks_for_concurrent_read={} 80. 671 0.001 43.62 KiB 0 1 227 ['Debug'] 1 Execute load job '{}' in {} 81. 671 0.001 45.59 KiB 0 1 62 ['Debug'] 0.058 Schedule load job '{}' into {} 82. 671 0.001 20.98 KiB 0 1 267 ['Debug'] 0.528 Spawn loader worker #{} in {} 83. 671 0.001 13.76 KiB 0 1 330 ['Debug'] 1 Stop worker in {} 84. 671 0.001 46.24 KiB 0 1 227 ['Debug'] 1 Finish load job '{}' with status {} 85. 670 0.001 52.69 KiB 0 1 62 ['Debug'] 0.057 Prioritize load job '{}': {} -> {} 86. 644 0.001 53.37 KiB 0 1 29 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {} 87. 644 0.001 21.99 KiB 0 1 29 ['Debug'] 0 Selected MergeAlgorithm: {} 88. 642 0.001 21.32 KiB 0 1 275 ['Debug'] 0.508 Change current priority: {} -> {} 89. 637 0.001 83.34 KiB 0.001 1 29 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec. 90. 636 0.001 5.59 KiB 0 2 62 ['Trace'] 0.003 No tables 91. 635 0.001 41.44 KiB 0 58 29 ['Trace'] 0 Merged {} parts: [{}, {}] -> {} 92. 618 0.001 83.06 KiB 0.001 211 182 ['Debug'] 0.932 Removing {} parts from filesystem (serially): Parts: [{}] 93. 610 0.001 49.65 KiB 0 1 302 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={} 94. 538 0.001 17.13 KiB 0 19 17 ['Debug'] 0 Requested flush up to offset {} 95. 519 0.001 37.78 KiB 0 1 79 ['Trace'] 0 The min valid primary key position for moving to the tail of PREWHERE is {} 96. 476 0.001 67.13 KiB 0.001 12 32 ['Debug'] 1 Fetching part {} from {}:{} 97. 474 0.001 24.53 KiB 0 12 32 ['Trace'] 1 Disk {} (with type {}) supports zero-copy replication 98. 474 0.001 40.73 KiB 0 12 32 ['Trace'] 1 Trying to fetch with zero-copy replication, but disk is not provided, will try to select 99. 474 0.001 13.42 KiB 0 12 32 ['Trace'] 1 Checking disk {} with type {} 100. 471 0.001 18.48 KiB 0 18 32 ['Debug'] 0.887 Committing part {} to zookeeper Top messages without format string (fmt::runtime): count pattern runtime_message line 1. 49 autoDBStorageReplicatedMergeTree auto DB::StorageReplicatedMergeTree::processQueueEntry(ReplicatedMergeTreeQueue::SelectedEntryPtr)::(anonymous class)::operator()(LogEntryPtr &) const: Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this ('/Exception.cpp',222) 2. 23 voidDBStorageReplicatedMergeTree void DB::StorageReplicatedMergeTree::queueUpdatingTask(): Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. std::exception::capture() @ 0x000000001819c375 1 ('/Exception.cpp',222) 3. 8 CodeDBExceptionReceivedfromlocal Code: 242. DB::Exception: Received from localhost:9000. DB::Exception: Table is in readonly mode: replica_path=/tables/shard_1/data/replicas/read. Stack trace: 0. std::exception::capture() @ 0x000000001819c375 1. ./build_docker/./base/poco/Foundation/src/ ('/executeQuery.cpp',218) 4. 7 virtualboolDBReplicatedMergeMuta virtual bool DB::ReplicatedMergeMutateTaskBase::executeStep(): Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. std::exception::capture() @ 0x000000001819c ('/Exception.cpp',222) 5. 7 Exceptionwhileexecutingbackgroun Exception while executing background task {fd33bed5-ef36-47a0-9f37-3b8a81694378::all_3_35_1}: Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. std::excepti ('/Exception.cpp',222) 6. 6 CodeDBExceptionSyntaxerrorfailed Code: 62. DB::Exception: Syntax error: failed at position 2 ('error'): error here . Expected one of: Query, Query with output, EXPLAIN, EXPLAIN, SELECT query, possibly with UNION, list of union elements, SELECT query, subquery, possibly with UNION, SELECT ('/executeQuery.cpp',218) 7. 3 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() @ 0x000000001819c375 1. ./build_docker/./base/poco/Foundation/src/Ex ('/Exception.cpp',222) 8. 3 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 18 ('/LoggerWrapper.h',43) 9. 2 skippedconfiglatestconfig skipped config 1, latest config 18 ('/LoggerWrapper.h',43) 10. 1 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',43) 11. 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() @ 0x000000001819c375 1. ./build_docker/./base/poco/Foun ('/Exception.cpp',222) 12. 1 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',43) 13. 1 newconfigurationlogidxprevlogidx new configuration: log idx 99, prev log idx 18 peer 1, DC ID 0, localhost:9234, voting member, 1 my id: 1, leader: 1, term: 3 ('/LoggerWrapper.h',43) 14. 1 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',43) 15. 1 detectaconfigurationchangethatis detect a configuration change that is not committed yet at index 1 ('/LoggerWrapper.h',43) 16. 1 statemachinecommitindexprecommit state machine commit index 0, precommit index 98, last log index 98 ('/LoggerWrapper.h',43) 17. 1 Forkedachildprocesstowatch Forked a child process to watch ('',0) 18. 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() @ 0x000000001819c375 1. ./build_docker/./base/poco/Foundation/src/Exception.cpp:28: Poco: ('/Exception.cpp',222) 19. 1 INITRAFTSERVERcommitindextermele === INIT RAFT SERVER === commit index 0 term 2 election timer allowed log store start 1, end 98 config log idx 18, prev log idx 1 -- ASYNC REPLICATION -- ('/LoggerWrapper.h',43) 20. 1 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 21. 1 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1 my id: 1, voting_member num peers: 0 ('/LoggerWrapper.h',43) 22. 1 startingup starting up ('',0) 23. 1 newelectiontimeoutrange new election timeout range: 0 - 0 ('/LoggerWrapper.h',43) 24. 1 PRIORITYdecaytargetmine [PRIORITY] decay, target 1 -> 1, mine 1 ('/LoggerWrapper.h',43) 25. 1 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 99 ('/LoggerWrapper.h',43) 26. 1 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',43) 27. 1 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 28. 1 newconfiglogidxprevlogidxcurconf new config log idx 99, prev log idx 18, cur config log idx 18, prev log idx 1 ('/LoggerWrapper.h',43) 29. 1 ELECTIONTIMEOUTcurrentrolefollow [ELECTION TIMEOUT] current role: follower, log last term 2, state term 2, target p 1, my p 1, hb dead, pre-vote NOT done ('/LoggerWrapper.h',43) 30. 1 VOTEINITmyidmyrolecandidateterml [VOTE INIT] my id 1, my role candidate, term 3, log idx 98, log term 2, priority (target 1 / mine 1) ('/LoggerWrapper.h',43) Top messages not matching their format strings: message_format_string count() any_message 1. {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 51 /var/lib/clickhouse/disks/s3/store/d01/d011c5cc-a365-4929-a82a-dc3afa8d4f98/tmp_merge_202407_1_31_6/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 1 similar messages) 2. 31 Forked a child process to watch 3. Query {} to stage {}{} 1 Query SELECT 'token-transfer-0x758f1bbabb160683e1c80ed52dcd24a32b599d40edf1cec91b5f1199c0e392a2-56' AS `'token-transfer-0x758f1bbabb160683e1c80ed52dcd24a32b599d40edf1cec91b5f1199c0e392a2-56'`, _CAST('Ӈ���Jl����X��X̊�Y', 'FixedString(20)') AS `hex2bytes('0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459')`, 3e21 AS `3e21`, '2024-01-02 16:54:59' AS `'2024-01-02 16:54:59'`, 'abc' AS `'abc'` FROM system.one AS __table1 to stage Complete 4. Query {} from stage {} to stage {}{} 1 Query SELECT 'token-transfer-0x758f1bbabb160683e1c80ed52dcd24a32b599d40edf1cec91b5f1199c0e392a2-56' AS `'token-transfer-0x758f1bbabb160683e1c80ed52dcd24a32b599d40edf1cec91b5f1199c0e392a2-56'`, _CAST('Ӈ���Jl����X��X̊�Y', 'FixedString(20)') AS `hex2bytes('0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459')`, 3e21 AS `3e21`, '2024-01-02 16:54:59' AS `'2024-01-02 16:54:59'`, 'abc' AS `'abc'` FROM system.one AS __table1 from stage FetchColumns to stage Complete Top short messages: c message_format_string substr(any(message), 1, 120) min_length_without_exception_boilerplate 1. 7 {} ThreadFuzzer is enabled. Application will run slowly and unstable. 27 2. 3 Creating {}: {} Creating table test_l8ixlsg1.tp_1: CREATE TABLE IF NOT EXISTS test_l8ixlsg1.tp_1 UUID '665bd19e-4755-4a46-94e7-8ddcad0ff 149 3. 2 {}:{}: '{}' src/Processors/Transforms/MergeJoinTransform.cpp:836: ' UInt32(size = 1) UInt32(size = 1) UInt32(size = 1)' 81 4. 2 Database {} does not exist Code: 81. DB::Exception: Database kek does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always 28 5. 1 Froze {} parts Froze 1 parts -13 6. 1 Found {} on {} Found changelog_1_100000.bin on LocalLogDisk 18 Top messages by level: (0.005308674852898583,'Database {} does not exist. Maybe you meant {}?') Error (0.000042764865164324,'Client has gone away.') Warning (0.05181352186159346,'Setting download as failed: {}') Information (0.10534735761729722,'Key {} is removed from metadata') Debug (0.043157524380832785,'Bypassing cache because file segment state is `PARTIALLY_DOWNLOADED_NO_CONTINUATION` and downloaded part already used') Trace 2024-07-22 11:49:42,538 Stress test finished + echo -e 'Test script exit code\tOK\t\N\t' + rg -Fa 'No queries hung' /test_output/test_results.tsv + grep -Fa OK No queries hung OK \N + stop_server + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=2728 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2728. The process with pid = 2728 is running. Sent terminate signal to process with pid 2728. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2728. The process with pid = 2728 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2728. The process with pid = 2728 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2728. The process with pid = 2728 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2728. The process with pid = 2728 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2728. The process with pid = 2728 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2728. The process with pid = 2728 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2728. The process with pid = 2728 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2728. The process with pid = 2728 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 - - [22/Jul/2024:09:49:50 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [22/Jul/2024:09:49:50 +0000] "PUT /devstoreaccount1/cont/akawfcbvnihntzrsxrrdsikxoagaohgd?blockid=jpwnqkhbkhzfilpnjoqlvszddnjdzwfxnmnedehmldhqzlwbbeasxrxvrncfwhrq&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:09:49:50 +0000] "PUT /devstoreaccount1/cont/akawfcbvnihntzrsxrrdsikxoagaohgd?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:09:49:50 +0000] "GET /devstoreaccount1/cont/akawfcbvnihntzrsxrrdsikxoagaohgd HTTP/1.1" 206 4 127.0.0.1 - - [22/Jul/2024:09:49:50 +0000] "GET /devstoreaccount1/cont/akawfcbvnihntzrsxrrdsikxoagaohgd HTTP/1.1" 206 2 127.0.0.1 - - [22/Jul/2024:09:49:50 +0000] "DELETE /devstoreaccount1/cont/akawfcbvnihntzrsxrrdsikxoagaohgd 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 ' + ts '%Y-%m-%d %H:%M:%S' ++ cat /var/run/clickhouse-server/clickhouse-server.pid + sleep 5 + gdb -batch -command script.gdb -p 21935 + 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=21935 + 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 = 21935. The process with pid = 21935 is running. Sent terminate signal to process with pid 21935. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 21935. The process with pid = 21935 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 21935. The process with pid = 21935 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 21935. The process with pid = 21935 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + '[' -f /var/log/clickhouse-server/clickhouse-server.log ']' + '[' -f /var/log/clickhouse-server/stderr.log ']' + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.final.log + check_logs_for_critical_errors + sed -n '/WARNING:.*anitizer/,/^$/p' /var/log/clickhouse-server/stderr.log + rg -Fav -e 'ASan doesn'\''t fully support makecontext/swapcontext functions' -e DB::Exception /test_output/tmp + echo -e 'No sanitizer asserts\tOK\t\N\t' + rm -f /test_output/tmp + rg -Fa ' Application: Child process was terminated by signal 9' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No OOM messages in clickhouse-server.log\tOK\t\N\t' + rg -Fa 'Code: 49. DB::Exception: ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No logical errors\tOK\t\N\t' + '[' -s /test_output/logical_errors.txt ']' + rm /test_output/logical_errors.txt + rg --text 'Code: 499.*The specified key does not exist' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + grep -v a.myext + echo -e 'No lost s3 keys\tOK\t\N\t' + rg -Fa 'it is lost forever' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + grep SharedMergeTreePartCheckThread + echo -e 'No SharedMergeTree lost forever in clickhouse-server.log\tOK\t\N\t' + '[' -s /test_output/no_such_key_errors.txt ']' + rm /test_output/no_such_key_errors.txt + rg -Fa '########################################' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'Not crashed\tOK\t\N\t' + rg -Fa ' ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No fatal messages in clickhouse-server.log\tOK\t\N\t' + '[' -s /test_output/fatal_messages.txt ']' + rm /test_output/fatal_messages.txt + rg -Faz '########################################' /test_output/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_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/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 - - [22/Jul/2024:09:50:45 +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_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/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 - - [22/Jul/2024:09:50:48 +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 ']' + echo -e 'success\tNo errors found' + rg 'OOM in dmesg|Signal 9' /test_output/check_status.tsv + collect_core_dumps + find . -type f -maxdepth 1 -name 'core.*' + read -r core