+ ln -s /usr/share/clickhouse-test/ci/stress.py /usr/bin/stress + ln -s /usr/share/clickhouse-test/clickhouse-test /usr/bin/clickhouse-test + source /attach_gdb.lib ++ source /utils.lib + source /stress_tests.lib ++ sysctl kernel.core_pattern=core.%e.%p-%P kernel.core_pattern = core.%e.%p-%P ++ OK='\tOK\t\N\t' ++ FAIL='\tFAIL\t\N\t' ++ FAILURE_CONTEXT_LINES=100 ++ FAILURE_CONTEXT_MAX_LINE_WIDTH=300 + install_packages package_folder + dpkg -i package_folder/clickhouse-common-static_24.3.5.48.altinityfips+tsan_amd64.deb Selecting previously unselected package clickhouse-common-static. (Reading database ... 49227 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static_24.3.5.48.altinityfips+tsan_amd64.deb ... Unpacking clickhouse-common-static (24.3.5.48.altinityfips+tsan) ... Setting up clickhouse-common-static (24.3.5.48.altinityfips+tsan) ... + dpkg -i package_folder/clickhouse-common-static-dbg_24.3.5.48.altinityfips+tsan_amd64.deb Selecting previously unselected package clickhouse-common-static-dbg. (Reading database ... 49256 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static-dbg_24.3.5.48.altinityfips+tsan_amd64.deb ... Unpacking clickhouse-common-static-dbg (24.3.5.48.altinityfips+tsan) ... Setting up clickhouse-common-static-dbg (24.3.5.48.altinityfips+tsan) ... + dpkg -i package_folder/clickhouse-server_24.3.5.48.altinityfips+tsan_amd64.deb Selecting previously unselected package clickhouse-server. (Reading database ... 49265 files and directories currently installed.) Preparing to unpack .../clickhouse-server_24.3.5.48.altinityfips+tsan_amd64.deb ... Unpacking clickhouse-server (24.3.5.48.altinityfips+tsan) ... Setting up clickhouse-server (24.3.5.48.altinityfips+tsan) ... ClickHouse binary is already located at /usr/bin/clickhouse Symlink /usr/bin/clickhouse-server already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-server to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-client to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-local to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-benchmark to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-obfuscator to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-git-import to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-compressor to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-format to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-extract-from-config already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-extract-from-config to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-keeper already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-keeper-converter already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper-converter to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-disks to /usr/bin/clickhouse. Creating symlink /usr/bin/ch to /usr/bin/clickhouse. Creating symlink /usr/bin/chl to /usr/bin/clickhouse. Creating symlink /usr/bin/chc to /usr/bin/clickhouse. Creating clickhouse group if it does not exist. groupadd -r clickhouse Creating clickhouse user if it does not exist. useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse clickhouse Will set ulimits for clickhouse user in /etc/security/limits.d/clickhouse.conf. Creating config directory /etc/clickhouse-server/config.d that is used for tweaks of main server configuration. Creating config directory /etc/clickhouse-server/users.d that is used for tweaks of users configuration. Config file /etc/clickhouse-server/config.xml already exists, will keep it and extract path info from it. /etc/clickhouse-server/config.xml has /var/lib/clickhouse/ as data path. /etc/clickhouse-server/config.xml has /var/log/clickhouse-server/ as log path. Users config file /etc/clickhouse-server/users.xml already exists, will keep it and extract users info from it. Log directory /var/log/clickhouse-server/ already exists. Creating data directory /var/lib/clickhouse/. Creating pid directory /var/run/clickhouse-server. chown -R clickhouse:clickhouse '/var/log/clickhouse-server/' chown -R clickhouse:clickhouse '/var/run/clickhouse-server' chown clickhouse:clickhouse '/var/lib/clickhouse/' groupadd -r clickhouse-bridge useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse-bridge clickhouse-bridge chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-odbc-bridge' chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-library-bridge' Password for the default user is an empty string. See /etc/clickhouse-server/users.xml and /etc/clickhouse-server/users.d to change it. Setting capabilities for clickhouse binary. This is optional. chown -R clickhouse:clickhouse '/etc/clickhouse-server' ClickHouse has been successfully installed. Start clickhouse-server with: sudo clickhouse start Start clickhouse-client with: clickhouse-client + dpkg -i package_folder/clickhouse-client_24.3.5.48.altinityfips+tsan_amd64.deb Selecting previously unselected package clickhouse-client. (Reading database ... 49282 files and directories currently installed.) Preparing to unpack .../clickhouse-client_24.3.5.48.altinityfips+tsan_amd64.deb ... Unpacking clickhouse-client (24.3.5.48.altinityfips+tsan) ... Setting up clickhouse-client (24.3.5.48.altinityfips+tsan) ... + export THREAD_FUZZER_CPU_TIME_PERIOD_US=1000 + THREAD_FUZZER_CPU_TIME_PERIOD_US=1000 + export THREAD_FUZZER_SLEEP_PROBABILITY=0.1 + THREAD_FUZZER_SLEEP_PROBABILITY=0.1 + export THREAD_FUZZER_SLEEP_TIME_US_MAX=100000 + THREAD_FUZZER_SLEEP_TIME_US_MAX=100000 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01 + THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01 + export THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01 + THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01 + export ZOOKEEPER_FAULT_INJECTION=1 + ZOOKEEPER_FAULT_INJECTION=1 + configure + export USE_DATABASE_ORDINARY=1 + USE_DATABASE_ORDINARY=1 + export EXPORT_S3_STORAGE_POLICIES=1 + EXPORT_S3_STORAGE_POLICIES=1 + /usr/share/clickhouse-test/config/install.sh + DEST_SERVER_PATH=/etc/clickhouse-server + DEST_CLIENT_PATH=/etc/clickhouse-client +++ dirname /usr/share/clickhouse-test/config/install.sh ++ cd /usr/share/clickhouse-test/config ++ pwd -P + SRC_PATH=/usr/share/clickhouse-test/config + echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server' + mkdir -p /etc/clickhouse-server/config.d/ Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + mkdir -p /etc/clickhouse-server/users.d/ + mkdir -p /etc/clickhouse-client + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/reverse_dns_query_function.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/block_number.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/ + '[' /etc/clickhouse-server = /etc/clickhouse-server ']' + ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/ + ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + rm -f /etc/clickhouse-server/config.d/zookeeper.xml + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/ + value=1 + sed --follow-symlinks -i 's|[01]|1|' /etc/clickhouse-server/config.d/keeper_port.xml + value=55209984 + sed --follow-symlinks -i 's|[[:digit:]]\+|55209984|' /etc/clickhouse-server/config.d/keeper_port.xml + value=52330496 + sed --follow-symlinks -i 's|[[:digit:]]\+|52330496|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ARM=aarch64 ++ uname -m + OS=x86_64 + [[ -n 1 ]] + echo x86_64 x86_64 Adding azure configuration + [[ '' -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=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value check_not_exists keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value create_if_not_exists keeper_port + value=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=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' Setting max_server_memory_usage_to_ram_ratio to 0.5 + cat Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G + local max_users_mem + max_users_mem=9856955596 + echo 'Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G' + cat + cat + ./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 + ./minio server --address :11111 ./minio_data + params=('--silent' '--verbose') + local params + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 0 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=1 + curl --silent --verbose http://localhost:11111 + grep AccessDenied 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 trying to connect to minio + [[ 3 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + 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 + [[ 5 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=6 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 6 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=7 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 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 + [[ 9 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=10 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 10 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio API: http://172.17.0.2:11111 http://127.0.0.1:11111 Console: http://172.17.0.2:38923 http://127.0.0.1:38923 Documentation: https://docs.min.io WARNING: Console endpoint is listening on a dynamic port (38923), please use --console-address ":PORT" to choose a static port. + counter=11 + curl --silent --verbose http://localhost:11111 + grep AccessDenied AccessDeniedAccess Denied./17F0CACE28850044dc931400-1319-4bc1-b5f2-122a5b8e7087 + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 301 root 10u IPv6 43789 0t0 TCP *:11111 (LISTEN) + sleep 5 + setup_minio stateless + local test_type=stateless + ./mc alias set clickminio http://localhost:11111 clickhouse clickhouse Added `clickminio` successfully. + ./mc admin user add clickminio test testtest Added user `test` successfully. + ./mc admin policy set clickminio readwrite user=test Policy `readwrite` is set on user `test` + ./mc mb clickminio/test Bucket created successfully `clickminio/test`. + '[' stateless = stateless ']' + ./mc policy set public clickminio/test Access permission for `clickminio/test` is set to `public` + upload_data 0_stateless /usr/share/clickhouse-test + local query_dir=0_stateless + local test_path=/usr/share/clickhouse-test + local data_path=/usr/share/clickhouse-test/queries/0_stateless/data_minio ++ ls /usr/share/clickhouse-test/queries/0_stateless/data_minio + for file in $(ls "${data_path}") + echo 02366_data.jsonl + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl clickminio/test/02366_data.jsonl 02366_data.jsonl `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl` -> `clickminio/test/02366_data.jsonl` Total: 0 B, Transferred: 0 B, Speed: 0 B/s + for file in $(ls "${data_path}") + echo 02731.arrow + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow clickminio/test/02731.arrow 02731.arrow `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow` -> `clickminio/test/02731.arrow` Total: 0 B, Transferred: 3.82 MiB, Speed: 123.42 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: 95.81 MiB/s + 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 02876.parquet `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02876.parquet` -> `clickminio/test/02876.parquet` Total: 0 B, Transferred: 293 B, Speed: 46.79 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: 2.55 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: 4.35 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: 5.00 KiB/s + for file in $(ls "${data_path}") + echo tsv_with_header.tsv 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: 6.68 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 127.0.0.1 - - [31/Aug/2024:10:54:13 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:10:54:13 +0000] "PUT /devstoreaccount1/cont/qgzedmjbqbtuywzwfyetrdisnobsnlfs?blockid=gvxvhdfcqseevesdqdkxpmhgpcvvssforghkfejinyzobvbmeijkrptxunqrcdho&comp=block HTTP/1.1" 201 - + counter=4 + clickhouse-client --query 'SELECT 1' 127.0.0.1 - - [31/Aug/2024:10:54:13 +0000] "PUT /devstoreaccount1/cont/qgzedmjbqbtuywzwfyetrdisnobsnlfs?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:10:54:13 +0000] "GET /devstoreaccount1/cont/qgzedmjbqbtuywzwfyetrdisnobsnlfs HTTP/1.1" 206 4 127.0.0.1 - - [31/Aug/2024:10:54:13 +0000] "GET /devstoreaccount1/cont/qgzedmjbqbtuywzwfyetrdisnobsnlfs HTTP/1.1" 206 2 127.0.0.1 - - [31/Aug/2024:10:54:13 +0000] "DELETE /devstoreaccount1/cont/qgzedmjbqbtuywzwfyetrdisnobsnlfs HTTP/1.1" 202 - 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 589 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + setup_logs_replication + set +x File /tmp/export-logs-config.sh does not exist, do not setup + clickhouse-client --query 'CREATE DATABASE datasets' + clickhouse-client --multiquery + clickhouse-client --query 'SHOW TABLES FROM datasets' hits_v1 visits_v1 + clickhouse-client --query 'CREATE DATABASE IF NOT EXISTS test' + stop_server + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=589 + 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 = 589. The process with pid = 589 is running. Sent terminate signal to process with pid 589. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 589. The process with pid = 589 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 589. The process with pid = 589 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 589. The process with pid = 589 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 589. The process with pid = 589 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 589. The process with pid = 589 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.initial.log + cache_policy= + '[' 0 -eq 1 ']' + cache_policy=LRU Using cache policy: LRU + echo 'Using cache policy: LRU' + '[' LRU = SLRU ']' + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' 127.0.0.1 - - [31/Aug/2024:10:55:19 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [31/Aug/2024:10:55:19 +0000] "PUT /devstoreaccount1/cont/clfyfuawbcvunguvdncqbxujtlbrexsj?blockid=xdpvvlxpqqkobxuhsuotzmkieyeyuaoqfekjwifnevkdjxffcavembmdyxekqesg&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:10:55:19 +0000] "PUT /devstoreaccount1/cont/clfyfuawbcvunguvdncqbxujtlbrexsj?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:10:55:19 +0000] "GET /devstoreaccount1/cont/clfyfuawbcvunguvdncqbxujtlbrexsj HTTP/1.1" 206 4 127.0.0.1 - - [31/Aug/2024:10:55:19 +0000] "GET /devstoreaccount1/cont/clfyfuawbcvunguvdncqbxujtlbrexsj HTTP/1.1" 206 2 127.0.0.1 - - [31/Aug/2024:10:55:19 +0000] "DELETE /devstoreaccount1/cont/clfyfuawbcvunguvdncqbxujtlbrexsj HTTP/1.1" 202 - 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' 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' 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 1423 + 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=1423 + 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 = 1423. The process with pid = 1423 is running. Sent terminate signal to process with pid 1423. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1423. The process with pid = 1423 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1423. The process with pid = 1423 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1423. The process with pid = 1423 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1423. The process with pid = 1423 is running. Waiting for server to stop Found pid = 1423 in the list of running processes. The process with pid = 1423 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=19445760 + sed --follow-symlinks -i 's|[[:digit:]]\+|19445760|' /etc/clickhouse-server/config.d/keeper_port.xml + value=57569280 + sed --follow-symlinks -i 's|[[:digit:]]\+|57569280|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + object_key_types_options=("generate-suffix" "generate-full-key" "generate-template-key") + object_key_type=generate-suffix + [[ -n 1 ]] + [[ 1 -eq 1 ]] + object_key_type=generate-template-key + case $object_key_type in + ln -sf /usr/share/clickhouse-test/config/config.d/storage_metadata_with_full_object_key.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/s3_storage_policy_with_template_object_key.xml /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + ARM=aarch64 ++ uname -m + OS=x86_64 x86_64 Adding azure configuration + [[ -n 1 ]] + echo x86_64 + [[ '' -eq 1 ]] + [[ x86_64 == \a\a\r\c\h\6\4 ]] + echo 'Adding azure configuration' + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|100000|10000|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value filtered_list keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value multi_read keeper_port + value=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value check_not_exists keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value create_if_not_exists keeper_port + value=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value use_compression zookeeper_fault_injection + value=0 + sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + randomize_config_boolean_value allow_experimental_block_number_column block_number + value=1 + sudo cat /etc/clickhouse-server/config.d/block_number.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml + echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\''' + export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + sudo chown root: /var/lib/clickhouse + echo '1' + local total_mem ++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo + total_mem=32086444 + total_mem=32856518656 + max_server_memory_usage_to_ram_ratio=0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat Setting max_server_memory_usage_to_ram_ratio to 0.5 + local max_users_mem + max_users_mem=9856955596 Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G + echo 'Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G' + cat + cat + sudo cat /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sed 's|
s3
|
s3
default|' + mv /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml.tmp /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo cat /etc/clickhouse-server/config.d/logger_trace.xml + sed 's|trace|test|' + mv /etc/clickhouse-server/config.d/logger_trace.xml.tmp /etc/clickhouse-server/config.d/logger_trace.xml + '[' LRU = SLRU ']' ++ date +%-d + '[' 1 -eq 1 ']' + sudo echo 'true' + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' 127.0.0.1 - - [31/Aug/2024:11:25:42 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [31/Aug/2024:11:25:42 +0000] "PUT /devstoreaccount1/cont/tjcldpxzfwrstocdklmkhgnkjhzbwavt?blockid=jijaxvfahbkthetfjjlgncthgnjpjbztaelgpeylkmwzwzpnnqvgzlwzhecnpyyn&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:11:25:42 +0000] "PUT /devstoreaccount1/cont/tjcldpxzfwrstocdklmkhgnkjhzbwavt?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:11:25:42 +0000] "GET /devstoreaccount1/cont/tjcldpxzfwrstocdklmkhgnkjhzbwavt HTTP/1.1" 206 4 127.0.0.1 - - [31/Aug/2024:11:25:42 +0000] "GET /devstoreaccount1/cont/tjcldpxzfwrstocdklmkhgnkjhzbwavt HTTP/1.1" 206 2 127.0.0.1 - - [31/Aug/2024:11:25:42 +0000] "DELETE /devstoreaccount1/cont/tjcldpxzfwrstocdklmkhgnkjhzbwavt HTTP/1.1" 202 - 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' 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 2777 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + stress --hung-check --drop-databases --output-folder test_output --skip-func-tests '' --global-time-limit 1200 2024-08-31 13:26:34,107 Run func tests '/usr/bin/clickhouse-test --client-option optimize_trivial_approximate_count_query=1 --global_time_limit=1200 ' 2024-08-31 13:26:34,608 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_1 --client-option join_use_nulls=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 http_make_head_request=0 --global_time_limit=1200 ' 2024-08-31 13:26:35,109 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-08-31 13:26:35,610 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-08-31 13:26:36,112 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 ' 2024-08-31 13:26:36,613 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' use_query_cache=1 group_by_use_nulls=1 http_make_head_request=0 --global_time_limit=1200 ' 2024-08-31 13:26:37,114 Run func tests '/usr/bin/clickhouse-test --order=random --client-option memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 http_make_head_request=0 --global_time_limit=1200 ' 2024-08-31 13:26:37,615 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-08-31 13:26:38,116 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 http_make_head_request=1 --global_time_limit=1200 ' 2024-08-31 13:26:38,618 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_9 --client-option join_algorithm='auto' max_rows_in_join=1000 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-08-31 13:26:39,119 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 optimize_trivial_approximate_count_query=1 --global_time_limit=1200 ' 2024-08-31 13:26:39,620 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' 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=1 --global_time_limit=1200 ' 2024-08-31 13:26:40,121 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 --global_time_limit=1200 ' 2024-08-31 13:26:40,622 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_13 --client-option join_use_nulls=1 join_algorithm='partial_merge' group_by_use_nulls=1 http_make_head_request=0 --global_time_limit=1200 ' 2024-08-31 13:26:41,123 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 optimize_trivial_approximate_count_query=1 --global_time_limit=1200 ' 2024-08-31 13:26:41,624 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-08-31 13:26:42,125 Will wait functests to finish 2024-08-31 13:26:42,125 Finished 3 from 16 processes 2024-08-31 13:26:47,130 Finished 3 from 16 processes 2024-08-31 13:26:52,134 Finished 3 from 16 processes 2024-08-31 13:26:57,138 Finished 3 from 16 processes 2024-08-31 13:27:02,142 Finished 3 from 16 processes 2024-08-31 13:27:07,146 Finished 3 from 16 processes 2024-08-31 13:27:12,150 Finished 3 from 16 processes 2024-08-31 13:27:17,154 Finished 3 from 16 processes 2024-08-31 13:27:22,158 Finished 3 from 16 processes 2024-08-31 13:27:27,159 Finished 3 from 16 processes 2024-08-31 13:27:32,162 Finished 3 from 16 processes 2024-08-31 13:27:37,166 Finished 3 from 16 processes 2024-08-31 13:27:42,171 Finished 3 from 16 processes 2024-08-31 13:27:47,176 Finished 3 from 16 processes 2024-08-31 13:27:52,178 Finished 3 from 16 processes 2024-08-31 13:27:57,182 Finished 3 from 16 processes 2024-08-31 13:28:02,186 Finished 3 from 16 processes 2024-08-31 13:28:07,190 Finished 3 from 16 processes 2024-08-31 13:28:12,195 Finished 3 from 16 processes 2024-08-31 13:28:17,198 Finished 3 from 16 processes 2024-08-31 13:28:22,202 Finished 3 from 16 processes 2024-08-31 13:28:27,206 Finished 3 from 16 processes 2024-08-31 13:28:32,210 Finished 3 from 16 processes 2024-08-31 13:28:37,214 Finished 3 from 16 processes 2024-08-31 13:28:42,218 Finished 3 from 16 processes 2024-08-31 13:28:47,222 Finished 3 from 16 processes 2024-08-31 13:28:52,226 Finished 3 from 16 processes 2024-08-31 13:28:57,230 Finished 3 from 16 processes 2024-08-31 13:29:02,234 Finished 3 from 16 processes 2024-08-31 13:29:07,238 Finished 3 from 16 processes 2024-08-31 13:29:12,242 Finished 3 from 16 processes 2024-08-31 13:29:17,247 Finished 3 from 16 processes 2024-08-31 13:29:22,250 Finished 3 from 16 processes 2024-08-31 13:29:27,255 Finished 3 from 16 processes 2024-08-31 13:29:32,258 Finished 3 from 16 processes 2024-08-31 13:29:37,262 Finished 3 from 16 processes 2024-08-31 13:29:42,266 Finished 3 from 16 processes 2024-08-31 13:29:47,271 Finished 3 from 16 processes 2024-08-31 13:29:52,274 Finished 3 from 16 processes 2024-08-31 13:29:57,278 Finished 3 from 16 processes 2024-08-31 13:30:02,282 Finished 3 from 16 processes 2024-08-31 13:30:07,286 Finished 3 from 16 processes 2024-08-31 13:30:12,290 Finished 3 from 16 processes 2024-08-31 13:30:17,294 Finished 3 from 16 processes 2024-08-31 13:30:22,298 Finished 3 from 16 processes 2024-08-31 13:30:27,302 Finished 3 from 16 processes 2024-08-31 13:30:32,305 Finished 3 from 16 processes 2024-08-31 13:30:37,310 Finished 3 from 16 processes 2024-08-31 13:30:42,314 Finished 3 from 16 processes 2024-08-31 13:30:47,316 Finished 3 from 16 processes 2024-08-31 13:30:52,321 Finished 3 from 16 processes 2024-08-31 13:30:57,326 Finished 3 from 16 processes 2024-08-31 13:31:02,330 Finished 3 from 16 processes 2024-08-31 13:31:07,335 Finished 3 from 16 processes 2024-08-31 13:31:12,339 Finished 3 from 16 processes 2024-08-31 13:31:17,342 Finished 3 from 16 processes 2024-08-31 13:31:22,346 Finished 3 from 16 processes 2024-08-31 13:31:27,350 Finished 3 from 16 processes 2024-08-31 13:31:32,354 Finished 3 from 16 processes 2024-08-31 13:31:37,358 Finished 3 from 16 processes 2024-08-31 13:31:42,362 Finished 3 from 16 processes 2024-08-31 13:31:47,366 Finished 3 from 16 processes 2024-08-31 13:31:52,370 Finished 3 from 16 processes 2024-08-31 13:31:57,374 Finished 3 from 16 processes 2024-08-31 13:32:02,378 Finished 3 from 16 processes 2024-08-31 13:32:07,382 Finished 3 from 16 processes 2024-08-31 13:32:12,387 Finished 3 from 16 processes 2024-08-31 13:32:17,390 Finished 3 from 16 processes 2024-08-31 13:32:22,394 Finished 3 from 16 processes 2024-08-31 13:32:27,398 Finished 3 from 16 processes 2024-08-31 13:32:32,402 Finished 3 from 16 processes 2024-08-31 13:32:37,406 Finished 3 from 16 processes 2024-08-31 13:32:42,408 Finished 3 from 16 processes 2024-08-31 13:32:47,410 Finished 3 from 16 processes 2024-08-31 13:32:52,414 Finished 3 from 16 processes 2024-08-31 13:32:57,418 Finished 3 from 16 processes 2024-08-31 13:33:02,422 Finished 3 from 16 processes 2024-08-31 13:33:07,422 Finished 3 from 16 processes 2024-08-31 13:33:12,426 Finished 3 from 16 processes 2024-08-31 13:33:17,430 Finished 3 from 16 processes 2024-08-31 13:33:22,434 Finished 3 from 16 processes 2024-08-31 13:33:27,442 Finished 3 from 16 processes 2024-08-31 13:33:32,446 Finished 3 from 16 processes 2024-08-31 13:33:37,450 Finished 3 from 16 processes 2024-08-31 13:33:42,454 Finished 3 from 16 processes 2024-08-31 13:33:47,458 Finished 3 from 16 processes 2024-08-31 13:33:52,462 Finished 3 from 16 processes 2024-08-31 13:33:57,466 Finished 3 from 16 processes 2024-08-31 13:34:02,470 Finished 3 from 16 processes 2024-08-31 13:34:07,475 Finished 3 from 16 processes 2024-08-31 13:34:12,478 Finished 3 from 16 processes 2024-08-31 13:34:17,482 Finished 3 from 16 processes 2024-08-31 13:34:22,486 Finished 3 from 16 processes 2024-08-31 13:34:27,490 Finished 3 from 16 processes 2024-08-31 13:34:32,494 Finished 3 from 16 processes 2024-08-31 13:34:37,498 Finished 3 from 16 processes 2024-08-31 13:34:42,502 Finished 3 from 16 processes 2024-08-31 13:34:47,506 Finished 3 from 16 processes 2024-08-31 13:34:52,510 Finished 3 from 16 processes 2024-08-31 13:34:57,514 Finished 3 from 16 processes 2024-08-31 13:35:02,518 Finished 3 from 16 processes 2024-08-31 13:35:07,522 Finished 3 from 16 processes 2024-08-31 13:35:12,526 Finished 3 from 16 processes 2024-08-31 13:35:17,530 Finished 3 from 16 processes 2024-08-31 13:35:22,534 Finished 3 from 16 processes 2024-08-31 13:35:27,538 Finished 3 from 16 processes 2024-08-31 13:35:32,542 Finished 3 from 16 processes 2024-08-31 13:35:37,547 Finished 3 from 16 processes 2024-08-31 13:35:42,551 Finished 3 from 16 processes 2024-08-31 13:35:47,555 Finished 3 from 16 processes 2024-08-31 13:35:52,558 Finished 3 from 16 processes 2024-08-31 13:35:57,563 Finished 3 from 16 processes 2024-08-31 13:36:02,566 Finished 3 from 16 processes 2024-08-31 13:36:07,570 Finished 3 from 16 processes 2024-08-31 13:36:12,574 Finished 3 from 16 processes 2024-08-31 13:36:17,578 Finished 3 from 16 processes 2024-08-31 13:36:22,582 Finished 3 from 16 processes 2024-08-31 13:36:27,586 Finished 3 from 16 processes 2024-08-31 13:36:32,590 Finished 3 from 16 processes 2024-08-31 13:36:37,594 Finished 3 from 16 processes 2024-08-31 13:36:42,598 Finished 3 from 16 processes 2024-08-31 13:36:47,602 Finished 3 from 16 processes 2024-08-31 13:36:52,606 Finished 3 from 16 processes 2024-08-31 13:36:57,610 Finished 3 from 16 processes 2024-08-31 13:37:02,610 Finished 3 from 16 processes 2024-08-31 13:37:07,614 Finished 3 from 16 processes 2024-08-31 13:37:12,618 Finished 3 from 16 processes 2024-08-31 13:37:17,622 Finished 3 from 16 processes 2024-08-31 13:37:22,626 Finished 3 from 16 processes 2024-08-31 13:37:27,631 Finished 3 from 16 processes 2024-08-31 13:37:32,634 Finished 3 from 16 processes 2024-08-31 13:37:37,638 Finished 3 from 16 processes 2024-08-31 13:37:42,642 Finished 3 from 16 processes 2024-08-31 13:37:47,646 Finished 3 from 16 processes 2024-08-31 13:37:52,650 Finished 3 from 16 processes 2024-08-31 13:37:57,654 Finished 3 from 16 processes 2024-08-31 13:38:02,658 Finished 3 from 16 processes 2024-08-31 13:38:07,662 Finished 3 from 16 processes 2024-08-31 13:38:12,666 Finished 3 from 16 processes 2024-08-31 13:38:17,670 Finished 3 from 16 processes 2024-08-31 13:38:22,674 Finished 3 from 16 processes 2024-08-31 13:38:27,678 Finished 3 from 16 processes 2024-08-31 13:38:32,682 Finished 3 from 16 processes 2024-08-31 13:38:37,686 Finished 3 from 16 processes 2024-08-31 13:38:42,690 Finished 3 from 16 processes 2024-08-31 13:38:47,694 Finished 3 from 16 processes 2024-08-31 13:38:52,698 Finished 3 from 16 processes 2024-08-31 13:38:57,702 Finished 3 from 16 processes 2024-08-31 13:39:02,706 Finished 3 from 16 processes 2024-08-31 13:39:07,710 Finished 3 from 16 processes 2024-08-31 13:39:12,714 Finished 3 from 16 processes 2024-08-31 13:39:17,718 Finished 3 from 16 processes 2024-08-31 13:39:22,722 Finished 3 from 16 processes 2024-08-31 13:39:27,727 Finished 3 from 16 processes 2024-08-31 13:39:32,731 Finished 3 from 16 processes 2024-08-31 13:39:37,734 Finished 3 from 16 processes 2024-08-31 13:39:42,738 Finished 3 from 16 processes 2024-08-31 13:39:47,742 Finished 3 from 16 processes 2024-08-31 13:39:52,746 Finished 3 from 16 processes 2024-08-31 13:39:57,750 Finished 3 from 16 processes 2024-08-31 13:40:02,754 Finished 3 from 16 processes 2024-08-31 13:40:07,758 Finished 3 from 16 processes 2024-08-31 13:40:12,762 Finished 3 from 16 processes 2024-08-31 13:40:17,766 Finished 3 from 16 processes 2024-08-31 13:40:22,770 Finished 3 from 16 processes 2024-08-31 13:40:27,774 Finished 3 from 16 processes 2024-08-31 13:40:32,778 Finished 3 from 16 processes 2024-08-31 13:40:37,783 Finished 3 from 16 processes 2024-08-31 13:40:42,786 Finished 3 from 16 processes 2024-08-31 13:40:47,790 Finished 3 from 16 processes 2024-08-31 13:40:52,794 Finished 3 from 16 processes 2024-08-31 13:40:57,798 Finished 3 from 16 processes 2024-08-31 13:41:02,802 Finished 3 from 16 processes 2024-08-31 13:41:07,806 Finished 3 from 16 processes 2024-08-31 13:41:12,810 Finished 3 from 16 processes 2024-08-31 13:41:17,814 Finished 3 from 16 processes 2024-08-31 13:41:22,818 Finished 3 from 16 processes 2024-08-31 13:41:27,822 Finished 3 from 16 processes 2024-08-31 13:41:32,826 Finished 3 from 16 processes 2024-08-31 13:41:37,830 Finished 3 from 16 processes 2024-08-31 13:41:42,834 Finished 3 from 16 processes 2024-08-31 13:41:47,839 Finished 3 from 16 processes 2024-08-31 13:41:52,842 Finished 3 from 16 processes 2024-08-31 13:41:57,846 Finished 3 from 16 processes 2024-08-31 13:42:02,850 Finished 3 from 16 processes 2024-08-31 13:42:07,851 Finished 3 from 16 processes 2024-08-31 13:42:12,854 Finished 3 from 16 processes 2024-08-31 13:42:17,858 Finished 3 from 16 processes 2024-08-31 13:42:22,862 Finished 3 from 16 processes 2024-08-31 13:42:27,866 Finished 3 from 16 processes 2024-08-31 13:42:32,870 Finished 3 from 16 processes 2024-08-31 13:42:37,874 Finished 3 from 16 processes 2024-08-31 13:42:42,879 Finished 3 from 16 processes 2024-08-31 13:42:47,882 Finished 3 from 16 processes 2024-08-31 13:42:52,886 Finished 3 from 16 processes 2024-08-31 13:42:57,890 Finished 3 from 16 processes 2024-08-31 13:43:02,894 Finished 3 from 16 processes 2024-08-31 13:43:07,898 Finished 3 from 16 processes 2024-08-31 13:43:12,903 Finished 3 from 16 processes 2024-08-31 13:43:17,906 Finished 3 from 16 processes 2024-08-31 13:43:22,910 Finished 3 from 16 processes 2024-08-31 13:43:27,914 Finished 3 from 16 processes 2024-08-31 13:43:32,918 Finished 3 from 16 processes 2024-08-31 13:43:37,926 Finished 3 from 16 processes 2024-08-31 13:43:42,931 Finished 3 from 16 processes 2024-08-31 13:43:47,934 Finished 3 from 16 processes 2024-08-31 13:43:52,938 Finished 3 from 16 processes 2024-08-31 13:43:57,943 Finished 3 from 16 processes 2024-08-31 13:44:02,946 Finished 3 from 16 processes 2024-08-31 13:44:07,950 Finished 3 from 16 processes 2024-08-31 13:44:12,954 Finished 3 from 16 processes 2024-08-31 13:44:17,958 Finished 3 from 16 processes 2024-08-31 13:44:22,962 Finished 3 from 16 processes 2024-08-31 13:44:27,966 Finished 3 from 16 processes 2024-08-31 13:44:32,970 Finished 3 from 16 processes 2024-08-31 13:44:37,974 Finished 3 from 16 processes 2024-08-31 13:44:42,978 Finished 3 from 16 processes 2024-08-31 13:44:47,982 Finished 3 from 16 processes 2024-08-31 13:44:52,986 Finished 3 from 16 processes 2024-08-31 13:44:57,990 Finished 3 from 16 processes 2024-08-31 13:45:02,994 Finished 3 from 16 processes 2024-08-31 13:45:08,001 Finished 3 from 16 processes 2024-08-31 13:45:13,006 Finished 4 from 16 processes 2024-08-31 13:45:18,010 Finished 4 from 16 processes 2024-08-31 13:45:23,014 Finished 4 from 16 processes 2024-08-31 13:45:28,018 Finished 4 from 16 processes 2024-08-31 13:45:33,022 Finished 4 from 16 processes 2024-08-31 13:45:38,026 Finished 4 from 16 processes 2024-08-31 13:45:43,030 Finished 4 from 16 processes 2024-08-31 13:45:48,034 Finished 4 from 16 processes 2024-08-31 13:45:53,039 Finished 4 from 16 processes 2024-08-31 13:45:58,042 Finished 4 from 16 processes 2024-08-31 13:46:03,046 Finished 4 from 16 processes 2024-08-31 13:46:08,051 Finished 4 from 16 processes 2024-08-31 13:46:13,054 Finished 4 from 16 processes 2024-08-31 13:46:18,058 Finished 4 from 16 processes 2024-08-31 13:46:23,062 Finished 4 from 16 processes 2024-08-31 13:46:28,066 Finished 4 from 16 processes 2024-08-31 13:46:33,070 Finished 4 from 16 processes 2024-08-31 13:46:38,074 Finished 5 from 16 processes 2024-08-31 13:46:43,078 Finished 5 from 16 processes 2024-08-31 13:46:48,082 Finished 6 from 16 processes 2024-08-31 13:46:53,084 Finished 8 from 16 processes 2024-08-31 13:46:58,086 Finished 9 from 16 processes 2024-08-31 13:47:03,090 Finished 9 from 16 processes 2024-08-31 13:47:08,095 Finished 10 from 16 processes 2024-08-31 13:47:13,098 Finished 10 from 16 processes 2024-08-31 13:47:18,103 Finished 11 from 16 processes 2024-08-31 13:47:23,106 Finished 11 from 16 processes 2024-08-31 13:47:28,110 Finished 11 from 16 processes 2024-08-31 13:47:33,114 Finished 11 from 16 processes 2024-08-31 13:47:38,118 Finished 11 from 16 processes 2024-08-31 13:47:43,122 Finished 12 from 16 processes 2024-08-31 13:47:48,126 Finished 12 from 16 processes 2024-08-31 13:47:53,130 Finished 12 from 16 processes 2024-08-31 13:47:58,135 Finished 12 from 16 processes 2024-08-31 13:48:03,138 Finished 12 from 16 processes 2024-08-31 13:48:08,142 Finished 13 from 16 processes 2024-08-31 13:48:13,146 Finished 13 from 16 processes 2024-08-31 13:48:18,147 Finished 13 from 16 processes 2024-08-31 13:48:23,150 Finished 13 from 16 processes 2024-08-31 13:48:28,154 Finished 13 from 16 processes 2024-08-31 13:48:33,158 Finished 14 from 16 processes 2024-08-31 13:48:38,162 Finished 14 from 16 processes 2024-08-31 13:48:43,167 Finished 14 from 16 processes 2024-08-31 13:48:48,170 Finished 14 from 16 processes 2024-08-31 13:48:53,174 Finished 14 from 16 processes 2024-08-31 13:48:58,178 Finished 14 from 16 processes 2024-08-31 13:49:03,182 Finished 14 from 16 processes 2024-08-31 13:49:08,186 Finished 14 from 16 processes 2024-08-31 13:49:13,190 Finished 14 from 16 processes 2024-08-31 13:49:18,194 Finished 15 from 16 processes 2024-08-31 13:49:23,199 Finished 15 from 16 processes 2024-08-31 13:49:28,204 Finished 15 from 16 processes 2024-08-31 13:49:33,206 Finished 15 from 16 processes 2024-08-31 13:49:38,211 All processes finished 2024-08-31 13:49:38,211 Compressing stress logs 2024-08-31 13:49:38,231 Logs compressed 2024-08-31 13:49:38,231 Will terminate gdb (if any) 2024-08-31 13:49:38,231 Running command: kill -TERM $(pidof gdb) 2024-08-31 13:49:38,239 Running command: timeout 50s tail --pid=$(pidof gdb) -f /dev/null || kill -9 $(pidof gdb) ||: Quit 2024-08-31 13:49:39,256 Running command: kill -CONT $(cat /var/run/clickhouse-server/clickhouse-server.pid) && clickhouse client -q 'SELECT 1 FORMAT Null' 2024-08-31 13:49:39,474 Running command: clickhouse client -q "SYSTEM STOP THREAD FUZZER" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-08-31 13:49:39,688 Running command: clickhouse client -q "SYSTEM START MERGES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-08-31 13:49:39,903 Running command: clickhouse client -q "SYSTEM START DISTRIBUTED SENDS" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-08-31 13:49:40,117 Running command: clickhouse client -q "SYSTEM START TTL MERGES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-08-31 13:49:40,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-08-31 13:49:40,546 Running command: clickhouse client -q "SYSTEM START FETCHES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-08-31 13:49:40,761 Running command: clickhouse client -q "SYSTEM START REPLICATED SENDS" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-08-31 13:49:40,976 Running command: clickhouse client -q "SYSTEM START REPLICATION QUEUES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-08-31 13:49:41,190 Running command: clickhouse client -q "SYSTEM DROP MARK CACHE" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-08-31 13:49:41,405 Running command: clickhouse client -q "KILL QUERY WHERE upper(query) LIKE 'WATCH %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-08-31 13:49:41,620 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'insert into tableB select %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-08-31 13:49:41,834 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'SELECT URL, uniq(SearchPhrase) AS u FROM test.hits GROUP BY URL ORDER BY u %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-08-31 13:49:41,998 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'SELECT (SELECT number FROM system.numbers WHERE number = 1000000000000)%'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-08-31 13:54:44,061 Checking if some queries hung Using queries from '/usr/share/clickhouse-test/queries' directory Connecting to ClickHouse server... OK Connected to server 24.3.5.48.altinityfips @ f030c602050d371934c7b7609b7a8228fb1c7779 HEAD Running 1 stateless tests (MainProcess). 00001_select_1: [ OK ] 1 tests passed. 0 tests skipped. 0.40 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. 69485 0.112 5.93 MiB 0.086 1 1135 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 2. 69372 0.112 2.04 MiB 0.03 1 1137 ['Trace'] 0 Aggregation method: {} 3. 63832 0.103 5.12 MiB 0.074 1 860 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 4. 42935 0.069 461.22 KiB 0.007 1 963 ['Trace'] 0 Aggregating 5. 15631 0.025 931.14 KiB 0.013 1 135 ['Debug'] 0.977 Key {} is removed from metadata 6. 14884 0.024 844.05 KiB 0.012 2 229 ['Trace'] 0.001 Access granted: {}{} 7. 14588 0.024 2.18 MiB 0.032 3 289 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 8. 14499 0.023 2.64 MiB 0.038 1 289 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 9. 13450 0.022 3.28 MiB 0.047 1 340 ['Trace'] 0.002 Query {} to stage {}{} 10. 13384 0.022 3.57 MiB 0.052 1 340 ['Trace'] 0.002 Query {} from stage {} to stage {}{} 11. 12692 0.021 731.28 KiB 0.01 1 889 ['Debug'] 0.039 Submitting key {} for removal 12. 10784 0.017 304.58 KiB 0.004 1 130 ['Debug'] 0 Processed in {} sec. 13. 9915 0.016 804.63 KiB 0.011 1 281 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 14. 9408 0.015 815.10 KiB 0.012 66 87 ['Trace'] 0 Reading {} ranges in{}order from part {}, approx. {} rows starting from {} 15. 8223 0.013 367.25 KiB 0.005 1 1 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 16. 7028 0.011 199.66 KiB 0.003 43 981 ['Trace'] 0 Found {} range in {} steps 17. 7028 0.011 212.10 KiB 0.003 43 981 ['Trace'] 0 Found (RIGHT) boundary mark: {} 18. 7028 0.011 205.16 KiB 0.003 43 981 ['Trace'] 0 Found (LEFT) boundary mark: {} 19. 7028 0.011 475.65 KiB 0.007 43 981 ['Trace'] 0 Running binary search on index range for part {} ({} marks) 20. 6554 0.011 748.85 KiB 0.011 200 899 ['Trace'] 0.056 Bypassing cache because file segment state is `PARTIALLY_DOWNLOADED_NO_CONTINUATION` and downloaded part already used 21. 6360 0.01 553.21 KiB 0.008 4 313 ['Debug'] 0.996 {} Authenticating user '{}' from {} 22. 6358 0.01 714.03 KiB 0.01 4 313 ['Debug'] 0.996 {} Authenticated with global context as user {} 23. 6334 0.01 556.70 KiB 0.008 4 313 ['Debug'] 0.996 {} Logout, user_id: {} 24. 6325 0.01 691.80 KiB 0.01 3 289 ['Debug'] 1 {} Creating session context with user_id: {} 25. 6146 0.01 914.49 KiB 0.013 1 494 ['Debug'] 0 Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.) 26. 6146 0.01 303.35 KiB 0.004 1 494 ['Trace'] 0 Merging partially aggregated blocks (bucket = {}). 27. 5334 0.009 236.08 KiB 0.003 1 141 ['Debug'] 0.116 Peak memory usage{}: {}. 28. 5046 0.008 497.96 KiB 0.007 1 89 ['Trace'] 0.064 PREWHERE condition was split into {} steps: {} 29. 4671 0.008 629.49 KiB 0.009 1 508 ['Information'] 0 Sorting and writing part of data into temporary file {} 30. 4403 0.007 755.69 KiB 0.011 1 428 ['Information'] 0 Done writing part of data into temporary file {}, compressed {}, uncompressed {} 31. 3927 0.006 464.96 KiB 0.007 269 324 ['Trace'] 0.553 Renaming temporary part {} to {} with tid {}. 32. 3915 0.006 703.22 KiB 0.01 3 261 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {} 33. 3915 0.006 7.18 MiB 0.104 2 261 ['Trace'] 1 Request URI: {} 34. 3728 0.006 177.93 KiB 0.003 1 308 ['Trace'] 0.539 filled checksums {} 35. 3720 0.006 257.98 KiB 0.004 266 607 ['Trace'] 0.689 Trying to reserve {} using storage policy from min volume index {} 36. 3588 0.006 73.58 KiB 0.001 2 261 ['Debug'] 0.045 Done processing query 37. 3542 0.006 1.07 MiB 0.016 1159 670 ['Information'] 0.044 Setting download as failed: {} 38. 3475 0.006 2.87 MiB 0.041 1 416 ['Debug'] 0.974 Objects with paths [{}] were removed from S3 39. 3256 0.005 73.13 KiB 0.001 1 797 ['Trace'] 0 Merging aggregated data 40. 3136 0.005 3.78 MiB 0.055 1 397 ['Debug'] 0.975 metadata and objects were removed for [{}], only metadata were removed for [{}]. 41. 2892 0.005 115.79 KiB 0.002 1 776 ['Trace'] 0 Converting aggregation data to two-level. 42. 2839 0.005 267.89 KiB 0.004 1 35 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 43. 2698 0.004 52.70 KiB 0.001 1 980 ['Trace'] 0 Aggregating in order 44. 2661 0.004 115.04 KiB 0.002 1 974 ['Debug'] 0 Aggregated. {} to {} rows (from {}) 45. 2577 0.004 85.61 KiB 0.001 1 130 ['Trace'] 1 TCP Request. Address: {} 46. 2577 0.004 240.12 KiB 0.003 1 130 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 47. 2432 0.004 86.77 KiB 0.001 213 139 ['Debug'] 0.009 Key condition: {} 48. 2362 0.004 274.99 KiB 0.004 210 139 ['Debug'] 0.009 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 49. 2361 0.004 62.25 KiB 0.001 1 127 ['Debug'] 1 Done processing connection. 50. 2317 0.004 312.25 KiB 0.004 1 408 ['Debug'] 0 Writing part of aggregation data into temporary file {} 51. 2316 0.004 569.36 KiB 0.008 1 407 ['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) 52. 2316 0.004 102.35 KiB 0.001 1 407 ['Debug'] 0 Max size of temporary block: {} rows, {}. 53. 2066 0.003 106.93 KiB 0.002 183 135 ['Trace'] 0.01 Spreading mark ranges among streams (default reading) 54. 2052 0.003 80.71 KiB 0.001 181 134 ['Debug'] 0.01 Reading approx. {} rows with {} streams 55. 1999 0.003 116.16 KiB 0.002 14 14 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 56. 1998 0.003 71.92 KiB 0.001 14 14 ['Trace'] 1 Flushed system log up to offset {} 57. 1938 0.003 225.79 KiB 0.003 1 17 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 58. 1802 0.003 57.60 KiB 0.001 58 124 ['Debug'] 0.011 MinMax index condition: {} 59. 1734 0.003 54.30 KiB 0.001 1 130 ['Debug'] 0.012 min_marks_for_concurrent_read={} 60. 1694 0.003 172.23 KiB 0.002 336 494 ['Trace'] 0.011 Predownload failed because of space limit. Will read from remote filesystem starting from offset: {} 61. 1619 0.003 129.48 KiB 0.002 1 666 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={} 62. 1590 0.003 130.22 KiB 0.002 545 484 ['Trace'] 0.058 No space left in cache to reserve {} bytes, will continue without cache download 63. 1576 0.003 195.35 KiB 0.003 1 2 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 64. 1529 0.002 110.80 KiB 0.002 1 119 ['Trace'] 0.014 The min valid primary key position for moving to the tail of PREWHERE is {} 65. 1519 0.002 117.19 KiB 0.002 1 218 ['Trace'] 0 Query span trace_id for opentelemetry log: {} 66. 1322 0.002 120.17 KiB 0.002 1 583 ['Debug'] 0 Merge sorted {} blocks, {} rows in {} sec., {} rows/sec., {}/sec 67. 1113 0.002 37.81 KiB 0.001 1 433 ['Debug'] 0.585 Spawn loader worker #{} in {} 68. 1113 0.002 25.85 KiB 0 1 560 ['Debug'] 1 Stop worker in {} 69. 1112 0.002 75.80 KiB 0.001 1 378 ['Debug'] 1 Finish load job '{}' with status {} 70. 1112 0.002 77.75 KiB 0.001 1 91 ['Debug'] 0.033 Schedule load job '{}' into {} 71. 1112 0.002 74.48 KiB 0.001 1 378 ['Debug'] 1 Execute load job '{}' in {} 72. 909 0.001 30.10 KiB 0 1 431 ['Debug'] 0.52 Change current priority: {} -> {} 73. 851 0.001 7.48 KiB 0 2 91 ['Trace'] 0.002 No tables 74. 810 0.001 135.60 KiB 0.002 1 2 ['Trace'] 1 Creating part at path {} 75. 795 0.001 33.55 KiB 0 1 453 ['Information'] 0 There are {} temporary sorted parts to merge 76. 763 0.001 59.00 KiB 0.001 1 160 ['Debug'] 0.507 Prioritize load job '{}': {} -> {} 77. 708 0.001 90.98 KiB 0.001 1 3 ['Debug'] 0 {}:{}: sampleColumns {} '{}' 78. 694 0.001 21.78 KiB 0 19 23 ['Debug'] 0 Requested flush up to offset {} 79. 604 0.001 76.48 KiB 0.001 260 200 ['Debug'] 0.964 Removing {} parts from filesystem (serially): Parts: [{}] 80. 599 0.001 117.34 KiB 0.002 1 318 ['Information'] 1 Removing metadata {} of dropped table {} 81. 599 0.001 44.46 KiB 0.001 1 78 ['Debug'] 0 Waiting for table {} to be finally dropped 82. 599 0.001 75.32 KiB 0.001 1 318 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {} 83. 585 0.001 148.53 KiB 0.002 1 11 ['Information'] 0.961 WriteBufferFromS3 is not finalized in destructor. The file might not be written to S3. {}. 84. 572 0.001 30.43 KiB 0 60 330 ['Debug'] 0.913 Selected {} parts from {} to {} 85. 569 0.001 32.84 KiB 0 2 17 ['Trace'] 0.949 Loading config file '{}'. 86. 544 0.001 18.57 KiB 0 1 35 ['Debug'] 0 Selected MergeAlgorithm: {} 87. 544 0.001 45.24 KiB 0.001 1 35 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {} 88. 537 0.001 70.37 KiB 0.001 1 35 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec. 89. 534 0.001 34.98 KiB 0 57 35 ['Trace'] 0 Merged {} parts: [{}, {}] -> {} 90. 492 0.001 63.18 KiB 0.001 48 58 ['Debug'] 0 Part: {}, sum_marks: {}, approx mark size: {}, prefetch_step_bytes: {}, prefetch_step_marks: {}, (ranges: {}) 91. 488 0.001 1.02 MiB 0.015 4 25 ['Error'] 0.939 Database {} does not exist. Maybe you meant {}? 92. 476 0.001 99.53 KiB 0.001 34 9 ['Information'] 1 {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 93. 441 0.001 36.02 KiB 0.001 416 91 ['Information'] 0.009 Metadata processed, database {} has {} tables and {} dictionaries in total. 94. 439 0.001 26.12 KiB 0 1 91 ['Information'] 0.005 Parsed metadata of {} tables in {} databases in {} sec 95. 438 0.001 46.63 KiB 0.001 3 229 ['Trace'] 1 Cannot execute alter metadata {} with version {} because another alter {} must be executed before 96. 434 0.001 33.06 KiB 0 3 89 ['Trace'] 0.938 Settings: readonly = {}, allow_ddl = {}, allow_introspection_functions = {} 97. 434 0.001 23.07 KiB 0 3 89 ['Trace'] 0.938 List of all grants: {} 98. 434 0.001 32.72 KiB 0 3 89 ['Trace'] 0.938 List of all grants including implicit: {} 99. 381 0.001 19.68 KiB 0 20 211 ['Trace'] 0.869 Finished loading {} part {} on disk {} 100. 381 0.001 17.08 KiB 0 20 211 ['Trace'] 0.869 Loading {} part {} from disk {} Top messages without format string (fmt::runtime): count pattern runtime_message line 1. 12 CodeDBExceptionReceivedfromDBExc Code: 241. DB::Exception: Received from 127.0.0.2:9000. DB::Exception: Memory tracker (for query): fault injected. Would use 29.73 MiB (attempt to allocate chunk of 1048639 bytes), maximum: 9.31 GiB: (while reading column FUniqID): (while reading from part ('/executeQuery.cpp',218) 2. 8 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. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, ('/Exception.cpp',222) 3. 4 CodeDBExceptionExpectedguidasarg Code: 395. DB::Exception: Expected guid as argument: while executing 'FUNCTION if(_CAST(1_UInt8, 'UInt8'_String) :: 1, toString(throwIf(1_Bool, 'Expected guid as argument'_String)) :: 3, _CAST(NULL_Nullable(Nothing), 'Nullable(Nothing)'_String) :: 4) -> if ('/executeQuery.cpp',218) 4. 2 CodeDBExceptionReceivedfromlocal Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (for query) exceeded: would use 20.01 MiB (attempt to allocate chunk of 1048832 bytes), maximum: 20.00 MiB.: While executing AggregatingTransform: while pushing to view tes ('/executeQuery.cpp',218) 5. 1 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 6. 1 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',43) 7. 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) 8. 1 newconfiglogidxprevlogidxcurconf new config log idx 202, prev log idx 19, cur config log idx 19, prev log idx 1 ('/LoggerWrapper.h',43) 9. 1 StartingClickHousealtinityfipsre Starting ClickHouse 24.3.5.48.altinityfips (revision: 54484, git hash: f030c602050d371934c7b7609b7a8228fb1c7779, build id: 36F0BC854011B2DEF5A0DE9023CD1950BBB00FB6), PID 2777 ('',0) 10. 1 numberofpendingcommitelements number of pending commit elements: 0 ('/LoggerWrapper.h',43) 11. 1 parameterselectiontimeoutrangehe parameters: election timeout range 0 - 0, heartbeat 0, leadership expiry 0, max batch 100, backoff 50, snapshot distance 10000, enable randomized snapshot creation NO, log sync stop gap 99999, reserved logs 2147483647, client timeout 10000, auto forwarding ('/LoggerWrapper.h',43) 12. 1 prevotetermisdifferentresetitto pre-vote term (0) is different, reset it to 2 ('/LoggerWrapper.h',43) 13. 1 VOTEINITmyidmyrolecandidateterml [VOTE INIT] my id 1, my role candidate, term 3, log idx 201, log term 2, priority (target 1 / mine 1) ('/LoggerWrapper.h',43) 14. 1 RaftASIOlistenerinitiatedonunsec Raft ASIO listener initiated on :::9234, unsecured ('/LoggerWrapper.h',43) 15. 1 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 202 ('/LoggerWrapper.h',43) 16. 1 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1 my id: 1, voting_member num peers: 0 ('/LoggerWrapper.h',43) 17. 1 configatindexiscommittedprevconf config at index 202 is committed, prev config log idx 19 ('/LoggerWrapper.h',43) 18. 1 INITRAFTSERVERcommitindextermele === INIT RAFT SERVER === commit index 201 term 2 election timer allowed log store start 1, end 201 config log idx 19, prev log idx 1 -- ASYNC REPLICATION -- ('/LoggerWrapper.h',43) 19. 1 PRIORITYdecaytargetmine [PRIORITY] decay, target 1 -> 1, mine 1 ('/LoggerWrapper.h',43) 20. 1 Forkedachildprocesstowatch Forked a child process to watch ('',0) 21. 1 newelectiontimeoutrange new election timeout range: 0 - 0 ('/LoggerWrapper.h',43) 22. 1 statemachinecommitindexprecommit state machine commit index 201, precommit index 201, last log index 201 ('/LoggerWrapper.h',43) 23. 1 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 24. 1 newconfigurationlogidxprevlogidx new configuration: log idx 202, prev log idx 19 peer 1, DC ID 0, localhost:9234, voting member, 1 my id: 1, leader: 1, term: 3 ('/LoggerWrapper.h',43) 25. 1 startingup starting up ('',0) 26. 1 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',43) 27. 1 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',43) 28. 1 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/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) 251 /var/lib/clickhouse/disks/s3_disk/store/8ef/8ef67ec9-268b-4c64-a838-418dfff29f90/tmp_merge_201403_1_6_1/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 1 similar messages) 2. 24 Forked a child process to watch 3. Query {} to stage {}{} 3 Query SELECT IPv6CIDRToRange(_CAST(' \r�\0\0��\0\0\0\0��', 'FixedString(16)'), toUInt8(128 - __table1.number)) AS `IPv6CIDRToRange(IPv6StringToNum('2001:0db8:0000:85a3:0000:0000:ac1f:8001'), toUInt8(minus(128, number)))` FROM numbers(2) AS __table1 to stage Complete 4. Query {} from stage {} to stage {}{} 3 Query SELECT IPv6CIDRToRange(_CAST(' \r�\0\0��\0\0\0\0��', 'FixedString(16)'), toUInt8(128 - __table1.number)) AS `IPv6CIDRToRange(IPv6StringToNum('2001:0db8:0000:85a3:0000:0000:ac1f:8001'), toUInt8(minus(128, number)))` FROM numbers(2) 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. 4 Database {} does not exist Code: 81. DB::Exception: Database kek does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always 28 3. 3 Found {} on {} Found snapshot_201.bin.zstd on LocalSnapshotDisk 18 4. 2 Unknown setting '{}' Code: 115. DB::Exception: Unknown setting 'xxx_yyy'. (UNKNOWN_SETTING) (version 24.3.5.48.altinityfips (altinity build)) 27 5. 1 {}:{}: '{}' src/Processors/Transforms/MergeJoinTransform.cpp:836: ' UInt32(size = 1) UInt32(size = 1) UInt32(size = 1)' 81 6. 1 Creating {}: {} Creating table test_c8w1ux24.tp_1: CREATE TABLE IF NOT EXISTS test_c8w1ux24.tp_1 UUID 'b7416efb-4552-4370-9354-c35abefd7 1029 Top messages by level: (0.000001615511495172044,'Can\'t start NON-SECURE keeper server in FIPS mode, please check the config.') Fatal (0.0007883696096439574,'Database {} does not exist. Maybe you meant {}?') Error (0.00006785148279722585,'Client has gone away.') Warning (0.007546054193948617,'Sorting and writing part of data into temporary file {}') Information (0.02525206018103422,'Key {} is removed from metadata') Debug (0.11230874363286532,'Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.)') Trace 2024-08-31 13:55:03,475 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=2777 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2777. The process with pid = 2777 is running. Sent terminate signal to process with pid 2777. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2777. The process with pid = 2777 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2777. The process with pid = 2777 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2777. The process with pid = 2777 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2777. The process with pid = 2777 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2777. The process with pid = 2777 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2777. The process with pid = 2777 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2777. The process with pid = 2777 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2777. The process with pid = 2777 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 + 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 127.0.0.1 - - [31/Aug/2024:11:55:12 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [31/Aug/2024:11:55:12 +0000] "PUT /devstoreaccount1/cont/iixwemlxnvqbtpfudbhwfyoxgimmnydg?blockid=hlxpyduvjdwztpttrgtuirphdqtfjhuqbwvexaenturjxhloicaqrxuuuxlldjxv&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:11:55:12 +0000] "PUT /devstoreaccount1/cont/iixwemlxnvqbtpfudbhwfyoxgimmnydg?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [31/Aug/2024:11:55:12 +0000] "GET /devstoreaccount1/cont/iixwemlxnvqbtpfudbhwfyoxgimmnydg HTTP/1.1" 206 4 127.0.0.1 - - [31/Aug/2024:11:55:12 +0000] "GET /devstoreaccount1/cont/iixwemlxnvqbtpfudbhwfyoxgimmnydg HTTP/1.1" 206 2 127.0.0.1 - - [31/Aug/2024:11:55:12 +0000] "DELETE /devstoreaccount1/cont/iixwemlxnvqbtpfudbhwfyoxgimmnydg HTTP/1.1" 202 - + 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' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ 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 24578 + 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=24578 + 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 = 24578. The process with pid = 24578 is running. Sent terminate signal to process with pid 24578. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 24578. The process with pid = 24578 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 24578. The process with pid = 24578 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 24578. The process with pid = 24578 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 24578. The process with pid = 24578 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 24578. The process with pid = 24578 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 24578. The process with pid = 24578 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 ++ trim_server_logs fatal_messages.txt ++ head -n 100 /test_output/fatal_messages.txt ++ grep -Eo ' \[ [0-9]+ \] \{.*' ++ escaped ++ clickhouse local -S 's String' --input-format=LineAsString -q 'select substr(s, 1, 300) from table format CustomSeparated settings format_custom_row_after_delimiter='\''\\\\n'\''' + echo -e 'Fatal message in clickhouse-server.log (see fatal_messages.txt)\tFAIL\t\N\t [ 589 ] {} KeeperServer: Can\'\''t start NON-SECURE keeper server in FIPS mode, please check the config.\\n [ 589 ] {} KeeperServer: Can\'\''t start NON-SECURE keeper server in FIPS mode, please check the config.\\n [ 1423 ] {} KeeperServer: Can\'\''t start NON-SECURE keeper server in FIPS mode, please check the config.\\n [ 2777 ] {} KeeperServer: Can\'\''t start NON-SECURE keeper server in FIPS mode, please check the config.\\n [ 24578 ] {} KeeperServer: Can\'\''t start NON-SECURE keeper server in FIPS mode, please check the config.\\n [ 24578 ] {} KeeperServer: Can\'\''t start NON-SECURE keeper server in FIPS mode, please check the config.\\n [ 1423 ] {} KeeperServer: Can\'\''t start NON-SECURE keeper server in FIPS mode, please check the config.\\n [ 2777 ] {} KeeperServer: Can\'\''t start NON-SECURE keeper server in FIPS mode, please check the config.\\n' + '[' -s /test_output/fatal_messages.txt ']' + rg -Faz '########################################' /test_output/fatal_messages.txt /test_output/gdb.log /test_output/stress_run_logs.tar.zst /test_output/test_results.tsv + rg -Fa ' received signal ' /test_output/gdb.log + dmesg -T + grep -q -F -e 'Out of memory: Killed process' -e 'oom_reaper: reaped process' -e oom-kill:constraint=CONSTRAINT_NONE /test_output/dmesg.log + echo -e 'No OOM in dmesg\tOK\t\N\t' + tar -chf /test_output/coordination.tar /var/lib/clickhouse/coordination tar: Removing leading `/' from member names tar: Removing leading `/' from hard link targets + collect_query_and_trace_logs + for table in query_log trace_log + clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.query_log format TSVWithNamesAndTypes' + zstd --threads=0 Processing configuration file '/etc/clickhouse-server/config.xml'. Merging configuration file '/etc/clickhouse-server/config.d/CORS.xml'. Merging configuration file '/etc/clickhouse-server/config.d/asynchronous_metrics_update_period_s.xml'. Merging configuration file '/etc/clickhouse-server/config.d/azure_storage_conf.xml'. Merging configuration file '/etc/clickhouse-server/config.d/backoff_failed_mutation.xml'. Merging configuration file '/etc/clickhouse-server/config.d/backups.xml'. Merging configuration file '/etc/clickhouse-server/config.d/blob_storage_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/block_number.xml'. Merging configuration file '/etc/clickhouse-server/config.d/clusters.xml'. Merging configuration file '/etc/clickhouse-server/config.d/compressed_marks_and_index.xml'. Merging configuration file '/etc/clickhouse-server/config.d/core.xml'. Merging configuration file '/etc/clickhouse-server/config.d/custom_disks_base_path.xml'. Merging configuration file '/etc/clickhouse-server/config.d/custom_settings_prefixes.xml'. Merging configuration file '/etc/clickhouse-server/config.d/database_atomic.xml'. Merging configuration file '/etc/clickhouse-server/config.d/disable_s3_env_credentials.xml'. Merging configuration file '/etc/clickhouse-server/config.d/display_name.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_access_control_improvements.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_async_load_databases.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_keeper_map.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_wait_for_shutdown_replicated_tables.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_zero_copy_replication.xml'. Merging configuration file '/etc/clickhouse-server/config.d/encryption.xml'. Merging configuration file '/etc/clickhouse-server/config.d/filesystem_cache_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/filesystem_caches_path.xml'. Merging configuration file '/etc/clickhouse-server/config.d/forbidden_headers.xml'. Merging configuration file '/etc/clickhouse-server/config.d/graphite.xml'. Merging configuration file '/etc/clickhouse-server/config.d/graphite_alternative.xml'. Merging configuration file '/etc/clickhouse-server/config.d/handlers.yaml'. Merging configuration file '/etc/clickhouse-server/config.d/keeper_port.xml'. Merging configuration file '/etc/clickhouse-server/config.d/legacy_geobase.xml'. Merging configuration file '/etc/clickhouse-server/config.d/listen.xml'. Merging configuration file '/etc/clickhouse-server/config.d/logger_trace.xml'. Merging configuration file '/etc/clickhouse-server/config.d/logging_no_rotate.xml'. Merging configuration file '/etc/clickhouse-server/config.d/lost_forever_check.xml'. Merging configuration file '/etc/clickhouse-server/config.d/macros.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_concurrent_queries.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_num_to_warn.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_server_memory_usage.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree_old_dirs_cleanup.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree_settings.xml'. Merging configuration file '/etc/clickhouse-server/config.d/named_collection.xml'. Merging configuration file '/etc/clickhouse-server/config.d/nlp.xml'. Merging configuration file '/etc/clickhouse-server/config.d/prometheus.xml'. Merging configuration file '/etc/clickhouse-server/config.d/query_masking_rules.xml'. Merging configuration file '/etc/clickhouse-server/config.d/query_masking_rules.xml_original.xml'. Merging configuration file '/etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml'. Merging configuration file '/etc/clickhouse-server/config.d/secure_ports.xml'. Merging configuration file '/etc/clickhouse-server/config.d/session_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/ssl_certs.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02944.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02961.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02963.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_metadata_with_full_object_key.xml'. Merging configuration file '/etc/clickhouse-server/config.d/system_unfreeze.xml'. Merging configuration file '/etc/clickhouse-server/config.d/tcp_with_proxy.xml'. Merging configuration file '/etc/clickhouse-server/config.d/test_cluster_with_incorrect_pw.xml'. Merging configuration file '/etc/clickhouse-server/config.d/text_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/top_level_domains_lists.xml'. Merging configuration file '/etc/clickhouse-server/config.d/top_level_domains_path.xml'. Merging configuration file '/etc/clickhouse-server/config.d/transactions.xml'. Merging configuration file '/etc/clickhouse-server/config.d/validate_tcp_client_information.xml'. Merging configuration file '/etc/clickhouse-server/config.d/zero_copy_destructive_operations.xml'. Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_fault_injection.xml'. Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_write.xml'. Logging trace to /var/log/clickhouse-server/clickhouse-server.log Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log 127.0.0.1 - - [31/Aug/2024:11:56:20 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - + for table in query_log trace_log + clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.trace_log format TSVWithNamesAndTypes' + zstd --threads=0 Processing configuration file '/etc/clickhouse-server/config.xml'. Merging configuration file '/etc/clickhouse-server/config.d/CORS.xml'. Merging configuration file '/etc/clickhouse-server/config.d/asynchronous_metrics_update_period_s.xml'. Merging configuration file '/etc/clickhouse-server/config.d/azure_storage_conf.xml'. Merging configuration file '/etc/clickhouse-server/config.d/backoff_failed_mutation.xml'. Merging configuration file '/etc/clickhouse-server/config.d/backups.xml'. Merging configuration file '/etc/clickhouse-server/config.d/blob_storage_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/block_number.xml'. Merging configuration file '/etc/clickhouse-server/config.d/clusters.xml'. Merging configuration file '/etc/clickhouse-server/config.d/compressed_marks_and_index.xml'. Merging configuration file '/etc/clickhouse-server/config.d/core.xml'. Merging configuration file '/etc/clickhouse-server/config.d/custom_disks_base_path.xml'. Merging configuration file '/etc/clickhouse-server/config.d/custom_settings_prefixes.xml'. Merging configuration file '/etc/clickhouse-server/config.d/database_atomic.xml'. Merging configuration file '/etc/clickhouse-server/config.d/disable_s3_env_credentials.xml'. Merging configuration file '/etc/clickhouse-server/config.d/display_name.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_access_control_improvements.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_async_load_databases.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_keeper_map.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_wait_for_shutdown_replicated_tables.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_zero_copy_replication.xml'. Merging configuration file '/etc/clickhouse-server/config.d/encryption.xml'. Merging configuration file '/etc/clickhouse-server/config.d/filesystem_cache_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/filesystem_caches_path.xml'. Merging configuration file '/etc/clickhouse-server/config.d/forbidden_headers.xml'. Merging configuration file '/etc/clickhouse-server/config.d/graphite.xml'. Merging configuration file '/etc/clickhouse-server/config.d/graphite_alternative.xml'. Merging configuration file '/etc/clickhouse-server/config.d/handlers.yaml'. Merging configuration file '/etc/clickhouse-server/config.d/keeper_port.xml'. Merging configuration file '/etc/clickhouse-server/config.d/legacy_geobase.xml'. Merging configuration file '/etc/clickhouse-server/config.d/listen.xml'. Merging configuration file '/etc/clickhouse-server/config.d/logger_trace.xml'. Merging configuration file '/etc/clickhouse-server/config.d/logging_no_rotate.xml'. Merging configuration file '/etc/clickhouse-server/config.d/lost_forever_check.xml'. Merging configuration file '/etc/clickhouse-server/config.d/macros.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_concurrent_queries.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_num_to_warn.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_server_memory_usage.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree_old_dirs_cleanup.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree_settings.xml'. Merging configuration file '/etc/clickhouse-server/config.d/named_collection.xml'. Merging configuration file '/etc/clickhouse-server/config.d/nlp.xml'. Merging configuration file '/etc/clickhouse-server/config.d/prometheus.xml'. Merging configuration file '/etc/clickhouse-server/config.d/query_masking_rules.xml'. Merging configuration file '/etc/clickhouse-server/config.d/query_masking_rules.xml_original.xml'. Merging configuration file '/etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml'. Merging configuration file '/etc/clickhouse-server/config.d/secure_ports.xml'. Merging configuration file '/etc/clickhouse-server/config.d/session_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/ssl_certs.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02944.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02961.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02963.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_metadata_with_full_object_key.xml'. Merging configuration file '/etc/clickhouse-server/config.d/system_unfreeze.xml'. Merging configuration file '/etc/clickhouse-server/config.d/tcp_with_proxy.xml'. Merging configuration file '/etc/clickhouse-server/config.d/test_cluster_with_incorrect_pw.xml'. Merging configuration file '/etc/clickhouse-server/config.d/text_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/top_level_domains_lists.xml'. Merging configuration file '/etc/clickhouse-server/config.d/top_level_domains_path.xml'. Merging configuration file '/etc/clickhouse-server/config.d/transactions.xml'. Merging configuration file '/etc/clickhouse-server/config.d/validate_tcp_client_information.xml'. Merging configuration file '/etc/clickhouse-server/config.d/zero_copy_destructive_operations.xml'. Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_fault_injection.xml'. Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_write.xml'. Logging trace to /var/log/clickhouse-server/clickhouse-server.log Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log 127.0.0.1 - - [31/Aug/2024:11:56:29 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - + mv /var/log/clickhouse-server/stderr.log /test_output/ + clickhouse-local --structure 'test String, res String, time Nullable(Float32), desc String' -q 'SELECT '\''failure'\'', test FROM table WHERE res != '\''OK'\'' order by (test like '\''%Sanitizer%'\'') DESC, (test like '\''%Killed by signal%'\'') DESC, (test like '\''%gdb.log%'\'') DESC, (test ilike '\''%possible deadlock%'\'') DESC, (test like '\''%start%'\'') DESC, (test like '\''%dmesg%'\'') DESC, (test like '\''%OOM%'\'') DESC, (test like '\''%Signal 9%'\'') DESC, (test like '\''%Fatal message%'\'') DESC, rowNumberInAllBlocks() LIMIT 1' + '[' -s /test_output/check_status.tsv ']' + rg 'OOM in dmesg|Signal 9' /test_output/check_status.tsv + collect_core_dumps + find . -type f -maxdepth 1 -name 'core.*' + read -r core