+ 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.10505.altinitytest+msan_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.10505.altinitytest+msan_amd64.deb ...
Unpacking clickhouse-common-static (24.8.14.10505.altinitytest+msan) ...
Setting up clickhouse-common-static (24.8.14.10505.altinitytest+msan) ...
+ dpkg -i package_folder/clickhouse-common-static-dbg_24.8.14.10505.altinitytest+msan_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.10505.altinitytest+msan_amd64.deb ...
Unpacking clickhouse-common-static-dbg (24.8.14.10505.altinitytest+msan) ...
Setting up clickhouse-common-static-dbg (24.8.14.10505.altinitytest+msan) ...
+ dpkg -i package_folder/clickhouse-server_24.8.14.10505.altinitytest+msan_amd64.deb
Selecting previously unselected package clickhouse-server.
(Reading database ... 48730 files and directories currently installed.)
Preparing to unpack .../clickhouse-server_24.8.14.10505.altinitytest+msan_amd64.deb ...
Unpacking clickhouse-server (24.8.14.10505.altinitytest+msan) ...
Setting up clickhouse-server (24.8.14.10505.altinitytest+msan) ...
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.10505.altinitytest+msan_amd64.deb
Selecting previously unselected package clickhouse-client.
(Reading database ... 48747 files and directories currently installed.)
Preparing to unpack .../clickhouse-client_24.8.14.10505.altinitytest+msan_amd64.deb ...
Unpacking clickhouse-client (24.8.14.10505.altinitytest+msan) ...
Setting up clickhouse-client (24.8.14.10505.altinitytest+msan) ...
+ export THREAD_FUZZER_CPU_TIME_PERIOD_US=1000
+ THREAD_FUZZER_CPU_TIME_PERIOD_US=1000
+ export THREAD_FUZZER_SLEEP_PROBABILITY=0.1
+ THREAD_FUZZER_SLEEP_PROBABILITY=0.1
+ export THREAD_FUZZER_SLEEP_TIME_US_MAX=100000
+ THREAD_FUZZER_SLEEP_TIME_US_MAX=100000
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000
+ export THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01
+ THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01
+ export THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01
+ THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01
+ export ZOOKEEPER_FAULT_INJECTION=1
+ ZOOKEEPER_FAULT_INJECTION=1
+ configure
+ export USE_DATABASE_ORDINARY=1
+ USE_DATABASE_ORDINARY=1
+ export EXPORT_S3_STORAGE_POLICIES=1
+ EXPORT_S3_STORAGE_POLICIES=1
+ /usr/share/clickhouse-test/config/install.sh
+ DEST_SERVER_PATH=/etc/clickhouse-server
+ DEST_CLIENT_PATH=/etc/clickhouse-client
+++ dirname /usr/share/clickhouse-test/config/install.sh
++ cd /usr/share/clickhouse-test/config
++ pwd -P
+ SRC_PATH=/usr/share/clickhouse-test/config
+ echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server'
+ mkdir -p /etc/clickhouse-server/config.d/
Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server
+ mkdir -p /etc/clickhouse-server/users.d/
+ mkdir -p /etc/clickhouse-client
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_catalog_drop_table_concurrency.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/grpc_protocol.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/block_number.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/serverwide_trace_collector.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/rocksdb.xml /etc/clickhouse-server/config.d/
+ '[' /etc/clickhouse-server = /etc/clickhouse-server ']'
+ ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/
+ ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ rm -f /etc/clickhouse-server/config.d/zookeeper.xml
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/
+ [[ -n '' ]]
+ rm -f /etc/clickhouse-server/config.d/cannot_allocate_thread_injection.xml
+ value=0
+ sed --follow-symlinks -i 's|[01]|0|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=6836224
+ sed --follow-symlinks -i 's|[[:digit:]]\+|6836224|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=45062144
+ sed --follow-symlinks -i 's|[[:digit:]]\+|45062144|' /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n '' ]]
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/
+ [[ '' == \1 ]]
+ [[ '' == \1 ]]
+ [[ -n 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|100000|10000|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value filtered_list keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value multi_read keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value check_not_exists keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value create_if_not_exists keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value use_compression zookeeper_fault_injection
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ randomize_config_boolean_value enable_block_number_column block_number
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/block_number.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml
+ randomize_config_boolean_value enable_block_offset_column block_number
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/block_number.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml
+ echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\'''
+ export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ sudo chown root: /var/lib/clickhouse
+ local total_mem
++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo
+ total_mem=32086432
+ total_mem=32856506368
+ max_server_memory_usage_to_ram_ratio=0.5
Setting max_server_memory_usage_to_ram_ratio to 0.5
+ echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5'
+ cat
+ local max_users_mem
+ max_users_mem=9856951910
+ echo 'Setting max_memory_usage_for_user=9856951910 and max_memory_usage for queries to 10G'
+ cat
Setting max_memory_usage_for_user=9856951910 and max_memory_usage for queries to 10G
+ cat
+ ./setup_minio.sh stateless
+ azurite-blob --blobHost 0.0.0.0 --blobPort 10000 --debug /azurite_log
+ export MINIO_ROOT_USER=clickhouse
+ MINIO_ROOT_USER=clickhouse
+ export MINIO_ROOT_PASSWORD=clickhouse
+ MINIO_ROOT_PASSWORD=clickhouse
+ main stateless
+ local query_dir
++ check_arg stateless
++ local query_dir
++ '[' '!' 1 -eq 1 ']'
++ case "$1" in
++ query_dir=0_stateless
++ echo 0_stateless
+ query_dir=0_stateless
+ '[' '!' -f ./minio ']'
+ start_minio
+ mkdir -p ./minio_data
+ ./minio --version
minio version RELEASE.2024-08-03T04-33-23Z (commit-id=6efb56851c40da88d1ca15112e2d686a4ecec6b3)
Runtime: go1.22.5 linux/amd64
License: GNU AGPLv3 - https://www.gnu.org/licenses/agpl-3.0.html
Copyright: 2015-2024 MinIO, Inc.
+ wait_for_it
+ 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
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:37501 http://127.0.0.1:37501
Docs: https://min.io/docs/minio/linux/index.html
Azurite Blob service is starting on 0.0.0.0:10000
Azurite Blob service successfully listens on http://0.0.0.0:10000
+ counter=1
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
AccessDenied
Access Denied./18639CB30A4FDEBB7dc7eb22d3288ec80374614e9088e31d3668a6922ead55932dd2a8e56373820f
+ lsof -i :11111
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
minio 275 root 8u IPv4 25358 0t0 TCP localhost:11111 (LISTEN)
minio 275 root 9u IPv6 25359 0t0 TCP *:11111 (LISTEN)
minio 275 root 10u IPv6 25360 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/03036_archive1.tar` -> `clickminio/test/03036_archive1.tar`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow` -> `clickminio/test/02731.arrow`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl` -> `clickminio/test/02366_data.jsonl`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet` -> `clickminio/test/02731.parquet`
`/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.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: 146.18 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
+ counter=16
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 16 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=17
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 17 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=18
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 18 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=19
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 19 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=20
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 20 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=21
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 21 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=22
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 22 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=23
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 23 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=24
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 24 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=25
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 25 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=26
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 26 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=27
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 27 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=28
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 28 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=29
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 29 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=30
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 30 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=31
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 31 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=32
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 32 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=33
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 33 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=34
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
127.0.0.1 - - [09/Sep/2025:12:23:26 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 404 -
127.0.0.1 - - [09/Sep/2025:12:23:26 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 -
127.0.0.1 - - [09/Sep/2025:12:23:26 +0000] "PUT /devstoreaccount1/cont/lymufznldroduibmypumbltlydpijukv HTTP/1.1" 201 -
+ '[' 34 -gt 120 ']'
+ clickhouse start --user root
127.0.0.1 - - [09/Sep/2025:12:23:26 +0000] "GET /devstoreaccount1/cont/lymufznldroduibmypumbltlydpijukv HTTP/1.1" 206 4
127.0.0.1 - - [09/Sep/2025:12:23:26 +0000] "GET /devstoreaccount1/cont/lymufznldroduibmypumbltlydpijukv HTTP/1.1" 206 2
127.0.0.1 - - [09/Sep/2025:12:23:26 +0000] "DELETE /devstoreaccount1/cont/lymufznldroduibmypumbltlydpijukv HTTP/1.1" 202 -
+ sleep 0.5
+ counter=35
+ 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 408
+ 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=408
+ 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 = 408.
The process with pid = 408 is running.
Sent terminate signal to process with pid 408.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408.
The process with pid = 408 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408.
The process with pid = 408 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408.
The process with pid = 408 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408.
The process with pid = 408 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408.
The process with pid = 408 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408.
The process with pid = 408 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408.
The process with pid = 408 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 408.
The process with pid = 408 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|LRU|SLRU|'
+ mv /etc/clickhouse-server/config.d/storage_conf.xml.tmp /etc/clickhouse-server/config.d/storage_conf.xml
+ sudo cat /etc/clickhouse-server/users.d/stress_tests_overrides.xml
cat: /etc/clickhouse-server/users.d/stress_tests_overrides.xml: No such file or directory
+ start_server
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 13 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=14
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 14 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=15
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 15 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=16
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 16 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=17
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 17 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=18
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 18 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=19
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 19 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=20
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 20 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=21
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 21 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=22
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 22 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=23
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 23 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=24
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 24 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=25
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 25 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=26
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 26 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=27
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 27 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=28
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 28 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=29
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 29 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=30
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 30 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=31
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 31 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=32
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 32 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=33
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 33 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=34
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 34 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=35
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 35 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=36
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 36 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=37
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 37 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=38
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 38 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=39
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 39 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=40
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 40 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=41
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 41 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=42
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 42 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
127.0.0.1 - - [09/Sep/2025:12:24:34 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 -
127.0.0.1 - - [09/Sep/2025:12:24:34 +0000] "PUT /devstoreaccount1/cont/ffeqdlzithdztreujrdfytidgabhwjga HTTP/1.1" 201 -
127.0.0.1 - - [09/Sep/2025:12:24:34 +0000] "GET /devstoreaccount1/cont/ffeqdlzithdztreujrdfytidgabhwjga HTTP/1.1" 206 4
127.0.0.1 - - [09/Sep/2025:12:24:34 +0000] "GET /devstoreaccount1/cont/ffeqdlzithdztreujrdfytidgabhwjga HTTP/1.1" 206 2
127.0.0.1 - - [09/Sep/2025:12:24:34 +0000] "DELETE /devstoreaccount1/cont/ffeqdlzithdztreujrdfytidgabhwjga HTTP/1.1" 202 -
+ counter=43
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 43 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=44
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 44 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=45
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 45 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=46
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 46 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=47
+ clickhouse-client --query 'SELECT 1'
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 1372
+ 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.30 GiB (attempt to allocate chunk of 1114112 bytes), maximum: 15.30 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.: (while reading column RefererRegions): (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 68 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 (total) exceeded: would use 15.30 GiB (attempt to allocate chunk of 1179520 bytes), maximum: 15.30 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.: (while reading column UTMContent): (while reading from part store/78e/78ebf6a1-d987-4579-b3ec-00c1a087b1f3/201403_1_1_2/ in table datasets.hits_v1 (78ebf6a1-d987-4579-b3ec-00c1a087b1f3) located on disk __tmp_internal_262634248876485800814430204900764312493 of type web, from mark 156 with max_rows_to_read = 8192): While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (MEMORY_LIMIT_EXCEEDED)
(query: INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16)
+ clickhouse-client --query 'INSERT INTO test.visits SELECT * FROM datasets.visits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16'
Received exception from server (version 24.8.14):
Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (total) exceeded: would use 15.30 GiB (attempt to allocate chunk of 1310720 bytes), maximum: 15.30 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.. (MEMORY_LIMIT_EXCEEDED)
(query: INSERT INTO test.visits SELECT * FROM datasets.visits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16)
+ clickhouse-client --query 'DROP TABLE datasets.visits_v1 SYNC'
+ clickhouse-client --query 'DROP TABLE datasets.hits_v1 SYNC'
+ clickhouse-client --query 'SHOW TABLES FROM test'
hits
hits_s3
visits
+ clickhouse-client --query 'SYSTEM STOP THREAD FUZZER'
+ stop_server
+ local max_tries=90
+ local check_hang=true
+ local pid
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ pid=1372
+ 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 = 1372.
The process with pid = 1372 is running.
Sent terminate signal to process with pid 1372.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1372.
The process with pid = 1372 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1372.
The process with pid = 1372 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1372.
The process with pid = 1372 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1372.
The process with pid = 1372 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1372.
The process with pid = 1372 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1372.
The process with pid = 1372 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ export RANDOMIZE_OBJECT_KEY_TYPE=1
+ RANDOMIZE_OBJECT_KEY_TYPE=1
+ export ZOOKEEPER_FAULT_INJECTION=1
+ ZOOKEEPER_FAULT_INJECTION=1
+ export THREAD_POOL_FAULT_INJECTION=1
+ THREAD_POOL_FAULT_INJECTION=1
+ configure
+ export USE_DATABASE_ORDINARY=1
+ USE_DATABASE_ORDINARY=1
+ export EXPORT_S3_STORAGE_POLICIES=1
+ EXPORT_S3_STORAGE_POLICIES=1
+ /usr/share/clickhouse-test/config/install.sh
+ DEST_SERVER_PATH=/etc/clickhouse-server
+ DEST_CLIENT_PATH=/etc/clickhouse-client
+++ dirname /usr/share/clickhouse-test/config/install.sh
++ cd /usr/share/clickhouse-test/config
++ pwd -P
Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server
+ SRC_PATH=/usr/share/clickhouse-test/config
+ echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server'
+ mkdir -p /etc/clickhouse-server/config.d/
+ mkdir -p /etc/clickhouse-server/users.d/
+ mkdir -p /etc/clickhouse-client
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_catalog_drop_table_concurrency.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/grpc_protocol.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/block_number.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/serverwide_trace_collector.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/rocksdb.xml /etc/clickhouse-server/config.d/
+ '[' /etc/clickhouse-server = /etc/clickhouse-server ']'
+ ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/
+ ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ rm -f /etc/clickhouse-server/config.d/zookeeper.xml
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/config.d/cannot_allocate_thread_injection.xml /etc/clickhouse-server/config.d/
+ value=0
+ sed --follow-symlinks -i 's|[01]|0|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=8826880
+ sed --follow-symlinks -i 's|[[:digit:]]\+|8826880|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=62351360
+ sed --follow-symlinks -i 's|[[:digit:]]\+|62351360|' /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n '' ]]
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/
+ [[ '' == \1 ]]
+ [[ '' == \1 ]]
+ [[ -n 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|100000|10000|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value filtered_list keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value multi_read keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value check_not_exists keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value create_if_not_exists keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value use_compression zookeeper_fault_injection
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ randomize_config_boolean_value enable_block_number_column block_number
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/block_number.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml
+ randomize_config_boolean_value enable_block_offset_column block_number
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/block_number.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml
+ echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\'''
+ export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ sudo chown root: /var/lib/clickhouse
+ local total_mem
++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo
Setting max_server_memory_usage_to_ram_ratio to 0.5
+ total_mem=32086432
+ total_mem=32856506368
+ max_server_memory_usage_to_ram_ratio=0.5
+ echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5'
+ cat
Setting max_memory_usage_for_user=9856951910 and max_memory_usage for queries to 10G
+ local max_users_mem
+ max_users_mem=9856951910
+ echo 'Setting max_memory_usage_for_user=9856951910 and max_memory_usage for queries to 10G'
+ cat
+ cat
+ [[ '' == \1 ]]
+ [[ '' == \1 ]]
+ sudo cat /etc/clickhouse-server/config.d/logger_trace.xml
+ sed 's|trace|test|'
+ mv /etc/clickhouse-server/config.d/logger_trace.xml.tmp /etc/clickhouse-server/config.d/logger_trace.xml
+ '[' SLRU = SLRU ']'
+ sudo cat /etc/clickhouse-server/config.d/storage_conf.xml
+ sed 's|LRU|SLRU|'
+ mv /etc/clickhouse-server/config.d/storage_conf.xml.tmp /etc/clickhouse-server/config.d/storage_conf.xml
++ date +%-d
+ '[' 1 -eq 1 ']'
+ sudo echo 'true'
+ start_server
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 13 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=14
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 14 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=15
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 15 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=16
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 16 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=17
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 17 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=18
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 18 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=19
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 19 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=20
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 20 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=21
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 21 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=22
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 22 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=23
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 23 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=24
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 24 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=25
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 25 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=26
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 26 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=27
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 27 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=28
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 28 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=29
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 29 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=30
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 30 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=31
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 31 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=32
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 32 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=33
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 33 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
127.0.0.1 - - [09/Sep/2025:12:26:44 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 -
127.0.0.1 - - [09/Sep/2025:12:26:44 +0000] "PUT /devstoreaccount1/cont/txvtdlfktrvyszgypmgdpvdzgzzyivbt HTTP/1.1" 201 -
127.0.0.1 - - [09/Sep/2025:12:26:44 +0000] "GET /devstoreaccount1/cont/txvtdlfktrvyszgypmgdpvdzgzzyivbt HTTP/1.1" 206 4
127.0.0.1 - - [09/Sep/2025:12:26:44 +0000] "GET /devstoreaccount1/cont/txvtdlfktrvyszgypmgdpvdzgzzyivbt HTTP/1.1" 206 2
127.0.0.1 - - [09/Sep/2025:12:26:44 +0000] "DELETE /devstoreaccount1/cont/txvtdlfktrvyszgypmgdpvdzgzzyivbt HTTP/1.1" 202 -
+ counter=34
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 34 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=35
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 35 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=36
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 36 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=37
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 37 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=38
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 38 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=39
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ [[ hxB =~ e ]]
++ set_e=false
++ set +e
++ local total_retries=5
++ shift
++ local retry=0
++ '[' 0 -ge 5 ']'
++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
Received exception from server (version 24.8.14):
Code: 439. DB::Exception: Received from localhost:9000. DB::Exception: Cannot schedule a task: fault injected (threads=1, jobs=1). (CANNOT_SCHEDULE_TASK)
(query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value))
++ retry=1
++ sleep 5
++ '[' 1 -ge 5 ']'
++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
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=7, jobs=7). (CANNOT_SCHEDULE_TASK)
(query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value))
++ retry=2
++ sleep 5
++ '[' 2 -ge 5 ']'
++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ false
++ return
+ IS_ASAN=0
+ [[ 0 = \1 ]]
++ kill -l SIGRTMIN
+ RTMIN=34
+ echo '
set follow-fork-mode parent
handle SIGHUP nostop noprint pass
handle SIGINT nostop noprint pass
handle SIGQUIT nostop noprint pass
handle SIGPIPE nostop noprint pass
handle SIGTERM nostop noprint pass
handle SIGUSR1 nostop noprint pass
handle SIGUSR2 nostop noprint pass
handle SIG34 nostop noprint pass
info signals
continue
backtrace full
info registers
p top' 1 KiB of the 'stack:
p/x *(uint64_t[128]*)$sp
maintenance info sections
thread apply all backtrace full
disassemble /s
up
disassemble /s
up
disassemble /s
p "done"
detach
quit
'
+ sleep 5
+ ts '%Y-%m-%d %H:%M:%S'
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ gdb -batch -command script.gdb -p 2874
+ 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-09-09 14:27:10,105 Run func tests '/usr/bin/clickhouse-test --client-option ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-09-09 14:27:10,606 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_1 --client-option join_use_nulls=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-09-09 14:27:11,108 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' http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-09-09 14:27:11,609 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-09-09 14:27:12,110 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 http_make_head_request=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-09-09 14:27:12,611 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_5', 's1', 'r1')" --database=test_5 --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='full_sorting_merge' use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-09-09 14:27:13,113 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 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-09-09 14:27:13,614 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_7 --client-option join_use_nulls=1 join_algorithm='grace_hash' group_by_use_nulls=1 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-09-09 14:27:14,115 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-09-09 14:27:14,617 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_9 --client-option join_algorithm='auto' max_rows_in_join=1000 group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-09-09 14:27:15,118 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-09-09 14:27:15,619 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-09-09 14:27:16,121 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' implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-09-09 14:27:16,622 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_13 --client-option join_use_nulls=1 join_algorithm='partial_merge' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-09-09 14:27:17,123 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=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-09-09 14:27:17,624 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_merge' group_by_use_nulls=1 http_make_head_request=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-09-09 14:27:18,125 Will wait functests to finish
2025-09-09 14:27:18,125 Finished 7 from 16 processes
2025-09-09 14:27:23,130 Finished 7 from 16 processes
2025-09-09 14:27:28,132 Finished 7 from 16 processes
2025-09-09 14:27:33,136 Finished 7 from 16 processes
2025-09-09 14:27:38,140 Finished 7 from 16 processes
2025-09-09 14:27:43,144 Finished 8 from 16 processes
2025-09-09 14:27:48,148 Finished 8 from 16 processes
2025-09-09 14:27:53,152 Finished 8 from 16 processes
2025-09-09 14:27:58,156 Finished 8 from 16 processes
2025-09-09 14:28:03,160 Finished 9 from 16 processes
2025-09-09 14:28:08,164 Finished 10 from 16 processes
2025-09-09 14:28:13,168 Finished 10 from 16 processes
2025-09-09 14:28:18,172 Finished 10 from 16 processes
2025-09-09 14:28:23,178 Finished 10 from 16 processes
2025-09-09 14:28:28,180 Finished 10 from 16 processes
2025-09-09 14:28:33,184 Finished 10 from 16 processes
2025-09-09 14:28:38,188 Finished 10 from 16 processes
2025-09-09 14:28:43,192 Finished 10 from 16 processes
2025-09-09 14:28:48,196 Finished 10 from 16 processes
2025-09-09 14:28:53,200 Finished 10 from 16 processes
2025-09-09 14:28:58,206 Finished 10 from 16 processes
2025-09-09 14:29:03,208 Finished 10 from 16 processes
2025-09-09 14:29:08,212 Finished 10 from 16 processes
2025-09-09 14:29:13,216 Finished 11 from 16 processes
2025-09-09 14:29:18,220 Finished 11 from 16 processes
2025-09-09 14:29:23,224 Finished 11 from 16 processes
2025-09-09 14:29:28,228 Finished 11 from 16 processes
2025-09-09 14:29:33,232 Finished 11 from 16 processes
2025-09-09 14:29:38,236 Finished 12 from 16 processes
2025-09-09 14:29:43,239 Finished 12 from 16 processes
2025-09-09 14:29:48,245 Finished 12 from 16 processes
2025-09-09 14:29:53,248 Finished 12 from 16 processes
2025-09-09 14:29:58,252 Finished 12 from 16 processes
2025-09-09 14:30:03,258 Finished 12 from 16 processes
2025-09-09 14:30:08,260 Finished 12 from 16 processes
2025-09-09 14:30:13,264 Finished 12 from 16 processes
2025-09-09 14:30:18,268 Finished 12 from 16 processes
2025-09-09 14:30:23,272 Finished 12 from 16 processes
2025-09-09 14:30:28,276 Finished 12 from 16 processes
2025-09-09 14:30:33,280 Finished 12 from 16 processes
2025-09-09 14:30:38,284 Finished 12 from 16 processes
2025-09-09 14:30:43,288 Finished 12 from 16 processes
2025-09-09 14:30:48,294 Finished 12 from 16 processes
2025-09-09 14:30:53,297 Finished 12 from 16 processes
2025-09-09 14:30:58,300 Finished 12 from 16 processes
2025-09-09 14:31:03,306 Finished 12 from 16 processes
2025-09-09 14:31:08,309 Finished 12 from 16 processes
2025-09-09 14:31:13,313 Finished 12 from 16 processes
2025-09-09 14:31:18,318 Finished 12 from 16 processes
2025-09-09 14:31:23,324 Finished 12 from 16 processes
2025-09-09 14:31:28,329 Finished 12 from 16 processes
2025-09-09 14:31:33,330 Finished 12 from 16 processes
2025-09-09 14:31:38,332 Finished 12 from 16 processes
2025-09-09 14:31:43,337 Finished 12 from 16 processes
2025-09-09 14:31:48,341 Finished 12 from 16 processes
2025-09-09 14:31:53,344 Finished 12 from 16 processes
2025-09-09 14:31:58,348 Finished 12 from 16 processes
2025-09-09 14:32:03,352 Finished 12 from 16 processes
2025-09-09 14:32:08,356 Finished 12 from 16 processes
2025-09-09 14:32:13,362 Finished 12 from 16 processes
2025-09-09 14:32:18,364 Finished 12 from 16 processes
2025-09-09 14:32:23,368 Finished 12 from 16 processes
2025-09-09 14:32:28,372 Finished 12 from 16 processes
2025-09-09 14:32:33,378 Finished 12 from 16 processes
2025-09-09 14:32:38,379 Finished 12 from 16 processes
2025-09-09 14:32:43,380 Finished 12 from 16 processes
2025-09-09 14:32:48,382 Finished 12 from 16 processes
2025-09-09 14:32:53,384 Finished 12 from 16 processes
2025-09-09 14:32:58,390 Finished 12 from 16 processes
2025-09-09 14:33:03,395 Finished 12 from 16 processes
2025-09-09 14:33:08,401 Finished 12 from 16 processes
2025-09-09 14:33:13,404 Finished 12 from 16 processes
2025-09-09 14:33:18,408 Finished 12 from 16 processes
2025-09-09 14:33:23,413 Finished 12 from 16 processes
2025-09-09 14:33:28,418 Finished 12 from 16 processes
2025-09-09 14:33:33,423 Finished 12 from 16 processes
2025-09-09 14:33:38,427 Finished 12 from 16 processes
2025-09-09 14:33:43,432 Finished 12 from 16 processes
2025-09-09 14:33:48,438 Finished 12 from 16 processes
2025-09-09 14:33:53,441 Finished 12 from 16 processes
2025-09-09 14:33:58,446 Finished 12 from 16 processes
2025-09-09 14:34:03,451 Finished 12 from 16 processes
2025-09-09 14:34:08,456 Finished 12 from 16 processes
2025-09-09 14:34:13,460 Finished 12 from 16 processes
2025-09-09 14:34:18,465 Finished 12 from 16 processes
2025-09-09 14:34:23,468 Finished 12 from 16 processes
2025-09-09 14:34:28,474 Finished 12 from 16 processes
2025-09-09 14:34:33,476 Finished 12 from 16 processes
2025-09-09 14:34:38,482 Finished 12 from 16 processes
2025-09-09 14:34:43,487 Finished 12 from 16 processes
2025-09-09 14:34:48,492 Finished 12 from 16 processes
2025-09-09 14:34:53,496 Finished 12 from 16 processes
2025-09-09 14:34:58,501 Finished 12 from 16 processes
2025-09-09 14:35:03,504 Finished 12 from 16 processes
2025-09-09 14:35:08,507 Finished 12 from 16 processes
2025-09-09 14:35:13,512 Finished 12 from 16 processes
2025-09-09 14:35:18,518 Finished 12 from 16 processes
2025-09-09 14:35:23,520 Finished 12 from 16 processes
2025-09-09 14:35:28,524 Finished 12 from 16 processes
2025-09-09 14:35:33,528 Finished 12 from 16 processes
2025-09-09 14:35:38,532 Finished 12 from 16 processes
2025-09-09 14:35:43,538 Finished 12 from 16 processes
2025-09-09 14:35:48,543 Finished 12 from 16 processes
2025-09-09 14:35:53,544 Finished 12 from 16 processes
2025-09-09 14:35:58,547 Finished 12 from 16 processes
2025-09-09 14:36:03,552 Finished 12 from 16 processes
2025-09-09 14:36:08,553 Finished 12 from 16 processes
2025-09-09 14:36:13,556 Finished 12 from 16 processes
2025-09-09 14:36:18,561 Finished 12 from 16 processes
2025-09-09 14:36:23,567 Finished 12 from 16 processes
2025-09-09 14:36:28,568 Finished 12 from 16 processes
2025-09-09 14:36:33,574 Finished 12 from 16 processes
2025-09-09 14:36:38,576 Finished 12 from 16 processes
2025-09-09 14:36:43,580 Finished 12 from 16 processes
2025-09-09 14:36:48,586 Finished 12 from 16 processes
2025-09-09 14:36:53,590 Finished 12 from 16 processes
2025-09-09 14:36:58,593 Finished 12 from 16 processes
2025-09-09 14:37:03,596 Finished 12 from 16 processes
2025-09-09 14:37:08,600 Finished 12 from 16 processes
2025-09-09 14:37:13,604 Finished 12 from 16 processes
2025-09-09 14:37:18,608 Finished 12 from 16 processes
2025-09-09 14:37:23,612 Finished 12 from 16 processes
2025-09-09 14:37:28,613 Finished 12 from 16 processes
2025-09-09 14:37:33,618 Finished 12 from 16 processes
2025-09-09 14:37:38,620 Finished 12 from 16 processes
2025-09-09 14:37:43,624 Finished 12 from 16 processes
2025-09-09 14:37:48,628 Finished 12 from 16 processes
2025-09-09 14:37:53,630 Finished 12 from 16 processes
2025-09-09 14:37:58,632 Finished 12 from 16 processes
2025-09-09 14:38:03,636 Finished 12 from 16 processes
2025-09-09 14:38:08,642 Finished 12 from 16 processes
2025-09-09 14:38:13,647 Finished 12 from 16 processes
2025-09-09 14:38:18,649 Finished 12 from 16 processes
2025-09-09 14:38:23,652 Finished 12 from 16 processes
2025-09-09 14:38:28,658 Finished 12 from 16 processes
2025-09-09 14:38:33,660 Finished 12 from 16 processes
2025-09-09 14:38:38,666 Finished 12 from 16 processes
2025-09-09 14:38:43,668 Finished 12 from 16 processes
2025-09-09 14:38:48,672 Finished 12 from 16 processes
2025-09-09 14:38:53,678 Finished 12 from 16 processes
2025-09-09 14:38:58,682 Finished 12 from 16 processes
2025-09-09 14:39:03,685 Finished 12 from 16 processes
2025-09-09 14:39:08,688 Finished 12 from 16 processes
2025-09-09 14:39:13,689 Finished 12 from 16 processes
2025-09-09 14:39:18,692 Finished 12 from 16 processes
2025-09-09 14:39:23,696 Finished 12 from 16 processes
2025-09-09 14:39:28,700 Finished 12 from 16 processes
2025-09-09 14:39:33,706 Finished 12 from 16 processes
2025-09-09 14:39:38,708 Finished 12 from 16 processes
2025-09-09 14:39:43,714 Finished 12 from 16 processes
2025-09-09 14:39:48,716 Finished 12 from 16 processes
2025-09-09 14:39:53,717 Finished 12 from 16 processes
2025-09-09 14:39:58,721 Finished 13 from 16 processes
2025-09-09 14:40:03,724 Finished 13 from 16 processes
2025-09-09 14:40:08,728 Finished 13 from 16 processes
2025-09-09 14:40:13,732 Finished 14 from 16 processes
2025-09-09 14:40:18,736 Finished 14 from 16 processes
2025-09-09 14:40:23,738 Finished 14 from 16 processes
2025-09-09 14:40:28,744 Finished 14 from 16 processes
2025-09-09 14:40:33,749 Finished 14 from 16 processes
2025-09-09 14:40:38,754 Finished 14 from 16 processes
2025-09-09 14:40:43,757 Finished 14 from 16 processes
2025-09-09 14:40:48,758 Finished 14 from 16 processes
2025-09-09 14:40:53,760 Finished 14 from 16 processes
2025-09-09 14:40:58,766 Finished 14 from 16 processes
2025-09-09 14:41:03,766 Finished 14 from 16 processes
2025-09-09 14:41:08,768 Finished 14 from 16 processes
2025-09-09 14:41:13,774 Finished 14 from 16 processes
2025-09-09 14:41:18,779 Finished 14 from 16 processes
2025-09-09 14:41:23,785 Finished 14 from 16 processes
2025-09-09 14:41:28,786 Finished 14 from 16 processes
2025-09-09 14:41:33,791 Finished 14 from 16 processes
2025-09-09 14:41:38,796 Finished 14 from 16 processes
2025-09-09 14:41:43,802 Finished 14 from 16 processes
2025-09-09 14:41:48,807 Finished 14 from 16 processes
2025-09-09 14:41:53,812 Finished 14 from 16 processes
2025-09-09 14:41:58,815 Finished 14 from 16 processes
2025-09-09 14:42:03,820 Finished 14 from 16 processes
2025-09-09 14:42:08,826 Finished 14 from 16 processes
2025-09-09 14:42:13,830 Finished 14 from 16 processes
2025-09-09 14:42:18,833 Finished 14 from 16 processes
2025-09-09 14:42:23,838 Finished 14 from 16 processes
2025-09-09 14:42:28,841 Finished 14 from 16 processes
2025-09-09 14:42:33,846 Finished 14 from 16 processes
2025-09-09 14:42:38,852 Finished 14 from 16 processes
2025-09-09 14:42:43,857 Finished 14 from 16 processes
2025-09-09 14:42:48,859 Finished 14 from 16 processes
2025-09-09 14:42:53,863 Finished 14 from 16 processes
2025-09-09 14:42:58,868 Finished 14 from 16 processes
2025-09-09 14:43:03,872 Finished 14 from 16 processes
2025-09-09 14:43:08,878 Finished 14 from 16 processes
2025-09-09 14:43:13,883 Finished 14 from 16 processes
2025-09-09 14:43:18,888 Finished 14 from 16 processes
2025-09-09 14:43:23,892 Finished 14 from 16 processes
2025-09-09 14:43:28,894 Finished 14 from 16 processes
2025-09-09 14:43:33,896 Finished 14 from 16 processes
2025-09-09 14:43:38,899 Finished 14 from 16 processes
2025-09-09 14:43:43,901 Finished 14 from 16 processes
2025-09-09 14:43:48,907 Finished 14 from 16 processes
2025-09-09 14:43:53,913 Finished 14 from 16 processes
2025-09-09 14:43:58,917 Finished 14 from 16 processes
2025-09-09 14:44:03,923 Finished 14 from 16 processes
2025-09-09 14:44:08,925 Finished 14 from 16 processes
2025-09-09 14:44:13,929 Finished 14 from 16 processes
2025-09-09 14:44:18,932 Finished 14 from 16 processes
2025-09-09 14:44:23,936 Finished 14 from 16 processes
2025-09-09 14:44:28,941 Finished 14 from 16 processes
2025-09-09 14:44:33,946 Finished 14 from 16 processes
2025-09-09 14:44:38,952 Finished 14 from 16 processes
2025-09-09 14:44:43,957 Finished 14 from 16 processes
2025-09-09 14:44:48,959 Finished 14 from 16 processes
2025-09-09 14:44:53,963 Finished 14 from 16 processes
2025-09-09 14:44:58,964 Finished 14 from 16 processes
2025-09-09 14:45:03,969 Finished 14 from 16 processes
2025-09-09 14:45:08,972 Finished 14 from 16 processes
2025-09-09 14:45:13,974 Finished 14 from 16 processes
2025-09-09 14:45:18,980 Finished 14 from 16 processes
2025-09-09 14:45:23,984 Finished 14 from 16 processes
2025-09-09 14:45:28,989 Finished 14 from 16 processes
2025-09-09 14:45:33,992 Finished 14 from 16 processes
2025-09-09 14:45:38,996 Finished 14 from 16 processes
2025-09-09 14:45:44,000 Finished 14 from 16 processes
2025-09-09 14:45:49,004 Finished 14 from 16 processes
2025-09-09 14:45:54,008 Finished 14 from 16 processes
2025-09-09 14:45:59,012 Finished 14 from 16 processes
2025-09-09 14:46:04,016 Finished 14 from 16 processes
2025-09-09 14:46:09,022 Finished 14 from 16 processes
2025-09-09 14:46:14,027 Finished 14 from 16 processes
2025-09-09 14:46:19,032 Finished 14 from 16 processes
2025-09-09 14:46:24,038 Finished 14 from 16 processes
2025-09-09 14:46:29,043 Finished 14 from 16 processes
2025-09-09 14:46:34,048 Finished 14 from 16 processes
2025-09-09 14:46:39,051 Finished 14 from 16 processes
2025-09-09 14:46:44,057 Finished 14 from 16 processes
2025-09-09 14:46:49,060 Finished 14 from 16 processes
2025-09-09 14:46:54,065 Finished 14 from 16 processes
2025-09-09 14:46:59,070 Finished 14 from 16 processes
2025-09-09 14:47:04,072 Finished 14 from 16 processes
2025-09-09 14:47:09,076 Finished 14 from 16 processes
2025-09-09 14:47:14,077 Finished 14 from 16 processes
2025-09-09 14:47:19,083 Finished 14 from 16 processes
2025-09-09 14:47:24,086 Finished 14 from 16 processes
2025-09-09 14:47:29,092 Finished 15 from 16 processes
2025-09-09 14:47:34,094 Finished 15 from 16 processes
2025-09-09 14:47:39,097 Finished 15 from 16 processes
2025-09-09 14:47:44,102 All processes finished
2025-09-09 14:47:44,102 Compressing stress logs
2025-09-09 14:47:44,129 Logs compressed
2025-09-09 14:47:44,129 Will terminate gdb (if any)
2025-09-09 14:47:44,130 Running command: kill -TERM $(pidof gdb)
2025-09-09 14:47:44,133 Running command: timeout 50s tail --pid=$(pidof gdb) -f /dev/null || kill -9 $(pidof gdb) ||:
2025-09-09 14:47:45,152 Running command: kill -CONT $(cat /var/run/clickhouse-server/clickhouse-server.pid) && clickhouse client -q 'SELECT 1 FORMAT Null'
2025-09-09 14:47:45,920 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-09-09 14:47:46,336 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-09-09 14:47:46,752 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-09-09 14:47:47,119 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-09-09 14:47:47,535 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-09-09 14:47:47,952 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-09-09 14:47:48,368 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-09-09 14:47:48,784 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-09-09 14:47:49,150 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-09-09 14:47:49,516 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-09-09 14:47:49,983 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-09-09 14:47:50,399 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-09-09 14:47:50,866 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.182709011 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-09-09 14:48:53,205 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.10505.altinitytest @ 0649e11fa9adfc8d68a79cfa246cd2fd4167f61a HEAD
Running 1 stateless tests (MainProcess).
00001_select_1: [ OK ]
1 tests passed. 0 tests skipped. 0.98 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. 12811 0.104 1.30 MiB 0.082 1 75 ['Trace'] 0.19 Checking existence of path: {}
2. 5454 0.044 836.26 KiB 0.051 2968 70 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {}
3. 4828 0.039 136.26 KiB 0.008 1 70 ['Debug'] 0.202 Processed in {} sec.
4. 4520 0.037 926.48 KiB 0.057 1 70 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {})
5. 3754 0.03 100.26 KiB 0.006 1 95 ['Trace'] 0.021 Query to stage {}{}
6. 3727 0.03 187.83 KiB 0.012 1 95 ['Trace'] 0.021 Query from stage {} to stage {}{}
7. 3036 0.025 213.57 KiB 0.013 1 477 ['Trace'] 0.877 Reserved {} on local disk {}, having unreserved {}.
8. 3022 0.025 134.97 KiB 0.008 1 3 ['Trace'] 1 Processing requests batch, size: {}, bytes: {}
9. 2987 0.024 335.45 KiB 0.021 2987 76 ['Debug'] 0.998 {} Authenticated with global context as user {}
10. 2987 0.024 137.89 KiB 0.008 2987 76 ['Debug'] 0.998 Authenticating user '{}' from {}
11. 2980 0.024 218.26 KiB 0.013 2980 70 ['Debug'] 1 Creating session context with user_id: {}
12. 2970 0.024 261.04 KiB 0.016 2970 76 ['Debug'] 0.998 {} Logout, user_id: {}
13. 2949 0.024 348.44 KiB 0.021 110 122 ['Trace'] 0.656 Renaming temporary part {} to {} with tid {}.
14. 2828 0.023 196.13 KiB 0.012 110 469 ['Trace'] 0.889 Trying to reserve {} using storage policy from min volume index {}
15. 2823 0.023 134.44 KiB 0.008 1 107 ['Trace'] 0.659 filled checksums {}
16. 2692 0.022 252.59 KiB 0.016 1 36 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part
17. 2377 0.019 214.40 KiB 0.013 1 70 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}.
18. 2377 0.019 79.40 KiB 0.005 1 70 ['Trace'] 1 TCP Request. Address: {}
19. 2359 0.019 62.20 KiB 0.004 1 70 ['Debug'] 1 Done processing connection.
20. 1860 0.015 106.45 KiB 0.007 16 36 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {}
21. 1858 0.015 65.81 KiB 0.004 16 36 ['Trace'] 1 Flushed system log up to offset {}
22. 1679 0.014 134.59 KiB 0.008 1 55 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec.
23. 1619 0.013 89.35 KiB 0.005 1 83 ['Debug'] 0.415 Peak memory usage{}: {}.
24. 1584 0.013 162.03 KiB 0.01 1 7 ['Trace'] 0.5 Adding file: {}, size: {}
25. 1292 0.01 117.69 KiB 0.007 1 89 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.)
26. 1270 0.01 75.65 KiB 0.005 205 92 ['Debug'] 0.272 There are {} detached tables. Start searching non used tables.
27. 1270 0.01 53.33 KiB 0.003 205 92 ['Debug'] 0.272 Found {} non used tables in detached tables.
28. 1169 0.009 141.62 KiB 0.009 1 6 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {}
29. 1166 0.009 26.19 KiB 0.002 1 89 ['Trace'] 0 Merging aggregated data
30. 1052 0.009 156.75 KiB 0.01 1 16 ['Debug'] 0 Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.)
31. 1052 0.009 51.94 KiB 0.003 1 16 ['Trace'] 0 Merging partially aggregated blocks (bucket = {}).
32. 998 0.008 134.03 KiB 0.008 1 2 ['Trace'] 1 Creating part at path {}
33. 983 0.008 2.66 MiB 0.167 2 16 ['Error'] 0.992 Setting {} should not be changed
34. 869 0.007 27.75 KiB 0.002 1 89 ['Trace'] 0 Aggregation method: {}
35. 686 0.006 39.70 KiB 0.002 2 11 ['Trace'] 0.981 Loading config file '{}'.
36. 685 0.006 122.68 KiB 0.008 2 34 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {}
37. 682 0.006 289.07 KiB 0.018 2 34 ['Trace'] 1 Request URI: {}
38. 621 0.005 12.74 KiB 0.001 2 34 ['Debug'] 0.127 Done processing query
39. 595 0.005 20.33 KiB 0.001 1 37 ['Debug'] 0 Selected MergeAlgorithm: {}
40. 595 0.005 49.19 KiB 0.003 1 37 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {}
41. 586 0.005 6.29 KiB 0 1 84 ['Trace'] 0 Aggregating
42. 579 0.005 30.89 KiB 0.002 34 366 ['Debug'] 0.941 Selected {} parts from {} to {}
43. 570 0.005 74.68 KiB 0.005 1 37 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec.
44. 570 0.005 37.06 KiB 0.002 35 37 ['Trace'] 0 Merged {} parts: [{}, {}] -> {}
45. 560 0.005 15.88 KiB 0.001 1 106 ['Debug'] 1 Stop worker in {}
46. 560 0.005 21.91 KiB 0.001 1 82 ['Debug'] 0.632 Spawn loader worker #{} in {}
47. 559 0.005 40.59 KiB 0.002 1 85 ['Debug'] 1 Execute load job '{}' in {}
48. 559 0.005 38.39 KiB 0.002 1 85 ['Debug'] 1 Finish load job '{}' with status {}
49. 559 0.005 42.23 KiB 0.003 1 30 ['Debug'] 0.145 Schedule load job '{}' into {}
50. 550 0.004 50.72 KiB 0.003 1 31 ['Debug'] 0.098 Prioritize load job '{}': {} -> {}
51. 470 0.004 51.20 KiB 0.003 59 51 ['Debug'] 0.998 Removing {} parts from filesystem (serially): Parts: [{}]
52. 466 0.004 35.95 KiB 0.002 1 46 ['Trace'] 0 Query span trace_id for opentelemetry log: {}
53. 446 0.004 42.53 KiB 0.003 30 34 ['Debug'] 0.991 Removing {} parts from memory: Parts: [{}]
54. 444 0.004 42.00 KiB 0.003 30 31 ['Trace'] 0.998 Found {} old parts to remove. Parts: [{}]
55. 431 0.004 13.00 KiB 0.001 1 10 ['Trace'] 0 {} -> {}
56. 427 0.003 14.17 KiB 0.001 1 84 ['Debug'] 0.527 Change current priority: {} -> {}
57. 420 0.003 3.69 KiB 0 2 30 ['Trace'] 0.019 No tables
58. 349 0.003 60.43 KiB 0.004 1 24 ['Trace'] 0 No query result found for query {}
59. 347 0.003 15.90 KiB 0.001 77 42 ['Debug'] 0 Key condition: {}
60. 344 0.003 27.41 KiB 0.002 1 72 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={}
61. 327 0.003 26.41 KiB 0.002 1 66 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={}
62. 314 0.003 27.68 KiB 0.002 7 128 ['Trace'] 0.844 Insert entry {} to queue with type {}
63. 296 0.002 22.96 KiB 0.001 68 39 ['Trace'] 0 Reading {} ranges in{}order from part {}, approx. {} rows starting from {}
64. 291 0.002 50.42 KiB 0.003 1 23 ['Trace'] 0 Stored query result of query {}
65. 286 0.002 11.45 KiB 0.001 13 52 ['Trace'] 0 Sending external_roles with query: [{}] ({})
66. 276 0.002 1.01 MiB 0.064 22 49 ['Error'] 0.268 Cannot schedule a task: {} (threads={}, jobs={})
67. 265 0.002 11.65 KiB 0.001 76 42 ['Trace'] 0 Filtering marks by primary and secondary keys
68. 264 0.002 21.32 KiB 0.001 1 3 ['Debug'] 1 Merging configuration file '{}'.
69. 260 0.002 8.08 KiB 0 20 9 ['Debug'] 0 Requested flush up to offset {}
70. 253 0.002 28.76 KiB 0.002 75 42 ['Debug'] 0 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges
71. 252 0.002 12.99 KiB 0.001 14 47 ['Trace'] 0 Connecting. Database: {}. User: {}{}{}
72. 241 0.002 9.20 KiB 0.001 4 32 ['Debug'] 0.32 Committing part {} to zookeeper
73. 233 0.002 12.06 KiB 0.001 67 38 ['Trace'] 0 Spreading mark ranges among streams (default reading)
74. 228 0.002 10.46 KiB 0.001 13 47 ['Trace'] 0 Connected to {} server version {}.{}.{}.
75. 226 0.002 36.55 KiB 0.002 13 44 ['Debug'] 0 Sent data for {} scalars, total {} rows in {} sec., {} rows/sec., {} ({}/sec.), compressed {} times to {} ({}/sec.)
76. 220 0.002 15.39 KiB 0.001 1 32 ['Debug'] 0.059 Wait load job '{}' in {}
77. 219 0.002 11.55 KiB 0.001 2 35 ['Trace'] 0.954 List of all grants: {}
78. 219 0.002 17.04 KiB 0.001 2 35 ['Trace'] 0.954 List of all grants including implicit: {}
79. 219 0.002 16.68 KiB 0.001 2 35 ['Trace'] 0.954 Settings: readonly = {}, allow_ddl = {}, allow_introspection_functions = {}
80. 217 0.002 8.05 KiB 0 4 32 ['Debug'] 0.355 Part {} committed to zookeeper
81. 216 0.002 17.63 KiB 0.001 207 30 ['Information'] 0.046 Metadata processed, database {} has {} tables and {} dictionaries in total.
82. 212 0.002 12.60 KiB 0.001 1 30 ['Information'] 0.028 Parsed metadata of {} tables in {} databases in {} sec
83. 208 0.002 16.10 KiB 0.001 4 25 ['Trace'] 0.986 Part {} is not stored on zero-copy replicated disk, blobs can be removed
84. 192 0.002 9.92 KiB 0.001 14 69 ['Trace'] 0.99 Loading {} part {} from disk {}
85. 192 0.002 11.23 KiB 0.001 14 69 ['Trace'] 0.99 Finished loading {} part {} on disk {}
86. 190 0.002 4.82 KiB 0 7 128 ['Debug'] 0.884 Pulled {} entries to queue.
87. 190 0.002 10.95 KiB 0.001 7 128 ['Debug'] 0.884 Pulling {} entries to queue: {} - {}
88. 184 0.001 7.91 KiB 0 1 3 ['Information'] 1 {} for session {} took {} ms
89. 180 0.001 22.48 KiB 0.001 1 3 ['Information','Debug'] 1 {} ({}:{})
90. 179 0.001 3.15 KiB 0 151 70 ['Debug'] 0.268 Loading data parts
91. 158 0.001 6.33 KiB 0 8 44 ['Debug'] 0.089 Will use old analyzer to prepare mutation
92. 146 0.001 3.28 KiB 0 143 48 ['Debug'] 0.151 There are no data parts
93. 141 0.001 4.54 KiB 0 1 3 ['Trace'] 1 Received heartbeat for session #{}
94. 135 0.001 5.54 KiB 0 6 6 ['Debug'] 0 Finished removing not used detached tables
95. 133 0.001 18.52 KiB 0.001 5 69 ['Trace'] 1 Checked {} partitions, found {} partitions with parts that may be merged: [{}] (max_total_size_to_merge={}, merge_with_ttl_allowed={})
96. 130 0.001 7.43 KiB 0 108 16 ['Trace'] 1 Executing log entry to mutate part {} to {}
97. 130 0.001 44.93 KiB 0.003 108 16 ['Trace'] 1 Mutating part {} with mutation commands from {} mutations ({}): {}
98. 121 0.001 7.67 KiB 0 27 29 ['Debug'] 0 MinMax index condition: {}
99. 113 0.001 20.45 KiB 0.001 1 32 ['Trace'] 0 {}Keys: {}, datatype: {}, kind: {}, strictness: {}, right header: {}
100. 113 0.001 9.67 KiB 0.001 6 95 ['Trace'] 1 Scheduling next merge selecting task after {}ms, current attempt status: {}
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. 6 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 0 ('/LoggerWrapper.h',43)
2. 3 Connectiontomysqlfailedtimes Connection to mysql failed 1 times ('',0)
3. 3 startingup starting up ('',0)
4. 3 newelectiontimeoutrange new election timeout range: 0 - 0 ('/LoggerWrapper.h',43)
5. 3 PRIORITYdecaytargetmine [PRIORITY] decay, target 1 -> 1, mine 1 ('/LoggerWrapper.h',43)
6. 3 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 1 ('/LoggerWrapper.h',43)
7. 3 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',43)
8. 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)
9. 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)
10. 3 newconfiglogidxprevlogidxcurconf new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0 ('/LoggerWrapper.h',43)
11. 3 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',43)
12. 3 numberofpendingcommitelements number of pending commit elements: 0 ('/LoggerWrapper.h',43)
13. 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)
14. 3 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',43)
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 RaftASIOlistenerinitiatedonunsec Raft ASIO listener initiated on :::9234, unsecured ('/LoggerWrapper.h',43)
17. 3 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',43)
18. 3 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1
my id: 1, voting_member
num peers: 0 ('/LoggerWrapper.h',43)
19. 3 INITRAFTSERVERcommitindextermele === INIT RAFT SERVER ===
commit index 0
term 0
election timer allowed
log store start 1, end 0
config log idx 0, prev log idx 0
-- ASYNC REPLICATION -- ('/LoggerWrapper.h',43)
20. 3 skippedconfiglatestconfig skipped config 1, latest config 1 ('/LoggerWrapper.h',43)
21. 3 Forkedachildprocesstowatch Forked a child process to watch ('',0)
22. 3 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',43)
23. 3 statemachinecommitindexprecommit state machine commit index 0, precommit index 0, last log index 0 ('/LoggerWrapper.h',43)
24. 3 StartingClickHousealtinitytestre Starting ClickHouse 24.8.14.10505.altinitytest (revision: 4294967295, git hash: 0649e11fa9adfc8d68a79cfa246cd2fd4167f61a, build id: 2FE502B9029F0B4BEECCCB4A769F01077B837413), PID 408 ('',0)
25. 3 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',43)
26. 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)
27. 2 CodeDBExceptionReceivedfromDBExc Code: 439. DB::Exception: Received from 127.0.0.1:9000. DB::Exception: Cannot schedule a task: fault injected (threads=749, jobs=730). Stack trace:
0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x ('/executeQuery.cpp',221)
28. 2 CodeDBExceptionEmptyquerySYNTAXE Code: 62. DB::Exception: Empty query. (SYNTAX_ERROR) (version 24.8.14.10505.altinitytest (altinity build)) (from [::ffff:127.0.0.1]:59184) (in query: ), Stack trace (when copying this message, always include the lines below):
0. ./contrib/llvm-project/lib ('/executeQuery.cpp',221)
29. 2 detectaconfigurationchangethatis detect a configuration change that is not committed yet at index 1 ('/LoggerWrapper.h',43)
30. 2 CodeDBExceptionSyntaxerrorfailed Code: 62. DB::Exception: Syntax error: failed at position 2 ('error'): error here
. Expected one of: Query, Query with output, EXPLAIN, EXPLAIN, SELECT query, possibly with UNION, list of union elements, SELECT query, subquery, possibly with UNION, SELECT ('/executeQuery.cpp',221)
Top messages not matching their format strings:
message_format_string count() any_message
1. 87 Forked a child process to watch
2. {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 8 /var/lib/clickhouse/store/62a/62ae27ce-097c-495c-8260-d735a0e49ee5/tmp_insert_201403_2_2_0/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 1 similar messages)
Top short messages:
c message_format_string substr(any(toValidUTF8(message)), 1, 120) min_length_without_exception_boilerplate
1. 17 {} Server has databases (for example `ordinary_test_13`) with Ordinary engine, which was deprecated. To convert this databa 34
2. 10 Cannot TRUNCATE dictionary Code: 62. DB::Exception: Cannot TRUNCATE dictionary. (SYNTAX_ERROR) (version 24.8.14.10505.altinitytest (altinity build) 27
3. 2 Found {} on {} Found changelog_1_100000.bin on LocalLogDisk 18
4. 1 Creating {}: {} Creating table test_3.data_native_copy: CREATE TABLE IF NOT EXISTS test_3.data_native_copy UUID '805de32c-259f-4c67-89f8 1056
Top messages by level:
(0.00796757852077001,'Setting {} should not be changed') Error
(0.00013779128672745695,'{}') Warning
(0.0017507598784194528,'Metadata processed, database {} has {} tables and {} dictionaries in total.') Information
(0.03913272543059777,'Processed in {} sec.') Debug
(0.10383789260385005,'Checking existence of path: {}') Trace
2025-09-09 14:49:03,710 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=2874
+ clickhouse stop --max-tries 90 --do-not-kill
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2874.
The process with pid = 2874 is running.
Sent terminate signal to process with pid 2874.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2874.
The process with pid = 2874 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2874.
The process with pid = 2874 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2874.
The process with pid = 2874 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2874.
The process with pid = 2874 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2874.
The process with pid = 2874 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2874.
The process with pid = 2874 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2874.
The process with pid = 2874 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2874.
The process with pid = 2874 does not exist.
Server stopped
+ return
+ mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ unset THREAD_FUZZER_CPU_TIME_PERIOD_US THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY THREAD_FUZZER_SLEEP_PROBABILITY THREAD_FUZZER_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX THREAD_POOL_FAULT_INJECTION
+ start_server
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 13 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=14
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 14 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=15
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 15 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=16
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 16 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
127.0.0.1 - - [09/Sep/2025:12:49:25 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 -
127.0.0.1 - - [09/Sep/2025:12:49:25 +0000] "PUT /devstoreaccount1/cont/fotflzzaubiqokdkskglnkjrkgjukczj HTTP/1.1" 201 -
127.0.0.1 - - [09/Sep/2025:12:49:25 +0000] "GET /devstoreaccount1/cont/fotflzzaubiqokdkskglnkjrkgjukczj HTTP/1.1" 206 4
127.0.0.1 - - [09/Sep/2025:12:49:25 +0000] "GET /devstoreaccount1/cont/fotflzzaubiqokdkskglnkjrkgjukczj HTTP/1.1" 206 2
127.0.0.1 - - [09/Sep/2025:12:49:25 +0000] "DELETE /devstoreaccount1/cont/fotflzzaubiqokdkskglnkjrkgjukczj HTTP/1.1" 202 -
+ 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'
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=7, jobs=7). (CANNOT_SCHEDULE_TASK)
(query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value))
++ retry=1
++ sleep 5
++ '[' 1 -ge 5 ']'
++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ false
++ return
+ IS_ASAN=0
+ [[ 0 = \1 ]]
++ kill -l SIGRTMIN
+ RTMIN=34
+ echo '
set follow-fork-mode parent
handle SIGHUP nostop noprint pass
handle SIGINT nostop noprint pass
handle SIGQUIT nostop noprint pass
handle SIGPIPE nostop noprint pass
handle SIGTERM nostop noprint pass
handle SIGUSR1 nostop noprint pass
handle SIGUSR2 nostop noprint pass
handle SIG34 nostop noprint pass
info signals
continue
backtrace full
info registers
p top' 1 KiB of the 'stack:
p/x *(uint64_t[128]*)$sp
maintenance info sections
thread apply all backtrace full
disassemble /s
up
disassemble /s
up
disassemble /s
p "done"
detach
quit
'
+ sleep 5
+ ts '%Y-%m-%d %H:%M:%S'
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ gdb -batch -command script.gdb -p 22984
+ 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=22984
+ 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 = 22984.
The process with pid = 22984 is running.
Sent terminate signal to process with pid 22984.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 22984.
The process with pid = 22984 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 22984.
The process with pid = 22984 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 22984.
The process with pid = 22984 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 22984.
The process with pid = 22984 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 22984.
The process with pid = 22984 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 22984.
The process with pid = 22984 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 22984.
The process with pid = 22984 is running.
Waiting for server to stop
Found pid = 22984 in the list of running processes.
The process with pid = 22984 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ '[' -f /var/log/clickhouse-server/clickhouse-server.log ']'
+ '[' -f /var/log/clickhouse-server/stderr.log ']'
+ mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.final.log
+ check_logs_for_critical_errors
+ sed -n '/WARNING:.*anitizer/,/^$/p' /var/log/clickhouse-server/stderr.log
+ rg -Fav -e 'ASan doesn'\''t fully support makecontext/swapcontext functions' -e DB::Exception /test_output/tmp
+ echo -e 'No sanitizer asserts\tOK\t\N\t'
+ rm -f /test_output/tmp
+ rg -Fa ' Application: Child process was terminated by signal 9' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No OOM messages in clickhouse-server.log\tOK\t\N\t'
+ rg -Fa 'Code: 49. DB::Exception: ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No logical errors\tOK\t\N\t'
+ '[' -s /test_output/logical_errors.txt ']'
+ rm /test_output/logical_errors.txt
+ rg --text 'Code: 499.*The specified key does not exist' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ grep -v a.myext
+ echo -e 'No lost s3 keys\tOK\t\N\t'
+ rg -Fa 'it is lost forever' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ grep SharedMergeTreePartCheckThread
+ echo -e 'No SharedMergeTree lost forever in clickhouse-server.log\tOK\t\N\t'
+ '[' -s /test_output/no_such_key_errors.txt ']'
+ rm /test_output/no_such_key_errors.txt
+ rg -Fa '########################################' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'Not crashed\tOK\t\N\t'
+ rg -Fa ' ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No fatal messages in clickhouse-server.log\tOK\t\N\t'
+ '[' -s /test_output/fatal_messages.txt ']'
+ rm /test_output/fatal_messages.txt
+ rg -Faz '########################################' /test_output/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 - - [09/Sep/2025:12:49:54 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 -
+ for table in query_log trace_log metric_log
+ clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.trace_log format TSVWithNamesAndTypes'
+ zstd --threads=0
Logging trace to /var/log/clickhouse-server/clickhouse-server.log
Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
127.0.0.1 - - [09/Sep/2025:12:50:03 +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 - - [09/Sep/2025:12:50:08 +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