+ dmesg --clear
+ source /setup_export_logs.sh
++ CLICKHOUSE_CI_LOGS_CREDENTIALS=/tmp/export-logs-config.sh
++ CLICKHOUSE_CI_LOGS_USER=ci
++ CLICKHOUSE_CI_LOGS_CLUSTER=system_logs_export
++ EXTRA_COLUMNS='pull_request_number UInt32, commit_sha String, check_start_time DateTime('\''UTC'\''), check_name LowCardinality(String), instance_type LowCardinality(String), instance_id String, INDEX ix_pr (pull_request_number) TYPE set(100), INDEX ix_commit (commit_sha) TYPE set(100), INDEX ix_check_time (check_start_time) TYPE minmax, '
++ EXTRA_COLUMNS_EXPRESSION='CAST(0 AS UInt32) AS pull_request_number, '\'''\'' AS commit_sha, now() AS check_start_time, toLowCardinality('\'''\'') AS check_name, toLowCardinality('\'''\'') AS instance_type, '\'''\'' AS instance_id'
++ EXTRA_ORDER_BY_COLUMNS=check_name
++ EXTRA_COLUMNS_COVERAGE_LOG='pull_request_number UInt32, commit_sha String, check_start_time DateTime('\''UTC'\''), check_name LowCardinality(String), instance_type LowCardinality(String), instance_id String, INDEX ix_pr (pull_request_number) TYPE set(100), INDEX ix_commit (commit_sha) TYPE set(100), INDEX ix_check_time (check_start_time) TYPE minmax, symbols Array(LowCardinality(String)), '
++ EXTRA_COLUMNS_EXPRESSION_COVERAGE_LOG='CAST(0 AS UInt32) AS pull_request_number, '\'''\'' AS commit_sha, now() AS check_start_time, toLowCardinality('\'''\'') AS check_name, toLowCardinality('\'''\'') AS instance_type, '\'''\'' AS instance_id, arrayDistinct(arrayMap(x -> demangle(addressToSymbol(x)), coverage))::Array(LowCardinality(String)) AS symbols'
+ ln -s /repo/tests/clickhouse-test /usr/bin/clickhouse-test
+ source /repo/tests/docker_scripts/attach_gdb.lib
++ source /repo/tests/docker_scripts/utils.lib
+++ sysctl kernel.core_pattern=core.%e.%p-%P
kernel.core_pattern = core.%e.%p-%P
+++ sysctl fs.suid_dumpable=1
fs.suid_dumpable = 1
++ source /basic_helpers.sh
+ source /repo/tests/docker_scripts/stress_tests.lib
++ OK='\tOK\t\N\t'
++ FAIL='\tFAIL\t\N\t'
++ FAILURE_CONTEXT_LINES=100
++ FAILURE_CONTEXT_MAX_LINE_WIDTH=3000
++ source /basic_helpers.sh
+ source /repo/tests/docker_scripts/utils.lib
++ sysctl kernel.core_pattern=core.%e.%p-%P
kernel.core_pattern = core.%e.%p-%P
++ sysctl fs.suid_dumpable=1
fs.suid_dumpable = 1
+ install_packages package_folder
+ run_with_retry 3 dpkg -i package_folder/clickhouse-common-static_25.3.3.20366.altinityantalya+ubsan_amd64.deb
+ local retries=3
+ shift
+ local retry=0
+ '[' 0 -ge 3 ']'
+ dpkg -i package_folder/clickhouse-common-static_25.3.3.20366.altinityantalya+ubsan_amd64.deb
Selecting previously unselected package clickhouse-common-static.
(Reading database ... 48718 files and directories currently installed.)
Preparing to unpack .../clickhouse-common-static_25.3.3.20366.altinityantalya+ubsan_amd64.deb ...
Unpacking clickhouse-common-static (25.3.3.20366.altinityantalya+ubsan) ...
Setting up clickhouse-common-static (25.3.3.20366.altinityantalya+ubsan) ...
+ return
+ run_with_retry 3 dpkg -i package_folder/clickhouse-common-static-dbg_25.3.3.20366.altinityantalya+ubsan_amd64.deb
+ local retries=3
+ shift
+ local retry=0
+ '[' 0 -ge 3 ']'
+ dpkg -i package_folder/clickhouse-common-static-dbg_25.3.3.20366.altinityantalya+ubsan_amd64.deb
Selecting previously unselected package clickhouse-common-static-dbg.
(Reading database ... 48745 files and directories currently installed.)
Preparing to unpack .../clickhouse-common-static-dbg_25.3.3.20366.altinityantalya+ubsan_amd64.deb ...
Unpacking clickhouse-common-static-dbg (25.3.3.20366.altinityantalya+ubsan) ...
Setting up clickhouse-common-static-dbg (25.3.3.20366.altinityantalya+ubsan) ...
+ return
+ run_with_retry 3 dpkg -i package_folder/clickhouse-server_25.3.3.20366.altinityantalya+ubsan_amd64.deb
+ local retries=3
+ shift
+ local retry=0
+ '[' 0 -ge 3 ']'
+ dpkg -i package_folder/clickhouse-server_25.3.3.20366.altinityantalya+ubsan_amd64.deb
Selecting previously unselected package clickhouse-server.
(Reading database ... 48752 files and directories currently installed.)
Preparing to unpack .../clickhouse-server_25.3.3.20366.altinityantalya+ubsan_amd64.deb ...
Unpacking clickhouse-server (25.3.3.20366.altinityantalya+ubsan) ...
Setting up clickhouse-server (25.3.3.20366.altinityantalya+ubsan) ...
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
+ return
+ run_with_retry 3 dpkg -i package_folder/clickhouse-client_25.3.3.20366.altinityantalya+ubsan_amd64.deb
+ local retries=3
+ shift
+ local retry=0
+ '[' 0 -ge 3 ']'
+ dpkg -i package_folder/clickhouse-client_25.3.3.20366.altinityantalya+ubsan_amd64.deb
Selecting previously unselected package clickhouse-client.
(Reading database ... 48769 files and directories currently installed.)
Preparing to unpack .../clickhouse-client_25.3.3.20366.altinityantalya+ubsan_amd64.deb ...
Unpacking clickhouse-client (25.3.3.20366.altinityantalya+ubsan) ...
Setting up clickhouse-client (25.3.3.20366.altinityantalya+ubsan) ...
+ return
+ 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
+ /repo/tests/config/install.sh
+ DEST_SERVER_PATH=/etc/clickhouse-server
+ DEST_CLIENT_PATH=/etc/clickhouse-client
+++ dirname /repo/tests/config/install.sh
++ cd /repo/tests/config
++ pwd -P
+ SRC_PATH=/repo/tests/config
+ '[' 0 -ge 2 ']'
+ FAST_TEST=0
+ NO_AZURE=0
+ [[ 0 -gt 0 ]]
Going to install test configs from /repo/tests/config into /etc/clickhouse-server
+ echo 'Going to install test configs from /repo/tests/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 /repo/tests/config/config.d/tmp.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/listen.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/text_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/database_catalog_drop_table_concurrency.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/macros.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/clusters.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/graphite.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/grpc_protocol.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/transactions.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/encryption.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/session_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/nlp.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/display_name.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/backups.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/threadpool_writer_pool_size.yaml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/serverwide_trace_collector.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/rocksdb.xml /etc/clickhouse-server/config.d/
+ '[' 0 '!=' 1 ']'
+ ln -sf /repo/tests/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/readonly.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/ci_logs_sender.yaml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/access_management.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/filelog.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/marks.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/limits.yaml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /repo/tests/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/ints_dictionary.xml /etc/clickhouse-server/
+ ln -sf /repo/tests/config/strings_dictionary.xml /etc/clickhouse-server/
+ ln -sf /repo/tests/config/decimals_dictionary.xml /etc/clickhouse-server/
+ ln -sf /repo/tests/config/executable_dictionary.xml /etc/clickhouse-server/
+ ln -sf /repo/tests/config/executable_pool_dictionary.xml /etc/clickhouse-server/
+ ln -sf /repo/tests/config/test_function.xml /etc/clickhouse-server/
+ ln -sf /repo/tests/config/top_level_domains /etc/clickhouse-server/
+ ln -sf /repo/tests/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/regions_names_en.txt /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/regions_names_es.txt /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/ext-en.txt /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/ext-ru.txt /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/lem-en.bin /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/server.key /etc/clickhouse-server/
+ ln -sf /repo/tests/config/server.crt /etc/clickhouse-server/
+ ln -sf /repo/tests/config/dhparam.pem /etc/clickhouse-server/
+ ln -sf --backup=simple --suffix=_original.xml /repo/tests/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 /repo/tests/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/
+ [[ -n '' ]]
+ rm -f /etc/clickhouse-server/config.d/cannot_allocate_thread_injection.xml
+ value=0
+ sed --follow-symlinks -i 's|[01]|0|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=48017408
+ sed --follow-symlinks -i 's|[[:digit:]]\+|48017408|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=8456192
+ sed --follow-symlinks -i 's|[[:digit:]]\+|8456192|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=1
+ sed --follow-symlinks -i 's|[01]|1|' /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n '' ]]
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /repo/tests/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/
+ [[ '' == \1 ]]
+ [[ '' == \1 ]]
+ [[ 1 == \1 ]]
+ [[ 0 != \1 ]]
+ ln -sf /repo/tests/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/
+ [[ '' == \1 ]]
+ [[ '' == \1 ]]
+ ln -sf /repo/tests/config/client_config.xml /etc/clickhouse-client/config.xml
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|100000|10000|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value filtered_list keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value multi_read keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value check_not_exists keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value create_if_not_exists keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value remove_recursive keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value use_compression zookeeper_fault_injection
+ value=0
+ sed 's|[01]|0|'
+ sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ randomize_config_boolean_value use_xid_64 zookeeper_fault_injection
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\'''
+ export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ sudo chown root: /var/lib/clickhouse
+ local total_mem
++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo
+ total_mem=32086444
+ total_mem=32856518656
+ max_server_memory_usage_to_ram_ratio=0.5
+ echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5'
+ cat
Setting max_server_memory_usage_to_ram_ratio to 0.5
Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G
+ local max_users_mem
+ max_users_mem=9856955596
+ echo 'Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G'
+ cat
+ cat
+ /repo/tests/docker_scripts/setup_minio.sh stateless
+ export MINIO_ROOT_USER=clickhouse
+ MINIO_ROOT_USER=clickhouse
+ export MINIO_ROOT_PASSWORD=clickhouse
+ MINIO_ROOT_PASSWORD=clickhouse
+ main stateless
+ local query_dir
++ check_arg stateless
++ local query_dir
++ '[' '!' 1 -eq 1 ']'
++ case "$1" in
++ query_dir=0_stateless
++ echo 0_stateless
+ query_dir=0_stateless
+ '[' '!' -f ./minio ']'
+ start_minio
+ mkdir -p ./minio_data
+ ./minio --version
minio version RELEASE.2024-08-03T04-33-23Z (commit-id=6efb56851c40da88d1ca15112e2d686a4ecec6b3)
Runtime: go1.22.5 linux/amd64
License: GNU AGPLv3 - https://www.gnu.org/licenses/agpl-3.0.html
Copyright: 2015-2024 MinIO, Inc.
+ wait_for_it
+ local counter=0
+ local max_counter=60
+ local url=http://localhost:11111
+ ./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
INFO: Formatting 1st pool, 1 set(s), 1 drives per set.
INFO: WARNING: Host local has more than 0 drives of set. A host failure will result in data becoming unavailable.
MinIO Object Storage Server
Copyright: 2015-2025 MinIO, Inc.
License: GNU AGPLv3 - https://www.gnu.org/licenses/agpl-3.0.html
Version: RELEASE.2024-08-03T04-33-23Z (go1.22.5 linux/amd64)
API: http://172.17.0.2:11111 http://127.0.0.1:11111
WebUI: http://172.17.0.2:35507 http://127.0.0.1:35507
Docs: https://min.io/docs/minio/linux/index.html
+ counter=1
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
AccessDeniedAccess Denied./185109B6A8ED11D77dc7eb22d3288ec80374614e9088e31d3668a6922ead55932dd2a8e56373820f
+ lsof -i :11111
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
minio 291 root 8u IPv4 35410 0t0 TCP localhost:11111 (LISTEN)
minio 291 root 9u IPv6 35411 0t0 TCP *:11111 (LISTEN)
minio 291 root 10u IPv6 35412 0t0 TCP localhost:11111 (LISTEN)
+ sleep 5
+ setup_minio stateless
+ local test_type=stateless
+ ./mc alias set clickminio http://localhost:11111 clickhouse clickhouse
Added `clickminio` successfully.
+ ./mc admin user add clickminio test testtest
Added user `test` successfully.
+ ./mc admin policy attach clickminio readwrite --user=test
Attached Policies: [readwrite]
To User: test
+ ./mc mb --ignore-existing clickminio/test
Bucket created successfully `clickminio/test`.
+ '[' stateless = stateless ']'
+ ./mc anonymous set public clickminio/test
Access permission for `clickminio/test` is set to `public`
+ upload_data 0_stateless /repo/tests/
+ local query_dir=0_stateless
+ local test_path=/repo/tests/
+ local data_path=/repo/tests//queries/0_stateless/data_minio
+ '[' -d /repo/tests//queries/0_stateless/data_minio ']'
+ ./mc cp --recursive /repo/tests//queries/0_stateless/data_minio/ clickminio/test/
`/repo/tests/queries/0_stateless/data_minio/02731.parquet` -> `clickminio/test/02731.parquet`
`/repo/tests/queries/0_stateless/data_minio/02366_data.jsonl` -> `clickminio/test/02366_data.jsonl`
`/repo/tests/queries/0_stateless/data_minio/02731.arrow` -> `clickminio/test/02731.arrow`
`/repo/tests/queries/0_stateless/data_minio/02876.parquet` -> `clickminio/test/02876.parquet`
`/repo/tests/queries/0_stateless/data_minio/03036_archive1.tar` -> `clickminio/test/03036_archive1.tar`
`/repo/tests/queries/0_stateless/data_minio/03036_archive1.zip` -> `clickminio/test/03036_archive1.zip`
`/repo/tests/queries/0_stateless/data_minio/03036_archive2.tar` -> `clickminio/test/03036_archive2.tar`
`/repo/tests/queries/0_stateless/data_minio/03036_archive2.zip` -> `clickminio/test/03036_archive2.zip`
`/repo/tests/queries/0_stateless/data_minio/03036_archive3.tar.gz` -> `clickminio/test/03036_archive3.tar.gz`
`/repo/tests/queries/0_stateless/data_minio/03036_compressed_file_archive.zip` -> `clickminio/test/03036_compressed_file_archive.zip`
`/repo/tests/queries/0_stateless/data_minio/03036_json_archive.zip` -> `clickminio/test/03036_json_archive.zip`
`/repo/tests/queries/0_stateless/data_minio/03322_a.parquet` -> `clickminio/test/03322_a.parquet`
`/repo/tests/queries/0_stateless/data_minio/03322_b.parquet` -> `clickminio/test/03322_b.parquet`
`/repo/tests/queries/0_stateless/data_minio/a.tsv` -> `clickminio/test/a.tsv`
`/repo/tests/queries/0_stateless/data_minio/b.tsv` -> `clickminio/test/b.tsv`
`/repo/tests/queries/0_stateless/data_minio/c.tsv` -> `clickminio/test/c.tsv`
`/repo/tests/queries/0_stateless/data_minio/est/data/00000-0-52725061-398c-41fa-a222-0981e71942b0-0-00001.parquet` -> `clickminio/test/est/data/00000-0-52725061-398c-41fa-a222-0981e71942b0-0-00001.parquet`
`/repo/tests/queries/0_stateless/data_minio/est/metadata/83521e92-07a7-450d-ba44-3a179b730c85-m0.avro` -> `clickminio/test/est/metadata/83521e92-07a7-450d-ba44-3a179b730c85-m0.avro`
`/repo/tests/queries/0_stateless/data_minio/est/metadata/snap-3858160944799047644-1-83521e92-07a7-450d-ba44-3a179b730c85.avro` -> `clickminio/test/est/metadata/snap-3858160944799047644-1-83521e92-07a7-450d-ba44-3a179b730c85.avro`
`/repo/tests/queries/0_stateless/data_minio/est/metadata/v2.metadata.json` -> `clickminio/test/est/metadata/v2.metadata.json`
`/repo/tests/queries/0_stateless/data_minio/hive_partitioning/column0=Elizabeth/column1=Gordon/sample.parquet` -> `clickminio/test/hive_partitioning/column0=Elizabeth/column1=Gordon/sample.parquet`
`/repo/tests/queries/0_stateless/data_minio/hive_partitioning/column0=Elizabeth/column1=Schmidt/sample.parquet` -> `clickminio/test/hive_partitioning/column0=Elizabeth/column1=Schmidt/sample.parquet`
`/repo/tests/queries/0_stateless/data_minio/hive_partitioning/column0=Elizabeth/sample.parquet` -> `clickminio/test/hive_partitioning/column0=Elizabeth/sample.parquet`
`/repo/tests/queries/0_stateless/data_minio/hive_partitioning/non_existing_column=Elizabeth/sample.parquet` -> `clickminio/test/hive_partitioning/non_existing_column=Elizabeth/sample.parquet`
`/repo/tests/queries/0_stateless/data_minio/json_data` -> `clickminio/test/json_data`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/data/00000-0-7e41b120-8dbb-4f03-a487-fab888fe1037-0-00001.parquet` -> `clickminio/test/merged_several_tables_test/data/00000-0-7e41b120-8dbb-4f03-a487-fab888fe1037-0-00001.parquet`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/data/00000-2-3f64c5e4-85a1-4846-bca2-ec61df4bd056-0-00001.parquet` -> `clickminio/test/merged_several_tables_test/data/00000-2-3f64c5e4-85a1-4846-bca2-ec61df4bd056-0-00001.parquet`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/data/00000-4-21e1734e-704f-43d0-aef8-0d4baf8caaa3-0-00001.parquet` -> `clickminio/test/merged_several_tables_test/data/00000-4-21e1734e-704f-43d0-aef8-0d4baf8caaa3-0-00001.parquet`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/data/00001-1-7e41b120-8dbb-4f03-a487-fab888fe1037-0-00001.parquet` -> `clickminio/test/merged_several_tables_test/data/00001-1-7e41b120-8dbb-4f03-a487-fab888fe1037-0-00001.parquet`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/data/00001-3-3f64c5e4-85a1-4846-bca2-ec61df4bd056-0-00001.parquet` -> `clickminio/test/merged_several_tables_test/data/00001-3-3f64c5e4-85a1-4846-bca2-ec61df4bd056-0-00001.parquet`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/data/00001-5-21e1734e-704f-43d0-aef8-0d4baf8caaa3-0-00001.parquet` -> `clickminio/test/merged_several_tables_test/data/00001-5-21e1734e-704f-43d0-aef8-0d4baf8caaa3-0-00001.parquet`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/metadata/00001-1e2722c2-33bc-4e24-a119-224f22616082.metadata.json` -> `clickminio/test/merged_several_tables_test/metadata/00001-1e2722c2-33bc-4e24-a119-224f22616082.metadata.json`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/metadata/00001-2aad93a8-a893-4943-8504-f6021f83ecab.metadata.json` -> `clickminio/test/merged_several_tables_test/metadata/00001-2aad93a8-a893-4943-8504-f6021f83ecab.metadata.json`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/metadata/00001-aec4e034-3f73-48f7-87ad-51b7b42a8db7.metadata.json` -> `clickminio/test/merged_several_tables_test/metadata/00001-aec4e034-3f73-48f7-87ad-51b7b42a8db7.metadata.json`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/metadata/00002-0d450afb-f0d1-4fe7-a6c1-a75a4deb78d0.metadata.json` -> `clickminio/test/merged_several_tables_test/metadata/00002-0d450afb-f0d1-4fe7-a6c1-a75a4deb78d0.metadata.json`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/metadata/00002-4a776c8c-bb70-4422-8309-313bd05bc984.metadata.json` -> `clickminio/test/merged_several_tables_test/metadata/00002-4a776c8c-bb70-4422-8309-313bd05bc984.metadata.json`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/metadata/00002-c7c8a160-5d43-4705-87a1-dfabc4677b9c.metadata.json` -> `clickminio/test/merged_several_tables_test/metadata/00002-c7c8a160-5d43-4705-87a1-dfabc4677b9c.metadata.json`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/metadata/12684bd2-2274-4262-962a-40f06681d0ad-m0.avro` -> `clickminio/test/merged_several_tables_test/metadata/12684bd2-2274-4262-962a-40f06681d0ad-m0.avro`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/metadata/5f3bf1e1-6bf9-42de-b42c-932989d02512-m0.avro` -> `clickminio/test/merged_several_tables_test/metadata/5f3bf1e1-6bf9-42de-b42c-932989d02512-m0.avro`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/metadata/966c9c10-0bdb-4885-9654-22a3d4513c19-m0.avro` -> `clickminio/test/merged_several_tables_test/metadata/966c9c10-0bdb-4885-9654-22a3d4513c19-m0.avro`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/metadata/snap-1893158857028005124-1-5f3bf1e1-6bf9-42de-b42c-932989d02512.avro` -> `clickminio/test/merged_several_tables_test/metadata/snap-1893158857028005124-1-5f3bf1e1-6bf9-42de-b42c-932989d02512.avro`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/metadata/snap-5813107004148504843-1-12684bd2-2274-4262-962a-40f06681d0ad.avro` -> `clickminio/test/merged_several_tables_test/metadata/snap-5813107004148504843-1-12684bd2-2274-4262-962a-40f06681d0ad.avro`
`/repo/tests/queries/0_stateless/data_minio/merged_several_tables_test/metadata/snap-7645007302261205410-1-966c9c10-0bdb-4885-9654-22a3d4513c19.avro` -> `clickminio/test/merged_several_tables_test/metadata/snap-7645007302261205410-1-966c9c10-0bdb-4885-9654-22a3d4513c19.avro`
`/repo/tests/queries/0_stateless/data_minio/tsv_with_header.tsv` -> `clickminio/test/tsv_with_header.tsv`
Total: 5.48 MiB, Transferred: 5.48 MiB, Speed: 160.12 MiB/s
+ setup_aws_credentials
+ local minio_root_user=clickhouse
+ local minio_root_password=clickhouse
+ mkdir -p /root/.aws
+ cat
+ config_logs_export_cluster /etc/clickhouse-server/config.d/system_logs_export.yaml
+ set +x
File /tmp/export-logs-config.sh does not exist, do not setup
+ export CLICKHOUSE_MAX_THREADS=8
+ CLICKHOUSE_MAX_THREADS=8
+ export CLICKHOUSE_MAX_CONCURRENT_QUERIES=4
+ CLICKHOUSE_MAX_CONCURRENT_QUERIES=4
+ start_server
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 13 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=14
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 14 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=15
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 15 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=16
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 16 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=17
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 17 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=18
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 18 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=19
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 19 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=20
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ clickhouse local --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
+ IS_ASAN=0
+ [[ 0 = \1 ]]
++ kill -l SIGRTMIN
+ RTMIN=34
+ echo '
set follow-fork-mode parent
handle SIGHUP nostop noprint pass
handle SIGINT nostop noprint pass
handle SIGQUIT nostop noprint pass
handle SIGPIPE nostop noprint pass
handle SIGTERM nostop noprint pass
handle SIGUSR1 nostop noprint pass
handle SIGUSR2 nostop noprint pass
handle SIG34 nostop noprint pass
info signals
# safeExit is called if graceful shutdown times out. Print stack traces in that case.
break safeExit
continue
backtrace full
info registers
p top' 1 KiB of the 'stack:
p/x *(uint64_t[128]*)$sp
maintenance info sections
thread apply all backtrace full
disassemble /s
up
disassemble /s
up
disassemble /s
p "done"
detach
quit
'
+ sleep 5
+ ts '%Y-%m-%d %H:%M:%S'
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ gdb -batch -command script.gdb -p 426
aarch64-binfmt-P: Could not open '/lib/ld-linux-aarch64.so.1': No such file or directory
+ run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
+ local 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
+ 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
+ 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=426
+ for i in {1..30}
+ clickhouse client -q 'SYSTEM STOP DISTRIBUTED SENDS'
+ break
+ clickhouse stop --max-tries 90 --do-not-kill
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 426.
The process with pid = 426 is running.
Sent terminate signal to process with pid 426.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 426.
The process with pid = 426 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 426.
The process with pid = 426 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 426.
The process with pid = 426 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 426.
The process with pid = 426 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 426.
The process with pid = 426 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 426.
The process with pid = 426 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 426.
The process with pid = 426 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 426.
The process with pid = 426 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 426.
The process with pid = 426 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 426.
The process with pid = 426 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 426.
The process with pid = 426 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 426.
The process with pid = 426 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 426.
The process with pid = 426 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 426.
The process with pid = 426 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 ']'
Using cache policy: LRU
+ sudo cat /etc/clickhouse-server/users.d/stress_tests_overrides.xml
cat: /etc/clickhouse-server/users.d/stress_tests_overrides.xml: No such file or directory
+ start_server
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 13 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=14
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 14 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=15
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 15 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=16
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 16 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=17
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 17 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=18
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 18 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=19
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 19 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=20
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 20 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=21
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 21 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=22
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 22 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=23
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 23 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=24
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ clickhouse local --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
+ IS_ASAN=0
+ [[ 0 = \1 ]]
++ kill -l SIGRTMIN
+ RTMIN=34
+ echo '
set follow-fork-mode parent
handle SIGHUP nostop noprint pass
handle SIGINT nostop noprint pass
handle SIGQUIT nostop noprint pass
handle SIGPIPE nostop noprint pass
handle SIGTERM nostop noprint pass
handle SIGUSR1 nostop noprint pass
handle SIGUSR2 nostop noprint pass
handle SIG34 nostop noprint pass
info signals
# safeExit is called if graceful shutdown times out. Print stack traces in that case.
break safeExit
continue
backtrace full
info registers
p top' 1 KiB of the 'stack:
p/x *(uint64_t[128]*)$sp
maintenance info sections
thread apply all backtrace full
disassemble /s
up
disassemble /s
up
disassemble /s
p "done"
detach
quit
'
+ sleep 5
+ ts '%Y-%m-%d %H:%M:%S'
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ gdb -batch -command script.gdb -p 1363
aarch64-binfmt-P: Could not open '/lib/ld-linux-aarch64.so.1': No such file or directory
+ run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
+ local 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
+ return
+ clickhouse-client --query 'SHOW TABLES FROM datasets'
hits_v1
visits_v1
+ clickhouse-client --query 'SHOW TABLES FROM test'
+ [[ '' == \1 ]]
+ [[ '' == \1 ]]
+ TEMP_POLICY=default
+ clickhouse-client --query 'CREATE TABLE test.hits_s3 (WatchID UInt64, JavaEnable UInt8, Title String, GoodEvent Int16,
EventTime DateTime, EventDate Date, CounterID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RegionID UInt32,
UserID UInt64, CounterClass Int8, OS UInt8, UserAgent UInt8, URL String, Referer String, URLDomain String, RefererDomain String,
Refresh UInt8, IsRobot UInt8, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32),
RefererRegions Array(UInt32), ResolutionWidth UInt16, ResolutionHeight UInt16, ResolutionDepth UInt8, FlashMajor UInt8,
FlashMinor UInt8, FlashMinor2 String, NetMajor UInt8, NetMinor UInt8, UserAgentMajor UInt16, UserAgentMinor FixedString(2),
CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, MobilePhone UInt8, MobilePhoneModel String, Params String,
IPNetworkID UInt32, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, IsArtifical UInt8,
WindowClientWidth UInt16, WindowClientHeight UInt16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 UInt8,
SilverlightVersion2 UInt8, SilverlightVersion3 UInt32, SilverlightVersion4 UInt16, PageCharset String, CodeVersion UInt32,
IsLink UInt8, IsDownload UInt8, IsNotBounce UInt8, FUniqID UInt64, HID UInt32, IsOldCounter UInt8, IsEvent UInt8,
IsParameter UInt8, DontCountHits UInt8, WithHash UInt8, HitColor FixedString(1), UTCEventTime DateTime, Age UInt8,
Sex UInt8, Income UInt8, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), RemoteIP UInt32,
RemoteIP6 FixedString(16), WindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage FixedString(2),
BrowserCountry FixedString(2), SocialNetwork String, SocialAction String, HTTPError UInt16, SendTiming Int32,
DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, FetchTiming Int32,
RedirectTiming Int32, DOMInteractiveTiming Int32, DOMContentLoadedTiming Int32, DOMCompleteTiming Int32,
LoadEventStartTiming Int32, LoadEventEndTiming Int32, NSToDOMContentLoadedTiming Int32, FirstPaintTiming Int32,
RedirectCount Int8, SocialSourceNetworkID UInt8, SocialSourcePage String, ParamPrice Int64, ParamOrderID String,
ParamCurrency FixedString(3), ParamCurrencyID UInt16, GoalsReached Array(UInt32), OpenstatServiceName String,
OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String,
UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, RefererHash UInt64,
URLHash UInt64, CLID UInt32, YCLID UInt64, ShareService String, ShareURL String, ShareTitle String,
ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64),
IslandID FixedString(16), RequestNum UInt32, RequestTry UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate)
ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''default'\'''
+ clickhouse-client --query 'CREATE TABLE test.hits (WatchID UInt64, JavaEnable UInt8, Title String, GoodEvent Int16,
EventTime DateTime, EventDate Date, CounterID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RegionID UInt32,
UserID UInt64, CounterClass Int8, OS UInt8, UserAgent UInt8, URL String, Referer String, URLDomain String,
RefererDomain String, Refresh UInt8, IsRobot UInt8, RefererCategories Array(UInt16), URLCategories Array(UInt16),
URLRegions Array(UInt32), RefererRegions Array(UInt32), ResolutionWidth UInt16, ResolutionHeight UInt16, ResolutionDepth UInt8,
FlashMajor UInt8, FlashMinor UInt8, FlashMinor2 String, NetMajor UInt8, NetMinor UInt8, UserAgentMajor UInt16,
UserAgentMinor FixedString(2), CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, MobilePhone UInt8,
MobilePhoneModel String, Params String, IPNetworkID UInt32, TraficSourceID Int8, SearchEngineID UInt16,
SearchPhrase String, AdvEngineID UInt8, IsArtifical UInt8, WindowClientWidth UInt16, WindowClientHeight UInt16,
ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 UInt8, SilverlightVersion2 UInt8, SilverlightVersion3 UInt32,
SilverlightVersion4 UInt16, PageCharset String, CodeVersion UInt32, IsLink UInt8, IsDownload UInt8, IsNotBounce UInt8,
FUniqID UInt64, HID UInt32, IsOldCounter UInt8, IsEvent UInt8, IsParameter UInt8, DontCountHits UInt8, WithHash UInt8,
HitColor FixedString(1), UTCEventTime DateTime, Age UInt8, Sex UInt8, Income UInt8, Interests UInt16, Robotness UInt8,
GeneralInterests Array(UInt16), RemoteIP UInt32, RemoteIP6 FixedString(16), WindowName Int32, OpenerName Int32,
HistoryLength Int16, BrowserLanguage FixedString(2), BrowserCountry FixedString(2), SocialNetwork String, SocialAction String,
HTTPError UInt16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32,
FetchTiming Int32, RedirectTiming Int32, DOMInteractiveTiming Int32, DOMContentLoadedTiming Int32, DOMCompleteTiming Int32,
LoadEventStartTiming Int32, LoadEventEndTiming Int32, NSToDOMContentLoadedTiming Int32, FirstPaintTiming Int32,
RedirectCount Int8, SocialSourceNetworkID UInt8, SocialSourcePage String, ParamPrice Int64, ParamOrderID String,
ParamCurrency FixedString(3), ParamCurrencyID UInt16, GoalsReached Array(UInt32), OpenstatServiceName String,
OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String,
UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, RefererHash UInt64,
URLHash UInt64, CLID UInt32, YCLID UInt64, ShareService String, ShareURL String, ShareTitle String,
ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64),
IslandID FixedString(16), RequestNum UInt32, RequestTry UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate)
ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''default'\'''
+ clickhouse-client --query 'CREATE TABLE test.visits (CounterID UInt32, StartDate Date, Sign Int8, IsNew UInt8,
VisitID UInt64, UserID UInt64, StartTime DateTime, Duration UInt32, UTCStartTime DateTime, PageViews Int32,
Hits Int32, IsBounce UInt8, Referer String, StartURL String, RefererDomain String, StartURLDomain String,
EndURL String, LinkURL String, IsDownload UInt8, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String,
AdvEngineID UInt8, PlaceID Int32, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32),
RefererRegions Array(UInt32), IsYandex UInt8, GoalReachesDepth Int32, GoalReachesURL Int32, GoalReachesAny Int32,
SocialSourceNetworkID UInt8, SocialSourcePage String, MobilePhoneModel String, ClientEventTime DateTime, RegionID UInt32,
ClientIP UInt32, ClientIP6 FixedString(16), RemoteIP UInt32, RemoteIP6 FixedString(16), IPNetworkID UInt32,
SilverlightVersion3 UInt32, CodeVersion UInt32, ResolutionWidth UInt16, ResolutionHeight UInt16, UserAgentMajor UInt16,
UserAgentMinor UInt16, WindowClientWidth UInt16, WindowClientHeight UInt16, SilverlightVersion2 UInt8, SilverlightVersion4 UInt16,
FlashVersion3 UInt16, FlashVersion4 UInt16, ClientTimeZone Int16, OS UInt8, UserAgent UInt8, ResolutionDepth UInt8,
FlashMajor UInt8, FlashMinor UInt8, NetMajor UInt8, NetMinor UInt8, MobilePhone UInt8, SilverlightVersion1 UInt8,
Age UInt8, Sex UInt8, Income UInt8, JavaEnable UInt8, CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8,
BrowserLanguage UInt16, BrowserCountry UInt16, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16),
Params Array(String), Goals Nested(ID UInt32, Serial UInt32, EventTime DateTime, Price Int64, OrderID String, CurrencyID UInt32),
WatchIDs Array(UInt64), ParamSumPrice Int64, ParamCurrency FixedString(3), ParamCurrencyID UInt16, ClickLogID UInt64,
ClickEventID Int32, ClickGoodEvent Int32, ClickEventTime DateTime, ClickPriorityID Int32, ClickPhraseID Int32, ClickPageID Int32,
ClickPlaceID Int32, ClickTypeID Int32, ClickResourceID Int32, ClickCost UInt32, ClickClientIP UInt32, ClickDomainID UInt32,
ClickURL String, ClickAttempt UInt8, ClickOrderID UInt32, ClickBannerID UInt32, ClickMarketCategoryID UInt32, ClickMarketPP UInt32,
ClickMarketCategoryName String, ClickMarketPPName String, ClickAWAPSCampaignName String, ClickPageName String, ClickTargetType UInt16,
ClickTargetPhraseID UInt64, ClickContextType UInt8, ClickSelectType Int8, ClickOptions String, ClickGroupBannerID Int32,
OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String,
UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, FirstVisit DateTime,
PredLastVisit Date, LastVisit Date, TotalVisits UInt32, TraficSource Nested(ID Int8, SearchEngineID UInt16, AdvEngineID UInt8,
PlaceID UInt16, SocialSourceNetworkID UInt8, Domain String, SearchPhrase String, SocialSourcePage String), Attendance FixedString(16),
CLID UInt32, YCLID UInt64, NormalizedRefererHash UInt64, SearchPhraseHash UInt64, RefererDomainHash UInt64, NormalizedStartURLHash UInt64,
StartURLDomainHash UInt64, NormalizedEndURLHash UInt64, TopLevelDomain UInt64, URLScheme UInt64, OpenstatServiceNameHash UInt64,
OpenstatCampaignIDHash UInt64, OpenstatAdIDHash UInt64, OpenstatSourceIDHash UInt64, UTMSourceHash UInt64, UTMMediumHash UInt64,
UTMCampaignHash UInt64, UTMContentHash UInt64, UTMTermHash UInt64, FromHash UInt64, WebVisorEnabled UInt8, WebVisorActivity UInt32,
ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64),
Market Nested(Type UInt8, GoalID UInt32, OrderID String, OrderPrice Int64, PP UInt32, DirectPlaceID UInt32, DirectOrderID UInt32,
DirectBannerID UInt32, GoodID String, GoodName String, GoodQuantity Int32, GoodPrice Int64), IslandID FixedString(16))
ENGINE = CollapsingMergeTree(Sign) PARTITION BY toYYYYMM(StartDate) ORDER BY (CounterID, StartDate, intHash32(UserID), VisitID)
SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''default'\'''
+ clickhouse-client --query 'INSERT INTO test.hits_s3 SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16'
Received exception from server (version 25.3.3):
Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: User memory limit exceeded: would use 9.18 GiB (attempt to allocate chunk of 1.10 MiB bytes), maximum: 9.18 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker: (while reading column FUniqID): (while reading from part store/78e/78ebf6a1-d987-4579-b3ec-00c1a087b1f3/201403_1_1_2/ in table datasets.hits_v1 (78ebf6a1-d987-4579-b3ec-00c1a087b1f3) located on disk __tmp_internal_262634248876485800814430204900764312493 of type web, from mark 440 with max_rows_to_read = 8192): While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (MEMORY_LIMIT_EXCEEDED)
(query: INSERT INTO test.hits_s3 SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16)
+ clickhouse-client --query 'INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16'
Received exception from server (version 25.3.3):
Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: User memory limit exceeded: would use 9.18 GiB (attempt to allocate chunk of 32.00 MiB bytes), maximum: 9.18 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker. (MEMORY_LIMIT_EXCEEDED)
(query: INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16)
+ clickhouse-client --query 'INSERT INTO test.visits SELECT * FROM datasets.visits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16'
+ clickhouse-client --query 'DROP TABLE datasets.visits_v1 SYNC'
+ clickhouse-client --query 'DROP TABLE datasets.hits_v1 SYNC'
+ clickhouse-client --query 'SHOW TABLES FROM test'
hits
hits_s3
visits
+ clickhouse-client --query 'SYSTEM STOP THREAD FUZZER'
+ stop_server
+ local max_tries=90
+ local check_hang=true
+ local pid
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ pid=1363
+ for i in {1..30}
+ clickhouse client -q 'SYSTEM STOP DISTRIBUTED SENDS'
+ break
+ clickhouse stop --max-tries 90 --do-not-kill
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1363.
The process with pid = 1363 is running.
Sent terminate signal to process with pid 1363.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1363.
The process with pid = 1363 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1363.
The process with pid = 1363 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1363.
The process with pid = 1363 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1363.
The process with pid = 1363 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1363.
The process with pid = 1363 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ export RANDOMIZE_OBJECT_KEY_TYPE=1
+ RANDOMIZE_OBJECT_KEY_TYPE=1
+ export ZOOKEEPER_FAULT_INJECTION=1
+ ZOOKEEPER_FAULT_INJECTION=1
+ export THREAD_POOL_FAULT_INJECTION=1
+ THREAD_POOL_FAULT_INJECTION=1
+ configure
+ export USE_DATABASE_ORDINARY=1
+ USE_DATABASE_ORDINARY=1
+ export EXPORT_S3_STORAGE_POLICIES=1
+ EXPORT_S3_STORAGE_POLICIES=1
+ /repo/tests/config/install.sh
+ DEST_SERVER_PATH=/etc/clickhouse-server
+ DEST_CLIENT_PATH=/etc/clickhouse-client
+++ dirname /repo/tests/config/install.sh
++ cd /repo/tests/config
++ pwd -P
+ SRC_PATH=/repo/tests/config
+ '[' 0 -ge 2 ']'
+ FAST_TEST=0
+ NO_AZURE=0
Going to install test configs from /repo/tests/config into /etc/clickhouse-server
+ [[ 0 -gt 0 ]]
+ echo 'Going to install test configs from /repo/tests/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 /repo/tests/config/config.d/tmp.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/listen.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/text_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/database_catalog_drop_table_concurrency.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/macros.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/clusters.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/graphite.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/grpc_protocol.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/transactions.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/encryption.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/session_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/nlp.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/display_name.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/backups.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/threadpool_writer_pool_size.yaml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/serverwide_trace_collector.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/rocksdb.xml /etc/clickhouse-server/config.d/
+ '[' 0 '!=' 1 ']'
+ ln -sf /repo/tests/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/readonly.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/ci_logs_sender.yaml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/access_management.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/filelog.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/marks.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/limits.yaml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /repo/tests/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/ints_dictionary.xml /etc/clickhouse-server/
+ ln -sf /repo/tests/config/strings_dictionary.xml /etc/clickhouse-server/
+ ln -sf /repo/tests/config/decimals_dictionary.xml /etc/clickhouse-server/
+ ln -sf /repo/tests/config/executable_dictionary.xml /etc/clickhouse-server/
+ ln -sf /repo/tests/config/executable_pool_dictionary.xml /etc/clickhouse-server/
+ ln -sf /repo/tests/config/test_function.xml /etc/clickhouse-server/
+ ln -sf /repo/tests/config/top_level_domains /etc/clickhouse-server/
+ ln -sf /repo/tests/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/regions_names_en.txt /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/regions_names_es.txt /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/ext-en.txt /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/ext-ru.txt /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/lem-en.bin /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/server.key /etc/clickhouse-server/
+ ln -sf /repo/tests/config/server.crt /etc/clickhouse-server/
+ ln -sf /repo/tests/config/dhparam.pem /etc/clickhouse-server/
+ ln -sf --backup=simple --suffix=_original.xml /repo/tests/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 /repo/tests/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /repo/tests/config/config.d/cannot_allocate_thread_injection.xml /etc/clickhouse-server/config.d/
+ value=1
+ sed --follow-symlinks -i 's|[01]|1|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=26275840
+ sed --follow-symlinks -i 's|[[:digit:]]\+|26275840|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=36605952
+ sed --follow-symlinks -i 's|[[:digit:]]\+|36605952|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=1
+ sed --follow-symlinks -i 's|[01]|1|' /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n '' ]]
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /repo/tests/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/
+ [[ '' == \1 ]]
+ [[ '' == \1 ]]
+ [[ 1 == \1 ]]
+ [[ 0 != \1 ]]
+ ln -sf /repo/tests/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/
+ ln -sf /repo/tests/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/
+ ln -sf /repo/tests/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/
+ [[ '' == \1 ]]
+ [[ '' == \1 ]]
+ ln -sf /repo/tests/config/client_config.xml /etc/clickhouse-client/config.xml
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|100000|10000|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value filtered_list keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value multi_read keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value check_not_exists keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value create_if_not_exists keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value remove_recursive keeper_port
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value use_compression zookeeper_fault_injection
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ randomize_config_boolean_value use_xid_64 zookeeper_fault_injection
+ value=0
+ sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\'''
+ export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ sudo chown root: /var/lib/clickhouse
+ local total_mem
++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo
+ total_mem=32086444
+ total_mem=32856518656
+ max_server_memory_usage_to_ram_ratio=0.5
Setting max_server_memory_usage_to_ram_ratio to 0.5
+ echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5'
+ cat
Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G
+ local max_users_mem
+ max_users_mem=9856955596
+ echo 'Setting max_memory_usage_for_user=9856955596 and max_memory_usage for queries to 10G'
+ cat
+ cat
+ [[ '' == \1 ]]
+ [[ '' == \1 ]]
+ sudo cat /etc/clickhouse-server/config.d/logger_trace.xml
+ sed 's|trace|test|'
+ mv /etc/clickhouse-server/config.d/logger_trace.xml.tmp /etc/clickhouse-server/config.d/logger_trace.xml
+ '[' LRU = SLRU ']'
++ date +%-d
+ '[' 1 -eq 1 ']'
+ sudo echo 'true'
+ start_server
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 13 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=14
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 14 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=15
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 15 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=16
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 16 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=17
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 17 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=18
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 18 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=19
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 19 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=20
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 20 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=21
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 21 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=22
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 22 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=23
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 23 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=24
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 24 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=25
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 25 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=26
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 26 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=27
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 27 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=28
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ clickhouse local --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
+ IS_ASAN=0
+ [[ 0 = \1 ]]
++ kill -l SIGRTMIN
+ RTMIN=34
+ echo '
set follow-fork-mode parent
handle SIGHUP nostop noprint pass
handle SIGINT nostop noprint pass
handle SIGQUIT nostop noprint pass
handle SIGPIPE nostop noprint pass
handle SIGTERM nostop noprint pass
handle SIGUSR1 nostop noprint pass
handle SIGUSR2 nostop noprint pass
handle SIG34 nostop noprint pass
info signals
# safeExit is called if graceful shutdown times out. Print stack traces in that case.
break safeExit
continue
backtrace full
info registers
p top' 1 KiB of the 'stack:
p/x *(uint64_t[128]*)$sp
maintenance info sections
thread apply all backtrace full
disassemble /s
up
disassemble /s
up
disassemble /s
p "done"
detach
quit
'
+ sleep 5
+ ts '%Y-%m-%d %H:%M:%S'
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ gdb -batch -command script.gdb -p 2825
aarch64-binfmt-P: Could not open '/lib/ld-linux-aarch64.so.1': No such file or directory
+ run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
+ local 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
+ return
+ cd /repo/tests/
+ python3 /repo/tests/ci/stress.py --hung-check --drop-databases --output-folder /test_output --skip-func-tests '' --global-time-limit 1200
2025-07-11 02:10:27,920 Run func tests '/usr/bin/clickhouse-test --client-option ignore_drop_queries_probability=0.2 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 '
2025-07-11 02:10:28,422 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_1 --client-option join_use_nulls=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 http_make_head_request=0 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:10:28,923 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_2', 's1', 'r1')" --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:10:29,424 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_3 --client-option join_algorithm='partial_merge' group_by_use_nulls=1 optimize_trivial_approximate_count_query=1 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:10:29,925 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:10:30,427 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_5', 's1', 'r1')" --database=test_5 --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='full_sorting_merge' use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' group_by_use_nulls=1 http_make_head_request=1 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:10:30,928 Run func tests '/usr/bin/clickhouse-test --order=random --client-option memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:10:31,429 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_7 --client-option join_use_nulls=1 join_algorithm='grace_hash' group_by_use_nulls=1 optimize_trivial_approximate_count_query=1 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:10:31,931 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_8', 's1', 'r1')" --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:10:32,432 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_9 --client-option join_algorithm='auto' max_rows_in_join=1000 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' group_by_use_nulls=1 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:10:32,933 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 http_make_head_request=0 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:10:33,434 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_11', 's1', 'r1')" --database=test_11 --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 optimize_trivial_approximate_count_query=1 http_make_head_request=0 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:10:33,935 Run func tests '/usr/bin/clickhouse-test --order=random --client-option use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:10:34,436 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_13 --client-option join_use_nulls=1 join_algorithm='partial_merge' group_by_use_nulls=1 ignore_drop_queries_probability=0.2 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 '
2025-07-11 02:10:34,937 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_14', 's1', 'r1')" --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 http_make_head_request=1 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:10:35,438 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_merge' group_by_use_nulls=1 ignore_drop_queries_probability=0.2 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 '
2025-07-11 02:10:35,939 Will wait functests to finish
2025-07-11 02:10:35,939 Finished 0 from 16 processes
2025-07-11 02:10:40,944 Finished 0 from 16 processes
2025-07-11 02:10:45,948 Finished 0 from 16 processes
2025-07-11 02:10:50,952 Finished 0 from 16 processes
2025-07-11 02:10:55,956 Finished 0 from 16 processes
2025-07-11 02:11:00,960 Finished 0 from 16 processes
2025-07-11 02:11:05,964 Finished 0 from 16 processes
2025-07-11 02:11:10,969 Finished 0 from 16 processes
2025-07-11 02:11:15,972 Finished 0 from 16 processes
2025-07-11 02:11:20,976 Finished 0 from 16 processes
2025-07-11 02:11:25,980 Finished 0 from 16 processes
2025-07-11 02:11:30,984 Finished 0 from 16 processes
2025-07-11 02:11:35,989 Finished 0 from 16 processes
2025-07-11 02:11:40,992 Finished 0 from 16 processes
2025-07-11 02:11:45,996 Finished 0 from 16 processes
2025-07-11 02:11:51,000 Finished 0 from 16 processes
2025-07-11 02:11:56,004 Finished 0 from 16 processes
2025-07-11 02:12:01,008 Finished 0 from 16 processes
2025-07-11 02:12:06,012 Finished 0 from 16 processes
2025-07-11 02:12:11,016 Finished 0 from 16 processes
2025-07-11 02:12:16,019 Finished 0 from 16 processes
2025-07-11 02:12:21,024 Finished 0 from 16 processes
2025-07-11 02:12:26,028 Finished 0 from 16 processes
2025-07-11 02:12:31,032 Finished 0 from 16 processes
2025-07-11 02:12:36,036 Finished 0 from 16 processes
2025-07-11 02:12:41,040 Finished 0 from 16 processes
2025-07-11 02:12:46,044 Finished 0 from 16 processes
2025-07-11 02:12:51,048 Finished 0 from 16 processes
2025-07-11 02:12:56,052 Finished 0 from 16 processes
2025-07-11 02:13:01,053 Finished 0 from 16 processes
2025-07-11 02:13:06,056 Finished 0 from 16 processes
2025-07-11 02:13:11,060 Finished 0 from 16 processes
2025-07-11 02:13:16,065 Finished 0 from 16 processes
2025-07-11 02:13:21,070 Finished 1 from 16 processes
2025-07-11 02:13:26,075 Finished 1 from 16 processes
2025-07-11 02:13:31,080 Finished 1 from 16 processes
2025-07-11 02:13:36,084 Finished 1 from 16 processes
2025-07-11 02:13:41,088 Finished 1 from 16 processes
2025-07-11 02:13:46,090 Finished 1 from 16 processes
2025-07-11 02:13:51,092 Finished 1 from 16 processes
2025-07-11 02:13:56,096 Finished 1 from 16 processes
2025-07-11 02:14:01,100 Finished 1 from 16 processes
2025-07-11 02:14:06,104 Finished 1 from 16 processes
2025-07-11 02:14:11,108 Finished 1 from 16 processes
2025-07-11 02:14:16,109 Finished 1 from 16 processes
2025-07-11 02:14:21,112 Finished 1 from 16 processes
2025-07-11 02:14:26,116 Finished 1 from 16 processes
2025-07-11 02:14:31,120 Finished 1 from 16 processes
2025-07-11 02:14:36,124 Finished 1 from 16 processes
2025-07-11 02:14:41,128 Finished 1 from 16 processes
2025-07-11 02:14:46,132 Finished 1 from 16 processes
2025-07-11 02:14:51,136 Finished 1 from 16 processes
2025-07-11 02:14:56,140 Finished 1 from 16 processes
2025-07-11 02:15:01,140 Finished 1 from 16 processes
2025-07-11 02:15:06,144 Finished 1 from 16 processes
2025-07-11 02:15:11,149 Finished 1 from 16 processes
2025-07-11 02:15:16,152 Finished 1 from 16 processes
2025-07-11 02:15:21,154 Finished 1 from 16 processes
2025-07-11 02:15:26,156 Finished 1 from 16 processes
2025-07-11 02:15:31,160 Finished 1 from 16 processes
2025-07-11 02:15:36,160 Finished 1 from 16 processes
2025-07-11 02:15:41,164 Finished 1 from 16 processes
2025-07-11 02:15:46,168 Finished 1 from 16 processes
2025-07-11 02:15:51,172 Finished 1 from 16 processes
2025-07-11 02:15:56,176 Finished 1 from 16 processes
2025-07-11 02:16:01,180 Finished 1 from 16 processes
2025-07-11 02:16:06,184 Finished 1 from 16 processes
2025-07-11 02:16:11,188 Finished 1 from 16 processes
2025-07-11 02:16:16,193 Finished 1 from 16 processes
2025-07-11 02:16:21,197 Finished 1 from 16 processes
2025-07-11 02:16:26,200 Finished 1 from 16 processes
2025-07-11 02:16:31,204 Finished 1 from 16 processes
2025-07-11 02:16:36,208 Finished 1 from 16 processes
2025-07-11 02:16:41,212 Finished 1 from 16 processes
2025-07-11 02:16:46,217 Finished 1 from 16 processes
2025-07-11 02:16:51,220 Finished 1 from 16 processes
2025-07-11 02:16:56,224 Finished 1 from 16 processes
2025-07-11 02:17:01,229 Finished 1 from 16 processes
2025-07-11 02:17:06,232 Finished 1 from 16 processes
2025-07-11 02:17:11,236 Finished 1 from 16 processes
2025-07-11 02:17:16,240 Finished 1 from 16 processes
2025-07-11 02:17:21,244 Finished 1 from 16 processes
2025-07-11 02:17:26,249 Finished 1 from 16 processes
2025-07-11 02:17:31,252 Finished 1 from 16 processes
2025-07-11 02:17:36,256 Finished 1 from 16 processes
2025-07-11 02:17:41,260 Finished 1 from 16 processes
2025-07-11 02:17:46,264 Finished 1 from 16 processes
2025-07-11 02:17:51,268 Finished 1 from 16 processes
2025-07-11 02:17:56,272 Finished 1 from 16 processes
2025-07-11 02:18:01,276 Finished 1 from 16 processes
2025-07-11 02:18:06,280 Finished 1 from 16 processes
2025-07-11 02:18:11,282 Finished 1 from 16 processes
2025-07-11 02:18:16,283 Finished 1 from 16 processes
2025-07-11 02:18:21,288 Finished 1 from 16 processes
2025-07-11 02:18:26,293 Finished 1 from 16 processes
2025-07-11 02:18:31,296 Finished 1 from 16 processes
2025-07-11 02:18:36,300 Finished 1 from 16 processes
2025-07-11 02:18:41,304 Finished 1 from 16 processes
2025-07-11 02:18:46,308 Finished 1 from 16 processes
2025-07-11 02:18:51,312 Finished 1 from 16 processes
2025-07-11 02:18:56,316 Finished 1 from 16 processes
2025-07-11 02:19:01,320 Finished 1 from 16 processes
2025-07-11 02:19:06,324 Finished 1 from 16 processes
2025-07-11 02:19:11,328 Finished 1 from 16 processes
2025-07-11 02:19:16,333 Finished 1 from 16 processes
2025-07-11 02:19:21,337 Finished 1 from 16 processes
2025-07-11 02:19:26,340 Finished 1 from 16 processes
2025-07-11 02:19:31,344 Finished 1 from 16 processes
2025-07-11 02:19:36,348 Finished 1 from 16 processes
2025-07-11 02:19:41,352 Finished 1 from 16 processes
2025-07-11 02:19:46,357 Finished 1 from 16 processes
2025-07-11 02:19:51,360 Finished 1 from 16 processes
2025-07-11 02:19:56,365 Finished 1 from 16 processes
2025-07-11 02:20:01,368 Finished 1 from 16 processes
2025-07-11 02:20:06,372 Finished 1 from 16 processes
2025-07-11 02:20:11,376 Finished 1 from 16 processes
2025-07-11 02:20:16,380 Finished 1 from 16 processes
2025-07-11 02:20:21,384 Finished 1 from 16 processes
2025-07-11 02:20:26,388 Finished 1 from 16 processes
2025-07-11 02:20:31,392 Finished 1 from 16 processes
2025-07-11 02:20:36,396 Finished 1 from 16 processes
2025-07-11 02:20:41,400 Finished 1 from 16 processes
2025-07-11 02:20:46,404 Finished 1 from 16 processes
2025-07-11 02:20:51,408 Finished 1 from 16 processes
2025-07-11 02:20:56,412 Finished 1 from 16 processes
2025-07-11 02:21:01,416 Finished 1 from 16 processes
2025-07-11 02:21:06,420 Finished 1 from 16 processes
2025-07-11 02:21:11,424 Finished 1 from 16 processes
2025-07-11 02:21:16,429 Finished 1 from 16 processes
2025-07-11 02:21:21,432 Finished 1 from 16 processes
2025-07-11 02:21:26,437 Finished 1 from 16 processes
2025-07-11 02:21:31,440 Finished 1 from 16 processes
2025-07-11 02:21:36,445 Finished 1 from 16 processes
2025-07-11 02:21:41,448 Finished 1 from 16 processes
2025-07-11 02:21:46,451 Finished 1 from 16 processes
2025-07-11 02:21:51,456 Finished 1 from 16 processes
2025-07-11 02:21:56,460 Finished 1 from 16 processes
2025-07-11 02:22:01,465 Finished 1 from 16 processes
2025-07-11 02:22:06,468 Finished 1 from 16 processes
2025-07-11 02:22:11,472 Finished 1 from 16 processes
2025-07-11 02:22:16,476 Finished 1 from 16 processes
2025-07-11 02:22:21,481 Finished 1 from 16 processes
2025-07-11 02:22:26,484 Finished 1 from 16 processes
2025-07-11 02:22:31,489 Finished 1 from 16 processes
2025-07-11 02:22:36,494 Finished 1 from 16 processes
2025-07-11 02:22:41,496 Finished 1 from 16 processes
2025-07-11 02:22:46,500 Finished 1 from 16 processes
2025-07-11 02:22:51,504 Finished 1 from 16 processes
2025-07-11 02:22:56,506 Finished 1 from 16 processes
2025-07-11 02:23:01,508 Finished 1 from 16 processes
2025-07-11 02:23:06,512 Finished 1 from 16 processes
2025-07-11 02:23:11,516 Finished 1 from 16 processes
2025-07-11 02:23:16,521 Finished 1 from 16 processes
2025-07-11 02:23:21,524 Finished 1 from 16 processes
2025-07-11 02:23:26,528 Finished 1 from 16 processes
2025-07-11 02:23:31,532 Finished 1 from 16 processes
2025-07-11 02:23:36,535 Finished 1 from 16 processes
2025-07-11 02:23:41,540 Finished 1 from 16 processes
2025-07-11 02:23:46,544 Finished 1 from 16 processes
2025-07-11 02:23:51,548 Finished 1 from 16 processes
2025-07-11 02:23:56,551 Finished 1 from 16 processes
2025-07-11 02:24:01,556 Finished 1 from 16 processes
2025-07-11 02:24:06,560 Finished 1 from 16 processes
2025-07-11 02:24:11,565 Finished 1 from 16 processes
2025-07-11 02:24:16,566 Finished 1 from 16 processes
2025-07-11 02:24:21,569 Finished 1 from 16 processes
2025-07-11 02:24:26,572 Finished 1 from 16 processes
2025-07-11 02:24:31,576 Finished 1 from 16 processes
2025-07-11 02:24:36,580 Finished 1 from 16 processes
2025-07-11 02:24:41,584 Finished 1 from 16 processes
2025-07-11 02:24:46,588 Finished 1 from 16 processes
2025-07-11 02:24:51,593 Finished 1 from 16 processes
2025-07-11 02:24:56,596 Finished 1 from 16 processes
2025-07-11 02:25:01,600 Finished 1 from 16 processes
2025-07-11 02:25:06,605 Finished 1 from 16 processes
2025-07-11 02:25:11,608 Finished 1 from 16 processes
2025-07-11 02:25:16,612 Finished 1 from 16 processes
2025-07-11 02:25:21,616 Finished 1 from 16 processes
2025-07-11 02:25:26,620 Finished 1 from 16 processes
2025-07-11 02:25:31,624 Finished 1 from 16 processes
2025-07-11 02:25:36,625 Finished 1 from 16 processes
2025-07-11 02:25:41,630 Finished 1 from 16 processes
2025-07-11 02:25:46,631 Finished 1 from 16 processes
2025-07-11 02:25:51,635 Finished 1 from 16 processes
2025-07-11 02:25:56,640 Finished 1 from 16 processes
2025-07-11 02:26:01,644 Finished 1 from 16 processes
2025-07-11 02:26:06,648 Finished 1 from 16 processes
2025-07-11 02:26:11,652 Finished 1 from 16 processes
2025-07-11 02:26:16,656 Finished 1 from 16 processes
2025-07-11 02:26:21,660 Finished 1 from 16 processes
2025-07-11 02:26:26,664 Finished 1 from 16 processes
2025-07-11 02:26:31,668 Finished 1 from 16 processes
2025-07-11 02:26:36,672 Finished 1 from 16 processes
2025-07-11 02:26:41,677 Finished 1 from 16 processes
2025-07-11 02:26:46,682 Finished 1 from 16 processes
2025-07-11 02:26:51,684 Finished 1 from 16 processes
2025-07-11 02:26:56,688 Finished 1 from 16 processes
2025-07-11 02:27:01,692 Finished 1 from 16 processes
2025-07-11 02:27:06,696 Finished 1 from 16 processes
2025-07-11 02:27:11,700 Finished 1 from 16 processes
2025-07-11 02:27:16,705 Finished 1 from 16 processes
2025-07-11 02:27:21,709 Finished 1 from 16 processes
2025-07-11 02:27:26,712 Finished 1 from 16 processes
2025-07-11 02:27:31,716 Finished 1 from 16 processes
2025-07-11 02:27:36,720 Finished 1 from 16 processes
2025-07-11 02:27:41,721 Finished 1 from 16 processes
2025-07-11 02:27:46,724 Finished 1 from 16 processes
2025-07-11 02:27:51,728 Finished 1 from 16 processes
2025-07-11 02:27:56,732 Finished 1 from 16 processes
2025-07-11 02:28:01,736 Finished 1 from 16 processes
2025-07-11 02:28:06,740 Finished 1 from 16 processes
2025-07-11 02:28:11,744 Finished 1 from 16 processes
2025-07-11 02:28:16,748 Finished 1 from 16 processes
2025-07-11 02:28:21,752 Finished 1 from 16 processes
2025-07-11 02:28:26,754 Finished 1 from 16 processes
2025-07-11 02:28:31,756 Finished 1 from 16 processes
2025-07-11 02:28:36,762 Finished 1 from 16 processes
2025-07-11 02:28:41,764 Finished 1 from 16 processes
2025-07-11 02:28:46,769 Finished 1 from 16 processes
2025-07-11 02:28:51,770 Finished 1 from 16 processes
2025-07-11 02:28:56,772 Finished 1 from 16 processes
2025-07-11 02:29:01,776 Finished 1 from 16 processes
2025-07-11 02:29:06,778 Finished 1 from 16 processes
2025-07-11 02:29:11,780 Finished 1 from 16 processes
2025-07-11 02:29:16,785 Finished 1 from 16 processes
2025-07-11 02:29:21,788 Finished 1 from 16 processes
2025-07-11 02:29:26,792 Finished 1 from 16 processes
2025-07-11 02:29:31,796 Finished 1 from 16 processes
2025-07-11 02:29:36,800 Finished 1 from 16 processes
2025-07-11 02:29:41,804 Finished 1 from 16 processes
2025-07-11 02:29:46,809 Finished 1 from 16 processes
2025-07-11 02:29:51,814 Finished 1 from 16 processes
2025-07-11 02:29:56,819 Finished 1 from 16 processes
2025-07-11 02:30:01,824 Finished 1 from 16 processes
2025-07-11 02:30:06,828 Finished 1 from 16 processes
2025-07-11 02:30:11,829 Finished 1 from 16 processes
2025-07-11 02:30:16,833 Finished 1 from 16 processes
2025-07-11 02:30:21,836 Finished 1 from 16 processes
2025-07-11 02:30:26,841 Finished 1 from 16 processes
2025-07-11 02:30:31,846 Finished 2 from 16 processes
2025-07-11 02:30:36,849 Finished 4 from 16 processes
2025-07-11 02:30:41,854 Finished 5 from 16 processes
2025-07-11 02:30:46,856 Finished 5 from 16 processes
2025-07-11 02:30:51,861 Finished 6 from 16 processes
2025-07-11 02:30:56,865 Finished 8 from 16 processes
2025-07-11 02:31:01,871 Finished 9 from 16 processes
2025-07-11 02:31:06,873 Finished 9 from 16 processes
2025-07-11 02:31:11,874 Finished 12 from 16 processes
2025-07-11 02:31:16,876 Finished 12 from 16 processes
2025-07-11 02:31:21,878 Finished 12 from 16 processes
2025-07-11 02:31:26,884 Finished 12 from 16 processes
2025-07-11 02:31:31,888 Finished 12 from 16 processes
2025-07-11 02:31:36,890 Finished 12 from 16 processes
2025-07-11 02:31:41,891 Finished 12 from 16 processes
2025-07-11 02:31:46,896 Finished 12 from 16 processes
2025-07-11 02:31:51,901 Finished 12 from 16 processes
2025-07-11 02:31:56,904 Finished 12 from 16 processes
2025-07-11 02:32:01,909 Finished 12 from 16 processes
2025-07-11 02:32:06,914 Finished 12 from 16 processes
2025-07-11 02:32:11,916 Finished 12 from 16 processes
2025-07-11 02:32:16,918 Finished 12 from 16 processes
2025-07-11 02:32:21,920 Finished 12 from 16 processes
2025-07-11 02:32:26,924 Finished 12 from 16 processes
2025-07-11 02:32:31,929 Finished 12 from 16 processes
2025-07-11 02:32:36,931 Finished 12 from 16 processes
2025-07-11 02:32:41,936 Finished 12 from 16 processes
2025-07-11 02:32:46,940 Finished 12 from 16 processes
2025-07-11 02:32:51,944 Finished 12 from 16 processes
2025-07-11 02:32:56,945 Finished 12 from 16 processes
2025-07-11 02:33:01,950 Finished 12 from 16 processes
2025-07-11 02:33:06,955 Finished 12 from 16 processes
2025-07-11 02:33:11,961 Finished 12 from 16 processes
2025-07-11 02:33:16,961 Finished 12 from 16 processes
2025-07-11 02:33:21,964 Finished 12 from 16 processes
2025-07-11 02:33:26,969 Finished 12 from 16 processes
2025-07-11 02:33:31,972 Finished 12 from 16 processes
2025-07-11 02:33:36,977 Finished 12 from 16 processes
2025-07-11 02:33:41,981 Finished 12 from 16 processes
2025-07-11 02:33:46,986 Finished 12 from 16 processes
2025-07-11 02:33:51,991 Finished 12 from 16 processes
2025-07-11 02:33:56,991 Finished 12 from 16 processes
2025-07-11 02:34:01,994 Finished 12 from 16 processes
2025-07-11 02:34:06,999 Finished 12 from 16 processes
2025-07-11 02:34:12,005 Finished 12 from 16 processes
2025-07-11 02:34:17,008 Finished 12 from 16 processes
2025-07-11 02:34:22,011 Finished 12 from 16 processes
2025-07-11 02:34:27,016 Finished 12 from 16 processes
2025-07-11 02:34:32,021 Finished 12 from 16 processes
2025-07-11 02:34:37,026 Finished 12 from 16 processes
2025-07-11 02:34:42,031 Finished 12 from 16 processes
2025-07-11 02:34:47,037 Finished 12 from 16 processes
2025-07-11 02:34:52,039 Finished 12 from 16 processes
2025-07-11 02:34:57,044 Finished 12 from 16 processes
2025-07-11 02:35:02,045 Finished 12 from 16 processes
2025-07-11 02:35:07,046 Finished 13 from 16 processes
2025-07-11 02:35:12,051 Finished 13 from 16 processes
2025-07-11 02:35:17,057 Finished 13 from 16 processes
2025-07-11 02:35:22,059 Finished 13 from 16 processes
2025-07-11 02:35:27,064 Finished 13 from 16 processes
2025-07-11 02:35:32,069 Finished 13 from 16 processes
2025-07-11 02:35:37,071 Finished 13 from 16 processes
2025-07-11 02:35:42,077 Finished 13 from 16 processes
2025-07-11 02:35:47,081 Finished 13 from 16 processes
2025-07-11 02:35:52,084 Finished 13 from 16 processes
2025-07-11 02:35:57,089 Finished 13 from 16 processes
2025-07-11 02:36:02,094 Finished 13 from 16 processes
2025-07-11 02:36:07,100 Finished 13 from 16 processes
2025-07-11 02:36:12,101 Finished 13 from 16 processes
2025-07-11 02:36:17,106 Finished 13 from 16 processes
2025-07-11 02:36:22,112 Finished 13 from 16 processes
2025-07-11 02:36:27,117 Finished 13 from 16 processes
2025-07-11 02:36:32,120 Finished 13 from 16 processes
2025-07-11 02:36:37,120 Finished 13 from 16 processes
2025-07-11 02:36:42,126 Finished 13 from 16 processes
2025-07-11 02:36:47,131 Finished 13 from 16 processes
2025-07-11 02:36:52,136 Finished 13 from 16 processes
2025-07-11 02:36:57,142 Finished 13 from 16 processes
2025-07-11 02:37:02,147 Finished 13 from 16 processes
2025-07-11 02:37:07,151 Finished 13 from 16 processes
2025-07-11 02:37:12,155 Finished 14 from 16 processes
2025-07-11 02:37:17,160 Finished 14 from 16 processes
2025-07-11 02:37:22,165 Finished 14 from 16 processes
2025-07-11 02:37:27,170 Finished 14 from 16 processes
2025-07-11 02:37:32,176 Finished 14 from 16 processes
2025-07-11 02:37:37,181 Finished 14 from 16 processes
2025-07-11 02:37:42,184 Finished 15 from 16 processes
2025-07-11 02:37:47,188 Finished 15 from 16 processes
2025-07-11 02:37:52,193 Finished 15 from 16 processes
2025-07-11 02:37:57,198 Finished 15 from 16 processes
2025-07-11 02:38:02,204 Finished 15 from 16 processes
2025-07-11 02:38:07,209 Finished 15 from 16 processes
2025-07-11 02:38:12,214 Finished 15 from 16 processes
2025-07-11 02:38:17,219 Finished 15 from 16 processes
2025-07-11 02:38:22,224 Finished 15 from 16 processes
2025-07-11 02:38:27,224 Finished 15 from 16 processes
2025-07-11 02:38:32,228 Finished 15 from 16 processes
2025-07-11 02:38:37,232 Finished 15 from 16 processes
2025-07-11 02:38:42,237 Finished 15 from 16 processes
2025-07-11 02:38:47,242 Finished 15 from 16 processes
2025-07-11 02:38:52,248 Finished 15 from 16 processes
2025-07-11 02:38:57,249 Finished 15 from 16 processes
2025-07-11 02:39:02,254 Finished 15 from 16 processes
2025-07-11 02:39:07,256 Finished 15 from 16 processes
2025-07-11 02:39:12,259 Finished 15 from 16 processes
2025-07-11 02:39:17,260 All processes finished
2025-07-11 02:39:17,260 Compressing stress logs
2025-07-11 02:39:17,302 Logs compressed
2025-07-11 02:39:17,302 Will terminate gdb (if any)
2025-07-11 02:39:17,302 Running command: kill -TERM $(pidof gdb)
/bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or
kill -l [exitstatus]
2025-07-11 02:39:17,306 Command returned 2, retrying
/bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or
kill -l [exitstatus]
2025-07-11 02:39:17,310 Command returned 2, retrying
/bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or
kill -l [exitstatus]
2025-07-11 02:39:18,315 Command returned 2, retrying
/bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or
kill -l [exitstatus]
2025-07-11 02:39:20,321 Command returned 2, retrying
/bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or
kill -l [exitstatus]
2025-07-11 02:39:23,328 Command returned 2, retrying
2025-07-11 02:39:27,331 Running command: timeout 50s tail --pid=$(pidof gdb) -f /dev/null || kill -9 $(pidof gdb) ||:
tail: invalid PID: ‘’
/bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or
kill -l [exitstatus]
2025-07-11 02:39:27,342 Running command: kill -CONT $(cat /var/run/clickhouse-server/clickhouse-server.pid) && clickhouse client -q 'SELECT 1 FORMAT Null'
2025-07-11 02:39:27,607 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 --enable-progress-table-toggle=0
2025-07-11 02:39:27,922 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 --enable-progress-table-toggle=0
2025-07-11 02:39:28,087 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 --enable-progress-table-toggle=0
2025-07-11 02:39:28,251 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 --enable-progress-table-toggle=0
2025-07-11 02:39:28,416 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 --enable-progress-table-toggle=0
2025-07-11 02:39:28,580 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 --enable-progress-table-toggle=0
2025-07-11 02:39:28,745 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 --enable-progress-table-toggle=0
2025-07-11 02:39:28,909 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 --enable-progress-table-toggle=0
2025-07-11 02:39:29,073 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 --enable-progress-table-toggle=0
2025-07-11 02:39:29,238 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 --enable-progress-table-toggle=0
2025-07-11 02:39:29,402 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 --enable-progress-table-toggle=0
2025-07-11 02:39:29,567 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 --enable-progress-table-toggle=0
2025-07-11 02:39:29,731 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 --enable-progress-table-toggle=0
Received exception from server (version 25.3.3):
Code: 159. DB::Exception: Received from localhost:9000. DB::Exception: Timeout exceeded: elapsed 60047.707593 ms, maximum: 60000 ms. (TIMEOUT_EXCEEDED)
(query: SELECT sleepEachRow((
SELECT maxOrDefault(300 - elapsed) + 1
FROM system.processes
WHERE query NOT LIKE '%FROM system.processes%' AND elapsed < 300
) / 300)
FROM numbers(300)
FORMAT Null
SETTINGS function_sleep_max_microseconds_per_block = 0
)
2025-07-11 02:40:30,910 Checking if some queries hung
Using queries from 'queries' directory
Connecting to ClickHouse server... OK
Connected to server 25.3.3.20366.altinityantalya @ 1abef611c9a40dce30ed011ede491e532b2a3e72 HEAD
Found 1 parallel tests and 0 sequential tests
Running about 1 stateless tests (Process-3).
00001_select_1: [ OK ]
1 tests passed. 0 tests skipped. 0.28 s elapsed (Process-3).
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. 46326 0.071 9.80 MiB 0.085 1 125 ['Debug'] 0 (from {}{}{}){}{}{} {} (stage: {})
2. 46006 0.071 6.89 MiB 0.059 11159 124 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {}
3. 40735 0.063 1.12 MiB 0.01 1 124 ['Debug'] 0 Processed in {} sec.
4. 32487 0.05 850.94 KiB 0.007 1 172 ['Trace'] 0 Query to stage {}{}
5. 32055 0.049 1.56 MiB 0.013 1 172 ['Trace'] 0 Query from stage {} to stage {}{}
6. 23565 0.036 1.84 MiB 0.016 1 101 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec.
7. 14038 0.022 628.04 KiB 0.005 1 3 ['Trace'] 1 Processing requests batch, size: {}, bytes: {}
8. 12950 0.02 608.17 KiB 0.005 12950 158 ['Debug'] 0.997 Authenticating user '{}' from {}
9. 12749 0.02 1.40 MiB 0.012 12749 158 ['Debug'] 0.997 {} Authenticated with global context as user {}
10. 11183 0.017 982.88 KiB 0.008 11183 148 ['Debug'] 0.996 {} Logout, user_id: {}
11. 11178 0.017 818.70 KiB 0.007 11178 124 ['Debug'] 1 Creating session context with user_id: {}
12. 9359 0.014 348.42 KiB 0.003 1 147 ['Debug'] 0.118 {}{} memory usage: {}.
13. 9238 0.014 304.72 KiB 0.003 1 124 ['Trace'] 1 TCP Request. Address: {}
14. 9230 0.014 851.95 KiB 0.007 1 124 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}.
15. 9212 0.014 955.03 KiB 0.008 1 72 ['Trace'] 0.002 Checking existence of path: {}
16. 8912 0.014 626.72 KiB 0.005 1 735 ['Trace'] 0.501 Reserved {} on local disk {}, having unreserved {}.
17. 8910 0.014 1.03 MiB 0.009 1212 268 ['Trace'] 0.375 Renaming temporary part {} to {} with tid {}.
18. 8601 0.013 402.61 KiB 0.003 1 261 ['Trace'] 0.383 filled checksums {}
19. 8429 0.013 584.53 KiB 0.005 1201 704 ['Trace'] 0.501 Trying to reserve {} using storage policy from min volume index {}
20. 7609 0.012 200.63 KiB 0.002 1 114 ['Debug'] 1 Done processing connection.
21. 6597 0.01 596.08 KiB 0.005 1 123 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.)
22. 6436 0.01 194.94 KiB 0.002 1 123 ['Trace'] 0 Aggregation method: {}
23. 6244 0.01 581.49 KiB 0.005 1 70 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part
24. 6048 0.009 253.97 KiB 0.002 947 218 ['Debug'] 0.098 Found {} non used tables in detached tables.
25. 6048 0.009 360.28 KiB 0.003 947 218 ['Debug'] 0.098 There are {} detached tables. Start searching non used tables.
26. 6044 0.009 246.07 KiB 0.002 1 112 ['Trace'] 0 Read steps statistics: {}
27. 5736 0.009 2.04 MiB 0.018 2 17 ['Error'] 0.5 Number of arguments for function {} doesn't match: passed {}, should be {}
28. 4957 0.008 53.25 KiB 0 1 121 ['Trace'] 0 Aggregating
29. 4737 0.007 365.45 KiB 0.003 1 98 ['Trace'] 0 Query span trace_id for opentelemetry log: {}
30. 4647 0.007 104.38 KiB 0.001 1 121 ['Trace'] 0 Merging aggregated data
31. 4601 0.007 371.89 KiB 0.003 1 100 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={}
32. 4218 0.007 531.69 KiB 0.004 1 57 ['Trace'] 0 No query result found for query {}
33. 4142 0.006 320.68 KiB 0.003 592 102 ['Trace'] 0 Reading {} ranges in{}order from part {}, approx. {} rows starting from {}
34. 3803 0.006 102.72 KiB 0.001 751 111 ['Debug'] 0 Key condition: {}
35. 3734 0.006 704.78 KiB 0.006 2 86 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {}
36. 3727 0.006 4.82 MiB 0.042 2 86 ['Trace'] 1 Request URI: {}
37. 3568 0.006 6.25 MiB 0.054 5 84 ['Error'] 0.999 Database {} does not exist. Maybe you meant {}?
38. 3541 0.005 403.01 KiB 0.003 742 110 ['Debug'] 0 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges
39. 3468 0.005 380.56 KiB 0.003 1 103 ['Trace'] 0 Adjusting memory limit before external aggregation with {} (ratio: {}, available system memory: {})
40. 3381 0.005 148.58 KiB 0.001 750 111 ['Trace'] 0 Filtering marks by primary and secondary keys
41. 3298 0.005 190.20 KiB 0.002 19 44 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {}
42. 3287 0.005 117.48 KiB 0.001 19 44 ['Trace'] 1 Flushed system log up to offset {}
43. 3090 0.005 356.30 KiB 0.003 1 31 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {}
44. 3061 0.005 158.43 KiB 0.001 654 109 ['Trace'] 0 Spreading mark ranges among streams (default reading)
45. 2789 0.004 902.42 KiB 0.008 1 195 ['Trace'] 0.047 The new analyzer is enabled, but the old interpreter is used. It can be a bug, please report it. Will disable 'allow_experimental_analyzer' setting (for query: {})
46. 2755 0.004 56.50 KiB 0 2 84 ['Debug'] 0.018 Done processing query
47. 2746 0.004 186.80 KiB 0.002 1 153 ['Debug'] 1 Finish load job '{}' with status {}
48. 2746 0.004 205.59 KiB 0.002 1 85 ['Debug'] 0.032 Schedule load job '{}' into {}
49. 2746 0.004 197.55 KiB 0.002 1 153 ['Debug'] 1 Execute load job '{}' in {}
50. 2744 0.004 107.24 KiB 0.001 1 190 ['Debug'] 0.53 Spawn loader worker #{} in {}
51. 2744 0.004 77.73 KiB 0.001 1 163 ['Debug'] 1 Stop worker in {}
52. 2733 0.004 249.82 KiB 0.002 1 86 ['Debug'] 0.022 Prioritize load job '{}': {} -> {}
53. 2732 0.004 134.69 KiB 0.001 1 67 ['Trace'] 0 Merging partially aggregated blocks (bucket = {}).
54. 2726 0.004 402.17 KiB 0.003 1 67 ['Debug'] 0 Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.)
55. 2560 0.004 102.66 KiB 0.001 15 128 ['Trace'] 0.002 Sending external_roles with query: [{}] ({})
56. 2067 0.003 68.62 KiB 0.001 1 189 ['Debug'] 0.506 Change current priority: {} -> {}
57. 2051 0.003 291.73 KiB 0.002 1 53 ['Trace'] 0 Stored query result of query {}
58. 1980 0.003 17.40 KiB 0 2 85 ['Trace'] 0.004 No tables
59. 1974 0.003 341.63 KiB 0.003 1 120 ['Trace'] 0.015 {}Keys: {}, datatype: {}, kind: {}, strictness: {}, right header: {}
60. 1954 0.003 112.75 KiB 0.001 2 51 ['Trace'] 0.958 Loading config file '{}'.
61. 1948 0.003 144.58 KiB 0.001 1 80 ['Debug'] 0 Waiting for table {} to be finally dropped
62. 1948 0.003 224.48 KiB 0.002 1 80 ['Debug'] 0 Done waiting for the table {} to be dropped. The outcome: {}
63. 1921 0.003 330.98 KiB 0.003 1 98 ['Information'] 1 Removing metadata {} of dropped table {}
64. 1834 0.003 180.76 KiB 0.002 1329 524 ['Trace'] 1 Didn't start merge: {}
65. 1822 0.003 131.77 KiB 0.001 1 501 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {} tables
66. 1693 0.003 215.15 KiB 0.002 1 65 ['Debug'] 0 Could not find entry for table_uuid: {}, part: {}, condition_hash: {}
67. 1584 0.002 162.03 KiB 0.001 1 7 ['Trace'] 0.5 Adding file: {}, size: {}
68. 1573 0.002 182.10 KiB 0.002 1 85 ['Debug'] 0 Going to respond to replica {} with {}; mine_marks={}, stolen_by_hash={}, stolen_rest={}
69. 1573 0.002 114.22 KiB 0.001 1 85 ['Trace'] 0 Handling request from replica {}, minimal marks size is {}, request count {}
70. 1543 0.002 222.08 KiB 0.002 1 89 ['Debug'] 0.008 (internal) {} (stage: {})
71. 1540 0.002 27.07 KiB 0 1417 169 ['Debug'] 0.084 Loading data parts
72. 1484 0.002 33.33 KiB 0 1409 144 ['Debug'] 0.063 There are no data parts
73. 1467 0.002 7.68 MiB 0.066 1 73 ['Trace'] 0 Before join block: '{}'
74. 1467 0.002 7.76 MiB 0.067 1 73 ['Trace'] 0 After join block: '{}'
75. 1333 0.002 146.39 KiB 0.001 590 134 ['Debug'] 0.974 Removing {} parts from filesystem (serially): Parts: [{}]
76. 1331 0.002 106.18 KiB 0.001 1 135 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={}
77. 1304 0.002 95.11 KiB 0.001 1 82 ['Trace'] 0 The min valid primary key position for moving to the tail of PREWHERE is {}
78. 1220 0.002 70.34 KiB 0.001 1217 100 ['Trace'] 0.993 dropAllData: removing data parts (count {}) from filesystem.
79. 1220 0.002 36.93 KiB 0 1217 100 ['Trace'] 0.993 dropAllData: waiting for locks.
80. 1217 0.002 51.10 KiB 0 1217 100 ['Information'] 0.993 dropAllData: clearing temporary directories
81. 1217 0.002 78.44 KiB 0.001 1217 100 ['Information'] 0.993 dropAllData: removing table directory recursive to cleanup garbage
82. 1217 0.002 21.39 KiB 0 1217 100 ['Trace'] 0.993 dropAllData: done.
83. 1217 0.002 58.24 KiB 0 1217 100 ['Trace'] 0.993 dropAllData: removing all data parts from memory.
84. 1217 0.002 91.51 KiB 0.001 1217 100 ['Information'] 0.993 dropAllData: remove format_version.txt, detached, moving and write ahead logs
85. 1189 0.002 80.99 KiB 0.001 1 85 ['Debug'] 0.008 Wait load job '{}' in {}
86. 1179 0.002 97.10 KiB 0.001 1 57 ['Debug'] 0 mark_segment_size={}, min_marks_per_task*threads={}, sum_marks/number_of_replicas^2={}
87. 1179 0.002 27.87 KiB 0 1 57 ['Debug'] 0 Chosen segment size: {}
88. 1178 0.002 48.46 KiB 0 1 107 ['Debug'] 0 Sent initial requests: {} Replicas count: {}
89. 1178 0.002 113.53 KiB 0.001 1 107 ['Debug'] 0 Initial request: {}
90. 1152 0.002 259.63 KiB 0.002 181 75 ['Trace'] 1 scheduleTasks: initialized={}, size_before_filtering={}, queue_size={}, entries={}..{}, first_failed_task_name={}, current_tasks_size={}, last_current_task={}, last_skipped_entry_name={}
91. 1152 0.002 28.13 KiB 0 181 75 ['Debug'] 1 Waiting for queue updates
92. 1152 0.002 18.00 KiB 0 181 75 ['Debug'] 1 Scheduling tasks
93. 1149 0.002 33.66 KiB 0 181 73 ['Trace'] 1 Checking task {}
94. 1149 0.002 58.35 KiB 0 181 73 ['Debug'] 1 Will schedule {} tasks starting from {}
95. 1118 0.002 106.87 KiB 0.001 180 72 ['Debug'] 1 Will not execute task {}: {}
96. 1095 0.002 89.02 KiB 0.001 1 72 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {}
97. 1095 0.002 37.37 KiB 0 1 72 ['Debug'] 0 Selected MergeAlgorithm: {}
98. 1084 0.002 140.97 KiB 0.001 1 73 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec.
99. 1082 0.002 68.11 KiB 0.001 143 74 ['Information'] 0 Merged {} parts: [{}, {}] -> {}
100. 1027 0.002 84.62 KiB 0.001 949 85 ['Information'] 0.01 Metadata processed, database {} has {} tables and {} dictionaries in total.
count count_% size size_% uniq_loggers uniq_threads levels background_% message_format_string
Top messages without format string (fmt::runtime):
count pattern runtime_message line
1. 77 CodeDBExceptionReceivedfromDBExc Code: 439. DB::Exception: Received from 127.0.0.3:9000. DB::Exception: Cannot schedule a task: failed to start the thread (threads=0, jobs=0). Stack trace: ↴ ('/executeQuery.cpp',301)
↳ ↴
↳0. std::exception::exception[abi:ne190107]() @ 0x0000000017e18a94 ↴
↳1. ./build_docker/./base/poco/Fou
2. 66 IfthesignaturecheckfailedThiscou If the signature check failed. This could be because of a time skew. Attempting to adjust the signer. ('/AWSLogger.cpp',70)
3. 56 CodeDBExceptionSyntaxerrorfailed Code: 62. DB::Exception: Syntax error: failed at position 17 (0.011991): 0.011991. Expected one of: token sequence, Dot, token, OR, AND, IS NOT DISTINCT FROM, IS NULL, IS NOT NULL, BETWEEN, NOT BETWEEN, LIKE, ILIKE, NOT LIKE, NOT ILIKE, REGEXP, IN, NOT IN, ('/executeQuery.cpp',301)
4. 6 Connectiontomysqlfailedtimes Connection to mysql failed 1 times ('',0)
5. 6 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 0 ('/LoggerWrapper.h',43)
6. 4 CodeDBExceptionSQLitedatabasefil Code: 481. DB::Exception: SQLite database file path '/etc/passwd' must be inside 'user_files' directory. (PATH_ACCESS_DENIED) (version 25.3.3.20366.altinityantalya (altinity build)) (from [::1]:36552) (comment: 02918_sqlite_path_check.sh) (query 1, line 1) ('/executeQuery.cpp',301)
7. 4 CodeDBExceptionExpectedguidasarg Code: 395. DB::Exception: Expected guid as argument: while executing 'FUNCTION if(_CAST(1_UInt8, 'UInt8'_String) :: 1, toString(throwIf(1_Bool, 'Expected guid as argument'_String)) :: 3, _CAST(NULL_Nullable(Nothing), 'Nullable(Nothing)'_String) :: 4) -> if ('/executeQuery.cpp',301)
8. 4 CodeDBExceptionTherequestsignatu Code: 499. DB::Exception: The request signature we calculated does not match the signature you provided. Check your key and signing method. (S3_ERROR) (version 25.3.3.20366.altinityantalya (altinity build)) (from [::1]:37928) (comment: 02843_backup_use_sam ('/executeQuery.cpp',301)
9. 4 CodeDBExceptionReceivedfromlocal Code: 452. DB::Exception: Received from localhost:9000. DB::Exception: Setting max_execution_time shouldn't be greater than 60.. Stack trace: ↴ ('/executeQuery.cpp',301)
↳ ↴
↳0. std::exception::exception[abi:ne190107]() @ 0x0000000017e18a94 ↴
↳1. ./build_docker/./base/poco/Foundation/src/Ex
10. 3 startingup starting up ('',0)
11. 3 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',43)
12. 3 ConnectiontosystemasuserMYSQLUSE Connection to system@127.0.0.1:9004 as user 02833_MYSQL_USER_4778 failed: mysqlxx::ConnectionFailed: 02833_MYSQL_USER_4778: Authentication failed: password is incorrect, or there is no user with such name. ((nullptr):9004) ('',0)
13. 3 statemachinecommitindexprecommit state machine commit index 0, precommit index 0, last log index 0 ('/LoggerWrapper.h',43)
14. 3 newconfigurationlogidxprevlogidx new configuration: log idx 1, prev log idx 0 ↴ ('/LoggerWrapper.h',43)
↳peer 1, DC ID 0, localhost:9234, voting member, 1 ↴
↳my id: 1, leader: 1, term: 1
15. 3 Forkedachildprocesstowatch Forked a child process to watch ('',0)
16. 3 PRIORITYdecaytargetmine [PRIORITY] decay, target 1 -> 1, mine 1 ('/LoggerWrapper.h',43)
17. 3 skippedconfiglatestconfig skipped config 1, latest config 1 ('/LoggerWrapper.h',43)
18. 3 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',43)
19. 3 INITRAFTSERVERcommitindextermele === INIT RAFT SERVER === ↴ ('/LoggerWrapper.h',43)
↳commit index 0 ↴
↳term 0 ↴
↳election timer allowed ↴
↳log store start 1, end 0 ↴
↳config log idx 0, prev log idx 0 ↴
↳ -- ASYNC REPLICATION --
20. 3 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',43)
21. 3 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1 ↴ ('/LoggerWrapper.h',43)
↳my id: 1, voting_member ↴
↳num peers: 0
22. 3 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',43)
23. 3 RaftASIOlistenerinitiatedonunsec Raft ASIO listener initiated on :::9234, unsecured ('/LoggerWrapper.h',43)
24. 3 VOTEINITmyidmyrolecandidateterml [VOTE INIT] my id 1, my role candidate, term 1, log idx 0, log term 0, priority (target 1 / mine 1) ('/LoggerWrapper.h',43)
25. 3 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',43)
26. 3 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',43)
27. 3 ELECTIONTIMEOUTcurrentrolefollow [ELECTION TIMEOUT] current role: follower, log last term 0, state term 0, target p 1, my p 1, hb dead, pre-vote NOT done ('/LoggerWrapper.h',43)
28. 3 StartingClickHousealtinityantaly Starting ClickHouse 25.3.3.20366.altinityantalya (revision: 4294967295, git hash: 1abef611c9a40dce30ed011ede491e532b2a3e72, build id: 3BF1C5682D9A1ECB4EF93FFC5890AFF5ADF400C0), PID 426 ('',0)
29. 3 newconfiglogidxprevlogidxcurconf new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0 ('/LoggerWrapper.h',43)
30. 3 Connectiontoconvmainasusermetrik Connection to conv_main@127.0.0.1:3456 as user metrika failed: mysqlxx::ConnectionFailed: Can't connect to MySQL server on '127.0.0.1' (115) ((nullptr):0) ('',0)
Top messages not matching their format strings:
message_format_string count() any_message
1. 166 creating a snapshot for index 10000
2. {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 15 /var/lib/clickhouse/store/c97/c97ad53b-6dc0-433a-94c8-6d68d27bd0bd/tmp_merge_202507_1_91_18/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 1 similar messages)
3. Cannot find '{}' in '{}' 6 Cannot find 'kernel' in '/sys/fs/cgroup/memory.stat' (skipped 5645 similar messages)
4. (from {}{}{}){}{}{} {} (stage: {}) 4 (from [::1]:45492) (comment: 02686_bson3.sql) (query 1, line 1) -- It correctly throws exception about incorrect data: ↴
↳ SELECT * FROM format(BSONEachRow, 'WatchID Int64, JavaEnable Int16, Title String, GoodEvent Int16, EventTime DateTime, EventDate Date, CounterID Int32, ClientIP Int32, RegionID Int32, UserID Int64, CounterClass Int16, OS Int16, UserAgent Int16, URL String, Referer String, IsRefresh Int16, RefererCategoryID Int16, RefererRegionID Int32, URLCategoryID Int16, URLRegionID Int32, ResolutionWidth Int16, ResolutionHeight Int16, ResolutionDepth Int16, FlashMajor Int16, FlashMinor Int16, FlashMinor2 String, NetMajor Int16, NetMinor Int16, UserAgentMajor Int16, UserAgentMinor String, CookieEnable Int16, JavascriptEnable Int16, IsMobile Int16, MobilePhone Int16, MobilePhoneModel String, Params String, IPNetworkID Int32, TraficSourceID Int16, SearchEngineID Int16, SearchPhrase String, AdvEngineID Int16, IsArtifical Int16, WindowClientWidth Int16, WindowClientHeight Int16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 Int16, SilverlightVersion2 Int16, SilverlightVersion3 Int32, SilverlightVersion4 Int16, PageCharset String, CodeVersion Int32, IsLink Int16, IsDownload Int16, IsNotBounce Int16, FUniqID Int64, OriginalURL String, HID Int32, IsOldCounter Int16, IsEvent Int16, IsParameter Int16, DontCountHits Int16, WithHash Int16, HitColor String, LocalEventTime DateTime, Age Int16, Sex Int16, Income Int16, Interests Int16, Robotness Int16, RemoteIP Int32, WindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage String, BrowserCountry String, SocialNetwork String, SocialAction String, HTTPError Int16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, FetchTiming Int32, SocialSourceNetworkID Int16, SocialSourcePage String, ParamPrice Int64, ParamOrderID String, ParamCurrency String, ParamCurrencyID Int16, OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID Int16, RefererHash Int64, URLHash Int64, CLID Int32', $$^ WatchID c*5/ !p~JavaEnable Title GoodEvent EventTime 7�Q EventDate > CounterID ClientIP �z�RegionID G UserID � �:6�CounterClass OS UserAgent URL Referer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor �OCookieEnable JavascriptEnabl�sMobile MobilePhone MobilePhoneModel Params IPNetworkID �9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID OriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime &�Q Age Sex Income Interests Robotness RemoteIP ^DI�WindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �|3�b.�CLID ^ WatchID �F�ӓ2qJavaEnable Title GoodEvent EventTime n$�Q EventDate > CounterID ClientIP �z�RegionID G UserID � �:6�CounterClass OS UserAgent URL Referer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor �OCookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID OriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime ǘ�Q Age Sex Income Interests Robotness RemoteIP ^DI�WindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage P�amPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �|3�b.�CLID ^ WatchID l!�|�@HJavaEnable Title GoodEvent EventTime �)�Q EventDate > CounterID ClientIP �z�RegionID G UserID � �:6�CounterClass OS UserAgent URL Referer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor �OCookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID OriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime }�Q Age Sex Income Interests Robotness RemoteIP ^DI�WindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �|3�b.�CLID ^ WatchID �ǐ=ЌWJavaEnable Title GoodEvent EventTime 8*�Q EventDate > CounterID ClientIP �z�RegionID G UserID � �:6�CounterClass OS UserAgent URL Referer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor �OCookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID OriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime ݞ�Q Age Sex Income Interests Robotness RemoteIP ^DI�WindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �|3�b.�CLID � WatchID �E&LyJavaEnable Title GoodEvent EventTime J�Q EventDate > CounterID ClientIP �I`RegionID ' UserID q�Jd8CounterClass OS UserAgent URL - http://holodilnik.ru/russia/05jul2013&model=0Referer IsRefresh RefererCategoryID RefererRegionID URLCateParams String, IPNetworkID Int32, TraficSourceID Int16, SearchEngineID Int16, SearchPhrase String, AdvEngineID Int16, IsArtifical Int16, WindowClientWidth Int16, WindowClientHeight Int16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 Int16, SilverlightVersion2 Int16, SilverlightVersion3 Int32, SilverlightVersion4 Int16, PageCharset String, CodeVersion Int32, IsLink Int16, IsDownload Int16, IsNotBounce Int16, FUniqID Int64, OriginalURL String, HID Int32, IsOldCounter Int16, IsEvent Int16, IsParameter Int16, DontCountHits Int16, WithHash Int16, HitColor String, LocalEventTime DateTime, Age Int16, Sex Int16, Income Int16, Interests Int16, Robotness Int16, RemoteIP Int32, WindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage String, BrowserCountry String, SocialNetwork String, SocialAction String, HTTPError Int16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �↴
↳o�eCLID � WatchID �k=�pJavaEnable Title GoodEvent EventTime ��Q EventDate > CounterID Clien�Q9�HRegionID G UserID
�Ks}�CounterClass OS UserAgent URL H http://afisha.mail.ru/catalog/314/women.ru/ency=1&page3/?errovat-pinnikiReferer IsRefresh RefererCategoryID RefererRegionID URLCategoryID 0= URLRegionID � ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor D�CookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4
PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID :�W�mOriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime A�Q Age Sex Income Interests Robotness RemoteIP ^DI�WindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �
�#�\CLID � WatchID �1�o�CJavaEnable Title GoodEvent EventTime �0�Q EventDate > CounterID ClientIP �^{]RegionID � UserID &n%�t"6CounterClass OS ' UserAgent URL > http://bonprix.ru/index.ru/cinema/art/0 986 424 233 сезонReferer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID � ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor D�CookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �#( TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID OriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime �Q Age Sex Income Interests Robotness RemoteIP �UWindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash X-h�X CLID � WatchID »-�C_JavaEnable Title GoodEvent EventTime 83�Q EventDate > CounterID ClientIP �^{]RegionID � UserID &n%�t"6CounterClass OS ' UserAgent URL : http://bonprix.ru/index.ru/cinema/art/A00387,3797); ru)&bLReferer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID � ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor D�CookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �#( TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID OriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime ↴
↳�Q Age Sex Income Interests Robotness RemoteIP �UWindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash v�v�CLID � WatchID ��\JavaEnable Title GoodEvent EventTime � �Q EventDate > CounterID ClientIP �gURegionID � UserID �s�yy�fCounterClass OS , UserAgent URL 1 http://tours/Ekategoriya%2F&sr=http://slovareniyeReferer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID � esRolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor D�CookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID � TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID OriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime Y�Q Age Sex Income Interests Robotness RemoteIP �=kWindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash h�9�DCLID ^ WatchID �/E�J�{JavaEnable Title GoodEvent EventTime �1�Q EventDate > CounterID ClientIP �z�RegionID G UserID � �:6�CounterClass OS UserAgent URL Referer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor �OCookieEnable JavascriptEnable IsMobile MobilePhone MobilePhkneModel Params IPNetworkID �9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID OriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime �Q Age Sex Income Interests Robotness RemoteIP ^DI�WindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �|3�b.�CLID $$); (stage: Complete)
Top short messages:
c message_format_string substr(any(toValidUTF8(message)), 1, 120) min_length_without_exception_boilerplate
1. 20 {} Code: 36. DB::Exception: Columns 'e798545eefc8b7a1c2c81ff00c064ad8 Int32' and 'very_very_long_column_name_that_will_be_r 40
2. 19 Cannot TRUNCATE dictionary Code: 62. DB::Exception: Cannot TRUNCATE dictionary. (SYNTAX_ERROR) (version 25.3.3.20366.altinityantalya (altinity buil 27
3. 16 Creating {}: {} Creating table test_0jn572rv.tbl2: CREATE TABLE IF NOT EXISTS test_0jn572rv.tbl2 UUID '680e6252-61ea-42d2-8082-611b15f7f 197
4. 4 Froze {} parts Froze 1 parts -13
5. 4 Unknown data type family: {} Code: 50. DB::Exception: Unknown data type family: ab. (UNKNOWN_TYPE) (version 25.3.3.20366.altinityantalya (altinity bu 29
6. 2 Found {} on {} Found changelog_1_100000.bin on LocalLogDisk 18
7. 2 Substitution {} is not set Code: 456. DB::Exception: Substitution `n` is not set. (UNKNOWN_QUERY_PARAMETER) (version 25.3.3.20366.altinityantalya ( 29
Top messages by level:
(0.008851879172466581,'Number of arguments for function {} doesn\'t match: passed {}, should be {}') Error
(0.000015432146395513568,'Incorrect data: number of rows with sign = 1 ({}) differs with number of rows with sign = -1 ({}) by more than one (for key: {}).') Warning
(0.002964515322578156,'Removing metadata {} of dropped table {}') Information
(0.07149096139185615,'(from {}{}{}){}{}{} {} (stage: {})') Debug
(0.07099713270719972,'{} Creating query context from {} context, user_id: {}, parent context user: {}') Trace
2025-07-11 02:40:34,887 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=2825
+ for i in {1..30}
+ clickhouse client -q 'SYSTEM STOP DISTRIBUTED SENDS'
+ break
+ clickhouse stop --max-tries 90 --do-not-kill
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2825.
The process with pid = 2825 is running.
Sent terminate signal to process with pid 2825.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2825.
The process with pid = 2825 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2825.
The process with pid = 2825 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2825.
The process with pid = 2825 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2825.
The process with pid = 2825 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2825.
The process with pid = 2825 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2825.
The process with pid = 2825 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2825.
The process with pid = 2825 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2825.
The process with pid = 2825 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2825.
The process with pid = 2825 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2825.
The process with pid = 2825 does not exist.
Server stopped
+ return
+ mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ unset THREAD_FUZZER_CPU_TIME_PERIOD_US THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY THREAD_FUZZER_SLEEP_PROBABILITY THREAD_FUZZER_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX THREAD_POOL_FAULT_INJECTION
+ rm /etc/clickhouse-server/config.d/cannot_allocate_thread_injection.xml
+ 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'
1
+ attach_gdb_to_clickhouse
++ clickhouse local --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)'
+ IS_ASAN=0
+ [[ 0 = \1 ]]
++ kill -l SIGRTMIN
+ RTMIN=34
+ echo '
set follow-fork-mode parent
handle SIGHUP nostop noprint pass
handle SIGINT nostop noprint pass
handle SIGQUIT nostop noprint pass
handle SIGPIPE nostop noprint pass
handle SIGTERM nostop noprint pass
handle SIGUSR1 nostop noprint pass
handle SIGUSR2 nostop noprint pass
handle SIG34 nostop noprint pass
info signals
# safeExit is called if graceful shutdown times out. Print stack traces in that case.
break safeExit
continue
backtrace full
info registers
p top' 1 KiB of the 'stack:
p/x *(uint64_t[128]*)$sp
maintenance info sections
thread apply all backtrace full
disassemble /s
up
disassemble /s
up
disassemble /s
p "done"
detach
quit
'
+ sleep 5
+ ts '%Y-%m-%d %H:%M:%S'
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ gdb -batch -command script.gdb -p 78910
aarch64-binfmt-P: Could not open '/lib/ld-linux-aarch64.so.1': No such file or directory
+ run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
+ local 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
+ 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=78910
+ for i in {1..30}
+ clickhouse client -q 'SYSTEM STOP DISTRIBUTED SENDS'
+ break
+ clickhouse stop --max-tries 90 --do-not-kill
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 78910.
The process with pid = 78910 is running.
Sent terminate signal to process with pid 78910.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 78910.
The process with pid = 78910 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 78910.
The process with pid = 78910 is running.
Waiting for server to stop
Found pid = 78910 in the list of running processes.
The process with pid = 78910 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ '[' -f /var/log/clickhouse-server/clickhouse-server.log ']'
+ '[' -f /var/log/clickhouse-server/stderr.log ']'
+ mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.final.log
+ check_logs_for_critical_errors
+ sed -n '/WARNING:.*anitizer/,/^$/p' /var/log/clickhouse-server/stderr.log
+ rg -Fav -e 'ASan doesn'\''t fully support makecontext/swapcontext functions' -e DB::Exception /test_output/tmp
+ echo -e 'No sanitizer asserts\tOK\t\N\t'
+ rm -f /test_output/tmp
+ rg -Fa ' Application: Child process was terminated by signal 9' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No OOM messages in clickhouse-server.log\tOK\t\N\t'
+ rg -Fa 'Code: 49. DB::Exception: ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No logical errors\tOK\t\N\t'
+ '[' -s /test_output/logical_errors.txt ']'
+ rm /test_output/logical_errors.txt
+ rg --text 'Code: 499.*The specified key does not exist' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ grep -v -e a.myext -e DistributedCacheTCPHandler -e ReadBufferFromDistributedCache -e ReadBufferFromS3 -e ReadBufferFromAzureBlobStorage -e AsynchronousBoundedReadBuffer -e 'caller id: None:DistribCache'
+ echo -e 'No lost s3 keys\tOK\t\N\t'
+ grep SharedMergeTreePartCheckThread
+ 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
+ echo -e 'No SharedMergeTree lost forever in clickhouse-server.log\tOK\t\N\t'
+ '[' -s /test_output/no_such_key_errors.txt ']'
+ rm /test_output/no_such_key_errors.txt
+ rg -Fa '#######################################' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'Not crashed\tOK\t\N\t'
+ rg -Fa ' ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No fatal messages in clickhouse-server.log\tOK\t\N\t'
+ '[' -s /test_output/fatal_messages.txt ']'
+ rm /test_output/fatal_messages.txt
+ rg -Faz '########################################' /test_output/gdb.log /test_output/stress_run_logs.tar.zst /test_output/test_results.tsv
+ rg -v 'rg -Faz '
+ rg -Fa ' received signal ' /test_output/gdb.log
+ dmesg -T
+ grep -q -F -e 'Out of memory: Killed process' -e 'oom_reaper: reaped process' -e oom-kill:constraint=CONSTRAINT_NONE /test_output/dmesg.log
+ echo -e 'No OOM in dmesg\tOK\t\N\t'
+ tar -chf /test_output/coordination.tar /var/lib/clickhouse/coordination
tar: Removing leading `/' from member names
tar: Removing leading `/' from hard link targets
+ collect_query_and_trace_logs
+ for table in query_log trace_log metric_log
+ clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.query_log format TSVWithNamesAndTypes'
+ zstd --threads=0
Logging trace to /var/log/clickhouse-server/clickhouse-server.log
Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
+ for table in query_log trace_log metric_log
+ clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.trace_log format TSVWithNamesAndTypes'
+ zstd --threads=0
Logging trace to /var/log/clickhouse-server/clickhouse-server.log
Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
+ for table in query_log trace_log metric_log
+ clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.metric_log format TSVWithNamesAndTypes'
+ zstd --threads=0
Logging trace to /var/log/clickhouse-server/clickhouse-server.log
Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
+ 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