+ 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.14.10457.altinitytest+asan_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.14.10457.altinitytest+asan_amd64.deb ... Unpacking clickhouse-common-static (24.8.14.10457.altinitytest+asan) ... Setting up clickhouse-common-static (24.8.14.10457.altinitytest+asan) ... + dpkg -i package_folder/clickhouse-common-static-dbg_24.8.14.10457.altinitytest+asan_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.14.10457.altinitytest+asan_amd64.deb ... Unpacking clickhouse-common-static-dbg (24.8.14.10457.altinitytest+asan) ... Setting up clickhouse-common-static-dbg (24.8.14.10457.altinitytest+asan) ... + dpkg -i package_folder/clickhouse-server_24.8.14.10457.altinitytest+asan_amd64.deb Selecting previously unselected package clickhouse-server. (Reading database ... 48726 files and directories currently installed.) Preparing to unpack .../clickhouse-server_24.8.14.10457.altinitytest+asan_amd64.deb ... Unpacking clickhouse-server (24.8.14.10457.altinitytest+asan) ... Setting up clickhouse-server (24.8.14.10457.altinitytest+asan) ... 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.14.10457.altinitytest+asan_amd64.deb Selecting previously unselected package clickhouse-client. (Reading database ... 48743 files and directories currently installed.) Preparing to unpack .../clickhouse-client_24.8.14.10457.altinitytest+asan_amd64.deb ... Unpacking clickhouse-client (24.8.14.10457.altinitytest+asan) ... Setting up clickhouse-client (24.8.14.10457.altinitytest+asan) ... + 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 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 '' ]] + 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=1955840 + sed --follow-symlinks -i 's|[[:digit:]]\+|1955840|' /etc/clickhouse-server/config.d/keeper_port.xml + value=54376448 + sed --follow-symlinks -i 's|[[:digit:]]\+|54376448|' /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 + sed 's|[01]|1|' + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value check_not_exists keeper_port + value=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value create_if_not_exists keeper_port + value=0 + sed 's|[01]|0|' + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + 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=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 Setting max_server_memory_usage_to_ram_ratio to 0.5 + total_mem=32086444 + total_mem=32856518656 + max_server_memory_usage_to_ram_ratio=0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G + local max_users_mem + max_users_mem=9856955596 + echo 'Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G' + cat + cat + ./setup_minio.sh stateless + azurite-blob --blobHost 0.0.0.0 --blobPort 10000 --debug /azurite_log + export MINIO_ROOT_USER=clickhouse + MINIO_ROOT_USER=clickhouse + export MINIO_ROOT_PASSWORD=clickhouse + MINIO_ROOT_PASSWORD=clickhouse + main stateless + local query_dir ++ check_arg stateless ++ local query_dir ++ '[' '!' 1 -eq 1 ']' ++ case "$1" in ++ query_dir=0_stateless ++ echo 0_stateless + query_dir=0_stateless + '[' '!' -f ./minio ']' + start_minio + mkdir -p ./minio_data + ./minio --version 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 + local counter=0 + local max_counter=60 + local url=http://localhost:11111 + ./minio server --address :11111 ./minio_data + params=('--silent' '--verbose') + local params + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 0 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 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:36769 http://127.0.0.1:36769 Docs: https://min.io/docs/minio/linux/index.html + counter=1 + curl --silent --verbose http://localhost:11111 + grep AccessDenied AccessDeniedAccess Denied./1831E5528CA8C0187dc7eb22d3288ec80374614e9088e31d3668a6922ead55932dd2a8e56373820f + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 276 root 8u IPv4 31585 0t0 TCP localhost:11111 (LISTEN) minio 276 root 9u IPv6 31586 0t0 TCP *:11111 (LISTEN) minio 276 root 10u IPv6 31587 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/02731.parquet` -> `clickminio/test/02731.parquet` `/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/02731.arrow` -> `clickminio/test/02731.arrow` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02876.parquet` -> `clickminio/test/02876.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/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: 160.39 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 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 127.0.0.1 - - [31/Mar/2025:13:11:27 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 404 - 127.0.0.1 - - [31/Mar/2025:13:11:27 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [31/Mar/2025:13:11:27 +0000] "PUT /devstoreaccount1/cont/tboxfnsjzgiacsvzqqpcpciynhhsajcb HTTP/1.1" 201 - 127.0.0.1 - - [31/Mar/2025:13:11:27 +0000] "GET /devstoreaccount1/cont/tboxfnsjzgiacsvzqqpcpciynhhsajcb HTTP/1.1" 206 4 127.0.0.1 - - [31/Mar/2025:13:11:27 +0000] "GET /devstoreaccount1/cont/tboxfnsjzgiacsvzqqpcpciynhhsajcb HTTP/1.1" 206 2 127.0.0.1 - - [31/Mar/2025:13:11:27 +0000] "DELETE /devstoreaccount1/cont/tboxfnsjzgiacsvzqqpcpciynhhsajcb HTTP/1.1" 202 - + 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)' ++ false ++ return ASAN build detected. Not using gdb since it disables LeakSanitizer detections + IS_ASAN=1 + [[ 1 = \1 ]] + echo 'ASAN build detected. Not using gdb since it disables LeakSanitizer detections' + 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=414 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414. The process with pid = 414 is running. Sent terminate signal to process with pid 414. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414. The process with pid = 414 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414. The process with pid = 414 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414. The process with pid = 414 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414. The process with pid = 414 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414. The process with pid = 414 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414. The process with pid = 414 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414. The process with pid = 414 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414. The process with pid = 414 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414. The process with pid = 414 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414. The process with pid = 414 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.initial.log Using cache policy: SLRU + cache_policy= + '[' 1 -eq 1 ']' + 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 + 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 127.0.0.1 - - [31/Mar/2025:13:12:06 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - 127.0.0.1 - - [31/Mar/2025:13:12:06 +0000] "PUT /devstoreaccount1/cont/jmczjtsjzmwnmdvptxhnkepyvhdwzzpv HTTP/1.1" 201 - 127.0.0.1 - - [31/Mar/2025:13:12:06 +0000] "GET /devstoreaccount1/cont/jmczjtsjzmwnmdvptxhnkepyvhdwzzpv HTTP/1.1" 206 4 127.0.0.1 - - [31/Mar/2025:13:12:06 +0000] "GET /devstoreaccount1/cont/jmczjtsjzmwnmdvptxhnkepyvhdwzzpv HTTP/1.1" 206 2 127.0.0.1 - - [31/Mar/2025:13:12:06 +0000] "DELETE /devstoreaccount1/cont/jmczjtsjzmwnmdvptxhnkepyvhdwzzpv HTTP/1.1" 202 - + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 15 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=16 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 16 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=17 + clickhouse-client --query 'SELECT 1' 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=1 + [[ 1 = \1 ]] ASAN build detected. Not using gdb since it disables LeakSanitizer detections + echo 'ASAN build detected. Not using gdb since it disables LeakSanitizer detections' + 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.14): 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 1065037 bytes), maximum: 9.18 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.: (while reading column ShareURL): (while reading from part store/78e/78ebf6a1-d987-4579-b3ec-00c1a087b1f3/201403_1_1_2/ in table datasets.hits_v1 (78ebf6a1-d987-4579-b3ec-00c1a087b1f3) located on disk __tmp_internal_262634248876485800814430204900764312493 of type web, from mark 156 with max_rows_to_read = 8192): While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (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.14): 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 1105920 bytes), maximum: 9.18 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.: (while reading column RemoteIP6): (while reading from part store/78e/78ebf6a1-d987-4579-b3ec-00c1a087b1f3/201403_1_1_2/ in table datasets.hits_v1 (78ebf6a1-d987-4579-b3ec-00c1a087b1f3) located on disk __tmp_internal_262634248876485800814430204900764312493 of type web, from mark 88 with max_rows_to_read = 8192): While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (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' + 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=1285 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1285. The process with pid = 1285 is running. Sent terminate signal to process with pid 1285. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1285. The process with pid = 1285 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1285. The process with pid = 1285 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1285. The process with pid = 1285 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1285. The process with pid = 1285 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 + 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 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=44632064 + sed --follow-symlinks -i 's|[[:digit:]]\+|44632064|' /etc/clickhouse-server/config.d/keeper_port.xml + value=24811520 + sed --follow-symlinks -i 's|[[:digit:]]\+|24811520|' /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=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value create_if_not_exists keeper_port + value=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value use_compression zookeeper_fault_injection + value=0 + sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + randomize_config_boolean_value 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=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 Setting max_server_memory_usage_to_ram_ratio to 0.5 + total_mem=32086444 + total_mem=32856518656 + max_server_memory_usage_to_ram_ratio=0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat + local max_users_mem + max_users_mem=9856955596 + echo 'Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G' + cat Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G + 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 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 127.0.0.1 - - [31/Mar/2025:13:14:30 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - 127.0.0.1 - - [31/Mar/2025:13:14:30 +0000] "PUT /devstoreaccount1/cont/uffubqopbywqasdkhkxiptsulqufebgs HTTP/1.1" 201 - 127.0.0.1 - - [31/Mar/2025:13:14:30 +0000] "GET /devstoreaccount1/cont/uffubqopbywqasdkhkxiptsulqufebgs HTTP/1.1" 206 4 127.0.0.1 - - [31/Mar/2025:13:14:30 +0000] "GET /devstoreaccount1/cont/uffubqopbywqasdkhkxiptsulqufebgs HTTP/1.1" 206 2 127.0.0.1 - - [31/Mar/2025:13:14:30 +0000] "DELETE /devstoreaccount1/cont/uffubqopbywqasdkhkxiptsulqufebgs HTTP/1.1" 202 - + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 15 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=16 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 16 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=17 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 17 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=18 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 18 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=19 + clickhouse-client --query 'SELECT 1' 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.14): 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)' ++ false ++ return + IS_ASAN=1 + [[ 1 = \1 ]] + echo 'ASAN build detected. Not using gdb since it disables LeakSanitizer detections' ASAN build detected. Not using gdb since it disables LeakSanitizer detections + stress --hung-check --drop-databases --output-folder test_output --skip-func-tests '' --global-time-limit 1200 2025-03-31 15:14:45,169 Run func tests '/usr/bin/clickhouse-test --client-option ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-03-31 15:14:45,670 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_1 --client-option join_use_nulls=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-03-31 15:14:46,172 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-03-31 15:14:46,673 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_3 --client-option join_algorithm='partial_merge' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-03-31 15:14:47,174 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 http_make_head_request=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-03-31 15:14:47,676 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' use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' 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-03-31 15:14:48,177 Run func tests '/usr/bin/clickhouse-test --order=random --client-option memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-03-31 15:14:48,679 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_7 --client-option join_use_nulls=1 join_algorithm='grace_hash' use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' group_by_use_nulls=1 http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-03-31 15:14:49,181 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 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-03-31 15:14:49,682 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_9 --client-option join_algorithm='auto' max_rows_in_join=1000 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' group_by_use_nulls=1 http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-03-31 15:14:50,183 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-03-31 15:14:50,685 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 --global_time_limit=1200 ' 2025-03-31 15:14:51,186 Run func tests '/usr/bin/clickhouse-test --order=random --client-option implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 http_make_head_request=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-03-31 15:14:51,687 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_13 --client-option join_use_nulls=1 join_algorithm='partial_merge' group_by_use_nulls=1 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-03-31 15:14:52,188 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 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' 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-03-31 15:14:52,690 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_merge' group_by_use_nulls=1 http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-03-31 15:14:53,191 Will wait functests to finish 2025-03-31 15:14:53,191 Finished 6 from 16 processes 2025-03-31 15:14:58,192 Finished 6 from 16 processes 2025-03-31 15:15:03,195 Finished 7 from 16 processes 2025-03-31 15:15:08,199 Finished 7 from 16 processes 2025-03-31 15:15:13,203 Finished 7 from 16 processes 2025-03-31 15:15:18,207 Finished 7 from 16 processes 2025-03-31 15:15:23,211 Finished 7 from 16 processes 2025-03-31 15:15:28,215 Finished 7 from 16 processes 2025-03-31 15:15:33,219 Finished 7 from 16 processes 2025-03-31 15:15:38,221 Finished 7 from 16 processes 2025-03-31 15:15:43,226 Finished 7 from 16 processes 2025-03-31 15:15:48,231 Finished 7 from 16 processes 2025-03-31 15:15:53,233 Finished 7 from 16 processes 2025-03-31 15:15:58,235 Finished 7 from 16 processes 2025-03-31 15:16:03,236 Finished 7 from 16 processes 2025-03-31 15:16:08,239 Finished 7 from 16 processes 2025-03-31 15:16:13,243 Finished 7 from 16 processes 2025-03-31 15:16:18,247 Finished 7 from 16 processes 2025-03-31 15:16:23,251 Finished 7 from 16 processes 2025-03-31 15:16:28,256 Finished 7 from 16 processes 2025-03-31 15:16:33,259 Finished 7 from 16 processes 2025-03-31 15:16:38,263 Finished 7 from 16 processes 2025-03-31 15:16:43,268 Finished 8 from 16 processes 2025-03-31 15:16:48,274 Finished 8 from 16 processes 2025-03-31 15:16:53,275 Finished 8 from 16 processes 2025-03-31 15:16:58,279 Finished 8 from 16 processes 2025-03-31 15:17:03,283 Finished 8 from 16 processes 2025-03-31 15:17:08,287 Finished 8 from 16 processes 2025-03-31 15:17:13,291 Finished 8 from 16 processes 2025-03-31 15:17:18,296 Finished 8 from 16 processes 2025-03-31 15:17:23,302 Finished 8 from 16 processes 2025-03-31 15:17:28,306 Finished 8 from 16 processes 2025-03-31 15:17:33,311 Finished 8 from 16 processes 2025-03-31 15:17:38,315 Finished 8 from 16 processes 2025-03-31 15:17:43,319 Finished 8 from 16 processes 2025-03-31 15:17:48,323 Finished 8 from 16 processes 2025-03-31 15:17:53,327 Finished 8 from 16 processes 2025-03-31 15:17:58,333 Finished 8 from 16 processes 2025-03-31 15:18:03,335 Finished 8 from 16 processes 2025-03-31 15:18:08,340 Finished 8 from 16 processes 2025-03-31 15:18:13,343 Finished 8 from 16 processes 2025-03-31 15:18:18,347 Finished 8 from 16 processes 2025-03-31 15:18:23,351 Finished 8 from 16 processes 2025-03-31 15:18:28,356 Finished 8 from 16 processes 2025-03-31 15:18:33,359 Finished 8 from 16 processes 2025-03-31 15:18:38,363 Finished 8 from 16 processes 2025-03-31 15:18:43,367 Finished 8 from 16 processes 2025-03-31 15:18:48,371 Finished 8 from 16 processes 2025-03-31 15:18:53,375 Finished 8 from 16 processes 2025-03-31 15:18:58,379 Finished 8 from 16 processes 2025-03-31 15:19:03,383 Finished 8 from 16 processes 2025-03-31 15:19:08,387 Finished 8 from 16 processes 2025-03-31 15:19:13,388 Finished 8 from 16 processes 2025-03-31 15:19:18,391 Finished 8 from 16 processes 2025-03-31 15:19:23,395 Finished 8 from 16 processes 2025-03-31 15:19:28,399 Finished 8 from 16 processes 2025-03-31 15:19:33,403 Finished 8 from 16 processes 2025-03-31 15:19:38,407 Finished 8 from 16 processes 2025-03-31 15:19:43,411 Finished 8 from 16 processes 2025-03-31 15:19:48,416 Finished 8 from 16 processes 2025-03-31 15:19:53,419 Finished 8 from 16 processes 2025-03-31 15:19:58,423 Finished 8 from 16 processes 2025-03-31 15:20:03,426 Finished 8 from 16 processes 2025-03-31 15:20:08,429 Finished 8 from 16 processes 2025-03-31 15:20:13,434 Finished 8 from 16 processes 2025-03-31 15:20:18,439 Finished 8 from 16 processes 2025-03-31 15:20:23,443 Finished 8 from 16 processes 2025-03-31 15:20:28,447 Finished 8 from 16 processes 2025-03-31 15:20:33,451 Finished 8 from 16 processes 2025-03-31 15:20:38,455 Finished 8 from 16 processes 2025-03-31 15:20:43,460 Finished 8 from 16 processes 2025-03-31 15:20:48,463 Finished 8 from 16 processes 2025-03-31 15:20:53,468 Finished 8 from 16 processes 2025-03-31 15:20:58,471 Finished 8 from 16 processes 2025-03-31 15:21:03,476 Finished 8 from 16 processes 2025-03-31 15:21:08,481 Finished 8 from 16 processes 2025-03-31 15:21:13,483 Finished 8 from 16 processes 2025-03-31 15:21:18,487 Finished 8 from 16 processes 2025-03-31 15:21:23,491 Finished 8 from 16 processes 2025-03-31 15:21:28,495 Finished 8 from 16 processes 2025-03-31 15:21:33,499 Finished 8 from 16 processes 2025-03-31 15:21:38,499 Finished 8 from 16 processes 2025-03-31 15:21:43,503 Finished 8 from 16 processes 2025-03-31 15:21:48,507 Finished 8 from 16 processes 2025-03-31 15:21:53,507 Finished 8 from 16 processes 2025-03-31 15:21:58,511 Finished 8 from 16 processes 2025-03-31 15:22:03,516 Finished 8 from 16 processes 2025-03-31 15:22:08,517 Finished 8 from 16 processes 2025-03-31 15:22:13,517 Finished 8 from 16 processes 2025-03-31 15:22:18,518 Finished 8 from 16 processes 2025-03-31 15:22:23,523 Finished 8 from 16 processes 2025-03-31 15:22:28,527 Finished 8 from 16 processes 2025-03-31 15:22:33,531 Finished 8 from 16 processes 2025-03-31 15:22:38,535 Finished 8 from 16 processes 2025-03-31 15:22:43,540 Finished 8 from 16 processes 2025-03-31 15:22:48,543 Finished 8 from 16 processes 2025-03-31 15:22:53,547 Finished 8 from 16 processes 2025-03-31 15:22:58,551 Finished 8 from 16 processes 2025-03-31 15:23:03,555 Finished 8 from 16 processes 2025-03-31 15:23:08,560 Finished 8 from 16 processes 2025-03-31 15:23:13,566 Finished 8 from 16 processes 2025-03-31 15:23:18,567 Finished 8 from 16 processes 2025-03-31 15:23:23,567 Finished 8 from 16 processes 2025-03-31 15:23:28,571 Finished 8 from 16 processes 2025-03-31 15:23:33,575 Finished 8 from 16 processes 2025-03-31 15:23:38,579 Finished 8 from 16 processes 2025-03-31 15:23:43,583 Finished 8 from 16 processes 2025-03-31 15:23:48,588 Finished 8 from 16 processes 2025-03-31 15:23:53,591 Finished 8 from 16 processes 2025-03-31 15:23:58,595 Finished 8 from 16 processes 2025-03-31 15:24:03,599 Finished 8 from 16 processes 2025-03-31 15:24:08,603 Finished 8 from 16 processes 2025-03-31 15:24:13,608 Finished 8 from 16 processes 2025-03-31 15:24:18,611 Finished 8 from 16 processes 2025-03-31 15:24:23,615 Finished 8 from 16 processes 2025-03-31 15:24:28,619 Finished 8 from 16 processes 2025-03-31 15:24:33,623 Finished 8 from 16 processes 2025-03-31 15:24:38,628 Finished 8 from 16 processes 2025-03-31 15:24:43,631 Finished 8 from 16 processes 2025-03-31 15:24:48,635 Finished 8 from 16 processes 2025-03-31 15:24:53,639 Finished 8 from 16 processes 2025-03-31 15:24:58,643 Finished 8 from 16 processes 2025-03-31 15:25:03,647 Finished 8 from 16 processes 2025-03-31 15:25:08,651 Finished 8 from 16 processes 2025-03-31 15:25:13,655 Finished 8 from 16 processes 2025-03-31 15:25:18,659 Finished 8 from 16 processes 2025-03-31 15:25:23,663 Finished 8 from 16 processes 2025-03-31 15:25:28,667 Finished 8 from 16 processes 2025-03-31 15:25:33,671 Finished 8 from 16 processes 2025-03-31 15:25:38,675 Finished 8 from 16 processes 2025-03-31 15:25:43,679 Finished 8 from 16 processes 2025-03-31 15:25:48,680 Finished 8 from 16 processes 2025-03-31 15:25:53,683 Finished 8 from 16 processes 2025-03-31 15:25:58,687 Finished 8 from 16 processes 2025-03-31 15:26:03,691 Finished 8 from 16 processes 2025-03-31 15:26:08,695 Finished 8 from 16 processes 2025-03-31 15:26:13,699 Finished 8 from 16 processes 2025-03-31 15:26:18,703 Finished 8 from 16 processes 2025-03-31 15:26:23,708 Finished 8 from 16 processes 2025-03-31 15:26:28,711 Finished 8 from 16 processes 2025-03-31 15:26:33,715 Finished 8 from 16 processes 2025-03-31 15:26:38,720 Finished 8 from 16 processes 2025-03-31 15:26:43,723 Finished 8 from 16 processes 2025-03-31 15:26:48,727 Finished 8 from 16 processes 2025-03-31 15:26:53,731 Finished 8 from 16 processes 2025-03-31 15:26:58,735 Finished 8 from 16 processes 2025-03-31 15:27:03,739 Finished 8 from 16 processes 2025-03-31 15:27:08,743 Finished 8 from 16 processes 2025-03-31 15:27:13,747 Finished 8 from 16 processes 2025-03-31 15:27:18,751 Finished 8 from 16 processes 2025-03-31 15:27:23,756 Finished 8 from 16 processes 2025-03-31 15:27:28,761 Finished 8 from 16 processes 2025-03-31 15:27:33,763 Finished 8 from 16 processes 2025-03-31 15:27:38,767 Finished 8 from 16 processes 2025-03-31 15:27:43,771 Finished 8 from 16 processes 2025-03-31 15:27:48,775 Finished 8 from 16 processes 2025-03-31 15:27:53,780 Finished 8 from 16 processes 2025-03-31 15:27:58,784 Finished 8 from 16 processes 2025-03-31 15:28:03,788 Finished 8 from 16 processes 2025-03-31 15:28:08,791 Finished 8 from 16 processes 2025-03-31 15:28:13,795 Finished 8 from 16 processes 2025-03-31 15:28:18,799 Finished 8 from 16 processes 2025-03-31 15:28:23,803 Finished 8 from 16 processes 2025-03-31 15:28:28,808 Finished 8 from 16 processes 2025-03-31 15:28:33,811 Finished 8 from 16 processes 2025-03-31 15:28:38,815 Finished 8 from 16 processes 2025-03-31 15:28:43,819 Finished 8 from 16 processes 2025-03-31 15:28:48,823 Finished 8 from 16 processes 2025-03-31 15:28:53,827 Finished 8 from 16 processes 2025-03-31 15:28:58,831 Finished 8 from 16 processes 2025-03-31 15:29:03,835 Finished 8 from 16 processes 2025-03-31 15:29:08,837 Finished 8 from 16 processes 2025-03-31 15:29:13,839 Finished 8 from 16 processes 2025-03-31 15:29:18,840 Finished 8 from 16 processes 2025-03-31 15:29:23,845 Finished 8 from 16 processes 2025-03-31 15:29:28,850 Finished 8 from 16 processes 2025-03-31 15:29:33,851 Finished 8 from 16 processes 2025-03-31 15:29:38,855 Finished 8 from 16 processes 2025-03-31 15:29:43,859 Finished 8 from 16 processes 2025-03-31 15:29:48,860 Finished 8 from 16 processes 2025-03-31 15:29:53,863 Finished 8 from 16 processes 2025-03-31 15:29:58,867 Finished 8 from 16 processes 2025-03-31 15:30:03,871 Finished 8 from 16 processes 2025-03-31 15:30:08,875 Finished 8 from 16 processes 2025-03-31 15:30:13,879 Finished 8 from 16 processes 2025-03-31 15:30:18,884 Finished 8 from 16 processes 2025-03-31 15:30:23,887 Finished 9 from 16 processes 2025-03-31 15:30:28,892 Finished 9 from 16 processes 2025-03-31 15:30:33,897 Finished 9 from 16 processes 2025-03-31 15:30:38,902 Finished 9 from 16 processes 2025-03-31 15:30:43,908 Finished 9 from 16 processes 2025-03-31 15:30:48,913 Finished 9 from 16 processes 2025-03-31 15:30:53,915 Finished 10 from 16 processes 2025-03-31 15:30:58,919 Finished 10 from 16 processes 2025-03-31 15:31:03,923 Finished 10 from 16 processes 2025-03-31 15:31:08,927 Finished 10 from 16 processes 2025-03-31 15:31:13,932 Finished 10 from 16 processes 2025-03-31 15:31:18,935 Finished 10 from 16 processes 2025-03-31 15:31:23,939 Finished 10 from 16 processes 2025-03-31 15:31:28,943 Finished 10 from 16 processes 2025-03-31 15:31:33,948 Finished 10 from 16 processes 2025-03-31 15:31:38,949 Finished 10 from 16 processes 2025-03-31 15:31:43,954 Finished 10 from 16 processes 2025-03-31 15:31:48,960 Finished 10 from 16 processes 2025-03-31 15:31:53,963 Finished 10 from 16 processes 2025-03-31 15:31:58,968 Finished 10 from 16 processes 2025-03-31 15:32:03,971 Finished 10 from 16 processes 2025-03-31 15:32:08,976 Finished 10 from 16 processes 2025-03-31 15:32:13,979 Finished 10 from 16 processes 2025-03-31 15:32:18,983 Finished 10 from 16 processes 2025-03-31 15:32:23,987 Finished 10 from 16 processes 2025-03-31 15:32:28,991 Finished 10 from 16 processes 2025-03-31 15:32:33,996 Finished 10 from 16 processes 2025-03-31 15:32:39,002 Finished 10 from 16 processes 2025-03-31 15:32:44,004 Finished 10 from 16 processes 2025-03-31 15:32:49,010 Finished 10 from 16 processes 2025-03-31 15:32:54,015 Finished 10 from 16 processes 2025-03-31 15:32:59,019 Finished 10 from 16 processes 2025-03-31 15:33:04,024 Finished 10 from 16 processes 2025-03-31 15:33:09,027 Finished 10 from 16 processes 2025-03-31 15:33:14,031 Finished 10 from 16 processes 2025-03-31 15:33:19,033 Finished 10 from 16 processes 2025-03-31 15:33:24,035 Finished 10 from 16 processes 2025-03-31 15:33:29,039 Finished 10 from 16 processes 2025-03-31 15:33:34,044 Finished 10 from 16 processes 2025-03-31 15:33:39,047 Finished 10 from 16 processes 2025-03-31 15:33:44,050 Finished 10 from 16 processes 2025-03-31 15:33:49,055 Finished 10 from 16 processes 2025-03-31 15:33:54,057 Finished 10 from 16 processes 2025-03-31 15:33:59,059 Finished 10 from 16 processes 2025-03-31 15:34:04,063 Finished 10 from 16 processes 2025-03-31 15:34:09,067 Finished 10 from 16 processes 2025-03-31 15:34:14,071 Finished 10 from 16 processes 2025-03-31 15:34:19,075 Finished 10 from 16 processes 2025-03-31 15:34:24,079 Finished 10 from 16 processes 2025-03-31 15:34:29,083 Finished 10 from 16 processes 2025-03-31 15:34:34,087 Finished 10 from 16 processes 2025-03-31 15:34:39,091 Finished 10 from 16 processes 2025-03-31 15:34:44,095 Finished 10 from 16 processes 2025-03-31 15:34:49,097 Finished 11 from 16 processes 2025-03-31 15:34:54,099 Finished 11 from 16 processes 2025-03-31 15:34:59,104 Finished 12 from 16 processes 2025-03-31 15:35:04,110 Finished 12 from 16 processes 2025-03-31 15:35:09,115 Finished 12 from 16 processes 2025-03-31 15:35:14,120 Finished 12 from 16 processes 2025-03-31 15:35:19,125 Finished 13 from 16 processes 2025-03-31 15:35:24,126 Finished 14 from 16 processes 2025-03-31 15:35:29,131 Finished 14 from 16 processes 2025-03-31 15:35:34,137 Finished 14 from 16 processes 2025-03-31 15:35:39,142 Finished 14 from 16 processes 2025-03-31 15:35:44,143 Finished 14 from 16 processes 2025-03-31 15:35:49,147 Finished 14 from 16 processes 2025-03-31 15:35:54,151 Finished 14 from 16 processes 2025-03-31 15:35:59,156 Finished 14 from 16 processes 2025-03-31 15:36:04,162 Finished 14 from 16 processes 2025-03-31 15:36:09,164 Finished 14 from 16 processes 2025-03-31 15:36:14,167 Finished 14 from 16 processes 2025-03-31 15:36:19,170 Finished 14 from 16 processes 2025-03-31 15:36:24,176 Finished 14 from 16 processes 2025-03-31 15:36:29,181 Finished 14 from 16 processes 2025-03-31 15:36:34,186 Finished 14 from 16 processes 2025-03-31 15:36:39,192 Finished 14 from 16 processes 2025-03-31 15:36:44,194 Finished 14 from 16 processes 2025-03-31 15:36:49,198 Finished 14 from 16 processes 2025-03-31 15:36:54,203 Finished 14 from 16 processes 2025-03-31 15:36:59,208 Finished 14 from 16 processes 2025-03-31 15:37:04,211 Finished 14 from 16 processes 2025-03-31 15:37:09,215 Finished 14 from 16 processes 2025-03-31 15:37:14,219 Finished 14 from 16 processes 2025-03-31 15:37:19,223 Finished 14 from 16 processes 2025-03-31 15:37:24,227 Finished 14 from 16 processes 2025-03-31 15:37:29,231 Finished 14 from 16 processes 2025-03-31 15:37:34,236 Finished 14 from 16 processes 2025-03-31 15:37:39,239 Finished 14 from 16 processes 2025-03-31 15:37:44,244 Finished 14 from 16 processes 2025-03-31 15:37:49,248 Finished 14 from 16 processes 2025-03-31 15:37:54,254 Finished 14 from 16 processes 2025-03-31 15:37:59,255 Finished 14 from 16 processes 2025-03-31 15:38:04,260 Finished 14 from 16 processes 2025-03-31 15:38:09,266 Finished 14 from 16 processes 2025-03-31 15:38:14,270 Finished 14 from 16 processes 2025-03-31 15:38:19,275 Finished 14 from 16 processes 2025-03-31 15:38:24,279 Finished 14 from 16 processes 2025-03-31 15:38:29,283 Finished 14 from 16 processes 2025-03-31 15:38:34,288 Finished 15 from 16 processes 2025-03-31 15:38:39,291 Finished 15 from 16 processes 2025-03-31 15:38:44,296 Finished 15 from 16 processes 2025-03-31 15:38:49,299 Finished 15 from 16 processes 2025-03-31 15:38:54,300 Finished 15 from 16 processes 2025-03-31 15:38:59,306 Finished 15 from 16 processes 2025-03-31 15:39:04,306 Finished 15 from 16 processes 2025-03-31 15:39:09,311 Finished 15 from 16 processes 2025-03-31 15:39:14,315 Finished 15 from 16 processes 2025-03-31 15:39:19,320 Finished 15 from 16 processes 2025-03-31 15:39:24,326 Finished 15 from 16 processes 2025-03-31 15:39:29,328 Finished 15 from 16 processes 2025-03-31 15:39:34,334 Finished 15 from 16 processes 2025-03-31 15:39:39,335 Finished 15 from 16 processes 2025-03-31 15:39:44,337 Finished 15 from 16 processes 2025-03-31 15:39:49,342 Finished 15 from 16 processes 2025-03-31 15:39:54,343 Finished 15 from 16 processes 2025-03-31 15:39:59,347 Finished 15 from 16 processes 2025-03-31 15:40:04,353 Finished 15 from 16 processes 2025-03-31 15:40:09,358 Finished 15 from 16 processes 2025-03-31 15:40:14,363 Finished 15 from 16 processes 2025-03-31 15:40:19,367 Finished 15 from 16 processes 2025-03-31 15:40:24,371 Finished 15 from 16 processes 2025-03-31 15:40:29,377 Finished 15 from 16 processes 2025-03-31 15:40:34,381 Finished 15 from 16 processes 2025-03-31 15:40:39,387 Finished 15 from 16 processes 2025-03-31 15:40:44,391 Finished 15 from 16 processes 2025-03-31 15:40:49,396 Finished 15 from 16 processes 2025-03-31 15:40:54,399 Finished 15 from 16 processes 2025-03-31 15:40:59,402 Finished 15 from 16 processes 2025-03-31 15:41:04,407 Finished 15 from 16 processes 2025-03-31 15:41:09,412 Finished 15 from 16 processes 2025-03-31 15:41:14,417 Finished 15 from 16 processes 2025-03-31 15:41:19,423 Finished 15 from 16 processes 2025-03-31 15:41:24,423 Finished 15 from 16 processes 2025-03-31 15:41:29,424 Finished 15 from 16 processes 2025-03-31 15:41:34,426 Finished 15 from 16 processes 2025-03-31 15:41:39,432 Finished 15 from 16 processes 2025-03-31 15:41:44,437 Finished 15 from 16 processes 2025-03-31 15:41:49,439 Finished 15 from 16 processes 2025-03-31 15:41:54,444 Finished 15 from 16 processes 2025-03-31 15:41:59,445 Finished 15 from 16 processes 2025-03-31 15:42:04,446 Finished 15 from 16 processes 2025-03-31 15:42:09,450 Finished 15 from 16 processes 2025-03-31 15:42:14,455 Finished 15 from 16 processes 2025-03-31 15:42:19,456 Finished 15 from 16 processes 2025-03-31 15:42:24,461 Finished 15 from 16 processes 2025-03-31 15:42:29,463 Finished 15 from 16 processes 2025-03-31 15:42:34,464 Finished 15 from 16 processes 2025-03-31 15:42:39,469 Finished 15 from 16 processes 2025-03-31 15:42:44,474 Finished 15 from 16 processes 2025-03-31 15:42:49,478 Finished 15 from 16 processes 2025-03-31 15:42:54,483 Finished 15 from 16 processes 2025-03-31 15:42:59,487 All processes finished 2025-03-31 15:42:59,487 Compressing stress logs 2025-03-31 15:42:59,540 Logs compressed 2025-03-31 15:42:59,540 Will terminate gdb (if any) 2025-03-31 15:42:59,541 Running command: kill -TERM $(pidof gdb) /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-03-31 15:42:59,545 Command returend 2, retrying /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-03-31 15:42:59,549 Command returend 2, retrying /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-03-31 15:43:00,553 Command returend 2, retrying /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-03-31 15:43:02,559 Command returend 2, retrying /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-03-31 15:43:05,565 Command returend 2, retrying 2025-03-31 15:43:09,567 Running command: timeout 50s tail --pid=$(pidof gdb) -f /dev/null || kill -9 $(pidof gdb) ||: tail: invalid PID: ‘’ /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-03-31 15:43:09,583 Running command: kill -CONT $(cat /var/run/clickhouse-server/clickhouse-server.pid) && clickhouse client -q 'SELECT 1 FORMAT Null' 2025-03-31 15:43:09,898 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-03-31 15:43:10,264 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-03-31 15:43:10,428 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-03-31 15:43:10,643 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-03-31 15:43:10,808 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-03-31 15:43:10,972 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-03-31 15:43:11,137 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-03-31 15:43:11,301 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-03-31 15:43:11,466 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-03-31 15:43:11,630 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-03-31 15:43:11,895 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-03-31 15:43:12,059 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-03-31 15:43:12,224 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.14): Code: 159. DB::Exception: Received from localhost:9000. DB::Exception: Timeout exceeded: elapsed 60.101148114 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-03-31 15:44:13,386 Checking if some queries hung Using queries from '/usr/share/clickhouse-test/queries' directory Connecting to ClickHouse server... OK Connected to server 24.8.14.10457.altinitytest @ b0d9f85bbd70fc8895e975ff8104a8966c89f5f7 HEAD Running 1 stateless tests (MainProcess). 00001_select_1: [ OK ] 1 tests passed. 0 tests skipped. 0.43 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. 18650 0.057 2.80 MiB 0.032 8504 106 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 2. 17515 0.053 3.46 MiB 0.04 1 107 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 3. 15249 0.046 430.26 KiB 0.005 1 88 ['Debug'] 0.098 Processed in {} sec. 4. 14518 0.044 35.69 MiB 0.409 12 513 ['Error'] 1 Table is in readonly mode (replica path: {}) 5. 12815 0.039 1.30 MiB 0.015 1 79 ['Trace'] 0.19 Checking existence of path: {} 6. 12773 0.039 313.17 KiB 0.004 1 153 ['Trace'] 0.003 Query to stage {}{} 7. 12635 0.039 608.22 KiB 0.007 1 153 ['Trace'] 0.003 Query from stage {} to stage {}{} 8. 10268 0.031 458.71 KiB 0.005 1 3 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 9. 9242 0.028 741.39 KiB 0.008 1 98 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 10. 8666 0.026 440.10 KiB 0.005 8666 116 ['Debug'] 0.999 Authenticating user '{}' from {} 11. 8539 0.026 958.97 KiB 0.011 8539 116 ['Debug'] 0.999 {} Authenticated with global context as user {} 12. 8520 0.026 748.83 KiB 0.008 8520 116 ['Debug'] 0.999 {} Logout, user_id: {} 13. 8504 0.026 622.85 KiB 0.007 8504 106 ['Debug'] 1 Creating session context with user_id: {} 14. 7023 0.021 493.99 KiB 0.006 1 693 ['Trace'] 0.597 Reserved {} on local disk {}, having unreserved {}. 15. 6797 0.021 471.37 KiB 0.005 344 672 ['Trace'] 0.591 Trying to reserve {} using storage policy from min volume index {} 16. 6789 0.021 321.10 KiB 0.004 1 222 ['Trace'] 0.436 filled checksums {} 17. 6506 0.02 770.03 KiB 0.009 341 227 ['Trace'] 0.465 Renaming temporary part {} to {} with tid {}. 18. 6190 0.019 286.43 KiB 0.003 1 131 ['Debug'] 0.178 Peak memory usage{}: {}. 19. 5295 0.016 493.82 KiB 0.006 1 88 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 20. 5295 0.016 174.13 KiB 0.002 2 88 ['Trace'] 1 TCP Request. Address: {} 21. 5268 0.016 494.26 KiB 0.006 1 57 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 22. 5231 0.016 137.93 KiB 0.002 1 88 ['Debug'] 1 Done processing connection. 23. 3375 0.01 7.61 MiB 0.087 2 92 ['Trace'] 1 Request URI: {} 24. 3375 0.01 598.78 KiB 0.007 2 92 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {} 25. 2982 0.009 61.15 KiB 0.001 2 92 ['Debug'] 0.023 Done processing query 26. 2967 0.009 171.01 KiB 0.002 16 40 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 27. 2956 0.009 105.59 KiB 0.001 16 39 ['Trace'] 1 Flushed system log up to offset {} 28. 2880 0.009 171.56 KiB 0.002 249 104 ['Debug'] 0.123 There are {} detached tables. Start searching non used tables. 29. 2880 0.009 120.94 KiB 0.001 249 104 ['Debug'] 0.123 Found {} non used tables in detached tables. 30. 2203 0.007 255.60 KiB 0.003 1 21 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 31. 1907 0.006 288.14 KiB 0.003 1 51 ['Debug'] 0 Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.) 32. 1907 0.006 94.13 KiB 0.001 1 51 ['Trace'] 0 Merging partially aggregated blocks (bucket = {}). 33. 1820 0.006 155.67 KiB 0.002 116 495 ['Trace'] 1 Scheduling next merge selecting task after {}ms, current attempt status: {} 34. 1795 0.005 138.48 KiB 0.002 1 84 ['Trace'] 0 Query span trace_id for opentelemetry log: {} 35. 1755 0.005 50.41 KiB 0.001 1 125 ['Trace'] 0 Aggregation method: {} 36. 1625 0.005 145.24 KiB 0.002 1 123 ['Trace'] 0.001 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 37. 1588 0.005 4.20 MiB 0.048 2 66 ['Error'] 0.938 Setting {} should not be changed 38. 1584 0.005 162.03 KiB 0.002 1 7 ['Trace'] 0.5 Adding file: {}, size: {} 39. 1420 0.004 197.18 KiB 0.002 79 484 ['Trace'] 1 Checked {} partitions, found {} partitions with parts that may be merged: [{}] (max_total_size_to_merge={}, merge_with_ttl_allowed={}) 40. 1330 0.004 29.87 KiB 0 1 118 ['Trace'] 0.001 Merging aggregated data 41. 1313 0.004 127.61 KiB 0.001 38 478 ['Trace'] 1 Scheduling next cleanup after {}ms (points: {}, interval: {}ms, ratio: {}, points per minute: {}) 42. 1278 0.004 159.04 KiB 0.002 2 395 ['Debug'] 1 Not executing log entry {} of type {} for part {} because merges and mutations are cancelled now. 43. 1169 0.004 62.29 KiB 0.001 93 497 ['Debug'] 0.932 Selected {} parts from {} to {} 44. 1152 0.004 12.38 KiB 0 1 120 ['Trace'] 0 Aggregating 45. 1144 0.003 107.08 KiB 0.001 1 5 ['Trace'] 1 Creating part at path {} 46. 1130 0.003 78.96 KiB 0.001 1 460 ['Trace'] 0.798 Rolling back transaction {}{} 47. 1122 0.003 136.79 KiB 0.002 1 6 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 48. 1054 0.003 35.99 KiB 0 1 58 ['Debug'] 0 Selected MergeAlgorithm: {} 49. 1054 0.003 88.21 KiB 0.001 1 58 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {} 50. 1022 0.003 116.17 KiB 0.001 204 108 ['Debug'] 0.975 Removing {} parts from filesystem (serially): Parts: [{}] 51. 1016 0.003 132.86 KiB 0.001 1 55 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec. 52. 1016 0.003 67.67 KiB 0.001 74 56 ['Trace'] 0 Merged {} parts: [{}, {}] -> {} 53. 986 0.003 79.14 KiB 0.001 174 57 ['Trace'] 0.001 Reading {} ranges in{}order from part {}, approx. {} rows starting from {} 54. 882 0.003 27.77 KiB 0 20 22 ['Debug'] 0.002 Requested flush up to offset {} 55. 878 0.003 100.04 KiB 0.001 64 38 ['Trace'] 0.987 Found {} old parts to remove. Parts: [{}] 56. 876 0.003 100.34 KiB 0.001 62 38 ['Debug'] 0.987 Removing {} parts from memory: Parts: [{}] 57. 867 0.003 3.32 MiB 0.038 15 112 ['Error'] 0.055 Cannot schedule a task: {} (threads={}, jobs={}) 58. 807 0.002 17.50 KiB 0 159 423 ['Trace'] 1 Execution took {} ms. 59. 765 0.002 22.41 KiB 0 114 407 ['Debug'] 0.997 Updating strategy picker state 60. 749 0.002 60.32 KiB 0.001 1 98 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 61. 727 0.002 56.75 KiB 0.001 69 86 ['Trace'] 0.627 Part {} is not stored on zero-copy replicated disk, blobs can be removed 62. 712 0.002 22.02 KiB 0 200 63 ['Debug'] 0.001 Key condition: {} 63. 707 0.002 31.07 KiB 0 199 63 ['Trace'] 0.001 Filtering marks by primary and secondary keys 64. 665 0.002 76.18 KiB 0.001 193 63 ['Debug'] 0.002 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 65. 636 0.002 55.64 KiB 0.001 40 368 ['Trace'] 1 Insert entry {} to queue with type {} 66. 624 0.002 17.69 KiB 0 1 158 ['Debug'] 1 Stop worker in {} 67. 624 0.002 24.41 KiB 0 1 130 ['Debug'] 0.579 Spawn loader worker #{} in {} 68. 623 0.002 45.06 KiB 0.001 1 134 ['Debug'] 1 Execute load job '{}' in {} 69. 623 0.002 42.62 KiB 0 1 134 ['Debug'] 1 Finish load job '{}' with status {} 70. 623 0.002 46.89 KiB 0.001 1 34 ['Debug'] 0.133 Schedule load job '{}' into {} 71. 614 0.002 56.43 KiB 0.001 1 35 ['Debug'] 0.091 Prioritize load job '{}': {} -> {} 72. 595 0.002 10.46 KiB 0 463 91 ['Debug'] 0.091 Loading data parts 73. 593 0.002 34.17 KiB 0 39 360 ['Debug'] 1 Pulling {} entries to queue: {} - {} 74. 593 0.002 15.06 KiB 0 39 360 ['Debug'] 1 Pulled {} entries to queue. 75. 590 0.002 32.90 KiB 0 29 120 ['Trace'] 0.658 Finished loading {} part {} on disk {} 76. 590 0.002 28.87 KiB 0 29 120 ['Trace'] 0.658 Loading {} part {} from disk {} 77. 587 0.002 89.84 KiB 0.001 1 72 ['Trace'] 0 {}Keys: {}, datatype: {}, kind: {}, strictness: {}, right header: {} 78. 580 0.002 30.02 KiB 0 163 62 ['Trace'] 0.002 Spreading mark ranges among streams (default reading) 79. 547 0.002 8.55 KiB 0 22 20 ['Debug'] 1 Scheduling tasks 80. 546 0.002 43.56 KiB 0 1 106 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={} 81. 533 0.002 17.68 KiB 0 1 132 ['Debug'] 0.523 Change current priority: {} -> {} 82. 530 0.002 120.48 KiB 0.001 22 20 ['Trace'] 1 scheduleTasks: initialized={}, size_before_filtering={}, queue_size={}, entries={}..{}, first_failed_task_name={}, current_tasks_size={}, last_current_task={}, last_skipped_entry_name={} 83. 528 0.002 12.89 KiB 0 22 20 ['Debug'] 1 Waiting for queue updates 84. 517 0.002 4.54 KiB 0 2 34 ['Trace'] 0.015 No tables 85. 477 0.001 10.71 KiB 0 453 63 ['Debug'] 0.048 There are no data parts 86. 468 0.001 19.65 KiB 0 11 11 ['Trace'] 1 Too early to clean queue, will do it later. 87. 459 0.001 34.15 KiB 0 53 55 ['Debug'] 0 Wrote block with ID '{}', {} rows{} 88. 450 0.001 33.40 KiB 0 1 35 ['Debug'] 0 Waiting for table {} to be finally dropped 89. 450 0.001 51.86 KiB 0.001 1 35 ['Debug'] 0 Done waiting for the table {} to be dropped. The outcome: {} 90. 438 0.001 19.11 KiB 0 1 3 ['Information'] 1 {} for session {} took {} ms 91. 424 0.001 499.32 KiB 0.006 20 54 ['Information','Error','Warning'] 0.495 92. 407 0.001 12.09 KiB 0 31 90 ['Trace'] 0 Found (RIGHT) boundary mark: {} 93. 407 0.001 11.65 KiB 0 31 90 ['Trace'] 0 Found (LEFT) boundary mark: {} 94. 407 0.001 12.83 KiB 0 31 90 ['Trace'] 0 Found {} range {}in {} steps 95. 407 0.001 27.68 KiB 0 31 90 ['Trace'] 0 Running binary search on index range for part {} ({} marks) 96. 405 0.001 1.57 MiB 0.018 2 33 ['Error'] 0 Table {}.{} already exists 97. 399 0.001 11.69 KiB 0 22 18 ['Trace'] 1 Checking task {} 98. 397 0.001 20.16 KiB 0 22 18 ['Debug'] 1 Will schedule {} tasks starting from {} 99. 386 0.001 29.57 KiB 0 114 98 ['Debug'] 0.404 Creating shared ID for table {} 100. 383 0.001 27.68 KiB 0 1 277 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {} tables 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. 69 Connectiontomysqlfailedtimes Connection to mysql failed 1 times ('',0) 2. 67 DBExceptionThereisnouserinvalids DB::Exception: There is no user `invalid_session_log_test_xml_user` in user directories ('',0) 3. 39 DBExceptionsessionlogtestuseracd DB::Exception: session_log_test_user_03a647c9d8f3b14ceecafd1b1db14be8_plaintext_password_no_profiles_no_roles: Authentication failed: password is incorrect, or there is no user with such name. ('',0) 4. 39 Connectiontosystemasuserinvalids Connection to system@127.0.0.1:9004 as user invalid_session_log_test_xml_user failed: mysqlxx::ConnectionFailed: There is no user `invalid_session_log_test_xml_user` in user directories ((nullptr):9004) ('',0) 5. 38 CodeDBExceptionReceivedfromDBExc Code: 439. DB::Exception: Received from 127.0.0.9:9000. DB::Exception: Cannot schedule a task: fault injected (threads=10, jobs=8): While executing MergeTreeSelect(pool: ReadPoolParallelReplicas, algorithm: Thread). Stack trace: 0. ./contrib/llvm-project/ ('/executeQuery.cpp',221) 6. 27 Connectiontosystemasusersessionl Connection to system@127.0.0.1:9004 as user session_log_test_user_03a647c9d8f3b14ceecafd1b1db14be8_plaintext_password_no_profiles_no_roles failed: mysqlxx::ConnectionFailed: session_log_test_user_03a647c9d8f3b14ceecafd1b1db14be8_plaintext_password_no_profi ('',0) 7. 16 CodeDBExceptionOkwhileexecutingF Code: 395. DB::Exception: Ok: while executing 'FUNCTION throwIf(greater(__table1.number, 10000000_UInt32) :: 1, 'Ok'_String :: 4) -> throwIf(greater(__table1.number, 10000000_UInt32), 'Ok'_String) UInt8 : 3'. (FUNCTION_THROW_IF_VALUE_IS_NON_ZERO) (version ('/executeQuery.cpp',221) 8. 12 voidDBStorageReplicatedMergeTree void DB::StorageReplicatedMergeTree::mutationsUpdatingTask(): Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. ./contrib/llvm-project/libcxx/include/except ('/Exception.cpp',273) 9. 10 CodeDBExceptionSyntaxerrorfailed Code: 62. DB::Exception: Syntax error: failed at position 46 ('numbers'): numbers. Expected one of: token, Comma, FROM, PREWHERE, WHERE, GROUP BY, WITH, HAVING, WINDOW, QUALIFY, ORDER BY, LIMIT, OFFSET, FETCH, SETTINGS, UNION, EXCEPT, INTERSECT, INTO OUTFI ('/executeQuery.cpp',221) 10. 6 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',273) 11. 6 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 0 ('/LoggerWrapper.h',43) 12. 3 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 13. 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) 14. 3 StartingClickHousealtinitytestre Starting ClickHouse 24.8.14.10457.altinitytest (revision: 4294967295, git hash: b0d9f85bbd70fc8895e975ff8104a8966c89f5f7, build id: DB516CB92D446316C29BB05EB4496EA10744C1E2), PID 414 ('',0) 15. 3 ConnectiontosystemasuserMYSQLUSE Connection to system@127.0.0.1:9004 as user 02833_MYSQL_USER_30754 failed: mysqlxx::ConnectionFailed: 02833_MYSQL_USER_30754: Authentication failed: password is incorrect, or there is no user with such name. ((nullptr):9004) ('',0) 16. 3 statemachinecommitindexprecommit state machine commit index 0, precommit index 0, last log index 0 ('/LoggerWrapper.h',43) 17. 3 Forkedachildprocesstowatch Forked a child process to watch ('',0) 18. 3 skippedconfiglatestconfig skipped config 1, latest config 1 ('/LoggerWrapper.h',43) 19. 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) 20. 3 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1 my id: 1, voting_member num peers: 0 ('/LoggerWrapper.h',43) 21. 3 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 22. 3 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',43) 23. 3 RaftASIOlistenerinitiatedonunsec Raft ASIO listener initiated on :::9234, unsecured ('/LoggerWrapper.h',43) 24. 3 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',43) 25. 3 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 1 ('/LoggerWrapper.h',43) 26. 3 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',43) 27. 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) 28. 3 newelectiontimeoutrange new election timeout range: 0 - 0 ('/LoggerWrapper.h',43) 29. 3 startingup starting up ('',0) 30. 3 PRIORITYdecaytargetmine [PRIORITY] decay, target 1 -> 1, mine 1 ('/LoggerWrapper.h',43) Top messages not matching their format strings: message_format_string count() any_message 1. 224 Connection to system@127.0.0.1:9004 as user invalid_session_log_test_xml_user failed: mysqlxx::ConnectionFailed: There is no user `invalid_session_log_test_xml_user` in user directories ((nullptr):9004) 2. {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 8 /var/lib/clickhouse/store/ce3/ce392f47-7c60-43d0-a0bf-8f2a45886227/tmp_merge_202503_1_196_106/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 1 similar messages) Top short messages: c message_format_string substr(any(toValidUTF8(message)), 1, 120) min_length_without_exception_boilerplate 1. 17 {} ThreadFuzzer is enabled. Application will run slowly and unstable. 35 2. 14 Cannot TRUNCATE dictionary Code: 62. DB::Exception: Cannot TRUNCATE dictionary. (SYNTAX_ERROR) (version 24.8.14.10457.altinitytest (altinity build) 27 3. 9 Froze {} parts Froze 10 parts -13 4. 4 Database {} does not exist Code: 81. DB::Exception: Database kek does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always 28 5. 2 Found {} on {} Found changelog_1_100000.bin on LocalLogDisk 18 Top messages by level: (0.04419563218810694,'Table is in readonly mode (replica path: {})') Error (0.0002861543894256821,'ZooKeeper session has expired. Switching to a new session.') Warning (0.0013333576868983909,'{} for session {} took {} ms') Information (0.05332821908467126,'(from {}{}{}){}{} {} (stage: {})') Debug (0.05678338112720476,'{} Creating query context from {} context, user_id: {}, parent context user: {}') Trace 2025-03-31 15:44:20,019 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=2646 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2646. The process with pid = 2646 is running. Sent terminate signal to process with pid 2646. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2646. The process with pid = 2646 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2646. The process with pid = 2646 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2646. The process with pid = 2646 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2646. The process with pid = 2646 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2646. The process with pid = 2646 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2646. The process with pid = 2646 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2646. The process with pid = 2646 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2646. The process with pid = 2646 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 127.0.0.1 - - [31/Mar/2025:13:44:29 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - 127.0.0.1 - - [31/Mar/2025:13:44:29 +0000] "PUT /devstoreaccount1/cont/eyulzspptkzteztikxfxxejcnidqhxqn HTTP/1.1" 201 - 127.0.0.1 - - [31/Mar/2025:13:44:29 +0000] "GET /devstoreaccount1/cont/eyulzspptkzteztikxfxxejcnidqhxqn HTTP/1.1" 206 4 127.0.0.1 - - [31/Mar/2025:13:44:29 +0000] "GET /devstoreaccount1/cont/eyulzspptkzteztikxfxxejcnidqhxqn HTTP/1.1" 206 2 127.0.0.1 - - [31/Mar/2025:13:44:29 +0000] "DELETE /devstoreaccount1/cont/eyulzspptkzteztikxfxxejcnidqhxqn HTTP/1.1" 202 - + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' 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=1 + [[ 1 = \1 ]] ASAN build detected. Not using gdb since it disables LeakSanitizer detections + echo 'ASAN build detected. Not using gdb since it disables LeakSanitizer detections' + 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=50308 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 50308. The process with pid = 50308 is running. Sent terminate signal to process with pid 50308. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 50308. The process with pid = 50308 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 50308. The process with pid = 50308 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 50308. The process with pid = 50308 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 50308. The process with pid = 50308 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 50308. The process with pid = 50308 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 50308. The process with pid = 50308 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 50308. The process with pid = 50308 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 50308. The process with pid = 50308 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 50308. The process with pid = 50308 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 50308. The process with pid = 50308 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 50308. The process with pid = 50308 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + '[' -f /var/log/clickhouse-server/clickhouse-server.log ']' + '[' -f /var/log/clickhouse-server/stderr.log ']' + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.final.log + check_logs_for_critical_errors + sed -n '/WARNING:.*anitizer/,/^$/p' /var/log/clickhouse-server/stderr.log + rg -Fav -e 'ASan doesn'\''t fully support makecontext/swapcontext functions' -e DB::Exception /test_output/tmp + echo -e 'No sanitizer asserts\tOK\t\N\t' + rm -f /test_output/tmp + rg -Fa ' Application: Child process was terminated by signal 9' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No OOM messages in clickhouse-server.log\tOK\t\N\t' + rg -Fa 'Code: 49. DB::Exception: ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No logical errors\tOK\t\N\t' + '[' -s /test_output/logical_errors.txt ']' + rm /test_output/logical_errors.txt + rg --text 'Code: 499.*The specified key does not exist' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + grep -v a.myext + echo -e 'No lost s3 keys\tOK\t\N\t' + rg -Fa 'it is lost forever' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + grep SharedMergeTreePartCheckThread + echo -e 'No SharedMergeTree lost forever in clickhouse-server.log\tOK\t\N\t' + '[' -s /test_output/no_such_key_errors.txt ']' + rm /test_output/no_such_key_errors.txt + rg -Fa '########################################' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'Not crashed\tOK\t\N\t' + rg -Fa ' ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No fatal messages in clickhouse-server.log\tOK\t\N\t' + '[' -s /test_output/fatal_messages.txt ']' + rm /test_output/fatal_messages.txt + rg -Faz '########################################' /test_output/stress_run_logs.tar.zst /test_output/test_results.tsv + rg -Fa ' received signal ' /test_output/gdb.log /test_output/gdb.log: No such file or directory (os error 2) + 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 - - [31/Mar/2025:13:44:43 +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 - - [31/Mar/2025:13:44:47 +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 - - [31/Mar/2025:13:44:50 +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 + read -r core + find . -type f -maxdepth 1 -name 'core.*'