+ 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
+ source /stress_tests.lib
++ sysctl kernel.core_pattern=core.%e.%p-%P
kernel.core_pattern = core.%e.%p-%P
++ OK='\tOK\t\N\t'
++ FAIL='\tFAIL\t\N\t'
++ FAILURE_CONTEXT_LINES=100
++ FAILURE_CONTEXT_MAX_LINE_WIDTH=300
+ install_packages package_folder
+ dpkg -i package_folder/clickhouse-common-static_24.3.5.47.altinitystable+msan_amd64.deb
Selecting previously unselected package clickhouse-common-static.
(Reading database ... 49227 files and directories currently installed.)
Preparing to unpack .../clickhouse-common-static_24.3.5.47.altinitystable+msan_amd64.deb ...
Unpacking clickhouse-common-static (24.3.5.47.altinitystable+msan) ...
Setting up clickhouse-common-static (24.3.5.47.altinitystable+msan) ...
+ dpkg -i package_folder/clickhouse-common-static-dbg_24.3.5.47.altinitystable+msan_amd64.deb
Selecting previously unselected package clickhouse-common-static-dbg.
(Reading database ... 49256 files and directories currently installed.)
Preparing to unpack .../clickhouse-common-static-dbg_24.3.5.47.altinitystable+msan_amd64.deb ...
Unpacking clickhouse-common-static-dbg (24.3.5.47.altinitystable+msan) ...
Setting up clickhouse-common-static-dbg (24.3.5.47.altinitystable+msan) ...
+ dpkg -i package_folder/clickhouse-server_24.3.5.47.altinitystable+msan_amd64.deb
Selecting previously unselected package clickhouse-server.
(Reading database ... 49265 files and directories currently installed.)
Preparing to unpack .../clickhouse-server_24.3.5.47.altinitystable+msan_amd64.deb ...
Unpacking clickhouse-server (24.3.5.47.altinitystable+msan) ...
Setting up clickhouse-server (24.3.5.47.altinitystable+msan) ...
ClickHouse binary is already located at /usr/bin/clickhouse
Symlink /usr/bin/clickhouse-server already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-server to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-client to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-local to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-benchmark to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-obfuscator to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-git-import to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-compressor to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-format to /usr/bin/clickhouse.
Symlink /usr/bin/clickhouse-extract-from-config already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-extract-from-config to /usr/bin/clickhouse.
Symlink /usr/bin/clickhouse-keeper already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-keeper to /usr/bin/clickhouse.
Symlink /usr/bin/clickhouse-keeper-converter already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-keeper-converter to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-disks to /usr/bin/clickhouse.
Creating symlink /usr/bin/ch to /usr/bin/clickhouse.
Creating symlink /usr/bin/chl to /usr/bin/clickhouse.
Creating symlink /usr/bin/chc to /usr/bin/clickhouse.
Creating clickhouse group if it does not exist.
 groupadd -r clickhouse
Creating clickhouse user if it does not exist.
 useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse clickhouse
