+ ln -s /usr/share/clickhouse-test/ci/stress.py /usr/bin/stress + ln -s /usr/share/clickhouse-test/clickhouse-test /usr/bin/clickhouse-test + source /attach_gdb.lib ++ source /utils.lib +++ sysctl kernel.core_pattern=core.%e.%p-%P kernel.core_pattern = core.%e.%p-%P +++ sysctl fs.suid_dumpable=1 fs.suid_dumpable = 1 + source /stress_tests.lib ++ OK='\tOK\t\N\t' ++ FAIL='\tFAIL\t\N\t' ++ FAILURE_CONTEXT_LINES=100 ++ FAILURE_CONTEXT_MAX_LINE_WIDTH=300 + source /utils.lib ++ sysctl kernel.core_pattern=core.%e.%p-%P kernel.core_pattern = core.%e.%p-%P ++ sysctl fs.suid_dumpable=1 fs.suid_dumpable = 1 + install_packages package_folder + dpkg -i package_folder/clickhouse-common-static_24.8.11.51000.altinitytest+tsan_amd64.deb Selecting previously unselected package clickhouse-common-static. (Reading database ... 48692 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static_24.8.11.51000.altinitytest+tsan_amd64.deb ... Unpacking clickhouse-common-static (24.8.11.51000.altinitytest+tsan) ... Setting up clickhouse-common-static (24.8.11.51000.altinitytest+tsan) ... + dpkg -i package_folder/clickhouse-common-static-dbg_24.8.11.51000.altinitytest+tsan_amd64.deb Selecting previously unselected package clickhouse-common-static-dbg. (Reading database ... 48719 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static-dbg_24.8.11.51000.altinitytest+tsan_amd64.deb ... Unpacking clickhouse-common-static-dbg (24.8.11.51000.altinitytest+tsan) ... Setting up clickhouse-common-static-dbg (24.8.11.51000.altinitytest+tsan) ... + dpkg -i package_folder/clickhouse-server_24.8.11.51000.altinitytest+tsan_amd64.deb Selecting previously unselected package clickhouse-server. (Reading database ... 48726 files and directories currently installed.) Preparing to unpack .../clickhouse-server_24.8.11.51000.altinitytest+tsan_amd64.deb ... Unpacking clickhouse-server (24.8.11.51000.altinitytest+tsan) ... Setting up clickhouse-server (24.8.11.51000.altinitytest+tsan) ... ClickHouse binary is already located at /usr/bin/clickhouse Symlink /usr/bin/clickhouse-server already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-server to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-client to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-local to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-benchmark to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-obfuscator to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-git-import to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-compressor to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-format to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-extract-from-config already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-extract-from-config to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-keeper already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-keeper-converter already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper-converter to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-disks to /usr/bin/clickhouse. Creating symlink /usr/bin/ch to /usr/bin/clickhouse. Creating symlink /usr/bin/chl to /usr/bin/clickhouse. Creating symlink /usr/bin/chc to /usr/bin/clickhouse. Creating clickhouse group if it does not exist. groupadd -r clickhouse Creating clickhouse user if it does not exist. useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse clickhouse Will set ulimits for clickhouse user in /etc/security/limits.d/clickhouse.conf. Creating config directory /etc/clickhouse-server/config.d that is used for tweaks of main server configuration. Creating config directory /etc/clickhouse-server/users.d that is used for tweaks of users configuration. Config file /etc/clickhouse-server/config.xml already exists, will keep it and extract path info from it. /etc/clickhouse-server/config.xml has /var/lib/clickhouse/ as data path. /etc/clickhouse-server/config.xml has /var/log/clickhouse-server/ as log path. Users config file /etc/clickhouse-server/users.xml already exists, will keep it and extract users info from it. Log directory /var/log/clickhouse-server/ already exists. Creating data directory /var/lib/clickhouse/. Creating pid directory /var/run/clickhouse-server. chown -R clickhouse:clickhouse '/var/log/clickhouse-server/' chown -R clickhouse:clickhouse '/var/run/clickhouse-server' chown clickhouse:clickhouse '/var/lib/clickhouse/' Password for the default user is an empty string. See /etc/clickhouse-server/users.xml and /etc/clickhouse-server/users.d to change it. Setting capabilities for clickhouse binary. This is optional. chown -R clickhouse:clickhouse '/etc/clickhouse-server' ClickHouse has been successfully installed. Start clickhouse-server with: sudo clickhouse start Start clickhouse-client with: clickhouse-client + dpkg -i package_folder/clickhouse-client_24.8.11.51000.altinitytest+tsan_amd64.deb Selecting previously unselected package clickhouse-client. (Reading database ... 48743 files and directories currently installed.) Preparing to unpack .../clickhouse-client_24.8.11.51000.altinitytest+tsan_amd64.deb ... Unpacking clickhouse-client (24.8.11.51000.altinitytest+tsan) ... Setting up clickhouse-client (24.8.11.51000.altinitytest+tsan) ... + export THREAD_FUZZER_CPU_TIME_PERIOD_US=1000 + THREAD_FUZZER_CPU_TIME_PERIOD_US=1000 + export THREAD_FUZZER_SLEEP_PROBABILITY=0.1 + THREAD_FUZZER_SLEEP_PROBABILITY=0.1 + export THREAD_FUZZER_SLEEP_TIME_US_MAX=100000 + THREAD_FUZZER_SLEEP_TIME_US_MAX=100000 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01 + THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01 + export THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01 + THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01 + export ZOOKEEPER_FAULT_INJECTION=1 + ZOOKEEPER_FAULT_INJECTION=1 + configure + export USE_DATABASE_ORDINARY=1 + USE_DATABASE_ORDINARY=1 + export EXPORT_S3_STORAGE_POLICIES=1 + EXPORT_S3_STORAGE_POLICIES=1 + /usr/share/clickhouse-test/config/install.sh + DEST_SERVER_PATH=/etc/clickhouse-server + DEST_CLIENT_PATH=/etc/clickhouse-client +++ dirname /usr/share/clickhouse-test/config/install.sh ++ cd /usr/share/clickhouse-test/config ++ pwd -P + SRC_PATH=/usr/share/clickhouse-test/config + echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server' Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + mkdir -p /etc/clickhouse-server/config.d/ + mkdir -p /etc/clickhouse-server/users.d/ + mkdir -p /etc/clickhouse-client + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_catalog_drop_table_concurrency.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/grpc_protocol.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/block_number.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/serverwide_trace_collector.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/rocksdb.xml /etc/clickhouse-server/config.d/ + '[' /etc/clickhouse-server = /etc/clickhouse-server ']' + ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/ + ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + rm -f /etc/clickhouse-server/config.d/zookeeper.xml + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/ + [[ -n '' ]] + rm -f /etc/clickhouse-server/config.d/cannot_allocate_thread_injection.xml + value=0 + sed --follow-symlinks -i 's|[01]|0|' /etc/clickhouse-server/config.d/keeper_port.xml + value=17788928 + sed --follow-symlinks -i 's|[[:digit:]]\+|17788928|' /etc/clickhouse-server/config.d/keeper_port.xml + value=57604096 + sed --follow-symlinks -i 's|[[:digit:]]\+|57604096|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/ + [[ '' == \1 ]] + [[ '' == \1 ]] + [[ -n 1 ]] + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|100000|10000|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value filtered_list keeper_port + value=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value multi_read keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value check_not_exists keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value create_if_not_exists keeper_port + value=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value use_compression zookeeper_fault_injection + value=0 + sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + randomize_config_boolean_value enable_block_number_column block_number + value=1 + sudo cat /etc/clickhouse-server/config.d/block_number.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml + randomize_config_boolean_value enable_block_offset_column block_number + value=0 + sudo cat /etc/clickhouse-server/config.d/block_number.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml + echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\''' + export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + sudo chown root: /var/lib/clickhouse + local total_mem ++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo + total_mem=32086436 + total_mem=32856510464 + 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=9856953139 + echo 'Setting max_memory_usage_for_user=9856953139 and max_memory_usage for queries to 10G' + cat Setting max_memory_usage_for_user=9856953139 and max_memory_usage for queries to 10G + cat + ./setup_minio.sh stateless + azurite-blob --blobHost 0.0.0.0 --blobPort 10000 --debug /azurite_log + export MINIO_ROOT_USER=clickhouse + MINIO_ROOT_USER=clickhouse + export MINIO_ROOT_PASSWORD=clickhouse + MINIO_ROOT_PASSWORD=clickhouse + main stateless + local query_dir ++ check_arg stateless ++ local query_dir ++ '[' '!' 1 -eq 1 ']' ++ case "$1" in ++ query_dir=0_stateless ++ echo 0_stateless + query_dir=0_stateless + '[' '!' -f ./minio ']' + start_minio + mkdir -p ./minio_data + ./minio --version minio version RELEASE.2024-08-03T04-33-23Z (commit-id=6efb56851c40da88d1ca15112e2d686a4ecec6b3) Runtime: go1.22.5 linux/amd64 License: GNU AGPLv3 - https://www.gnu.org/licenses/agpl-3.0.html Copyright: 2015-2024 MinIO, Inc. + wait_for_it + ./minio server --address :11111 ./minio_data + local counter=0 + local max_counter=60 + local url=http://localhost:11111 + params=('--silent' '--verbose') + local params + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 0 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio (node:257) [DEP0040] DeprecationWarning: The `punycode` module is deprecated. Please use a userland alternative instead. (Use `node --trace-deprecation ...` to show where the warning was created) Azurite Blob service is starting on 0.0.0.0:10000 Azurite Blob service successfully listens on http://0.0.0.0:10000 INFO: Formatting 1st pool, 1 set(s), 1 drives per set. INFO: WARNING: Host local has more than 0 drives of set. A host failure will result in data becoming unavailable. MinIO Object Storage Server Copyright: 2015-2025 MinIO, Inc. License: GNU AGPLv3 - https://www.gnu.org/licenses/agpl-3.0.html Version: RELEASE.2024-08-03T04-33-23Z (go1.22.5 linux/amd64) API: http://172.17.0.2:11111 http://127.0.0.1:11111 WebUI: http://172.17.0.2:42381 http://127.0.0.1:42381 Docs: https://min.io/docs/minio/linux/index.html + counter=1 + curl --silent --verbose http://localhost:11111 + grep AccessDenied AccessDeniedAccess Denied./1820CE1C70F20E137dc7eb22d3288ec80374614e9088e31d3668a6922ead55932dd2a8e56373820f + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 283 root 6u IPv6 15277 0t0 TCP *:11111 (LISTEN) minio 283 root 9u IPv4 15276 0t0 TCP localhost:11111 (LISTEN) minio 283 root 10u IPv6 15278 0t0 TCP localhost:11111 (LISTEN) + sleep 5 + setup_minio stateless + local test_type=stateless + ./mc alias set clickminio http://localhost:11111 clickhouse clickhouse Added `clickminio` successfully. + ./mc admin user add clickminio test testtest Added user `test` successfully. + ./mc admin policy attach clickminio readwrite --user=test Attached Policies: [readwrite] To User: test + ./mc mb --ignore-existing clickminio/test Bucket created successfully `clickminio/test`. + '[' stateless = stateless ']' + ./mc anonymous set public clickminio/test Access permission for `clickminio/test` is set to `public` + upload_data 0_stateless /usr/share/clickhouse-test + local query_dir=0_stateless + local test_path=/usr/share/clickhouse-test + local data_path=/usr/share/clickhouse-test/queries/0_stateless/data_minio + '[' -d /usr/share/clickhouse-test/queries/0_stateless/data_minio ']' + ./mc cp --recursive /usr/share/clickhouse-test/queries/0_stateless/data_minio/ clickminio/test/ `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl` -> `clickminio/test/02366_data.jsonl` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02876.parquet` -> `clickminio/test/02876.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet` -> `clickminio/test/02731.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive1.tar` -> `clickminio/test/03036_archive1.tar` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow` -> `clickminio/test/02731.arrow` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive1.zip` -> `clickminio/test/03036_archive1.zip` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive2.tar` -> `clickminio/test/03036_archive2.tar` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive2.zip` -> `clickminio/test/03036_archive2.zip` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive3.tar.gz` -> `clickminio/test/03036_archive3.tar.gz` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_compressed_file_archive.zip` -> `clickminio/test/03036_compressed_file_archive.zip` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_json_archive.zip` -> `clickminio/test/03036_json_archive.zip` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv` -> `clickminio/test/a.tsv` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv` -> `clickminio/test/b.tsv` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv` -> `clickminio/test/c.tsv` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/hive_partitioning/column0=Elizabeth/column1=Gordon/sample.parquet` -> `clickminio/test/hive_partitioning/column0=Elizabeth/column1=Gordon/sample.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/hive_partitioning/column0=Elizabeth/column1=Schmidt/sample.parquet` -> `clickminio/test/hive_partitioning/column0=Elizabeth/column1=Schmidt/sample.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/hive_partitioning/column0=Elizabeth/sample.parquet` -> `clickminio/test/hive_partitioning/column0=Elizabeth/sample.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/hive_partitioning/non_existing_column=Elizabeth/sample.parquet` -> `clickminio/test/hive_partitioning/non_existing_column=Elizabeth/sample.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/json_data` -> `clickminio/test/json_data` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv` -> `clickminio/test/tsv_with_header.tsv` Total: 5.42 MiB, Transferred: 5.42 MiB, Speed: 125.24 MiB/s + setup_aws_credentials + local minio_root_user=clickhouse + local minio_root_password=clickhouse + mkdir -p /root/.aws + cat + config_logs_export_cluster /etc/clickhouse-server/config.d/system_logs_export.yaml + set +x File /tmp/export-logs-config.sh does not exist, do not setup + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 127.0.0.1 - - [03/Feb/2025:20:54:47 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 404 - 127.0.0.1 - - [03/Feb/2025:20:54:47 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [03/Feb/2025:20:54:47 +0000] "PUT /devstoreaccount1/cont/kfblwaxtcmumsiqhlxbmrxxeymdcryeh HTTP/1.1" 201 - 127.0.0.1 - - [03/Feb/2025:20:54:47 +0000] "GET /devstoreaccount1/cont/kfblwaxtcmumsiqhlxbmrxxeymdcryeh HTTP/1.1" 206 4 127.0.0.1 - - [03/Feb/2025:20:54:47 +0000] "GET /devstoreaccount1/cont/kfblwaxtcmumsiqhlxbmrxxeymdcryeh HTTP/1.1" 206 2 127.0.0.1 - - [03/Feb/2025:20:54:47 +0000] "DELETE /devstoreaccount1/cont/kfblwaxtcmumsiqhlxbmrxxeymdcryeh HTTP/1.1" 202 - + counter=4 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ [[ hxB =~ e ]] ++ set_e=false ++ set +e ++ local total_retries=5 ++ shift ++ local retry=0 ++ '[' 0 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ false ++ return + IS_ASAN=0 + [[ 0 = \1 ]] ++ kill -l SIGRTMIN + RTMIN=34 + echo ' set follow-fork-mode parent handle SIGHUP nostop noprint pass handle SIGINT nostop noprint pass handle SIGQUIT nostop noprint pass handle SIGPIPE nostop noprint pass handle SIGTERM nostop noprint pass handle SIGUSR1 nostop noprint pass handle SIGUSR2 nostop noprint pass handle SIG34 nostop noprint pass info signals continue backtrace full info registers p top' 1 KiB of the 'stack: p/x *(uint64_t[128]*)$sp maintenance info sections thread apply all backtrace full disassemble /s up disassemble /s up disassemble /s p "done" detach quit ' + sleep 5 + ts '%Y-%m-%d %H:%M:%S' ++ cat /var/run/clickhouse-server/clickhouse-server.pid + gdb -batch -command script.gdb -p 423 + 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=423 + 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 = 423. The process with pid = 423 is running. Sent terminate signal to process with pid 423. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 423. The process with pid = 423 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 423. The process with pid = 423 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 423. The process with pid = 423 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 423. The process with pid = 423 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 423. The process with pid = 423 is running. Waiting for server to stop Found pid = 423 in the list of running processes. The process with pid = 423 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.initial.log + cache_policy= + '[' 1 -eq 1 ']' + cache_policy=SLRU Using cache policy: SLRU + echo 'Using cache policy: SLRU' + '[' SLRU = SLRU ']' + sudo cat /etc/clickhouse-server/config.d/storage_conf.xml + sed 's|LRU|SLRU|' + mv /etc/clickhouse-server/config.d/storage_conf.xml.tmp /etc/clickhouse-server/config.d/storage_conf.xml + sudo cat /etc/clickhouse-server/users.d/stress_tests_overrides.xml cat: /etc/clickhouse-server/users.d/stress_tests_overrides.xml: No such file or directory + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 127.0.0.1 - - [03/Feb/2025:20:55:19 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - 127.0.0.1 - - [03/Feb/2025:20:55:19 +0000] "PUT /devstoreaccount1/cont/poryyccrpvrivszwnppkdhmdgndkussh HTTP/1.1" 201 - 127.0.0.1 - - [03/Feb/2025:20:55:19 +0000] "GET /devstoreaccount1/cont/poryyccrpvrivszwnppkdhmdgndkussh HTTP/1.1" 206 4 127.0.0.1 - - [03/Feb/2025:20:55:19 +0000] "GET /devstoreaccount1/cont/poryyccrpvrivszwnppkdhmdgndkussh HTTP/1.1" 206 2 127.0.0.1 - - [03/Feb/2025:20:55:19 +0000] "DELETE /devstoreaccount1/cont/poryyccrpvrivszwnppkdhmdgndkussh HTTP/1.1" 202 - + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ [[ hxB =~ e ]] ++ set_e=false ++ set +e ++ local total_retries=5 ++ shift ++ local retry=0 ++ '[' 0 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ false ++ return + IS_ASAN=0 + [[ 0 = \1 ]] ++ kill -l SIGRTMIN + RTMIN=34 + echo ' set follow-fork-mode parent handle SIGHUP nostop noprint pass handle SIGINT nostop noprint pass handle SIGQUIT nostop noprint pass handle SIGPIPE nostop noprint pass handle SIGTERM nostop noprint pass handle SIGUSR1 nostop noprint pass handle SIGUSR2 nostop noprint pass handle SIG34 nostop noprint pass info signals continue backtrace full info registers p top' 1 KiB of the 'stack: p/x *(uint64_t[128]*)$sp maintenance info sections thread apply all backtrace full disassemble /s up disassemble /s up disassemble /s p "done" detach quit ' + sleep 5 + ts '%Y-%m-%d %H:%M:%S' ++ cat /var/run/clickhouse-server/clickhouse-server.pid + gdb -batch -command script.gdb -p 1282 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + clickhouse-client --query 'SHOW TABLES FROM datasets' hits_v1 visits_v1 + clickhouse-client --query 'SHOW TABLES FROM test' + [[ '' == \1 ]] + [[ '' == \1 ]] + TEMP_POLICY=default + clickhouse-client --query 'CREATE TABLE test.hits_s3 (WatchID UInt64, JavaEnable UInt8, Title String, GoodEvent Int16, EventTime DateTime, EventDate Date, CounterID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RegionID UInt32, UserID UInt64, CounterClass Int8, OS UInt8, UserAgent UInt8, URL String, Referer String, URLDomain String, RefererDomain String, Refresh UInt8, IsRobot UInt8, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32), RefererRegions Array(UInt32), ResolutionWidth UInt16, ResolutionHeight UInt16, ResolutionDepth UInt8, FlashMajor UInt8, FlashMinor UInt8, FlashMinor2 String, NetMajor UInt8, NetMinor UInt8, UserAgentMajor UInt16, UserAgentMinor FixedString(2), CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, MobilePhone UInt8, MobilePhoneModel String, Params String, IPNetworkID UInt32, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, IsArtifical UInt8, WindowClientWidth UInt16, WindowClientHeight UInt16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 UInt8, SilverlightVersion2 UInt8, SilverlightVersion3 UInt32, SilverlightVersion4 UInt16, PageCharset String, CodeVersion UInt32, IsLink UInt8, IsDownload UInt8, IsNotBounce UInt8, FUniqID UInt64, HID UInt32, IsOldCounter UInt8, IsEvent UInt8, IsParameter UInt8, DontCountHits UInt8, WithHash UInt8, HitColor FixedString(1), UTCEventTime DateTime, Age UInt8, Sex UInt8, Income UInt8, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), RemoteIP UInt32, RemoteIP6 FixedString(16), WindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage FixedString(2), BrowserCountry FixedString(2), SocialNetwork String, SocialAction String, HTTPError UInt16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, FetchTiming Int32, RedirectTiming Int32, DOMInteractiveTiming Int32, DOMContentLoadedTiming Int32, DOMCompleteTiming Int32, LoadEventStartTiming Int32, LoadEventEndTiming Int32, NSToDOMContentLoadedTiming Int32, FirstPaintTiming Int32, RedirectCount Int8, SocialSourceNetworkID UInt8, SocialSourcePage String, ParamPrice Int64, ParamOrderID String, ParamCurrency FixedString(3), ParamCurrencyID UInt16, GoalsReached Array(UInt32), OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, RefererHash UInt64, URLHash UInt64, CLID UInt32, YCLID UInt64, ShareService String, ShareURL String, ShareTitle String, ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64), IslandID FixedString(16), RequestNum UInt32, RequestTry UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate) ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''default'\''' + clickhouse-client --query 'CREATE TABLE test.hits (WatchID UInt64, JavaEnable UInt8, Title String, GoodEvent Int16, EventTime DateTime, EventDate Date, CounterID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RegionID UInt32, UserID UInt64, CounterClass Int8, OS UInt8, UserAgent UInt8, URL String, Referer String, URLDomain String, RefererDomain String, Refresh UInt8, IsRobot UInt8, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32), RefererRegions Array(UInt32), ResolutionWidth UInt16, ResolutionHeight UInt16, ResolutionDepth UInt8, FlashMajor UInt8, FlashMinor UInt8, FlashMinor2 String, NetMajor UInt8, NetMinor UInt8, UserAgentMajor UInt16, UserAgentMinor FixedString(2), CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, MobilePhone UInt8, MobilePhoneModel String, Params String, IPNetworkID UInt32, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, IsArtifical UInt8, WindowClientWidth UInt16, WindowClientHeight UInt16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 UInt8, SilverlightVersion2 UInt8, SilverlightVersion3 UInt32, SilverlightVersion4 UInt16, PageCharset String, CodeVersion UInt32, IsLink UInt8, IsDownload UInt8, IsNotBounce UInt8, FUniqID UInt64, HID UInt32, IsOldCounter UInt8, IsEvent UInt8, IsParameter UInt8, DontCountHits UInt8, WithHash UInt8, HitColor FixedString(1), UTCEventTime DateTime, Age UInt8, Sex UInt8, Income UInt8, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), RemoteIP UInt32, RemoteIP6 FixedString(16), WindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage FixedString(2), BrowserCountry FixedString(2), SocialNetwork String, SocialAction String, HTTPError UInt16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, FetchTiming Int32, RedirectTiming Int32, DOMInteractiveTiming Int32, DOMContentLoadedTiming Int32, DOMCompleteTiming Int32, LoadEventStartTiming Int32, LoadEventEndTiming Int32, NSToDOMContentLoadedTiming Int32, FirstPaintTiming Int32, RedirectCount Int8, SocialSourceNetworkID UInt8, SocialSourcePage String, ParamPrice Int64, ParamOrderID String, ParamCurrency FixedString(3), ParamCurrencyID UInt16, GoalsReached Array(UInt32), OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, RefererHash UInt64, URLHash UInt64, CLID UInt32, YCLID UInt64, ShareService String, ShareURL String, ShareTitle String, ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64), IslandID FixedString(16), RequestNum UInt32, RequestTry UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate) ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''default'\''' + clickhouse-client --query 'CREATE TABLE test.visits (CounterID UInt32, StartDate Date, Sign Int8, IsNew UInt8, VisitID UInt64, UserID UInt64, StartTime DateTime, Duration UInt32, UTCStartTime DateTime, PageViews Int32, Hits Int32, IsBounce UInt8, Referer String, StartURL String, RefererDomain String, StartURLDomain String, EndURL String, LinkURL String, IsDownload UInt8, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, PlaceID Int32, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32), RefererRegions Array(UInt32), IsYandex UInt8, GoalReachesDepth Int32, GoalReachesURL Int32, GoalReachesAny Int32, SocialSourceNetworkID UInt8, SocialSourcePage String, MobilePhoneModel String, ClientEventTime DateTime, RegionID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RemoteIP UInt32, RemoteIP6 FixedString(16), IPNetworkID UInt32, SilverlightVersion3 UInt32, CodeVersion UInt32, ResolutionWidth UInt16, ResolutionHeight UInt16, UserAgentMajor UInt16, UserAgentMinor UInt16, WindowClientWidth UInt16, WindowClientHeight UInt16, SilverlightVersion2 UInt8, SilverlightVersion4 UInt16, FlashVersion3 UInt16, FlashVersion4 UInt16, ClientTimeZone Int16, OS UInt8, UserAgent UInt8, ResolutionDepth UInt8, FlashMajor UInt8, FlashMinor UInt8, NetMajor UInt8, NetMinor UInt8, MobilePhone UInt8, SilverlightVersion1 UInt8, Age UInt8, Sex UInt8, Income UInt8, JavaEnable UInt8, CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, BrowserLanguage UInt16, BrowserCountry UInt16, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), Params Array(String), Goals Nested(ID UInt32, Serial UInt32, EventTime DateTime, Price Int64, OrderID String, CurrencyID UInt32), WatchIDs Array(UInt64), ParamSumPrice Int64, ParamCurrency FixedString(3), ParamCurrencyID UInt16, ClickLogID UInt64, ClickEventID Int32, ClickGoodEvent Int32, ClickEventTime DateTime, ClickPriorityID Int32, ClickPhraseID Int32, ClickPageID Int32, ClickPlaceID Int32, ClickTypeID Int32, ClickResourceID Int32, ClickCost UInt32, ClickClientIP UInt32, ClickDomainID UInt32, ClickURL String, ClickAttempt UInt8, ClickOrderID UInt32, ClickBannerID UInt32, ClickMarketCategoryID UInt32, ClickMarketPP UInt32, ClickMarketCategoryName String, ClickMarketPPName String, ClickAWAPSCampaignName String, ClickPageName String, ClickTargetType UInt16, ClickTargetPhraseID UInt64, ClickContextType UInt8, ClickSelectType Int8, ClickOptions String, ClickGroupBannerID Int32, OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, FirstVisit DateTime, PredLastVisit Date, LastVisit Date, TotalVisits UInt32, TraficSource Nested(ID Int8, SearchEngineID UInt16, AdvEngineID UInt8, PlaceID UInt16, SocialSourceNetworkID UInt8, Domain String, SearchPhrase String, SocialSourcePage String), Attendance FixedString(16), CLID UInt32, YCLID UInt64, NormalizedRefererHash UInt64, SearchPhraseHash UInt64, RefererDomainHash UInt64, NormalizedStartURLHash UInt64, StartURLDomainHash UInt64, NormalizedEndURLHash UInt64, TopLevelDomain UInt64, URLScheme UInt64, OpenstatServiceNameHash UInt64, OpenstatCampaignIDHash UInt64, OpenstatAdIDHash UInt64, OpenstatSourceIDHash UInt64, UTMSourceHash UInt64, UTMMediumHash UInt64, UTMCampaignHash UInt64, UTMContentHash UInt64, UTMTermHash UInt64, FromHash UInt64, WebVisorEnabled UInt8, WebVisorActivity UInt32, ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64), Market Nested(Type UInt8, GoalID UInt32, OrderID String, OrderPrice Int64, PP UInt32, DirectPlaceID UInt32, DirectOrderID UInt32, DirectBannerID UInt32, GoodID String, GoodName String, GoodQuantity Int32, GoodPrice Int64), IslandID FixedString(16)) ENGINE = CollapsingMergeTree(Sign) PARTITION BY toYYYYMM(StartDate) ORDER BY (CounterID, StartDate, intHash32(UserID), VisitID) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''default'\''' + clickhouse-client --query 'INSERT INTO test.hits_s3 SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16' Received exception from server (version 24.8.11): Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (for user) exceeded: would use 9.20 GiB (attempt to allocate chunk of 33554432 bytes), maximum: 9.18 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.. (MEMORY_LIMIT_EXCEEDED) (query: INSERT INTO test.hits_s3 SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16) + clickhouse-client --query 'INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16' Received exception from server (version 24.8.11): Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (for user) exceeded: would use 9.18 GiB (attempt to allocate chunk of 1124730 bytes), maximum: 9.18 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.. (MEMORY_LIMIT_EXCEEDED) (query: INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16) + clickhouse-client --query 'INSERT INTO test.visits SELECT * FROM datasets.visits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16' Received exception from server (version 24.8.11): Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (total) exceeded: would use 15.76 GiB (attempt to allocate chunk of 3943041 bytes), maximum: 15.30 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.. (MEMORY_LIMIT_EXCEEDED) (query: INSERT INTO test.visits SELECT * FROM datasets.visits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16) + clickhouse-client --query 'DROP TABLE datasets.visits_v1 SYNC' + clickhouse-client --query 'DROP TABLE datasets.hits_v1 SYNC' + clickhouse-client --query 'SHOW TABLES FROM test' hits hits_s3 visits + clickhouse-client --query 'SYSTEM STOP THREAD FUZZER' + stop_server + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=1282 + 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 = 1282. The process with pid = 1282 is running. Sent terminate signal to process with pid 1282. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1282. The process with pid = 1282 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1282. The process with pid = 1282 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1282. The process with pid = 1282 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1282. The process with pid = 1282 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1282. The process with pid = 1282 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1282. The process with pid = 1282 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1282. The process with pid = 1282 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1282. The process with pid = 1282 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + export RANDOMIZE_OBJECT_KEY_TYPE=1 + RANDOMIZE_OBJECT_KEY_TYPE=1 + export ZOOKEEPER_FAULT_INJECTION=1 + ZOOKEEPER_FAULT_INJECTION=1 + export THREAD_POOL_FAULT_INJECTION=1 + THREAD_POOL_FAULT_INJECTION=1 + configure + export USE_DATABASE_ORDINARY=1 + USE_DATABASE_ORDINARY=1 + export EXPORT_S3_STORAGE_POLICIES=1 + EXPORT_S3_STORAGE_POLICIES=1 + /usr/share/clickhouse-test/config/install.sh + DEST_SERVER_PATH=/etc/clickhouse-server + DEST_CLIENT_PATH=/etc/clickhouse-client +++ dirname /usr/share/clickhouse-test/config/install.sh ++ cd /usr/share/clickhouse-test/config ++ pwd -P Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + 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/ + mkdir -p /etc/clickhouse-server/users.d/ + mkdir -p /etc/clickhouse-client + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_catalog_drop_table_concurrency.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/grpc_protocol.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/block_number.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/serverwide_trace_collector.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/rocksdb.xml /etc/clickhouse-server/config.d/ + '[' /etc/clickhouse-server = /etc/clickhouse-server ']' + ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/ + ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + rm -f /etc/clickhouse-server/config.d/zookeeper.xml + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/config.d/cannot_allocate_thread_injection.xml /etc/clickhouse-server/config.d/ + value=0 + sed --follow-symlinks -i 's|[01]|0|' /etc/clickhouse-server/config.d/keeper_port.xml + value=33005568 + sed --follow-symlinks -i 's|[[:digit:]]\+|33005568|' /etc/clickhouse-server/config.d/keeper_port.xml + value=8851456 + sed --follow-symlinks -i 's|[[:digit:]]\+|8851456|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/ + [[ '' == \1 ]] + [[ '' == \1 ]] + [[ -n 1 ]] + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|100000|10000|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value filtered_list keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value multi_read keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value check_not_exists keeper_port + value=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value create_if_not_exists keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value use_compression zookeeper_fault_injection + value=1 + sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + randomize_config_boolean_value enable_block_number_column block_number + value=0 + sudo cat /etc/clickhouse-server/config.d/block_number.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml + randomize_config_boolean_value enable_block_offset_column block_number + value=1 + sudo cat /etc/clickhouse-server/config.d/block_number.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml + echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\''' + export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + sudo chown root: /var/lib/clickhouse + local total_mem ++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo + total_mem=32086436 + total_mem=32856510464 + max_server_memory_usage_to_ram_ratio=0.5 Setting max_server_memory_usage_to_ram_ratio to 0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat + local max_users_mem + max_users_mem=9856953139 + echo 'Setting max_memory_usage_for_user=9856953139 and max_memory_usage for queries to 10G' Setting max_memory_usage_for_user=9856953139 and max_memory_usage for queries to 10G + cat + cat + [[ '' == \1 ]] + [[ '' == \1 ]] + sudo cat /etc/clickhouse-server/config.d/logger_trace.xml + sed 's|trace|test|' + mv /etc/clickhouse-server/config.d/logger_trace.xml.tmp /etc/clickhouse-server/config.d/logger_trace.xml + '[' SLRU = SLRU ']' + sudo cat /etc/clickhouse-server/config.d/storage_conf.xml + sed 's|LRU|SLRU|' + mv /etc/clickhouse-server/config.d/storage_conf.xml.tmp /etc/clickhouse-server/config.d/storage_conf.xml ++ date +%-d + '[' 1 -eq 1 ']' + sudo echo 'true' + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 127.0.0.1 - - [03/Feb/2025:20:58:54 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - 127.0.0.1 - - [03/Feb/2025:20:58:54 +0000] "PUT /devstoreaccount1/cont/fwngomemkiuafbifinekobmdbryvdvwq HTTP/1.1" 201 - 127.0.0.1 - - [03/Feb/2025:20:58:54 +0000] "GET /devstoreaccount1/cont/fwngomemkiuafbifinekobmdbryvdvwq HTTP/1.1" 206 4 127.0.0.1 - - [03/Feb/2025:20:58:54 +0000] "GET /devstoreaccount1/cont/fwngomemkiuafbifinekobmdbryvdvwq HTTP/1.1" 206 2 127.0.0.1 - - [03/Feb/2025:20:58:54 +0000] "DELETE /devstoreaccount1/cont/fwngomemkiuafbifinekobmdbryvdvwq HTTP/1.1" 202 - + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ [[ hxB =~ e ]] ++ set_e=false ++ set +e ++ local total_retries=5 ++ shift ++ local retry=0 ++ '[' 0 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' Received exception from server (version 24.8.11): Code: 439. DB::Exception: Received from localhost:9000. DB::Exception: Cannot schedule a task: fault injected (threads=1, jobs=1). (CANNOT_SCHEDULE_TASK) (query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value)) ++ retry=1 ++ sleep 5 ++ '[' 1 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' Received exception from server (version 24.8.11): Code: 439. DB::Exception: Received from localhost:9000. DB::Exception: Cannot schedule a task: fault injected (threads=5, jobs=5). (CANNOT_SCHEDULE_TASK) (query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value)) ++ retry=2 ++ sleep 5 ++ '[' 2 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ false ++ return + IS_ASAN=0 + [[ 0 = \1 ]] ++ kill -l SIGRTMIN + RTMIN=34 + echo ' set follow-fork-mode parent handle SIGHUP nostop noprint pass handle SIGINT nostop noprint pass handle SIGQUIT nostop noprint pass handle SIGPIPE nostop noprint pass handle SIGTERM nostop noprint pass handle SIGUSR1 nostop noprint pass handle SIGUSR2 nostop noprint pass handle SIG34 nostop noprint pass info signals continue backtrace full info registers p top' 1 KiB of the 'stack: p/x *(uint64_t[128]*)$sp maintenance info sections thread apply all backtrace full disassemble /s up disassemble /s up disassemble /s p "done" detach quit ' + sleep 5 + ts '%Y-%m-%d %H:%M:%S' ++ cat /var/run/clickhouse-server/clickhouse-server.pid + gdb -batch -command script.gdb -p 2654 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + stress --hung-check --drop-databases --output-folder test_output --skip-func-tests '' --global-time-limit 1200 2025-02-03 21:59:15,939 Run func tests '/usr/bin/clickhouse-test --client-option optimize_trivial_approximate_count_query=1 ignore_drop_queries_probability=0.5 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 ' 2025-02-03 21:59:16,441 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_1 --client-option join_use_nulls=1 join_algorithm='parallel_hash' use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-02-03 21:59:16,942 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_2', 's1', 'r1')" --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 ignore_drop_queries_probability=0.5 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 ' 2025-02-03 21:59:17,444 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_3 --client-option join_algorithm='partial_merge' use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-02-03 21:59:17,945 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' optimize_trivial_approximate_count_query=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-02-03 21:59:18,446 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_5', 's1', 'r1')" --database=test_5 --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='full_sorting_merge' group_by_use_nulls=1 optimize_trivial_approximate_count_query=1 ignore_drop_queries_probability=0.5 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 ' 2025-02-03 21:59:18,947 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 ignore_drop_queries_probability=0.5 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 ' 2025-02-03 21:59:19,449 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=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-02-03 21:59:19,950 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_8', 's1', 'r1')" --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' http_make_head_request=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-02-03 21:59:20,451 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 optimize_trivial_approximate_count_query=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-02-03 21:59:20,953 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-02-03 21:59:21,454 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_11', 's1', 'r1')" --database=test_11 --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 ignore_drop_queries_probability=0.5 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 ' 2025-02-03 21:59:21,955 Run func tests '/usr/bin/clickhouse-test --order=random --client-option implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-02-03 21:59:22,457 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 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-02-03 21:59:22,958 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_14', 's1', 'r1')" --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-02-03 21:59:23,459 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_merge' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-02-03 21:59:23,960 Will wait functests to finish 2025-02-03 21:59:23,960 Finished 9 from 16 processes 2025-02-03 21:59:28,962 Finished 9 from 16 processes 2025-02-03 21:59:33,966 Finished 9 from 16 processes 2025-02-03 21:59:38,970 Finished 9 from 16 processes 2025-02-03 21:59:43,974 Finished 9 from 16 processes 2025-02-03 21:59:48,979 Finished 9 from 16 processes 2025-02-03 21:59:53,981 Finished 9 from 16 processes 2025-02-03 21:59:58,986 Finished 9 from 16 processes 2025-02-03 22:00:03,987 Finished 9 from 16 processes 2025-02-03 22:00:08,991 Finished 9 from 16 processes 2025-02-03 22:00:13,995 Finished 10 from 16 processes 2025-02-03 22:00:18,998 Finished 10 from 16 processes 2025-02-03 22:00:24,002 Finished 11 from 16 processes 2025-02-03 22:00:29,006 Finished 11 from 16 processes 2025-02-03 22:00:34,006 Finished 11 from 16 processes 2025-02-03 22:00:39,010 Finished 11 from 16 processes 2025-02-03 22:00:44,015 Finished 11 from 16 processes 2025-02-03 22:00:49,018 Finished 11 from 16 processes 2025-02-03 22:00:54,022 Finished 11 from 16 processes 2025-02-03 22:00:59,027 Finished 11 from 16 processes 2025-02-03 22:01:04,032 Finished 11 from 16 processes 2025-02-03 22:01:09,034 Finished 11 from 16 processes 2025-02-03 22:01:14,038 Finished 11 from 16 processes 2025-02-03 22:01:19,039 Finished 11 from 16 processes 2025-02-03 22:01:24,045 Finished 11 from 16 processes 2025-02-03 22:01:29,046 Finished 11 from 16 processes 2025-02-03 22:01:34,050 Finished 11 from 16 processes 2025-02-03 22:01:39,055 Finished 11 from 16 processes 2025-02-03 22:01:44,058 Finished 11 from 16 processes 2025-02-03 22:01:49,063 Finished 11 from 16 processes 2025-02-03 22:01:54,066 Finished 11 from 16 processes 2025-02-03 22:01:59,071 Finished 11 from 16 processes 2025-02-03 22:02:04,074 Finished 11 from 16 processes 2025-02-03 22:02:09,079 Finished 11 from 16 processes 2025-02-03 22:02:14,082 Finished 11 from 16 processes 2025-02-03 22:02:19,086 Finished 11 from 16 processes 2025-02-03 22:02:24,089 Finished 11 from 16 processes 2025-02-03 22:02:29,094 Finished 11 from 16 processes 2025-02-03 22:02:34,098 Finished 11 from 16 processes 2025-02-03 22:02:39,102 Finished 11 from 16 processes 2025-02-03 22:02:44,106 Finished 11 from 16 processes 2025-02-03 22:02:49,110 Finished 11 from 16 processes 2025-02-03 22:02:54,113 Finished 11 from 16 processes 2025-02-03 22:02:59,118 Finished 11 from 16 processes 2025-02-03 22:03:04,123 Finished 11 from 16 processes 2025-02-03 22:03:09,126 Finished 11 from 16 processes 2025-02-03 22:03:14,130 Finished 11 from 16 processes 2025-02-03 22:03:19,135 Finished 11 from 16 processes 2025-02-03 22:03:24,138 Finished 11 from 16 processes 2025-02-03 22:03:29,138 Finished 11 from 16 processes 2025-02-03 22:03:34,144 Finished 11 from 16 processes 2025-02-03 22:03:39,149 Finished 11 from 16 processes 2025-02-03 22:03:44,154 Finished 11 from 16 processes 2025-02-03 22:03:49,159 Finished 11 from 16 processes 2025-02-03 22:03:54,162 Finished 11 from 16 processes 2025-02-03 22:03:59,167 Finished 11 from 16 processes 2025-02-03 22:04:04,172 Finished 11 from 16 processes 2025-02-03 22:04:09,174 Finished 11 from 16 processes 2025-02-03 22:04:14,179 Finished 11 from 16 processes 2025-02-03 22:04:19,182 Finished 11 from 16 processes 2025-02-03 22:04:24,186 Finished 11 from 16 processes 2025-02-03 22:04:29,190 Finished 11 from 16 processes 2025-02-03 22:04:34,194 Finished 11 from 16 processes 2025-02-03 22:04:39,198 Finished 11 from 16 processes 2025-02-03 22:04:44,202 Finished 11 from 16 processes 2025-02-03 22:04:49,206 Finished 11 from 16 processes 2025-02-03 22:04:54,210 Finished 11 from 16 processes 2025-02-03 22:04:59,214 Finished 11 from 16 processes 2025-02-03 22:05:04,218 Finished 11 from 16 processes 2025-02-03 22:05:09,222 Finished 11 from 16 processes 2025-02-03 22:05:14,226 Finished 11 from 16 processes 2025-02-03 22:05:19,231 Finished 11 from 16 processes 2025-02-03 22:05:24,236 Finished 11 from 16 processes 2025-02-03 22:05:29,238 Finished 11 from 16 processes 2025-02-03 22:05:34,242 Finished 11 from 16 processes 2025-02-03 22:05:39,247 Finished 11 from 16 processes 2025-02-03 22:05:44,250 Finished 11 from 16 processes 2025-02-03 22:05:49,254 Finished 11 from 16 processes 2025-02-03 22:05:54,259 Finished 11 from 16 processes 2025-02-03 22:05:59,264 Finished 11 from 16 processes 2025-02-03 22:06:04,266 Finished 11 from 16 processes 2025-02-03 22:06:09,268 Finished 11 from 16 processes 2025-02-03 22:06:14,270 Finished 11 from 16 processes 2025-02-03 22:06:19,274 Finished 11 from 16 processes 2025-02-03 22:06:24,278 Finished 11 from 16 processes 2025-02-03 22:06:29,283 Finished 11 from 16 processes 2025-02-03 22:06:34,286 Finished 11 from 16 processes 2025-02-03 22:06:39,291 Finished 11 from 16 processes 2025-02-03 22:06:44,294 Finished 11 from 16 processes 2025-02-03 22:06:49,298 Finished 11 from 16 processes 2025-02-03 22:06:54,302 Finished 11 from 16 processes 2025-02-03 22:06:59,306 Finished 11 from 16 processes 2025-02-03 22:07:04,310 Finished 11 from 16 processes 2025-02-03 22:07:09,314 Finished 11 from 16 processes 2025-02-03 22:07:14,318 Finished 11 from 16 processes 2025-02-03 22:07:19,323 Finished 11 from 16 processes 2025-02-03 22:07:24,328 Finished 11 from 16 processes 2025-02-03 22:07:29,330 Finished 11 from 16 processes 2025-02-03 22:07:34,336 Finished 11 from 16 processes 2025-02-03 22:07:39,338 Finished 11 from 16 processes 2025-02-03 22:07:44,343 Finished 11 from 16 processes 2025-02-03 22:07:49,346 Finished 11 from 16 processes 2025-02-03 22:07:54,350 Finished 11 from 16 processes 2025-02-03 22:07:59,355 Finished 11 from 16 processes 2025-02-03 22:08:04,360 Finished 11 from 16 processes 2025-02-03 22:08:09,362 Finished 11 from 16 processes 2025-02-03 22:08:14,366 Finished 11 from 16 processes 2025-02-03 22:08:19,370 Finished 11 from 16 processes 2025-02-03 22:08:24,375 Finished 11 from 16 processes 2025-02-03 22:08:29,378 Finished 11 from 16 processes 2025-02-03 22:08:34,382 Finished 11 from 16 processes 2025-02-03 22:08:39,386 Finished 11 from 16 processes 2025-02-03 22:08:44,391 Finished 11 from 16 processes 2025-02-03 22:08:49,394 Finished 11 from 16 processes 2025-02-03 22:08:54,396 Finished 11 from 16 processes 2025-02-03 22:08:59,401 Finished 11 from 16 processes 2025-02-03 22:09:04,406 Finished 11 from 16 processes 2025-02-03 22:09:09,408 Finished 11 from 16 processes 2025-02-03 22:09:14,410 Finished 11 from 16 processes 2025-02-03 22:09:19,414 Finished 11 from 16 processes 2025-02-03 22:09:24,416 Finished 11 from 16 processes 2025-02-03 22:09:29,418 Finished 11 from 16 processes 2025-02-03 22:09:34,422 Finished 11 from 16 processes 2025-02-03 22:09:39,423 Finished 11 from 16 processes 2025-02-03 22:09:44,428 Finished 11 from 16 processes 2025-02-03 22:09:49,430 Finished 11 from 16 processes 2025-02-03 22:09:54,434 Finished 11 from 16 processes 2025-02-03 22:09:59,438 Finished 11 from 16 processes 2025-02-03 22:10:04,443 Finished 11 from 16 processes 2025-02-03 22:10:09,448 Finished 11 from 16 processes 2025-02-03 22:10:14,450 Finished 11 from 16 processes 2025-02-03 22:10:19,454 Finished 11 from 16 processes 2025-02-03 22:10:24,459 Finished 11 from 16 processes 2025-02-03 22:10:29,462 Finished 11 from 16 processes 2025-02-03 22:10:34,466 Finished 11 from 16 processes 2025-02-03 22:10:39,470 Finished 11 from 16 processes 2025-02-03 22:10:44,474 Finished 12 from 16 processes 2025-02-03 22:10:49,479 Finished 12 from 16 processes 2025-02-03 22:10:54,482 Finished 12 from 16 processes 2025-02-03 22:10:59,486 Finished 12 from 16 processes 2025-02-03 22:11:04,490 Finished 12 from 16 processes 2025-02-03 22:11:09,494 Finished 12 from 16 processes 2025-02-03 22:11:14,498 Finished 12 from 16 processes 2025-02-03 22:11:19,502 Finished 13 from 16 processes 2025-02-03 22:11:24,506 Finished 13 from 16 processes 2025-02-03 22:11:29,510 Finished 13 from 16 processes 2025-02-03 22:11:34,514 Finished 13 from 16 processes 2025-02-03 22:11:39,518 Finished 13 from 16 processes 2025-02-03 22:11:44,523 Finished 13 from 16 processes 2025-02-03 22:11:49,524 Finished 13 from 16 processes 2025-02-03 22:11:54,530 Finished 13 from 16 processes 2025-02-03 22:11:59,534 Finished 13 from 16 processes 2025-02-03 22:12:04,536 Finished 13 from 16 processes 2025-02-03 22:12:09,538 Finished 13 from 16 processes 2025-02-03 22:12:14,538 Finished 13 from 16 processes 2025-02-03 22:12:19,544 Finished 13 from 16 processes 2025-02-03 22:12:24,546 Finished 13 from 16 processes 2025-02-03 22:12:29,551 Finished 13 from 16 processes 2025-02-03 22:12:34,557 Finished 13 from 16 processes 2025-02-03 22:12:39,558 Finished 13 from 16 processes 2025-02-03 22:12:44,563 Finished 13 from 16 processes 2025-02-03 22:12:49,566 Finished 13 from 16 processes 2025-02-03 22:12:54,571 Finished 13 from 16 processes 2025-02-03 22:12:59,572 Finished 13 from 16 processes 2025-02-03 22:13:04,577 Finished 13 from 16 processes 2025-02-03 22:13:09,578 Finished 13 from 16 processes 2025-02-03 22:13:14,582 Finished 13 from 16 processes 2025-02-03 22:13:19,586 Finished 13 from 16 processes 2025-02-03 22:13:24,590 Finished 13 from 16 processes 2025-02-03 22:13:29,595 Finished 13 from 16 processes 2025-02-03 22:13:34,596 Finished 13 from 16 processes 2025-02-03 22:13:39,599 Finished 13 from 16 processes 2025-02-03 22:13:44,604 Finished 13 from 16 processes 2025-02-03 22:13:49,604 Finished 13 from 16 processes 2025-02-03 22:13:54,610 Finished 13 from 16 processes 2025-02-03 22:13:59,615 Finished 13 from 16 processes 2025-02-03 22:14:04,616 Finished 13 from 16 processes 2025-02-03 22:14:09,617 Finished 13 from 16 processes 2025-02-03 22:14:14,619 Finished 13 from 16 processes 2025-02-03 22:14:19,624 Finished 13 from 16 processes 2025-02-03 22:14:24,625 Finished 13 from 16 processes 2025-02-03 22:14:29,630 Finished 13 from 16 processes 2025-02-03 22:14:34,634 Finished 13 from 16 processes 2025-02-03 22:14:39,638 Finished 13 from 16 processes 2025-02-03 22:14:44,639 Finished 13 from 16 processes 2025-02-03 22:14:49,642 Finished 13 from 16 processes 2025-02-03 22:14:54,643 Finished 13 from 16 processes 2025-02-03 22:14:59,648 Finished 13 from 16 processes 2025-02-03 22:15:04,650 Finished 13 from 16 processes 2025-02-03 22:15:09,655 Finished 13 from 16 processes 2025-02-03 22:15:14,661 Finished 13 from 16 processes 2025-02-03 22:15:19,665 Finished 13 from 16 processes 2025-02-03 22:15:24,670 Finished 13 from 16 processes 2025-02-03 22:15:29,676 Finished 13 from 16 processes 2025-02-03 22:15:34,677 Finished 13 from 16 processes 2025-02-03 22:15:39,682 Finished 13 from 16 processes 2025-02-03 22:15:44,686 Finished 13 from 16 processes 2025-02-03 22:15:49,691 Finished 13 from 16 processes 2025-02-03 22:15:54,694 Finished 13 from 16 processes 2025-02-03 22:15:59,700 Finished 13 from 16 processes 2025-02-03 22:16:04,705 Finished 13 from 16 processes 2025-02-03 22:16:09,710 Finished 13 from 16 processes 2025-02-03 22:16:14,714 Finished 13 from 16 processes 2025-02-03 22:16:19,715 Finished 13 from 16 processes 2025-02-03 22:16:24,719 Finished 13 from 16 processes 2025-02-03 22:16:29,724 Finished 13 from 16 processes 2025-02-03 22:16:34,729 Finished 13 from 16 processes 2025-02-03 22:16:39,734 Finished 13 from 16 processes 2025-02-03 22:16:44,735 Finished 13 from 16 processes 2025-02-03 22:16:49,738 Finished 13 from 16 processes 2025-02-03 22:16:54,743 Finished 13 from 16 processes 2025-02-03 22:16:59,746 Finished 13 from 16 processes 2025-02-03 22:17:04,751 Finished 13 from 16 processes 2025-02-03 22:17:09,755 Finished 13 from 16 processes 2025-02-03 22:17:14,760 Finished 13 from 16 processes 2025-02-03 22:17:19,764 Finished 13 from 16 processes 2025-02-03 22:17:24,769 Finished 13 from 16 processes 2025-02-03 22:17:29,774 Finished 13 from 16 processes 2025-02-03 22:17:34,776 Finished 13 from 16 processes 2025-02-03 22:17:39,777 Finished 13 from 16 processes 2025-02-03 22:17:44,782 Finished 13 from 16 processes 2025-02-03 22:17:49,785 Finished 13 from 16 processes 2025-02-03 22:17:54,786 Finished 13 from 16 processes 2025-02-03 22:17:59,790 Finished 13 from 16 processes 2025-02-03 22:18:04,795 Finished 13 from 16 processes 2025-02-03 22:18:09,801 Finished 13 from 16 processes 2025-02-03 22:18:14,801 Finished 13 from 16 processes 2025-02-03 22:18:19,802 Finished 13 from 16 processes 2025-02-03 22:18:24,806 Finished 13 from 16 processes 2025-02-03 22:18:29,810 Finished 13 from 16 processes 2025-02-03 22:18:34,815 Finished 13 from 16 processes 2025-02-03 22:18:39,820 Finished 13 from 16 processes 2025-02-03 22:18:44,822 Finished 13 from 16 processes 2025-02-03 22:18:49,827 Finished 13 from 16 processes 2025-02-03 22:18:54,830 Finished 13 from 16 processes 2025-02-03 22:18:59,835 Finished 13 from 16 processes 2025-02-03 22:19:04,841 Finished 13 from 16 processes 2025-02-03 22:19:09,845 Finished 13 from 16 processes 2025-02-03 22:19:14,846 Finished 13 from 16 processes 2025-02-03 22:19:19,851 Finished 13 from 16 processes 2025-02-03 22:19:24,855 Finished 13 from 16 processes 2025-02-03 22:19:29,858 Finished 13 from 16 processes 2025-02-03 22:19:34,863 Finished 13 from 16 processes 2025-02-03 22:19:39,866 Finished 13 from 16 processes 2025-02-03 22:19:44,870 Finished 13 from 16 processes 2025-02-03 22:19:49,874 Finished 13 from 16 processes 2025-02-03 22:19:54,878 Finished 13 from 16 processes 2025-02-03 22:19:59,882 Finished 13 from 16 processes 2025-02-03 22:20:04,886 Finished 13 from 16 processes 2025-02-03 22:20:09,890 Finished 13 from 16 processes 2025-02-03 22:20:14,895 Finished 13 from 16 processes 2025-02-03 22:20:19,899 Finished 13 from 16 processes 2025-02-03 22:20:24,904 Finished 13 from 16 processes 2025-02-03 22:20:29,909 Finished 13 from 16 processes 2025-02-03 22:20:34,915 Finished 13 from 16 processes 2025-02-03 22:20:39,920 Finished 13 from 16 processes 2025-02-03 22:20:44,921 Finished 13 from 16 processes 2025-02-03 22:20:49,926 Finished 13 from 16 processes 2025-02-03 22:20:54,928 Finished 13 from 16 processes 2025-02-03 22:20:59,933 Finished 13 from 16 processes 2025-02-03 22:21:04,939 Finished 13 from 16 processes 2025-02-03 22:21:09,942 Finished 13 from 16 processes 2025-02-03 22:21:14,942 Finished 13 from 16 processes 2025-02-03 22:21:19,943 Finished 13 from 16 processes 2025-02-03 22:21:24,944 Finished 13 from 16 processes 2025-02-03 22:21:29,948 Finished 13 from 16 processes 2025-02-03 22:21:34,950 Finished 13 from 16 processes 2025-02-03 22:21:39,955 Finished 13 from 16 processes 2025-02-03 22:21:44,960 Finished 13 from 16 processes 2025-02-03 22:21:49,966 Finished 13 from 16 processes 2025-02-03 22:21:54,971 Finished 13 from 16 processes 2025-02-03 22:21:59,976 Finished 13 from 16 processes 2025-02-03 22:22:04,978 Finished 13 from 16 processes 2025-02-03 22:22:09,983 Finished 13 from 16 processes 2025-02-03 22:22:14,984 Finished 13 from 16 processes 2025-02-03 22:22:19,986 Finished 13 from 16 processes 2025-02-03 22:22:24,991 Finished 13 from 16 processes 2025-02-03 22:22:29,997 Finished 13 from 16 processes 2025-02-03 22:22:34,998 Finished 13 from 16 processes 2025-02-03 22:22:40,002 Finished 13 from 16 processes 2025-02-03 22:22:45,006 Finished 13 from 16 processes 2025-02-03 22:22:50,010 Finished 13 from 16 processes 2025-02-03 22:22:55,014 Finished 13 from 16 processes 2025-02-03 22:23:00,019 Finished 13 from 16 processes 2025-02-03 22:23:05,022 Finished 13 from 16 processes 2025-02-03 22:23:10,026 Finished 13 from 16 processes 2025-02-03 22:23:15,031 Finished 13 from 16 processes 2025-02-03 22:23:20,033 Finished 13 from 16 processes 2025-02-03 22:23:25,038 Finished 13 from 16 processes 2025-02-03 22:23:30,044 Finished 13 from 16 processes 2025-02-03 22:23:35,048 Finished 13 from 16 processes 2025-02-03 22:23:40,053 Finished 13 from 16 processes 2025-02-03 22:23:45,057 Finished 13 from 16 processes 2025-02-03 22:23:50,062 Finished 13 from 16 processes 2025-02-03 22:23:55,067 Finished 13 from 16 processes 2025-02-03 22:24:00,070 Finished 13 from 16 processes 2025-02-03 22:24:05,072 Finished 13 from 16 processes 2025-02-03 22:24:10,075 Finished 13 from 16 processes 2025-02-03 22:24:15,076 Finished 13 from 16 processes 2025-02-03 22:24:20,079 Finished 13 from 16 processes 2025-02-03 22:24:25,084 Finished 13 from 16 processes 2025-02-03 22:24:30,085 Finished 13 from 16 processes 2025-02-03 22:24:35,090 Finished 13 from 16 processes 2025-02-03 22:24:40,092 Finished 13 from 16 processes 2025-02-03 22:24:45,093 Finished 13 from 16 processes 2025-02-03 22:24:50,099 Finished 13 from 16 processes 2025-02-03 22:24:55,104 Finished 13 from 16 processes 2025-02-03 22:25:00,109 Finished 13 from 16 processes 2025-02-03 22:25:05,114 Finished 13 from 16 processes 2025-02-03 22:25:10,119 Finished 13 from 16 processes 2025-02-03 22:25:15,125 Finished 13 from 16 processes 2025-02-03 22:25:20,126 Finished 13 from 16 processes 2025-02-03 22:25:25,128 Finished 13 from 16 processes 2025-02-03 22:25:30,133 Finished 13 from 16 processes 2025-02-03 22:25:35,138 Finished 13 from 16 processes 2025-02-03 22:25:40,142 Finished 13 from 16 processes 2025-02-03 22:25:45,144 Finished 13 from 16 processes 2025-02-03 22:25:50,146 Finished 13 from 16 processes 2025-02-03 22:25:55,148 Finished 13 from 16 processes 2025-02-03 22:26:00,153 Finished 13 from 16 processes 2025-02-03 22:26:05,158 Finished 13 from 16 processes 2025-02-03 22:26:10,160 Finished 13 from 16 processes 2025-02-03 22:26:15,163 Finished 13 from 16 processes 2025-02-03 22:26:20,165 Finished 13 from 16 processes 2025-02-03 22:26:25,170 Finished 13 from 16 processes 2025-02-03 22:26:30,176 Finished 13 from 16 processes 2025-02-03 22:26:35,181 Finished 13 from 16 processes 2025-02-03 22:26:40,186 Finished 13 from 16 processes 2025-02-03 22:26:45,187 Finished 13 from 16 processes 2025-02-03 22:26:50,190 Finished 14 from 16 processes 2025-02-03 22:26:55,195 Finished 14 from 16 processes 2025-02-03 22:27:00,198 Finished 14 from 16 processes 2025-02-03 22:27:05,202 Finished 14 from 16 processes 2025-02-03 22:27:10,206 Finished 14 from 16 processes 2025-02-03 22:27:15,210 Finished 14 from 16 processes 2025-02-03 22:27:20,214 Finished 14 from 16 processes 2025-02-03 22:27:25,218 Finished 14 from 16 processes 2025-02-03 22:27:30,223 Finished 14 from 16 processes 2025-02-03 22:27:35,229 Finished 14 from 16 processes 2025-02-03 22:27:40,234 Finished 14 from 16 processes 2025-02-03 22:27:45,239 Finished 14 from 16 processes 2025-02-03 22:27:50,245 Finished 14 from 16 processes 2025-02-03 22:27:55,250 Finished 14 from 16 processes 2025-02-03 22:28:00,255 Finished 14 from 16 processes 2025-02-03 22:28:05,258 Finished 14 from 16 processes 2025-02-03 22:28:10,261 Finished 14 from 16 processes 2025-02-03 22:28:15,266 Finished 14 from 16 processes 2025-02-03 22:28:20,271 Finished 14 from 16 processes 2025-02-03 22:28:25,277 Finished 14 from 16 processes 2025-02-03 22:28:30,282 Finished 14 from 16 processes 2025-02-03 22:28:35,287 Finished 14 from 16 processes 2025-02-03 22:28:40,292 Finished 14 from 16 processes 2025-02-03 22:28:45,295 Finished 14 from 16 processes 2025-02-03 22:28:50,301 Finished 14 from 16 processes 2025-02-03 22:28:55,306 Finished 15 from 16 processes 2025-02-03 22:29:00,311 All processes finished 2025-02-03 22:29:00,311 Compressing stress logs 2025-02-03 22:29:00,331 Logs compressed 2025-02-03 22:29:00,331 Will terminate gdb (if any) 2025-02-03 22:29:00,331 Running command: kill -TERM $(pidof gdb) 2025-02-03 22:29:00,335 Running command: timeout 50s tail --pid=$(pidof gdb) -f /dev/null || kill -9 $(pidof gdb) ||: 2025-02-03 22:29:01,352 Running command: kill -CONT $(cat /var/run/clickhouse-server/clickhouse-server.pid) && clickhouse client -q 'SELECT 1 FORMAT Null' 2025-02-03 22:29:01,616 Running command: clickhouse client -q "SYSTEM STOP THREAD FUZZER" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-02-03 22:29:01,831 Running command: clickhouse client -q "SYSTEM START MERGES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-02-03 22:29:02,046 Running command: clickhouse client -q "SYSTEM START DISTRIBUTED SENDS" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-02-03 22:29:02,260 Running command: clickhouse client -q "SYSTEM START TTL MERGES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-02-03 22:29:02,475 Running command: clickhouse client -q "SYSTEM START MOVES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-02-03 22:29:02,689 Running command: clickhouse client -q "SYSTEM START FETCHES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-02-03 22:29:02,904 Running command: clickhouse client -q "SYSTEM START REPLICATED SENDS" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-02-03 22:29:03,119 Running command: clickhouse client -q "SYSTEM START REPLICATION QUEUES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-02-03 22:29:03,334 Running command: clickhouse client -q "SYSTEM DROP MARK CACHE" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-02-03 22:29:03,548 Running command: clickhouse client -q "KILL QUERY WHERE upper(query) LIKE 'WATCH %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-02-03 22:29:03,813 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'insert into tableB select %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-02-03 22:29:04,028 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'SELECT URL, uniq(SearchPhrase) AS u FROM test.hits GROUP BY URL ORDER BY u %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-02-03 22:29:04,242 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'SELECT (SELECT number FROM system.numbers WHERE number = 1000000000000)%'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 Received exception from server (version 24.8.11): Code: 159. DB::Exception: Received from localhost:9000. DB::Exception: Timeout exceeded: elapsed 60.069182709 seconds, maximum: 60. (TIMEOUT_EXCEEDED) (query: SELECT sleepEachRow(( SELECT maxOrDefault(300 - elapsed) + 1 FROM system.processes WHERE query NOT LIKE '%FROM system.processes%' AND elapsed < 300 ) / 300) FROM numbers(300) FORMAT Null SETTINGS function_sleep_max_microseconds_per_block = 0 ) 2025-02-03 22:30:05,532 Checking if some queries hung Using queries from '/usr/share/clickhouse-test/queries' directory Connecting to ClickHouse server... OK Connected to server 24.8.11.51000.altinitytest @ 70a7c762cc96d8a8f0a83d8096b012215c3cea64 HEAD Running 1 stateless tests (MainProcess). 00001_select_1: [ OK ] 1 tests passed. 0 tests skipped. 0.58 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. 12815 0.046 1.30 MiB 0.035 1 81 ['Trace'] 0.19 Checking existence of path: {} 2. 10971 0.039 1.64 MiB 0.045 5099 139 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 3. 10043 0.036 283.35 KiB 0.008 1 138 ['Debug'] 0.14 Processed in {} sec. 4. 9551 0.034 1.70 MiB 0.046 1 139 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 5. 8932 0.032 399.75 KiB 0.011 1 3 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 6. 7926 0.028 599.75 KiB 0.016 106 49 ['Trace'] 0 Reading {} ranges in{}order from part {}, approx. {} rows starting from {} 7. 7256 0.026 510.54 KiB 0.014 1 667 ['Trace'] 0.787 Reserved {} on local disk {}, having unreserved {}. 8. 7040 0.025 801.67 KiB 0.021 243 221 ['Trace'] 0.661 Renaming temporary part {} to {} with tid {}. 9. 6967 0.025 483.13 KiB 0.013 245 656 ['Trace'] 0.795 Trying to reserve {} using storage policy from min volume index {} 10. 6593 0.023 167.79 KiB 0.004 1 144 ['Trace'] 0.047 Query to stage {}{} 11. 6439 0.023 316.02 KiB 0.008 1 144 ['Trace'] 0.043 Query from stage {} to stage {}{} 12. 5985 0.021 530.17 KiB 0.014 45 499 ['Trace'] 0.988 Insert entry {} to queue with type {} 13. 5139 0.018 234.66 KiB 0.006 5139 165 ['Debug'] 0.994 Authenticating user '{}' from {} 14. 5135 0.018 576.68 KiB 0.015 5135 165 ['Debug'] 0.994 {} Authenticated with global context as user {} 15. 5124 0.018 450.35 KiB 0.012 5124 164 ['Debug'] 0.994 {} Logout, user_id: {} 16. 5105 0.018 373.90 KiB 0.01 5105 139 ['Debug'] 1 Creating session context with user_id: {} 17. 5030 0.018 234.53 KiB 0.006 1 216 ['Trace'] 0.528 filled checksums {} 18. 4446 0.016 412.01 KiB 0.011 1 36 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 19. 4240 0.015 385.47 KiB 0.01 1 138 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 20. 4240 0.015 139.73 KiB 0.004 2 138 ['Trace'] 1 TCP Request. Address: {} 21. 4222 0.015 111.32 KiB 0.003 1 137 ['Debug'] 1 Done processing connection. 22. 3591 0.013 286.89 KiB 0.008 1 98 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 23. 2893 0.01 242.27 KiB 0.006 45 508 ['Trace'] 1 Scheduling next merge selecting task after {}ms, current attempt status: {} 24. 2799 0.01 388.95 KiB 0.01 41 508 ['Trace'] 1 Checked {} partitions, found {} partitions with parts that may be merged: [{}] (max_total_size_to_merge={}, merge_with_ttl_allowed={}) 25. 2777 0.01 211.23 KiB 0.006 38 194 ['Trace'] 0.996 Part {} is not stored on zero-copy replicated disk, blobs can be removed 26. 2746 0.01 808.82 KiB 0.021 2 56 ['Trace'] 1 Request URI: {} 27. 2746 0.01 576.76 KiB 0.015 3 56 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {} 28. 2628 0.009 229.35 KiB 0.006 1 103 ['Trace'] 0.359 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 29. 2591 0.009 53.14 KiB 0.001 2 52 ['Debug'] 0.726 Done processing query 30. 2536 0.009 135.35 KiB 0.004 1 134 ['Debug'] 0.375 Peak memory usage{}: {}. 31. 2450 0.009 140.82 KiB 0.004 14 32 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 32. 2450 0.009 87.45 KiB 0.002 14 32 ['Trace'] 1 Flushed system log up to offset {} 33. 2445 0.009 62.08 KiB 0.002 44 497 ['Debug'] 0.987 Pulled {} entries to queue. 34. 2445 0.009 140.87 KiB 0.004 44 497 ['Debug'] 0.987 Pulling {} entries to queue: {} - {} 35. 2182 0.008 65.84 KiB 0.002 1 99 ['Trace'] 0.434 Aggregation method: {} 36. 2091 0.007 75.51 KiB 0.002 32 32 ['Debug'] 0.899 Committing part {} to zookeeper 37. 2056 0.007 72.24 KiB 0.002 32 32 ['Debug'] 0.909 Part {} committed to zookeeper 38. 2054 0.007 86.25 KiB 0.002 316 131 ['Debug'] 0.167 Found {} non used tables in detached tables. 39. 2054 0.007 122.36 KiB 0.003 316 131 ['Debug'] 0.167 There are {} detached tables. Start searching non used tables. 40. 2037 0.007 44.15 KiB 0.001 153 502 ['Trace'] 1 Execution took {} ms. 41. 1915 0.007 232.23 KiB 0.006 1 6 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 42. 1883 0.007 170.88 KiB 0.005 25 32 ['Debug'] 1 Fetching part {} from {}:{} 43. 1882 0.007 36.74 KiB 0.001 25 32 ['Debug'] 1 Downloading files {} 44. 1880 0.007 38.49 KiB 0.001 25 20 ['Trace'] 1 Sending part {} 45. 1880 0.007 67.93 KiB 0.002 25 32 ['Trace'] 1 Checking disk {} with type {} 46. 1880 0.007 159.73 KiB 0.004 25 32 ['Trace'] 1 Disk for fetch is not provided, getting disk from reservation {} with type '{}' 47. 1880 0.007 161.56 KiB 0.004 25 32 ['Trace'] 1 Trying to fetch with zero-copy replication, but disk is not provided, will try to select 48. 1880 0.007 80.71 KiB 0.002 25 32 ['Debug'] 1 Downloading part {} onto disk {}. 49. 1879 0.007 97.18 KiB 0.003 25 32 ['Debug'] 1 Download of part {} onto disk {} finished. 50. 1869 0.007 167.78 KiB 0.004 25 32 ['Debug'] 1 Fetched part {} from {}:{}{} 51. 1821 0.006 239.76 KiB 0.006 1 70 ['Trace'] 0 No query result found for query {} 52. 1742 0.006 139.68 KiB 0.004 1 90 ['Trace'] 0.543 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 53. 1584 0.006 162.03 KiB 0.004 1 7 ['Trace'] 0.5 Adding file: {}, size: {} 54. 1514 0.005 34.01 KiB 0.001 1 101 ['Trace'] 0.039 Merging aggregated data 55. 1499 0.005 86.54 KiB 0.002 2 14 ['Trace'] 0.985 Loading config file '{}'. 56. 1429 0.005 3.94 MiB 0.107 2 42 ['Error'] 0.983 Setting {} should not be changed 57. 1330 0.005 58.45 KiB 0.002 128 56 ['Trace'] 0 Filtering marks by primary and secondary keys 58. 1330 0.005 32.49 KiB 0.001 128 56 ['Debug'] 0 Key condition: {} 59. 1163 0.004 73.02 KiB 0.002 25 134 ['Debug'] 1 There is no part {} in ZooKeeper, it was only in filesystem 60. 1127 0.004 129.63 KiB 0.003 180 238 ['Debug'] 0.993 Removing {} parts from filesystem (serially): Parts: [{}] 61. 1118 0.004 36.93 KiB 0.001 48 42 ['Debug'] 0 MinMax index condition: {} 62. 1094 0.004 55.54 KiB 0.001 54 460 ['Debug'] 0.979 Selected {} parts from {} to {} 63. 1073 0.004 132.52 KiB 0.004 1 56 ['Trace'] 0 Stored query result of query {} 64. 1064 0.004 125.58 KiB 0.003 124 54 ['Debug'] 0 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 65. 1049 0.004 5.21 MiB 0.142 20 109 ['Error'] 0.109 Cannot schedule a task: {} (threads={}, jobs={}) 66. 1043 0.004 53.98 KiB 0.001 114 52 ['Trace'] 0 Spreading mark ranges among streams (default reading) 67. 1023 0.004 78.92 KiB 0.002 1 75 ['Trace'] 0 Query span trace_id for opentelemetry log: {} 68. 991 0.004 100.05 KiB 0.003 59 183 ['Trace'] 0.99 Found {} old parts to remove. Parts: [{}] 69. 987 0.004 100.77 KiB 0.003 59 183 ['Debug'] 0.99 Removing {} parts from memory: Parts: [{}] 70. 974 0.003 33.28 KiB 0.001 1 38 ['Debug'] 0 Selected MergeAlgorithm: {} 71. 974 0.003 79.07 KiB 0.002 1 38 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {} 72. 917 0.003 119.32 KiB 0.003 1 38 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec. 73. 915 0.003 57.56 KiB 0.002 56 38 ['Trace'] 0 Merged {} parts: [{}, {}] -> {} 74. 894 0.003 89.36 KiB 0.002 432 16 ['Trace'] 1 Executing log entry to merge parts {} to {} 75. 852 0.003 49.65 KiB 0.001 19 24 ['Debug'] 1 Part {} is rendered obsolete by fetching part {} 76. 782 0.003 22.17 KiB 0.001 1 146 ['Debug'] 1 Stop worker in {} 77. 782 0.003 30.57 KiB 0.001 1 134 ['Debug'] 0.59 Spawn loader worker #{} in {} 78. 781 0.003 56.82 KiB 0.002 1 118 ['Debug'] 1 Execute load job '{}' in {} 79. 781 0.003 53.75 KiB 0.001 1 118 ['Debug'] 1 Finish load job '{}' with status {} 80. 781 0.003 59.11 KiB 0.002 1 50 ['Debug'] 0.099 Schedule load job '{}' into {} 81. 772 0.003 71.29 KiB 0.002 1 51 ['Debug'] 0.065 Prioritize load job '{}': {} -> {} 82. 755 0.003 28.81 KiB 0.001 33 22 ['Debug'] 0 Reading approx. {} rows with {} streams 83. 704 0.003 141.53 KiB 0.004 284 16 ['Debug'] 1 Don't have all parts (at least {} is missing) for merge {}; will try to fetch it instead. Either pool for fetches is starving, see background_fetches_pool_size, or none of active replicas has it 84. 677 0.002 73.83 KiB 0.002 39 340 ['Trace'] 1 Scheduling next cleanup after {}ms (points: {}, interval: {}ms, ratio: {}, points per minute: {}) 85. 667 0.002 22.13 KiB 0.001 1 141 ['Debug'] 0.519 Change current priority: {} -> {} 86. 650 0.002 5.71 KiB 0 2 50 ['Trace'] 0.012 No tables 87. 589 0.002 6.33 KiB 0 1 89 ['Trace'] 0.104 Aggregating 88. 581 0.002 40.43 KiB 0.001 32 25 ['Debug'] 1 Skipping action for part {} because part {} already exists. 89. 567 0.002 16.61 KiB 0 45 317 ['Debug'] 0.968 Updating strategy picker state 90. 547 0.002 38.48 KiB 0.001 34 53 ['Debug'] 0 Wrote block with ID '{}', {} rows{} 91. 476 0.002 10.20 KiB 0 22 284 ['Information','Debug'] 0.996 Checking part {} 92. 476 0.002 82.55 KiB 0.002 225 25 ['Information'] 1 No active replica has part {} or covering part (cannot execute {}: {}) 93. 473 0.002 25.82 KiB 0.001 21 283 ['Information'] 1 Checking if anyone has a part {} or covering part. 94. 473 0.002 22.59 KiB 0.001 21 283 ['Trace'] 1 Part {} in zookeeper: {}, locally: {} 95. 473 0.002 17.51 KiB 0 21 28 ['Trace'] 1 Enqueueing {} for check after {}s 96. 417 0.001 80.01 KiB 0.002 19 262 ['Information'] 1 Found parts with the same min block and with the same max block as the missing part {} on replica {}. Hoping that it will eventually appear as a result of a merge. Parts: {} 97. 414 0.001 32.99 KiB 0.001 1 80 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={} 98. 401 0.001 45.69 KiB 0.001 1 17 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 99. 400 0.001 12.40 KiB 0 20 13 ['Debug'] 0 Requested flush up to offset {} 100. 395 0.001 14.66 KiB 0 26 24 ['Information'] 0.942 Removing broken parts from ZooKeeper: {} count count_% size size_% uniq_loggers uniq_threads levels background_% message_format_string Top messages without format string (fmt::runtime): count pattern runtime_message line 1. 37 autoDBStorageReplicatedMergeTree auto DB::StorageReplicatedMergeTree::processQueueEntry(ReplicatedMergeTreeQueue::SelectedEntryPtr)::(anonymous class)::operator()(LogEntryPtr &) const: Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this ('/Exception.cpp',265) 2. 21 voidDBStorageReplicatedMergeTree void DB::StorageReplicatedMergeTree::queueUpdatingTask(): Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. ./contrib/llvm-project/libcxx/include/exception: ('/Exception.cpp',265) 3. 12 CodeDBExceptionReceivedfromDBExc Code: 439. DB::Exception: Received from 127.0.0.2:9000. DB::Exception: Cannot schedule a task: failed to start the thread (threads=0, jobs=0). Stack trace: 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, i ('/executeQuery.cpp',221) 4. 6 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 0 ('/LoggerWrapper.h',43) 5. 4 voidDBReplicatedMergeTreeCleanup void DB::ReplicatedMergeTreeCleanupThread::run(): Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. ./contrib/llvm-project/libcxx/include/exception:141: Poc ('/Exception.cpp',265) 6. 4 Exceptionwhileexecutingbackgroun Exception while executing background task {e3fbc6c7-d17a-4cd6-8a78-9e277f6a1f69::5_11_16_1}: Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. ./contrib/llv ('/Exception.cpp',265) 7. 4 virtualboolDBReplicatedMergeMuta virtual bool DB::ReplicatedMergeMutateTaskBase::executeStep(): Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. ./contrib/llvm-project/libcxx/include/excep ('/Exception.cpp',265) 8. 3 newconfigurationlogidxprevlogidx new configuration: log idx 1, prev log idx 0 peer 1, DC ID 0, localhost:9234, voting member, 1 my id: 1, leader: 1, term: 1 ('/LoggerWrapper.h',43) 9. 3 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 10. 3 StartingClickHousealtinitytestre Starting ClickHouse 24.8.11.51000.altinitytest (revision: 54499, git hash: 70a7c762cc96d8a8f0a83d8096b012215c3cea64, build id: E519F6AC345008782E84A1FAC763E8579429295D), PID 423 ('',0) 11. 3 statemachinecommitindexprecommit state machine commit index 0, precommit index 0, last log index 0 ('/LoggerWrapper.h',43) 12. 3 Forkedachildprocesstowatch Forked a child process to watch ('',0) 13. 3 skippedconfiglatestconfig skipped config 1, latest config 1 ('/LoggerWrapper.h',43) 14. 3 INITRAFTSERVERcommitindextermele === INIT RAFT SERVER === commit index 0 term 0 election timer allowed log store start 1, end 0 config log idx 0, prev log idx 0 -- ASYNC REPLICATION -- ('/LoggerWrapper.h',43) 15. 3 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1 my id: 1, voting_member num peers: 0 ('/LoggerWrapper.h',43) 16. 3 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 17. 3 RaftASIOlistenerinitiatedonunsec Raft ASIO listener initiated on :::9234, unsecured ('/LoggerWrapper.h',43) 18. 3 VOTEINITmyidmyrolecandidateterml [VOTE INIT] my id 1, my role candidate, term 1, log idx 0, log term 0, priority (target 1 / mine 1) ('/LoggerWrapper.h',43) 19. 3 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',43) 20. 3 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',43) 21. 3 startingup starting up ('',0) 22. 3 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',43) 23. 3 newelectiontimeoutrange new election timeout range: 0 - 0 ('/LoggerWrapper.h',43) 24. 3 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) 25. 3 CodeCoordinationExceptionSession Code: 999. Coordination::Exception: Session expired (fault injected on recv). (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(S ('/Exception.cpp',265) 26. 3 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 1 ('/LoggerWrapper.h',43) 27. 3 PRIORITYdecaytargetmine [PRIORITY] decay, target 1 -> 1, mine 1 ('/LoggerWrapper.h',43) 28. 3 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',43) 29. 3 numberofpendingcommitelements number of pending commit elements: 0 ('/LoggerWrapper.h',43) 30. 3 newconfiglogidxprevlogidxcurconf new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0 ('/LoggerWrapper.h',43) Top messages not matching their format strings: message_format_string count() any_message 1. 85 Forked a child process to watch 2. {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 58 /var/lib/clickhouse/store/676/676376af-3282-414a-b94d-f540540eb8f5/tmp_insert_201403_8_8_0/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 5 similar messages) 3. (from {}{}{}){}{} {} (stage: {}) 1 (from [::1]:60642) (comment: 01674_unicode_asan.sql) SELECT positionCaseInsensitiveUTF8('иголка.ру', 'иголка.р�\0') AS res; (stage: Complete) Top short messages: c message_format_string substr(any(toValidUTF8(message)), 1, 120) min_length_without_exception_boilerplate 1. 16 {} ThreadFuzzer is enabled. Application will run slowly and unstable. 34 2. 14 Cannot TRUNCATE dictionary Code: 62. DB::Exception: Cannot TRUNCATE dictionary. (SYNTAX_ERROR) (version 24.8.11.51000.altinitytest (altinity build) 27 3. 3 Froze {} parts Froze 1 parts -13 4. 2 Found {} on {} Found changelog_1_100000.bin on LocalLogDisk 18 Top messages by level: (0.005075312811879571,'Setting {} should not be changed') Error (0.0002876839312541954,'ZooKeeper session has expired. Switching to a new session.') Warning (0.0016905870528024323,'No active replica has part {} or covering part (cannot execute {}: {})') Information (0.035669255822047954,'Processed in {} sec.') Debug (0.04551443924719153,'Checking existence of path: {}') Trace 2025-02-03 22:30:21,691 Stress test finished + echo -e 'Test script exit code\tOK\t\N\t' + rg -Fa 'No queries hung' /test_output/test_results.tsv + grep -Fa OK No queries hung OK \N + stop_server + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=2654 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2654. The process with pid = 2654 is running. Sent terminate signal to process with pid 2654. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2654. The process with pid = 2654 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2654. The process with pid = 2654 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2654. The process with pid = 2654 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2654. The process with pid = 2654 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2654. The process with pid = 2654 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2654. The process with pid = 2654 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2654. The process with pid = 2654 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2654. The process with pid = 2654 does not exist. Server stopped + return + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.stress.log + unset THREAD_FUZZER_CPU_TIME_PERIOD_US THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY THREAD_FUZZER_SLEEP_PROBABILITY THREAD_FUZZER_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX THREAD_POOL_FAULT_INJECTION + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + 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 - - [03/Feb/2025:21:30:32 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - 127.0.0.1 - - [03/Feb/2025:21:30:32 +0000] "PUT /devstoreaccount1/cont/auadkrpgcfmoiqncijvmvnhphizhwqhx HTTP/1.1" 201 - 127.0.0.1 - - [03/Feb/2025:21:30:32 +0000] "GET /devstoreaccount1/cont/auadkrpgcfmoiqncijvmvnhphizhwqhx HTTP/1.1" 206 4 127.0.0.1 - - [03/Feb/2025:21:30:32 +0000] "GET /devstoreaccount1/cont/auadkrpgcfmoiqncijvmvnhphizhwqhx HTTP/1.1" 206 2 127.0.0.1 - - [03/Feb/2025:21:30:32 +0000] "DELETE /devstoreaccount1/cont/auadkrpgcfmoiqncijvmvnhphizhwqhx 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' 1 + attach_gdb_to_clickhouse ++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ [[ hxB =~ e ]] ++ set_e=false ++ set +e ++ local total_retries=5 ++ shift ++ local retry=0 ++ '[' 0 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' Received exception from server (version 24.8.11): Code: 439. DB::Exception: Received from localhost:9000. DB::Exception: Cannot schedule a task: fault injected (threads=7, jobs=7). (CANNOT_SCHEDULE_TASK) (query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value)) ++ retry=1 ++ sleep 5 ++ '[' 1 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ false ++ return + IS_ASAN=0 + [[ 0 = \1 ]] ++ kill -l SIGRTMIN + RTMIN=34 + echo ' set follow-fork-mode parent handle SIGHUP nostop noprint pass handle SIGINT nostop noprint pass handle SIGQUIT nostop noprint pass handle SIGPIPE nostop noprint pass handle SIGTERM nostop noprint pass handle SIGUSR1 nostop noprint pass handle SIGUSR2 nostop noprint pass handle SIG34 nostop noprint pass info signals continue backtrace full info registers p top' 1 KiB of the 'stack: p/x *(uint64_t[128]*)$sp maintenance info sections thread apply all backtrace full disassemble /s up disassemble /s up disassemble /s p "done" detach quit ' + sleep 5 + ts '%Y-%m-%d %H:%M:%S' ++ cat /var/run/clickhouse-server/clickhouse-server.pid + gdb -batch -command script.gdb -p 32786 + 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=32786 + 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 = 32786. The process with pid = 32786 is running. Sent terminate signal to process with pid 32786. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 32786. The process with pid = 32786 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 32786. The process with pid = 32786 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 32786. The process with pid = 32786 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 32786. The process with pid = 32786 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 32786. The process with pid = 32786 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + '[' -f /var/log/clickhouse-server/clickhouse-server.log ']' + '[' -f /var/log/clickhouse-server/stderr.log ']' + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.final.log + check_logs_for_critical_errors + sed -n '/WARNING:.*anitizer/,/^$/p' /var/log/clickhouse-server/stderr.log + rg -Fav -e 'ASan doesn'\''t fully support makecontext/swapcontext functions' -e DB::Exception /test_output/tmp + echo -e 'No sanitizer asserts\tOK\t\N\t' + rm -f /test_output/tmp + rg -Fa ' Application: Child process was terminated by signal 9' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No OOM messages in clickhouse-server.log\tOK\t\N\t' + rg -Fa 'Code: 49. DB::Exception: ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No logical errors\tOK\t\N\t' + '[' -s /test_output/logical_errors.txt ']' + rm /test_output/logical_errors.txt + rg --text 'Code: 499.*The specified key does not exist' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + grep -v a.myext + echo -e 'No lost s3 keys\tOK\t\N\t' + grep SharedMergeTreePartCheckThread + rg -Fa 'it is lost forever' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No SharedMergeTree lost forever in clickhouse-server.log\tOK\t\N\t' + '[' -s /test_output/no_such_key_errors.txt ']' + rm /test_output/no_such_key_errors.txt + rg -Fa '########################################' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'Not crashed\tOK\t\N\t' + rg -Fa ' ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No fatal messages in clickhouse-server.log\tOK\t\N\t' + '[' -s /test_output/fatal_messages.txt ']' + rm /test_output/fatal_messages.txt + rg -Faz '########################################' /test_output/gdb.log /test_output/stress_run_logs.tar.zst /test_output/test_results.tsv + rg -Fa ' received signal ' /test_output/gdb.log + dmesg -T + grep -q -F -e 'Out of memory: Killed process' -e 'oom_reaper: reaped process' -e oom-kill:constraint=CONSTRAINT_NONE /test_output/dmesg.log + echo -e 'No OOM in dmesg\tOK\t\N\t' + tar -chf /test_output/coordination.tar /var/lib/clickhouse/coordination tar: Removing leading `/' from member names tar: Removing leading `/' from hard link targets + collect_query_and_trace_logs + for table in query_log trace_log metric_log + clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.query_log format TSVWithNamesAndTypes' + zstd --threads=0 Logging trace to /var/log/clickhouse-server/clickhouse-server.log Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log 127.0.0.1 - - [03/Feb/2025:21:30:54 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - + for table in query_log trace_log metric_log + clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.trace_log format TSVWithNamesAndTypes' + zstd --threads=0 Logging trace to /var/log/clickhouse-server/clickhouse-server.log Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log 127.0.0.1 - - [03/Feb/2025:21:31:02 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - + for table in query_log trace_log metric_log + clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.metric_log format TSVWithNamesAndTypes' + zstd --threads=0 Logging trace to /var/log/clickhouse-server/clickhouse-server.log Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log 127.0.0.1 - - [03/Feb/2025:21:31:05 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - + mv /var/log/clickhouse-server/stderr.log /test_output/ + clickhouse-local --structure 'test String, res String, time Nullable(Float32), desc String' -q 'SELECT '\''failure'\'', test FROM table WHERE res != '\''OK'\'' order by (test like '\''%Sanitizer%'\'') DESC, (test like '\''%Killed by signal%'\'') DESC, (test like '\''%gdb.log%'\'') DESC, (test ilike '\''%possible deadlock%'\'') DESC, (test like '\''%start%'\'') DESC, (test like '\''%dmesg%'\'') DESC, (test like '\''%OOM%'\'') DESC, (test like '\''%Signal 9%'\'') DESC, (test like '\''%Fatal message%'\'') DESC, rowNumberInAllBlocks() LIMIT 1' + '[' -s /test_output/check_status.tsv ']' + echo -e 'success\tNo errors found' + rg 'OOM in dmesg|Signal 9' /test_output/check_status.tsv + collect_core_dumps + find . -type f -maxdepth 1 -name 'core.*' + read -r core