+ 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.10531.altinitytest_amd64.deb
Selecting previously unselected package clickhouse-common-static.
(Reading database ... 48696 files and directories currently installed.)
Preparing to unpack .../clickhouse-common-static_24.8.14.10531.altinitytest_amd64.deb ...
Unpacking clickhouse-common-static (24.8.14.10531.altinitytest) ...
Setting up clickhouse-common-static (24.8.14.10531.altinitytest) ...
+ dpkg -i package_folder/clickhouse-common-static-dbg_24.8.14.10531.altinitytest_amd64.deb
Selecting previously unselected package clickhouse-common-static-dbg.
(Reading database ... 48723 files and directories currently installed.)
Preparing to unpack .../clickhouse-common-static-dbg_24.8.14.10531.altinitytest_amd64.deb ...
Unpacking clickhouse-common-static-dbg (24.8.14.10531.altinitytest) ...
Setting up clickhouse-common-static-dbg (24.8.14.10531.altinitytest) ...
+ dpkg -i package_folder/clickhouse-server_24.8.14.10531.altinitytest_amd64.deb
Selecting previously unselected package clickhouse-server.
(Reading database ... 48730 files and directories currently installed.)
Preparing to unpack .../clickhouse-server_24.8.14.10531.altinitytest_amd64.deb ...
Unpacking clickhouse-server (24.8.14.10531.altinitytest) ...
Setting up clickhouse-server (24.8.14.10531.altinitytest) ...
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.10531.altinitytest_amd64.deb
Selecting previously unselected package clickhouse-client.
(Reading database ... 48747 files and directories currently installed.)
Preparing to unpack .../clickhouse-client_24.8.14.10531.altinitytest_amd64.deb ...
Unpacking clickhouse-client (24.8.14.10531.altinitytest) ...
Setting up clickhouse-client (24.8.14.10531.altinitytest) ...
+ 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=1
+ sed --follow-symlinks -i 's|<create_snapshot_on_exit>[01]</create_snapshot_on_exit>|<create_snapshot_on_exit>1</create_snapshot_on_exit>|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=3203072
+ sed --follow-symlinks -i 's|<latest_logs_cache_size_threshold>[[:digit:]]\+</latest_logs_cache_size_threshold>|<latest_logs_cache_size_threshold>3203072</latest_logs_cache_size_threshold>|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=56596480
+ sed --follow-symlinks -i 's|<commit_logs_cache_size_threshold>[[:digit:]]\+</commit_logs_cache_size_threshold>|<commit_logs_cache_size_threshold>56596480</commit_logs_cache_size_threshold>|' /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|<snapshot_distance>100000</snapshot_distance>|<snapshot_distance>10000</snapshot_distance>|'
+ 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|<filtered_list>[01]</filtered_list>|<filtered_list>0</filtered_list>|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value multi_read keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|<multi_read>[01]</multi_read>|<multi_read>0</multi_read>|'
+ 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|<check_not_exists>[01]</check_not_exists>|<check_not_exists>0</check_not_exists>|'
+ 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|<create_if_not_exists>[01]</create_if_not_exists>|<create_if_not_exists>0</create_if_not_exists>|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value use_compression zookeeper_fault_injection
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ sed 's|<use_compression>[01]</use_compression>|<use_compression>1</use_compression>|'
+ 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|<enable_block_number_column>[01]</enable_block_number_column>|<enable_block_number_column>1</enable_block_number_column>|'
+ 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|<enable_block_offset_column>[01]</enable_block_offset_column>|<enable_block_offset_column>1</enable_block_offset_column>|'
+ sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml
+ echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\'''
+ export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ sudo chown root: /var/lib/clickhouse
+ local total_mem
++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo
+ total_mem=32086440
+ total_mem=32856514560
+ max_server_memory_usage_to_ram_ratio=0.5
+ echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5'
+ cat
Setting max_server_memory_usage_to_ram_ratio to 0.5
Setting max_memory_usage_for_user=9856954368 and max_memory_usage for queries to 10G
+ local max_users_mem
+ max_users_mem=9856954368
+ echo 'Setting max_memory_usage_for_user=9856954368 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
+ params=('--silent' '--verbose')
+ ./minio server --address :11111 ./minio_data
+ local params
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 0 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
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:46855 http://127.0.0.1:46855    

Docs: https://min.io/docs/minio/linux/index.html
+ counter=1
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
<Error><Code>AccessDenied</Code><Message>Access Denied.</Message><Resource>/</Resource><RequestId>18705048053FB15D</RequestId><HostId>7dc7eb22d3288ec80374614e9088e31d3668a6922ead55932dd2a8e56373820f</HostId></Error>
+ lsof -i :11111
COMMAND PID USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
minio   276 root    6u  IPv6  29526      0t0  TCP *:11111 (LISTEN)
minio   276 root    9u  IPv4  29525      0t0  TCP localhost:11111 (LISTEN)
minio   276 root   10u  IPv6  29527      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: 142.88 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
+ export CLICKHOUSE_MAX_THREADS=8
+ CLICKHOUSE_MAX_THREADS=8
+ export CLICKHOUSE_MAX_CONCURRENT_QUERIES=4
+ CLICKHOUSE_MAX_CONCURRENT_QUERIES=4
+ start_server
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 13 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=14
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 14 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=15
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 15 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
127.0.0.1 - - [20/Oct/2025:21:29:01 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 404 -
127.0.0.1 - - [20/Oct/2025:21:29:01 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 -
127.0.0.1 - - [20/Oct/2025:21:29:01 +0000] "PUT /devstoreaccount1/cont/paeoozlpxtqebqfkubxaooeduzllgxsk HTTP/1.1" 201 -
127.0.0.1 - - [20/Oct/2025:21:29:01 +0000] "GET /devstoreaccount1/cont/paeoozlpxtqebqfkubxaooeduzllgxsk HTTP/1.1" 206 4
127.0.0.1 - - [20/Oct/2025:21:29:01 +0000] "GET /devstoreaccount1/cont/paeoozlpxtqebqfkubxaooeduzllgxsk HTTP/1.1" 206 2
127.0.0.1 - - [20/Oct/2025:21:29:01 +0000] "DELETE /devstoreaccount1/cont/paeoozlpxtqebqfkubxaooeduzllgxsk HTTP/1.1" 202 -
+ counter=16
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ [[ hxB =~ e ]]
++ set_e=false
++ set +e
++ local total_retries=5
++ shift
++ local retry=0
++ '[' 0 -ge 5 ']'
++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ false
++ return
+ IS_ASAN=0
+ [[ 0 = \1 ]]
++ kill -l SIGRTMIN
+ RTMIN=34
+ echo '
        set follow-fork-mode parent
        handle SIGHUP nostop noprint pass
        handle SIGINT nostop noprint pass
        handle SIGQUIT nostop noprint pass
        handle SIGPIPE nostop noprint pass
        handle SIGTERM nostop noprint pass
        handle SIGUSR1 nostop noprint pass
        handle SIGUSR2 nostop noprint pass
        handle SIG34 nostop noprint pass
        info signals
        continue
        backtrace full
        info registers
        p top' 1 KiB of the 'stack:
        p/x *(uint64_t[128]*)$sp
        maintenance info sections
        thread apply all backtrace full
        disassemble /s
        up
        disassemble /s
        up
        disassemble /s
        p "done"
        detach
        quit
        '
+ sleep 5
+ ts '%Y-%m-%d %H:%M:%S'
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ gdb -batch -command script.gdb -p 411
+ run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
+ [[ hxB =~ e ]]
+ set_e=false
+ set +e
+ local total_retries=60
+ shift
+ local retry=0
+ '[' 0 -ge 60 ']'
+ clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
Connected to clickhouse-server after attaching gdb
+ false
+ return
+ setup_logs_replication
+ set +x
File /tmp/export-logs-config.sh does not exist, do not setup
+ clickhouse-client --query 'CREATE DATABASE datasets'
+ clickhouse-client --multiquery
+ clickhouse-client --query 'SHOW TABLES FROM datasets'
hits_v1
visits_v1
+ clickhouse-client --query 'CREATE DATABASE IF NOT EXISTS test'
+ stop_server
+ local max_tries=90
+ local check_hang=true
+ local pid
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ pid=411
+ clickhouse stop --max-tries 90 --do-not-kill
script.gdb:13: Error in sourced command file:
No stack.
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Sent terminate signal to process with pid 411.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 411.
The process with pid = 411 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.initial.log
+ cache_policy=
+ '[' 1 -eq 1 ']'
+ cache_policy=SLRU
+ echo 'Using cache policy: SLRU'
+ '[' SLRU = SLRU ']'
Using cache policy: SLRU
+ sudo cat /etc/clickhouse-server/config.d/storage_conf.xml
+ sed 's|<cache_policy>LRU</cache_policy>|<cache_policy>SLRU</cache_policy>|'
+ 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
+ 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 - - [20/Oct/2025:21:30:04 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 -
127.0.0.1 - - [20/Oct/2025:21:30:04 +0000] "PUT /devstoreaccount1/cont/zktdrikquczuaynihlssdsqelbimebjf HTTP/1.1" 201 -
+ counter=10
+ clickhouse-client --query 'SELECT 1'
127.0.0.1 - - [20/Oct/2025:21:30:04 +0000] "GET /devstoreaccount1/cont/zktdrikquczuaynihlssdsqelbimebjf HTTP/1.1" 206 4
127.0.0.1 - - [20/Oct/2025:21:30:04 +0000] "GET /devstoreaccount1/cont/zktdrikquczuaynihlssdsqelbimebjf HTTP/1.1" 206 2
127.0.0.1 - - [20/Oct/2025:21:30:04 +0000] "DELETE /devstoreaccount1/cont/zktdrikquczuaynihlssdsqelbimebjf HTTP/1.1" 202 -
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 13 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=14
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 14 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=15
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 15 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=16
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 16 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=17
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 17 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=18
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 18 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=19
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 19 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=20
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 20 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=21
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 21 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=22
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 22 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=23
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 23 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=24
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 24 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=25
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 25 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=26
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 26 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=27
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 27 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=28
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ [[ hxB =~ e ]]
++ set_e=false
++ set +e
++ local total_retries=5
++ shift
++ local retry=0
++ '[' 0 -ge 5 ']'
++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ false
++ return
+ IS_ASAN=0
+ [[ 0 = \1 ]]
++ kill -l SIGRTMIN
+ RTMIN=34
+ echo '
        set follow-fork-mode parent
        handle SIGHUP nostop noprint pass
        handle SIGINT nostop noprint pass
        handle SIGQUIT nostop noprint pass
        handle SIGPIPE nostop noprint pass
        handle SIGTERM nostop noprint pass
        handle SIGUSR1 nostop noprint pass
        handle SIGUSR2 nostop noprint pass
        handle SIG34 nostop noprint pass
        info signals
        continue
        backtrace full
        info registers
        p top' 1 KiB of the 'stack:
        p/x *(uint64_t[128]*)$sp
        maintenance info sections
        thread apply all backtrace full
        disassemble /s
        up
        disassemble /s
        up
        disassemble /s
        p "done"
        detach
        quit
        '
+ sleep 5
+ ts '%Y-%m-%d %H:%M:%S'
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ gdb -batch -command script.gdb -p 1393
+ run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
+ [[ hxB =~ e ]]
+ set_e=false
+ set +e
+ local total_retries=60
+ shift
+ local retry=0
+ '[' 0 -ge 60 ']'
+ clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
Connected to clickhouse-server after attaching gdb
+ false
+ return
+ clickhouse-client --query 'SHOW TABLES FROM datasets'
hits_v1
visits_v1
+ clickhouse-client --query 'SHOW TABLES FROM test'
+ [[ '' == \1 ]]
+ [[ '' == \1 ]]
+ TEMP_POLICY=default
+ clickhouse-client --query 'CREATE TABLE test.hits_s3 (WatchID UInt64,  JavaEnable UInt8,  Title String,  GoodEvent Int16,
    EventTime DateTime,  EventDate Date,  CounterID UInt32,  ClientIP UInt32,  ClientIP6 FixedString(16),  RegionID UInt32,
    UserID UInt64,  CounterClass Int8,  OS UInt8,  UserAgent UInt8,  URL String,  Referer String,  URLDomain String,  RefererDomain String,
    Refresh UInt8,  IsRobot UInt8,  RefererCategories Array(UInt16),  URLCategories Array(UInt16), URLRegions Array(UInt32),
    RefererRegions Array(UInt32),  ResolutionWidth UInt16,  ResolutionHeight UInt16,  ResolutionDepth UInt8,  FlashMajor UInt8,
    FlashMinor UInt8,  FlashMinor2 String,  NetMajor UInt8,  NetMinor UInt8, UserAgentMajor UInt16,  UserAgentMinor FixedString(2),
    CookieEnable UInt8, JavascriptEnable UInt8,  IsMobile UInt8,  MobilePhone UInt8,  MobilePhoneModel String,  Params String,
    IPNetworkID UInt32,  TraficSourceID Int8, SearchEngineID UInt16,  SearchPhrase String,  AdvEngineID UInt8,  IsArtifical UInt8,
    WindowClientWidth UInt16,  WindowClientHeight UInt16,  ClientTimeZone Int16,  ClientEventTime DateTime,  SilverlightVersion1 UInt8,
    SilverlightVersion2 UInt8,  SilverlightVersion3 UInt32,  SilverlightVersion4 UInt16,  PageCharset String,  CodeVersion UInt32,
    IsLink UInt8,  IsDownload UInt8,  IsNotBounce UInt8,  FUniqID UInt64,  HID UInt32,  IsOldCounter UInt8, IsEvent UInt8,
    IsParameter UInt8,  DontCountHits UInt8,  WithHash UInt8, HitColor FixedString(1),  UTCEventTime DateTime,  Age UInt8,
    Sex UInt8,  Income UInt8,  Interests UInt16,  Robotness UInt8,  GeneralInterests Array(UInt16), RemoteIP UInt32,
    RemoteIP6 FixedString(16),  WindowName Int32,  OpenerName Int32,  HistoryLength Int16,  BrowserLanguage FixedString(2),
    BrowserCountry FixedString(2),  SocialNetwork String,  SocialAction String,  HTTPError UInt16, SendTiming Int32,
    DNSTiming Int32,  ConnectTiming Int32,  ResponseStartTiming Int32,  ResponseEndTiming Int32,  FetchTiming Int32,
    RedirectTiming Int32, DOMInteractiveTiming Int32,  DOMContentLoadedTiming Int32,  DOMCompleteTiming Int32,
    LoadEventStartTiming Int32,  LoadEventEndTiming Int32, NSToDOMContentLoadedTiming Int32,  FirstPaintTiming Int32,
    RedirectCount Int8, SocialSourceNetworkID UInt8,  SocialSourcePage String,  ParamPrice Int64, ParamOrderID String,
    ParamCurrency FixedString(3),  ParamCurrencyID UInt16, GoalsReached Array(UInt32),  OpenstatServiceName String,
    OpenstatCampaignID String,  OpenstatAdID String,  OpenstatSourceID String,  UTMSource String, UTMMedium String,
    UTMCampaign String,  UTMContent String,  UTMTerm String, FromTag String,  HasGCLID UInt8,  RefererHash UInt64,
    URLHash UInt64,  CLID UInt32,  YCLID UInt64,  ShareService String,  ShareURL String,  ShareTitle String,
    ParsedParams Nested(Key1 String,  Key2 String, Key3 String, Key4 String, Key5 String,  ValueDouble Float64),
    IslandID FixedString(16),  RequestNum UInt32,  RequestTry UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate)
    ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''default'\'''
+ clickhouse-client --query 'CREATE TABLE test.hits (WatchID UInt64,  JavaEnable UInt8,  Title String,  GoodEvent Int16,
    EventTime DateTime,  EventDate Date,  CounterID UInt32,  ClientIP UInt32,  ClientIP6 FixedString(16),  RegionID UInt32,
    UserID UInt64,  CounterClass Int8,  OS UInt8,  UserAgent UInt8,  URL String,  Referer String,  URLDomain String,
    RefererDomain String,  Refresh UInt8,  IsRobot UInt8,  RefererCategories Array(UInt16),  URLCategories Array(UInt16),
    URLRegions Array(UInt32),  RefererRegions Array(UInt32),  ResolutionWidth UInt16,  ResolutionHeight UInt16,  ResolutionDepth UInt8,
    FlashMajor UInt8, FlashMinor UInt8,  FlashMinor2 String,  NetMajor UInt8,  NetMinor UInt8, UserAgentMajor UInt16,
    UserAgentMinor FixedString(2),  CookieEnable UInt8, JavascriptEnable UInt8,  IsMobile UInt8,  MobilePhone UInt8,
    MobilePhoneModel String,  Params String,  IPNetworkID UInt32,  TraficSourceID Int8, SearchEngineID UInt16,
    SearchPhrase String,  AdvEngineID UInt8,  IsArtifical UInt8,  WindowClientWidth UInt16,  WindowClientHeight UInt16,
    ClientTimeZone Int16,  ClientEventTime DateTime,  SilverlightVersion1 UInt8, SilverlightVersion2 UInt8,  SilverlightVersion3 UInt32,
    SilverlightVersion4 UInt16,  PageCharset String,  CodeVersion UInt32,  IsLink UInt8,  IsDownload UInt8,  IsNotBounce UInt8,
    FUniqID UInt64,  HID UInt32,  IsOldCounter UInt8, IsEvent UInt8,  IsParameter UInt8,  DontCountHits UInt8,  WithHash UInt8,
    HitColor FixedString(1),  UTCEventTime DateTime,  Age UInt8,  Sex UInt8,  Income UInt8,  Interests UInt16,  Robotness UInt8,
    GeneralInterests Array(UInt16), RemoteIP UInt32,  RemoteIP6 FixedString(16),  WindowName Int32,  OpenerName Int32,
    HistoryLength Int16,  BrowserLanguage FixedString(2),  BrowserCountry FixedString(2),  SocialNetwork String,  SocialAction String,
    HTTPError UInt16, SendTiming Int32,  DNSTiming Int32,  ConnectTiming Int32,  ResponseStartTiming Int32,  ResponseEndTiming Int32,
    FetchTiming Int32,  RedirectTiming Int32, DOMInteractiveTiming Int32,  DOMContentLoadedTiming Int32,  DOMCompleteTiming Int32,
    LoadEventStartTiming Int32,  LoadEventEndTiming Int32, NSToDOMContentLoadedTiming Int32,  FirstPaintTiming Int32,
    RedirectCount Int8, SocialSourceNetworkID UInt8,  SocialSourcePage String,  ParamPrice Int64, ParamOrderID String,
    ParamCurrency FixedString(3),  ParamCurrencyID UInt16, GoalsReached Array(UInt32),  OpenstatServiceName String,
    OpenstatCampaignID String,  OpenstatAdID String,  OpenstatSourceID String,  UTMSource String, UTMMedium String,
    UTMCampaign String,  UTMContent String,  UTMTerm String, FromTag String,  HasGCLID UInt8,  RefererHash UInt64,
    URLHash UInt64,  CLID UInt32,  YCLID UInt64,  ShareService String,  ShareURL String,  ShareTitle String,
    ParsedParams Nested(Key1 String,  Key2 String, Key3 String, Key4 String, Key5 String,  ValueDouble Float64),
    IslandID FixedString(16),  RequestNum UInt32,  RequestTry UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate)
    ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''default'\'''
+ clickhouse-client --query 'CREATE TABLE test.visits (CounterID UInt32,  StartDate Date,  Sign Int8,  IsNew UInt8,
    VisitID UInt64,  UserID UInt64,  StartTime DateTime,  Duration UInt32,  UTCStartTime DateTime,  PageViews Int32,
    Hits Int32,  IsBounce UInt8,  Referer String,  StartURL String,  RefererDomain String,  StartURLDomain String,
    EndURL String,  LinkURL String,  IsDownload UInt8,  TraficSourceID Int8,  SearchEngineID UInt16,  SearchPhrase String,
    AdvEngineID UInt8,  PlaceID Int32,  RefererCategories Array(UInt16),  URLCategories Array(UInt16),  URLRegions Array(UInt32),
    RefererRegions Array(UInt32),  IsYandex UInt8,  GoalReachesDepth Int32,  GoalReachesURL Int32,  GoalReachesAny Int32,
    SocialSourceNetworkID UInt8,  SocialSourcePage String,  MobilePhoneModel String,  ClientEventTime DateTime,  RegionID UInt32,
    ClientIP UInt32,  ClientIP6 FixedString(16),  RemoteIP UInt32,  RemoteIP6 FixedString(16),  IPNetworkID UInt32,
    SilverlightVersion3 UInt32,  CodeVersion UInt32,  ResolutionWidth UInt16,  ResolutionHeight UInt16,  UserAgentMajor UInt16,
    UserAgentMinor UInt16,  WindowClientWidth UInt16,  WindowClientHeight UInt16,  SilverlightVersion2 UInt8,  SilverlightVersion4 UInt16,
    FlashVersion3 UInt16,  FlashVersion4 UInt16,  ClientTimeZone Int16,  OS UInt8,  UserAgent UInt8,  ResolutionDepth UInt8,
    FlashMajor UInt8,  FlashMinor UInt8,  NetMajor UInt8,  NetMinor UInt8,  MobilePhone UInt8,  SilverlightVersion1 UInt8,
    Age UInt8,  Sex UInt8,  Income UInt8,  JavaEnable UInt8,  CookieEnable UInt8,  JavascriptEnable UInt8,  IsMobile UInt8,
    BrowserLanguage UInt16,  BrowserCountry UInt16,  Interests UInt16,  Robotness UInt8,  GeneralInterests Array(UInt16),
    Params Array(String),  Goals Nested(ID UInt32, Serial UInt32, EventTime DateTime,  Price Int64,  OrderID String, CurrencyID UInt32),
    WatchIDs Array(UInt64),  ParamSumPrice Int64,  ParamCurrency FixedString(3),  ParamCurrencyID UInt16,  ClickLogID UInt64,
    ClickEventID Int32,  ClickGoodEvent Int32,  ClickEventTime DateTime,  ClickPriorityID Int32,  ClickPhraseID Int32,  ClickPageID Int32,
    ClickPlaceID Int32,  ClickTypeID Int32,  ClickResourceID Int32,  ClickCost UInt32,  ClickClientIP UInt32,  ClickDomainID UInt32,
    ClickURL String,  ClickAttempt UInt8,  ClickOrderID UInt32,  ClickBannerID UInt32,  ClickMarketCategoryID UInt32,  ClickMarketPP UInt32,
    ClickMarketCategoryName String,  ClickMarketPPName String,  ClickAWAPSCampaignName String,  ClickPageName String,  ClickTargetType UInt16,
    ClickTargetPhraseID UInt64,  ClickContextType UInt8,  ClickSelectType Int8,  ClickOptions String,  ClickGroupBannerID Int32,
    OpenstatServiceName String,  OpenstatCampaignID String,  OpenstatAdID String,  OpenstatSourceID String,  UTMSource String,
    UTMMedium String,  UTMCampaign String,  UTMContent String,  UTMTerm String,  FromTag String,  HasGCLID UInt8,  FirstVisit DateTime,
    PredLastVisit Date,  LastVisit Date,  TotalVisits UInt32,  TraficSource    Nested(ID Int8,  SearchEngineID UInt16, AdvEngineID UInt8,
    PlaceID UInt16, SocialSourceNetworkID UInt8, Domain String, SearchPhrase String, SocialSourcePage String),  Attendance FixedString(16),
    CLID UInt32,  YCLID UInt64,  NormalizedRefererHash UInt64,  SearchPhraseHash UInt64,  RefererDomainHash UInt64,  NormalizedStartURLHash UInt64,
    StartURLDomainHash UInt64,  NormalizedEndURLHash UInt64,  TopLevelDomain UInt64,  URLScheme UInt64,  OpenstatServiceNameHash UInt64,
    OpenstatCampaignIDHash UInt64,  OpenstatAdIDHash UInt64,  OpenstatSourceIDHash UInt64,  UTMSourceHash UInt64,  UTMMediumHash UInt64,
    UTMCampaignHash UInt64,  UTMContentHash UInt64,  UTMTermHash UInt64,  FromHash UInt64,  WebVisorEnabled UInt8,  WebVisorActivity UInt32,
    ParsedParams    Nested(Key1 String,  Key2 String,  Key3 String,  Key4 String, Key5 String, ValueDouble    Float64),
    Market Nested(Type UInt8, GoalID UInt32, OrderID String,  OrderPrice Int64,  PP UInt32,  DirectPlaceID UInt32,  DirectOrderID  UInt32,
    DirectBannerID UInt32,  GoodID String, GoodName String, GoodQuantity Int32,  GoodPrice Int64),  IslandID FixedString(16))
    ENGINE = CollapsingMergeTree(Sign) PARTITION BY toYYYYMM(StartDate) ORDER BY (CounterID, StartDate, intHash32(UserID), VisitID)
    SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''default'\'''
+ clickhouse-client --query 'INSERT INTO test.hits_s3 SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16'
Received exception from server (version 24.8.14):
Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (total) exceeded: would use 15.90 GiB (attempt to allocate chunk of 1118969 bytes), maximum: 15.30 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.: (while reading column UTMCampaign): (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 904 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 1130330 bytes), maximum: 9.18 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.. (MEMORY_LIMIT_EXCEEDED)
(query: INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16)
+ clickhouse-client --query 'INSERT INTO test.visits SELECT * FROM datasets.visits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16'
+ 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=1393
+ clickhouse stop --max-tries 90 --do-not-kill
script.gdb:13: Error in sourced command file:
No stack.
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Sent terminate signal to process with pid 1393.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ export RANDOMIZE_OBJECT_KEY_TYPE=1
+ RANDOMIZE_OBJECT_KEY_TYPE=1
+ export ZOOKEEPER_FAULT_INJECTION=1
+ ZOOKEEPER_FAULT_INJECTION=1
+ export THREAD_POOL_FAULT_INJECTION=1
+ THREAD_POOL_FAULT_INJECTION=1
+ configure
+ export USE_DATABASE_ORDINARY=1
+ USE_DATABASE_ORDINARY=1
+ export EXPORT_S3_STORAGE_POLICIES=1
+ EXPORT_S3_STORAGE_POLICIES=1
+ /usr/share/clickhouse-test/config/install.sh
+ DEST_SERVER_PATH=/etc/clickhouse-server
+ DEST_CLIENT_PATH=/etc/clickhouse-client
+++ dirname /usr/share/clickhouse-test/config/install.sh
++ cd /usr/share/clickhouse-test/config
++ pwd -P
Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server
+ SRC_PATH=/usr/share/clickhouse-test/config
+ echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server'
+ mkdir -p /etc/clickhouse-server/config.d/
+ mkdir -p /etc/clickhouse-server/users.d/
+ mkdir -p /etc/clickhouse-client
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_catalog_drop_table_concurrency.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/grpc_protocol.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/block_number.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/serverwide_trace_collector.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/rocksdb.xml /etc/clickhouse-server/config.d/
+ '[' /etc/clickhouse-server = /etc/clickhouse-server ']'
+ ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/
+ ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ rm -f /etc/clickhouse-server/config.d/zookeeper.xml
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/config.d/cannot_allocate_thread_injection.xml /etc/clickhouse-server/config.d/
+ value=0
+ sed --follow-symlinks -i 's|<create_snapshot_on_exit>[01]</create_snapshot_on_exit>|<create_snapshot_on_exit>0</create_snapshot_on_exit>|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=63000576
+ sed --follow-symlinks -i 's|<latest_logs_cache_size_threshold>[[:digit:]]\+</latest_logs_cache_size_threshold>|<latest_logs_cache_size_threshold>63000576</latest_logs_cache_size_threshold>|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=20912128
+ sed --follow-symlinks -i 's|<commit_logs_cache_size_threshold>[[:digit:]]\+</commit_logs_cache_size_threshold>|<commit_logs_cache_size_threshold>20912128</commit_logs_cache_size_threshold>|' /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|<snapshot_distance>100000</snapshot_distance>|<snapshot_distance>10000</snapshot_distance>|'
+ 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|<filtered_list>[01]</filtered_list>|<filtered_list>1</filtered_list>|'
+ 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|<multi_read>[01]</multi_read>|<multi_read>1</multi_read>|'
+ 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|<check_not_exists>[01]</check_not_exists>|<check_not_exists>0</check_not_exists>|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value create_if_not_exists keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|<create_if_not_exists>[01]</create_if_not_exists>|<create_if_not_exists>1</create_if_not_exists>|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value use_compression zookeeper_fault_injection
+ value=1
+ sed 's|<use_compression>[01]</use_compression>|<use_compression>1</use_compression>|'
+ sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ 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|<enable_block_number_column>[01]</enable_block_number_column>|<enable_block_number_column>1</enable_block_number_column>|'
+ sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml
+ randomize_config_boolean_value enable_block_offset_column block_number
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/block_number.xml
+ sed 's|<enable_block_offset_column>[01]</enable_block_offset_column>|<enable_block_offset_column>0</enable_block_offset_column>|'
+ sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml
+ echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\'''
+ export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ sudo chown root: /var/lib/clickhouse
+ local total_mem
++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo
+ total_mem=32086440
+ total_mem=32856514560
+ max_server_memory_usage_to_ram_ratio=0.5
+ echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5'
+ cat
Setting max_server_memory_usage_to_ram_ratio to 0.5
Setting max_memory_usage_for_user=9856954368 and max_memory_usage for queries to 10G
+ local max_users_mem
+ max_users_mem=9856954368
+ echo 'Setting max_memory_usage_for_user=9856954368 and max_memory_usage for queries to 10G'
+ cat
+ cat
+ [[ '' == \1 ]]
+ [[ '' == \1 ]]
+ sudo cat /etc/clickhouse-server/config.d/logger_trace.xml
+ sed 's|<level>trace</level>|<level>test</level>|'
+ 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|<cache_policy>LRU</cache_policy>|<cache_policy>SLRU</cache_policy>|'
+ mv /etc/clickhouse-server/config.d/storage_conf.xml.tmp /etc/clickhouse-server/config.d/storage_conf.xml
++ date +%-d
+ '[' 0 -eq 1 ']'
+ start_server
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ 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 - - [20/Oct/2025:21:33:55 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 -
127.0.0.1 - - [20/Oct/2025:21:33:55 +0000] "PUT /devstoreaccount1/cont/ubcgbuptxmtpavjjofhlhfugozjphjpt HTTP/1.1" 201 -
127.0.0.1 - - [20/Oct/2025:21:33:55 +0000] "GET /devstoreaccount1/cont/ubcgbuptxmtpavjjofhlhfugozjphjpt HTTP/1.1" 206 4
127.0.0.1 - - [20/Oct/2025:21:33:55 +0000] "GET /devstoreaccount1/cont/ubcgbuptxmtpavjjofhlhfugozjphjpt HTTP/1.1" 206 2
127.0.0.1 - - [20/Oct/2025:21:33:55 +0000] "DELETE /devstoreaccount1/cont/ubcgbuptxmtpavjjofhlhfugozjphjpt HTTP/1.1" 202 -
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 13 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=14
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 14 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=15
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 15 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=16
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 16 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=17
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 17 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=18
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 18 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=19
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 19 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=20
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 20 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=21
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 21 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=22
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 22 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=23
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 23 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=24
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 24 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=25
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 25 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=26
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

+ '[' 26 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=27
+ clickhouse-client --query 'SELECT 1'
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: failed to start the thread (threads=2, jobs=2). (CANNOT_SCHEDULE_TASK)
(query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value))
++ retry=1
++ sleep 5
++ '[' 1 -ge 5 ']'
++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ false
++ return
+ IS_ASAN=0
+ [[ 0 = \1 ]]
++ kill -l SIGRTMIN
+ RTMIN=34
+ echo '
        set follow-fork-mode parent
        handle SIGHUP nostop noprint pass
        handle SIGINT nostop noprint pass
        handle SIGQUIT nostop noprint pass
        handle SIGPIPE nostop noprint pass
        handle SIGTERM nostop noprint pass
        handle SIGUSR1 nostop noprint pass
        handle SIGUSR2 nostop noprint pass
        handle SIG34 nostop noprint pass
        info signals
        continue
        backtrace full
        info registers
        p top' 1 KiB of the 'stack:
        p/x *(uint64_t[128]*)$sp
        maintenance info sections
        thread apply all backtrace full
        disassemble /s
        up
        disassemble /s
        up
        disassemble /s
        p "done"
        detach
        quit
        '
+ sleep 5
+ ts '%Y-%m-%d %H:%M:%S'
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ gdb -batch -command script.gdb -p 2994
+ run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
+ [[ hxB =~ e ]]
+ set_e=false
+ set +e
+ local total_retries=60
+ shift
+ local retry=0
+ '[' 0 -ge 60 ']'
+ clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
Connected to clickhouse-server after attaching gdb
+ false
+ return
+ stress --hung-check --drop-databases --output-folder test_output --skip-func-tests '' --global-time-limit 1200
2025-10-20 23:34:25,642 Run func tests '/usr/bin/clickhouse-test  --client-option http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200  '
2025-10-20 23:34:26,144 Run func tests '/usr/bin/clickhouse-test --order=random  --database=test_1  --client-option join_use_nulls=1 join_algorithm='parallel_hash' use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200  '
2025-10-20 23:34:26,645 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 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' ignore_drop_queries_probability=0.5 --global_time_limit=1200  '
2025-10-20 23:34:27,147 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-10-20 23:34:27,648 Run func tests '/usr/bin/clickhouse-test --order=random  --client-option join_use_nulls=1 optimize_trivial_approximate_count_query=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200  '
2025-10-20 23:34:28,150 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_5', 's1', 'r1')"  --database=test_5  --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='full_sorting_merge' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200  '
2025-10-20 23:34:28,651 Run func tests '/usr/bin/clickhouse-test --order=random  --client-option use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 ignore_drop_queries_probability=0.5 --global_time_limit=1200  '
2025-10-20 23:34:29,153 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 ignore_drop_queries_probability=0.5 --global_time_limit=1200  '
2025-10-20 23:34:29,654 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-10-20 23:34:30,155 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 ignore_drop_queries_probability=0.5 --global_time_limit=1200  '
2025-10-20 23:34:30,657 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-10-20 23:34:31,158 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-10-20 23:34:31,659 Run func tests '/usr/bin/clickhouse-test --order=random  --client-option implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 ignore_drop_queries_probability=0.5 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-10-20 23:34:32,161 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 optimize_trivial_approximate_count_query=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200  '
2025-10-20 23:34:32,662 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' http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200  '
2025-10-20 23:34:33,164 Run func tests '/usr/bin/clickhouse-test --order=random  --database=test_15  --client-option 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 ignore_drop_queries_probability=0.5 --global_time_limit=1200  '
2025-10-20 23:34:33,665 Will wait functests to finish
2025-10-20 23:34:33,665 Finished 7 from 16 processes
2025-10-20 23:34:38,666 Finished 7 from 16 processes
2025-10-20 23:34:43,668 Finished 7 from 16 processes
2025-10-20 23:34:48,672 Finished 7 from 16 processes
2025-10-20 23:34:53,676 Finished 7 from 16 processes
2025-10-20 23:34:58,680 Finished 7 from 16 processes
2025-10-20 23:35:03,685 Finished 7 from 16 processes
2025-10-20 23:35:08,685 Finished 7 from 16 processes
2025-10-20 23:35:13,688 Finished 7 from 16 processes
2025-10-20 23:35:18,692 Finished 7 from 16 processes
2025-10-20 23:35:23,696 Finished 7 from 16 processes
2025-10-20 23:35:28,700 Finished 7 from 16 processes
2025-10-20 23:35:33,703 Finished 7 from 16 processes
2025-10-20 23:35:38,708 Finished 7 from 16 processes
2025-10-20 23:35:43,712 Finished 7 from 16 processes
2025-10-20 23:35:48,716 Finished 7 from 16 processes
2025-10-20 23:35:53,720 Finished 7 from 16 processes
2025-10-20 23:35:58,725 Finished 7 from 16 processes
2025-10-20 23:36:03,728 Finished 7 from 16 processes
2025-10-20 23:36:08,732 Finished 7 from 16 processes
2025-10-20 23:36:13,736 Finished 7 from 16 processes
2025-10-20 23:36:18,740 Finished 7 from 16 processes
2025-10-20 23:36:23,744 Finished 7 from 16 processes
2025-10-20 23:36:28,748 Finished 7 from 16 processes
2025-10-20 23:36:33,752 Finished 7 from 16 processes
2025-10-20 23:36:38,756 Finished 8 from 16 processes
2025-10-20 23:36:43,760 Finished 8 from 16 processes
2025-10-20 23:36:48,764 Finished 8 from 16 processes
2025-10-20 23:36:53,768 Finished 8 from 16 processes
2025-10-20 23:36:58,769 Finished 8 from 16 processes
2025-10-20 23:37:03,772 Finished 8 from 16 processes
2025-10-20 23:37:08,777 Finished 8 from 16 processes
2025-10-20 23:37:13,780 Finished 8 from 16 processes
2025-10-20 23:37:18,784 Finished 8 from 16 processes
2025-10-20 23:37:23,788 Finished 8 from 16 processes
2025-10-20 23:37:28,792 Finished 8 from 16 processes
2025-10-20 23:37:33,797 Finished 8 from 16 processes
2025-10-20 23:37:38,800 Finished 8 from 16 processes
2025-10-20 23:37:43,804 Finished 8 from 16 processes
2025-10-20 23:37:48,808 Finished 8 from 16 processes
2025-10-20 23:37:53,812 Finished 8 from 16 processes
2025-10-20 23:37:58,816 Finished 8 from 16 processes
2025-10-20 23:38:03,820 Finished 8 from 16 processes
2025-10-20 23:38:08,824 Finished 8 from 16 processes
2025-10-20 23:38:13,828 Finished 8 from 16 processes
2025-10-20 23:38:18,832 Finished 8 from 16 processes
2025-10-20 23:38:23,833 Finished 9 from 16 processes
2025-10-20 23:38:28,837 Finished 9 from 16 processes
2025-10-20 23:38:33,840 Finished 9 from 16 processes
2025-10-20 23:38:38,844 Finished 9 from 16 processes
2025-10-20 23:38:43,848 Finished 9 from 16 processes
2025-10-20 23:38:48,852 Finished 9 from 16 processes
2025-10-20 23:38:53,856 Finished 9 from 16 processes
2025-10-20 23:38:58,860 Finished 9 from 16 processes
2025-10-20 23:39:03,864 Finished 9 from 16 processes
2025-10-20 23:39:08,866 Finished 9 from 16 processes
2025-10-20 23:39:13,871 Finished 9 from 16 processes
2025-10-20 23:39:18,876 Finished 9 from 16 processes
2025-10-20 23:39:23,880 Finished 9 from 16 processes
2025-10-20 23:39:28,884 Finished 9 from 16 processes
2025-10-20 23:39:33,888 Finished 9 from 16 processes
2025-10-20 23:39:38,888 Finished 9 from 16 processes
2025-10-20 23:39:43,892 Finished 9 from 16 processes
2025-10-20 23:39:48,896 Finished 9 from 16 processes
2025-10-20 23:39:53,900 Finished 9 from 16 processes
2025-10-20 23:39:58,904 Finished 9 from 16 processes
2025-10-20 23:40:03,909 Finished 9 from 16 processes
2025-10-20 23:40:08,912 Finished 9 from 16 processes
2025-10-20 23:40:13,916 Finished 9 from 16 processes
2025-10-20 23:40:18,920 Finished 9 from 16 processes
2025-10-20 23:40:23,924 Finished 9 from 16 processes
2025-10-20 23:40:28,928 Finished 9 from 16 processes
2025-10-20 23:40:33,932 Finished 9 from 16 processes
2025-10-20 23:40:38,936 Finished 9 from 16 processes
2025-10-20 23:40:43,940 Finished 9 from 16 processes
2025-10-20 23:40:48,944 Finished 9 from 16 processes
2025-10-20 23:40:53,948 Finished 9 from 16 processes
2025-10-20 23:40:58,952 Finished 9 from 16 processes
2025-10-20 23:41:03,956 Finished 9 from 16 processes
2025-10-20 23:41:08,960 Finished 9 from 16 processes
2025-10-20 23:41:13,960 Finished 9 from 16 processes
2025-10-20 23:41:18,964 Finished 9 from 16 processes
2025-10-20 23:41:23,967 Finished 9 from 16 processes
2025-10-20 23:41:28,972 Finished 9 from 16 processes
2025-10-20 23:41:33,976 Finished 9 from 16 processes
2025-10-20 23:41:38,982 Finished 9 from 16 processes
2025-10-20 23:41:43,984 Finished 9 from 16 processes
2025-10-20 23:41:48,988 Finished 9 from 16 processes
2025-10-20 23:41:53,992 Finished 9 from 16 processes
2025-10-20 23:41:58,997 Finished 9 from 16 processes
2025-10-20 23:42:04,000 Finished 9 from 16 processes
2025-10-20 23:42:09,004 Finished 9 from 16 processes
2025-10-20 23:42:14,008 Finished 9 from 16 processes
2025-10-20 23:42:19,012 Finished 9 from 16 processes
2025-10-20 23:42:24,017 Finished 9 from 16 processes
2025-10-20 23:42:29,020 Finished 9 from 16 processes
2025-10-20 23:42:34,024 Finished 9 from 16 processes
2025-10-20 23:42:39,029 Finished 9 from 16 processes
2025-10-20 23:42:44,032 Finished 9 from 16 processes
2025-10-20 23:42:49,036 Finished 9 from 16 processes
2025-10-20 23:42:54,040 Finished 9 from 16 processes
2025-10-20 23:42:59,045 Finished 9 from 16 processes
2025-10-20 23:43:04,048 Finished 9 from 16 processes
2025-10-20 23:43:09,052 Finished 9 from 16 processes
2025-10-20 23:43:14,056 Finished 9 from 16 processes
2025-10-20 23:43:19,060 Finished 9 from 16 processes
2025-10-20 23:43:24,064 Finished 9 from 16 processes
2025-10-20 23:43:29,068 Finished 9 from 16 processes
2025-10-20 23:43:34,072 Finished 9 from 16 processes
2025-10-20 23:43:39,076 Finished 9 from 16 processes
2025-10-20 23:43:44,080 Finished 9 from 16 processes
2025-10-20 23:43:49,085 Finished 9 from 16 processes
2025-10-20 23:43:54,088 Finished 9 from 16 processes
2025-10-20 23:43:59,092 Finished 9 from 16 processes
2025-10-20 23:44:04,096 Finished 9 from 16 processes
2025-10-20 23:44:09,098 Finished 9 from 16 processes
2025-10-20 23:44:14,103 Finished 9 from 16 processes
2025-10-20 23:44:19,108 Finished 9 from 16 processes
2025-10-20 23:44:24,112 Finished 9 from 16 processes
2025-10-20 23:44:29,117 Finished 9 from 16 processes
2025-10-20 23:44:34,120 Finished 9 from 16 processes
2025-10-20 23:44:39,124 Finished 9 from 16 processes
2025-10-20 23:44:44,128 Finished 9 from 16 processes
2025-10-20 23:44:49,132 Finished 9 from 16 processes
2025-10-20 23:44:54,135 Finished 9 from 16 processes
2025-10-20 23:44:59,140 Finished 9 from 16 processes
2025-10-20 23:45:04,144 Finished 9 from 16 processes
2025-10-20 23:45:09,148 Finished 9 from 16 processes
2025-10-20 23:45:14,152 Finished 9 from 16 processes
2025-10-20 23:45:19,156 Finished 9 from 16 processes
2025-10-20 23:45:24,160 Finished 9 from 16 processes
2025-10-20 23:45:29,164 Finished 9 from 16 processes
2025-10-20 23:45:34,166 Finished 9 from 16 processes
2025-10-20 23:45:39,168 Finished 9 from 16 processes
2025-10-20 23:45:44,173 Finished 9 from 16 processes
2025-10-20 23:45:49,176 Finished 9 from 16 processes
2025-10-20 23:45:54,180 Finished 9 from 16 processes
2025-10-20 23:45:59,184 Finished 9 from 16 processes
2025-10-20 23:46:04,188 Finished 9 from 16 processes
2025-10-20 23:46:09,193 Finished 9 from 16 processes
2025-10-20 23:46:14,196 Finished 9 from 16 processes
2025-10-20 23:46:19,201 Finished 9 from 16 processes
2025-10-20 23:46:24,204 Finished 9 from 16 processes
2025-10-20 23:46:29,208 Finished 9 from 16 processes
2025-10-20 23:46:34,209 Finished 9 from 16 processes
2025-10-20 23:46:39,210 Finished 9 from 16 processes
2025-10-20 23:46:44,215 Finished 9 from 16 processes
2025-10-20 23:46:49,220 Finished 9 from 16 processes
2025-10-20 23:46:54,225 Finished 9 from 16 processes
2025-10-20 23:46:59,228 Finished 9 from 16 processes
2025-10-20 23:47:04,232 Finished 9 from 16 processes
2025-10-20 23:47:09,236 Finished 9 from 16 processes
2025-10-20 23:47:14,240 Finished 9 from 16 processes
2025-10-20 23:47:19,244 Finished 9 from 16 processes
2025-10-20 23:47:24,248 Finished 9 from 16 processes
2025-10-20 23:47:29,253 Finished 9 from 16 processes
2025-10-20 23:47:34,256 Finished 9 from 16 processes
2025-10-20 23:47:39,260 Finished 9 from 16 processes
2025-10-20 23:47:44,264 Finished 9 from 16 processes
2025-10-20 23:47:49,268 Finished 9 from 16 processes
2025-10-20 23:47:54,271 Finished 9 from 16 processes
2025-10-20 23:47:59,276 Finished 9 from 16 processes
2025-10-20 23:48:04,280 Finished 9 from 16 processes
2025-10-20 23:48:09,285 Finished 9 from 16 processes
2025-10-20 23:48:14,288 Finished 9 from 16 processes
2025-10-20 23:48:19,292 Finished 9 from 16 processes
2025-10-20 23:48:24,296 Finished 9 from 16 processes
2025-10-20 23:48:29,300 Finished 9 from 16 processes
2025-10-20 23:48:34,304 Finished 9 from 16 processes
2025-10-20 23:48:39,308 Finished 9 from 16 processes
2025-10-20 23:48:44,312 Finished 9 from 16 processes
2025-10-20 23:48:49,316 Finished 9 from 16 processes
2025-10-20 23:48:54,318 Finished 9 from 16 processes
2025-10-20 23:48:59,324 Finished 9 from 16 processes
2025-10-20 23:49:04,328 Finished 9 from 16 processes
2025-10-20 23:49:09,332 Finished 9 from 16 processes
2025-10-20 23:49:14,336 Finished 9 from 16 processes
2025-10-20 23:49:19,340 Finished 9 from 16 processes
2025-10-20 23:49:24,344 Finished 9 from 16 processes
2025-10-20 23:49:29,344 Finished 9 from 16 processes
2025-10-20 23:49:34,346 Finished 9 from 16 processes
2025-10-20 23:49:39,351 Finished 9 from 16 processes
2025-10-20 23:49:44,356 Finished 9 from 16 processes
2025-10-20 23:49:49,360 Finished 9 from 16 processes
2025-10-20 23:49:54,364 Finished 9 from 16 processes
2025-10-20 23:49:59,368 Finished 9 from 16 processes
2025-10-20 23:50:04,372 Finished 9 from 16 processes
2025-10-20 23:50:09,376 Finished 9 from 16 processes
2025-10-20 23:50:14,380 Finished 9 from 16 processes
2025-10-20 23:50:19,384 Finished 9 from 16 processes
2025-10-20 23:50:24,388 Finished 9 from 16 processes
2025-10-20 23:50:29,392 Finished 9 from 16 processes
2025-10-20 23:50:34,396 Finished 9 from 16 processes
2025-10-20 23:50:39,400 Finished 9 from 16 processes
2025-10-20 23:50:44,404 Finished 9 from 16 processes
2025-10-20 23:50:49,408 Finished 9 from 16 processes
2025-10-20 23:50:54,412 Finished 9 from 16 processes
2025-10-20 23:50:59,416 Finished 9 from 16 processes
2025-10-20 23:51:04,420 Finished 9 from 16 processes
2025-10-20 23:51:09,424 Finished 9 from 16 processes
2025-10-20 23:51:14,428 Finished 9 from 16 processes
2025-10-20 23:51:19,432 Finished 9 from 16 processes
2025-10-20 23:51:24,436 Finished 9 from 16 processes
2025-10-20 23:51:29,440 Finished 9 from 16 processes
2025-10-20 23:51:34,444 Finished 9 from 16 processes
2025-10-20 23:51:39,449 Finished 9 from 16 processes
2025-10-20 23:51:44,452 Finished 9 from 16 processes
2025-10-20 23:51:49,456 Finished 9 from 16 processes
2025-10-20 23:51:54,460 Finished 9 from 16 processes
2025-10-20 23:51:59,464 Finished 9 from 16 processes
2025-10-20 23:52:04,468 Finished 9 from 16 processes
2025-10-20 23:52:09,472 Finished 9 from 16 processes
2025-10-20 23:52:14,476 Finished 9 from 16 processes
2025-10-20 23:52:19,480 Finished 9 from 16 processes
2025-10-20 23:52:24,485 Finished 9 from 16 processes
2025-10-20 23:52:29,488 Finished 9 from 16 processes
2025-10-20 23:52:34,492 Finished 9 from 16 processes
2025-10-20 23:52:39,496 Finished 9 from 16 processes
2025-10-20 23:52:44,500 Finished 9 from 16 processes
2025-10-20 23:52:49,502 Finished 9 from 16 processes
2025-10-20 23:52:54,504 Finished 9 from 16 processes
2025-10-20 23:52:59,508 Finished 9 from 16 processes
2025-10-20 23:53:04,512 Finished 9 from 16 processes
2025-10-20 23:53:09,516 Finished 9 from 16 processes
2025-10-20 23:53:14,520 Finished 9 from 16 processes
2025-10-20 23:53:19,524 Finished 9 from 16 processes
2025-10-20 23:53:24,528 Finished 9 from 16 processes
2025-10-20 23:53:29,532 Finished 9 from 16 processes
2025-10-20 23:53:34,537 Finished 9 from 16 processes
2025-10-20 23:53:39,540 Finished 9 from 16 processes
2025-10-20 23:53:44,544 Finished 9 from 16 processes
2025-10-20 23:53:49,548 Finished 9 from 16 processes
2025-10-20 23:53:54,552 Finished 9 from 16 processes
2025-10-20 23:53:59,556 Finished 9 from 16 processes
2025-10-20 23:54:04,560 Finished 9 from 16 processes
2025-10-20 23:54:09,564 Finished 9 from 16 processes
2025-10-20 23:54:14,568 Finished 9 from 16 processes
2025-10-20 23:54:19,572 Finished 9 from 16 processes
2025-10-20 23:54:24,577 Finished 9 from 16 processes
2025-10-20 23:54:29,580 Finished 9 from 16 processes
2025-10-20 23:54:34,584 Finished 10 from 16 processes
2025-10-20 23:54:39,588 Finished 11 from 16 processes
2025-10-20 23:54:44,592 Finished 11 from 16 processes
2025-10-20 23:54:49,596 Finished 11 from 16 processes
2025-10-20 23:54:54,600 Finished 11 from 16 processes
2025-10-20 23:54:59,604 Finished 11 from 16 processes
2025-10-20 23:55:04,608 Finished 12 from 16 processes
2025-10-20 23:55:09,612 Finished 12 from 16 processes
2025-10-20 23:55:14,612 Finished 12 from 16 processes
2025-10-20 23:55:19,616 Finished 12 from 16 processes
2025-10-20 23:55:24,620 Finished 12 from 16 processes
2025-10-20 23:55:29,624 Finished 12 from 16 processes
2025-10-20 23:55:34,628 Finished 12 from 16 processes
2025-10-20 23:55:39,632 Finished 12 from 16 processes
2025-10-20 23:55:44,636 Finished 12 from 16 processes
2025-10-20 23:55:49,640 Finished 12 from 16 processes
2025-10-20 23:55:54,644 Finished 12 from 16 processes
2025-10-20 23:55:59,648 Finished 12 from 16 processes
2025-10-20 23:56:04,652 Finished 12 from 16 processes
2025-10-20 23:56:09,656 Finished 12 from 16 processes
2025-10-20 23:56:14,660 Finished 12 from 16 processes
2025-10-20 23:56:19,664 Finished 12 from 16 processes
2025-10-20 23:56:24,668 Finished 12 from 16 processes
2025-10-20 23:56:29,669 Finished 13 from 16 processes
2025-10-20 23:56:34,672 Finished 13 from 16 processes
2025-10-20 23:56:39,676 Finished 13 from 16 processes
2025-10-20 23:56:44,680 Finished 13 from 16 processes
2025-10-20 23:56:49,685 Finished 13 from 16 processes
2025-10-20 23:56:54,688 Finished 13 from 16 processes
2025-10-20 23:56:59,692 Finished 13 from 16 processes
2025-10-20 23:57:04,696 Finished 13 from 16 processes
2025-10-20 23:57:09,701 Finished 13 from 16 processes
2025-10-20 23:57:14,706 Finished 13 from 16 processes
2025-10-20 23:57:19,712 Finished 13 from 16 processes
2025-10-20 23:57:24,716 Finished 13 from 16 processes
2025-10-20 23:57:29,721 Finished 13 from 16 processes
2025-10-20 23:57:34,724 Finished 13 from 16 processes
2025-10-20 23:57:39,728 Finished 13 from 16 processes
2025-10-20 23:57:44,732 Finished 13 from 16 processes
2025-10-20 23:57:49,736 Finished 13 from 16 processes
2025-10-20 23:57:54,739 Finished 13 from 16 processes
2025-10-20 23:57:59,744 Finished 13 from 16 processes
2025-10-20 23:58:04,748 Finished 13 from 16 processes
2025-10-20 23:58:09,752 Finished 13 from 16 processes
2025-10-20 23:58:14,756 Finished 13 from 16 processes
2025-10-20 23:58:19,760 Finished 13 from 16 processes
2025-10-20 23:58:24,764 Finished 13 from 16 processes
2025-10-20 23:58:29,768 Finished 13 from 16 processes
2025-10-20 23:58:34,772 Finished 13 from 16 processes
2025-10-20 23:58:39,772 Finished 13 from 16 processes
2025-10-20 23:58:44,776 Finished 13 from 16 processes
2025-10-20 23:58:49,780 Finished 13 from 16 processes
2025-10-20 23:58:54,784 Finished 13 from 16 processes
2025-10-20 23:58:59,788 Finished 13 from 16 processes
2025-10-20 23:59:04,792 Finished 13 from 16 processes
2025-10-20 23:59:09,796 Finished 13 from 16 processes
2025-10-20 23:59:14,800 Finished 14 from 16 processes
2025-10-20 23:59:19,804 Finished 14 from 16 processes
2025-10-20 23:59:24,809 Finished 14 from 16 processes
2025-10-20 23:59:29,812 Finished 14 from 16 processes
2025-10-20 23:59:34,816 Finished 14 from 16 processes
2025-10-20 23:59:39,820 Finished 15 from 16 processes
2025-10-20 23:59:44,825 Finished 15 from 16 processes
2025-10-20 23:59:49,828 Finished 15 from 16 processes
2025-10-20 23:59:54,833 Finished 15 from 16 processes
2025-10-20 23:59:59,836 Finished 15 from 16 processes
2025-10-21 00:00:04,840 Finished 15 from 16 processes
2025-10-21 00:00:09,844 Finished 15 from 16 processes
2025-10-21 00:00:14,848 Finished 15 from 16 processes
2025-10-21 00:00:19,852 Finished 15 from 16 processes
2025-10-21 00:00:24,856 Finished 15 from 16 processes
2025-10-21 00:00:29,857 Finished 15 from 16 processes
2025-10-21 00:00:34,858 Finished 15 from 16 processes
2025-10-21 00:00:39,864 Finished 15 from 16 processes
2025-10-21 00:00:44,868 Finished 15 from 16 processes
2025-10-21 00:00:49,872 Finished 15 from 16 processes
2025-10-21 00:00:54,877 Finished 15 from 16 processes
2025-10-21 00:00:59,880 Finished 15 from 16 processes
2025-10-21 00:01:04,885 Finished 15 from 16 processes
2025-10-21 00:01:09,890 Finished 15 from 16 processes
2025-10-21 00:01:14,892 All processes finished
2025-10-21 00:01:14,892 Compressing stress logs
2025-10-21 00:01:14,917 Logs compressed
2025-10-21 00:01:14,917 Will terminate gdb (if any)
2025-10-21 00:01:14,917 Running command: kill -TERM $(pidof gdb)
2025-10-21 00:01:14,921 Running command: timeout 50s tail --pid=$(pidof gdb) -f /dev/null || kill -9 $(pidof gdb) ||:
2025-10-21 00:01:15,938 Running command: kill -CONT $(cat /var/run/clickhouse-server/clickhouse-server.pid) && clickhouse client -q 'SELECT 1 FORMAT Null'
2025-10-21 00:01:16,103 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-10-21 00:01:16,317 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-10-21 00:01:16,432 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-10-21 00:01:16,546 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-10-21 00:01:16,661 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-10-21 00:01:16,775 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-10-21 00:01:16,890 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-10-21 00:01:17,004 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-10-21 00:01:17,119 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-10-21 00:01:17,233 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-10-21 00:01:17,348 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-10-21 00:01:17,463 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-10-21 00:01:17,578 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.023404568 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-10-21 00:02:18,129 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.10531.altinitytest @ feea6649cd270d4259dea4e635d3455d0d647952 HEAD
Running 1 stateless tests (MainProcess).
00001_select_1:                                                         [ OK ]

1 tests passed. 0 tests skipped. 0.32 s elapsed (MainProcess).
Won't run stateful tests because test data wasn't loaded.
Checking the hung queries:  done

No queries hung.
All tests have finished.

Top patterns of log messages:

count   count_%   size         size_%   uniq_loggers   uniq_threads   levels            background_%   message_format_string                                                                                                                 

  1.  12815     0.066   1.30 MiB      0.043              1             78   ['Trace']                 0.19   Checking existence of path: {}                                                                                                         
  2.   9506     0.049   1.42 MiB      0.047           4551             56   ['Trace']                    1   {} Creating query context from {} context, user_id: {}, parent context user: {}                                                        
  3.   8783     0.045   247.78 KiB    0.008              1             56   ['Debug']                0.138   Processed in {} sec.                                                                                                                   
  4.   8401     0.043   1.64 MiB      0.054              1             58   ['Debug']                    0   (from {}{}{}){}{} {} (stage: {})                                                                                                       
  5.   6256     0.032   157.91 KiB    0.005              1             68   ['Trace']                0.009   Query to stage {}{}                                                                                                                    
  6.   6180     0.032   301.89 KiB     0.01              1             68   ['Trace']                0.008   Query from stage {} to stage {}{}                                                                                                      
  7.   4774     0.024   446.16 KiB    0.014              1             37   ['Debug']                    0   Reading {} marks from part {}, total {} rows starting from the beginning of the part                                                   
  8.   4708     0.024   199.79 KiB    0.006              1             77   ['Trace']                    1   is disk {} eligible for search: {}                                                                                                     
  9.   4594     0.024   210.72 KiB    0.007           4594             72   ['Debug']                0.998   Authenticating user '{}' from {}                                                                                                       
 10.   4593     0.024   515.82 KiB    0.017           4593             72   ['Debug']                0.998   {} Authenticated with global context as user {}                                                                                        
 11.   4582     0.024   402.71 KiB    0.013           4582             72   ['Debug']                0.998   {} Logout, user_id: {}                                                                                                                 
 12.   4551     0.023   320.19 KiB     0.01              1            611   ['Trace']                0.914   Reserved {} on local disk {}, having unreserved {}.                                                                                    
 13.   4541     0.023   332.59 KiB    0.011           4541             56   ['Debug']                    1   Creating session context with user_id: {}                                                                                              
 14.   4353     0.022   516.61 KiB    0.017            152            171   ['Trace']                0.593   Renaming temporary part {} to {} with tid {}.                                                                                          
 15.   4291     0.022   205.10 KiB    0.007              1            160   ['Trace']                0.595   filled checksums {}                                                                                                                    
 16.   4280     0.022   296.83 KiB     0.01            154            598   ['Trace']                0.926   Trying to reserve {} using storage policy from min volume index {}                                                                     
 17.   4081     0.021   375.01 KiB    0.012              1             56   ['Debug']                    1   Connected {} version {}.{}.{}, revision: {}{}{}.                                                                                       
 18.   4081     0.021   134.94 KiB    0.004              2             56   ['Trace']                    1   TCP Request. Address: {}                                                                                                               
 19.   4076     0.021   107.47 KiB    0.003              1             56   ['Debug']                    1   Done processing connection.                                                                                                            
 20.   3837      0.02   445.83 KiB    0.014              1             23   ['Debug']                    0   Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {}                                        
 21.   3464     0.018   276.24 KiB    0.009              1             33   ['Debug']                    0   Read {} rows, {} in {} sec., {} rows/sec., {}/sec.                                                                                     
 22.   3408     0.017   152.26 KiB    0.005              1              3   ['Trace']                    1   Processing requests batch, size: {}, bytes: {}                                                                                         
 23.   3190     0.016   181.02 KiB    0.006              1             71   ['Debug']                0.461   Peak memory usage{}: {}.                                                                                                               
 24.   2548     0.013   146.94 KiB    0.005             16             39   ['Trace']                    1   Flushing system log, {} entries to flush up to offset {}                                                                               
 25.   2547     0.013   90.84 KiB     0.003             16             39   ['Trace']                    1   Flushed system log up to offset {}                                                                                                     
 26.   1815     0.009   227.65 KiB    0.007              1              6   ['Trace']                    1   MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {}                                        
 27.   1679     0.009   129.53 KiB    0.004              1              1   ['Debug']                    1   Restarting waiting for CQEs due to: {}                                                                                                 
 28.   1677     0.009   99.90 KiB     0.003            127             99   ['Debug']                0.207   There are {} detached tables. Start searching non used tables.                                                                         
 29.   1677     0.009   70.42 KiB     0.002            127             99   ['Debug']                0.207   Found {} non used tables in detached tables.                                                                                           
 30.   1584     0.008   162.03 KiB    0.005              1              7   ['Trace']                  0.5   Adding file: {}, size: {}                                                                                                              
 31.   1440     0.007   189.55 KiB    0.006              1             28   ['Trace']                    0   No query result found for query {}                                                                                                     
 32.   1412     0.007   48.21 KiB     0.002              1             38   ['Debug']                    0   Selected MergeAlgorithm: {}                                                                                                            
 33.   1412     0.007   114.87 KiB    0.004              1             38   ['Debug']                    0   Merging {} parts: from {} to {} into {} with storage {}                                                                                
 34.   1362     0.007   175.77 KiB    0.006              1             37   ['Debug']                    0   Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec.                                 
 35.   1326     0.007   117.07 KiB    0.004              1            106   ['Trace']                    0   Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.)                                                             
 36.   1234     0.006   3.28 MiB      0.108              2             25   ['Error']                0.982   Setting {} should not be changed                                                                                                       
 37.   1163     0.006   26.12 KiB     0.001              1            106   ['Trace']                    0   Merging aggregated data                                                                                                                
 38.   1149     0.006   34.28 KiB     0.001              1            106   ['Trace']                    0   Aggregation method: {}                                                                                                                 
 39.   1074     0.006   81.35 KiB     0.003              1             28   ['Trace']                0.013   Condition {} moved to PREWHERE                                                                                                         
 40.    938     0.005   115.47 KiB    0.004              1             28   ['Trace']                    0   Stored query result of query {}                                                                                                        
 41.    865     0.004   85.41 KiB     0.003             22            419   ['Trace']                    1   Scheduling next cleanup after {}ms (points: {}, interval: {}ms, ratio: {}, points per minute: {})                                      
 42.    850     0.004   65.58 KiB     0.002              1             34   ['Trace']                    0   Query span trace_id for opentelemetry log: {}                                                                                          
 43.    847     0.004   45.66 KiB     0.001             44            451   ['Debug']                0.943   Selected {} parts from {} to {}                                                                                                        
 44.    813     0.004   53.53 KiB     0.002             48             41   ['Trace']                    0   Merged {} parts: [{}, {}] -> {}                                                                                                        
 45.    807     0.004   28.37 KiB     0.001              1             20   ['Trace']                    1   Keeper request. Address: {}                                                                                                            
 46.    795     0.004   29.11 KiB     0.001            118             54   ['Debug']                0.018   Key condition: {}                                                                                                                      
 47.    781     0.004   34.32 KiB     0.001            117             54   ['Trace']                0.018   Filtering marks by primary and secondary keys                                                                                          
 48.    769     0.004   80.12 KiB     0.003             83             68   ['Debug']                0.997   Removing {} parts from filesystem (serially): Parts: [{}]                                                                              
 49.    750     0.004   23.44 KiB     0.001              1             17   ['Debug']                    1   Receive four letter command {}                                                                                                         
 50.    742     0.004   84.44 KiB     0.003            114             54   ['Debug']                0.019   Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges            
 51.    742     0.004   66.62 KiB     0.002             46             36   ['Trace']                0.996   Found {} old parts to remove. Parts: [{}]                                                                                              
 52.    741     0.004   67.27 KiB     0.002             46             36   ['Debug']                0.996   Removing {} parts from memory: Parts: [{}]                                                                                             
 53.    737     0.004   238.57 KiB    0.008              1             28   ['Trace']                0.019   PREWHERE condition was split into {} steps: {}                                                                                         
 54.    705     0.004   55.98 KiB     0.002             17             86   ['Trace']                    1   Part {} is not stored on zero-copy replicated disk, blobs can be removed                                                               
 55.    701     0.004   40.56 KiB     0.001              2             12   ['Trace']                0.981   Loading config file '{}'.                                                                                                              
 56.    690     0.004   55.61 KiB     0.002              1             93   ['Trace']                    0   An entry for key={} found in cache: sum_of_sizes={}, median_size={}                                                                    
 57.    666     0.003   57.09 KiB     0.002             39            369   ['Trace']                    1   Scheduling next merge selecting task after {}ms, current attempt status: {}                                                            
 58.    622     0.003   32.19 KiB     0.001             93             52   ['Trace']                0.023   Spreading mark ranges among streams (default reading)                                                                                  
 59.    614     0.003   2.89 MiB      0.095             31             59   ['Error']                0.197   Cannot schedule a task: {} (threads={}, jobs={})                                                                                       
 60.    613     0.003   48.14 KiB     0.002             96             51   ['Trace']                0.023   Reading {} ranges in{}order from part {}, approx. {} rows starting from {}                                                             
 61.    604     0.003   6.49 KiB          0              1             84   ['Trace']                    0   Aggregating                                                                                                                            
 62.    589     0.003   81.69 KiB     0.003             24            347   ['Trace']                    1   Checked {} partitions, found {} partitions with parts that may be merged: [{}] (max_total_size_to_merge={}, merge_with_ttl_allowed={}) 
 63.    588     0.003   43.21 KiB     0.001             29             16   ['Trace']                    1   Executing log entry to merge parts {} to {}                                                                                            
 64.    549     0.003   71.84 KiB     0.002              1             16   ['Information']              1   Part {} already exists, but it will be deleted soon                                                                                    
 65.    514     0.003   92.52 KiB     0.003              3             28   ['Trace']                    1   HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {}           
 66.    513     0.003   25.53 KiB     0.001             33             44   ['Debug']                    0   MinMax index condition: {}                                                                                                             
 67.    512     0.003   347.78 KiB    0.011              2             28   ['Trace']                    1   Request URI: {}                                                                                                                        
 68.    474     0.002   34.66 KiB     0.001              1             29   ['Trace']                 0.03   The min valid primary key position for moving to the tail of PREWHERE is {}                                                            
 69.    438     0.002   34.89 KiB     0.001              1             95   ['Trace']                    0   Statistics updated for key={}: new sum_of_sizes={}, median_size={}                                                                     
 70.    391     0.002   15.66 KiB     0.001             14             76   ['Trace']                0.005   Sending external_roles with query: [{}] ({})                                                                                           
 71.    391     0.002   8.02 KiB          0              2             28   ['Debug']                0.064   Done processing query                                                                                                                  
 72.    371     0.002   14.52 KiB         0              1            109   ['Debug']                0.639   Spawn loader worker #{} in {}                                                                                                          
 73.    371     0.002   10.53 KiB         0              1            138   ['Debug']                    1   Stop worker in {}                                                                                                                      
 74.    370     0.002   26.58 KiB     0.001              1            111   ['Debug']                    1   Execute load job '{}' in {}                                                                                                            
 75.    370     0.002   27.67 KiB     0.001              1             31   ['Debug']                0.219   Schedule load job '{}' into {}                                                                                                         
 76.    370     0.002   25.12 KiB     0.001              1            111   ['Debug']                    1   Finish load job '{}' with status {}                                                                                                    
 77.    367     0.002   11.47 KiB         0             20             11   ['Debug']                0.019   Requested flush up to offset {}                                                                                                        
 78.    367     0.002   21.40 KiB     0.001             19             97   ['Trace']                0.984   Finished loading {} part {} on disk {}                                                                                                 
 79.    367     0.002   18.89 KiB     0.001             19             97   ['Trace']                0.984   Loading {} part {} from disk {}                                                                                                        
 80.    361     0.002   33.02 KiB     0.001              1             33   ['Debug']                 0.15   Prioritize load job '{}': {} -> {}                                                                                                     
 81.    356     0.002   719.53 KiB    0.023              1             73   ['Trace']                0.003   Exception while executing query. Current state:
{}                                                                                      
 82.    342     0.002   13.37 KiB         0             26             27   ['Debug']                    0   Reading approx. {} rows with {} streams                                                                                                
 83.    315     0.002   13.54 KiB         0              1              3   ['Information']              1   {} for session {} took {} ms                                                                                                           
 84.    290     0.001   6.25 KiB          0             77            219   ['Trace']                    1   Execution took {} ms.                                                                                                                  
 85.    289     0.001   9.58 KiB          0              1            111   ['Debug']                 0.54   Change current priority: {} -> {}                                                                                                      
 86.    279     0.001   45.27 KiB     0.001             14             60   ['Debug']                    0   Sent data for {} scalars, total {} rows in {} sec., {} rows/sec., {} ({}/sec.), compressed {} times to {} ({}/sec.)                    
 87.    278     0.001   4.89 KiB          0            239             78   ['Debug']                 0.18   Loading data parts                                                                                                                     
 88.    274     0.001   41.11 KiB     0.001              1             12   ['Debug']                    0   Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.)          
 89.    274     0.001   13.52 KiB         0              1             12   ['Trace']                    0   Merging partially aggregated blocks (bucket = {}).                                                                                     
 90.    273     0.001   2.40 KiB          0              2             31   ['Trace']                0.029   No tables                                                                                                                              
 91.    271     0.001   13.79 KiB         0             14             67   ['Trace']                    0   Connecting. Database: {}. User: {}{}{}                                                                                                 
 92.    271     0.001   12.44 KiB         0             14             68   ['Trace']                    0   Connected to {} server version {}.{}.{}.                                                                                               
 93.    263     0.001   21.23 KiB     0.001              1              3   ['Debug']                    1   Merging configuration file '{}'.                                                                                                       
 94.    254     0.001   2.70 MiB      0.089              2             11   ['Error']                    0   Update failed for dictionary '{}': {}                                                                                                  
 95.    237     0.001   5.32 KiB          0            230             51   ['Debug']                0.093   There are no data parts                                                                                                                
 96.    230     0.001   45.61 KiB     0.001             16             14   ['Information']              1   {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting)                                   
 97.    214     0.001   15.88 KiB     0.001              1             28   ['Debug']                    0   Waiting for table {} to be finally dropped                                                                                             
 98.    214     0.001   24.66 KiB     0.001              1             28   ['Debug']                    0   Done waiting for the table {} to be dropped. The outcome: {}                                                                           
 99.    212     0.001   19.06 KiB     0.001             24            173   ['Trace']                    1   Insert entry {} to queue with type {}                                                                                                  
100.    211     0.001   27.91 KiB     0.001              3             25   ['Debug']                    0   {}, {} blocks, {} rows, {} bytes in {} sec., {} rows/sec., {}/sec.                                                                     

      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.     18   CodeDBExceptionReceivedfromDBExc   Code: 439. DB::Exception: Received from 127.0.0.3:9000. DB::Exception: Cannot schedule a task: fault injected (threads=0, jobs=0). Stack trace:

0. /build/contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0   ('/TCPHandler.cpp',765)   
 2.     10   Couldnotloadexternaldictionaryad   Could not load external dictionary 'a9d3ab98-30e1-429d-bc47-38705eedbc0b', next update is scheduled at 2025-10-20 23:38:12: Poco::Exception. Code: 1000, e.code() = 111, Connection refused, Stack trace (when copying this message, always include the lines be   ('/Exception.cpp',273)    
 3.      6   CodeDBExceptionSyntaxerrorfailed   Code: 62. DB::Exception: Syntax error: failed at position 8 ('$'): $$ab
. Expected one of: ALL, DISTINCT ON, DISTINCT, TOP, not empty list of expressions, list of expressions, list of elements, expression with optional alias, element of expression with opt   ('/executeQuery.cpp',221) 
 4.      3   newconfiglogidxprevlogidxcurconf   new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0                                                                                                                                                                                   ('/LoggerWrapper.h',43)   
 5.      3   Forkedachildprocesstowatch         Forked a child process to watch                                                                                                                                                                                                                              ('',0)                    
 6.      3   peerDCIDlocalhostvotingmembermyi   peer 1: DC ID 0, localhost:9234, voting member, 1
my id: 1, voting_member
num peers: 0                                                                                                                                                                         ('/LoggerWrapper.h',43)   
 7.      3   parameterselectiontimeoutrangehe   parameters: election timeout range 0 - 0, heartbeat 0, leadership expiry 0, max batch 100, backoff 50, snapshot distance 10000, enable randomized snapshot creation NO, log sync stop gap 99999, reserved logs 2147483647, client timeout 10000, auto forwarding   ('/LoggerWrapper.h',43)   
 8.      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)   
 9.      3   invalidelectiontimeoutupperbound   invalid election timeout upper bound detected, adjusted to 0                                                                                                                                                                                                 ('/LoggerWrapper.h',43)   
10.      3   StartingClickHousealtinitytestre   Starting ClickHouse 24.8.14.10531.altinitytest (revision: 4294967295, git hash: feea6649cd270d4259dea4e635d3455d0d647952, build id: 6DEB5ABCB4608434440E6B478E4120DBFDF874B2), PID 411                                                                       ('',0)                    
11.      3   invalidelectiontimeoutlowerbound   invalid election timeout lower bound detected, adjusted to 0                                                                                                                                                                                                 ('/LoggerWrapper.h',43)   
12.      3   globalmanagerdoesnotexistwilluse   global manager does not exist. will use local thread for commit and append                                                                                                                                                                                   ('/LoggerWrapper.h',43)   
13.      3   PRIORITYdecaytargetmine            [PRIORITY] decay, target 1 -> 1, mine 1                                                                                                                                                                                                                      ('/LoggerWrapper.h',43)   
14.      3   startingup                         starting up                                                                                                                                                                                                                                                  ('',0)                    
15.      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)   
16.      3   BECOMELEADERappendednewconfigat    [BECOME LEADER] appended new config at 1                                                                                                                                                                                                                     ('/LoggerWrapper.h',43)   
17.      3   ELECTIONTIMEOUTcurrentrolefollow   [ELECTION TIMEOUT] current role: follower, log last term 0, state term 0, target p 1, my p 1, hb dead, pre-vote NOT done                                                                                                                                     ('/LoggerWrapper.h',43)   
18.      3   Connectiontoconvmainasusermetrik   Connection to conv_main@127.0.0.1:3456 as user metrika failed: mysqlxx::ConnectionFailed: Can't connect to MySQL server on '127.0.0.1' (115) ((nullptr):0)                                                                                                   ('',0)                    
19.      3   RaftASIOlistenerinitiatedonunsec   Raft ASIO listener initiated on :::9234, unsecured                                                                                                                                                                                                           ('/LoggerWrapper.h',43)   
20.      3   bgappendentriesthreadinitiated     bg append_entries thread initiated                                                                                                                                                                                                                           ('/LoggerWrapper.h',43)   
21.      3   statemachinecommitindexprecommit   state machine commit index 0, precommit index 0, last log index 0                                                                                                                                                                                            ('/LoggerWrapper.h',43)   
22.      3   newelectiontimeoutrange            new election timeout range: 0 - 0                                                                                                                                                                                                                            ('/LoggerWrapper.h',43)   
23.      3   Connectiontomysqlfailedtimes       Connection to mysql failed 1 times                                                                                                                                                                                                                           ('',0)                    
24.      3   numberofpendingcommitelements      number of pending commit elements: 0                                                                                                                                                                                                                         ('/LoggerWrapper.h',43)   
25.      3   waitforHBforms                     wait for HB, for 50 + [0, 0] ms                                                                                                                                                                                                                              ('/LoggerWrapper.h',43)   
26.      3   Electiontimeoutinitiateleaderele   Election timeout, initiate leader election                                                                                                                                                                                                                   ('/LoggerWrapper.h',43)   
27.      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)   
28.      3   configatindexiscommittedprevconf   config at index 1 is committed, prev config log idx 0                                                                                                                                                                                                        ('/LoggerWrapper.h',43)   
29.      2   prevotetermisdifferentresetitto    pre-vote term (0) is different, reset it to 1                                                                                                                                                                                                                ('/LoggerWrapper.h',43)   
30.      2   CodeDBExceptionGoterrorfromlocal   Code: 439. DB::Exception: Got error from localhost:9000. DB::Exception: Cannot schedule a task: failed to start the thread (threads=0, jobs=0). Stack trace:

0. /build/contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String con   ('/executeQuery.cpp',221)



Top messages not matching their format strings:

message_format_string                                                                                  count()   any_message                                                                                                                                                                                                                                               

1.  {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting)       102   /var/lib/clickhouse/store/4fc/4fc3aa01-0ee0-40e4-9f19-fcc29db6b875/tmp_merge_202510_1_5_1/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 1 similar messages)                                  
2.                                                                                                              87   Forked a child process to watch                                                                                                                                                                                                                            
3.  Illegal UTF-8 sequence, while processing '{}'                                                               12   Code: 36. DB::Exception: Illegal UTF-8 sequence, while processing '�
': while executing 'FUNCTION stringJaccardIndexUTF8(materialize('hello'_String) :: 3, materialize('�
'_String) :: 1) -> stringJaccardIndexUTF8(materialize('hello'_String), materialize('�
'_String)) Float64 : 2'. (BAD_ARGUMENTS) (version 24.8.14.10531.altinitytest (altinity build)) (from [::1]:37320) (comment: 02884_string_distance_function.sql) (in query: SELECT stringJaccardIndexUTF8(materialize('hello'), materialize('\xC2\x01'));), Stack trace (when copying this message, always include the lines below):

0. /build/contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000001648cf32
1. /build/src/Common/Exception.cpp:111: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c652179
2. /build/contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000701116c
3. /build/contrib/llvm-project/libcxx/include/vector:438: DB::Exception::Exception<StringRef>(int, FormatStringHelperImpl<std::type_identity<StringRef>::type>, StringRef&&) @ 0x0000000007af8fcb
4. /build/src/Functions/FunctionsStringDistance.cpp:0: DB::parseUTF8String(char const*, unsigned long, std::function<void (unsigned int)>, std::function<void (unsigned char)>) @ 0x0000000007af881c
5. /build/contrib/llvm-project/libcxx/include/__functional/function.h:818: ? @ 0x0000000007b027b7
6. /build/src/Common/PODArray.h:208: DB::FunctionStringDistanceImpl<DB::ByteJaccardIndexImpl<true>>::vectorVector(DB::PODArray<char8_t, 4096ul, Allocator<false, false>, 63ul, 64ul> const&, DB::PODArray<unsigned long, 4096ul, Allocator<false, false>, 63ul, 64ul> const&, DB::PODArray<char8_t, 4096ul, Allocator<false, false>, 63ul, 64ul> const&, DB::PODArray<unsigned long, 4096ul, Allocator<false, false>, 63ul, 64ul> const&, DB::PODArray<double, 4096ul, Allocator<false, false>, 63ul, 64ul>&, unsigned long) @ 0x0000000007b023cf
7. /build/src/Functions/FunctionsStringSimilarity.h:0: DB::FunctionsStringSimilarity<DB::FunctionStringDistanceImpl<DB::ByteJaccardIndexImpl<true>>, DB::NameJaccardIndexUTF8>::executeImpl(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>> const&, std::shared_ptr<DB::IDataType const> const&, unsigned long) const @ 0x0000000007b01c2f
8. /build/src/Functions/IFunctionAdaptors.h:22: DB::FunctionToExecutableFunctionAdaptor::executeImpl(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>> const&, std::shared_ptr<DB::IDataType const> const&, unsigned long) const @ 0x000000000702697a
9. /build/contrib/boost/boost/smart_ptr/intrusive_ptr.hpp:117: DB::IExecutableFunction::executeWithoutLowCardinalityColumns(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>> const&, std::shared_ptr<DB::IDataType const> const&, unsigned long, bool) const @ 0x0000000007b69ca5
10. /build/contrib/boost/boost/smart_ptr/intrusive_ptr.hpp:117: DB::IExecutableFunction::executeWithoutSparseColumns(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>> const&, std::shared_ptr<DB::IDataType const> const&, unsigned long, bool) const @ 0x0000000007b6a71a
11. /build/src/Functions/IFunction.cpp:0: DB::IExecutableFunction::execute(std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>> const&, std::shared_ptr<DB::IDataType const> const&, unsigned long, bool) const @ 0x0000000007b6b645
12. /build/contrib/boost/boost/smart_ptr/intrusive_ptr.hpp:117: DB::ExpressionActions::execute(DB::Block&, unsigned long&, bool, bool) const @ 0x000000001119c79d
13. /build/src/Processors/Transforms/ExpressionTransform.cpp:0: DB::ExpressionTransform::transform(DB::Chunk&) @ 0x0000000012fb7df6
14. /build/contrib/llvm-project/libcxx/include/__utility/swap.h:35: DB::ISimpleTransform::transform(DB::Chunk&, DB::Chunk&) @ 0x000000000c90c4d3
15. /build/src/Processors/ISimpleTransform.cpp:99: DB::ISimpleTransform::work() @ 0x0000000012d5abc9
16. /build/src/Processors/Executors/ExecutionThreadContext.cpp:0: DB::ExecutionThreadContext::executeTask() @ 0x0000000012d753e9
17. /build/src/Processors/Executors/PipelineExecutor.cpp:273: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic<bool>*) @ 0x0000000012d6b090
18. /build/contrib/llvm-project/libcxx/include/vector:547: DB::PipelineExecutor::executeSingleThread(unsigned long) @ 0x0000000012d6b31d
19. /build/contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:701: DB::PipelineExecutor::executeImpl(unsigned long, bool) @ 0x0000000012d6a18c
20. /build/contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:274: DB::PipelineExecutor::execute(unsigned long, bool) @ 0x0000000012d69ba5
21. /build/src/Processors/Executors/PullingAsyncPipelineExecutor.cpp:0: void std::__function::__policy_invoker<void ()>::__call_impl<std::__function::__default_alloc_func<ThreadFromGlobalPoolImpl<true, true>::ThreadFromGlobalPoolImpl<DB::PullingAsyncPipelineExecutor::pull(DB::Chunk&, unsigned long)::$_0>(DB::PullingAsyncPipelineExecutor::pull(DB::Chunk&, unsigned long)::$_0&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x0000000012d7826a
22. /build/base/base/../base/wide_integer_impl.h:817: ThreadPoolImpl<std::thread>::ThreadFromThreadPool::worker() @ 0x000000000c706d2e
23. /build/contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: void* std::__thread_proxy[abi:v15007]<std::tuple<std::unique_ptr<std::__thread_struct, std::default_delete<std::__thread_struct>>, void (ThreadPoolImpl<std::thread>::ThreadFromThreadPool::*)(), ThreadPoolImpl<std::thread>::ThreadFromThreadPool*>>(void*) @ 0x000000000c70c192
24. ? @ 0x00007fb1c1c90ac3
25. ? @ 0x00007fb1c1d22850



Top short messages:

c   message_format_string        substr(any(toValidUTF8(message)), 1, 120)                                                                                  min_length_without_exception_boilerplate

1.  17   {}                           Server was built in debug mode. It will work slowly.                                                                                                             26 
2.  10   Cannot TRUNCATE dictionary   Code: 62. DB::Exception: Cannot TRUNCATE dictionary. (SYNTAX_ERROR) (version 24.8.14.10531.altinitytest (altinity build)                                         27 
3.   5   Found {} on {}               Found snapshot_17.bin.zstd on LocalSnapshotDisk                                                                                                                  18 
4.   2   Creating {}: {}              Creating table test_5.test: CREATE TABLE IF NOT EXISTS test_5.test UUID 'c55f5845-601b-4734-8d94-90d98822391a' (`test` A                                        197 
5.   1   Froze {} parts               Froze 1 parts                                                                                                                                                   -13



Top messages by level:

(0.006329698287801225,'Setting {} should not be changed')	Error
(0.00027185900263651937,'Not enabled four letter command {}')	Warning
(0.002816048914102814,'Part {} already exists, but it will be deleted soon')	Information
(0.04505165321050094,'Processed in {} sec.')	Debug
(0.06573345507145276,'Checking existence of path: {}')	Trace


2025-10-21 00:02:21,004 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=2994
+ clickhouse stop --max-tries 90 --do-not-kill
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2994.
The process with pid = 2994 is running.
Sent terminate signal to process with pid 2994.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2994.
The process with pid = 2994 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2994.
The process with pid = 2994 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2994.
The process with pid = 2994 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2994.
The process with pid = 2994 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2994.
The process with pid = 2994 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2994.
The process with pid = 2994 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2994.
The process with pid = 2994 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2994.
The process with pid = 2994 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
127.0.0.1 - - [20/Oct/2025:22:02:29 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 -
+ counter=2
+ clickhouse-client --query 'SELECT 1'
127.0.0.1 - - [20/Oct/2025:22:02:29 +0000] "PUT /devstoreaccount1/cont/rbmfrulbvlgkxfjqfnbwebxrcwqguaac HTTP/1.1" 201 -
127.0.0.1 - - [20/Oct/2025:22:02:29 +0000] "GET /devstoreaccount1/cont/rbmfrulbvlgkxfjqfnbwebxrcwqguaac HTTP/1.1" 206 4
127.0.0.1 - - [20/Oct/2025:22:02:29 +0000] "GET /devstoreaccount1/cont/rbmfrulbvlgkxfjqfnbwebxrcwqguaac HTTP/1.1" 206 2
127.0.0.1 - - [20/Oct/2025:22:02:29 +0000] "DELETE /devstoreaccount1/cont/rbmfrulbvlgkxfjqfnbwebxrcwqguaac HTTP/1.1" 202 -
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'
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=742, jobs=708). (CANNOT_SCHEDULE_TASK)
(query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value))
++ retry=1
++ sleep 5
++ '[' 1 -ge 5 ']'
++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ false
++ return
+ IS_ASAN=0
+ [[ 0 = \1 ]]
++ kill -l SIGRTMIN
+ RTMIN=34
+ echo '
        set follow-fork-mode parent
        handle SIGHUP nostop noprint pass
        handle SIGINT nostop noprint pass
        handle SIGQUIT nostop noprint pass
        handle SIGPIPE nostop noprint pass
        handle SIGTERM nostop noprint pass
        handle SIGUSR1 nostop noprint pass
        handle SIGUSR2 nostop noprint pass
        handle SIG34 nostop noprint pass
        info signals
        continue
        backtrace full
        info registers
        p top' 1 KiB of the 'stack:
        p/x *(uint64_t[128]*)$sp
        maintenance info sections
        thread apply all backtrace full
        disassemble /s
        up
        disassemble /s
        up
        disassemble /s
        p "done"
        detach
        quit
        '
+ sleep 5
+ ts '%Y-%m-%d %H:%M:%S'
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ gdb -batch -command script.gdb -p 44111
+ run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
+ [[ hxB =~ e ]]
+ set_e=false
+ set +e
+ local total_retries=60
+ shift
+ local retry=0
+ '[' 0 -ge 60 ']'
+ clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
Connected to clickhouse-server after attaching gdb
+ false
+ return
+ check_server_start
+ clickhouse-client --query 'SELECT '\''Server successfully started'\'', '\''OK'\'', NULL, '\'''\'''
+ '[' -s /test_output/application_errors.txt ']'
+ rm /test_output/application_errors.txt
rm: cannot remove '/test_output/application_errors.txt': No such file or directory
+ stop_server
+ local max_tries=90
+ local check_hang=true
+ local pid
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ pid=44111
+ clickhouse stop --max-tries 90 --do-not-kill
script.gdb:13: Error in sourced command file:
No stack.
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 44111.
The process with pid = 44111 is running.
Sent terminate signal to process with pid 44111.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 44111.
The process with pid = 44111 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 44111.
The process with pid = 44111 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 44111.
The process with pid = 44111 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 44111.
The process with pid = 44111 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 ' <Fatal> Application: Child process was terminated by signal 9' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No OOM messages in clickhouse-server.log\tOK\t\N\t'
+ rg -Fa 'Code: 49. DB::Exception: ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No logical errors\tOK\t\N\t'
+ '[' -s /test_output/logical_errors.txt ']'
+ rm /test_output/logical_errors.txt
+ grep -v a.myext
+ rg --text 'Code: 499.*The specified key does not exist' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No lost s3 keys\tOK\t\N\t'
+ 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 ' <Fatal> ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No fatal messages in clickhouse-server.log\tOK\t\N\t'
+ '[' -s /test_output/fatal_messages.txt ']'
+ rm /test_output/fatal_messages.txt
+ rg -Faz '########################################' /test_output/gdb.log /test_output/stress_run_logs.tar.zst /test_output/test_results.tsv
+ rg -Fa ' received signal ' /test_output/gdb.log
+ dmesg -T
+ grep -q -F -e 'Out of memory: Killed process' -e 'oom_reaper: reaped process' -e oom-kill:constraint=CONSTRAINT_NONE /test_output/dmesg.log
+ echo -e 'No OOM in dmesg\tOK\t\N\t'
+ tar -chf /test_output/coordination.tar /var/lib/clickhouse/coordination
tar: Removing leading `/' from member names
tar: Removing leading `/' from hard link targets
+ collect_query_and_trace_logs
+ for table in query_log trace_log metric_log
+ clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.query_log format TSVWithNamesAndTypes'
+ zstd --threads=0
Logging trace to /var/log/clickhouse-server/clickhouse-server.log
Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
127.0.0.1 - - [20/Oct/2025:22:02:52 +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 - - [20/Oct/2025:22:02:54 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 -
+ for table in query_log trace_log metric_log
+ clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.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 - - [20/Oct/2025:22:02:56 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 -
+ mv /var/log/clickhouse-server/stderr.log /test_output/
+ clickhouse-local --structure 'test String, res String, time Nullable(Float32), desc String' -q 'SELECT '\''failure'\'', test FROM table WHERE res != '\''OK'\'' order by
(test like '\''%Sanitizer%'\'') DESC,
(test like '\''%Killed by signal%'\'') DESC,
(test like '\''%gdb.log%'\'') DESC,
(test ilike '\''%possible deadlock%'\'') DESC,
(test like '\''%start%'\'') DESC,
(test like '\''%dmesg%'\'') DESC,
(test like '\''%OOM%'\'') DESC,
(test like '\''%Signal 9%'\'') DESC,
(test like '\''%Fatal message%'\'') DESC,
rowNumberInAllBlocks()
LIMIT 1'
+ '[' -s /test_output/check_status.tsv ']'
+ echo -e 'success\tNo errors found'
+ rg 'OOM in dmesg|Signal 9' /test_output/check_status.tsv
+ collect_core_dumps
+ find . -type f -maxdepth 1 -name 'core.*'
+ read -r core