Will set ulimits for clickhouse user in /etc/security/limits.d/clickhouse.conf.
Creating config directory /etc/clickhouse-server/config.d that is used for tweaks of main server configuration.
Creating config directory /etc/clickhouse-server/users.d that is used for tweaks of users configuration.
Config file /etc/clickhouse-server/config.xml already exists, will keep it and extract path info from it.
/etc/clickhouse-server/config.xml has /var/lib/clickhouse/ as data path.
/etc/clickhouse-server/config.xml has /var/log/clickhouse-server/ as log path.
Users config file /etc/clickhouse-server/users.xml already exists, will keep it and extract users info from it.
Log directory /var/log/clickhouse-server/ already exists.
Creating data directory /var/lib/clickhouse/.
Creating pid directory /var/run/clickhouse-server.
 chown -R clickhouse:clickhouse '/var/log/clickhouse-server/'
 chown -R clickhouse:clickhouse '/var/run/clickhouse-server'
 chown  clickhouse:clickhouse '/var/lib/clickhouse/'
 groupadd -r clickhouse-bridge
 useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse-bridge clickhouse-bridge
 chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-odbc-bridge'
 chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-library-bridge'
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.3.5.47.altinitystable+msan_amd64.deb
Selecting previously unselected package clickhouse-client.
(Reading database ... 49282 files and directories currently installed.)
Preparing to unpack .../clickhouse-client_24.3.5.47.altinitystable+msan_amd64.deb ...
Unpacking clickhouse-client (24.3.5.47.altinitystable+msan) ...
Setting up clickhouse-client (24.3.5.47.altinitystable+msan) ...
+ export THREAD_FUZZER_CPU_TIME_PERIOD_US=1000
+ THREAD_FUZZER_CPU_TIME_PERIOD_US=1000
+ export THREAD_FUZZER_SLEEP_PROBABILITY=0.1
+ THREAD_FUZZER_SLEEP_PROBABILITY=0.1
+ export THREAD_FUZZER_SLEEP_TIME_US_MAX=100000
+ THREAD_FUZZER_SLEEP_TIME_US_MAX=100000
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000
+ export THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01
+ THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01
+ export THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01
+ THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01
+ export ZOOKEEPER_FAULT_INJECTION=1
+ ZOOKEEPER_FAULT_INJECTION=1
+ configure
+ export USE_DATABASE_ORDINARY=1
+ USE_DATABASE_ORDINARY=1
+ export EXPORT_S3_STORAGE_POLICIES=1
+ EXPORT_S3_STORAGE_POLICIES=1
+ /usr/share/clickhouse-test/config/install.sh
+ DEST_SERVER_PATH=/etc/clickhouse-server
+ DEST_CLIENT_PATH=/etc/clickhouse-client
+++ dirname /usr/share/clickhouse-test/config/install.sh
++ cd /usr/share/clickhouse-test/config
++ pwd -P
+ SRC_PATH=/usr/share/clickhouse-test/config
Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server
+ echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server'
+ mkdir -p /etc/clickhouse-server/config.d/
+ mkdir -p /etc/clickhouse-server/users.d/
+ mkdir -p /etc/clickhouse-client
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/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/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/reverse_dns_query_function.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/
+ '[' /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/
+ value=0
+ sed --follow-symlinks -i 's|<create_snapshot_on_exit>[01]</create_snapshot_on_exit>|<create_snapshot_on_exit>0</create_snapshot_on_exit>|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=41254912
+ sed --follow-symlinks -i 's|<latest_logs_cache_size_threshold>[[:digit:]]\+</latest_logs_cache_size_threshold>|<latest_logs_cache_size_threshold>41254912</latest_logs_cache_size_threshold>|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=16240640
+ sed --follow-symlinks -i 's|<commit_logs_cache_size_threshold>[[:digit:]]\+</commit_logs_cache_size_threshold>|<commit_logs_cache_size_threshold>16240640</commit_logs_cache_size_threshold>|' /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n '' ]]
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ARM=aarch64
++ uname -m
+ OS=x86_64
x86_64
+ [[ -n 1 ]]
+ echo x86_64
+ [[ '' -eq 1 ]]
+ [[ x86_64 == \a\a\r\c\h\6\4 ]]
+ echo 'Adding azure configuration'
+ ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/
Adding azure configuration
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|<snapshot_distance>100000</snapshot_distance>|<snapshot_distance>10000</snapshot_distance>|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value filtered_list keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|<filtered_list>[01]</filtered_list>|<filtered_list>0</filtered_list>|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value multi_read keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|<multi_read>[01]</multi_read>|<multi_read>0</multi_read>|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value check_not_exists keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|<check_not_exists>[01]</check_not_exists>|<check_not_exists>0</check_not_exists>|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value create_if_not_exists keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|<create_if_not_exists>[01]</create_if_not_exists>|<create_if_not_exists>0</create_if_not_exists>|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value use_compression zookeeper_fault_injection
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ sed 's|<use_compression>[01]</use_compression>|<use_compression>0</use_compression>|'
+ sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ randomize_config_boolean_value allow_experimental_block_number_column block_number
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/block_number.xml
+ sed 's|<allow_experimental_block_number_column>[01]</allow_experimental_block_number_column>|<allow_experimental_block_number_column>0</allow_experimental_block_number_column>|'
+ sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml
+ echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\'''
+ export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ sudo chown root: /var/lib/clickhouse
+ echo '<clickhouse><asynchronous_metrics_update_period_s>1</asynchronous_metrics_update_period_s></clickhouse>'
+ local total_mem
++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo
+ total_mem=32086448
+ total_mem=32856522752
+ max_server_memory_usage_to_ram_ratio=0.5
+ echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5'
+ cat
Setting max_server_memory_usage_to_ram_ratio to 0.5
Setting max_memory_usage_for_user=9856956825 and max_memory_usage for queries to 10G
+ local max_users_mem
+ max_users_mem=9856956825
+ echo 'Setting max_memory_usage_for_user=9856956825 and max_memory_usage for queries to 10G'
+ cat
+ cat
+ ./setup_minio.sh stateless
+ azurite-blob --blobHost 0.0.0.0 --blobPort 10000 --debug /azurite_log
+ export MINIO_ROOT_USER=clickhouse
+ MINIO_ROOT_USER=clickhouse
+ export MINIO_ROOT_PASSWORD=clickhouse
+ MINIO_ROOT_PASSWORD=clickhouse
+ main stateless
+ local query_dir
++ check_arg stateless
++ local query_dir
++ '[' '!' 1 -eq 1 ']'
++ case "$1" in
++ query_dir=0_stateless
++ echo 0_stateless
+ query_dir=0_stateless
+ '[' '!' -f ./minio ']'
+ start_minio
+ mkdir -p ./minio_data
+ ./minio --version
Azurite Blob service is starting on 0.0.0.0:10000
Azurite Blob service successfully listens on http://0.0.0.0:10000
minio version RELEASE.2022-01-03T18-22-58Z
+ wait_for_it
+ local counter=0
+ local max_counter=60
+ local url=http://localhost:11111
+ ./minio server --address :11111 ./minio_data
+ params=('--silent' '--verbose')
+ local params
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
trying to connect to minio
+ [[ 0 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
+ counter=1
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 1 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=2
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 2 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=3
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 3 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=4
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
trying to connect to minio
+ [[ 4 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
+ counter=5
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 5 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=6
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 6 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=7
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
trying to connect to minio
+ [[ 7 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
+ counter=8
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 8 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=9
+ grep AccessDenied
+ curl --silent --verbose http://localhost:11111
+ [[ 9 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=10
+ grep AccessDenied
+ curl --silent --verbose http://localhost:11111
+ [[ 10 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
API: http://172.17.0.2:11111  http://127.0.0.1:11111       

Console: http://172.17.0.2:36795 http://127.0.0.1:36795    

Documentation: https://docs.min.io

WARNING: Console endpoint is listening on a dynamic port (36795), please use --console-address ":PORT" to choose a static port.
+ counter=11
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
<Error><Code>AccessDenied</Code><Message>Access Denied.</Message><Resource>/</Resource><RequestId>17E47D923B80331B</RequestId><HostId>9d847fc0-5aa2-4e3c-a59e-b19495e462ba</HostId></Error>
+ lsof -i :11111
COMMAND PID USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
minio   290 root   10u  IPv6  33476      0t0  TCP *: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 set clickminio readwrite user=test
Policy `readwrite` is set on user `test`
+ ./mc mb clickminio/test
Bucket created successfully `clickminio/test`.
+ '[' stateless = stateless ']'
+ ./mc policy 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
++ ls /usr/share/clickhouse-test/queries/0_stateless/data_minio
+ for file in $(ls "${data_path}")
+ echo 02366_data.jsonl
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl clickminio/test/02366_data.jsonl
02366_data.jsonl
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl` -> `clickminio/test/02366_data.jsonl`
Total: 0 B, Transferred: 0 B, Speed: 0 B/s
02731.arrow
+ for file in $(ls "${data_path}")
+ echo 02731.arrow
+ ./mc cp /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.arrow` -> `clickminio/test/02731.arrow`
Total: 0 B, Transferred: 3.82 MiB, Speed: 73.27 MiB/s
02731.parquet
+ for file in $(ls "${data_path}")
+ echo 02731.parquet
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet clickminio/test/02731.parquet
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet` -> `clickminio/test/02731.parquet`
Total: 0 B, Transferred: 1.57 MiB, Speed: 51.56 MiB/s
02876.parquet
+ for file in $(ls "${data_path}")
+ echo 02876.parquet
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02876.parquet clickminio/test/02876.parquet
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/02876.parquet` -> `clickminio/test/02876.parquet`
Total: 0 B, Transferred: 293 B, Speed: 27.16 KiB/s
+ for file in $(ls "${data_path}")
+ echo a.tsv
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv clickminio/test/a.tsv
a.tsv
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv` -> `clickminio/test/a.tsv`
Total: 0 B, Transferred: 24 B, Speed: 2.08 KiB/s
b.tsv
+ for file in $(ls "${data_path}")
+ echo b.tsv
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv clickminio/test/b.tsv
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv` -> `clickminio/test/b.tsv`
Total: 0 B, Transferred: 33 B, Speed: 3.32 KiB/s
c.tsv
+ for file in $(ls "${data_path}")
+ echo c.tsv
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv clickminio/test/c.tsv
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv` -> `clickminio/test/c.tsv`
Total: 0 B, Transferred: 33 B, Speed: 3.25 KiB/s
tsv_with_header.tsv
+ for file in $(ls "${data_path}")
+ echo tsv_with_header.tsv
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv clickminio/test/tsv_with_header.tsv
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv` -> `clickminio/test/tsv_with_header.tsv`
Total: 0 B, Transferred: 44 B, Speed: 4.16 KiB/s
+ setup_aws_credentials
+ local minio_root_user=clickhouse
+ local minio_root_password=clickhouse
+ mkdir -p /root/.aws
+ cat
+ config_logs_export_cluster /etc/clickhouse-server/config.d/system_logs_export.yaml
+ set +x
File /tmp/export-logs-config.sh does not exist, do not setup
+ start_server
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+ '[' 32 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
127.0.0.1 - - [22/Jul/2024:09:04:17 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 -
127.0.0.1 - - [22/Jul/2024:09:04:17 +0000] "PUT /devstoreaccount1/cont/lxhqnlqdzmicrntslzwvhcqihnkkoxax?blockid=goeiapwrlkvsjkfzwlbdfouglxmryvuwhpjzsnxdsryvkqgqbvmxvhdfskszbgjc&comp=block HTTP/1.1" 201 -
127.0.0.1 - - [22/Jul/2024:09:04:17 +0000] "PUT /devstoreaccount1/cont/lxhqnlqdzmicrntslzwvhcqihnkkoxax?comp=blocklist HTTP/1.1" 201 -
127.0.0.1 - - [22/Jul/2024:09:04:18 +0000] "GET /devstoreaccount1/cont/lxhqnlqdzmicrntslzwvhcqihnkkoxax HTTP/1.1" 206 4
127.0.0.1 - - [22/Jul/2024:09:04:18 +0000] "GET /devstoreaccount1/cont/lxhqnlqdzmicrntslzwvhcqihnkkoxax HTTP/1.1" 206 2
127.0.0.1 - - [22/Jul/2024:09:04:18 +0000] "DELETE /devstoreaccount1/cont/lxhqnlqdzmicrntslzwvhcqihnkkoxax HTTP/1.1" 202 -
+ counter=33
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ 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
thread apply all backtrace full
info registers
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 592
+ run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
+ [[ hxB =~ e ]]
+ set_e=false
+ set +e
+ local total_retries=60
+ shift
+ local retry=0
+ '[' 0 -ge 60 ']'
+ clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
Connected to clickhouse-server after attaching gdb
+ false
+ return
+ setup_logs_replication
+ set +x
File /tmp/export-logs-config.sh does not exist, do not setup
+ clickhouse-client --query 'CREATE DATABASE datasets'
+ clickhouse-client --multiquery
+ clickhouse-client --query 'SHOW TABLES FROM datasets'
hits_v1
visits_v1
+ clickhouse-client --query 'CREATE DATABASE IF NOT EXISTS test'
+ stop_server
+ local max_tries=90
+ local check_hang=true
+ local pid
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ pid=592
+ 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 = 592.
The process with pid = 592 is running.
Sent terminate signal to process with pid 592.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 592.
The process with pid = 592 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 592.
The process with pid = 592 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 592.
The process with pid = 592 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 592.
The process with pid = 592 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 592.
The process with pid = 592 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 592.
The process with pid = 592 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.initial.log
+ cache_policy=
+ '[' 0 -eq 1 ']'
+ cache_policy=LRU
+ echo 'Using cache policy: LRU'
+ '[' LRU = SLRU ']'
+ start_server
Using cache policy: LRU
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+ '[' 39 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=40
+ clickhouse-client --query 'SELECT 1'
127.0.0.1 - - [22/Jul/2024:09:06:04 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 -
127.0.0.1 - - [22/Jul/2024:09:06:04 +0000] "PUT /devstoreaccount1/cont/ncyqbayseazcvignaarsrfljlvltnapq?blockid=quirzbpkyadkwycbkvlkfemrgogqibitjdjaqfgfvmibndsgkmwokewpaiumsmcn&comp=block HTTP/1.1" 201 -
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

127.0.0.1 - - [22/Jul/2024:09:06:04 +0000] "PUT /devstoreaccount1/cont/ncyqbayseazcvignaarsrfljlvltnapq?comp=blocklist HTTP/1.1" 201 -
127.0.0.1 - - [22/Jul/2024:09:06:04 +0000] "GET /devstoreaccount1/cont/ncyqbayseazcvignaarsrfljlvltnapq HTTP/1.1" 206 4
127.0.0.1 - - [22/Jul/2024:09:06:04 +0000] "GET /devstoreaccount1/cont/ncyqbayseazcvignaarsrfljlvltnapq HTTP/1.1" 206 2
127.0.0.1 - - [22/Jul/2024:09:06:04 +0000] "DELETE /devstoreaccount1/cont/ncyqbayseazcvignaarsrfljlvltnapq HTTP/1.1" 202 -
+ '[' 40 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=41
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+ '[' 55 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=56
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ 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
thread apply all backtrace full
info registers
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 1505
+ 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'
+ 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='\''s3_cache'\'''
+ 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='\''s3_cache'\'''
+ 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='\''s3_cache'\'''
+ clickhouse-client --query 'INSERT INTO test.hits_s3 SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0'
+ clickhouse-client --query 'INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0'
+ clickhouse-client --query 'INSERT INTO test.visits SELECT * FROM datasets.visits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0'
+ 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=1505
+ clickhouse stop --max-tries 90 --do-not-kill
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1505.
The process with pid = 1505 is running.
Sent terminate signal to process with pid 1505.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1505.
The process with pid = 1505 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1505.
The process with pid = 1505 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1505.
The process with pid = 1505 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1505.
The process with pid = 1505 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1505.
The process with pid = 1505 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1505.
The process with pid = 1505 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1505.
The process with pid = 1505 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ export USE_S3_STORAGE_FOR_MERGE_TREE=1
+ USE_S3_STORAGE_FOR_MERGE_TREE=1
+ export RANDOMIZE_OBJECT_KEY_TYPE=1
+ RANDOMIZE_OBJECT_KEY_TYPE=1
+ export ZOOKEEPER_FAULT_INJECTION=1
+ ZOOKEEPER_FAULT_INJECTION=1
+ configure
+ export USE_DATABASE_ORDINARY=1
+ USE_DATABASE_ORDINARY=1
+ export EXPORT_S3_STORAGE_POLICIES=1
+ EXPORT_S3_STORAGE_POLICIES=1
+ /usr/share/clickhouse-test/config/install.sh
+ DEST_SERVER_PATH=/etc/clickhouse-server
+ DEST_CLIENT_PATH=/etc/clickhouse-client
+++ dirname /usr/share/clickhouse-test/config/install.sh
++ cd /usr/share/clickhouse-test/config
++ pwd -P
+ SRC_PATH=/usr/share/clickhouse-test/config
+ echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server'
+ mkdir -p /etc/clickhouse-server/config.d/
Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server
+ mkdir -p /etc/clickhouse-server/users.d/
+ mkdir -p /etc/clickhouse-client
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/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/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/reverse_dns_query_function.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/
+ '[' /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/
+ value=1
+ sed --follow-symlinks -i 's|<create_snapshot_on_exit>[01]</create_snapshot_on_exit>|<create_snapshot_on_exit>1</create_snapshot_on_exit>|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=18149376
+ sed --follow-symlinks -i 's|<latest_logs_cache_size_threshold>[[:digit:]]\+</latest_logs_cache_size_threshold>|<latest_logs_cache_size_threshold>18149376</latest_logs_cache_size_threshold>|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=62455808
+ sed --follow-symlinks -i 's|<commit_logs_cache_size_threshold>[[:digit:]]\+</commit_logs_cache_size_threshold>|<commit_logs_cache_size_threshold>62455808</commit_logs_cache_size_threshold>|' /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n '' ]]
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ object_key_types_options=("generate-suffix" "generate-full-key" "generate-template-key")
+ object_key_type=generate-suffix
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ object_key_type=generate-full-key
+ case $object_key_type in
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_metadata_with_full_object_key.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/s3_storage_policy_by_default.xml /etc/clickhouse-server/config.d/
+ ARM=aarch64
++ uname -m
+ OS=x86_64
+ [[ -n 1 ]]
+ echo x86_64
+ [[ '' -eq 1 ]]
+ [[ x86_64 == \a\a\r\c\h\6\4 ]]
+ echo 'Adding azure configuration'
+ ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/
x86_64
Adding azure configuration
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|<snapshot_distance>100000</snapshot_distance>|<snapshot_distance>10000</snapshot_distance>|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value filtered_list keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|<filtered_list>[01]</filtered_list>|<filtered_list>0</filtered_list>|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value multi_read keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|<multi_read>[01]</multi_read>|<multi_read>0</multi_read>|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value check_not_exists keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|<check_not_exists>[01]</check_not_exists>|<check_not_exists>1</check_not_exists>|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value create_if_not_exists keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|<create_if_not_exists>[01]</create_if_not_exists>|<create_if_not_exists>1</create_if_not_exists>|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
script.gdb:13: Error in sourced command file:
No stack.
+ [[ -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|<use_compression>[01]</use_compression>|<use_compression>0</use_compression>|'
+ sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ randomize_config_boolean_value allow_experimental_block_number_column block_number
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/block_number.xml
+ sed 's|<allow_experimental_block_number_column>[01]</allow_experimental_block_number_column>|<allow_experimental_block_number_column>1</allow_experimental_block_number_column>|'
+ sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml
+ echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\'''
+ export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ sudo chown root: /var/lib/clickhouse
+ echo '<clickhouse><asynchronous_metrics_update_period_s>1</asynchronous_metrics_update_period_s></clickhouse>'
+ local total_mem
++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo
+ total_mem=32086448
+ total_mem=32856522752
+ 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=9856956825
Setting max_memory_usage_for_user=9856956825 and max_memory_usage for queries to 10G
+ echo 'Setting max_memory_usage_for_user=9856956825 and max_memory_usage for queries to 10G'
+ cat
+ cat
+ sudo cat /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml
+ sed 's|<main><disk>s3</disk></main>|<main><disk>s3</disk></main><default><disk>default</disk></default>|'
+ mv /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml.tmp /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml
+ sed 's|<level>trace</level>|<level>test</level>|'
+ sudo cat /etc/clickhouse-server/config.d/logger_trace.xml
+ 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
+ sleep 0.5
+ counter=17
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

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

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

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

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

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

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

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

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

+ '[' 25 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
127.0.0.1 - - [22/Jul/2024:09:42:10 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 -
127.0.0.1 - - [22/Jul/2024:09:42:10 +0000] "PUT /devstoreaccount1/cont/bvvfwpevorbiqyhwsnrmcbtauhktkfxi?blockid=sxviodagseevyjuttzvdqdqvynulmeljsffrtrsrxdfepphpxskfxsasxwonqhzu&comp=block HTTP/1.1" 201 -
127.0.0.1 - - [22/Jul/2024:09:42:10 +0000] "PUT /devstoreaccount1/cont/bvvfwpevorbiqyhwsnrmcbtauhktkfxi?comp=blocklist HTTP/1.1" 201 -
127.0.0.1 - - [22/Jul/2024:09:42:10 +0000] "GET /devstoreaccount1/cont/bvvfwpevorbiqyhwsnrmcbtauhktkfxi HTTP/1.1" 206 4
127.0.0.1 - - [22/Jul/2024:09:42:10 +0000] "GET /devstoreaccount1/cont/bvvfwpevorbiqyhwsnrmcbtauhktkfxi HTTP/1.1" 206 2
127.0.0.1 - - [22/Jul/2024:09:42:10 +0000] "DELETE /devstoreaccount1/cont/bvvfwpevorbiqyhwsnrmcbtauhktkfxi HTTP/1.1" 202 -
+ 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'
1
+ attach_gdb_to_clickhouse
++ 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
thread apply all backtrace full
info registers
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 2961
+ 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
2024-07-22 11:43:15,799 Run func tests '/usr/bin/clickhouse-test  --client-option optimize_trivial_approximate_count_query=1 --global_time_limit=1200  '
2024-07-22 11:43:16,301 Run func tests '/usr/bin/clickhouse-test --order=random  --database=test_1  --client-option join_use_nulls=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 http_make_head_request=1 --global_time_limit=1200  '
2024-07-22 11:43:16,802 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_2', 's1', 'r1')"  --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 use_query_cache=1 --global_time_limit=1200  '
2024-07-22 11:43:17,304 Run func tests '/usr/bin/clickhouse-test --order=random  --database=test_3  --client-option join_algorithm='partial_merge' use_query_cache=1 group_by_use_nulls=1 optimize_trivial_approximate_count_query=1 --global_time_limit=1200  '
2024-07-22 11:43:17,806 Run func tests '/usr/bin/clickhouse-test --order=random  --client-option join_use_nulls=1 --global_time_limit=1200  '
2024-07-22 11:43:18,307 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_5', 's1', 'r1')"  --database=test_5  --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='full_sorting_merge' use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200  '
2024-07-22 11:43:18,809 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 --global_time_limit=1200  '
2024-07-22 11:43:19,310 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 group_by_use_nulls=1 --global_time_limit=1200  '
2024-07-22 11:43:19,812 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_8', 's1', 'r1')"  --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 --global_time_limit=1200  '
2024-07-22 11:43:20,313 Run func tests '/usr/bin/clickhouse-test --order=random  --database=test_9  --client-option join_algorithm='auto' max_rows_in_join=1000 use_query_cache=1 group_by_use_nulls=1 optimize_trivial_approximate_count_query=1 --global_time_limit=1200  '
2024-07-22 11:43:20,815 Run func tests '/usr/bin/clickhouse-test --order=random  --client-option join_use_nulls=1 use_query_cache=1 --global_time_limit=1200  '
2024-07-22 11:43:21,317 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_11', 's1', 'r1')"  --database=test_11  --client-option allow_experimental_database_replicated=1 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 --global_time_limit=1200  '
2024-07-22 11:43:21,818 Run func tests '/usr/bin/clickhouse-test --order=random  --client-option implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 --global_time_limit=1200  '
2024-07-22 11:43:22,320 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 --global_time_limit=1200  '
2024-07-22 11:43:22,822 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_14', 's1', 'r1')"  --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 use_query_cache=1 --global_time_limit=1200  '
2024-07-22 11:43:23,324 Run func tests '/usr/bin/clickhouse-test --order=random  --database=test_15  --client-option join_algorithm='full_sorting_merge' use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200  '
2024-07-22 11:43:23,826 Will wait functests to finish
2024-07-22 11:43:23,826 Finished 8 from 16 processes
2024-07-22 11:43:28,831 Finished 8 from 16 processes
2024-07-22 11:43:33,835 Finished 8 from 16 processes
2024-07-22 11:43:38,840 Finished 8 from 16 processes
2024-07-22 11:43:43,843 Finished 8 from 16 processes
2024-07-22 11:43:48,847 Finished 8 from 16 processes
2024-07-22 11:43:53,851 Finished 8 from 16 processes
2024-07-22 11:43:58,855 Finished 8 from 16 processes
2024-07-22 11:44:03,859 Finished 8 from 16 processes
2024-07-22 11:44:08,864 Finished 8 from 16 processes
2024-07-22 11:44:13,867 Finished 8 from 16 processes
2024-07-22 11:44:18,873 Finished 8 from 16 processes
2024-07-22 11:44:23,875 Finished 8 from 16 processes
2024-07-22 11:44:28,879 Finished 8 from 16 processes
2024-07-22 11:44:33,881 Finished 8 from 16 processes
2024-07-22 11:44:38,883 Finished 8 from 16 processes
2024-07-22 11:44:43,887 Finished 8 from 16 processes
2024-07-22 11:44:48,892 Finished 8 from 16 processes
2024-07-22 11:44:53,895 Finished 8 from 16 processes
2024-07-22 11:44:58,899 Finished 8 from 16 processes
2024-07-22 11:45:03,904 Finished 8 from 16 processes
2024-07-22 11:45:08,909 Finished 8 from 16 processes
2024-07-22 11:45:13,910 Finished 8 from 16 processes
2024-07-22 11:45:18,911 Finished 8 from 16 processes
2024-07-22 11:45:23,915 Finished 8 from 16 processes
2024-07-22 11:45:28,919 Finished 8 from 16 processes
2024-07-22 11:45:33,923 Finished 8 from 16 processes
2024-07-22 11:45:38,927 Finished 8 from 16 processes
2024-07-22 11:45:43,931 Finished 8 from 16 processes
2024-07-22 11:45:48,935 Finished 8 from 16 processes
2024-07-22 11:45:53,939 Finished 8 from 16 processes
2024-07-22 11:45:58,943 Finished 8 from 16 processes
2024-07-22 11:46:03,948 Finished 8 from 16 processes
2024-07-22 11:46:08,950 Finished 8 from 16 processes
2024-07-22 11:46:13,955 Finished 8 from 16 processes
2024-07-22 11:46:18,959 Finished 8 from 16 processes
2024-07-22 11:46:23,963 Finished 8 from 16 processes
2024-07-22 11:46:28,967 Finished 8 from 16 processes
2024-07-22 11:46:33,973 Finished 8 from 16 processes
2024-07-22 11:46:38,977 Finished 8 from 16 processes
2024-07-22 11:46:43,979 Finished 8 from 16 processes
2024-07-22 11:46:48,983 Finished 8 from 16 processes
2024-07-22 11:46:53,988 Finished 8 from 16 processes
2024-07-22 11:46:58,991 Finished 8 from 16 processes
2024-07-22 11:47:03,993 Finished 8 from 16 processes
2024-07-22 11:47:08,995 Finished 8 from 16 processes
2024-07-22 11:47:13,999 Finished 8 from 16 processes
2024-07-22 11:47:19,001 Finished 8 from 16 processes
2024-07-22 11:47:24,003 Finished 8 from 16 processes
2024-07-22 11:47:29,007 Finished 8 from 16 processes
2024-07-22 11:47:34,012 Finished 8 from 16 processes
2024-07-22 11:47:39,015 Finished 8 from 16 processes
2024-07-22 11:47:44,019 Finished 8 from 16 processes
2024-07-22 11:47:49,023 Finished 8 from 16 processes
2024-07-22 11:47:54,027 Finished 8 from 16 processes
2024-07-22 11:47:59,033 Finished 8 from 16 processes
2024-07-22 11:48:04,035 Finished 8 from 16 processes
2024-07-22 11:48:09,039 Finished 8 from 16 processes
2024-07-22 11:48:14,043 Finished 8 from 16 processes
2024-07-22 11:48:19,047 Finished 8 from 16 processes
2024-07-22 11:48:24,051 Finished 8 from 16 processes
2024-07-22 11:48:29,055 Finished 8 from 16 processes
2024-07-22 11:48:34,059 Finished 8 from 16 processes
2024-07-22 11:48:39,063 Finished 8 from 16 processes
2024-07-22 11:48:44,069 Finished 8 from 16 processes
2024-07-22 11:48:49,071 Finished 8 from 16 processes
2024-07-22 11:48:54,075 Finished 8 from 16 processes
2024-07-22 11:48:59,079 Finished 8 from 16 processes
2024-07-22 11:49:04,084 Finished 8 from 16 processes
2024-07-22 11:49:09,087 Finished 8 from 16 processes
2024-07-22 11:49:14,091 Finished 8 from 16 processes
2024-07-22 11:49:19,095 Finished 8 from 16 processes
2024-07-22 11:49:24,099 Finished 8 from 16 processes
2024-07-22 11:49:29,103 Finished 8 from 16 processes
2024-07-22 11:49:34,107 Finished 8 from 16 processes
2024-07-22 11:49:39,111 Finished 8 from 16 processes
2024-07-22 11:49:44,115 Finished 8 from 16 processes
2024-07-22 11:49:49,119 Finished 8 from 16 processes
2024-07-22 11:49:54,123 Finished 8 from 16 processes
2024-07-22 11:49:59,127 Finished 8 from 16 processes
2024-07-22 11:50:04,131 Finished 8 from 16 processes
2024-07-22 11:50:09,135 Finished 8 from 16 processes
2024-07-22 11:50:14,141 Finished 8 from 16 processes
2024-07-22 11:50:19,143 Finished 8 from 16 processes
2024-07-22 11:50:24,147 Finished 8 from 16 processes
2024-07-22 11:50:29,152 Finished 8 from 16 processes
2024-07-22 11:50:34,155 Finished 8 from 16 processes
2024-07-22 11:50:39,158 Finished 8 from 16 processes
2024-07-22 11:50:44,158 Finished 8 from 16 processes
2024-07-22 11:50:49,163 Finished 8 from 16 processes
2024-07-22 11:50:54,167 Finished 8 from 16 processes
2024-07-22 11:50:59,171 Finished 8 from 16 processes
2024-07-22 11:51:04,177 Finished 8 from 16 processes
2024-07-22 11:51:09,179 Finished 8 from 16 processes
2024-07-22 11:51:14,183 Finished 8 from 16 processes
2024-07-22 11:51:19,187 Finished 8 from 16 processes
2024-07-22 11:51:24,191 Finished 8 from 16 processes
2024-07-22 11:51:29,195 Finished 8 from 16 processes
2024-07-22 11:51:34,199 Finished 8 from 16 processes
2024-07-22 11:51:39,203 Finished 8 from 16 processes
2024-07-22 11:51:44,207 Finished 8 from 16 processes
2024-07-22 11:51:49,211 Finished 8 from 16 processes
2024-07-22 11:51:54,215 Finished 8 from 16 processes
2024-07-22 11:51:59,219 Finished 8 from 16 processes
2024-07-22 11:52:04,223 Finished 8 from 16 processes
2024-07-22 11:52:09,227 Finished 8 from 16 processes
2024-07-22 11:52:14,231 Finished 8 from 16 processes
2024-07-22 11:52:19,235 Finished 8 from 16 processes
2024-07-22 11:52:24,237 Finished 8 from 16 processes
2024-07-22 11:52:29,242 Finished 8 from 16 processes
2024-07-22 11:52:34,247 Finished 8 from 16 processes
2024-07-22 11:52:39,251 Finished 8 from 16 processes
2024-07-22 11:52:44,255 Finished 8 from 16 processes
2024-07-22 11:52:49,259 Finished 8 from 16 processes
2024-07-22 11:52:54,263 Finished 8 from 16 processes
2024-07-22 11:52:59,267 Finished 8 from 16 processes
2024-07-22 11:53:04,271 Finished 8 from 16 processes
2024-07-22 11:53:09,275 Finished 8 from 16 processes
2024-07-22 11:53:14,279 Finished 8 from 16 processes
2024-07-22 11:53:19,283 Finished 8 from 16 processes
2024-07-22 11:53:24,287 Finished 8 from 16 processes
2024-07-22 11:53:29,291 Finished 8 from 16 processes
2024-07-22 11:53:34,295 Finished 8 from 16 processes
2024-07-22 11:53:39,300 Finished 8 from 16 processes
2024-07-22 11:53:44,303 Finished 8 from 16 processes
2024-07-22 11:53:49,307 Finished 8 from 16 processes
2024-07-22 11:53:54,311 Finished 8 from 16 processes
2024-07-22 11:53:59,315 Finished 8 from 16 processes
2024-07-22 11:54:04,319 Finished 8 from 16 processes
2024-07-22 11:54:09,323 Finished 8 from 16 processes
2024-07-22 11:54:14,327 Finished 8 from 16 processes
2024-07-22 11:54:19,331 Finished 8 from 16 processes
2024-07-22 11:54:24,335 Finished 8 from 16 processes
2024-07-22 11:54:29,339 Finished 8 from 16 processes
2024-07-22 11:54:34,343 Finished 8 from 16 processes
2024-07-22 11:54:39,347 Finished 8 from 16 processes
2024-07-22 11:54:44,351 Finished 8 from 16 processes
2024-07-22 11:54:49,355 Finished 8 from 16 processes
2024-07-22 11:54:54,359 Finished 8 from 16 processes
2024-07-22 11:54:59,364 Finished 8 from 16 processes
2024-07-22 11:55:04,368 Finished 8 from 16 processes
2024-07-22 11:55:09,371 Finished 8 from 16 processes
2024-07-22 11:55:14,375 Finished 8 from 16 processes
2024-07-22 11:55:19,379 Finished 8 from 16 processes
2024-07-22 11:55:24,383 Finished 8 from 16 processes
2024-07-22 11:55:29,387 Finished 8 from 16 processes
2024-07-22 11:55:34,392 Finished 8 from 16 processes
2024-07-22 11:55:39,397 Finished 8 from 16 processes
2024-07-22 11:55:44,399 Finished 8 from 16 processes
2024-07-22 11:55:49,403 Finished 8 from 16 processes
2024-07-22 11:55:54,407 Finished 8 from 16 processes
2024-07-22 11:55:59,411 Finished 8 from 16 processes
2024-07-22 11:56:04,415 Finished 8 from 16 processes
2024-07-22 11:56:09,419 Finished 8 from 16 processes
2024-07-22 11:56:14,423 Finished 8 from 16 processes
2024-07-22 11:56:19,428 Finished 8 from 16 processes
2024-07-22 11:56:24,431 Finished 8 from 16 processes
2024-07-22 11:56:29,434 Finished 8 from 16 processes
2024-07-22 11:56:34,435 Finished 8 from 16 processes
2024-07-22 11:56:39,439 Finished 8 from 16 processes
2024-07-22 11:56:44,444 Finished 8 from 16 processes
2024-07-22 11:56:49,447 Finished 8 from 16 processes
2024-07-22 11:56:54,451 Finished 8 from 16 processes
2024-07-22 11:56:59,456 Finished 8 from 16 processes
2024-07-22 11:57:04,459 Finished 8 from 16 processes
2024-07-22 11:57:09,463 Finished 8 from 16 processes
2024-07-22 11:57:14,467 Finished 8 from 16 processes
2024-07-22 11:57:19,471 Finished 8 from 16 processes
2024-07-22 11:57:24,475 Finished 8 from 16 processes
2024-07-22 11:57:29,479 Finished 8 from 16 processes
2024-07-22 11:57:34,483 Finished 8 from 16 processes
2024-07-22 11:57:39,486 Finished 8 from 16 processes
2024-07-22 11:57:44,491 Finished 8 from 16 processes
2024-07-22 11:57:49,497 Finished 8 from 16 processes
2024-07-22 11:57:54,499 Finished 8 from 16 processes
2024-07-22 11:57:59,503 Finished 8 from 16 processes
2024-07-22 11:58:04,507 Finished 8 from 16 processes
2024-07-22 11:58:09,511 Finished 8 from 16 processes
2024-07-22 11:58:14,515 Finished 8 from 16 processes
2024-07-22 11:58:19,519 Finished 8 from 16 processes
2024-07-22 11:58:24,523 Finished 8 from 16 processes
2024-07-22 11:58:29,527 Finished 8 from 16 processes
2024-07-22 11:58:34,531 Finished 8 from 16 processes
2024-07-22 11:58:39,535 Finished 8 from 16 processes
2024-07-22 11:58:44,539 Finished 8 from 16 processes
2024-07-22 11:58:49,544 Finished 8 from 16 processes
2024-07-22 11:58:54,549 Finished 8 from 16 processes
2024-07-22 11:58:59,554 Finished 8 from 16 processes
2024-07-22 11:59:04,559 Finished 8 from 16 processes
2024-07-22 11:59:09,563 Finished 8 from 16 processes
2024-07-22 11:59:14,567 Finished 8 from 16 processes
2024-07-22 11:59:19,571 Finished 8 from 16 processes
2024-07-22 11:59:24,575 Finished 8 from 16 processes
2024-07-22 11:59:29,579 Finished 8 from 16 processes
2024-07-22 11:59:34,583 Finished 8 from 16 processes
2024-07-22 11:59:39,587 Finished 8 from 16 processes
2024-07-22 11:59:44,591 Finished 8 from 16 processes
2024-07-22 11:59:49,595 Finished 8 from 16 processes
2024-07-22 11:59:54,599 Finished 8 from 16 processes
2024-07-22 11:59:59,603 Finished 8 from 16 processes
2024-07-22 12:00:04,607 Finished 8 from 16 processes
2024-07-22 12:00:09,611 Finished 8 from 16 processes
2024-07-22 12:00:14,615 Finished 8 from 16 processes
2024-07-22 12:00:19,619 Finished 8 from 16 processes
2024-07-22 12:00:24,623 Finished 8 from 16 processes
2024-07-22 12:00:29,627 Finished 8 from 16 processes
2024-07-22 12:00:34,631 Finished 8 from 16 processes
2024-07-22 12:00:39,635 Finished 8 from 16 processes
2024-07-22 12:00:44,639 Finished 8 from 16 processes
2024-07-22 12:00:49,643 Finished 8 from 16 processes
2024-07-22 12:00:54,647 Finished 8 from 16 processes
2024-07-22 12:00:59,652 Finished 8 from 16 processes
2024-07-22 12:01:04,656 Finished 8 from 16 processes
2024-07-22 12:01:09,659 Finished 8 from 16 processes
2024-07-22 12:01:14,663 Finished 8 from 16 processes
2024-07-22 12:01:19,667 Finished 8 from 16 processes
2024-07-22 12:01:24,671 Finished 8 from 16 processes
2024-07-22 12:01:29,675 Finished 8 from 16 processes
2024-07-22 12:01:34,680 Finished 8 from 16 processes
2024-07-22 12:01:39,683 Finished 8 from 16 processes
2024-07-22 12:01:44,687 Finished 8 from 16 processes
2024-07-22 12:01:49,692 Finished 8 from 16 processes
2024-07-22 12:01:54,698 Finished 8 from 16 processes
2024-07-22 12:01:59,703 Finished 8 from 16 processes
2024-07-22 12:02:04,707 Finished 8 from 16 processes
2024-07-22 12:02:09,711 Finished 8 from 16 processes
2024-07-22 12:02:14,716 Finished 8 from 16 processes
2024-07-22 12:02:19,721 Finished 8 from 16 processes
2024-07-22 12:02:24,725 Finished 8 from 16 processes
2024-07-22 12:02:29,727 Finished 8 from 16 processes
2024-07-22 12:02:34,731 Finished 8 from 16 processes
2024-07-22 12:02:39,735 Finished 8 from 16 processes
2024-07-22 12:02:44,739 Finished 8 from 16 processes
2024-07-22 12:02:49,743 Finished 8 from 16 processes
2024-07-22 12:02:54,747 Finished 8 from 16 processes
2024-07-22 12:02:59,751 Finished 8 from 16 processes
2024-07-22 12:03:04,755 Finished 8 from 16 processes
2024-07-22 12:03:09,759 Finished 8 from 16 processes
2024-07-22 12:03:14,763 Finished 8 from 16 processes
2024-07-22 12:03:19,767 Finished 9 from 16 processes
2024-07-22 12:03:24,771 Finished 9 from 16 processes
2024-07-22 12:03:29,774 Finished 9 from 16 processes
2024-07-22 12:03:34,778 Finished 9 from 16 processes
2024-07-22 12:03:39,783 Finished 12 from 16 processes
2024-07-22 12:03:44,787 Finished 14 from 16 processes
2024-07-22 12:03:49,791 Finished 14 from 16 processes
2024-07-22 12:03:54,796 Finished 14 from 16 processes
2024-07-22 12:03:59,799 Finished 14 from 16 processes
2024-07-22 12:04:04,803 Finished 14 from 16 processes
2024-07-22 12:04:09,809 Finished 15 from 16 processes
2024-07-22 12:04:14,814 Finished 15 from 16 processes
2024-07-22 12:04:19,819 Finished 15 from 16 processes
2024-07-22 12:04:24,820 Finished 15 from 16 processes
2024-07-22 12:04:29,826 Finished 15 from 16 processes
2024-07-22 12:04:34,831 Finished 15 from 16 processes
2024-07-22 12:04:39,834 Finished 15 from 16 processes
2024-07-22 12:04:44,839 Finished 15 from 16 processes
2024-07-22 12:04:49,845 Finished 15 from 16 processes
2024-07-22 12:04:54,847 Finished 15 from 16 processes
2024-07-22 12:04:59,852 Finished 15 from 16 processes
2024-07-22 12:05:04,855 Finished 15 from 16 processes
2024-07-22 12:05:09,859 Finished 15 from 16 processes
2024-07-22 12:05:14,863 Finished 15 from 16 processes
2024-07-22 12:05:19,867 All processes finished
2024-07-22 12:05:19,867 Compressing stress logs
2024-07-22 12:05:19,929 Logs compressed
2024-07-22 12:05:19,930 Will terminate gdb (if any)
2024-07-22 12:05:19,930 Running command: kill -TERM $(pidof gdb)
2024-07-22 12:05:19,938 Running command: timeout 50s tail --pid=$(pidof gdb) -f /dev/null || kill -9 $(pidof gdb) ||:
Quit
2024-07-22 12:05:20,955 Running command: kill -CONT $(cat /var/run/clickhouse-server/clickhouse-server.pid) && clickhouse client -q 'SELECT 1 FORMAT Null'
2024-07-22 12:05:21,476 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
2024-07-22 12:05:21,842 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
2024-07-22 12:05:22,207 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
2024-07-22 12:05:22,572 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
2024-07-22 12:05:22,988 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
2024-07-22 12:05:23,354 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
2024-07-22 12:05:23,719 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
2024-07-22 12:05:24,085 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
2024-07-22 12:05:24,450 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
2024-07-22 12:05:24,816 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
2024-07-22 12:05:25,231 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
2024-07-22 12:05:25,596 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
2024-07-22 12:05:25,962 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
2024-07-22 12:10:28,837 Checking if some queries hung
Using queries from '/usr/share/clickhouse-test/queries' directory
Connecting to ClickHouse server... OK
Connected to server 24.3.5.47.altinitystable @ b6642564dbf296d6e55b907d7af6c8087470b672 HEAD

Running 1 stateless tests (MainProcess).

00001_select_1:                                                         [ OK ]

1 tests passed. 0 tests skipped. 0.99 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.  26005     0.061   2.33 MiB      0.044              1            621   ['Trace']                    0   Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.)                                                                                                                                                      
  2.  25130     0.058   989.94 KiB    0.018              1            621   ['Trace']                    0   Aggregation method: {}                                                                                                                                                                                                          
  3.  23041     0.054   247.51 KiB    0.005              1            596   ['Trace']                    0   Aggregating                                                                                                                                                                                                                     
  4.  20244     0.047   1.18 MiB      0.022              1             97   ['Debug']                 0.96   Key {} is removed from metadata                                                                                                                                                                                                 
  5.  18321     0.043   1.45 MiB      0.027              1            479   ['Trace']                    0   An entry for key={} found in cache: sum_of_sizes={}, median_size={}                                                                                                                                                             
  6.  18204     0.042   1.02 MiB      0.019              1            579   ['Debug']                0.006   Submitting key {} for removal                                                                                                                                                                                                   
  7.  15761     0.037   920.49 KiB    0.017              3            186   ['Trace']                0.004   Access granted: {}{}                                                                                                                                                                                                            
  8.  14047     0.033   2.49 MiB      0.047              1             53   ['Debug']                    0   (from {}{}{}){}{} {} (stage: {})                                                                                                                                                                                                
  9.  13735     0.032   2.06 MiB      0.039              3             52   ['Trace']                    1   {} Creating query context from {} context, user_id: {}, parent context user: {}                                                                                                                                                 
 10.  12860      0.03   362.94 KiB    0.007              1             52   ['Debug']                    0   Processed in {} sec.                                                                                                                                                                                                            
 11.  10702     0.025   1.19 MiB      0.023           1135            584   ['Trace']                    0   Bypassing cache because file segment state is `PARTIALLY_DOWNLOADED_NO_CONTINUATION` and downloaded part already used                                                                                                           
 12.  10311     0.024   2.33 MiB      0.044              1            133   ['Trace']                0.006   Query {} to stage {}{}                                                                                                                                                                                                          
 13.  10198     0.024   2.53 MiB      0.048              1            133   ['Trace']                0.006   Query {} from stage {} to stage {}{}                                                                                                                                                                                            
 14.   9372     0.022   756.24 KiB    0.014              1             39   ['Debug']                    0   Read {} rows, {} in {} sec., {} rows/sec., {}/sec.                                                                                                                                                                              
 15.   6513     0.015   439.67 KiB    0.008             17            358   ['Trace']                0.008   Running binary search on index range for part {} ({} marks)                                                                                                                                                                     
 16.   6513     0.015   190.52 KiB    0.004             17            358   ['Trace']                0.008   Found (LEFT) boundary mark: {}                                                                                                                                                                                                  
 17.   6513     0.015   184.32 KiB    0.003             17            358   ['Trace']                0.008   Found {} range in {} steps                                                                                                                                                                                                      
 18.   6513     0.015   196.96 KiB    0.004             17            358   ['Trace']                0.008   Found (RIGHT) boundary mark: {}                                                                                                                                                                                                 
 19.   5491     0.013   740.00 KiB    0.014              1            313   ['Information']              0   Sorting and writing part of data into temporary file {}                                                                                                                                                                         
 20.   4752     0.011   212.94 KiB    0.004              1              1   ['Trace']                    1   Processing requests batch, size: {}, bytes: {}                                                                                                                                                                                  
 21.   4660     0.011   206.10 KiB    0.004              1             55   ['Debug']                0.127   Peak memory usage{}: {}.                                                                                                                                                                                                        
 22.   4567     0.011   1.39 MiB      0.026           3160            552   ['Information']          0.006   Setting download as failed: {}                                                                                                                                                                                                  
 23.   4068     0.009   710.60 KiB    0.013              1            193   ['Information']              0   Done writing part of data into temporary file {}, compressed {}, uncompressed {}                                                                                                                                                
 24.   3989     0.009   890.58 KiB    0.016              1            161   ['Trace']                    0   {}Keys: {}, datatype: {}, kind: {}, strictness: {}, right header: {}                                                                                                                                                            
 25.   3798     0.009   328.54 KiB    0.006             52             33   ['Trace']                    0   Reading {} ranges in{}order from part {}, approx. {} rows starting from {}                                                                                                                                                      
 26.   3786     0.009   290.83 KiB    0.005              1            146   ['Trace']                0.001   {}Join data is being destroyed, {} bytes and {} rows in hash table                                                                                                                                                              
 27.   3524     0.008   866.41 KiB    0.016              1            227   ['Debug']                    0   Written part in {:.3f} sec., {} rows, {} uncompressed, {} compressed, {:.3f} uncompressed bytes per row, {:.3f} compressed bytes per row, compression rate: {:.3f} ({:.3f} rows/sec., {}/sec. uncompressed, {}/sec. compressed) 
 28.   3512     0.008   155.22 KiB    0.003              1            221   ['Debug']                    0   Max size of temporary block: {} rows, {}.                                                                                                                                                                                       
 29.   3507     0.008   472.62 KiB    0.009              1            218   ['Debug']                    0   Writing part of aggregation data into temporary file {}                                                                                                                                                                         
 30.   3427     0.008   237.69 KiB    0.004            223            549   ['Trace']                0.728   Trying to reserve {} using storage policy from min volume index {}                                                                                                                                                              
 31.   3395     0.008   163.22 KiB    0.003              1            223   ['Trace']                0.565   filled checksums {}                                                                                                                                                                                                             
 32.   3390     0.008   404.10 KiB    0.007            225            234   ['Trace']                0.561   Renaming temporary part {} to {} with tid {}.                                                                                                                                                                                   
 33.   2927     0.007   1.39 MiB      0.026              1            482   ['Debug']                0.898   Objects with paths [{}] were removed from S3                                                                                                                                                                                    
 34.   2868     0.007   272.87 KiB    0.005              1             25   ['Debug']                    0   Reading {} marks from part {}, total {} rows starting from the beginning of the part                                                                                                                                            
 35.   2866     0.007   64.37 KiB     0.001              1            407   ['Trace']                    0   Merging aggregated data                                                                                                                                                                                                         
 36.   2794     0.007   228.46 KiB    0.004              4             76   ['Debug']                0.991   {} Authenticating user '{}' from {}                                                                                                                                                                                             
 37.   2794     0.007   313.78 KiB    0.006              4             76   ['Debug']                0.991   {} Authenticated with global context as user {}                                                                                                                                                                                 
 38.   2777     0.006   244.07 KiB    0.005              4             76   ['Debug']                0.991   {} Logout, user_id: {}                                                                                                                                                                                                          
 39.   2770     0.006   302.97 KiB    0.006              3             52   ['Debug']                    1   {} Creating session context with user_id: {}                                                                                                                                                                                    
 40.   2687     0.006   216.46 KiB    0.004           1999            429   ['Trace']                    0   No space left in cache to reserve {} bytes, will continue without cache download                                                                                                                                                
 41.   2672     0.006   3.04 MiB      0.057              1            460   ['Debug']                0.894   metadata and objects were removed for [{}], only metadata were removed for [{}].                                                                                                                                                
 42.   2248     0.005   83.63 KiB     0.002            173             80   ['Debug']                0.017   Key condition: {}                                                                                                                                                                                                               
 43.   2217     0.005   256.00 KiB    0.005            166             80   ['Debug']                0.018   Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges                                                                                                     
 44.   2124     0.005   109.93 KiB    0.002            148             78   ['Trace']                0.017   Spreading mark ranges among streams (default reading)                                                                                                                                                                           
 45.   2121     0.005   82.29 KiB     0.002            147             78   ['Debug']                0.017   Reading approx. {} rows with {} streams                                                                                                                                                                                         
 46.   2115     0.005   232.75 KiB    0.004              1             38   ['Trace']                0.017   PREWHERE condition was split into {} steps: {}                                                                                                                                                                                  
 47.   2038     0.005   235.06 KiB    0.004              1             19   ['Debug']                    0   Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {}                                                                                                                                 
 48.   1971     0.005   493.87 KiB    0.009              1             30   ['Information']          0.143   WriteBufferFromS3 is not finalized in destructor. The file might not be written to S3. {}.                                                                                                                                      
 49.   1957     0.005   96.58 KiB     0.002              1            177   ['Trace']                0.001   Merging partially aggregated blocks (bucket = {}).                                                                                                                                                                              
 50.   1956     0.005   293.03 KiB    0.005              1            176   ['Debug']                0.001   Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.)                                                                                                   
 51.   1946     0.005   113.10 KiB    0.002             15             15   ['Trace']                    1   Flushing system log, {} entries to flush up to offset {}                                                                                                                                                                        
 52.   1941     0.005   69.68 KiB     0.001             15             15   ['Trace']                    1   Flushed system log up to offset {}                                                                                                                                                                                              
 53.   1922     0.004   62.60 KiB     0.001              2             52   ['Trace']                    1   TCP Request. Address: {}                                                                                                                                                                                                        
 54.   1921     0.004   178.23 KiB    0.003              1             52   ['Debug']                    1   Connected {} version {}.{}.{}, revision: {}{}{}.                                                                                                                                                                                
 55.   1897     0.004   50.02 KiB     0.001              1             52   ['Debug']                    1   Done processing connection.                                                                                                                                                                                                     
 56.   1732     0.004   54.18 KiB     0.001              1             78   ['Debug']                0.021   min_marks_for_concurrent_read={}                                                                                                                                                                                                
 57.   1676     0.004   58.92 KiB     0.001              1             41   ['Trace']                    0   Skipping inserting block with {} rows                                                                                                                                                                                           
 58.   1637     0.004   118.75 KiB    0.002              1             49   ['Trace']                0.011   The min valid primary key position for moving to the tail of PREWHERE is {}                                                                                                                                                     
 59.   1544     0.004   157.36 KiB    0.003            633            428   ['Trace']                    0   Predownload failed because of space limit. Will read from remote filesystem starting from offset: {}                                                                                                                            
 60.   1519     0.004   121.21 KiB    0.002              1            362   ['Trace']                    0   Statistics updated for key={}: new sum_of_sizes={}, median_size={}                                                                                                                                                              
 61.   1515     0.004   49.26 KiB     0.001             33             37   ['Debug']                    0   MinMax index condition: {}                                                                                                                                                                                                      
 62.   1442     0.003   178.97 KiB    0.003              1              2   ['Trace']                    1   MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {}                                                                                                                                 
 63.   1420     0.003   367.72 KiB    0.007              1             56   ['Debug']                    0   {}:{}: sampleColumns {} '{}'                                                                                                                                                                                                    
 64.   1349     0.003   104.07 KiB    0.002              1             38   ['Trace']                    0   Query span trace_id for opentelemetry log: {}                                                                                                                                                                                   
 65.   1262     0.003   483.67 KiB    0.009              2              7   ['Error']                    0   Number of arguments for function {} doesn't match: passed {}, should be {}                                                                                                                                                      
 66.   1196     0.003   3.01 MiB      0.057              8            479   ['Error']                0.997   Table is in readonly mode (replica path: {})                                                                                                                                                                                    
 67.   1001     0.002   92.07 KiB     0.002              1            322   ['Debug']                    0   Merge sorted {} blocks, {} rows in {} sec., {} rows/sec., {}/sec                                                                                                                                                                
 68.    976     0.002   39.08 KiB     0.001              1            393   ['Trace']                    0   Converting aggregation data to two-level.                                                                                                                                                                                       
 69.    876     0.002   154.90 KiB    0.003              2             35   ['Trace']                    1   HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {}                                                                                                    
 70.    876     0.002   528.33 KiB     0.01              2             35   ['Trace']                    1   Request URI: {}                                                                                                                                                                                                                 
 71.    845     0.002   124.29 KiB    0.002              1             56   ['Debug']                    0   {}:{}: {} - '{}'                                                                                                                                                                                                                
 72.    833     0.002   17.08 KiB         0              2             35   ['Debug']                0.037   Done processing query                                                                                                                                                                                                           
 73.    824     0.002   152.90 KiB    0.003              1             21   ['Debug']                    0   Before join block: '{}'                                                                                                                                                                                                         
 74.    812     0.002   244.01 KiB    0.005              1             21   ['Debug']                    0   After join block: '{}'                                                                                                                                                                                                          
 75.    765     0.002   52.09 KiB     0.001              1             30   ['Debug']                0.051   Schedule load job '{}' into {}                                                                                                                                                                                                  
 76.    765     0.002   23.92 KiB         0              1            262   ['Debug']                0.561   Spawn loader worker #{} in {}                                                                                                                                                                                                   
 77.    765     0.002   49.85 KiB     0.001              1            253   ['Debug']                    1   Execute load job '{}' in {}                                                                                                                                                                                                     
 78.    765     0.002   52.83 KiB     0.001              1            253   ['Debug']                    1   Finish load job '{}' with status {}                                                                                                                                                                                             
 79.    765     0.002   15.69 KiB         0              1            392   ['Debug']                    1   Stop worker in {}                                                                                                                                                                                                               
 80.    764     0.002   60.20 KiB     0.001              1             30   ['Debug']                 0.05   Prioritize load job '{}': {} -> {}                                                                                                                                                                                              
 81.    674     0.002   22.38 KiB         0              1            275   ['Debug']                0.507   Change current priority: {} -> {}                                                                                                                                                                                               
 82.    668     0.002   5.87 KiB          0              2             30   ['Trace']                0.003   No tables                                                                                                                                                                                                                       
 83.    583     0.001   71.47 KiB     0.001             42             31   ['Debug']                    0   Part: {}, sum_marks: {}, approx mark size: {}, prefetch_step_bytes: {}, prefetch_step_marks: {}, (ranges: {})                                                                                                                   
 84.    580     0.001   13.97 KiB         0              1            101   ['Trace']                    0   Skipping {} {} bucket {}                                                                                                                                                                                                        
 85.    562     0.001   19.16 KiB         0              1             27   ['Debug']                    0   Selected MergeAlgorithm: {}                                                                                                                                                                                                     
 86.    562     0.001   46.83 KiB     0.001              1             27   ['Debug']                    0   Merging {} parts: from {} to {} into {} with storage {}                                                                                                                                                                         
 87.    561     0.001   30.16 KiB     0.001             43            348   ['Debug']                0.957   Selected {} parts from {} to {}                                                                                                                                                                                                 
 88.    548     0.001   40.56 KiB     0.001             21            275   ['Trace']                0.036   Used generic exclusion search over index for part {} with {} steps                                                                                                                                                              
 89.    541     0.001   61.55 KiB     0.001            208            181   ['Debug']                 0.93   Removing {} parts from filesystem (serially): Parts: [{}]                                                                                                                                                                       
 90.    526     0.001   68.79 KiB     0.001              1             27   ['Debug']                    0   Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec.                                                                                                                          
 91.    522     0.001   34.42 KiB     0.001             41             27   ['Trace']                    0   Merged {} parts: [{}, {}] -> {}                                                                                                                                                                                                 
 92.    512     0.001   130.95 KiB    0.002              5              8   ['Debug']                    0   ZooKeeperRetriesControl: {}: {}: retry_count={}/{} timeout={}ms error={} message={}                                                                                                                                             
 93.    485     0.001   9.47 KiB          0              1            241   ['Trace']                    0   Aggregating in order                                                                                                                                                                                                            
 94.    471     0.001   21.38 KiB         0              1            224   ['Debug']                    0   Aggregated. {} to {} rows (from {})                                                                                                                                                                                             
 95.    461     0.001   14.60 KiB         0             19             11   ['Debug']                    0   Requested flush up to offset {}                                                                                                                                                                                                 
 96.    457     0.001   10.01 KiB         0             37            311   ['Trace']                    1   Execution took {} ms.                                                                                                                                                                                                           
 97.    425     0.001   31.54 KiB     0.001              1             33   ['Debug']                    0   Waiting for table {} to be finally dropped                                                                                                                                                                                      
 98.    425     0.001   82.62 KiB     0.002              1            268   ['Information']              1   Removing metadata {} of dropped table {}                                                                                                                                                                                        
 99.    425     0.001   53.12 KiB     0.001              1            268   ['Information']              1   Have {} tables in drop queue ({} of them are in use), will try drop {}                                                                                                                                                          
100.    411     0.001   83.38 KiB     0.002             39             12   ['Information']              1   {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting)



Top messages without format string (fmt::runtime):

count   pattern                            runtime_message                                                                                                                                                                                                                                              line                     

 1.      9   CodeCoordinationExceptionSession   Code: 999. Coordination::Exception: Session expired (fault injected on recv). (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below):

0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(S   ('/Exception.cpp',222)    
 2.      8   autoDBStorageReplicatedMergeTree   auto DB::StorageReplicatedMergeTree::processQueueEntry(ReplicatedMergeTreeQueue::SelectedEntryPtr)::(anonymous class)::operator()(LogEntryPtr &) const: Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this    ('/Exception.cpp',222)    
 3.      4   CodeDBExceptionReceivedfromDBExc   Code: 241. DB::Exception: Received from 127.0.0.2:9000. DB::Exception: Memory limit (total) exceeded: would use 15.32 GiB (attempt to allocate chunk of 1049997 bytes), maximum: 15.30 GiB. OvercommitTracker decision: Query was selected to stop by Overcommit   ('/executeQuery.cpp',218) 
 4.      4   voidDBStorageReplicatedMergeTree   void DB::StorageReplicatedMergeTree::mergeSelectingTask(): Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below):

0. ./contrib/llvm-project/libcxx/include/exception   ('/Exception.cpp',222)    
 5.      3   virtualboolDBReplicatedMergeMuta   virtual bool DB::ReplicatedMergeMutateTaskBase::executeStep(): Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below):

0. ./contrib/llvm-project/libcxx/include/excep   ('/Exception.cpp',222)    
 6.      3   voidDBReplicatedMergeTreeCleanup   void DB::ReplicatedMergeTreeCleanupThread::run(): Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below):

0. ./contrib/llvm-project/libcxx/include/exception:141: Poc   ('/Exception.cpp',222)    
 7.      3   Exceptionwhileexecutingbackgroun   Exception while executing background task {d310abca-e5f7-41d9-ae0e-68e0aab8bbec::all_0_0_1}: Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below):

0. ./contrib/llv   ('/Exception.cpp',222)    
 8.      3   configatindexiscommittedprevconf   config at index 1 is committed, prev config log idx 19                                                                                                                                                                                                       ('/LoggerWrapper.h',43)   
 9.      2   skippedconfiglatestconfig          skipped config 1, latest config 19                                                                                                                                                                                                                           ('/LoggerWrapper.h',43)   
10.      2   CodeDBExceptionReceivedfromlocal   Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (for query) exceeded: would use 20.01 MiB (attempt to allocate chunk of 1048832 bytes), maximum: 20.00 MiB.: While executing AggregatingTransform: while pushing to view tes   ('/executeQuery.cpp',218) 
11.      1   Electiontimeoutinitiateleaderele   Election timeout, initiate leader election                                                                                                                                                                                                                   ('/LoggerWrapper.h',43)   
12.      1   bgappendentriesthreadinitiated     bg append_entries thread initiated                                                                                                                                                                                                                           ('/LoggerWrapper.h',43)   
13.      1   PocoExceptionCodeecodeNetExcepti   Poco::Exception. Code: 1000, e.code() = 107, Net Exception: Socket is not connected, Stack trace (when copying this message, always include the lines below):

0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&,   ('/Exception.cpp',222)    
14.      1   waitforHBforms                     wait for HB, for 50 + [0, 0] ms                                                                                                                                                                                                                              ('/LoggerWrapper.h',43)   
15.      1   invalidelectiontimeoutupperbound   invalid election timeout upper bound detected, adjusted to 0                                                                                                                                                                                                 ('/LoggerWrapper.h',43)   
16.      1   detectaconfigurationchangethatis   detect a configuration change that is not committed yet at index 1                                                                                                                                                                                           ('/LoggerWrapper.h',43)   
17.      1   statemachinecommitindexprecommit   state machine commit index 0, precommit index 231, last log index 231                                                                                                                                                                                        ('/LoggerWrapper.h',43)   
18.      1   Forkedachildprocesstowatch         Forked a child process to watch                                                                                                                                                                                                                              ('',0)                    
19.      1   INITRAFTSERVERcommitindextermele      === INIT RAFT SERVER ===
commit index 0
term 2
election timer allowed
log store start 1, end 231
config log idx 19, prev log idx 1
 -- ASYNC REPLICATION --                                                                                                     ('/LoggerWrapper.h',43)   
20.      1   newconfigurationlogidxprevlogidx   new configuration: log idx 232, prev log idx 19
peer 1, DC ID 0, localhost:9234, voting member, 1
my id: 1, leader: 1, term: 3                                                                                                                                 ('/LoggerWrapper.h',43)   
21.      1   peerDCIDlocalhostvotingmembermyi   peer 1: DC ID 0, localhost:9234, voting member, 1
my id: 1, voting_member
num peers: 0                                                                                                                                                                         ('/LoggerWrapper.h',43)   
22.      1   startingup                         starting up                                                                                                                                                                                                                                                  ('',0)                    
23.      1   newelectiontimeoutrange            new election timeout range: 0 - 0                                                                                                                                                                                                                            ('/LoggerWrapper.h',43)   
24.      1   PRIORITYdecaytargetmine            [PRIORITY] decay, target 1 -> 1, mine 1                                                                                                                                                                                                                      ('/LoggerWrapper.h',43)   
25.      1   BECOMELEADERappendednewconfigat    [BECOME LEADER] appended new config at 232                                                                                                                                                                                                                   ('/LoggerWrapper.h',43)   
26.      1   globalmanagerdoesnotexistwilluse   global manager does not exist. will use local thread for commit and append                                                                                                                                                                                   ('/LoggerWrapper.h',43)   
27.      1   invalidelectiontimeoutlowerbound   invalid election timeout lower bound detected, adjusted to 0                                                                                                                                                                                                 ('/LoggerWrapper.h',43)   
28.      1   newconfiglogidxprevlogidxcurconf   new config log idx 232, prev log idx 19, cur config log idx 19, prev log idx 1                                                                                                                                                                               ('/LoggerWrapper.h',43)   
29.      1   ELECTIONTIMEOUTcurrentrolefollow   [ELECTION TIMEOUT] current role: follower, log last term 2, state term 2, target p 1, my p 1, hb dead, pre-vote NOT done                                                                                                                                     ('/LoggerWrapper.h',43)   
30.      1   VOTEINITmyidmyrolecandidateterml   [VOTE INIT] my id 1, my role candidate, term 3, log idx 231, log term 2, priority (target 1 / mine 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)       119   /var/lib/clickhouse/disks/s3_disk/store/da3/da3dce89-81f6-4a78-9e6a-2a7fcfc493cd/tmp_merge_201403_1_6_1/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 1 similar messages)                    
2.  Query {} to stage {}{}                                                                                      69   Query SELECT 'token-transfer-0x758f1bbabb160683e1c80ed52dcd24a32b599d40edf1cec91b5f1199c0e392a2-56' AS `'token-transfer-0x758f1bbabb160683e1c80ed52dcd24a32b599d40edf1cec91b5f1199c0e392a2-56'`, _CAST('Ӈ���Jl����X��X̊�Y', 'FixedString(20)') AS `hex2bytes('0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459')`, 3e21 AS `3e21`, '2024-01-02 16:54:59' AS `'2024-01-02 16:54:59'`, 'abc' AS `'abc'` FROM system.one AS __table1 to stage Complete 
3.  Query {} from stage {} to stage {}{}                                                                        69   Query SELECT 'token-transfer-0x758f1bbabb160683e1c80ed52dcd24a32b599d40edf1cec91b5f1199c0e392a2-56' AS `'token-transfer-0x758f1bbabb160683e1c80ed52dcd24a32b599d40edf1cec91b5f1199c0e392a2-56'`, _CAST('Ӈ���Jl����X��X̊�Y', 'FixedString(20)') AS `hex2bytes('0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459')`, 3e21 AS `3e21`, '2024-01-02 16:54:59' AS `'2024-01-02 16:54:59'`, 'abc' AS `'abc'` FROM system.one AS __table1 from stage FetchColumns to stage Complete 
4.                                                                                                              30   Forked a child process to watch                                                                                                                                                                                                                            
5.  (from {}{}{}){}{} {} (stage: {})                                                                             1   (from [::1]:37752) (comment: 02682_quantiles_too_large_size.sql) -- This query throw high-level exception instead of low-level "too large size passed to allocator":
 SELECT * FROM format(RowBinary, 'ik2 	String, 	Sum 		AggregateFunction(sum, UInt16), 	A$g 		AggregateFunction(quantiles(0.4, 0.9), UInt64), 	GroupArray	AggregateFunction(groupArray, String)', '295TMi44400000005942762421546108502
�














































































z










*




















ParalcelParsingInputFormat



















































































te Date,     
I








�
























!











STRING




















































































































d Tuple(UInt8)
vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvTabSeparatedWithNamesAndTypes
d Date, a S)ring, x UInt32, y UInt64, z Float32
29TabSeparatevvvvvvvdRawWithNames
a UInt32
26TabSeparatedR,�b UInt32
26TabSeparatedRawWithNthNames



vvvvv

1
key U7878
'); (stage: Complete)



Top short messages:

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

1.  172   {}:{}: '{}'             src/Processors/Transforms/MergeJoinTransform.cpp:836: ' UInt32(size = 1) UInt32(size = 1) UInt32(size = 1)'                                                      30 
2.    7   {}                      ThreadFuzzer is enabled. Application will run slowly and unstable.                                                                                               27 
3.    2   Creating {}: {}         Creating table test_y8gr4pw0.tp_1: CREATE TABLE IF NOT EXISTS test_y8gr4pw0.tp_1 UUID '6c50b7eb-5110-4934-b7fb-64981835d                                        149 
4.    1   Found {} on {}          Found changelog_1_100000.bin on LocalLogDisk                                                                                                                     18



Top messages by level:

(0.0029334783801248706,'Number of arguments for function {} doesn\'t match: passed {}, should be {}')	Error
(0.00004184042063569546,'Client has gone away.')	Warning
(0.012763652761700208,'Sorting and writing part of data into temporary file {}')	Information
(0.04705652640827882,'Key {} is removed from metadata')	Debug
(0.06050589717484182,'Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.)')	Trace


2024-07-22 12:10:56,539 Stress test finished
+ echo -e 'Test script exit code\tOK\t\N\t'
+ rg -Fa 'No queries hung' /test_output/test_results.tsv
+ grep -Fa OK
No queries hung	OK	\N	
+ stop_server
+ local max_tries=90
+ local check_hang=true
+ local pid
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ pid=2961
+ clickhouse stop --max-tries 90 --do-not-kill
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2961.
The process with pid = 2961 is running.
Sent terminate signal to process with pid 2961.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2961.
The process with pid = 2961 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2961.
The process with pid = 2961 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2961.
The process with pid = 2961 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2961.
The process with pid = 2961 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2961.
The process with pid = 2961 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2961.
The process with pid = 2961 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2961.
The process with pid = 2961 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2961.
The process with pid = 2961 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2961.
The process with pid = 2961 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
+ 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 - - [22/Jul/2024:10:11:18 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 -
127.0.0.1 - - [22/Jul/2024:10:11:18 +0000] "PUT /devstoreaccount1/cont/hbjbhkuscycfpdiluhpayzgflppjuopi?blockid=xhgmwaqdaqreuqbacqjbcbjskusoyirkeyqjdqpemppssqmuuwezjihpjzczougf&comp=block HTTP/1.1" 201 -
127.0.0.1 - - [22/Jul/2024:10:11:18 +0000] "PUT /devstoreaccount1/cont/hbjbhkuscycfpdiluhpayzgflppjuopi?comp=blocklist HTTP/1.1" 201 -
127.0.0.1 - - [22/Jul/2024:10:11:18 +0000] "GET /devstoreaccount1/cont/hbjbhkuscycfpdiluhpayzgflppjuopi HTTP/1.1" 206 4
127.0.0.1 - - [22/Jul/2024:10:11:18 +0000] "GET /devstoreaccount1/cont/hbjbhkuscycfpdiluhpayzgflppjuopi HTTP/1.1" 206 2
127.0.0.1 - - [22/Jul/2024:10:11:18 +0000] "DELETE /devstoreaccount1/cont/hbjbhkuscycfpdiluhpayzgflppjuopi 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
++ 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
thread apply all backtrace full
info registers
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 58887
+ 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=58887
+ 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 = 58887.
The process with pid = 58887 is running.
Sent terminate signal to process with pid 58887.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 58887.
The process with pid = 58887 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 58887.
The process with pid = 58887 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 58887.
The process with pid = 58887 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 58887.
The process with pid = 58887 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 58887.
The process with pid = 58887 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 58887.
The process with pid = 58887 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 58887.
The process with pid = 58887 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 58887.
The process with pid = 58887 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ '[' -f /var/log/clickhouse-server/clickhouse-server.log ']'
+ '[' -f /var/log/clickhouse-server/stderr.log ']'
+ mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.final.log
+ check_logs_for_critical_errors
+ sed -n '/WARNING:.*anitizer/,/^$/p' /var/log/clickhouse-server/stderr.log
+ rg -Fav -e 'ASan doesn'\''t fully support makecontext/swapcontext functions' -e DB::Exception /test_output/tmp
+ echo -e 'No sanitizer asserts\tOK\t\N\t'
+ rm -f /test_output/tmp
+ rg -Fa ' <Fatal> Application: Child process was terminated by signal 9' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No OOM messages in clickhouse-server.log\tOK\t\N\t'
+ rg -Fa 'Code: 49. DB::Exception: ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No logical errors\tOK\t\N\t'
+ '[' -s /test_output/logical_errors.txt ']'
+ rm /test_output/logical_errors.txt
+ 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 ' <Fatal> ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No fatal messages in clickhouse-server.log\tOK\t\N\t'
+ '[' -s /test_output/fatal_messages.txt ']'
+ rm /test_output/fatal_messages.txt
+ rg -Faz '########################################' /test_output/gdb.log /test_output/stress_run_logs.tar.zst /test_output/test_results.tsv
+ rg -Fa ' received signal ' /test_output/gdb.log
+ dmesg -T
+ grep -q -F -e 'Out of memory: Killed process' -e 'oom_reaper: reaped process' -e oom-kill:constraint=CONSTRAINT_NONE /test_output/dmesg.log
+ echo -e 'No OOM in dmesg\tOK\t\N\t'
+ tar -chf /test_output/coordination.tar /var/lib/clickhouse/coordination
tar: Removing leading `/' from member names
tar: Removing leading `/' from hard link targets
+ collect_query_and_trace_logs
+ for table in query_log trace_log
+ clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.query_log format TSVWithNamesAndTypes'
+ zstd --threads=0
Processing configuration file '/etc/clickhouse-server/config.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/CORS.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/asynchronous_metrics_update_period_s.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/azure_storage_conf.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/backoff_failed_mutation.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/backups.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/blob_storage_log.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/block_number.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/clusters.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/compressed_marks_and_index.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/core.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/custom_disks_base_path.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/custom_settings_prefixes.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/database_atomic.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/disable_s3_env_credentials.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/display_name.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/enable_access_control_improvements.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/enable_keeper_map.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/enable_wait_for_shutdown_replicated_tables.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/enable_zero_copy_replication.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/encryption.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/filesystem_cache_log.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/filesystem_caches_path.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/forbidden_headers.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/graphite.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/graphite_alternative.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/handlers.yaml'.
Merging configuration file '/etc/clickhouse-server/config.d/keeper_port.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/legacy_geobase.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/listen.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/logger_trace.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/logging_no_rotate.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/lost_forever_check.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/macros.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/max_concurrent_queries.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/max_num_to_warn.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/max_server_memory_usage.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/merge_tree.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/merge_tree_old_dirs_cleanup.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/merge_tree_settings.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/named_collection.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/nlp.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/prometheus.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/query_masking_rules.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/query_masking_rules.xml_original.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/secure_ports.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/session_log.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/ssl_certs.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/storage_conf.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02944.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02961.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02963.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/storage_metadata_with_full_object_key.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/system_unfreeze.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/tcp_with_proxy.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/test_cluster_with_incorrect_pw.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/text_log.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/top_level_domains_lists.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/top_level_domains_path.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/transactions.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/validate_tcp_client_information.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/zero_copy_destructive_operations.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_fault_injection.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_log.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_write.xml'.
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 - - [22/Jul/2024:10:12:43 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 -
+ for table in query_log trace_log
+ clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.trace_log format TSVWithNamesAndTypes'
+ zstd --threads=0
Processing configuration file '/etc/clickhouse-server/config.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/CORS.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/asynchronous_metrics_update_period_s.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/azure_storage_conf.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/backoff_failed_mutation.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/backups.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/blob_storage_log.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/block_number.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/clusters.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/compressed_marks_and_index.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/core.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/custom_disks_base_path.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/custom_settings_prefixes.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/database_atomic.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/disable_s3_env_credentials.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/display_name.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/enable_access_control_improvements.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/enable_keeper_map.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/enable_wait_for_shutdown_replicated_tables.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/enable_zero_copy_replication.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/encryption.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/filesystem_cache_log.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/filesystem_caches_path.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/forbidden_headers.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/graphite.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/graphite_alternative.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/handlers.yaml'.
Merging configuration file '/etc/clickhouse-server/config.d/keeper_port.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/legacy_geobase.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/listen.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/logger_trace.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/logging_no_rotate.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/lost_forever_check.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/macros.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/max_concurrent_queries.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/max_num_to_warn.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/max_server_memory_usage.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/merge_tree.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/merge_tree_old_dirs_cleanup.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/merge_tree_settings.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/named_collection.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/nlp.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/prometheus.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/query_masking_rules.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/query_masking_rules.xml_original.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/secure_ports.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/session_log.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/ssl_certs.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/storage_conf.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02944.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02961.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/storage_conf_02963.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/storage_metadata_with_full_object_key.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/system_unfreeze.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/tcp_with_proxy.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/test_cluster_with_incorrect_pw.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/text_log.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/top_level_domains_lists.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/top_level_domains_path.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/transactions.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/validate_tcp_client_information.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/zero_copy_destructive_operations.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_fault_injection.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_log.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/zookeeper_write.xml'.
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 - - [22/Jul/2024:10:12:55 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 -
+ 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