+ 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.10544.altinitytest+tsan_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.10544.altinitytest+tsan_amd64.deb ...
Unpacking clickhouse-common-static (24.8.14.10544.altinitytest+tsan) ...
Setting up clickhouse-common-static (24.8.14.10544.altinitytest+tsan) ...
+ dpkg -i package_folder/clickhouse-common-static-dbg_24.8.14.10544.altinitytest+tsan_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.10544.altinitytest+tsan_amd64.deb ...
Unpacking clickhouse-common-static-dbg (24.8.14.10544.altinitytest+tsan) ...
Setting up clickhouse-common-static-dbg (24.8.14.10544.altinitytest+tsan) ...
+ dpkg -i package_folder/clickhouse-server_24.8.14.10544.altinitytest+tsan_amd64.deb
Selecting previously unselected package clickhouse-server.
(Reading database ... 48730 files and directories currently installed.)
Preparing to unpack .../clickhouse-server_24.8.14.10544.altinitytest+tsan_amd64.deb ...
Unpacking clickhouse-server (24.8.14.10544.altinitytest+tsan) ...
Setting up clickhouse-server (24.8.14.10544.altinitytest+tsan) ...
ClickHouse binary is already located at /usr/bin/clickhouse
Symlink /usr/bin/clickhouse-server already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-server to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-client to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-local to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-benchmark to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-obfuscator to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-git-import to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-compressor to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-format to /usr/bin/clickhouse.
Symlink /usr/bin/clickhouse-extract-from-config already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-extract-from-config to /usr/bin/clickhouse.
Symlink /usr/bin/clickhouse-keeper already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-keeper to /usr/bin/clickhouse.
Symlink /usr/bin/clickhouse-keeper-converter already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-keeper-converter to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-disks to /usr/bin/clickhouse.
Creating symlink /usr/bin/ch to /usr/bin/clickhouse.
Creating symlink /usr/bin/chl to /usr/bin/clickhouse.
Creating symlink /usr/bin/chc to /usr/bin/clickhouse.
Creating clickhouse group if it does not exist.
groupadd -r clickhouse
Creating clickhouse user if it does not exist.
useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse clickhouse
Will set ulimits for clickhouse user in /etc/security/limits.d/clickhouse.conf.
Creating config directory /etc/clickhouse-server/config.d that is used for tweaks of main server configuration.
Creating config directory /etc/clickhouse-server/users.d that is used for tweaks of users configuration.
Config file /etc/clickhouse-server/config.xml already exists, will keep it and extract path info from it.
/etc/clickhouse-server/config.xml has /var/lib/clickhouse/ as data path.
/etc/clickhouse-server/config.xml has /var/log/clickhouse-server/ as log path.
Users config file /etc/clickhouse-server/users.xml already exists, will keep it and extract users info from it.
Log directory /var/log/clickhouse-server/ already exists.
Creating data directory /var/lib/clickhouse/.
Creating pid directory /var/run/clickhouse-server.
chown -R clickhouse:clickhouse '/var/log/clickhouse-server/'
chown -R clickhouse:clickhouse '/var/run/clickhouse-server'
chown clickhouse:clickhouse '/var/lib/clickhouse/'
Password for the default user is an empty string. See /etc/clickhouse-server/users.xml and /etc/clickhouse-server/users.d to change it.
Setting capabilities for clickhouse binary. This is optional.
chown -R clickhouse:clickhouse '/etc/clickhouse-server'
ClickHouse has been successfully installed.
Start clickhouse-server with:
sudo clickhouse start
Start clickhouse-client with:
clickhouse-client
+ dpkg -i package_folder/clickhouse-client_24.8.14.10544.altinitytest+tsan_amd64.deb
Selecting previously unselected package clickhouse-client.
(Reading database ... 48747 files and directories currently installed.)
Preparing to unpack .../clickhouse-client_24.8.14.10544.altinitytest+tsan_amd64.deb ...
Unpacking clickhouse-client (24.8.14.10544.altinitytest+tsan) ...
Setting up clickhouse-client (24.8.14.10544.altinitytest+tsan) ...
+ export THREAD_FUZZER_CPU_TIME_PERIOD_US=1000
+ THREAD_FUZZER_CPU_TIME_PERIOD_US=1000
+ export THREAD_FUZZER_SLEEP_PROBABILITY=0.1
+ THREAD_FUZZER_SLEEP_PROBABILITY=0.1
+ export THREAD_FUZZER_SLEEP_TIME_US_MAX=100000
+ THREAD_FUZZER_SLEEP_TIME_US_MAX=100000
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000
+ export THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01
+ THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01
+ export THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01
+ THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01
+ export ZOOKEEPER_FAULT_INJECTION=1
+ ZOOKEEPER_FAULT_INJECTION=1
+ configure
+ export USE_DATABASE_ORDINARY=1
+ USE_DATABASE_ORDINARY=1
+ export EXPORT_S3_STORAGE_POLICIES=1
+ EXPORT_S3_STORAGE_POLICIES=1
+ /usr/share/clickhouse-test/config/install.sh
+ DEST_SERVER_PATH=/etc/clickhouse-server
+ DEST_CLIENT_PATH=/etc/clickhouse-client
+++ dirname /usr/share/clickhouse-test/config/install.sh
++ cd /usr/share/clickhouse-test/config
++ pwd -P
Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server
+ SRC_PATH=/usr/share/clickhouse-test/config
+ echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server'
+ mkdir -p /etc/clickhouse-server/config.d/
+ mkdir -p /etc/clickhouse-server/users.d/
+ mkdir -p /etc/clickhouse-client
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_catalog_drop_table_concurrency.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/grpc_protocol.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/block_number.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/serverwide_trace_collector.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/rocksdb.xml /etc/clickhouse-server/config.d/
+ '[' /etc/clickhouse-server = /etc/clickhouse-server ']'
+ ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/
+ ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ rm -f /etc/clickhouse-server/config.d/zookeeper.xml
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/
+ [[ -n '' ]]
+ rm -f /etc/clickhouse-server/config.d/cannot_allocate_thread_injection.xml
+ value=1
+ sed --follow-symlinks -i 's|[01]|1|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=43450368
+ sed --follow-symlinks -i 's|[[:digit:]]\+|43450368|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=7641088
+ sed --follow-symlinks -i 's|[[:digit:]]\+|7641088|' /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=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value check_not_exists keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value create_if_not_exists keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value use_compression zookeeper_fault_injection
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ randomize_config_boolean_value enable_block_number_column block_number
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/block_number.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml
+ randomize_config_boolean_value enable_block_offset_column block_number
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/block_number.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml
+ echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\'''
+ export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ sudo chown root: /var/lib/clickhouse
+ local total_mem
++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo
+ total_mem=32086444
+ total_mem=32856518656
+ max_server_memory_usage_to_ram_ratio=0.5
+ echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5'
+ cat
Setting max_server_memory_usage_to_ram_ratio to 0.5
+ local max_users_mem
+ max_users_mem=9856955596
+ echo 'Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G'
+ cat
Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G
+ cat
+ ./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')
+ local params
+ ./minio server --address :11111 ./minio_data
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
trying to connect to minio
+ [[ 0 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
Azurite Blob service is starting on 0.0.0.0:10000
Azurite Blob service successfully listens on http://0.0.0.0:10000
INFO: Formatting 1st pool, 1 set(s), 1 drives per set.
INFO: WARNING: Host local has more than 0 drives of set. A host failure will result in data becoming unavailable.
MinIO Object Storage Server
Copyright: 2015-2025 MinIO, Inc.
License: GNU AGPLv3 - https://www.gnu.org/licenses/agpl-3.0.html
Version: RELEASE.2024-08-03T04-33-23Z (go1.22.5 linux/amd64)
API: http://172.17.0.2:11111 http://127.0.0.1:11111
WebUI: http://172.17.0.2:38833 http://127.0.0.1:38833
Docs: https://min.io/docs/minio/linux/index.html
+ counter=1
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
AccessDeniedAccess Denied./18713CDED453B3837dc7eb22d3288ec80374614e9088e31d3668a6922ead55932dd2a8e56373820f
+ lsof -i :11111
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
minio 282 root 8u IPv4 81737 0t0 TCP localhost:11111 (LISTEN)
minio 282 root 9u IPv6 81738 0t0 TCP *:11111 (LISTEN)
minio 282 root 10u IPv6 81739 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.zip` -> `clickminio/test/03036_archive1.zip`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl` -> `clickminio/test/02366_data.jsonl`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow` -> `clickminio/test/02731.arrow`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive1.tar` -> `clickminio/test/03036_archive1.tar`
`/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_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_archive2.zip` -> `clickminio/test/03036_archive2.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/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/03036_json_archive.zip` -> `clickminio/test/03036_json_archive.zip`
`/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: 91.85 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'
127.0.0.1 - - [23/Oct/2025:21:44:29 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 404 -
127.0.0.1 - - [23/Oct/2025:21:44:29 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 -
127.0.0.1 - - [23/Oct/2025:21:44:30 +0000] "PUT /devstoreaccount1/cont/dcaunvxpmuijjfharvhdnwyrvawszihs HTTP/1.1" 201 -
127.0.0.1 - - [23/Oct/2025:21:44:30 +0000] "GET /devstoreaccount1/cont/dcaunvxpmuijjfharvhdnwyrvawszihs HTTP/1.1" 206 4
127.0.0.1 - - [23/Oct/2025:21:44:30 +0000] "GET /devstoreaccount1/cont/dcaunvxpmuijjfharvhdnwyrvawszihs HTTP/1.1" 206 2
127.0.0.1 - - [23/Oct/2025:21:44:30 +0000] "DELETE /devstoreaccount1/cont/dcaunvxpmuijjfharvhdnwyrvawszihs HTTP/1.1" 202 -
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 428
+ 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=428
+ 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 = 428.
The process with pid = 428 is running.
Sent terminate signal to process with pid 428.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 428.
The process with pid = 428 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 428.
The process with pid = 428 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 428.
The process with pid = 428 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 428.
The process with pid = 428 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 428.
The process with pid = 428 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 428.
The process with pid = 428 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 428.
The process with pid = 428 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.initial.log
Using cache policy: SLRU
+ cache_policy=
+ '[' 1 -eq 1 ']'
+ cache_policy=SLRU
+ echo 'Using cache policy: SLRU'
+ '[' SLRU = SLRU ']'
+ sudo cat /etc/clickhouse-server/config.d/storage_conf.xml
+ sed 's|LRU|SLRU|'
+ mv /etc/clickhouse-server/config.d/storage_conf.xml.tmp /etc/clickhouse-server/config.d/storage_conf.xml
+ sudo cat /etc/clickhouse-server/users.d/stress_tests_overrides.xml
cat: /etc/clickhouse-server/users.d/stress_tests_overrides.xml: No such file or directory
+ start_server
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
127.0.0.1 - - [23/Oct/2025:21:45:08 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 -
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
127.0.0.1 - - [23/Oct/2025:21:45:08 +0000] "PUT /devstoreaccount1/cont/megglrpjnschhimozgaqtsxgmbqnldom HTTP/1.1" 201 -
127.0.0.1 - - [23/Oct/2025:21:45:08 +0000] "GET /devstoreaccount1/cont/megglrpjnschhimozgaqtsxgmbqnldom HTTP/1.1" 206 4
127.0.0.1 - - [23/Oct/2025:21:45:08 +0000] "GET /devstoreaccount1/cont/megglrpjnschhimozgaqtsxgmbqnldom HTTP/1.1" 206 2
127.0.0.1 - - [23/Oct/2025:21:45:08 +0000] "DELETE /devstoreaccount1/cont/megglrpjnschhimozgaqtsxgmbqnldom HTTP/1.1" 202 -
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ [[ hxB =~ e ]]
++ set_e=false
++ set +e
++ local total_retries=5
++ shift
++ local retry=0
++ '[' 0 -ge 5 ']'
++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ 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 1299
+ 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: 159. DB::Exception: Received from localhost:9000. DB::Exception: Timeout exceeded: elapsed 60.131875071 seconds, maximum: 60: While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (TIMEOUT_EXCEEDED)
(query: INSERT INTO test.hits_s3 SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16)
+ clickhouse-client --query 'INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16'
Received exception from server (version 24.8.14):
Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (for user) exceeded: would use 9.18 GiB (attempt to allocate chunk of 1064960 bytes), maximum: 9.18 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.: (while reading column ShareURL): (while reading from part store/78e/78ebf6a1-d987-4579-b3ec-00c1a087b1f3/201403_1_1_2/ in table datasets.hits_v1 (78ebf6a1-d987-4579-b3ec-00c1a087b1f3) located on disk __tmp_internal_262634248876485800814430204900764312493 of type web, from mark 20 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.85 GiB (attempt to allocate chunk of 2621440 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=1299
+ 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 = 1299.
The process with pid = 1299 is running.
Sent terminate signal to process with pid 1299.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1299.
The process with pid = 1299 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1299.
The process with pid = 1299 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1299.
The process with pid = 1299 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1299.
The process with pid = 1299 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1299.
The process with pid = 1299 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1299.
The process with pid = 1299 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ export RANDOMIZE_OBJECT_KEY_TYPE=1
+ RANDOMIZE_OBJECT_KEY_TYPE=1
+ export ZOOKEEPER_FAULT_INJECTION=1
+ ZOOKEEPER_FAULT_INJECTION=1
+ export THREAD_POOL_FAULT_INJECTION=1
+ THREAD_POOL_FAULT_INJECTION=1
+ configure
+ export USE_DATABASE_ORDINARY=1
+ USE_DATABASE_ORDINARY=1
+ export EXPORT_S3_STORAGE_POLICIES=1
+ EXPORT_S3_STORAGE_POLICIES=1
+ /usr/share/clickhouse-test/config/install.sh
+ DEST_SERVER_PATH=/etc/clickhouse-server
+ DEST_CLIENT_PATH=/etc/clickhouse-client
+++ dirname /usr/share/clickhouse-test/config/install.sh
++ cd /usr/share/clickhouse-test/config
++ pwd -P
+ SRC_PATH=/usr/share/clickhouse-test/config
+ echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server'
+ 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 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/config.d/cannot_allocate_thread_injection.xml /etc/clickhouse-server/config.d/
+ value=1
+ sed --follow-symlinks -i 's|[01]|1|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=3340288
+ sed --follow-symlinks -i 's|[[:digit:]]\+|3340288|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=7368704
+ sed --follow-symlinks -i 's|[[:digit:]]\+|7368704|' /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=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value check_not_exists keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value create_if_not_exists keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value use_compression zookeeper_fault_injection
+ value=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=32086444
+ total_mem=32856518656
+ max_server_memory_usage_to_ram_ratio=0.5
+ echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5'
+ cat
Setting max_server_memory_usage_to_ram_ratio to 0.5
+ local max_users_mem
+ max_users_mem=9856955596
+ echo 'Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G'
+ cat
Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G
+ cat
+ [[ '' == \1 ]]
+ [[ '' == \1 ]]
+ sudo cat /etc/clickhouse-server/config.d/logger_trace.xml
+ sed 's|trace|test|'
+ mv /etc/clickhouse-server/config.d/logger_trace.xml.tmp /etc/clickhouse-server/config.d/logger_trace.xml
+ '[' SLRU = SLRU ']'
+ sudo cat /etc/clickhouse-server/config.d/storage_conf.xml
+ sed 's|LRU|SLRU|'
+ mv /etc/clickhouse-server/config.d/storage_conf.xml.tmp /etc/clickhouse-server/config.d/storage_conf.xml
++ date +%-d
+ '[' 1 -eq 1 ']'
+ sudo echo 'true'
+ start_server
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
127.0.0.1 - - [23/Oct/2025:21:50:35 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 -
127.0.0.1 - - [23/Oct/2025:21:50:35 +0000] "PUT /devstoreaccount1/cont/frfcfgdrnpjcdnzryeocqxlfqvxofcvo HTTP/1.1" 201 -
127.0.0.1 - - [23/Oct/2025:21:50:35 +0000] "GET /devstoreaccount1/cont/frfcfgdrnpjcdnzryeocqxlfqvxofcvo HTTP/1.1" 206 4
127.0.0.1 - - [23/Oct/2025:21:50:35 +0000] "GET /devstoreaccount1/cont/frfcfgdrnpjcdnzryeocqxlfqvxofcvo HTTP/1.1" 206 2
127.0.0.1 - - [23/Oct/2025:21:50:35 +0000] "DELETE /devstoreaccount1/cont/frfcfgdrnpjcdnzryeocqxlfqvxofcvo HTTP/1.1" 202 -
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ [[ hxB =~ e ]]
++ set_e=false
++ set +e
++ local total_retries=5
++ shift
++ local retry=0
++ '[' 0 -ge 5 ']'
++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
Received exception from server (version 24.8.14):
Code: 439. DB::Exception: Received from localhost:9000. DB::Exception: Cannot schedule a task: failed to start the thread (threads=2, jobs=2). (CANNOT_SCHEDULE_TASK)
(query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value))
++ retry=1
++ sleep 5
++ '[' 1 -ge 5 ']'
++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ false
++ return
+ IS_ASAN=0
+ [[ 0 = \1 ]]
++ kill -l SIGRTMIN
+ RTMIN=34
+ echo '
set follow-fork-mode parent
handle SIGHUP nostop noprint pass
handle SIGINT nostop noprint pass
handle SIGQUIT nostop noprint pass
handle SIGPIPE nostop noprint pass
handle SIGTERM nostop noprint pass
handle SIGUSR1 nostop noprint pass
handle SIGUSR2 nostop noprint pass
handle SIG34 nostop noprint pass
info signals
continue
backtrace full
info registers
p top' 1 KiB of the 'stack:
p/x *(uint64_t[128]*)$sp
maintenance info sections
thread apply all backtrace full
disassemble /s
up
disassemble /s
up
disassemble /s
p "done"
detach
quit
'
+ sleep 5
+ ts '%Y-%m-%d %H:%M:%S'
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ gdb -batch -command script.gdb -p 2683
+ run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
+ [[ hxB =~ e ]]
+ set_e=false
+ set +e
+ local total_retries=60
+ shift
+ local retry=0
+ '[' 0 -ge 60 ']'
+ clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
Connected to clickhouse-server after attaching gdb
+ false
+ return
+ stress --hung-check --drop-databases --output-folder test_output --skip-func-tests '' --global-time-limit 1200
2025-10-23 23:50:56,590 Run func tests '/usr/bin/clickhouse-test --client-option ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-10-23 23:50:57,094 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_1 --client-option join_use_nulls=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-10-23 23:50:57,596 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 optimize_trivial_approximate_count_query=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-10-23 23:50:58,097 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_3 --client-option join_algorithm='partial_merge' use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 '
2025-10-23 23:50:58,599 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-10-23 23:50:59,101 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_5', 's1', 'r1')" --database=test_5 --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='full_sorting_merge' group_by_use_nulls=1 http_make_head_request=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-10-23 23:50:59,602 Run func tests '/usr/bin/clickhouse-test --order=random --client-option memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 optimize_trivial_approximate_count_query=1 http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-10-23 23:51:00,104 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 --global_time_limit=1200 '
2025-10-23 23:51:00,605 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_8', 's1', 'r1')" --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-10-23 23:51:01,107 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-10-23 23:51:01,608 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-10-23 23:51:02,110 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_11', 's1', 'r1')" --database=test_11 --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 ignore_drop_queries_probability=0.5 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 '
2025-10-23 23:51:02,611 Run func tests '/usr/bin/clickhouse-test --order=random --client-option implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-10-23 23:51:03,113 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-10-23 23:51:03,614 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 optimize_trivial_approximate_count_query=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2025-10-23 23:51:04,116 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-10-23 23:51:04,617 Will wait functests to finish
2025-10-23 23:51:04,618 Finished 9 from 16 processes
2025-10-23 23:51:09,623 Finished 9 from 16 processes
2025-10-23 23:51:14,626 Finished 9 from 16 processes
2025-10-23 23:51:19,630 Finished 9 from 16 processes
2025-10-23 23:51:24,631 Finished 9 from 16 processes
2025-10-23 23:51:29,634 Finished 9 from 16 processes
2025-10-23 23:51:34,638 Finished 9 from 16 processes
2025-10-23 23:51:39,642 Finished 9 from 16 processes
2025-10-23 23:51:44,647 Finished 10 from 16 processes
2025-10-23 23:51:49,650 Finished 10 from 16 processes
2025-10-23 23:51:54,651 Finished 10 from 16 processes
2025-10-23 23:51:59,654 Finished 11 from 16 processes
2025-10-23 23:52:04,658 Finished 11 from 16 processes
2025-10-23 23:52:09,664 Finished 11 from 16 processes
2025-10-23 23:52:14,666 Finished 11 from 16 processes
2025-10-23 23:52:19,670 Finished 11 from 16 processes
2025-10-23 23:52:24,676 Finished 11 from 16 processes
2025-10-23 23:52:29,679 Finished 11 from 16 processes
2025-10-23 23:52:34,684 Finished 11 from 16 processes
2025-10-23 23:52:39,686 Finished 11 from 16 processes
2025-10-23 23:52:44,692 Finished 11 from 16 processes
2025-10-23 23:52:49,694 Finished 11 from 16 processes
2025-10-23 23:52:54,700 Finished 11 from 16 processes
2025-10-23 23:52:59,705 Finished 11 from 16 processes
2025-10-23 23:53:04,710 Finished 11 from 16 processes
2025-10-23 23:53:09,716 Finished 11 from 16 processes
2025-10-23 23:53:14,718 Finished 11 from 16 processes
2025-10-23 23:53:19,720 Finished 11 from 16 processes
2025-10-23 23:53:24,722 Finished 11 from 16 processes
2025-10-23 23:53:29,728 Finished 11 from 16 processes
2025-10-23 23:53:34,730 Finished 11 from 16 processes
2025-10-23 23:53:39,734 Finished 11 from 16 processes
2025-10-23 23:53:44,738 Finished 11 from 16 processes
2025-10-23 23:53:49,742 Finished 11 from 16 processes
2025-10-23 23:53:54,747 Finished 11 from 16 processes
2025-10-23 23:53:59,750 Finished 11 from 16 processes
2025-10-23 23:54:04,755 Finished 11 from 16 processes
2025-10-23 23:54:09,758 Finished 11 from 16 processes
2025-10-23 23:54:14,762 Finished 11 from 16 processes
2025-10-23 23:54:19,766 Finished 11 from 16 processes
2025-10-23 23:54:24,770 Finished 11 from 16 processes
2025-10-23 23:54:29,776 Finished 11 from 16 processes
2025-10-23 23:54:34,781 Finished 11 from 16 processes
2025-10-23 23:54:39,782 Finished 11 from 16 processes
2025-10-23 23:54:44,785 Finished 11 from 16 processes
2025-10-23 23:54:49,790 Finished 11 from 16 processes
2025-10-23 23:54:54,796 Finished 11 from 16 processes
2025-10-23 23:54:59,800 Finished 11 from 16 processes
2025-10-23 23:55:04,802 Finished 11 from 16 processes
2025-10-23 23:55:09,803 Finished 11 from 16 processes
2025-10-23 23:55:14,806 Finished 11 from 16 processes
2025-10-23 23:55:19,812 Finished 11 from 16 processes
2025-10-23 23:55:24,817 Finished 11 from 16 processes
2025-10-23 23:55:29,822 Finished 11 from 16 processes
2025-10-23 23:55:34,826 Finished 11 from 16 processes
2025-10-23 23:55:39,832 Finished 11 from 16 processes
2025-10-23 23:55:44,834 Finished 11 from 16 processes
2025-10-23 23:55:49,838 Finished 11 from 16 processes
2025-10-23 23:55:54,842 Finished 11 from 16 processes
2025-10-23 23:55:59,846 Finished 11 from 16 processes
2025-10-23 23:56:04,848 Finished 11 from 16 processes
2025-10-23 23:56:09,850 Finished 11 from 16 processes
2025-10-23 23:56:14,854 Finished 11 from 16 processes
2025-10-23 23:56:19,858 Finished 11 from 16 processes
2025-10-23 23:56:24,862 Finished 11 from 16 processes
2025-10-23 23:56:29,868 Finished 11 from 16 processes
2025-10-23 23:56:34,873 Finished 11 from 16 processes
2025-10-23 23:56:39,878 Finished 11 from 16 processes
2025-10-23 23:56:44,882 Finished 11 from 16 processes
2025-10-23 23:56:49,886 Finished 11 from 16 processes
2025-10-23 23:56:54,887 Finished 11 from 16 processes
2025-10-23 23:56:59,890 Finished 11 from 16 processes
2025-10-23 23:57:04,894 Finished 11 from 16 processes
2025-10-23 23:57:09,898 Finished 11 from 16 processes
2025-10-23 23:57:14,902 Finished 11 from 16 processes
2025-10-23 23:57:19,906 Finished 11 from 16 processes
2025-10-23 23:57:24,910 Finished 11 from 16 processes
2025-10-23 23:57:29,914 Finished 11 from 16 processes
2025-10-23 23:57:34,920 Finished 11 from 16 processes
2025-10-23 23:57:39,922 Finished 11 from 16 processes
2025-10-23 23:57:44,926 Finished 11 from 16 processes
2025-10-23 23:57:49,932 Finished 11 from 16 processes
2025-10-23 23:57:54,934 Finished 11 from 16 processes
2025-10-23 23:57:59,938 Finished 11 from 16 processes
2025-10-23 23:58:04,944 Finished 11 from 16 processes
2025-10-23 23:58:09,946 Finished 11 from 16 processes
2025-10-23 23:58:14,948 Finished 11 from 16 processes
2025-10-23 23:58:19,950 Finished 11 from 16 processes
2025-10-23 23:58:24,956 Finished 11 from 16 processes
2025-10-23 23:58:29,961 Finished 11 from 16 processes
2025-10-23 23:58:34,967 Finished 11 from 16 processes
2025-10-23 23:58:39,970 Finished 11 from 16 processes
2025-10-23 23:58:44,974 Finished 11 from 16 processes
2025-10-23 23:58:49,979 Finished 11 from 16 processes
2025-10-23 23:58:54,982 Finished 11 from 16 processes
2025-10-23 23:58:59,983 Finished 11 from 16 processes
2025-10-23 23:59:04,986 Finished 11 from 16 processes
2025-10-23 23:59:09,992 Finished 11 from 16 processes
2025-10-23 23:59:14,994 Finished 11 from 16 processes
2025-10-23 23:59:20,000 Finished 11 from 16 processes
2025-10-23 23:59:25,005 Finished 11 from 16 processes
2025-10-23 23:59:30,010 Finished 11 from 16 processes
2025-10-23 23:59:35,014 Finished 11 from 16 processes
2025-10-23 23:59:40,018 Finished 11 from 16 processes
2025-10-23 23:59:45,022 Finished 11 from 16 processes
2025-10-23 23:59:50,026 Finished 11 from 16 processes
2025-10-23 23:59:55,030 Finished 11 from 16 processes
2025-10-24 00:00:00,034 Finished 11 from 16 processes
2025-10-24 00:00:05,038 Finished 11 from 16 processes
2025-10-24 00:00:10,042 Finished 11 from 16 processes
2025-10-24 00:00:15,047 Finished 11 from 16 processes
2025-10-24 00:00:20,050 Finished 11 from 16 processes
2025-10-24 00:00:25,054 Finished 11 from 16 processes
2025-10-24 00:00:30,060 Finished 11 from 16 processes
2025-10-24 00:00:35,062 Finished 11 from 16 processes
2025-10-24 00:00:40,066 Finished 11 from 16 processes
2025-10-24 00:00:45,070 Finished 11 from 16 processes
2025-10-24 00:00:50,074 Finished 11 from 16 processes
2025-10-24 00:00:55,078 Finished 11 from 16 processes
2025-10-24 00:01:00,082 Finished 11 from 16 processes
2025-10-24 00:01:05,086 Finished 11 from 16 processes
2025-10-24 00:01:10,087 Finished 11 from 16 processes
2025-10-24 00:01:15,091 Finished 11 from 16 processes
2025-10-24 00:01:20,093 Finished 11 from 16 processes
2025-10-24 00:01:25,094 Finished 11 from 16 processes
2025-10-24 00:01:30,098 Finished 11 from 16 processes
2025-10-24 00:01:35,102 Finished 11 from 16 processes
2025-10-24 00:01:40,108 Finished 11 from 16 processes
2025-10-24 00:01:45,113 Finished 11 from 16 processes
2025-10-24 00:01:50,116 Finished 11 from 16 processes
2025-10-24 00:01:55,121 Finished 11 from 16 processes
2025-10-24 00:02:00,126 Finished 11 from 16 processes
2025-10-24 00:02:05,130 Finished 11 from 16 processes
2025-10-24 00:02:10,134 Finished 11 from 16 processes
2025-10-24 00:02:15,139 Finished 11 from 16 processes
2025-10-24 00:02:20,142 Finished 11 from 16 processes
2025-10-24 00:02:25,146 Finished 11 from 16 processes
2025-10-24 00:02:30,150 Finished 11 from 16 processes
2025-10-24 00:02:35,154 Finished 11 from 16 processes
2025-10-24 00:02:40,155 Finished 11 from 16 processes
2025-10-24 00:02:45,161 Finished 11 from 16 processes
2025-10-24 00:02:50,162 Finished 11 from 16 processes
2025-10-24 00:02:55,166 Finished 11 from 16 processes
2025-10-24 00:03:00,170 Finished 11 from 16 processes
2025-10-24 00:03:05,174 Finished 11 from 16 processes
2025-10-24 00:03:10,178 Finished 11 from 16 processes
2025-10-24 00:03:15,182 Finished 11 from 16 processes
2025-10-24 00:03:20,186 Finished 11 from 16 processes
2025-10-24 00:03:25,190 Finished 11 from 16 processes
2025-10-24 00:03:30,196 Finished 11 from 16 processes
2025-10-24 00:03:35,200 Finished 11 from 16 processes
2025-10-24 00:03:40,202 Finished 11 from 16 processes
2025-10-24 00:03:45,208 Finished 11 from 16 processes
2025-10-24 00:03:50,209 Finished 11 from 16 processes
2025-10-24 00:03:55,214 Finished 11 from 16 processes
2025-10-24 00:04:00,220 Finished 11 from 16 processes
2025-10-24 00:04:05,225 Finished 11 from 16 processes
2025-10-24 00:04:10,227 Finished 11 from 16 processes
2025-10-24 00:04:15,230 Finished 11 from 16 processes
2025-10-24 00:04:20,234 Finished 11 from 16 processes
2025-10-24 00:04:25,238 Finished 11 from 16 processes
2025-10-24 00:04:30,243 Finished 11 from 16 processes
2025-10-24 00:04:35,246 Finished 11 from 16 processes
2025-10-24 00:04:40,250 Finished 11 from 16 processes
2025-10-24 00:04:45,256 Finished 11 from 16 processes
2025-10-24 00:04:50,261 Finished 11 from 16 processes
2025-10-24 00:04:55,266 Finished 11 from 16 processes
2025-10-24 00:05:00,269 Finished 11 from 16 processes
2025-10-24 00:05:05,274 Finished 11 from 16 processes
2025-10-24 00:05:10,278 Finished 11 from 16 processes
2025-10-24 00:05:15,282 Finished 11 from 16 processes
2025-10-24 00:05:20,288 Finished 11 from 16 processes
2025-10-24 00:05:25,290 Finished 11 from 16 processes
2025-10-24 00:05:30,296 Finished 11 from 16 processes
2025-10-24 00:05:35,298 Finished 11 from 16 processes
2025-10-24 00:05:40,302 Finished 11 from 16 processes
2025-10-24 00:05:45,306 Finished 11 from 16 processes
2025-10-24 00:05:50,310 Finished 11 from 16 processes
2025-10-24 00:05:55,315 Finished 11 from 16 processes
2025-10-24 00:06:00,318 Finished 11 from 16 processes
2025-10-24 00:06:05,322 Finished 11 from 16 processes
2025-10-24 00:06:10,326 Finished 11 from 16 processes
2025-10-24 00:06:15,330 Finished 11 from 16 processes
2025-10-24 00:06:20,334 Finished 11 from 16 processes
2025-10-24 00:06:25,340 Finished 11 from 16 processes
2025-10-24 00:06:30,342 Finished 11 from 16 processes
2025-10-24 00:06:35,346 Finished 11 from 16 processes
2025-10-24 00:06:40,352 Finished 11 from 16 processes
2025-10-24 00:06:45,357 Finished 11 from 16 processes
2025-10-24 00:06:50,358 Finished 11 from 16 processes
2025-10-24 00:06:55,363 Finished 12 from 16 processes
2025-10-24 00:07:00,367 Finished 12 from 16 processes
2025-10-24 00:07:05,370 Finished 12 from 16 processes
2025-10-24 00:07:10,374 Finished 12 from 16 processes
2025-10-24 00:07:15,379 Finished 12 from 16 processes
2025-10-24 00:07:20,382 Finished 12 from 16 processes
2025-10-24 00:07:25,384 Finished 12 from 16 processes
2025-10-24 00:07:30,386 Finished 12 from 16 processes
2025-10-24 00:07:35,392 Finished 12 from 16 processes
2025-10-24 00:07:40,397 Finished 12 from 16 processes
2025-10-24 00:07:45,399 Finished 12 from 16 processes
2025-10-24 00:07:50,402 Finished 12 from 16 processes
2025-10-24 00:07:55,406 Finished 12 from 16 processes
2025-10-24 00:08:00,410 Finished 12 from 16 processes
2025-10-24 00:08:05,414 Finished 12 from 16 processes
2025-10-24 00:08:10,416 Finished 12 from 16 processes
2025-10-24 00:08:15,418 Finished 12 from 16 processes
2025-10-24 00:08:20,422 Finished 12 from 16 processes
2025-10-24 00:08:25,425 Finished 12 from 16 processes
2025-10-24 00:08:30,430 Finished 12 from 16 processes
2025-10-24 00:08:35,436 Finished 12 from 16 processes
2025-10-24 00:08:40,438 Finished 12 from 16 processes
2025-10-24 00:08:45,442 Finished 12 from 16 processes
2025-10-24 00:08:50,446 Finished 12 from 16 processes
2025-10-24 00:08:55,450 Finished 12 from 16 processes
2025-10-24 00:09:00,454 Finished 12 from 16 processes
2025-10-24 00:09:05,460 Finished 12 from 16 processes
2025-10-24 00:09:10,465 Finished 12 from 16 processes
2025-10-24 00:09:15,470 Finished 12 from 16 processes
2025-10-24 00:09:20,474 Finished 12 from 16 processes
2025-10-24 00:09:25,478 Finished 12 from 16 processes
2025-10-24 00:09:30,484 Finished 12 from 16 processes
2025-10-24 00:09:35,486 Finished 12 from 16 processes
2025-10-24 00:09:40,490 Finished 12 from 16 processes
2025-10-24 00:09:45,496 Finished 12 from 16 processes
2025-10-24 00:09:50,498 Finished 12 from 16 processes
2025-10-24 00:09:55,502 Finished 12 from 16 processes
2025-10-24 00:10:00,507 Finished 12 from 16 processes
2025-10-24 00:10:05,513 Finished 12 from 16 processes
2025-10-24 00:10:10,518 Finished 12 from 16 processes
2025-10-24 00:10:15,523 Finished 12 from 16 processes
2025-10-24 00:10:20,529 Finished 12 from 16 processes
2025-10-24 00:10:25,530 Finished 12 from 16 processes
2025-10-24 00:10:30,534 Finished 12 from 16 processes
2025-10-24 00:10:35,540 Finished 12 from 16 processes
2025-10-24 00:10:40,545 Finished 12 from 16 processes
2025-10-24 00:10:45,546 Finished 12 from 16 processes
2025-10-24 00:10:50,550 Finished 12 from 16 processes
2025-10-24 00:10:55,553 Finished 12 from 16 processes
2025-10-24 00:11:00,558 Finished 12 from 16 processes
2025-10-24 00:11:05,563 Finished 12 from 16 processes
2025-10-24 00:11:10,567 Finished 13 from 16 processes
2025-10-24 00:11:15,568 Finished 13 from 16 processes
2025-10-24 00:11:20,570 Finished 13 from 16 processes
2025-10-24 00:11:25,574 Finished 13 from 16 processes
2025-10-24 00:11:30,580 Finished 14 from 16 processes
2025-10-24 00:11:35,585 Finished 14 from 16 processes
2025-10-24 00:11:40,590 Finished 14 from 16 processes
2025-10-24 00:11:45,594 Finished 14 from 16 processes
2025-10-24 00:11:50,600 Finished 14 from 16 processes
2025-10-24 00:11:55,605 Finished 14 from 16 processes
2025-10-24 00:12:00,610 Finished 14 from 16 processes
2025-10-24 00:12:05,616 Finished 14 from 16 processes
2025-10-24 00:12:10,621 Finished 14 from 16 processes
2025-10-24 00:12:15,626 Finished 14 from 16 processes
2025-10-24 00:12:20,632 Finished 14 from 16 processes
2025-10-24 00:12:25,636 Finished 14 from 16 processes
2025-10-24 00:12:30,636 Finished 14 from 16 processes
2025-10-24 00:12:35,638 Finished 14 from 16 processes
2025-10-24 00:12:40,642 Finished 14 from 16 processes
2025-10-24 00:12:45,646 Finished 14 from 16 processes
2025-10-24 00:12:50,652 Finished 14 from 16 processes
2025-10-24 00:12:55,656 Finished 15 from 16 processes
2025-10-24 00:13:00,660 Finished 15 from 16 processes
2025-10-24 00:13:05,661 Finished 15 from 16 processes
2025-10-24 00:13:10,662 Finished 15 from 16 processes
2025-10-24 00:13:15,668 Finished 15 from 16 processes
2025-10-24 00:13:20,673 Finished 15 from 16 processes
2025-10-24 00:13:25,678 Finished 15 from 16 processes
2025-10-24 00:13:30,684 Finished 15 from 16 processes
2025-10-24 00:13:35,686 Finished 15 from 16 processes
2025-10-24 00:13:40,690 Finished 15 from 16 processes
2025-10-24 00:13:45,694 Finished 15 from 16 processes
2025-10-24 00:13:50,697 Finished 15 from 16 processes
2025-10-24 00:13:55,703 Finished 15 from 16 processes
2025-10-24 00:14:00,708 Finished 15 from 16 processes
2025-10-24 00:14:05,710 Finished 15 from 16 processes
2025-10-24 00:14:10,716 Finished 15 from 16 processes
2025-10-24 00:14:15,721 Finished 15 from 16 processes
2025-10-24 00:14:20,727 All processes finished
2025-10-24 00:14:20,727 Compressing stress logs
2025-10-24 00:14:20,750 Logs compressed
2025-10-24 00:14:20,750 Will terminate gdb (if any)
2025-10-24 00:14:20,750 Running command: kill -TERM $(pidof gdb)
2025-10-24 00:14:20,754 Running command: timeout 50s tail --pid=$(pidof gdb) -f /dev/null || kill -9 $(pidof gdb) ||:
2025-10-24 00:14:21,772 Running command: kill -CONT $(cat /var/run/clickhouse-server/clickhouse-server.pid) && clickhouse client -q 'SELECT 1 FORMAT Null'
2025-10-24 00:14:22,087 Running command: clickhouse client -q "SYSTEM STOP THREAD FUZZER" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000
2025-10-24 00:14:22,352 Running command: clickhouse client -q "SYSTEM START MERGES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000
2025-10-24 00:14:22,617 Running command: clickhouse client -q "SYSTEM START DISTRIBUTED SENDS" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000
2025-10-24 00:14:22,883 Running command: clickhouse client -q "SYSTEM START TTL MERGES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000
2025-10-24 00:14:23,148 Running command: clickhouse client -q "SYSTEM START MOVES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000
2025-10-24 00:14:23,413 Running command: clickhouse client -q "SYSTEM START FETCHES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000
2025-10-24 00:14:23,679 Running command: clickhouse client -q "SYSTEM START REPLICATED SENDS" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000
2025-10-24 00:14:23,944 Running command: clickhouse client -q "SYSTEM START REPLICATION QUEUES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000
2025-10-24 00:14:24,210 Running command: clickhouse client -q "SYSTEM DROP MARK CACHE" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000
2025-10-24 00:14:24,475 Running command: clickhouse client -q "KILL QUERY WHERE upper(query) LIKE 'WATCH %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000
2025-10-24 00:14:24,790 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'insert into tableB select %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000
2025-10-24 00:14:25,055 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'SELECT URL, uniq(SearchPhrase) AS u FROM test.hits GROUP BY URL ORDER BY u %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000
2025-10-24 00:14:25,321 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.057923897 seconds, maximum: 60. (TIMEOUT_EXCEEDED)
(query: SELECT sleepEachRow((
SELECT maxOrDefault(300 - elapsed) + 1
FROM system.processes
WHERE query NOT LIKE '%FROM system.processes%' AND elapsed < 300
) / 300)
FROM numbers(300)
FORMAT Null
SETTINGS function_sleep_max_microseconds_per_block = 0
)
2025-10-24 00:15:26,913 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.10544.altinitytest @ 9ff92307932be886d77861423556aba6ef8de5b8 HEAD
Running 1 stateless tests (MainProcess).
00001_select_1: [ OK ]
1 tests passed. 0 tests skipped. 0.63 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. 55453 0.216 2.37 MiB 0.092 1 70 ['Trace'] 1 is disk {} eligible for search: {}
2. 12819 0.05 1.30 MiB 0.051 1 77 ['Trace'] 0.19 Checking existence of path: {}
3. 11289 0.044 292.88 KiB 0.011 1 647 ['Trace'] 0.23 Query to stage {}{}
4. 11220 0.044 554.57 KiB 0.021 1 647 ['Trace'] 0.231 Query from stage {} to stage {}{}
5. 8783 0.034 1.32 MiB 0.051 4991 95 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {}
6. 8776 0.034 1.47 MiB 0.057 1 96 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {})
7. 6735 0.026 190.03 KiB 0.007 1 93 ['Debug'] 0.002 Processed in {} sec.
8. 5146 0.02 253.37 KiB 0.01 5146 106 ['Debug'] 0.997 Authenticating user '{}' from {}
9. 5131 0.02 576.24 KiB 0.022 5131 106 ['Debug'] 0.997 {} Authenticated with global context as user {}
10. 5119 0.02 449.91 KiB 0.017 5119 102 ['Debug'] 0.997 {} Logout, user_id: {}
11. 5115 0.02 374.63 KiB 0.014 5115 95 ['Debug'] 1 Creating session context with user_id: {}
12. 4166 0.016 174.94 KiB 0.007 184 637 ['Debug'] 0.215 Found {} non used tables in detached tables.
13. 4166 0.016 248.17 KiB 0.009 184 637 ['Debug'] 0.215 There are {} detached tables. Start searching non used tables.
14. 4052 0.016 284.96 KiB 0.011 1 671 ['Trace'] 0.752 Reserved {} on local disk {}, having unreserved {}.
15. 3976 0.015 275.73 KiB 0.011 802 663 ['Trace'] 0.753 Trying to reserve {} using storage policy from min volume index {}
16. 3952 0.015 466.50 KiB 0.018 799 537 ['Trace'] 0.6 Renaming temporary part {} to {} with tid {}.
17. 3946 0.015 186.58 KiB 0.007 1 540 ['Trace'] 0.598 filled checksums {}
18. 3412 0.013 273.01 KiB 0.01 1 66 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec.
19. 3177 0.012 147.65 KiB 0.006 1 481 ['Debug'] 0.193 Peak memory usage{}: {}.
20. 3176 0.012 289.96 KiB 0.011 1 93 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}.
21. 3176 0.012 105.08 KiB 0.004 1 93 ['Trace'] 1 TCP Request. Address: {}
22. 3112 0.012 293.24 KiB 0.011 1 37 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part
23. 3025 0.012 79.76 KiB 0.003 1 89 ['Debug'] 1 Done processing connection.
24. 2362 0.009 134.87 KiB 0.005 15 35 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {}
25. 2361 0.009 83.55 KiB 0.003 15 35 ['Trace'] 1 Flushed system log up to offset {}
26. 2199 0.009 158.91 KiB 0.006 1 504 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {} tables
27. 2199 0.009 253.40 KiB 0.01 1 535 ['Debug'] 0 Done waiting for the table {} to be dropped. The outcome: {}
28. 2199 0.009 163.21 KiB 0.006 1 535 ['Debug'] 0 Waiting for table {} to be finally dropped
29. 2163 0.008 587.66 KiB 0.022 1 70 ['Information'] 1 Removing metadata {} of dropped table {}
30. 2003 0.008 48.90 KiB 0.002 1 503 ['Debug'] 1 Refreshing view {}
31. 1956 0.008 791.94 KiB 0.03 2 58 ['Trace'] 1 Request URI: {}
32. 1956 0.008 406.02 KiB 0.015 2 58 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {}
33. 1881 0.007 38.58 KiB 0.001 2 57 ['Debug'] 0.005 Done processing query
34. 1723 0.007 209.00 KiB 0.008 1 6 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {}
35. 1584 0.006 162.03 KiB 0.006 1 7 ['Trace'] 0.5 Adding file: {}, size: {}
36. 1509 0.006 87.11 KiB 0.003 2 25 ['Trace'] 0.991 Loading config file '{}'.
37. 1438 0.006 173.99 KiB 0.007 1 43 ['Trace'] 0 Have {} pending inserts with total {} bytes of data for query '{}'
38. 1340 0.005 113.21 KiB 0.004 734 77 ['Debug'] 0.996 Removing {} parts from filesystem (serially): Parts: [{}]
39. 1229 0.005 21.60 KiB 0.001 872 493 ['Debug'] 0.298 Loading data parts
40. 1022 0.004 65.81 KiB 0.003 1 104 ['Debug'] 1 Finish load job '{}' with status {}
41. 1022 0.004 72.75 KiB 0.003 1 34 ['Debug'] 0.073 Schedule load job '{}' into {}
42. 1021 0.004 69.67 KiB 0.003 1 104 ['Debug'] 1 Execute load job '{}' in {}
43. 1011 0.004 88.20 KiB 0.003 1 35 ['Debug'] 0.047 Prioritize load job '{}': {} -> {}
44. 984 0.004 87.40 KiB 0.003 1 77 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.)
45. 954 0.004 42.34 KiB 0.002 1 3 ['Trace'] 1 Processing requests batch, size: {}, bytes: {}
46. 929 0.004 20.87 KiB 0.001 851 467 ['Debug'] 0.103 There are no data parts
47. 897 0.003 69.20 KiB 0.003 1 72 ['Trace'] 0 Query span trace_id for opentelemetry log: {}
48. 788 0.003 39.10 KiB 0.001 68 108 ['Trace'] 0.977 Loading {} part {} from disk {}
49. 788 0.003 44.48 KiB 0.002 68 108 ['Trace'] 0.977 Finished loading {} part {} on disk {}
50. 769 0.003 17.27 KiB 0.001 1 77 ['Trace'] 0 Merging aggregated data
51. 761 0.003 17.01 KiB 0.001 8 424 ['Trace'] 1 Execution took {} ms.
52. 749 0.003 41.59 KiB 0.002 3 11 ['Trace'] 0.035 Table {} has {} ({})
53. 748 0.003 43.10 KiB 0.002 746 65 ['Trace'] 0.999 dropAllData: removing data parts (count {}) from filesystem.
54. 748 0.003 22.64 KiB 0.001 746 65 ['Trace'] 0.999 dropAllData: waiting for locks.
55. 746 0.003 13.11 KiB 0 746 65 ['Trace'] 0.999 dropAllData: done.
56. 746 0.003 48.08 KiB 0.002 746 65 ['Information'] 0.999 dropAllData: removing table directory recursive to cleanup garbage
57. 746 0.003 31.33 KiB 0.001 746 65 ['Information'] 0.999 dropAllData: clearing temporary directories
58. 746 0.003 56.10 KiB 0.002 746 65 ['Information'] 0.999 dropAllData: remove format_version.txt, detached, moving and write ahead logs
59. 746 0.003 35.70 KiB 0.001 746 65 ['Trace'] 0.999 dropAllData: removing all data parts from memory.
60. 740 0.003 58.79 KiB 0.002 101 97 ['Trace'] 0.223 Reading {} ranges in{}order from part {}, approx. {} rows starting from {}
61. 726 0.003 22.49 KiB 0.001 20 15 ['Debug'] 0.008 Requested flush up to offset {}
62. 676 0.003 21.03 KiB 0.001 112 110 ['Debug'] 0.376 Key condition: {}
63. 676 0.003 29.71 KiB 0.001 112 110 ['Trace'] 0.376 Filtering marks by primary and secondary keys
64. 670 0.003 76.06 KiB 0.003 114 110 ['Debug'] 0.373 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges
65. 634 0.002 53.24 KiB 0.002 1 37 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {}
66. 634 0.002 21.67 KiB 0.001 1 37 ['Debug'] 0 Selected MergeAlgorithm: {}
67. 632 0.002 19.26 KiB 0.001 1 75 ['Trace'] 0 Aggregation method: {}
68. 630 0.002 58.80 KiB 0.002 23 16 ['Debug'] 0.989 Removing {} parts from memory: Parts: [{}]
69. 630 0.002 58.19 KiB 0.002 23 16 ['Trace'] 0.989 Found {} old parts to remove. Parts: [{}]
70. 627 0.002 34.05 KiB 0.001 37 402 ['Debug'] 0.973 Selected {} parts from {} to {}
71. 609 0.002 31.52 KiB 0.001 95 109 ['Trace'] 0.411 Spreading mark ranges among streams (default reading)
72. 608 0.002 107.67 KiB 0.004 1 9 ['Trace'] 0 Failed to make request to '{}'{}. Error: {}. Failed at try {}/{}. Will retry with current backoff wait is {}/{} ms.
73. 599 0.002 78.18 KiB 0.003 1 36 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec.
74. 597 0.002 39.67 KiB 0.002 37 35 ['Trace'] 0 Merged {} parts: [{}, {}] -> {}
75. 596 0.002 19.15 KiB 0.001 5 59 ['Trace'] 1 Loading table {}
76. 552 0.002 21.64 KiB 0.001 1 104 ['Debug'] 0.513 Spawn loader worker #{} in {}
77. 552 0.002 15.65 KiB 0.001 1 124 ['Debug'] 1 Stop worker in {}
78. 547 0.002 57.53 KiB 0.002 1 74 ['Debug'] 0.941 (internal) {} (stage: {})
79. 521 0.002 2.12 MiB 0.083 18 142 ['Error'] 0.422 Cannot schedule a task: {} (threads={}, jobs={})
80. 489 0.002 55.44 KiB 0.002 1 55 ['Trace'] 0.978 Using builtin hash table for {} attribute of {}
81. 483 0.002 49.81 KiB 0.002 2 12 ['Trace'] 0.973 Will load the object '{}' {}, force = {}, loading_id = {}
82. 482 0.002 42.31 KiB 0.002 2 66 ['Trace'] 0.973 Next update time for '{}' was set to {}
83. 482 0.002 27.70 KiB 0.001 2 66 ['Trace'] 0.973 Start loading object '{}'
84. 451 0.002 54.54 KiB 0.002 1 60 ['Trace'] 0.98 Supposed update time for '{}' is {} (loaded, lifetime [{}, {}], no errors)
85. 434 0.002 4.66 KiB 0 1 68 ['Trace'] 0 Aggregating
86. 414 0.002 30.09 KiB 0.001 1 23 ['Trace'] 0.114 Condition {} moved to PREWHERE
87. 411 0.002 13.64 KiB 0.001 1 108 ['Debug'] 0.528 Change current priority: {} -> {}
88. 383 0.001 3.37 KiB 0 2 34 ['Trace'] 0.021 No tables
89. 379 0.001 81.76 KiB 0.003 1 25 ['Trace'] 0.124 PREWHERE condition was split into {} steps: {}
90. 336 0.001 26.73 KiB 0.001 1 76 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={}
91. 311 0.001 12.45 KiB 0 12 73 ['Trace'] 0 Sending external_roles with query: [{}] ({})
92. 290 0.001 56.26 KiB 0.002 1 68 ['Trace'] 0.017 {}Keys: {}, datatype: {}, kind: {}, strictness: {}, right header: {}
93. 287 0.001 23.07 KiB 0.001 1 68 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={}
94. 284 0.001 20.72 KiB 0.001 1 30 ['Trace'] 0.165 The min valid primary key position for moving to the tail of PREWHERE is {}
95. 275 0.001 10.75 KiB 0 68 60 ['Trace'] 0.956 Will load {} parts using up to {} threads
96. 265 0.001 6.99 KiB 0 67 59 ['Debug'] 0.958 Loaded data parts ({} items)
97. 264 0.001 21.32 KiB 0.001 1 3 ['Debug'] 1 Merging configuration file '{}'.
98. 247 0.001 10.62 KiB 0 1 3 ['Information'] 1 {} for session {} took {} ms
99. 236 0.001 16.05 KiB 0.001 1 35 ['Debug'] 0.051 Wait load job '{}' in {}
100. 227 0.001 36.95 KiB 0.001 12 57 ['Debug'] 0 Sent data for {} scalars, total {} rows in {} sec., {} rows/sec., {} ({}/sec.), compressed {} times to {} ({}/sec.)
count count_% size size_% uniq_loggers uniq_threads levels background_% message_format_string
Top messages without format string (fmt::runtime):
count pattern runtime_message line
1. 14 CodeDBExceptionReceivedfromDBExc Code: 439. DB::Exception: Received from 127.0.0.2:9000. DB::Exception: Cannot schedule a task: fault injected (threads=774, jobs=729). Stack trace:
0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x ('/executeQuery.cpp',221)
2. 6 CodeDBExceptionSyntaxerrorfailed Code: 62. DB::Exception: Syntax error: failed at position 17 ('0.018783'): 0.018783. Expected one of: token sequence, Dot, token, OR, AND, IS NOT DISTINCT FROM, IS NULL, IS NOT NULL, BETWEEN, NOT BETWEEN, LIKE, ILIKE, NOT LIKE, NOT ILIKE, REGEXP, IN, NOT I ('/executeQuery.cpp',221)
3. 3 Connectiontomysqlfailedtimes Connection to mysql failed 1 times ('',0)
4. 3 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',43)
5. 3 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',43)
6. 3 StartingClickHousealtinitytestre Starting ClickHouse 24.8.14.10544.altinitytest (revision: 4294967295, git hash: 9ff92307932be886d77861423556aba6ef8de5b8, build id: 60E2D623E5133122E5089C8BFA21525AF0068F3F), PID 428 ('',0)
7. 3 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',43)
8. 3 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',43)
9. 3 ConnectiontosystemasuserMYSQLUSE Connection to system@127.0.0.1:9004 as user 02833_MYSQL_USER_10991 failed: mysqlxx::ConnectionFailed: 02833_MYSQL_USER_10991: Authentication failed: password is incorrect, or there is no user with such name. ((nullptr):9004) ('',0)
10. 3 statemachinecommitindexprecommit state machine commit index 0, precommit index 0, last log index 0 ('/LoggerWrapper.h',43)
11. 3 Forkedachildprocesstowatch Forked a child process to watch ('',0)
12. 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)
13. 3 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 0 ('/LoggerWrapper.h',43)
14. 3 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1
my id: 1, voting_member
num peers: 0 ('/LoggerWrapper.h',43)
15. 3 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',43)
16. 3 RaftASIOlistenerinitiatedonunsec Raft ASIO listener initiated on :::9234, unsecured ('/LoggerWrapper.h',43)
17. 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)
18. 3 VOTEINITmyidmyrolecandidateterml [VOTE INIT] my id 1, my role candidate, term 1, log idx 0, log term 0, priority (target 1 / mine 1) ('/LoggerWrapper.h',43)
19. 3 startingup starting up ('',0)
20. 3 newelectiontimeoutrange new election timeout range: 0 - 0 ('/LoggerWrapper.h',43)
21. 3 PRIORITYdecaytargetmine [PRIORITY] decay, target 1 -> 1, mine 1 ('/LoggerWrapper.h',43)
22. 3 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 1 ('/LoggerWrapper.h',43)
23. 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)
24. 3 DBExceptionMYSQLUSERAuthenticati DB::Exception: 02833_MYSQL_USER_10991: Authentication failed: password is incorrect, or there is no user with such name. ('',0)
25. 3 newconfiglogidxprevlogidxcurconf new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0 ('/LoggerWrapper.h',43)
26. 3 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',43)
27. 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)
28. 3 numberofpendingcommitelements number of pending commit elements: 0 ('/LoggerWrapper.h',43)
29. 2 CodeDBExceptionTherequestsignatu Code: 499. DB::Exception: The request signature we calculated does not match the signature you provided. Check your key and signing method. (S3_ERROR) (version 24.8.14.10544.altinitytest (altinity build)) (from [::1]:50818) (comment: 02843_backup_use_same_ ('/executeQuery.cpp',221)
30. 2 prevotetermisdifferentresetitto pre-vote term (0) is different, reset it to 1 ('/LoggerWrapper.h',43)
Top messages not matching their format strings:
message_format_string count() any_message
1. 79 Forked a child process to watch
2. {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 30 /var/lib/clickhouse/store/f7a/f7a9f746-fa6f-4f82-bae3-f9e0e1af99e1/tmp_merge_202510_1_11_2/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 1 similar messages)
3. (from {}{}{}){}{} {} (stage: {}) 1 (from [::1]:58052) (comment: 02683_native_too_large_size.sql) SELECT * FROM format('Native', 'WatchID Int64, JavaEnable Int16, Title String, GoodEvent Int16, EventTime DateTime, EventDate Date, CounterID Int32, ClientIP Int32, RegionID Int32, UserID Int64, CounterClass Int16, OS Int16, UserAgent Int16, URL String, Referer String, IsRefresh Int16, RefererCategoryID Int16, RefererRegionID Int32, URLCategoryID Int16, URLRegionID Int32, ResolutionWidth Int16, ResolutionHeight Int16, ResolutionDepth Int16, FlashMajor Int16, FlashMinor Int16, FlashMinor2 String, NetMajor Int16, NetMinor Int16, UserAgentMajor Int16, UserAgentMinor String, CookieEnable Int16, JavascriptEnable Int16, IsMobile Int16, MobilePhone Int16, MobilePhoneModel String, Params String, IPNetworkID Int32, TraficSourceID Int16, SearchEngineID Int16, SearchPhrase String, AdvEngineID Int32, IsArtifical Int16, WindowClientWidth Int16, WindowClientHeight Int16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 Int16, SilverlightVersion2 Int16, SilverlightVersion3 Int32, SilverlightVersion4 Int16, PageCharset String, CodeVersion Int32, IsLink Int16, IsDownload Int16, IsNotBounce Int16, FUniqID Int64, OriginalURL String, HID Int32, IsOldCounter Int16, IsEvent Int16, IsParameter Int16, DontCountHits Int16, WithHash Int16, HitColor String, LocalEventTime DateTime, Age Int16, Sex Int16, Income Int16, Interests Int16, Robotness Int16, RemoteIP Int32, VindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage String, BrowserCountry String, SocialNetwork String, SocialAction String, HTTPError Int16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, FetchTiming Int32, SocialSourceNetworkID Int16, SocialSourcePage String, ParamPrice Int64, ParamOrderID String, ParamCurrency String, ParamCurrencyID Int16, OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID Int16, RefererHash Int64, URLHash Int64, CLID Int32', $$i
WatchIDInt64c*5/ !p~�F�ӓ2ql!�|�@H�ǐ=ЌW�E&Ly�k=�p�1�o�C»-�C_��\�/E�J�{
JavaEnableInt16 TitleString GoodEventInt16 EventTimeDateTime7�Qn$�Q�)�Q8*�QJ�Q��Q�0�Q83�Q� �Q�1�Q EventDateDate>>>>>>>>>> CounterIDInt32 ClientIPInt32�z�z�z�z�I`�z�^{]�^{]�gU�z�RegionIDInt32G G G G ' G � � � G UserIDInt64� �:6� �:6� �:6� �:6�q�Jd8
�Ks}�&n%�t"6&n%�t"6�s�yy�f� �:6�CounterClassInt16 OSInt16 ' ' , UserAgentInt16 URLString -http://holodilInt16 WindowClientWidthInt16 WindowClientHeightInt16 ClientTimeZoneInt16�ClientEventTimeDateTime����������SilverlightVersion1Int16 SilverlightVersion2Int16 SilverlightVersion3Int32 SilverlightVersion4Int16 PageCharsetString CodeVersionInt32 IsLinkInt16
IsDownloadInt16 IsNotBounceInt16 FUniqIDInt64 %�l�+k:�W�m OriginalURLString HIDInt32 IsOldCounterInt16 IsEventInt16 IsParameterInt16
DontCountHitsInt16 WithHashInt16 HitColorString5555555555LocalEventTimeDateTime&�Qǘ�Q}�Qݞ�Q'�QA�Q�Q
�QY�Q�QAgeInt16 SexInt16 IncomeInt16 InterestsInt16 �: RobotnessInt16 RemoteIPInt32^DI�^DI�^DI�^DI�9�3N^DI��U�U�=k^DI�
WindowNameInt32�
OpenerNameInt32�
HistoryLengthInt16�BrowserLanguageString����������BrowserCountryString����������
SocialNetworkString SocialActionString HTTPErrorInt16
SendTimingInt32 DNSTimingInt32
ConnectTimingInt32 ResponseStartTimingInt32 ResponseEndTimingInt32 FetchTimingInt32 SocialSourceNetworkIDInt16 SocialSourcePageString
ParamPriceInt64 ParamOrderIDString
ParamCurrencyStringNHNHNHNHNHNHNHNHNHNHParamCurrencyIDInt16 OpenstatServiceNameString OpenstatCampaignIDString OpenstatAdIDString OpenstatSourceIDString UTMSourceString UTMMediumString UTMCampaignString
UTMContentString UTMTermString FromTagString HasGCLIDInt16 RefererHashInt64X+�'�X+�'�X+�'�X+�'�X+�'�X+�'�X+�'�X+�'�X+�'�X+�'�URLHashInt64�|3�b.�|3�b.�|3�b.�|3�b.�
o�e�
�#�\X-h�X v�v�h�9�D�|3�b.�CLIDInt32 $$); (stage: Complete)
Top short messages:
c message_format_string substr(any(toValidUTF8(message)), 1, 120) min_length_without_exception_boilerplate
1. 17 {} ThreadFuzzer is enabled. Application will run slowly and unstable. 34
2. 6 Cannot TRUNCATE dictionary Code: 62. DB::Exception: Cannot TRUNCATE dictionary. (SYNTAX_ERROR) (version 24.8.14.10544.altinitytest (altinity build) 27
3. 5 Froze {} parts Froze 10 parts -13
4. 5 Found {} on {} Found snapshot_15.bin.zstd on LocalSnapshotDisk 18
5. 2 Table {} is not empty Code: 705. DB::Exception: Table tab2 is not empty. (TABLE_NOT_EMPTY) (version 24.8.14.10544.altinitytest (altinity build 25
6. 2 Substitution {} is not set Code: 456. DB::Exception: Substitution `s` is not set. (UNKNOWN_QUERY_PARAMETER) (version 24.8.14.10544.altinitytest (al 29
Top messages by level:
(0.002024126342780551,'Cannot schedule a task: {} (threads={}, jobs={})') Error
(0.00006604634899667826,'{}') Warning
(0.00854328949668797,'Have {} tables in drop queue ({} of them are in use), will try drop {} tables') Information
(0.03411099671710795,'(from {}{}{}){}{} {} (stage: {})') Debug
(0.21543930534781172,'is disk {} eligible for search: {}') Trace
2025-10-24 00:15:44,986 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=2683
+ clickhouse stop --max-tries 90 --do-not-kill
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2683.
The process with pid = 2683 is running.
Sent terminate signal to process with pid 2683.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2683.
The process with pid = 2683 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2683.
The process with pid = 2683 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2683.
The process with pid = 2683 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2683.
The process with pid = 2683 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2683.
The process with pid = 2683 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2683.
The process with pid = 2683 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2683.
The process with pid = 2683 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2683.
The process with pid = 2683 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
127.0.0.1 - - [23/Oct/2025:22:15:55 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 -
127.0.0.1 - - [23/Oct/2025:22:15:55 +0000] "PUT /devstoreaccount1/cont/hwxvhsokmqvmapizggwiypvmowjnzpja HTTP/1.1" 201 -
127.0.0.1 - - [23/Oct/2025:22:15:55 +0000] "GET /devstoreaccount1/cont/hwxvhsokmqvmapizggwiypvmowjnzpja HTTP/1.1" 206 4
127.0.0.1 - - [23/Oct/2025:22:15:55 +0000] "GET /devstoreaccount1/cont/hwxvhsokmqvmapizggwiypvmowjnzpja HTTP/1.1" 206 2
127.0.0.1 - - [23/Oct/2025:22:15:55 +0000] "DELETE /devstoreaccount1/cont/hwxvhsokmqvmapizggwiypvmowjnzpja HTTP/1.1" 202 -
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
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'
1
+ attach_gdb_to_clickhouse
++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ [[ hxB =~ e ]]
++ set_e=false
++ set +e
++ local total_retries=5
++ shift
++ local retry=0
++ '[' 0 -ge 5 ']'
++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
Received exception from server (version 24.8.14):
Code: 439. DB::Exception: Received from localhost:9000. DB::Exception: Cannot schedule a task: failed to start the thread (threads=6, jobs=6). (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=4, jobs=4). (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)'
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=0, jobs=0). (CANNOT_SCHEDULE_TASK)
(query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value))
++ retry=3
++ sleep 5
++ '[' 3 -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 35208
+ 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=35208
+ 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 = 35208.
The process with pid = 35208 is running.
Sent terminate signal to process with pid 35208.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 35208.
The process with pid = 35208 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 35208.
The process with pid = 35208 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 35208.
The process with pid = 35208 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 35208.
The process with pid = 35208 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 35208.
The process with pid = 35208 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 35208.
The process with pid = 35208 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 - - [23/Oct/2025:22:16:34 +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 - - [23/Oct/2025:22:16:44 +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 - - [23/Oct/2025:22:16:49 +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