+ ln -s /usr/share/clickhouse-test/ci/stress.py /usr/bin/stress + ln -s /usr/share/clickhouse-test/clickhouse-test /usr/bin/clickhouse-test + source /attach_gdb.lib ++ source /utils.lib + source /stress_tests.lib ++ sysctl kernel.core_pattern=core.%e.%p-%P kernel.core_pattern = core.%e.%p-%P ++ OK='\tOK\t\N\t' ++ FAIL='\tFAIL\t\N\t' ++ FAILURE_CONTEXT_LINES=100 ++ FAILURE_CONTEXT_MAX_LINE_WIDTH=300 + install_packages package_folder + dpkg -i package_folder/clickhouse-common-static_24.3.5.47.altinitystable_amd64.deb Selecting previously unselected package clickhouse-common-static. (Reading database ... 49227 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static_24.3.5.47.altinitystable_amd64.deb ... Unpacking clickhouse-common-static (24.3.5.47.altinitystable) ... Setting up clickhouse-common-static (24.3.5.47.altinitystable) ... + dpkg -i package_folder/clickhouse-common-static-dbg_24.3.5.47.altinitystable_amd64.deb Selecting previously unselected package clickhouse-common-static-dbg. (Reading database ... 49256 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static-dbg_24.3.5.47.altinitystable_amd64.deb ... Unpacking clickhouse-common-static-dbg (24.3.5.47.altinitystable) ... Setting up clickhouse-common-static-dbg (24.3.5.47.altinitystable) ... + dpkg -i package_folder/clickhouse-server_24.3.5.47.altinitystable_amd64.deb Selecting previously unselected package clickhouse-server. (Reading database ... 49265 files and directories currently installed.) Preparing to unpack .../clickhouse-server_24.3.5.47.altinitystable_amd64.deb ... Unpacking clickhouse-server (24.3.5.47.altinitystable) ... Setting up clickhouse-server (24.3.5.47.altinitystable) ... ClickHouse binary is already located at /usr/bin/clickhouse Symlink /usr/bin/clickhouse-server already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-server to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-client to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-local to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-benchmark to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-obfuscator to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-git-import to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-compressor to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-format to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-extract-from-config already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-extract-from-config to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-keeper already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-keeper-converter already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper-converter to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-disks to /usr/bin/clickhouse. Creating symlink /usr/bin/ch to /usr/bin/clickhouse. Creating symlink /usr/bin/chl to /usr/bin/clickhouse. Creating symlink /usr/bin/chc to /usr/bin/clickhouse. Creating clickhouse group if it does not exist. groupadd -r clickhouse Creating clickhouse user if it does not exist. useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse clickhouse Will set ulimits for clickhouse user in /etc/security/limits.d/clickhouse.conf. Creating config directory /etc/clickhouse-server/config.d that is used for tweaks of main server configuration. Creating config directory /etc/clickhouse-server/users.d that is used for tweaks of users configuration. Config file /etc/clickhouse-server/config.xml already exists, will keep it and extract path info from it. /etc/clickhouse-server/config.xml has /var/lib/clickhouse/ as data path. /etc/clickhouse-server/config.xml has /var/log/clickhouse-server/ as log path. Users config file /etc/clickhouse-server/users.xml already exists, will keep it and extract users info from it. Log directory /var/log/clickhouse-server/ already exists. Creating data directory /var/lib/clickhouse/. Creating pid directory /var/run/clickhouse-server. chown -R clickhouse:clickhouse '/var/log/clickhouse-server/' chown -R clickhouse:clickhouse '/var/run/clickhouse-server' chown clickhouse:clickhouse '/var/lib/clickhouse/' groupadd -r clickhouse-bridge useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse-bridge clickhouse-bridge chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-odbc-bridge' chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-library-bridge' Password for the default user is an empty string. See /etc/clickhouse-server/users.xml and /etc/clickhouse-server/users.d to change it. Setting capabilities for clickhouse binary. This is optional. chown -R clickhouse:clickhouse '/etc/clickhouse-server' ClickHouse has been successfully installed. Start clickhouse-server with: sudo clickhouse start Start clickhouse-client with: clickhouse-client + dpkg -i package_folder/clickhouse-client_24.3.5.47.altinitystable_amd64.deb Selecting previously unselected package clickhouse-client. (Reading database ... 49282 files and directories currently installed.) Preparing to unpack .../clickhouse-client_24.3.5.47.altinitystable_amd64.deb ... Unpacking clickhouse-client (24.3.5.47.altinitystable) ... Setting up clickhouse-client (24.3.5.47.altinitystable) ... + export THREAD_FUZZER_CPU_TIME_PERIOD_US=1000 + THREAD_FUZZER_CPU_TIME_PERIOD_US=1000 + export THREAD_FUZZER_SLEEP_PROBABILITY=0.1 + THREAD_FUZZER_SLEEP_PROBABILITY=0.1 + export THREAD_FUZZER_SLEEP_TIME_US_MAX=100000 + THREAD_FUZZER_SLEEP_TIME_US_MAX=100000 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01 + THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01 + export THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01 + THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01 + export ZOOKEEPER_FAULT_INJECTION=1 + ZOOKEEPER_FAULT_INJECTION=1 + configure + export USE_DATABASE_ORDINARY=1 + USE_DATABASE_ORDINARY=1 + export EXPORT_S3_STORAGE_POLICIES=1 + EXPORT_S3_STORAGE_POLICIES=1 + /usr/share/clickhouse-test/config/install.sh + DEST_SERVER_PATH=/etc/clickhouse-server + DEST_CLIENT_PATH=/etc/clickhouse-client +++ dirname /usr/share/clickhouse-test/config/install.sh ++ cd /usr/share/clickhouse-test/config ++ pwd -P + SRC_PATH=/usr/share/clickhouse-test/config + echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server' + mkdir -p /etc/clickhouse-server/config.d/ Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + mkdir -p /etc/clickhouse-server/users.d/ + mkdir -p /etc/clickhouse-client + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/reverse_dns_query_function.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/block_number.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/ + '[' /etc/clickhouse-server = /etc/clickhouse-server ']' + ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/ + ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + rm -f /etc/clickhouse-server/config.d/zookeeper.xml + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/ + value=0 + sed --follow-symlinks -i 's|[01]|0|' /etc/clickhouse-server/config.d/keeper_port.xml + value=37140480 + sed --follow-symlinks -i 's|[[:digit:]]\+|37140480|' /etc/clickhouse-server/config.d/keeper_port.xml + value=7471104 + sed --follow-symlinks -i 's|[[:digit:]]\+|7471104|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ARM=aarch64 ++ uname -m + OS=x86_64 x86_64 + [[ -n 1 ]] + echo x86_64 + [[ '' -eq 1 ]] + [[ x86_64 == \a\a\r\c\h\6\4 ]] Adding azure configuration + echo 'Adding azure configuration' + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|100000|10000|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value filtered_list keeper_port + value=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value multi_read keeper_port + value=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value check_not_exists keeper_port + value=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value create_if_not_exists keeper_port + value=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value use_compression zookeeper_fault_injection + value=1 + sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + randomize_config_boolean_value 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 Setting max_server_memory_usage_to_ram_ratio to 0.5 + total_mem=32086448 + total_mem=32856522752 + max_server_memory_usage_to_ram_ratio=0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat + local max_users_mem + max_users_mem=9856956825 Setting max_memory_usage_for_user=9856956825 and max_memory_usage for queries to 10G + echo 'Setting max_memory_usage_for_user=9856956825 and max_memory_usage for queries to 10G' + cat + cat + ./setup_minio.sh stateless + azurite-blob --blobHost 0.0.0.0 --blobPort 10000 --debug /azurite_log + export MINIO_ROOT_USER=clickhouse + MINIO_ROOT_USER=clickhouse + export MINIO_ROOT_PASSWORD=clickhouse + MINIO_ROOT_PASSWORD=clickhouse + main stateless + local query_dir ++ check_arg stateless ++ local query_dir ++ '[' '!' 1 -eq 1 ']' ++ case "$1" in ++ query_dir=0_stateless ++ echo 0_stateless + query_dir=0_stateless + '[' '!' -f ./minio ']' + start_minio + mkdir -p ./minio_data + ./minio --version Azurite Blob service is starting on 0.0.0.0:10000 Azurite Blob service successfully listens on http://0.0.0.0:10000 minio version RELEASE.2022-01-03T18-22-58Z + wait_for_it + local counter=0 + local max_counter=60 + local url=http://localhost:11111 + params=('--silent' '--verbose') + local params + ./minio server --address :11111 ./minio_data + grep AccessDenied + curl --silent --verbose http://localhost:11111 + [[ 0 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=1 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 1 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=2 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 2 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=3 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 3 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=4 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 4 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + 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 trying to connect to minio + [[ 6 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=7 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 7 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=8 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 8 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=9 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 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 + counter=11 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 11 == \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:39661 http://127.0.0.1:39661 Documentation: https://docs.min.io WARNING: Console endpoint is listening on a dynamic port (39661), please use --console-address ":PORT" to choose a static port. + counter=12 + curl --silent --verbose http://localhost:11111 + grep AccessDenied AccessDeniedAccess Denied./17E49D56B135DE4844b543b3-5de8-46c5-9e02-28f5a81f77ac + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 290 root 10u IPv6 43266 0t0 TCP *:11111 (LISTEN) + sleep 5 + setup_minio stateless + local test_type=stateless + ./mc alias set clickminio http://localhost:11111 clickhouse clickhouse Added `clickminio` successfully. + ./mc admin user add clickminio test testtest Added user `test` successfully. + ./mc admin policy set clickminio readwrite user=test Policy `readwrite` is set on user `test` + ./mc mb clickminio/test Bucket created successfully `clickminio/test`. + '[' stateless = stateless ']' + ./mc policy set public clickminio/test Access permission for `clickminio/test` is set to `public` + upload_data 0_stateless /usr/share/clickhouse-test + local query_dir=0_stateless + local test_path=/usr/share/clickhouse-test + local data_path=/usr/share/clickhouse-test/queries/0_stateless/data_minio ++ ls /usr/share/clickhouse-test/queries/0_stateless/data_minio 02366_data.jsonl + for file in $(ls "${data_path}") + echo 02366_data.jsonl + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl clickminio/test/02366_data.jsonl `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl` -> `clickminio/test/02366_data.jsonl` Total: 0 B, Transferred: 0 B, Speed: 0 B/s + for file in $(ls "${data_path}") + echo 02731.arrow + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow clickminio/test/02731.arrow 02731.arrow `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow` -> `clickminio/test/02731.arrow` Total: 0 B, Transferred: 3.82 MiB, Speed: 82.99 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: 93.12 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: 36.68 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.85 KiB/s + 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 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.59 KiB/s + 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 c.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv` -> `clickminio/test/c.tsv` Total: 0 B, Transferred: 33 B, Speed: 4.34 KiB/s + for file in $(ls "${data_path}") + echo tsv_with_header.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv clickminio/test/tsv_with_header.tsv tsv_with_header.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv` -> `clickminio/test/tsv_with_header.tsv` Total: 0 B, Transferred: 44 B, Speed: 5.57 KiB/s + setup_aws_credentials + local minio_root_user=clickhouse + local minio_root_password=clickhouse + mkdir -p /root/.aws + cat + config_logs_export_cluster /etc/clickhouse-server/config.d/system_logs_export.yaml + set +x File /tmp/export-logs-config.sh does not exist, do not setup + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 15 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=16 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 16 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=17 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 17 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=18 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 18 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=19 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 19 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=20 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 20 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=21 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 21 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=22 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 22 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=23 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 23 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=24 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 24 -gt 120 ']' + clickhouse start --user root + sleep 0.5 127.0.0.1 - - [22/Jul/2024:18:46:24 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:18:46:24 +0000] "PUT /devstoreaccount1/cont/xmdbfjihtmatugxvokxoxyjmbfpuvnys?blockid=jsblinvhhqbmfziwohaijptfxopazwckrijdlhqfzciyjgmsttamwxfuxljslrph&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:18:46:24 +0000] "PUT /devstoreaccount1/cont/xmdbfjihtmatugxvokxoxyjmbfpuvnys?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:18:46:24 +0000] "GET /devstoreaccount1/cont/xmdbfjihtmatugxvokxoxyjmbfpuvnys HTTP/1.1" 206 4 127.0.0.1 - - [22/Jul/2024:18:46:24 +0000] "GET /devstoreaccount1/cont/xmdbfjihtmatugxvokxoxyjmbfpuvnys HTTP/1.1" 206 2 127.0.0.1 - - [22/Jul/2024:18:46:24 +0000] "DELETE /devstoreaccount1/cont/xmdbfjihtmatugxvokxoxyjmbfpuvnys HTTP/1.1" 202 - + counter=25 + 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 590 + 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=590 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Sent terminate signal to process with pid 590. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running.script.gdb:13: Error in sourced command file: No stack. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 590. The process with pid = 590 is running. Waiting for server to stop Found pid = 590 in the list of running processes. The process with pid = 590 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 Using cache policy: LRU + cache_policy= + '[' 0 -eq 1 ']' + 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' 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' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 18 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=19 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 19 -gt 120 ']' + clickhouse start --user root + sleep 0.5 127.0.0.1 - - [22/Jul/2024:18:49:21 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - + counter=20 + clickhouse-client --query 'SELECT 1' 127.0.0.1 - - [22/Jul/2024:18:49:22 +0000] "PUT /devstoreaccount1/cont/hidswvjjkuekksqiwrdijusbzrdglnqe?blockid=wguwxsllijrwaikeazpwyipdhkpayfbudwpyczrzpjhsupzcywsltocdwughjzxq&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:18:49:22 +0000] "PUT /devstoreaccount1/cont/hidswvjjkuekksqiwrdijusbzrdglnqe?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:18:49:22 +0000] "GET /devstoreaccount1/cont/hidswvjjkuekksqiwrdijusbzrdglnqe HTTP/1.1" 206 4 127.0.0.1 - - [22/Jul/2024:18:49:22 +0000] "GET /devstoreaccount1/cont/hidswvjjkuekksqiwrdijusbzrdglnqe HTTP/1.1" 206 2 127.0.0.1 - - [22/Jul/2024:18:49:22 +0000] "DELETE /devstoreaccount1/cont/hidswvjjkuekksqiwrdijusbzrdglnqe HTTP/1.1" 202 - Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 20 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=21 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 21 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=22 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 22 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=23 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 23 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=24 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 24 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=25 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 25 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=26 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 26 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=27 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 27 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=28 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 28 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=29 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 29 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=30 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 30 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=31 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 31 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=32 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 32 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=33 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 33 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=34 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 34 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=35 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 35 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=36 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 36 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=37 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 37 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=38 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 38 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=39 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 39 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=40 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 40 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=41 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 41 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=42 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 42 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=43 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 43 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=44 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 44 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=45 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 45 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=46 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 46 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=47 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 47 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=48 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 48 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=49 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 49 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=50 + 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 1485 + 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=1485 + 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 = 1485. The process with pid = 1485 is running. Sent terminate signal to process with pid 1485. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1485. The process with pid = 1485 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1485. The process with pid = 1485 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1485. The process with pid = 1485 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1485. The process with pid = 1485 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1485. The process with pid = 1485 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1485. The process with pid = 1485 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1485. The process with pid = 1485 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1485. The process with pid = 1485 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1485. The process with pid = 1485 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1485. The process with pid = 1485 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1485. The process with pid = 1485 is running. Waiting for server to stop Found pid = 1485 in the list of running processes. The process with pid = 1485 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' Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + mkdir -p /etc/clickhouse-server/config.d/ + mkdir -p /etc/clickhouse-server/users.d/ + mkdir -p /etc/clickhouse-client + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/reverse_dns_query_function.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/block_number.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/ + '[' /etc/clickhouse-server = /etc/clickhouse-server ']' + ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/ + ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + rm -f /etc/clickhouse-server/config.d/zookeeper.xml + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/ + value=0 + sed --follow-symlinks -i 's|[01]|0|' /etc/clickhouse-server/config.d/keeper_port.xml + value=12103680 + sed --follow-symlinks -i 's|[[:digit:]]\+|12103680|' /etc/clickhouse-server/config.d/keeper_port.xml + value=38748160 + sed --follow-symlinks -i 's|[[:digit:]]\+|38748160|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + object_key_types_options=("generate-suffix" "generate-full-key" "generate-template-key") + object_key_type=generate-suffix + [[ -n 1 ]] + [[ 1 -eq 1 ]] + object_key_type=generate-template-key + case $object_key_type in + ln -sf /usr/share/clickhouse-test/config/config.d/storage_metadata_with_full_object_key.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/s3_storage_policy_with_template_object_key.xml /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + ARM=aarch64 ++ uname -m + OS=x86_64 x86_64 Adding azure configuration + [[ -n 1 ]] + echo x86_64 + [[ '' -eq 1 ]] + [[ x86_64 == \a\a\r\c\h\6\4 ]] + echo 'Adding azure configuration' + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|100000|10000|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value filtered_list keeper_port + value=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value multi_read keeper_port + value=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=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value create_if_not_exists keeper_port + value=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value use_compression zookeeper_fault_injection + value=0 + sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + randomize_config_boolean_value allow_experimental_block_number_column block_number + value=0 + sudo cat /etc/clickhouse-server/config.d/block_number.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml + echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\''' + export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + sudo chown root: /var/lib/clickhouse + echo '1' + local total_mem ++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo + total_mem=32086448 + total_mem=32856522752 + max_server_memory_usage_to_ram_ratio=0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat Setting max_server_memory_usage_to_ram_ratio to 0.5 + local max_users_mem + max_users_mem=9856956825 + echo 'Setting max_memory_usage_for_user=9856956825 and max_memory_usage for queries to 10G' + cat Setting max_memory_usage_for_user=9856956825 and max_memory_usage for queries to 10G + cat + sudo cat /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sed 's|
s3
|
s3
default|' + mv /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml.tmp /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo cat /etc/clickhouse-server/config.d/logger_trace.xml + sed 's|trace|test|' + mv /etc/clickhouse-server/config.d/logger_trace.xml.tmp /etc/clickhouse-server/config.d/logger_trace.xml + '[' LRU = SLRU ']' ++ date +%-d + '[' 0 -eq 1 ']' + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' 127.0.0.1 - - [22/Jul/2024:19:54:01 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root 127.0.0.1 - - [22/Jul/2024:19:54:01 +0000] "PUT /devstoreaccount1/cont/mblhuxhegzvykwltxnffetbhqwudrciy?blockid=ukpmmjyvgcusuvupxozbumbxtwpositozvtkxncjpjswdotctbloxbyssnaoervv&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:19:54:01 +0000] "PUT /devstoreaccount1/cont/mblhuxhegzvykwltxnffetbhqwudrciy?comp=blocklist HTTP/1.1" 201 - + sleep 0.5 127.0.0.1 - - [22/Jul/2024:19:54:01 +0000] "GET /devstoreaccount1/cont/mblhuxhegzvykwltxnffetbhqwudrciy HTTP/1.1" 206 4 127.0.0.1 - - [22/Jul/2024:19:54:01 +0000] "GET /devstoreaccount1/cont/mblhuxhegzvykwltxnffetbhqwudrciy HTTP/1.1" 206 2 127.0.0.1 - - [22/Jul/2024:19:54:01 +0000] "DELETE /devstoreaccount1/cont/mblhuxhegzvykwltxnffetbhqwudrciy HTTP/1.1" 202 - + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 15 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=16 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 16 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=17 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 17 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=18 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 18 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=19 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 19 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=20 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 20 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=21 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 21 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=22 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 22 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=23 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 23 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=24 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 24 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=25 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 25 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=26 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 26 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=27 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 27 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=28 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 28 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=29 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 29 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=30 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 30 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=31 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 31 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=32 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 32 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=33 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 33 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=34 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 34 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=35 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 35 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=36 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 36 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=37 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 37 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=38 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 38 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=39 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 39 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=40 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 40 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=41 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 41 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=42 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 42 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=43 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 43 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=44 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 44 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=45 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 45 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=46 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 46 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=47 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 47 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=48 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 48 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=49 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 49 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=50 + 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 2813 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + stress --hung-check --drop-databases --output-folder test_output --skip-func-tests '' --global-time-limit 1200 2024-07-22 21:56:19,169 Run func tests '/usr/bin/clickhouse-test --client-option http_make_head_request=0 --global_time_limit=1200 ' 2024-07-22 21:56:19,670 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 --global_time_limit=1200 ' 2024-07-22 21:56:20,171 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_2', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 --global_time_limit=1200 ' 2024-07-22 21:56:20,673 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_3 --client-option join_algorithm='partial_merge' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-07-22 21:56:21,174 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 use_query_cache=1 optimize_trivial_approximate_count_query=1 http_make_head_request=0 --global_time_limit=1200 ' 2024-07-22 21:56:21,675 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_5', 's1', 'r1')" --database=test_5 --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='full_sorting_merge' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-07-22 21:56:22,176 Run func tests '/usr/bin/clickhouse-test --order=random --client-option memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 http_make_head_request=1 --global_time_limit=1200 ' 2024-07-22 21:56:22,678 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_7 --client-option join_use_nulls=1 join_algorithm='grace_hash' group_by_use_nulls=1 http_make_head_request=1 --global_time_limit=1200 ' 2024-07-22 21:56:23,179 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_8', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 use_query_cache=1 --global_time_limit=1200 ' 2024-07-22 21:56:23,679 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-07-22 21:56:24,181 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 use_query_cache=1 --global_time_limit=1200 ' 2024-07-22 21:56:24,682 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_11', 's1', 'r1')" --database=test_11 --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='parallel_hash' use_query_cache=1 memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 http_make_head_request=1 --global_time_limit=1200 ' 2024-07-22 21:56:25,183 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-07-22 21:56:25,684 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_13 --client-option join_use_nulls=1 join_algorithm='partial_merge' use_query_cache=1 group_by_use_nulls=1 http_make_head_request=0 --global_time_limit=1200 ' 2024-07-22 21:56:26,185 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 http_make_head_request=1 --global_time_limit=1200 ' 2024-07-22 21:56:26,687 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_merge' use_query_cache=1 group_by_use_nulls=1 http_make_head_request=1 --global_time_limit=1200 ' 2024-07-22 21:56:27,187 Will wait functests to finish 2024-07-22 21:56:27,188 Finished 7 from 16 processes 2024-07-22 21:56:32,191 Finished 7 from 16 processes 2024-07-22 21:56:37,195 Finished 7 from 16 processes 2024-07-22 21:56:42,199 Finished 7 from 16 processes 2024-07-22 21:56:47,203 Finished 7 from 16 processes 2024-07-22 21:56:52,207 Finished 7 from 16 processes 2024-07-22 21:56:57,211 Finished 7 from 16 processes 2024-07-22 21:57:02,216 Finished 7 from 16 processes 2024-07-22 21:57:07,219 Finished 7 from 16 processes 2024-07-22 21:57:12,223 Finished 7 from 16 processes 2024-07-22 21:57:17,227 Finished 7 from 16 processes 2024-07-22 21:57:22,231 Finished 7 from 16 processes 2024-07-22 21:57:27,235 Finished 7 from 16 processes 2024-07-22 21:57:32,239 Finished 7 from 16 processes 2024-07-22 21:57:37,243 Finished 7 from 16 processes 2024-07-22 21:57:42,247 Finished 7 from 16 processes 2024-07-22 21:57:47,251 Finished 7 from 16 processes 2024-07-22 21:57:52,255 Finished 7 from 16 processes 2024-07-22 21:57:57,259 Finished 7 from 16 processes 2024-07-22 21:58:02,263 Finished 7 from 16 processes 2024-07-22 21:58:07,267 Finished 7 from 16 processes 2024-07-22 21:58:12,273 Finished 7 from 16 processes 2024-07-22 21:58:17,278 Finished 7 from 16 processes 2024-07-22 21:58:22,281 Finished 7 from 16 processes 2024-07-22 21:58:27,283 Finished 7 from 16 processes 2024-07-22 21:58:32,284 Finished 7 from 16 processes 2024-07-22 21:58:37,287 Finished 7 from 16 processes 2024-07-22 21:58:42,291 Finished 7 from 16 processes 2024-07-22 21:58:47,295 Finished 7 from 16 processes 2024-07-22 21:58:52,297 Finished 7 from 16 processes 2024-07-22 21:58:57,299 Finished 7 from 16 processes 2024-07-22 21:59:02,303 Finished 7 from 16 processes 2024-07-22 21:59:07,308 Finished 7 from 16 processes 2024-07-22 21:59:12,311 Finished 7 from 16 processes 2024-07-22 21:59:17,314 Finished 7 from 16 processes 2024-07-22 21:59:22,315 Finished 7 from 16 processes 2024-07-22 21:59:27,319 Finished 7 from 16 processes 2024-07-22 21:59:32,325 Finished 7 from 16 processes 2024-07-22 21:59:37,327 Finished 7 from 16 processes 2024-07-22 21:59:42,332 Finished 7 from 16 processes 2024-07-22 21:59:47,335 Finished 7 from 16 processes 2024-07-22 21:59:52,341 Finished 7 from 16 processes 2024-07-22 21:59:57,344 Finished 7 from 16 processes 2024-07-22 22:00:02,346 Finished 7 from 16 processes 2024-07-22 22:00:07,351 Finished 7 from 16 processes 2024-07-22 22:00:12,355 Finished 7 from 16 processes 2024-07-22 22:00:17,359 Finished 7 from 16 processes 2024-07-22 22:00:22,363 Finished 7 from 16 processes 2024-07-22 22:00:27,367 Finished 7 from 16 processes 2024-07-22 22:00:32,371 Finished 7 from 16 processes 2024-07-22 22:00:37,375 Finished 7 from 16 processes 2024-07-22 22:00:42,381 Finished 7 from 16 processes 2024-07-22 22:00:47,383 Finished 7 from 16 processes 2024-07-22 22:00:52,387 Finished 7 from 16 processes 2024-07-22 22:00:57,391 Finished 7 from 16 processes 2024-07-22 22:01:02,397 Finished 7 from 16 processes 2024-07-22 22:01:07,400 Finished 7 from 16 processes 2024-07-22 22:01:12,404 Finished 7 from 16 processes 2024-07-22 22:01:17,407 Finished 7 from 16 processes 2024-07-22 22:01:22,410 Finished 7 from 16 processes 2024-07-22 22:01:27,415 Finished 7 from 16 processes 2024-07-22 22:01:32,419 Finished 7 from 16 processes 2024-07-22 22:01:37,423 Finished 7 from 16 processes 2024-07-22 22:01:42,427 Finished 7 from 16 processes 2024-07-22 22:01:47,431 Finished 7 from 16 processes 2024-07-22 22:01:52,432 Finished 7 from 16 processes 2024-07-22 22:01:57,436 Finished 7 from 16 processes 2024-07-22 22:02:02,439 Finished 7 from 16 processes 2024-07-22 22:02:07,443 Finished 7 from 16 processes 2024-07-22 22:02:12,447 Finished 7 from 16 processes 2024-07-22 22:02:17,451 Finished 7 from 16 processes 2024-07-22 22:02:22,455 Finished 7 from 16 processes 2024-07-22 22:02:27,459 Finished 7 from 16 processes 2024-07-22 22:02:32,463 Finished 7 from 16 processes 2024-07-22 22:02:37,467 Finished 7 from 16 processes 2024-07-22 22:02:42,471 Finished 7 from 16 processes 2024-07-22 22:02:47,476 Finished 7 from 16 processes 2024-07-22 22:02:52,481 Finished 7 from 16 processes 2024-07-22 22:02:57,483 Finished 7 from 16 processes 2024-07-22 22:03:02,487 Finished 7 from 16 processes 2024-07-22 22:03:07,491 Finished 7 from 16 processes 2024-07-22 22:03:12,495 Finished 7 from 16 processes 2024-07-22 22:03:17,499 Finished 7 from 16 processes 2024-07-22 22:03:22,503 Finished 7 from 16 processes 2024-07-22 22:03:27,506 Finished 7 from 16 processes 2024-07-22 22:03:32,507 Finished 7 from 16 processes 2024-07-22 22:03:37,511 Finished 7 from 16 processes 2024-07-22 22:03:42,517 Finished 7 from 16 processes 2024-07-22 22:03:47,520 Finished 7 from 16 processes 2024-07-22 22:03:52,524 Finished 7 from 16 processes 2024-07-22 22:03:57,527 Finished 7 from 16 processes 2024-07-22 22:04:02,531 Finished 7 from 16 processes 2024-07-22 22:04:07,535 Finished 7 from 16 processes 2024-07-22 22:04:12,539 Finished 7 from 16 processes 2024-07-22 22:04:17,543 Finished 7 from 16 processes 2024-07-22 22:04:22,547 Finished 7 from 16 processes 2024-07-22 22:04:27,551 Finished 7 from 16 processes 2024-07-22 22:04:32,556 Finished 7 from 16 processes 2024-07-22 22:04:37,559 Finished 7 from 16 processes 2024-07-22 22:04:42,563 Finished 7 from 16 processes 2024-07-22 22:04:47,565 Finished 7 from 16 processes 2024-07-22 22:04:52,568 Finished 7 from 16 processes 2024-07-22 22:04:57,573 Finished 7 from 16 processes 2024-07-22 22:05:02,577 Finished 7 from 16 processes 2024-07-22 22:05:07,583 Finished 7 from 16 processes 2024-07-22 22:05:12,587 Finished 7 from 16 processes 2024-07-22 22:05:17,592 Finished 7 from 16 processes 2024-07-22 22:05:22,595 Finished 7 from 16 processes 2024-07-22 22:05:27,600 Finished 7 from 16 processes 2024-07-22 22:05:32,603 Finished 7 from 16 processes 2024-07-22 22:05:37,607 Finished 7 from 16 processes 2024-07-22 22:05:42,611 Finished 7 from 16 processes 2024-07-22 22:05:47,615 Finished 7 from 16 processes 2024-07-22 22:05:52,620 Finished 7 from 16 processes 2024-07-22 22:05:57,623 Finished 7 from 16 processes 2024-07-22 22:06:02,627 Finished 7 from 16 processes 2024-07-22 22:06:07,631 Finished 7 from 16 processes 2024-07-22 22:06:12,637 Finished 7 from 16 processes 2024-07-22 22:06:17,640 Finished 7 from 16 processes 2024-07-22 22:06:22,643 Finished 7 from 16 processes 2024-07-22 22:06:27,647 Finished 7 from 16 processes 2024-07-22 22:06:32,651 Finished 7 from 16 processes 2024-07-22 22:06:37,655 Finished 7 from 16 processes 2024-07-22 22:06:42,659 Finished 7 from 16 processes 2024-07-22 22:06:47,663 Finished 7 from 16 processes 2024-07-22 22:06:52,667 Finished 7 from 16 processes 2024-07-22 22:06:57,671 Finished 7 from 16 processes 2024-07-22 22:07:02,675 Finished 7 from 16 processes 2024-07-22 22:07:07,679 Finished 7 from 16 processes 2024-07-22 22:07:12,682 Finished 7 from 16 processes 2024-07-22 22:07:17,687 Finished 7 from 16 processes 2024-07-22 22:07:22,690 Finished 7 from 16 processes 2024-07-22 22:07:27,696 Finished 7 from 16 processes 2024-07-22 22:07:32,699 Finished 7 from 16 processes 2024-07-22 22:07:37,703 Finished 7 from 16 processes 2024-07-22 22:07:42,707 Finished 7 from 16 processes 2024-07-22 22:07:47,711 Finished 7 from 16 processes 2024-07-22 22:07:52,715 Finished 7 from 16 processes 2024-07-22 22:07:57,721 Finished 7 from 16 processes 2024-07-22 22:08:02,723 Finished 7 from 16 processes 2024-07-22 22:08:07,727 Finished 7 from 16 processes 2024-07-22 22:08:12,732 Finished 7 from 16 processes 2024-07-22 22:08:17,736 Finished 7 from 16 processes 2024-07-22 22:08:22,739 Finished 7 from 16 processes 2024-07-22 22:08:27,743 Finished 7 from 16 processes 2024-07-22 22:08:32,747 Finished 7 from 16 processes 2024-07-22 22:08:37,751 Finished 7 from 16 processes 2024-07-22 22:08:42,755 Finished 7 from 16 processes 2024-07-22 22:08:47,759 Finished 7 from 16 processes 2024-07-22 22:08:52,763 Finished 7 from 16 processes 2024-07-22 22:08:57,767 Finished 7 from 16 processes 2024-07-22 22:09:02,771 Finished 7 from 16 processes 2024-07-22 22:09:07,775 Finished 7 from 16 processes 2024-07-22 22:09:12,780 Finished 7 from 16 processes 2024-07-22 22:09:17,783 Finished 7 from 16 processes 2024-07-22 22:09:22,787 Finished 7 from 16 processes 2024-07-22 22:09:27,791 Finished 7 from 16 processes 2024-07-22 22:09:32,795 Finished 7 from 16 processes 2024-07-22 22:09:37,801 Finished 7 from 16 processes 2024-07-22 22:09:42,803 Finished 7 from 16 processes 2024-07-22 22:09:47,808 Finished 7 from 16 processes 2024-07-22 22:09:52,811 Finished 7 from 16 processes 2024-07-22 22:09:57,815 Finished 7 from 16 processes 2024-07-22 22:10:02,819 Finished 7 from 16 processes 2024-07-22 22:10:07,823 Finished 7 from 16 processes 2024-07-22 22:10:12,827 Finished 7 from 16 processes 2024-07-22 22:10:17,833 Finished 7 from 16 processes 2024-07-22 22:10:22,835 Finished 7 from 16 processes 2024-07-22 22:10:27,836 Finished 7 from 16 processes 2024-07-22 22:10:32,839 Finished 7 from 16 processes 2024-07-22 22:10:37,843 Finished 7 from 16 processes 2024-07-22 22:10:42,847 Finished 7 from 16 processes 2024-07-22 22:10:47,851 Finished 7 from 16 processes 2024-07-22 22:10:52,855 Finished 7 from 16 processes 2024-07-22 22:10:57,859 Finished 7 from 16 processes 2024-07-22 22:11:02,860 Finished 7 from 16 processes 2024-07-22 22:11:07,863 Finished 7 from 16 processes 2024-07-22 22:11:12,867 Finished 7 from 16 processes 2024-07-22 22:11:17,871 Finished 7 from 16 processes 2024-07-22 22:11:22,875 Finished 7 from 16 processes 2024-07-22 22:11:27,880 Finished 7 from 16 processes 2024-07-22 22:11:32,883 Finished 7 from 16 processes 2024-07-22 22:11:37,887 Finished 7 from 16 processes 2024-07-22 22:11:42,892 Finished 7 from 16 processes 2024-07-22 22:11:47,896 Finished 7 from 16 processes 2024-07-22 22:11:52,899 Finished 7 from 16 processes 2024-07-22 22:11:57,903 Finished 7 from 16 processes 2024-07-22 22:12:02,905 Finished 7 from 16 processes 2024-07-22 22:12:07,907 Finished 7 from 16 processes 2024-07-22 22:12:12,911 Finished 7 from 16 processes 2024-07-22 22:12:17,915 Finished 7 from 16 processes 2024-07-22 22:12:22,921 Finished 7 from 16 processes 2024-07-22 22:12:27,923 Finished 7 from 16 processes 2024-07-22 22:12:32,927 Finished 7 from 16 processes 2024-07-22 22:12:37,931 Finished 7 from 16 processes 2024-07-22 22:12:42,935 Finished 7 from 16 processes 2024-07-22 22:12:47,939 Finished 7 from 16 processes 2024-07-22 22:12:52,944 Finished 7 from 16 processes 2024-07-22 22:12:57,947 Finished 7 from 16 processes 2024-07-22 22:13:02,952 Finished 7 from 16 processes 2024-07-22 22:13:07,955 Finished 7 from 16 processes 2024-07-22 22:13:12,961 Finished 7 from 16 processes 2024-07-22 22:13:17,966 Finished 7 from 16 processes 2024-07-22 22:13:22,967 Finished 7 from 16 processes 2024-07-22 22:13:27,971 Finished 7 from 16 processes 2024-07-22 22:13:32,975 Finished 7 from 16 processes 2024-07-22 22:13:37,979 Finished 7 from 16 processes 2024-07-22 22:13:42,983 Finished 7 from 16 processes 2024-07-22 22:13:47,987 Finished 7 from 16 processes 2024-07-22 22:13:52,992 Finished 7 from 16 processes 2024-07-22 22:13:57,995 Finished 7 from 16 processes 2024-07-22 22:14:02,999 Finished 7 from 16 processes 2024-07-22 22:14:08,003 Finished 7 from 16 processes 2024-07-22 22:14:13,007 Finished 7 from 16 processes 2024-07-22 22:14:18,008 Finished 7 from 16 processes 2024-07-22 22:14:23,012 Finished 7 from 16 processes 2024-07-22 22:14:28,018 Finished 7 from 16 processes 2024-07-22 22:14:33,019 Finished 7 from 16 processes 2024-07-22 22:14:38,023 Finished 7 from 16 processes 2024-07-22 22:14:43,027 Finished 7 from 16 processes 2024-07-22 22:14:48,030 Finished 7 from 16 processes 2024-07-22 22:14:53,035 Finished 7 from 16 processes 2024-07-22 22:14:58,039 Finished 7 from 16 processes 2024-07-22 22:15:03,043 Finished 7 from 16 processes 2024-07-22 22:15:08,047 Finished 7 from 16 processes 2024-07-22 22:15:13,051 Finished 7 from 16 processes 2024-07-22 22:15:18,055 Finished 7 from 16 processes 2024-07-22 22:15:23,059 Finished 7 from 16 processes 2024-07-22 22:15:28,063 Finished 7 from 16 processes 2024-07-22 22:15:33,067 Finished 7 from 16 processes 2024-07-22 22:15:38,071 Finished 7 from 16 processes 2024-07-22 22:15:43,075 Finished 7 from 16 processes 2024-07-22 22:15:48,079 Finished 7 from 16 processes 2024-07-22 22:15:53,083 Finished 7 from 16 processes 2024-07-22 22:15:58,087 Finished 7 from 16 processes 2024-07-22 22:16:03,090 Finished 7 from 16 processes 2024-07-22 22:16:08,094 Finished 7 from 16 processes 2024-07-22 22:16:13,099 Finished 7 from 16 processes 2024-07-22 22:16:18,105 Finished 7 from 16 processes 2024-07-22 22:16:23,108 Finished 7 from 16 processes 2024-07-22 22:16:28,111 Finished 8 from 16 processes 2024-07-22 22:16:33,115 Finished 8 from 16 processes 2024-07-22 22:16:38,120 Finished 8 from 16 processes 2024-07-22 22:16:43,123 Finished 8 from 16 processes 2024-07-22 22:16:48,127 Finished 9 from 16 processes 2024-07-22 22:16:53,131 Finished 9 from 16 processes 2024-07-22 22:16:58,135 Finished 9 from 16 processes 2024-07-22 22:17:03,140 Finished 9 from 16 processes 2024-07-22 22:17:08,143 Finished 10 from 16 processes 2024-07-22 22:17:13,148 Finished 10 from 16 processes 2024-07-22 22:17:18,151 Finished 10 from 16 processes 2024-07-22 22:17:23,155 Finished 10 from 16 processes 2024-07-22 22:17:28,159 Finished 11 from 16 processes 2024-07-22 22:17:33,163 Finished 11 from 16 processes 2024-07-22 22:17:38,167 Finished 11 from 16 processes 2024-07-22 22:17:43,171 Finished 11 from 16 processes 2024-07-22 22:17:48,175 Finished 11 from 16 processes 2024-07-22 22:17:53,179 Finished 12 from 16 processes 2024-07-22 22:17:58,183 Finished 12 from 16 processes 2024-07-22 22:18:03,187 Finished 12 from 16 processes 2024-07-22 22:18:08,188 Finished 12 from 16 processes 2024-07-22 22:18:13,191 Finished 12 from 16 processes 2024-07-22 22:18:18,197 Finished 12 from 16 processes 2024-07-22 22:18:23,199 Finished 12 from 16 processes 2024-07-22 22:18:28,203 Finished 12 from 16 processes 2024-07-22 22:18:33,209 Finished 12 from 16 processes 2024-07-22 22:18:38,211 Finished 12 from 16 processes 2024-07-22 22:18:43,215 Finished 12 from 16 processes 2024-07-22 22:18:48,221 Finished 12 from 16 processes 2024-07-22 22:18:53,226 Finished 12 from 16 processes 2024-07-22 22:18:58,227 Finished 12 from 16 processes 2024-07-22 22:19:03,231 Finished 12 from 16 processes 2024-07-22 22:19:08,235 Finished 12 from 16 processes 2024-07-22 22:19:13,239 Finished 12 from 16 processes 2024-07-22 22:19:18,243 Finished 12 from 16 processes 2024-07-22 22:19:23,249 Finished 12 from 16 processes 2024-07-22 22:19:28,251 Finished 12 from 16 processes 2024-07-22 22:19:33,257 Finished 12 from 16 processes 2024-07-22 22:19:38,259 Finished 12 from 16 processes 2024-07-22 22:19:43,263 Finished 12 from 16 processes 2024-07-22 22:19:48,267 Finished 12 from 16 processes 2024-07-22 22:19:53,271 Finished 12 from 16 processes 2024-07-22 22:19:58,275 Finished 12 from 16 processes 2024-07-22 22:20:03,279 Finished 12 from 16 processes 2024-07-22 22:20:08,281 Finished 12 from 16 processes 2024-07-22 22:20:13,283 Finished 12 from 16 processes 2024-07-22 22:20:18,287 Finished 12 from 16 processes 2024-07-22 22:20:23,291 Finished 12 from 16 processes 2024-07-22 22:20:28,295 Finished 12 from 16 processes 2024-07-22 22:20:33,299 Finished 12 from 16 processes 2024-07-22 22:20:38,303 Finished 12 from 16 processes 2024-07-22 22:20:43,307 Finished 12 from 16 processes 2024-07-22 22:20:48,311 Finished 12 from 16 processes 2024-07-22 22:20:53,315 Finished 12 from 16 processes 2024-07-22 22:20:58,319 Finished 12 from 16 processes 2024-07-22 22:21:03,323 Finished 12 from 16 processes 2024-07-22 22:21:08,327 Finished 12 from 16 processes 2024-07-22 22:21:13,331 Finished 12 from 16 processes 2024-07-22 22:21:18,335 Finished 12 from 16 processes 2024-07-22 22:21:23,340 Finished 12 from 16 processes 2024-07-22 22:21:28,342 Finished 12 from 16 processes 2024-07-22 22:21:33,343 Finished 12 from 16 processes 2024-07-22 22:21:38,347 Finished 12 from 16 processes 2024-07-22 22:21:43,351 Finished 12 from 16 processes 2024-07-22 22:21:48,355 Finished 12 from 16 processes 2024-07-22 22:21:53,359 Finished 13 from 16 processes 2024-07-22 22:21:58,363 Finished 13 from 16 processes 2024-07-22 22:22:03,367 Finished 13 from 16 processes 2024-07-22 22:22:08,373 Finished 13 from 16 processes 2024-07-22 22:22:13,375 Finished 13 from 16 processes 2024-07-22 22:22:18,379 Finished 14 from 16 processes 2024-07-22 22:22:23,383 Finished 14 from 16 processes 2024-07-22 22:22:28,387 Finished 14 from 16 processes 2024-07-22 22:22:33,391 Finished 14 from 16 processes 2024-07-22 22:22:38,395 Finished 14 from 16 processes 2024-07-22 22:22:43,399 Finished 14 from 16 processes 2024-07-22 22:22:48,403 Finished 14 from 16 processes 2024-07-22 22:22:53,407 Finished 14 from 16 processes 2024-07-22 22:22:58,411 Finished 14 from 16 processes 2024-07-22 22:23:03,415 Finished 14 from 16 processes 2024-07-22 22:23:08,419 Finished 14 from 16 processes 2024-07-22 22:23:13,423 Finished 14 from 16 processes 2024-07-22 22:23:18,427 Finished 14 from 16 processes 2024-07-22 22:23:23,431 Finished 14 from 16 processes 2024-07-22 22:23:28,435 Finished 14 from 16 processes 2024-07-22 22:23:33,439 Finished 14 from 16 processes 2024-07-22 22:23:38,443 Finished 14 from 16 processes 2024-07-22 22:23:43,444 Finished 14 from 16 processes 2024-07-22 22:23:48,450 Finished 14 from 16 processes 2024-07-22 22:23:53,451 Finished 14 from 16 processes 2024-07-22 22:23:58,455 Finished 14 from 16 processes 2024-07-22 22:24:03,457 Finished 14 from 16 processes 2024-07-22 22:24:08,459 Finished 14 from 16 processes 2024-07-22 22:24:13,463 Finished 14 from 16 processes 2024-07-22 22:24:18,467 Finished 14 from 16 processes 2024-07-22 22:24:23,471 Finished 14 from 16 processes 2024-07-22 22:24:28,474 Finished 15 from 16 processes 2024-07-22 22:24:33,475 Finished 15 from 16 processes 2024-07-22 22:24:38,479 Finished 15 from 16 processes 2024-07-22 22:24:43,483 Finished 15 from 16 processes 2024-07-22 22:24:48,487 Finished 15 from 16 processes 2024-07-22 22:24:53,491 Finished 15 from 16 processes 2024-07-22 22:24:58,495 Finished 15 from 16 processes 2024-07-22 22:25:03,499 Finished 15 from 16 processes 2024-07-22 22:25:08,501 Finished 15 from 16 processes 2024-07-22 22:25:13,503 Finished 15 from 16 processes 2024-07-22 22:25:18,508 Finished 15 from 16 processes 2024-07-22 22:25:23,511 Finished 15 from 16 processes 2024-07-22 22:25:28,515 Finished 15 from 16 processes 2024-07-22 22:25:33,519 Finished 15 from 16 processes 2024-07-22 22:25:38,523 Finished 15 from 16 processes 2024-07-22 22:25:43,527 Finished 15 from 16 processes 2024-07-22 22:25:48,531 Finished 15 from 16 processes 2024-07-22 22:25:53,536 Finished 15 from 16 processes 2024-07-22 22:25:58,539 Finished 15 from 16 processes 2024-07-22 22:26:03,543 Finished 15 from 16 processes 2024-07-22 22:26:08,547 Finished 15 from 16 processes 2024-07-22 22:26:13,553 Finished 15 from 16 processes 2024-07-22 22:26:18,555 Finished 15 from 16 processes 2024-07-22 22:26:23,561 All processes finished 2024-07-22 22:26:23,561 Compressing stress logs 2024-07-22 22:26:23,572 Logs compressed 2024-07-22 22:26:23,572 Will terminate gdb (if any) 2024-07-22 22:26:23,572 Running command: kill -TERM $(pidof gdb) 2024-07-22 22:26:23,576 Running command: timeout 50s tail --pid=$(pidof gdb) -f /dev/null || kill -9 $(pidof gdb) ||: Quit 2024-07-22 22:26:24,593 Running command: kill -CONT $(cat /var/run/clickhouse-server/clickhouse-server.pid) && clickhouse client -q 'SELECT 1 FORMAT Null' 2024-07-22 22:26:25,563 Running command: clickhouse client -q "SYSTEM STOP THREAD FUZZER" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-07-22 22:26:26,379 Running command: clickhouse client -q "SYSTEM START MERGES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-07-22 22:26:26,995 Running command: clickhouse client -q "SYSTEM START DISTRIBUTED SENDS" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-07-22 22:26:27,611 Running command: clickhouse client -q "SYSTEM START TTL MERGES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-07-22 22:26:28,176 Running command: clickhouse client -q "SYSTEM START MOVES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-07-22 22:26:28,792 Running command: clickhouse client -q "SYSTEM START FETCHES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-07-22 22:26:29,408 Running command: clickhouse client -q "SYSTEM START REPLICATED SENDS" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-07-22 22:26:29,974 Running command: clickhouse client -q "SYSTEM START REPLICATION QUEUES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-07-22 22:26:30,540 Running command: clickhouse client -q "SYSTEM DROP MARK CACHE" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-07-22 22:26:31,106 Running command: clickhouse client -q "KILL QUERY WHERE upper(query) LIKE 'WATCH %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-07-22 22:26:31,671 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'insert into tableB select %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-07-22 22:26:32,236 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'SELECT URL, uniq(SearchPhrase) AS u FROM test.hits GROUP BY URL ORDER BY u %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-07-22 22:26:32,801 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'SELECT (SELECT number FROM system.numbers WHERE number = 1000000000000)%'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2024-07-22 22:31:36,689 Checking if some queries hung Using queries from '/usr/share/clickhouse-test/queries' directory Connecting to ClickHouse server... OK Connected to server 24.3.5.47.altinitystable @ b6642564dbf296d6e55b907d7af6c8087470b672 HEAD Running 1 stateless tests (MainProcess). 00001_select_1: [ OK ] 1 tests passed. 0 tests skipped. 3.38 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. 15261 0.083 909.10 KiB 0.025 1 53 ['Debug'] 0.996 Key {} is removed from metadata 2. 13885 0.076 800.01 KiB 0.022 1 547 ['Debug'] 0.017 Submitting key {} for removal 3. 6178 0.034 570.72 KiB 0.016 1 700 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 4. 5585 0.03 1.33 MiB 0.038 1 212 ['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) 5. 5585 0.03 247.27 KiB 0.007 1 212 ['Debug'] 0 Max size of temporary block: {} rows, {}. 6. 5585 0.03 752.67 KiB 0.021 1 212 ['Debug'] 0 Writing part of aggregation data into temporary file {} 7. 5426 0.03 161.18 KiB 0.004 1 699 ['Trace'] 0 Aggregation method: {} 8. 4777 0.026 545.81 KiB 0.015 166 788 ['Trace'] 0 Bypassing cache because file segment state is `PARTIALLY_DOWNLOADED_NO_CONTINUATION` and downloaded part already used 9. 4741 0.026 1.44 MiB 0.041 1726 486 ['Information'] 0.011 Setting download as failed: {} 10. 4344 0.024 263.67 KiB 0.007 1 113 ['Trace'] 0.008 Access granted: {}{} 11. 4285 0.023 372.39 KiB 0.01 24 38 ['Trace'] 0 Reading {} ranges in{}order from part {}, approx. {} rows starting from {} 12. 4144 0.023 44.52 KiB 0.001 1 691 ['Trace'] 0 Aggregating 13. 3000 0.016 358.90 KiB 0.01 88 163 ['Trace'] 0.731 Renaming temporary part {} to {} with tid {}. 14. 2985 0.016 303.31 KiB 0.008 574 351 ['Trace'] 0 Predownload failed because of space limit. Will read from remote filesystem starting from offset: {} 15. 2953 0.016 204.77 KiB 0.006 87 495 ['Trace'] 0.921 Trying to reserve {} using storage policy from min volume index {} 16. 2947 0.016 142.25 KiB 0.004 1 146 ['Trace'] 0.728 filled checksums {} 17. 2919 0.016 618.13 KiB 0.017 1 74 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 18. 2819 0.015 432.21 KiB 0.012 2 74 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 19. 2774 0.015 262.14 KiB 0.007 1 18 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 20. 2676 0.015 4.28 MiB 0.121 1 81 ['Trace'] 0.013 Query {} to stage {}{} 21. 2668 0.015 4.33 MiB 0.122 1 81 ['Trace'] 0.013 Query {} from stage {} to stage {}{} 22. 2537 0.014 667.09 KiB 0.018 1 18 ['Trace'] 0 {}Keys: {}, datatype: {}, kind: {}, strictness: {}, right header: {} 23. 2537 0.014 197.98 KiB 0.005 1 18 ['Trace'] 0 {}Join data is being destroyed, {} bytes and {} rows in hash table 24. 2469 0.013 69.89 KiB 0.002 1 73 ['Debug'] 0 Processed in {} sec. 25. 2426 0.013 2.12 MiB 0.06 1 87 ['Debug'] 0.972 Objects with paths [{}] were removed from S3 26. 2422 0.013 108.04 KiB 0.003 1 1 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 27. 2270 0.012 2.82 MiB 0.08 1 71 ['Debug'] 0.994 metadata and objects were removed for [{}], only metadata were removed for [{}]. 28. 2262 0.012 329.35 KiB 0.009 1 235 ['Debug'] 0 Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.) 29. 2262 0.012 111.57 KiB 0.003 1 235 ['Trace'] 0 Merging partially aggregated blocks (bucket = {}). 30. 2145 0.012 124.47 KiB 0.003 14 14 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 31. 2145 0.012 77.00 KiB 0.002 14 14 ['Trace'] 1 Flushed system log up to offset {} 32. 2073 0.011 279.37 KiB 0.008 1 138 ['Information'] 0 Sorting and writing part of data into temporary file {} 33. 2073 0.011 361.40 KiB 0.01 1 136 ['Information'] 0 Done writing part of data into temporary file {}, compressed {}, uncompressed {} 34. 1730 0.009 137.93 KiB 0.004 1 60 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 35. 1582 0.009 154.49 KiB 0.004 1 35 ['Trace'] 0.177 PREWHERE condition was split into {} steps: {} 36. 1526 0.008 81.76 KiB 0.002 1 79 ['Debug'] 0.376 Peak memory usage{}: {}. 37. 1460 0.008 119.14 KiB 0.003 824 399 ['Trace'] 0 No space left in cache to reserve {} bytes, will continue without cache download 38. 1456 0.008 119.72 KiB 0.003 1 508 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 39. 1287 0.007 58.59 KiB 0.002 1 615 ['Debug'] 0 Aggregated. {} to {} rows (from {}) 40. 1274 0.007 160.38 KiB 0.004 1 2 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 41. 1221 0.007 23.85 KiB 0.001 1 609 ['Trace'] 0 Aggregating in order 42. 1203 0.007 141.02 KiB 0.004 1 17 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 43. 1143 0.006 96.49 KiB 0.003 3 80 ['Debug'] 0.995 {} Authenticating user '{}' from {} 44. 1143 0.006 128.36 KiB 0.004 3 80 ['Debug'] 0.995 {} Authenticated with global context as user {} 45. 1137 0.006 124.36 KiB 0.003 2 74 ['Debug'] 1 {} Creating session context with user_id: {} 46. 1131 0.006 99.40 KiB 0.003 3 76 ['Debug'] 0.995 {} Logout, user_id: {} 47. 945 0.005 33.22 KiB 0.001 1 62 ['Trace'] 0 Skipping inserting block with {} rows 48. 794 0.004 29.28 KiB 0.001 2 73 ['Trace'] 1 TCP Request. Address: {} 49. 794 0.004 68.40 KiB 0.002 1 73 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 50. 762 0.004 30.51 KiB 0.001 1 347 ['Trace'] 0 Converting aggregation data to two-level. 51. 747 0.004 19.70 KiB 0.001 1 69 ['Debug'] 1 Done processing connection. 52. 651 0.004 19.64 KiB 0.001 66 60 ['Debug'] 0.054 Key condition: {} 53. 645 0.004 75.33 KiB 0.002 64 58 ['Debug'] 0.054 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 54. 579 0.003 31.29 KiB 0.001 29 358 ['Debug'] 0.995 Selected {} parts from {} to {} 55. 566 0.003 47.66 KiB 0.001 1 18 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {} 56. 566 0.003 19.34 KiB 0.001 1 18 ['Debug'] 0 Selected MergeAlgorithm: {} 57. 565 0.003 37.59 KiB 0.001 27 18 ['Trace'] 0 Merged {} parts: [{}, {}] -> {} 58. 565 0.003 74.43 KiB 0.002 1 18 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec. 59. 555 0.003 28.73 KiB 0.001 50 50 ['Trace'] 0.063 Spreading mark ranges among streams (default reading) 60. 536 0.003 20.95 KiB 0.001 49 46 ['Debug'] 0.065 Reading approx. {} rows with {} streams 61. 506 0.003 15.78 KiB 0 1 46 ['Debug'] 0.069 min_marks_for_concurrent_read={} 62. 500 0.003 102.61 KiB 0.003 23 8 ['Information'] 1 {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 63. 485 0.003 28.00 KiB 0.001 2 6 ['Trace'] 0.988 Loading config file '{}'. 64. 458 0.002 59.29 KiB 0.002 83 74 ['Debug'] 0.985 Removing {} parts from filesystem (serially): Parts: [{}] 65. 445 0.002 33.37 KiB 0.001 5 311 ['Trace'] 0 Used generic exclusion search over index for part {} with {} steps 66. 417 0.002 57.10 KiB 0.002 1 76 ['Trace'] 0.693 Single part upload has completed. {}, size {} 67. 417 0.002 52.89 KiB 0.001 1 53 ['Trace'] 0.693 finalizeImpl WriteBufferFromS3. {}. 68. 417 0.002 50.04 KiB 0.001 1 53 ['Trace'] 0.693 Close WriteBufferFromS3. {}. 69. 417 0.002 105.40 KiB 0.003 1 53 ['Trace'] 0.693 Create WriteBufferFromS3, {} 70. 391 0.002 69.56 KiB 0.002 2 39 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {} 71. 391 0.002 158.75 KiB 0.004 2 39 ['Trace'] 1 Request URI: {} 72. 390 0.002 46.80 KiB 0.001 18 10 ['Debug'] 0.982 Removing {} parts from memory: Parts: [{}] 73. 390 0.002 46.42 KiB 0.001 18 10 ['Trace'] 0.982 Found {} old parts to remove. Parts: [{}] 74. 380 0.002 7.79 KiB 0 2 39 ['Debug'] 0.126 Done processing query 75. 361 0.002 7.95 KiB 0 33 265 ['Trace'] 1 Execution took {} ms. 76. 337 0.002 26.00 KiB 0.001 1 43 ['Trace'] 0 Query span trace_id for opentelemetry log: {} 77. 310 0.002 28.87 KiB 0.001 1 169 ['Debug'] 0 Merge sorted {} blocks, {} rows in {} sec., {} rows/sec., {}/sec 78. 308 0.002 10.68 KiB 0 11 47 ['Debug'] 0.114 MinMax index condition: {} 79. 298 0.002 15.17 KiB 0 22 80 ['Trace'] 0 Connecting. Database: {}. User: {}{}{} 80. 292 0.002 13.12 KiB 0 21 82 ['Trace'] 0 Connected to {} server version {}.{}.{}. 81. 286 0.002 45.89 KiB 0.001 21 78 ['Debug'] 0 Sent data for {} scalars, total {} rows in {} sec., {} rows/sec., {} ({}/sec.), compressed {} times to {} ({}/sec.) 82. 282 0.002 5.79 KiB 0 1 223 ['Debug'] 1 Stop worker in {} 83. 282 0.002 8.82 KiB 0 1 131 ['Debug'] 0.645 Spawn loader worker #{} in {} 84. 282 0.002 19.02 KiB 0.001 1 34 ['Debug'] 0.138 Schedule load job '{}' into {} 85. 282 0.002 18.19 KiB 0.001 1 116 ['Debug'] 1 Execute load job '{}' in {} 86. 282 0.002 19.29 KiB 0.001 1 116 ['Debug'] 1 Finish load job '{}' with status {} 87. 281 0.002 29.17 KiB 0.001 1 20 ['Debug'] 0 Before join block: '{}' 88. 281 0.002 21.94 KiB 0.001 1 34 ['Debug'] 0.135 Prioritize load job '{}': {} -> {} 89. 281 0.002 58.84 KiB 0.002 1 20 ['Debug'] 0 After join block: '{}' 90. 267 0.001 6.00 KiB 0 1 222 ['Trace'] 0 Merging aggregated data 91. 244 0.001 19.78 KiB 0.001 1 16 ['Information'] 0 Write-through cache is stopped as cache limit is reached and nothing can be evicted 92. 244 0.001 97.11 KiB 0.003 1 16 ['Debug'] 0 Failed to reserve space in cache (size: {}, file segment info: {} 93. 216 0.001 15.74 KiB 0 1 37 ['Trace'] 0.162 The min valid primary key position for moving to the tail of PREWHERE is {} 94. 213 0.001 17.20 KiB 0 1 185 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={} 95. 212 0.001 6.16 KiB 0 7 171 ['Trace'] 0 Found {} range in {} steps 96. 212 0.001 6.45 KiB 0 7 171 ['Trace'] 0 Found (RIGHT) boundary mark: {} 97. 212 0.001 14.45 KiB 0 7 171 ['Trace'] 0 Running binary search on index range for part {} ({} marks) 98. 212 0.001 6.23 KiB 0 7 171 ['Trace'] 0 Found (LEFT) boundary mark: {} 99. 210 0.001 6.97 KiB 0 1 130 ['Debug'] 0.524 Change current priority: {} -> {} 100. 209 0.001 6.74 KiB 0 1 1 ['Trace'] 1 Received heartbeat for session #{} Top messages without format string (fmt::runtime): count pattern runtime_message line 1. 3 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 22 ('/LoggerWrapper.h',43) 2. 2 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. /build/contrib/llvm-project/libcxx/include/exception:141: std::exception::capture() @ 0x000000 ('/Exception.cpp',222) 3. 2 skippedconfiglatestconfig skipped config 1, latest config 22 ('/LoggerWrapper.h',43) 4. 2 CodeDBExceptionReceivedfromDBExc Code: 241. DB::Exception: Received from 127.0.0.8:9000. DB::Exception: Memory tracker (for query): fault injected. Would use 2.78 MiB (attempt to allocate chunk of 1080943 bytes), maximum: 9.31 GiB: (while reading column SendTiming): (while reading from pa ('/executeQuery.cpp',218) 5. 1 numberofpendingcommitelements number of pending commit elements: 0 ('/LoggerWrapper.h',43) 6. 1 statemachinecommitindexprecommit state machine commit index 0, precommit index 403, last log index 403 ('/LoggerWrapper.h',43) 7. 1 VOTEINITmyidmyrolecandidateterml [VOTE INIT] my id 1, my role candidate, term 3, log idx 403, log term 2, priority (target 1 / mine 1) ('/LoggerWrapper.h',43) 8. 1 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',43) 9. 1 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 10. 1 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',43) 11. 1 Currentlyassignedconfigisnewerth Currently assigned config is newer than some uncomitted config. This can only happen during startup or force recovery. If that is not the case, this is a bug. ('/LoggerWrapper.h',43) 12. 1 StartingClickHousealtinitystable Starting ClickHouse 24.3.5.47.altinitystable (revision: 54484, git hash: b6642564dbf296d6e55b907d7af6c8087470b672, build id: F8C8F9597630BFB71118B9293BCE3FA909726057), PID 2813 ('',0) 13. 1 newconfiglogidxprevlogidxcurconf new config log idx 404, prev log idx 22, cur config log idx 22, prev log idx 1 ('/LoggerWrapper.h',43) 14. 1 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 404 ('/LoggerWrapper.h',43) 15. 1 RaftASIOlistenerinitiatedonunsec Raft ASIO listener initiated on :::9234, unsecured ('/LoggerWrapper.h',43) 16. 1 INITRAFTSERVERcommitindextermele === INIT RAFT SERVER === commit index 0 term 2 election timer allowed log store start 1, end 403 config log idx 22, prev log idx 1 -- ASYNC REPLICATION -- ('/LoggerWrapper.h',43) 17. 1 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 18. 1 detectaconfigurationchangethatis detect a configuration change that is not committed yet at index 1 ('/LoggerWrapper.h',43) 19. 1 startingup starting up ('',0) 20. 1 PRIORITYdecaytargetmine [PRIORITY] decay, target 1 -> 1, mine 1 ('/LoggerWrapper.h',43) 21. 1 Forkedachildprocesstowatch Forked a child process to watch ('',0) 22. 1 newelectiontimeoutrange new election timeout range: 0 - 0 ('/LoggerWrapper.h',43) 23. 1 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',43) 24. 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) 25. 1 prevotetermisdifferentresetitto pre-vote term (0) is different, reset it to 2 ('/LoggerWrapper.h',43) 26. 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) 27. 1 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',43) 28. 1 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1 my id: 1, voting_member num peers: 0 ('/LoggerWrapper.h',43) 29. 1 newconfigurationlogidxprevlogidx new configuration: log idx 404, prev log idx 22 peer 1, DC ID 0, localhost:9234, voting member, 1 my id: 1, leader: 1, term: 3 ('/LoggerWrapper.h',43) Failed to get stats about log messages: timed out 2024-07-22 22:34:26,013 Stress test finished + echo -e 'Test script exit code\tOK\t\N\t' + grep -Fa OK + rg -Fa 'No queries hung' /test_output/test_results.tsv No queries hung OK \N + stop_server + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=2813 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2813. The process with pid = 2813 is running. Sent terminate signal to process with pid 2813. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2813. The process with pid = 2813 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2813. The process with pid = 2813 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2813. The process with pid = 2813 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2813. The process with pid = 2813 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2813. The process with pid = 2813 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2813. The process with pid = 2813 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2813. The process with pid = 2813 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2813. The process with pid = 2813 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 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 127.0.0.1 - - [22/Jul/2024:20:34:37 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [22/Jul/2024:20:34:37 +0000] "PUT /devstoreaccount1/cont/aottudbcksmzcfhsmoyebtrjfctlbrui?blockid=xgrmeawdadllaffhquyjsoeneajnizylttfgbalpmidxizogioggoticntqqeqsl&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:20:34:37 +0000] "PUT /devstoreaccount1/cont/aottudbcksmzcfhsmoyebtrjfctlbrui?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [22/Jul/2024:20:34:37 +0000] "GET /devstoreaccount1/cont/aottudbcksmzcfhsmoyebtrjfctlbrui HTTP/1.1" 206 4 127.0.0.1 - - [22/Jul/2024:20:34:37 +0000] "GET /devstoreaccount1/cont/aottudbcksmzcfhsmoyebtrjfctlbrui HTTP/1.1" 206 2 127.0.0.1 - - [22/Jul/2024:20:34:37 +0000] "DELETE /devstoreaccount1/cont/aottudbcksmzcfhsmoyebtrjfctlbrui HTTP/1.1" 202 - + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' 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 9516 + 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=9516 + 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 = 9516. The process with pid = 9516 is running. Sent terminate signal to process with pid 9516. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 9516. The process with pid = 9516 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 9516. The process with pid = 9516 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 9516. The process with pid = 9516 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 9516. The process with pid = 9516 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 9516. The process with pid = 9516 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 9516. The process with pid = 9516 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 9516. The process with pid = 9516 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 9516. The process with pid = 9516 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 9516. The process with pid = 9516 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 9516. The process with pid = 9516 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 9516. The process with pid = 9516 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 9516. The process with pid = 9516 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 + grep -v a.myext + 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 + echo -e 'No lost s3 keys\tOK\t\N\t' + grep SharedMergeTreePartCheckThread + rg -Fa 'it is lost forever' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No SharedMergeTree lost forever in clickhouse-server.log\tOK\t\N\t' + '[' -s /test_output/no_such_key_errors.txt ']' + rm /test_output/no_such_key_errors.txt + rg -Fa '########################################' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'Not crashed\tOK\t\N\t' + rg -Fa ' ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No fatal messages in clickhouse-server.log\tOK\t\N\t' + '[' -s /test_output/fatal_messages.txt ']' + rm /test_output/fatal_messages.txt + rg -Faz '########################################' /test_output/gdb.log /test_output/stress_run_logs.tar.zst /test_output/test_results.tsv + rg -Fa ' received signal ' /test_output/gdb.log + dmesg -T + grep -q -F -e 'Out of memory: Killed process' -e 'oom_reaper: reaped process' -e oom-kill:constraint=CONSTRAINT_NONE /test_output/dmesg.log + echo -e 'No OOM in dmesg\tOK\t\N\t' + tar -chf /test_output/coordination.tar /var/lib/clickhouse/coordination tar: Removing leading `/' from member names tar: Removing leading `/' from hard link targets + collect_query_and_trace_logs + for table in query_log trace_log + clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.query_log format TSVWithNamesAndTypes' + zstd --threads=0 Processing configuration file '/etc/clickhouse-server/config.xml'. Merging configuration file '/etc/clickhouse-server/config.d/CORS.xml'. Merging configuration file '/etc/clickhouse-server/config.d/asynchronous_metrics_update_period_s.xml'. Merging configuration file '/etc/clickhouse-server/config.d/azure_storage_conf.xml'. Merging configuration file '/etc/clickhouse-server/config.d/backoff_failed_mutation.xml'. Merging configuration file '/etc/clickhouse-server/config.d/backups.xml'. Merging configuration file '/etc/clickhouse-server/config.d/blob_storage_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/block_number.xml'. Merging configuration file '/etc/clickhouse-server/config.d/clusters.xml'. Merging configuration file '/etc/clickhouse-server/config.d/compressed_marks_and_index.xml'. Merging configuration file '/etc/clickhouse-server/config.d/core.xml'. Merging configuration file '/etc/clickhouse-server/config.d/custom_disks_base_path.xml'. Merging configuration file '/etc/clickhouse-server/config.d/custom_settings_prefixes.xml'. Merging configuration file '/etc/clickhouse-server/config.d/database_atomic.xml'. Merging configuration file '/etc/clickhouse-server/config.d/disable_s3_env_credentials.xml'. Merging configuration file '/etc/clickhouse-server/config.d/display_name.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_access_control_improvements.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_keeper_map.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_wait_for_shutdown_replicated_tables.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_zero_copy_replication.xml'. Merging configuration file '/etc/clickhouse-server/config.d/encryption.xml'. Merging configuration file '/etc/clickhouse-server/config.d/filesystem_cache_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/filesystem_caches_path.xml'. Merging configuration file '/etc/clickhouse-server/config.d/forbidden_headers.xml'. Merging configuration file '/etc/clickhouse-server/config.d/graphite.xml'. Merging configuration file '/etc/clickhouse-server/config.d/graphite_alternative.xml'. Merging configuration file '/etc/clickhouse-server/config.d/handlers.yaml'. Merging configuration file '/etc/clickhouse-server/config.d/keeper_port.xml'. Merging configuration file '/etc/clickhouse-server/config.d/legacy_geobase.xml'. Merging configuration file '/etc/clickhouse-server/config.d/listen.xml'. Merging configuration file '/etc/clickhouse-server/config.d/logger_trace.xml'. Merging configuration file '/etc/clickhouse-server/config.d/logging_no_rotate.xml'. Merging configuration file '/etc/clickhouse-server/config.d/lost_forever_check.xml'. Merging configuration file '/etc/clickhouse-server/config.d/macros.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_concurrent_queries.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_num_to_warn.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_server_memory_usage.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree_old_dirs_cleanup.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree_settings.xml'. Merging configuration file '/etc/clickhouse-server/config.d/named_collection.xml'. Merging configuration file '/etc/clickhouse-server/config.d/nlp.xml'. Merging configuration file '/etc/clickhouse-server/config.d/prometheus.xml'. Merging configuration file '/etc/clickhouse-server/config.d/query_masking_rules.xml'. Merging configuration file '/etc/clickhouse-server/config.d/query_masking_rules.xml_original.xml'. Merging configuration file '/etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml'. Merging configuration file '/etc/clickhouse-server/config.d/secure_ports.xml'. Merging configuration file '/etc/clickhouse-server/config.d/session_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/ssl_certs.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02944.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02961.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02963.xml'. Merging configuration file '/etc/clickhouse-server/config.d/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 - - [22/Jul/2024:20:36:44 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - + for table in query_log trace_log + clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.trace_log format TSVWithNamesAndTypes' + zstd --threads=0 Processing configuration file '/etc/clickhouse-server/config.xml'. Merging configuration file '/etc/clickhouse-server/config.d/CORS.xml'. Merging configuration file '/etc/clickhouse-server/config.d/asynchronous_metrics_update_period_s.xml'. Merging configuration file '/etc/clickhouse-server/config.d/azure_storage_conf.xml'. Merging configuration file '/etc/clickhouse-server/config.d/backoff_failed_mutation.xml'. Merging configuration file '/etc/clickhouse-server/config.d/backups.xml'. Merging configuration file '/etc/clickhouse-server/config.d/blob_storage_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/block_number.xml'. Merging configuration file '/etc/clickhouse-server/config.d/clusters.xml'. Merging configuration file '/etc/clickhouse-server/config.d/compressed_marks_and_index.xml'. Merging configuration file '/etc/clickhouse-server/config.d/core.xml'. Merging configuration file '/etc/clickhouse-server/config.d/custom_disks_base_path.xml'. Merging configuration file '/etc/clickhouse-server/config.d/custom_settings_prefixes.xml'. Merging configuration file '/etc/clickhouse-server/config.d/database_atomic.xml'. Merging configuration file '/etc/clickhouse-server/config.d/disable_s3_env_credentials.xml'. Merging configuration file '/etc/clickhouse-server/config.d/display_name.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_access_control_improvements.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_keeper_map.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_wait_for_shutdown_replicated_tables.xml'. Merging configuration file '/etc/clickhouse-server/config.d/enable_zero_copy_replication.xml'. Merging configuration file '/etc/clickhouse-server/config.d/encryption.xml'. Merging configuration file '/etc/clickhouse-server/config.d/filesystem_cache_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/filesystem_caches_path.xml'. Merging configuration file '/etc/clickhouse-server/config.d/forbidden_headers.xml'. Merging configuration file '/etc/clickhouse-server/config.d/graphite.xml'. Merging configuration file '/etc/clickhouse-server/config.d/graphite_alternative.xml'. Merging configuration file '/etc/clickhouse-server/config.d/handlers.yaml'. Merging configuration file '/etc/clickhouse-server/config.d/keeper_port.xml'. Merging configuration file '/etc/clickhouse-server/config.d/legacy_geobase.xml'. Merging configuration file '/etc/clickhouse-server/config.d/listen.xml'. Merging configuration file '/etc/clickhouse-server/config.d/logger_trace.xml'. Merging configuration file '/etc/clickhouse-server/config.d/logging_no_rotate.xml'. Merging configuration file '/etc/clickhouse-server/config.d/lost_forever_check.xml'. Merging configuration file '/etc/clickhouse-server/config.d/macros.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_concurrent_queries.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_num_to_warn.xml'. Merging configuration file '/etc/clickhouse-server/config.d/max_server_memory_usage.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree_old_dirs_cleanup.xml'. Merging configuration file '/etc/clickhouse-server/config.d/merge_tree_settings.xml'. Merging configuration file '/etc/clickhouse-server/config.d/named_collection.xml'. Merging configuration file '/etc/clickhouse-server/config.d/nlp.xml'. Merging configuration file '/etc/clickhouse-server/config.d/prometheus.xml'. Merging configuration file '/etc/clickhouse-server/config.d/query_masking_rules.xml'. Merging configuration file '/etc/clickhouse-server/config.d/query_masking_rules.xml_original.xml'. Merging configuration file '/etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml'. Merging configuration file '/etc/clickhouse-server/config.d/secure_ports.xml'. Merging configuration file '/etc/clickhouse-server/config.d/session_log.xml'. Merging configuration file '/etc/clickhouse-server/config.d/ssl_certs.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02944.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02961.xml'. Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02963.xml'. Merging configuration file '/etc/clickhouse-server/config.d/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 - - [22/Jul/2024:20:37:00 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - + mv /var/log/clickhouse-server/stderr.log /test_output/ + clickhouse-local --structure 'test String, res String, time Nullable(Float32), desc String' -q 'SELECT '\''failure'\'', test FROM table WHERE res != '\''OK'\'' order by (test like '\''%Sanitizer%'\'') DESC, (test like '\''%Killed by signal%'\'') DESC, (test like '\''%gdb.log%'\'') DESC, (test ilike '\''%possible deadlock%'\'') DESC, (test like '\''%start%'\'') DESC, (test like '\''%dmesg%'\'') DESC, (test like '\''%OOM%'\'') DESC, (test like '\''%Signal 9%'\'') DESC, (test like '\''%Fatal message%'\'') DESC, rowNumberInAllBlocks() LIMIT 1' + '[' -s /test_output/check_status.tsv ']' + echo -e 'success\tNo errors found' + rg 'OOM in dmesg|Signal 9' /test_output/check_status.tsv + collect_core_dumps + read -r core + find . -type f -maxdepth 1 -name 'core.*'