+ 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.10546.altinitytest_amd64.deb
Selecting previously unselected package clickhouse-common-static.
(Reading database ... 48696 files and directories currently installed.)
Preparing to unpack .../clickhouse-common-static_24.8.14.10546.altinitytest_amd64.deb ...
Unpacking clickhouse-common-static (24.8.14.10546.altinitytest) ...
Setting up clickhouse-common-static (24.8.14.10546.altinitytest) ...
+ dpkg -i package_folder/clickhouse-common-static-dbg_24.8.14.10546.altinitytest_amd64.deb
Selecting previously unselected package clickhouse-common-static-dbg.
(Reading database ... 48723 files and directories currently installed.)
Preparing to unpack .../clickhouse-common-static-dbg_24.8.14.10546.altinitytest_amd64.deb ...
Unpacking clickhouse-common-static-dbg (24.8.14.10546.altinitytest) ...
Setting up clickhouse-common-static-dbg (24.8.14.10546.altinitytest) ...
+ dpkg -i package_folder/clickhouse-server_24.8.14.10546.altinitytest_amd64.deb
Selecting previously unselected package clickhouse-server.
(Reading database ... 48730 files and directories currently installed.)
Preparing to unpack .../clickhouse-server_24.8.14.10546.altinitytest_amd64.deb ...
Unpacking clickhouse-server (24.8.14.10546.altinitytest) ...
Setting up clickhouse-server (24.8.14.10546.altinitytest) ...
ClickHouse binary is already located at /usr/bin/clickhouse
Symlink /usr/bin/clickhouse-server already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-server to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-client to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-local to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-benchmark to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-obfuscator to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-git-import to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-compressor to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-format to /usr/bin/clickhouse.
Symlink /usr/bin/clickhouse-extract-from-config already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-extract-from-config to /usr/bin/clickhouse.
Symlink /usr/bin/clickhouse-keeper already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-keeper to /usr/bin/clickhouse.
Symlink /usr/bin/clickhouse-keeper-converter already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-keeper-converter to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-disks to /usr/bin/clickhouse.
Creating symlink /usr/bin/ch to /usr/bin/clickhouse.
Creating symlink /usr/bin/chl to /usr/bin/clickhouse.
Creating symlink /usr/bin/chc to /usr/bin/clickhouse.
Creating clickhouse group if it does not exist.
groupadd -r clickhouse
Creating clickhouse user if it does not exist.
useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse clickhouse
Will set ulimits for clickhouse user in /etc/security/limits.d/clickhouse.conf.
Creating config directory /etc/clickhouse-server/config.d that is used for tweaks of main server configuration.
Creating config directory /etc/clickhouse-server/users.d that is used for tweaks of users configuration.
Config file /etc/clickhouse-server/config.xml already exists, will keep it and extract path info from it.
/etc/clickhouse-server/config.xml has /var/lib/clickhouse/ as data path.
/etc/clickhouse-server/config.xml has /var/log/clickhouse-server/ as log path.
Users config file /etc/clickhouse-server/users.xml already exists, will keep it and extract users info from it.
Log directory /var/log/clickhouse-server/ already exists.
Creating data directory /var/lib/clickhouse/.
Creating pid directory /var/run/clickhouse-server.
chown -R clickhouse:clickhouse '/var/log/clickhouse-server/'
chown -R clickhouse:clickhouse '/var/run/clickhouse-server'
chown clickhouse:clickhouse '/var/lib/clickhouse/'
Password for the default user is an empty string. See /etc/clickhouse-server/users.xml and /etc/clickhouse-server/users.d to change it.
Setting capabilities for clickhouse binary. This is optional.
chown -R clickhouse:clickhouse '/etc/clickhouse-server'
ClickHouse has been successfully installed.
Start clickhouse-server with:
sudo clickhouse start
Start clickhouse-client with:
clickhouse-client
+ dpkg -i package_folder/clickhouse-client_24.8.14.10546.altinitytest_amd64.deb
Selecting previously unselected package clickhouse-client.
(Reading database ... 48747 files and directories currently installed.)
Preparing to unpack .../clickhouse-client_24.8.14.10546.altinitytest_amd64.deb ...
Unpacking clickhouse-client (24.8.14.10546.altinitytest) ...
Setting up clickhouse-client (24.8.14.10546.altinitytest) ...
+ export THREAD_FUZZER_CPU_TIME_PERIOD_US=1000
+ THREAD_FUZZER_CPU_TIME_PERIOD_US=1000
+ export THREAD_FUZZER_SLEEP_PROBABILITY=0.1
+ THREAD_FUZZER_SLEEP_PROBABILITY=0.1
+ export THREAD_FUZZER_SLEEP_TIME_US_MAX=100000
+ THREAD_FUZZER_SLEEP_TIME_US_MAX=100000
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000
+ export THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01
+ THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01
+ export THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01
+ THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01
+ export ZOOKEEPER_FAULT_INJECTION=1
+ ZOOKEEPER_FAULT_INJECTION=1
+ configure
+ export USE_DATABASE_ORDINARY=1
+ USE_DATABASE_ORDINARY=1
+ export EXPORT_S3_STORAGE_POLICIES=1
+ EXPORT_S3_STORAGE_POLICIES=1
+ /usr/share/clickhouse-test/config/install.sh
+ DEST_SERVER_PATH=/etc/clickhouse-server
+ DEST_CLIENT_PATH=/etc/clickhouse-client
+++ dirname /usr/share/clickhouse-test/config/install.sh
++ cd /usr/share/clickhouse-test/config
++ pwd -P
+ SRC_PATH=/usr/share/clickhouse-test/config
+ echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server'
Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server
+ mkdir -p /etc/clickhouse-server/config.d/
+ mkdir -p /etc/clickhouse-server/users.d/
+ mkdir -p /etc/clickhouse-client
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_catalog_drop_table_concurrency.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/grpc_protocol.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/block_number.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/serverwide_trace_collector.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/rocksdb.xml /etc/clickhouse-server/config.d/
+ '[' /etc/clickhouse-server = /etc/clickhouse-server ']'
+ ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/
+ ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ rm -f /etc/clickhouse-server/config.d/zookeeper.xml
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/
+ [[ -n '' ]]
+ rm -f /etc/clickhouse-server/config.d/cannot_allocate_thread_injection.xml
+ value=1
+ sed --follow-symlinks -i 's|[01]|1|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=42514432
+ sed --follow-symlinks -i 's|[[:digit:]]\+|42514432|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=28909568
+ sed --follow-symlinks -i 's|[[:digit:]]\+|28909568|' /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n '' ]]
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/
+ [[ '' == \1 ]]
+ [[ '' == \1 ]]
+ [[ -n 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|100000|10000|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value filtered_list keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value multi_read keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value check_not_exists keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value create_if_not_exists keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value use_compression zookeeper_fault_injection
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ randomize_config_boolean_value enable_block_number_column block_number
+ value=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
+ sed 's|[01]|1|'
+ sudo cat /etc/clickhouse-server/config.d/block_number.xml
+ sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml
+ echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\'''
+ export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ sudo chown root: /var/lib/clickhouse
+ local total_mem
++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo
+ total_mem=32086440
+ total_mem=32856514560
+ max_server_memory_usage_to_ram_ratio=0.5
+ echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5'
+ cat
Setting max_server_memory_usage_to_ram_ratio to 0.5
+ local max_users_mem
+ max_users_mem=9856954368
+ echo 'Setting max_memory_usage_for_user=9856954368 and max_memory_usage for queries to 10G'
+ cat
Setting max_memory_usage_for_user=9856954368 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
+ grep AccessDenied
+ curl --silent --verbose http://localhost:11111
+ [[ 0 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
Azurite Blob service is starting on 0.0.0.0:10000
Azurite Blob service successfully listens on http://0.0.0.0:10000
INFO: Formatting 1st pool, 1 set(s), 1 drives per set.
INFO: WARNING: Host local has more than 0 drives of set. A host failure will result in data becoming unavailable.
MinIO Object Storage Server
Copyright: 2015-2026 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:42031 http://127.0.0.1:42031
Docs: https://min.io/docs/minio/linux/index.html
+ counter=1
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
AccessDeniedAccess Denied./18ACCF1DEA219BB47dc7eb22d3288ec80374614e9088e31d3668a6922ead55932dd2a8e56373820f
+ lsof -i :11111
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
minio 275 root 8u IPv6 26345 0t0 TCP *:11111 (LISTEN)
minio 275 root 9u IPv4 26344 0t0 TCP localhost:11111 (LISTEN)
minio 275 root 10u IPv6 26346 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/02876.parquet` -> `clickminio/test/02876.parquet`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl` -> `clickminio/test/02366_data.jsonl`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive2.tar` -> `clickminio/test/03036_archive2.tar`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive1.tar` -> `clickminio/test/03036_archive1.tar`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive3.tar.gz` -> `clickminio/test/03036_archive3.tar.gz`
`/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_archive1.zip` -> `clickminio/test/03036_archive1.zip`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow` -> `clickminio/test/02731.arrow`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet` -> `clickminio/test/02731.parquet`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_compressed_file_archive.zip` -> `clickminio/test/03036_compressed_file_archive.zip`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_json_archive.zip` -> `clickminio/test/03036_json_archive.zip`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv` -> `clickminio/test/a.tsv`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv` -> `clickminio/test/b.tsv`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv` -> `clickminio/test/c.tsv`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/hive_partitioning/column0=Elizabeth/column1=Gordon/sample.parquet` -> `clickminio/test/hive_partitioning/column0=Elizabeth/column1=Gordon/sample.parquet`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/hive_partitioning/column0=Elizabeth/column1=Schmidt/sample.parquet` -> `clickminio/test/hive_partitioning/column0=Elizabeth/column1=Schmidt/sample.parquet`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/hive_partitioning/column0=Elizabeth/sample.parquet` -> `clickminio/test/hive_partitioning/column0=Elizabeth/sample.parquet`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/hive_partitioning/non_existing_column=Elizabeth/sample.parquet` -> `clickminio/test/hive_partitioning/non_existing_column=Elizabeth/sample.parquet`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/json_data` -> `clickminio/test/json_data`
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv` -> `clickminio/test/tsv_with_header.tsv`
Total: 5.42 MiB, Transferred: 5.42 MiB, Speed: 72.73 MiB/s
+ setup_aws_credentials
+ local minio_root_user=clickhouse
+ local minio_root_password=clickhouse
+ mkdir -p /root/.aws
+ cat
+ config_logs_export_cluster /etc/clickhouse-server/config.d/system_logs_export.yaml
+ set +x
File /tmp/export-logs-config.sh does not exist, do not setup
+ export CLICKHOUSE_MAX_THREADS=8
+ CLICKHOUSE_MAX_THREADS=8
+ export CLICKHOUSE_MAX_CONCURRENT_QUERIES=4
+ CLICKHOUSE_MAX_CONCURRENT_QUERIES=4
+ start_server
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 13 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=14
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 14 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=15
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 15 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=16
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 16 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=17
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 17 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=18
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 18 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=19
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 19 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=20
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 20 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
127.0.0.1 - - [05/May/2026:23:28:22 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 404 -
127.0.0.1 - - [05/May/2026:23:28:22 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 -
127.0.0.1 - - [05/May/2026:23:28:22 +0000] "PUT /devstoreaccount1/cont/cyewsghqusuhbtgsanpvnlkagrydyuwa HTTP/1.1" 201 -
127.0.0.1 - - [05/May/2026:23:28:22 +0000] "GET /devstoreaccount1/cont/cyewsghqusuhbtgsanpvnlkagrydyuwa HTTP/1.1" 206 4
127.0.0.1 - - [05/May/2026:23:28:22 +0000] "GET /devstoreaccount1/cont/cyewsghqusuhbtgsanpvnlkagrydyuwa HTTP/1.1" 206 2
127.0.0.1 - - [05/May/2026:23:28:22 +0000] "DELETE /devstoreaccount1/cont/cyewsghqusuhbtgsanpvnlkagrydyuwa HTTP/1.1" 202 -
+ counter=21
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ [[ hxB =~ e ]]
++ set_e=false
++ set +e
++ local total_retries=5
++ shift
++ local retry=0
++ '[' 0 -ge 5 ']'
++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ 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 414
+ 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
File /tmp/export-logs-config.sh does not exist, do not setup
+ set +x
+ clickhouse-client --query 'CREATE DATABASE datasets'
+ clickhouse-client --multiquery
+ clickhouse-client --query 'SHOW TABLES FROM datasets'
hits_v1
visits_v1
+ clickhouse-client --query 'CREATE DATABASE IF NOT EXISTS test'
+ stop_server
+ local max_tries=90
+ local check_hang=true
+ local pid
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ pid=414
+ clickhouse stop --max-tries 90 --do-not-kill
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Sent terminate signal to process with pid 414.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 414.
The process with pid = 414 is running.script.gdb:13: Error in sourced command file:
No stack.
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: LRU
+ cache_policy=
+ '[' 0 -eq 1 ']'
+ cache_policy=LRU
+ echo 'Using cache policy: LRU'
+ '[' LRU = SLRU ']'
+ sudo cat /etc/clickhouse-server/users.d/stress_tests_overrides.xml
cat: /etc/clickhouse-server/users.d/stress_tests_overrides.xml: No such file or directory
+ start_server
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 13 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=14
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 14 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=15
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 15 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=16
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 16 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
127.0.0.1 - - [05/May/2026:23:29:55 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 -
127.0.0.1 - - [05/May/2026:23:29:56 +0000] "PUT /devstoreaccount1/cont/kfphfxrintmjxhutmubtoxkttizdmlze HTTP/1.1" 201 -
127.0.0.1 - - [05/May/2026:23:29:56 +0000] "GET /devstoreaccount1/cont/kfphfxrintmjxhutmubtoxkttizdmlze HTTP/1.1" 206 4
127.0.0.1 - - [05/May/2026:23:29:56 +0000] "GET /devstoreaccount1/cont/kfphfxrintmjxhutmubtoxkttizdmlze HTTP/1.1" 206 2
127.0.0.1 - - [05/May/2026:23:29:56 +0000] "DELETE /devstoreaccount1/cont/kfphfxrintmjxhutmubtoxkttizdmlze HTTP/1.1" 202 -
+ counter=17
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 17 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=18
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 18 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=19
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 19 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=20
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 20 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=21
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 21 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=22
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 22 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=23
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 23 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=24
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 24 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=25
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 25 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=26
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 26 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=27
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 27 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=28
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 28 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=29
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 29 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=30
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 30 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=31
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 31 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=32
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 32 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=33
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 33 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=34
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 34 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=35
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 35 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=36
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 36 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=37
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 37 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=38
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 38 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=39
+ clickhouse-client --query 'SELECT 1'
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 1435
+ 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.272521239 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 (total) exceeded: would use 16.01 GiB (attempt to allocate chunk of 1610212 bytes), maximum: 15.30 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.: (while reading column UserAgentMajor): (while reading from part store/78e/78ebf6a1-d987-4579-b3ec-00c1a087b1f3/201403_1_1_2/ in table datasets.hits_v1 (78ebf6a1-d987-4579-b3ec-00c1a087b1f3) located on disk __tmp_internal_262634248876485800814430204900764312493 of type web, from mark 88 with max_rows_to_read = 8192): While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (MEMORY_LIMIT_EXCEEDED)
(query: INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16)
+ clickhouse-client --query 'INSERT INTO test.visits SELECT * FROM datasets.visits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16'
Received exception from server (version 24.8.14):
Code: 159. DB::Exception: Received from localhost:9000. DB::Exception: Timeout exceeded: elapsed 66.605496233 seconds, maximum: 60. (TIMEOUT_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=1435
+ 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 = 1435.
The process with pid = 1435 is running.
Sent terminate signal to process with pid 1435.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1435.
The process with pid = 1435 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1435.
The process with pid = 1435 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1435.
The process with pid = 1435 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1435.
The process with pid = 1435 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1435.
The process with pid = 1435 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ export RANDOMIZE_OBJECT_KEY_TYPE=1
+ RANDOMIZE_OBJECT_KEY_TYPE=1
+ export ZOOKEEPER_FAULT_INJECTION=1
+ ZOOKEEPER_FAULT_INJECTION=1
+ export THREAD_POOL_FAULT_INJECTION=1
+ THREAD_POOL_FAULT_INJECTION=1
+ configure
+ export USE_DATABASE_ORDINARY=1
+ USE_DATABASE_ORDINARY=1
+ export EXPORT_S3_STORAGE_POLICIES=1
+ EXPORT_S3_STORAGE_POLICIES=1
+ /usr/share/clickhouse-test/config/install.sh
+ DEST_SERVER_PATH=/etc/clickhouse-server
+ DEST_CLIENT_PATH=/etc/clickhouse-client
+++ dirname /usr/share/clickhouse-test/config/install.sh
++ cd /usr/share/clickhouse-test/config
++ pwd -P
+ SRC_PATH=/usr/share/clickhouse-test/config
+ echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server'
Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server
+ mkdir -p /etc/clickhouse-server/config.d/
+ mkdir -p /etc/clickhouse-server/users.d/
+ mkdir -p /etc/clickhouse-client
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_catalog_drop_table_concurrency.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/grpc_protocol.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/block_number.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/serverwide_trace_collector.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/rocksdb.xml /etc/clickhouse-server/config.d/
+ '[' /etc/clickhouse-server = /etc/clickhouse-server ']'
+ ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/
+ ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ rm -f /etc/clickhouse-server/config.d/zookeeper.xml
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/config.d/cannot_allocate_thread_injection.xml /etc/clickhouse-server/config.d/
+ value=0
+ sed --follow-symlinks -i 's|[01]|0|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=31889408
+ sed --follow-symlinks -i 's|[[:digit:]]\+|31889408|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=3295232
+ sed --follow-symlinks -i 's|[[:digit:]]\+|3295232|' /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
+ sed 's|[01]|1|'
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value multi_read keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value check_not_exists keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value create_if_not_exists keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value use_compression zookeeper_fault_injection
+ value=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=0
+ sudo cat /etc/clickhouse-server/config.d/block_number.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml
+ randomize_config_boolean_value enable_block_offset_column block_number
+ value=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=32086440
+ total_mem=32856514560
+ max_server_memory_usage_to_ram_ratio=0.5
+ echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5'
+ cat
Setting max_server_memory_usage_to_ram_ratio to 0.5
+ local max_users_mem
+ max_users_mem=9856954368
+ echo 'Setting max_memory_usage_for_user=9856954368 and max_memory_usage for queries to 10G'
+ cat
Setting max_memory_usage_for_user=9856954368 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
+ '[' LRU = SLRU ']'
++ date +%-d
+ '[' 0 -eq 1 ']'
+ start_server
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 13 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=14
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 14 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=15
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 15 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=16
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 16 -gt 120 ']'
+ clickhouse start --user root
127.0.0.1 - - [05/May/2026:23:35:49 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 -
+ sleep 0.5
127.0.0.1 - - [05/May/2026:23:35:49 +0000] "PUT /devstoreaccount1/cont/aiislnjxhaytsfeftnsmwewznchdujfu HTTP/1.1" 201 -
127.0.0.1 - - [05/May/2026:23:35:49 +0000] "GET /devstoreaccount1/cont/aiislnjxhaytsfeftnsmwewznchdujfu HTTP/1.1" 206 4
127.0.0.1 - - [05/May/2026:23:35:49 +0000] "GET /devstoreaccount1/cont/aiislnjxhaytsfeftnsmwewznchdujfu HTTP/1.1" 206 2
127.0.0.1 - - [05/May/2026:23:35:49 +0000] "DELETE /devstoreaccount1/cont/aiislnjxhaytsfeftnsmwewznchdujfu HTTP/1.1" 202 -
+ counter=17
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 17 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=18
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 18 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=19
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 19 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=20
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 20 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=21
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 21 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=22
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 22 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=23
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 23 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=24
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 24 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=25
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 25 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=26
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 26 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=27
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 27 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=28
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 28 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=29
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 29 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=30
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 30 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=31
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 31 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=32
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 32 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=33
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 33 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=34
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 34 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=35
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 35 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=36
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 36 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=37
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 37 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=38
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 38 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=39
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ [[ hxB =~ e ]]
++ set_e=false
++ set +e
++ local total_retries=5
++ shift
++ local retry=0
++ '[' 0 -ge 5 ']'
++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
Received exception from server (version 24.8.14):
Code: 439. DB::Exception: Received from localhost:9000. DB::Exception: Cannot schedule a task: fault injected (threads=1, jobs=1). (CANNOT_SCHEDULE_TASK)
(query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value))
++ retry=1
++ sleep 5
++ '[' 1 -ge 5 ']'
++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ false
++ return
+ IS_ASAN=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 2972
+ 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
2026-05-06 01:36:38,686 Run func tests '/usr/bin/clickhouse-test --client-option ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2026-05-06 01:36:39,188 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 '
2026-05-06 01:36:39,689 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_2', 's1', 'r1')" --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2026-05-06 01:36:40,192 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 '
2026-05-06 01:36:40,695 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 '
2026-05-06 01:36:41,196 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_5', 's1', 'r1')" --database=test_5 --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='full_sorting_merge' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2026-05-06 01:36:41,701 Run func tests '/usr/bin/clickhouse-test --order=random --client-option memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 ignore_drop_queries_probability=0.5 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 '
2026-05-06 01:36:42,203 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_7 --client-option join_use_nulls=1 join_algorithm='grace_hash' use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' group_by_use_nulls=1 http_make_head_request=0 ignore_drop_queries_probability=0.5 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 '
2026-05-06 01:36:42,705 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_8', 's1', 'r1')" --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2026-05-06 01:36:43,207 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 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 '
2026-05-06 01:36:43,709 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 '
2026-05-06 01:36:44,213 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 http_make_head_request=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 '
2026-05-06 01:36:44,718 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 '
2026-05-06 01:36:45,220 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 http_make_head_request=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2026-05-06 01:36:45,724 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_14', 's1', 'r1')" --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2026-05-06 01:36:46,226 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_merge' use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' group_by_use_nulls=1 optimize_trivial_approximate_count_query=1 http_make_head_request=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 '
2026-05-06 01:36:46,727 Will wait functests to finish
2026-05-06 01:36:46,728 Finished 6 from 16 processes
2026-05-06 01:36:51,732 Finished 7 from 16 processes
2026-05-06 01:36:56,739 Finished 7 from 16 processes
2026-05-06 01:37:01,742 Finished 7 from 16 processes
2026-05-06 01:37:06,746 Finished 7 from 16 processes
2026-05-06 01:37:11,750 Finished 7 from 16 processes
2026-05-06 01:37:16,754 Finished 7 from 16 processes
2026-05-06 01:37:21,758 Finished 7 from 16 processes
2026-05-06 01:37:26,762 Finished 7 from 16 processes
2026-05-06 01:37:31,766 Finished 7 from 16 processes
2026-05-06 01:37:36,770 Finished 7 from 16 processes
2026-05-06 01:37:41,774 Finished 7 from 16 processes
2026-05-06 01:37:46,778 Finished 7 from 16 processes
2026-05-06 01:37:51,783 Finished 7 from 16 processes
2026-05-06 01:37:56,786 Finished 7 from 16 processes
2026-05-06 01:38:01,792 Finished 7 from 16 processes
2026-05-06 01:38:06,794 Finished 7 from 16 processes
2026-05-06 01:38:11,798 Finished 7 from 16 processes
2026-05-06 01:38:16,801 Finished 7 from 16 processes
2026-05-06 01:38:21,806 Finished 7 from 16 processes
2026-05-06 01:38:26,810 Finished 7 from 16 processes
2026-05-06 01:38:31,814 Finished 7 from 16 processes
2026-05-06 01:38:36,818 Finished 7 from 16 processes
2026-05-06 01:38:41,822 Finished 7 from 16 processes
2026-05-06 01:38:46,826 Finished 7 from 16 processes
2026-05-06 01:38:51,830 Finished 7 from 16 processes
2026-05-06 01:38:56,834 Finished 7 from 16 processes
2026-05-06 01:39:01,838 Finished 7 from 16 processes
2026-05-06 01:39:06,842 Finished 7 from 16 processes
2026-05-06 01:39:11,846 Finished 7 from 16 processes
2026-05-06 01:39:16,850 Finished 7 from 16 processes
2026-05-06 01:39:21,855 Finished 7 from 16 processes
2026-05-06 01:39:26,858 Finished 7 from 16 processes
2026-05-06 01:39:31,862 Finished 7 from 16 processes
2026-05-06 01:39:36,866 Finished 7 from 16 processes
2026-05-06 01:39:41,870 Finished 7 from 16 processes
2026-05-06 01:39:46,872 Finished 7 from 16 processes
2026-05-06 01:39:51,874 Finished 7 from 16 processes
2026-05-06 01:39:56,878 Finished 7 from 16 processes
2026-05-06 01:40:01,882 Finished 7 from 16 processes
2026-05-06 01:40:06,888 Finished 7 from 16 processes
2026-05-06 01:40:11,890 Finished 7 from 16 processes
2026-05-06 01:40:16,894 Finished 7 from 16 processes
2026-05-06 01:40:21,898 Finished 7 from 16 processes
2026-05-06 01:40:26,901 Finished 7 from 16 processes
2026-05-06 01:40:31,906 Finished 7 from 16 processes
2026-05-06 01:40:36,910 Finished 7 from 16 processes
2026-05-06 01:40:41,915 Finished 7 from 16 processes
2026-05-06 01:40:46,918 Finished 7 from 16 processes
2026-05-06 01:40:51,922 Finished 7 from 16 processes
2026-05-06 01:40:56,926 Finished 7 from 16 processes
2026-05-06 01:41:01,928 Finished 7 from 16 processes
2026-05-06 01:41:06,930 Finished 7 from 16 processes
2026-05-06 01:41:11,934 Finished 7 from 16 processes
2026-05-06 01:41:16,938 Finished 7 from 16 processes
2026-05-06 01:41:21,947 Finished 7 from 16 processes
2026-05-06 01:41:26,950 Finished 7 from 16 processes
2026-05-06 01:41:31,954 Finished 7 from 16 processes
2026-05-06 01:41:36,958 Finished 7 from 16 processes
2026-05-06 01:41:41,962 Finished 7 from 16 processes
2026-05-06 01:41:46,966 Finished 7 from 16 processes
2026-05-06 01:41:51,970 Finished 7 from 16 processes
2026-05-06 01:41:56,974 Finished 7 from 16 processes
2026-05-06 01:42:01,978 Finished 7 from 16 processes
2026-05-06 01:42:06,986 Finished 7 from 16 processes
2026-05-06 01:42:11,990 Finished 7 from 16 processes
2026-05-06 01:42:16,994 Finished 7 from 16 processes
2026-05-06 01:42:21,999 Finished 7 from 16 processes
2026-05-06 01:42:27,002 Finished 7 from 16 processes
2026-05-06 01:42:32,006 Finished 7 from 16 processes
2026-05-06 01:42:37,010 Finished 7 from 16 processes
2026-05-06 01:42:42,014 Finished 7 from 16 processes
2026-05-06 01:42:47,018 Finished 7 from 16 processes
2026-05-06 01:42:52,022 Finished 7 from 16 processes
2026-05-06 01:42:57,026 Finished 7 from 16 processes
2026-05-06 01:43:02,030 Finished 7 from 16 processes
2026-05-06 01:43:07,034 Finished 7 from 16 processes
2026-05-06 01:43:12,038 Finished 7 from 16 processes
2026-05-06 01:43:17,042 Finished 7 from 16 processes
2026-05-06 01:43:22,046 Finished 7 from 16 processes
2026-05-06 01:43:27,050 Finished 7 from 16 processes
2026-05-06 01:43:32,056 Finished 7 from 16 processes
2026-05-06 01:43:37,062 Finished 7 from 16 processes
2026-05-06 01:43:42,066 Finished 7 from 16 processes
2026-05-06 01:43:47,070 Finished 7 from 16 processes
2026-05-06 01:43:52,074 Finished 7 from 16 processes
2026-05-06 01:43:57,078 Finished 7 from 16 processes
2026-05-06 01:44:02,082 Finished 7 from 16 processes
2026-05-06 01:44:07,086 Finished 7 from 16 processes
2026-05-06 01:44:12,090 Finished 7 from 16 processes
2026-05-06 01:44:17,094 Finished 7 from 16 processes
2026-05-06 01:44:22,098 Finished 7 from 16 processes
2026-05-06 01:44:27,102 Finished 7 from 16 processes
2026-05-06 01:44:32,106 Finished 7 from 16 processes
2026-05-06 01:44:37,110 Finished 7 from 16 processes
2026-05-06 01:44:42,114 Finished 7 from 16 processes
2026-05-06 01:44:47,118 Finished 7 from 16 processes
2026-05-06 01:44:52,118 Finished 7 from 16 processes
2026-05-06 01:44:57,120 Finished 7 from 16 processes
2026-05-06 01:45:02,126 Finished 7 from 16 processes
2026-05-06 01:45:07,130 Finished 7 from 16 processes
2026-05-06 01:45:12,134 Finished 7 from 16 processes
2026-05-06 01:45:17,138 Finished 7 from 16 processes
2026-05-06 01:45:22,142 Finished 7 from 16 processes
2026-05-06 01:45:27,145 Finished 7 from 16 processes
2026-05-06 01:45:32,150 Finished 7 from 16 processes
2026-05-06 01:45:37,154 Finished 7 from 16 processes
2026-05-06 01:45:42,158 Finished 7 from 16 processes
2026-05-06 01:45:47,162 Finished 7 from 16 processes
2026-05-06 01:45:52,166 Finished 7 from 16 processes
2026-05-06 01:45:57,170 Finished 7 from 16 processes
2026-05-06 01:46:02,174 Finished 7 from 16 processes
2026-05-06 01:46:07,178 Finished 7 from 16 processes
2026-05-06 01:46:12,182 Finished 7 from 16 processes
2026-05-06 01:46:17,186 Finished 7 from 16 processes
2026-05-06 01:46:22,191 Finished 7 from 16 processes
2026-05-06 01:46:27,196 Finished 7 from 16 processes
2026-05-06 01:46:32,198 Finished 7 from 16 processes
2026-05-06 01:46:37,202 Finished 7 from 16 processes
2026-05-06 01:46:42,206 Finished 7 from 16 processes
2026-05-06 01:46:47,210 Finished 7 from 16 processes
2026-05-06 01:46:52,214 Finished 7 from 16 processes
2026-05-06 01:46:57,218 Finished 7 from 16 processes
2026-05-06 01:47:02,222 Finished 7 from 16 processes
2026-05-06 01:47:07,226 Finished 7 from 16 processes
2026-05-06 01:47:12,230 Finished 7 from 16 processes
2026-05-06 01:47:17,234 Finished 7 from 16 processes
2026-05-06 01:47:22,238 Finished 7 from 16 processes
2026-05-06 01:47:27,242 Finished 7 from 16 processes
2026-05-06 01:47:32,246 Finished 7 from 16 processes
2026-05-06 01:47:37,250 Finished 7 from 16 processes
2026-05-06 01:47:42,258 Finished 7 from 16 processes
2026-05-06 01:47:47,262 Finished 7 from 16 processes
2026-05-06 01:47:52,266 Finished 7 from 16 processes
2026-05-06 01:47:57,270 Finished 7 from 16 processes
2026-05-06 01:48:02,274 Finished 7 from 16 processes
2026-05-06 01:48:07,278 Finished 7 from 16 processes
2026-05-06 01:48:12,282 Finished 7 from 16 processes
2026-05-06 01:48:17,286 Finished 7 from 16 processes
2026-05-06 01:48:22,290 Finished 7 from 16 processes
2026-05-06 01:48:27,294 Finished 7 from 16 processes
2026-05-06 01:48:32,299 Finished 7 from 16 processes
2026-05-06 01:48:37,302 Finished 7 from 16 processes
2026-05-06 01:48:42,306 Finished 7 from 16 processes
2026-05-06 01:48:47,310 Finished 7 from 16 processes
2026-05-06 01:48:52,314 Finished 7 from 16 processes
2026-05-06 01:48:57,318 Finished 7 from 16 processes
2026-05-06 01:49:02,322 Finished 7 from 16 processes
2026-05-06 01:49:07,326 Finished 7 from 16 processes
2026-05-06 01:49:12,330 Finished 7 from 16 processes
2026-05-06 01:49:17,334 Finished 7 from 16 processes
2026-05-06 01:49:22,338 Finished 7 from 16 processes
2026-05-06 01:49:27,342 Finished 7 from 16 processes
2026-05-06 01:49:32,346 Finished 7 from 16 processes
2026-05-06 01:49:37,350 Finished 7 from 16 processes
2026-05-06 01:49:42,354 Finished 7 from 16 processes
2026-05-06 01:49:47,358 Finished 7 from 16 processes
2026-05-06 01:49:52,361 Finished 7 from 16 processes
2026-05-06 01:49:57,366 Finished 7 from 16 processes
2026-05-06 01:50:02,370 Finished 7 from 16 processes
2026-05-06 01:50:07,374 Finished 7 from 16 processes
2026-05-06 01:50:12,378 Finished 7 from 16 processes
2026-05-06 01:50:17,382 Finished 7 from 16 processes
2026-05-06 01:50:22,386 Finished 7 from 16 processes
2026-05-06 01:50:27,388 Finished 7 from 16 processes
2026-05-06 01:50:32,390 Finished 7 from 16 processes
2026-05-06 01:50:37,394 Finished 8 from 16 processes
2026-05-06 01:50:42,398 Finished 8 from 16 processes
2026-05-06 01:50:47,402 Finished 8 from 16 processes
2026-05-06 01:50:52,406 Finished 8 from 16 processes
2026-05-06 01:50:57,410 Finished 8 from 16 processes
2026-05-06 01:51:02,414 Finished 8 from 16 processes
2026-05-06 01:51:07,418 Finished 8 from 16 processes
2026-05-06 01:51:12,422 Finished 8 from 16 processes
2026-05-06 01:51:17,426 Finished 8 from 16 processes
2026-05-06 01:51:22,430 Finished 8 from 16 processes
2026-05-06 01:51:27,434 Finished 8 from 16 processes
2026-05-06 01:51:32,438 Finished 8 from 16 processes
2026-05-06 01:51:37,441 Finished 8 from 16 processes
2026-05-06 01:51:42,446 Finished 8 from 16 processes
2026-05-06 01:51:47,450 Finished 8 from 16 processes
2026-05-06 01:51:52,454 Finished 8 from 16 processes
2026-05-06 01:51:57,458 Finished 8 from 16 processes
2026-05-06 01:52:02,462 Finished 8 from 16 processes
2026-05-06 01:52:07,466 Finished 8 from 16 processes
2026-05-06 01:52:12,470 Finished 8 from 16 processes
2026-05-06 01:52:17,474 Finished 8 from 16 processes
2026-05-06 01:52:22,478 Finished 8 from 16 processes
2026-05-06 01:52:27,482 Finished 8 from 16 processes
2026-05-06 01:52:32,486 Finished 8 from 16 processes
2026-05-06 01:52:37,490 Finished 8 from 16 processes
2026-05-06 01:52:42,494 Finished 8 from 16 processes
2026-05-06 01:52:47,498 Finished 8 from 16 processes
2026-05-06 01:52:52,502 Finished 8 from 16 processes
2026-05-06 01:52:57,506 Finished 8 from 16 processes
2026-05-06 01:53:02,510 Finished 8 from 16 processes
2026-05-06 01:53:07,514 Finished 8 from 16 processes
2026-05-06 01:53:12,518 Finished 8 from 16 processes
2026-05-06 01:53:17,522 Finished 8 from 16 processes
2026-05-06 01:53:22,526 Finished 8 from 16 processes
2026-05-06 01:53:27,530 Finished 8 from 16 processes
2026-05-06 01:53:32,534 Finished 8 from 16 processes
2026-05-06 01:53:37,539 Finished 8 from 16 processes
2026-05-06 01:53:42,542 Finished 8 from 16 processes
2026-05-06 01:53:47,546 Finished 8 from 16 processes
2026-05-06 01:53:52,550 Finished 8 from 16 processes
2026-05-06 01:53:57,554 Finished 8 from 16 processes
2026-05-06 01:54:02,558 Finished 8 from 16 processes
2026-05-06 01:54:07,562 Finished 8 from 16 processes
2026-05-06 01:54:12,566 Finished 8 from 16 processes
2026-05-06 01:54:17,570 Finished 8 from 16 processes
2026-05-06 01:54:22,574 Finished 8 from 16 processes
2026-05-06 01:54:27,578 Finished 8 from 16 processes
2026-05-06 01:54:32,582 Finished 8 from 16 processes
2026-05-06 01:54:37,586 Finished 8 from 16 processes
2026-05-06 01:54:42,590 Finished 8 from 16 processes
2026-05-06 01:54:47,596 Finished 8 from 16 processes
2026-05-06 01:54:52,598 Finished 8 from 16 processes
2026-05-06 01:54:57,602 Finished 8 from 16 processes
2026-05-06 01:55:02,606 Finished 8 from 16 processes
2026-05-06 01:55:07,610 Finished 8 from 16 processes
2026-05-06 01:55:12,614 Finished 8 from 16 processes
2026-05-06 01:55:17,618 Finished 9 from 16 processes
2026-05-06 01:55:22,622 Finished 9 from 16 processes
2026-05-06 01:55:27,626 Finished 9 from 16 processes
2026-05-06 01:55:32,630 Finished 9 from 16 processes
2026-05-06 01:55:37,634 Finished 9 from 16 processes
2026-05-06 01:55:42,638 Finished 9 from 16 processes
2026-05-06 01:55:47,642 Finished 9 from 16 processes
2026-05-06 01:55:52,646 Finished 9 from 16 processes
2026-05-06 01:55:57,649 Finished 9 from 16 processes
2026-05-06 01:56:02,654 Finished 9 from 16 processes
2026-05-06 01:56:07,655 Finished 9 from 16 processes
2026-05-06 01:56:12,658 Finished 9 from 16 processes
2026-05-06 01:56:17,662 Finished 9 from 16 processes
2026-05-06 01:56:22,666 Finished 9 from 16 processes
2026-05-06 01:56:27,670 Finished 9 from 16 processes
2026-05-06 01:56:32,674 Finished 9 from 16 processes
2026-05-06 01:56:37,679 Finished 9 from 16 processes
2026-05-06 01:56:42,683 Finished 9 from 16 processes
2026-05-06 01:56:47,686 Finished 10 from 16 processes
2026-05-06 01:56:52,690 Finished 11 from 16 processes
2026-05-06 01:56:57,694 Finished 11 from 16 processes
2026-05-06 01:57:02,698 Finished 12 from 16 processes
2026-05-06 01:57:07,702 Finished 12 from 16 processes
2026-05-06 01:57:12,706 Finished 12 from 16 processes
2026-05-06 01:57:17,710 Finished 13 from 16 processes
2026-05-06 01:57:22,714 Finished 13 from 16 processes
2026-05-06 01:57:27,719 Finished 14 from 16 processes
2026-05-06 01:57:32,722 Finished 15 from 16 processes
2026-05-06 01:57:37,726 Finished 15 from 16 processes
2026-05-06 01:57:42,731 Finished 15 from 16 processes
2026-05-06 01:57:47,734 Finished 15 from 16 processes
2026-05-06 01:57:52,738 All processes finished
2026-05-06 01:57:52,738 Compressing stress logs
2026-05-06 01:57:52,818 Logs compressed
2026-05-06 01:57:52,818 Will terminate gdb (if any)
2026-05-06 01:57:52,818 Running command: kill -TERM $(pidof gdb)
2026-05-06 01:57:52,827 Running command: timeout 50s tail --pid=$(pidof gdb) -f /dev/null || kill -9 $(pidof gdb) ||:
2026-05-06 01:57:53,847 Running command: kill -CONT $(cat /var/run/clickhouse-server/clickhouse-server.pid) && clickhouse client -q 'SELECT 1 FORMAT Null'
2026-05-06 01:57:54,263 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
2026-05-06 01:57:54,529 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
2026-05-06 01:57:54,695 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
2026-05-06 01:57:54,861 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
2026-05-06 01:57:55,077 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
2026-05-06 01:57:55,243 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
2026-05-06 01:57:55,409 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
2026-05-06 01:57:55,575 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
2026-05-06 01:57:55,741 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
2026-05-06 01:57:55,907 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
2026-05-06 01:57:56,123 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
2026-05-06 01:57:56,288 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
2026-05-06 01:57:56,454 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
2026-05-06 01:57:58,688 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.10546.altinitytest @ 0449ce3ecb43b1b0414a759c58fe0057dd73ec82 HEAD
Running 1 stateless tests (MainProcess).
00001_select_1: [ OK ]
1 tests passed. 0 tests skipped. 0.54 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. 14141 0.057 2.12 MiB 0.054 6340 109 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {}
2. 14089 0.057 2.89 MiB 0.073 1 111 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {})
3. 12819 0.052 1.30 MiB 0.033 1 76 ['Trace'] 0.19 Checking existence of path: {}
4. 11243 0.046 288.35 KiB 0.007 1 151 ['Trace'] 0.004 Query to stage {}{}
5. 11185 0.045 551.09 KiB 0.014 1 151 ['Trace'] 0.004 Query from stage {} to stage {}{}
6. 11049 0.045 311.89 KiB 0.008 1 109 ['Debug'] 0.029 Processed in {} sec.
7. 7562 0.031 599.89 KiB 0.015 1 91 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec.
8. 6363 0.026 322.90 KiB 0.008 6363 116 ['Debug'] 0.999 Authenticating user '{}' from {}
9. 6361 0.026 714.37 KiB 0.018 6361 116 ['Debug'] 0.999 {} Authenticated with global context as user {}
10. 6352 0.026 465.23 KiB 0.012 6352 109 ['Debug'] 1 Creating session context with user_id: {}
11. 6342 0.026 557.40 KiB 0.014 6342 115 ['Debug'] 0.999 {} Logout, user_id: {}
12. 5932 0.024 251.69 KiB 0.006 1 133 ['Trace'] 1 is disk {} eligible for search: {}
13. 5444 0.022 262.56 KiB 0.006 1 125 ['Debug'] 0.24 Peak memory usage{}: {}.
14. 4684 0.019 329.53 KiB 0.008 1 603 ['Trace'] 0.783 Reserved {} on local disk {}, having unreserved {}.
15. 4554 0.019 529.67 KiB 0.013 195 233 ['Trace'] 0.504 Renaming temporary part {} to {} with tid {}.
16. 4548 0.018 315.42 KiB 0.008 198 585 ['Trace'] 0.786 Trying to reserve {} using storage policy from min volume index {}
17. 4349 0.018 203.43 KiB 0.005 1 229 ['Trace'] 0.484 filled checksums {}
18. 4206 0.017 390.04 KiB 0.01 1 40 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part
19. 4198 0.017 188.44 KiB 0.005 1 3 ['Trace'] 1 Processing requests batch, size: {}, bytes: {}
20. 3325 0.014 299.85 KiB 0.007 1 109 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}.
21. 3325 0.014 112.13 KiB 0.003 2 109 ['Trace'] 1 TCP Request. Address: {}
22. 3228 0.013 85.11 KiB 0.002 1 108 ['Debug'] 1 Done processing connection.
23. 3211 0.013 575.34 KiB 0.014 2 83 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {}
24. 3209 0.013 6.93 MiB 0.176 2 83 ['Trace'] 1 Request URI: {}
25. 3030 0.012 62.14 KiB 0.002 2 83 ['Debug'] 0.059 Done processing query
26. 2095 0.009 120.55 KiB 0.003 16 38 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {}
27. 2093 0.009 74.24 KiB 0.002 16 38 ['Trace'] 1 Flushed system log up to offset {}
28. 2000 0.008 83.98 KiB 0.002 213 132 ['Debug'] 0.173 Found {} non used tables in detached tables.
29. 2000 0.008 119.14 KiB 0.003 213 132 ['Debug'] 0.173 There are {} detached tables. Start searching non used tables.
30. 1832 0.007 163.29 KiB 0.004 1 204 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.)
31. 1584 0.006 162.03 KiB 0.004 1 7 ['Trace'] 0.5 Adding file: {}, size: {}
32. 1540 0.006 34.59 KiB 0.001 1 204 ['Trace'] 0 Merging aggregated data
33. 1417 0.006 42.15 KiB 0.001 1 203 ['Trace'] 0 Aggregation method: {}
34. 1409 0.006 108.70 KiB 0.003 1 90 ['Trace'] 0 Query span trace_id for opentelemetry log: {}
35. 1307 0.005 104.21 KiB 0.003 1 46 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {}
36. 1307 0.005 44.65 KiB 0.001 1 46 ['Debug'] 0 Selected MergeAlgorithm: {}
37. 1267 0.005 97.75 KiB 0.002 1 1 ['Debug'] 1 Restarting waiting for CQEs due to: {}
38. 1263 0.005 161.66 KiB 0.004 1 45 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec.
39. 1154 0.005 128.58 KiB 0.003 1 35 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {}
40. 1115 0.005 140.31 KiB 0.003 1 6 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {}
41. 1037 0.004 81.97 KiB 0.002 24 124 ['Trace'] 0.894 Part {} is not stored on zero-copy replicated disk, blobs can be removed
42. 1002 0.004 2.59 MiB 0.066 10 467 ['Error'] 1 Table is in readonly mode (replica path: {})
43. 870 0.004 29.50 KiB 0.001 153 99 ['Debug'] 0.051 Key condition: {}
44. 868 0.004 38.14 KiB 0.001 152 99 ['Trace'] 0.051 Filtering marks by primary and secondary keys
45. 861 0.003 84.99 KiB 0.002 23 423 ['Trace'] 1 Scheduling next cleanup after {}ms (points: {}, interval: {}ms, ratio: {}, points per minute: {})
46. 857 0.003 18.58 KiB 0 86 442 ['Trace'] 1 Execution took {} ms.
47. 829 0.003 94.70 KiB 0.002 148 97 ['Debug'] 0.051 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges
48. 809 0.003 59.80 KiB 0.001 22 16 ['Trace'] 1 Executing log entry to merge parts {} to {}
49. 783 0.003 8.41 KiB 0 1 192 ['Trace'] 0 Aggregating
50. 779 0.003 3.17 MiB 0.08 15 113 ['Error','Warning'] 0.122 Cannot schedule a task: {} (threads={}, jobs={})
51. 765 0.003 100.11 KiB 0.002 1 16 ['Information'] 1 Part {} already exists, but it will be deleted soon
52. 754 0.003 43.61 KiB 0.001 2 12 ['Trace'] 0.984 Loading config file '{}'.
53. 725 0.003 37.52 KiB 0.001 124 93 ['Trace'] 0.058 Spreading mark ranges among streams (default reading)
54. 699 0.003 55.67 KiB 0.001 1 191 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={}
55. 698 0.003 27.95 KiB 0.001 13 169 ['Trace'] 0 Sending external_roles with query: [{}] ({})
56. 693 0.003 56.42 KiB 0.001 103 51 ['Trace'] 0.001 Reading {} ranges in{}order from part {}, approx. {} rows starting from {}
57. 650 0.003 55.64 KiB 0.001 31 378 ['Trace'] 1 Scheduling next merge selecting task after {}ms, current attempt status: {}
58. 640 0.003 64.32 KiB 0.002 93 75 ['Debug'] 0.977 Removing {} parts from filesystem (serially): Parts: [{}]
59. 596 0.002 49.43 KiB 0.001 43 36 ['Debug'] 0.975 Removing {} parts from memory: Parts: [{}]
60. 594 0.002 48.75 KiB 0.001 41 34 ['Trace'] 0.978 Found {} old parts to remove. Parts: [{}]
61. 587 0.002 18.38 KiB 0 20 19 ['Debug'] 0.012 Requested flush up to offset {}
62. 562 0.002 45.33 KiB 0.001 1 177 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={}
63. 530 0.002 46.15 KiB 0.001 28 279 ['Trace'] 0.979 Insert entry {} to queue with type {}
64. 516 0.002 20.19 KiB 0 1 180 ['Debug'] 0.581 Spawn loader worker #{} in {}
65. 516 0.002 14.63 KiB 0 1 227 ['Debug'] 1 Stop worker in {}
66. 515 0.002 38.72 KiB 0.001 1 47 ['Debug'] 0.157 Schedule load job '{}' into {}
67. 515 0.002 37.21 KiB 0.001 1 168 ['Debug'] 1 Execute load job '{}' in {}
68. 515 0.002 35.18 KiB 0.001 1 168 ['Debug'] 1 Finish load job '{}' with status {}
69. 512 0.002 26.91 KiB 0.001 39 376 ['Debug'] 0.932 Selected {} parts from {} to {}
70. 504 0.002 46.30 KiB 0.001 1 48 ['Debug'] 0.107 Prioritize load job '{}': {} -> {}
71. 498 0.002 31.72 KiB 0.001 41 45 ['Trace'] 0 Merged {} parts: [{}, {}] -> {}
72. 488 0.002 62.23 KiB 0.002 1 2 ['Trace'] 1 Creating part at path {}
73. 483 0.002 79.18 KiB 0.002 1 46 ['Trace'] 0 No query result found for query {}
74. 481 0.002 59.88 KiB 0.001 1 120 ['Debug'] 0 Going to respond to replica {} with {}; mine_marks={}, stolen_by_hash={}, stolen_rest={}
75. 481 0.002 27.34 KiB 0.001 1 120 ['Trace'] 0 Handling request from replica {}, minimal marks size is {}
76. 472 0.002 65.63 KiB 0.002 24 310 ['Trace'] 1 Checked {} partitions, found {} partitions with parts that may be merged: [{}] (max_total_size_to_merge={}, merge_with_ttl_allowed={})
77. 454 0.002 23.49 KiB 0.001 21 110 ['Trace'] 0.963 Loading {} part {} from disk {}
78. 454 0.002 26.60 KiB 0.001 21 110 ['Trace'] 0.963 Finished loading {} part {} on disk {}
79. 453 0.002 15.03 KiB 0 1 189 ['Debug'] 0.528 Change current priority: {} -> {}
80. 450 0.002 82.05 KiB 0.002 1 38 ['Trace'] 0 PREWHERE condition was split into {} steps: {}
81. 442 0.002 22.60 KiB 0.001 15 141 ['Trace'] 0 Connecting. Database: {}. User: {}{}{}
82. 437 0.002 3.84 KiB 0 2 47 ['Trace'] 0.018 No tables
83. 410 0.002 12.13 KiB 0 22 126 ['Trace'] 0 Found (RIGHT) boundary mark: {}
84. 410 0.002 27.56 KiB 0.001 22 126 ['Trace'] 0 Running binary search on index range for part {} ({} marks)
85. 410 0.002 11.70 KiB 0 22 126 ['Trace'] 0 Found (LEFT) boundary mark: {}
86. 410 0.002 13.22 KiB 0 22 126 ['Trace'] 0 Found {} range {}in {} steps
87. 389 0.002 26.54 KiB 0.001 1 40 ['Trace'] 0 Condition {} moved to PREWHERE
88. 385 0.002 59.69 KiB 0.001 1 41 ['Trace'] 0 Stored query result of query {}
89. 380 0.002 17.44 KiB 0 13 120 ['Trace'] 0 Connected to {} server version {}.{}.{}.
90. 379 0.002 21.84 KiB 0.001 28 279 ['Debug'] 0.987 Pulling {} entries to queue: {} - {}
91. 379 0.002 9.62 KiB 0 28 279 ['Debug'] 0.987 Pulled {} entries to queue.
92. 362 0.001 26.37 KiB 0.001 1 43 ['Trace'] 0 The min valid primary key position for moving to the tail of PREWHERE is {}
93. 361 0.001 57.96 KiB 0.001 13 111 ['Debug'] 0 Sent data for {} scalars, total {} rows in {} sec., {} rows/sec., {} ({}/sec.), compressed {} times to {} ({}/sec.)
94. 338 0.001 28.14 KiB 0.001 1 33 ['Debug'] 0 mark_segment_size={}, min_marks_per_task*threads={}, sum_marks/number_of_replicas^2={}
95. 338 0.001 8.12 KiB 0 1 33 ['Debug'] 0 Chosen segment size: {}
96. 336 0.001 9.84 KiB 0 31 259 ['Debug'] 0.94 Updating strategy picker state
97. 332 0.001 40.83 KiB 0.001 1 107 ['Debug'] 0 Initial request: {}
98. 332 0.001 13.62 KiB 0 1 107 ['Debug'] 0 Sent initial requests: {} Replicas count: {}
99. 331 0.001 901.83 KiB 0.022 2 45 ['Error'] 0.97 Setting {} should not be changed
100. 327 0.001 5.75 KiB 0 287 103 ['Debug'] 0.147 Loading data parts
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. 44 CodeDBExceptionReceivedfromDBExc Code: 81. DB::Exception: Received from 127.0.0.1:9000. DB::Exception: Database test_ocor0zmf does not exist. Stack trace:
0. /build/contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x00000000164a1872
1. / ('/executeQuery.cpp',221)
2. 6 IfthesignaturecheckfailedThiscou If the signature check failed. This could be because of a time skew. Attempting to adjust the signer. ('/AWSLogger.cpp',71)
3. 3 PRIORITYdecaytargetmine [PRIORITY] decay, target 1 -> 1, mine 1 ('/LoggerWrapper.h',43)
4. 3 Connectiontomysqlfailedtimes Connection to mysql failed 1 times ('',0)
5. 3 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 0 ('/LoggerWrapper.h',43)
6. 3 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1
my id: 1, voting_member
num peers: 0 ('/LoggerWrapper.h',43)
7. 3 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',43)
8. 3 newconfiglogidxprevlogidxcurconf new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0 ('/LoggerWrapper.h',43)
9. 3 startingup starting up ('',0)
10. 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)
11. 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)
12. 3 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',43)
13. 3 numberofpendingcommitelements number of pending commit elements: 0 ('/LoggerWrapper.h',43)
14. 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)
15. 3 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',43)
16. 3 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',43)
17. 3 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',43)
18. 3 statemachinecommitindexprecommit state machine commit index 0, precommit index 0, last log index 0 ('/LoggerWrapper.h',43)
19. 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)
20. 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)
21. 3 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',43)
22. 3 StartingClickHousealtinitytestre Starting ClickHouse 24.8.14.10546.altinitytest (revision: 4294967295, git hash: 0449ce3ecb43b1b0414a759c58fe0057dd73ec82, build id: 7783ACD8D17E08885F96EF3FB5272180FDE52BFF), PID 414 ('',0)
23. 3 RaftASIOlistenerinitiatedonunsec Raft ASIO listener initiated on :::9234, unsecured ('/LoggerWrapper.h',43)
24. 3 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 1 ('/LoggerWrapper.h',43)
25. 3 newelectiontimeoutrange new election timeout range: 0 - 0 ('/LoggerWrapper.h',43)
26. 3 Forkedachildprocesstowatch Forked a child process to watch ('',0)
27. 3 Connectiontomysqldbasusermysqlus Connection to mysql_db@127.123.0.1:3306 as user mysql_user failed: mysqlxx::ConnectionFailed: Can't connect to MySQL server on '127.123.0.1' (115) ((nullptr):0) ('',0)
28. 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. {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 131 /var/lib/clickhouse/store/693/6931b7c5-5074-4e8d-938f-af50e69a7b56/tmp_insert_201403_5_5_0/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 3 similar messages)
2. 83 Forked a child process to watch
3. (from {}{}{}){}{} {} (stage: {}) 1 (from [::1]:55434) (comment: 02685_bson2.sql) -- It correctly throws exception about incorrect data:
SELECT * FROM format('BSONEachRow', '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 Int16, 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, WindowName 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', $$^ WatchID c*5/ !p~JavaEnable Title GoodEvent EventTime 7�Q EventDate > CounterID ClientIP �z�RegionID G UserID � �:6�CounterClass OS UserAgent URL Referer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor �OCookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion2 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID OriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime &�Q Age Sex Income Interests Robotness RemoteIP ^DI�WindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �|3�b.�CLID ^ WatchID �F�ӓ2qJavaEnable Title GoodEvent EventTime n$�Q EventDate > CounterID ClientIP �z�RegionID G UserID � �:6�CounterClass OS UserAgent URL Referer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor �OCookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID OriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime ǘ�Q Age Sex Income Interests Robotness RemoteIP ^DI�WindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �|3�b.�CLID ^ WatchID l!�|�@HJavaEnable Title GoodEvent EventTime �)�Q EventDate > CounterID ClientIP �z�RegionID G UserID � �:6�CounterClass OS UserAgent URL Referer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor �OCookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID OriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime }�Q Age Sex Income Interests Robotness RemoteIP ^DI�WindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �|3�b.�CLID ^ WatchID �ǐ=ЌWJavaEnable Title GoodEvent EventTime 8*�Q EventDate > CounterID ClientIP �z�RegionID G UserID � �:6�CounterClass OS UserAgent URL Referer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor �OCookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID OriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime ݞ�Q Age Sex Income Interests Robotness RemoteIP ^DI�WindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �|3�b.�CLID � WatchID �E&LyJavaEnable Title GoodEvent EventTime J�Q EventDate > CounterID ClientIP �I`RegionID ' UserID q�Jd8CounterClass OS UserAgent URL - http://holodilnik.ru/russia/05jul2013&model=0Referer IsRefresh RefererCategoryID RefererRegionID URLCategoryID �9 URLRegionID ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor
UserAgentMinor D�CookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �d9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID %�l�+kOriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime '�Q Age Sex Income Interests �: Robotness RemoteIP 9�3NWindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �
o�eCLID � WatchID �k=�pJavaEnable Title GoodEvent EventTime ��Q EventDate > CounterID ClientIP �z�RegionID G UserID
�Ks}�CounterClass OS UserAgent URL H http://afisha.mail.ru/catalog/314/women.ru/ency=1&page3/?errovat-pinnikiReferer IsRefresh RefererCategoryID RefererRegionID URLCategoryID 0= URLRegionID � ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor D�CookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID :�W�mOriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime A�Q Age Sex Income Interests Robotness RemoteIP ^DI�WindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �
�#�\CLID � WatchID �1�o�CJavaEnable Title GoodEvent EventTime �0�Q EventDate > CounterID ClientIP �^{]RegionID � UserID &n%�t"6CounterClass OS ' UserAgent URL > http://bonprix.ru/index.ru/cinema/art/0 986 424 233 сезонReferer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID � ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor Fla⋯
Top short messages:
c message_format_string substr(any(toValidUTF8(message)), 1, 120) min_length_without_exception_boilerplate
1. 17 Cannot TRUNCATE dictionary Code: 62. DB::Exception: Cannot TRUNCATE dictionary. (SYNTAX_ERROR) (version 24.8.14.10546.altinitytest (altinity build) 27
2. 17 {} Server was built in debug mode. It will work slowly. 26
3. 5 Found {} on {} Found snapshot_12.bin.zstd on LocalSnapshotDisk 18
4. 1 Creating {}: {} Creating table test_5.test: CREATE TABLE IF NOT EXISTS test_5.test UUID 'b1b1c8a8-877a-4c5d-ab62-ca9b548e8803' (`test` S 170
Top messages by level:
(0.004071035920188194,'Table is in readonly mode (replica path: {})') Error
(0.000280340796899187,'Client has gone away.') Warning
(0.0031081262264909862,'Part {} already exists, but it will be deleted soon') Information
(0.057242340398734,'(from {}{}{}){}{} {} (stage: {})') Debug
(0.05745361172393339,'{} Creating query context from {} context, user_id: {}, parent context user: {}') Trace
2026-05-06 01:58:03,023 Stress test finished
+ echo -e 'Test script exit code\tOK\t\N\t'
+ grep -Fa OK
+ rg -Fa 'No queries hung' /test_output/test_results.tsv
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=2972
+ clickhouse stop --max-tries 90 --do-not-kill
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2972.
The process with pid = 2972 is running.
Sent terminate signal to process with pid 2972.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2972.
The process with pid = 2972 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2972.
The process with pid = 2972 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2972.
The process with pid = 2972 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2972.
The process with pid = 2972 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2972.
The process with pid = 2972 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2972.
The process with pid = 2972 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2972.
The process with pid = 2972 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2972.
The process with pid = 2972 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'
127.0.0.1 - - [05/May/2026:23:58:12 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 -
127.0.0.1 - - [05/May/2026:23:58:12 +0000] "PUT /devstoreaccount1/cont/osomzppongvjjvjievlvhoaqoeyehwrb HTTP/1.1" 201 -
127.0.0.1 - - [05/May/2026:23:58:12 +0000] "GET /devstoreaccount1/cont/osomzppongvjjvjievlvhoaqoeyehwrb HTTP/1.1" 206 4
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
127.0.0.1 - - [05/May/2026:23:58:12 +0000] "GET /devstoreaccount1/cont/osomzppongvjjvjievlvhoaqoeyehwrb HTTP/1.1" 206 2
127.0.0.1 - - [05/May/2026:23:58:12 +0000] "DELETE /devstoreaccount1/cont/osomzppongvjjvjievlvhoaqoeyehwrb HTTP/1.1" 202 -
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
++ [[ hxB =~ e ]]
++ set_e=false
++ set +e
++ local total_retries=5
++ shift
++ local retry=0
++ '[' 0 -ge 5 ']'
++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
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 39306
+ 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=39306
+ 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 = 39306.
The process with pid = 39306 is running.
Sent terminate signal to process with pid 39306.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 39306.
The process with pid = 39306 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 39306.
The process with pid = 39306 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 39306.
The process with pid = 39306 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 39306.
The process with pid = 39306 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 39306.
The process with pid = 39306 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 - - [05/May/2026:23:58:45 +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 - - [05/May/2026:23:58:49 +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 - - [05/May/2026:23:58:51 +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