+ 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+tsan_amd64.deb
+ local retries=3
+ shift
+ local retry=0
+ '[' 0 -ge 3 ']'
+ dpkg -i package_folder/clickhouse-common-static_25.3.3.20366.altinityantalya+tsan_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+tsan_amd64.deb ...
Unpacking clickhouse-common-static (25.3.3.20366.altinityantalya+tsan) ...
Setting up clickhouse-common-static (25.3.3.20366.altinityantalya+tsan) ...
+ return
+ run_with_retry 3 dpkg -i package_folder/clickhouse-common-static-dbg_25.3.3.20366.altinityantalya+tsan_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+tsan_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+tsan_amd64.deb ...
Unpacking clickhouse-common-static-dbg (25.3.3.20366.altinityantalya+tsan) ...
Setting up clickhouse-common-static-dbg (25.3.3.20366.altinityantalya+tsan) ...
+ return
+ run_with_retry 3 dpkg -i package_folder/clickhouse-server_25.3.3.20366.altinityantalya+tsan_amd64.deb
+ local retries=3
+ shift
+ local retry=0
+ '[' 0 -ge 3 ']'
+ dpkg -i package_folder/clickhouse-server_25.3.3.20366.altinityantalya+tsan_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+tsan_amd64.deb ...
Unpacking clickhouse-server (25.3.3.20366.altinityantalya+tsan) ...
Setting up clickhouse-server (25.3.3.20366.altinityantalya+tsan) ...
ClickHouse binary is already located at /usr/bin/clickhouse
Symlink /usr/bin/clickhouse-server already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-server to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-client to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-local to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-benchmark to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-obfuscator to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-git-import to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-compressor to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-format to /usr/bin/clickhouse.
Symlink /usr/bin/clickhouse-extract-from-config already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-extract-from-config to /usr/bin/clickhouse.
Symlink /usr/bin/clickhouse-keeper already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-keeper to /usr/bin/clickhouse.
Symlink /usr/bin/clickhouse-keeper-converter already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-keeper-converter to /usr/bin/clickhouse.
Creating symlink /usr/bin/clickhouse-disks to /usr/bin/clickhouse.
Creating symlink /usr/bin/ch to /usr/bin/clickhouse.
Creating symlink /usr/bin/chl to /usr/bin/clickhouse.
Creating symlink /usr/bin/chc to /usr/bin/clickhouse.
Creating clickhouse group if it does not exist.
groupadd -r clickhouse
Creating clickhouse user if it does not exist.
useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse clickhouse
Will set ulimits for clickhouse user in /etc/security/limits.d/clickhouse.conf.
Creating config directory /etc/clickhouse-server/config.d that is used for tweaks of main server configuration.
Creating config directory /etc/clickhouse-server/users.d that is used for tweaks of users configuration.
Config file /etc/clickhouse-server/config.xml already exists, will keep it and extract path info from it.
/etc/clickhouse-server/config.xml has /var/lib/clickhouse/ as data path.
/etc/clickhouse-server/config.xml has /var/log/clickhouse-server/ as log path.
Users config file /etc/clickhouse-server/users.xml already exists, will keep it and extract users info from it.
Log directory /var/log/clickhouse-server/ already exists.
Creating data directory /var/lib/clickhouse/.
Creating pid directory /var/run/clickhouse-server.
chown -R clickhouse:clickhouse '/var/log/clickhouse-server/'
chown -R clickhouse:clickhouse '/var/run/clickhouse-server'
chown clickhouse:clickhouse '/var/lib/clickhouse/'
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+tsan_amd64.deb
+ local retries=3
+ shift
+ local retry=0
+ '[' 0 -ge 3 ']'
+ dpkg -i package_folder/clickhouse-client_25.3.3.20366.altinityantalya+tsan_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+tsan_amd64.deb ...
Unpacking clickhouse-client (25.3.3.20366.altinityantalya+tsan) ...
Setting up clickhouse-client (25.3.3.20366.altinityantalya+tsan) ...
+ 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
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 '' ]]
+ 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=60534784
+ sed --follow-symlinks -i 's|[[:digit:]]\+|60534784|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=55099392
+ sed --follow-symlinks -i 's|[[:digit:]]\+|55099392|' /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=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=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ randomize_config_boolean_value use_compression zookeeper_fault_injection
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml
+ randomize_config_boolean_value 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=32086432
+ total_mem=32856506368
+ max_server_memory_usage_to_ram_ratio=0.5
+ echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5'
Setting max_server_memory_usage_to_ram_ratio to 0.5
+ cat
+ local max_users_mem
+ max_users_mem=9856951910
+ echo 'Setting max_memory_usage_for_user=9856951910 and max_memory_usage for queries to 10G'
+ cat
Setting max_memory_usage_for_user=9856951910 and max_memory_usage for queries to 10G
+ cat
+ /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
+ [[ 0 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
INFO: Formatting 1st pool, 1 set(s), 1 drives per set.
INFO: WARNING: Host local has more than 0 drives of set. A host failure will result in data becoming unavailable.
MinIO Object Storage Server
Copyright: 2015-2025 MinIO, Inc.
License: GNU AGPLv3 - https://www.gnu.org/licenses/agpl-3.0.html
Version: RELEASE.2024-08-03T04-33-23Z (go1.22.5 linux/amd64)
API: http://172.17.0.2:11111 http://127.0.0.1:11111
WebUI: http://172.17.0.2:38375 http://127.0.0.1:38375
Docs: https://min.io/docs/minio/linux/index.html
+ counter=1
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
AccessDeniedAccess Denied./18510A69C8304DCB7dc7eb22d3288ec80374614e9088e31d3668a6922ead55932dd2a8e56373820f
+ lsof -i :11111
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
minio 299 root 8u IPv6 27498 0t0 TCP *:11111 (LISTEN)
minio 299 root 9u IPv4 27497 0t0 TCP localhost:11111 (LISTEN)
minio 299 root 10u IPv6 27499 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/02876.parquet` -> `clickminio/test/02876.parquet`
`/repo/tests/queries/0_stateless/data_minio/02366_data.jsonl` -> `clickminio/test/02366_data.jsonl`
`/repo/tests/queries/0_stateless/data_minio/03036_archive1.tar` -> `clickminio/test/03036_archive1.tar`
`/repo/tests/queries/0_stateless/data_minio/03036_archive2.zip` -> `clickminio/test/03036_archive2.zip`
`/repo/tests/queries/0_stateless/data_minio/02731.arrow` -> `clickminio/test/02731.arrow`
`/repo/tests/queries/0_stateless/data_minio/03036_archive2.tar` -> `clickminio/test/03036_archive2.tar`
`/repo/tests/queries/0_stateless/data_minio/03036_archive1.zip` -> `clickminio/test/03036_archive1.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: 128.32 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'
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 436
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=436
+ 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 = 436.
The process with pid = 436 is running.
Sent terminate signal to process with pid 436.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 436.
The process with pid = 436 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 436.
The process with pid = 436 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 436.
The process with pid = 436 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 436.
The process with pid = 436 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 436.
The process with pid = 436 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 436.
The process with pid = 436 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 436.
The process with pid = 436 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 436.
The process with pid = 436 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 436.
The process with pid = 436 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 436.
The process with pid = 436 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 436.
The process with pid = 436 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 436.
The process with pid = 436 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 436.
The process with pid = 436 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 436.
The process with pid = 436 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 436.
The process with pid = 436 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.initial.log
+ cache_policy=
+ '[' 1 -eq 1 ']'
+ cache_policy=SLRU
+ echo 'Using cache policy: SLRU'
+ '[' SLRU = SLRU ']'
Using cache policy: SLRU
+ sudo cat /etc/clickhouse-server/config.d/storage_conf.xml
+ sed 's|LRU|SLRU|'
+ mv /etc/clickhouse-server/config.d/storage_conf.xml.tmp /etc/clickhouse-server/config.d/storage_conf.xml
+ sudo cat /etc/clickhouse-server/users.d/stress_tests_overrides.xml
cat: /etc/clickhouse-server/users.d/stress_tests_overrides.xml: No such file or directory
+ start_server
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 13 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=14
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 14 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=15
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 15 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=16
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 16 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=17
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 17 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=18
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 18 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=19
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 19 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=20
+ clickhouse-client --query 'SELECT 1'
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 1393
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.07 MiB bytes), maximum: 9.18 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker. (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 1.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'
Received exception from server (version 25.3.3):
Code: 159. DB::Exception: Received from localhost:9000. DB::Exception: Timeout exceeded: elapsed 80338.827313 ms, maximum: 60000 ms. (TIMEOUT_EXCEEDED)
(query: INSERT INTO test.visits SELECT * FROM datasets.visits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16)
+ clickhouse-client --query 'DROP TABLE datasets.visits_v1 SYNC'
+ clickhouse-client --query 'DROP TABLE datasets.hits_v1 SYNC'
+ clickhouse-client --query 'SHOW TABLES FROM test'
hits
hits_s3
visits
+ clickhouse-client --query 'SYSTEM STOP THREAD FUZZER'
+ stop_server
+ local max_tries=90
+ local check_hang=true
+ local pid
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ pid=1393
+ 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 = 1393.
The process with pid = 1393 is running.
Sent terminate signal to process with pid 1393.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1393.
The process with pid = 1393 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
+ [[ 0 -gt 0 ]]
+ echo 'Going to install test configs from /repo/tests/config into /etc/clickhouse-server'
+ mkdir -p /etc/clickhouse-server/config.d/
Going to install test configs from /repo/tests/config into /etc/clickhouse-server
+ 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=0
+ sed --follow-symlinks -i 's|[01]|0|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=16283648
+ sed --follow-symlinks -i 's|[[:digit:]]\+|16283648|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=25270272
+ sed --follow-symlinks -i 's|[[:digit:]]\+|25270272|' /etc/clickhouse-server/config.d/keeper_port.xml
+ value=0
+ sed --follow-symlinks -i 's|[01]|0|' /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=0
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|0|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value check_not_exists keeper_port
+ value=1
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|[01]|1|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ randomize_config_boolean_value create_if_not_exists keeper_port
+ value=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
+ 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=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
Setting max_server_memory_usage_to_ram_ratio to 0.5
+ total_mem=32086432
+ total_mem=32856506368
+ max_server_memory_usage_to_ram_ratio=0.5
+ echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5'
+ cat
+ local max_users_mem
+ max_users_mem=9856951910
+ echo 'Setting max_memory_usage_for_user=9856951910 and max_memory_usage for queries to 10G'
+ cat
Setting max_memory_usage_for_user=9856951910 and max_memory_usage for queries to 10G
+ cat
+ [[ '' == \1 ]]
+ [[ '' == \1 ]]
+ sudo cat /etc/clickhouse-server/config.d/logger_trace.xml
+ sed 's|trace|test|'
+ mv /etc/clickhouse-server/config.d/logger_trace.xml.tmp /etc/clickhouse-server/config.d/logger_trace.xml
+ '[' SLRU = SLRU ']'
+ sudo cat /etc/clickhouse-server/config.d/storage_conf.xml
+ sed 's|LRU|SLRU|'
+ mv /etc/clickhouse-server/config.d/storage_conf.xml.tmp /etc/clickhouse-server/config.d/storage_conf.xml
++ date +%-d
+ '[' 1 -eq 1 ']'
+ sudo echo 'true'
+ start_server
+ counter=0
+ max_attempt=120
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 13 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=14
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 14 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=15
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 15 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=16
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 16 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=17
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 17 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=18
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 18 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=19
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 19 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=20
+ clickhouse-client --query 'SELECT 1'
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 2884
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:25:01,659 Run func tests '/usr/bin/clickhouse-test --client-option http_make_head_request=1 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:25:02,160 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_1 --client-option join_use_nulls=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:25:02,662 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:25:03,163 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_3 --client-option join_algorithm='partial_merge' use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' group_by_use_nulls=1 http_make_head_request=1 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:25:03,665 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 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:25:04,166 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 optimize_trivial_approximate_count_query=1 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:25:04,667 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:25:05,169 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 http_make_head_request=0 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:25:05,670 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_8', 's1', 'r1')" --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:25:06,171 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 optimize_trivial_approximate_count_query=1 http_make_head_request=0 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:25:06,672 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:25:07,174 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' use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:25:07,675 Run func tests '/usr/bin/clickhouse-test --order=random --client-option implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 http_make_head_request=0 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:25:08,176 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_13 --client-option join_use_nulls=1 join_algorithm='partial_merge' group_by_use_nulls=1 http_make_head_request=0 ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:25:08,677 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_14', 's1', 'r1')" --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' ignore_drop_queries_probability=0.2 --global_time_limit=1200 '
2025-07-11 02:25:09,178 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:25:09,688 Will wait functests to finish
2025-07-11 02:25:09,688 Finished 0 from 16 processes
2025-07-11 02:25:14,692 Finished 0 from 16 processes
2025-07-11 02:25:19,696 Finished 0 from 16 processes
2025-07-11 02:25:24,704 Finished 0 from 16 processes
2025-07-11 02:25:29,708 Finished 0 from 16 processes
2025-07-11 02:25:34,712 Finished 0 from 16 processes
2025-07-11 02:25:39,716 Finished 0 from 16 processes
2025-07-11 02:25:44,720 Finished 0 from 16 processes
2025-07-11 02:25:49,724 Finished 0 from 16 processes
2025-07-11 02:25:54,728 Finished 0 from 16 processes
2025-07-11 02:25:59,732 Finished 0 from 16 processes
2025-07-11 02:26:04,736 Finished 0 from 16 processes
2025-07-11 02:26:09,740 Finished 0 from 16 processes
2025-07-11 02:26:14,744 Finished 0 from 16 processes
2025-07-11 02:26:19,748 Finished 0 from 16 processes
2025-07-11 02:26:24,752 Finished 0 from 16 processes
2025-07-11 02:26:29,756 Finished 0 from 16 processes
2025-07-11 02:26:34,760 Finished 0 from 16 processes
2025-07-11 02:26:39,764 Finished 0 from 16 processes
2025-07-11 02:26:44,768 Finished 0 from 16 processes
2025-07-11 02:26:49,772 Finished 0 from 16 processes
2025-07-11 02:26:54,776 Finished 0 from 16 processes
2025-07-11 02:26:59,780 Finished 0 from 16 processes
2025-07-11 02:27:04,784 Finished 0 from 16 processes
2025-07-11 02:27:09,788 Finished 0 from 16 processes
2025-07-11 02:27:14,792 Finished 0 from 16 processes
2025-07-11 02:27:19,796 Finished 0 from 16 processes
2025-07-11 02:27:24,800 Finished 0 from 16 processes
2025-07-11 02:27:29,804 Finished 0 from 16 processes
2025-07-11 02:27:34,808 Finished 0 from 16 processes
2025-07-11 02:27:39,812 Finished 1 from 16 processes
2025-07-11 02:27:44,816 Finished 1 from 16 processes
2025-07-11 02:27:49,820 Finished 1 from 16 processes
2025-07-11 02:27:54,824 Finished 1 from 16 processes
2025-07-11 02:27:59,828 Finished 1 from 16 processes
2025-07-11 02:28:04,832 Finished 1 from 16 processes
2025-07-11 02:28:09,836 Finished 1 from 16 processes
2025-07-11 02:28:14,840 Finished 1 from 16 processes
2025-07-11 02:28:19,844 Finished 1 from 16 processes
2025-07-11 02:28:24,850 Finished 1 from 16 processes
2025-07-11 02:28:29,855 Finished 1 from 16 processes
2025-07-11 02:28:34,860 Finished 1 from 16 processes
2025-07-11 02:28:39,864 Finished 1 from 16 processes
2025-07-11 02:28:44,868 Finished 1 from 16 processes
2025-07-11 02:28:49,872 Finished 1 from 16 processes
2025-07-11 02:28:54,877 Finished 1 from 16 processes
2025-07-11 02:28:59,880 Finished 1 from 16 processes
2025-07-11 02:29:04,884 Finished 1 from 16 processes
2025-07-11 02:29:09,888 Finished 2 from 16 processes
2025-07-11 02:29:14,892 Finished 2 from 16 processes
2025-07-11 02:29:19,896 Finished 2 from 16 processes
2025-07-11 02:29:24,900 Finished 2 from 16 processes
2025-07-11 02:29:29,904 Finished 2 from 16 processes
2025-07-11 02:29:34,908 Finished 2 from 16 processes
2025-07-11 02:29:39,912 Finished 2 from 16 processes
2025-07-11 02:29:44,916 Finished 3 from 16 processes
2025-07-11 02:29:49,920 Finished 3 from 16 processes
2025-07-11 02:29:54,924 Finished 3 from 16 processes
2025-07-11 02:29:59,928 Finished 3 from 16 processes
2025-07-11 02:30:04,932 Finished 3 from 16 processes
2025-07-11 02:30:09,936 Finished 3 from 16 processes
2025-07-11 02:30:14,940 Finished 3 from 16 processes
2025-07-11 02:30:19,944 Finished 3 from 16 processes
2025-07-11 02:30:24,948 Finished 3 from 16 processes
2025-07-11 02:30:29,949 Finished 3 from 16 processes
2025-07-11 02:30:34,952 Finished 3 from 16 processes
2025-07-11 02:30:39,954 Finished 3 from 16 processes
2025-07-11 02:30:44,959 Finished 3 from 16 processes
2025-07-11 02:30:49,964 Finished 3 from 16 processes
2025-07-11 02:30:54,968 Finished 3 from 16 processes
2025-07-11 02:30:59,972 Finished 3 from 16 processes
2025-07-11 02:31:04,976 Finished 3 from 16 processes
2025-07-11 02:31:09,980 Finished 3 from 16 processes
2025-07-11 02:31:14,984 Finished 3 from 16 processes
2025-07-11 02:31:19,988 Finished 3 from 16 processes
2025-07-11 02:31:24,992 Finished 3 from 16 processes
2025-07-11 02:31:29,996 Finished 3 from 16 processes
2025-07-11 02:31:35,001 Finished 3 from 16 processes
2025-07-11 02:31:40,004 Finished 3 from 16 processes
2025-07-11 02:31:45,008 Finished 3 from 16 processes
2025-07-11 02:31:50,013 Finished 3 from 16 processes
2025-07-11 02:31:55,016 Finished 3 from 16 processes
2025-07-11 02:32:00,020 Finished 3 from 16 processes
2025-07-11 02:32:05,024 Finished 3 from 16 processes
2025-07-11 02:32:10,028 Finished 3 from 16 processes
2025-07-11 02:32:15,032 Finished 3 from 16 processes
2025-07-11 02:32:20,036 Finished 3 from 16 processes
2025-07-11 02:32:25,040 Finished 3 from 16 processes
2025-07-11 02:32:30,044 Finished 3 from 16 processes
2025-07-11 02:32:35,048 Finished 3 from 16 processes
2025-07-11 02:32:40,052 Finished 3 from 16 processes
2025-07-11 02:32:45,056 Finished 3 from 16 processes
2025-07-11 02:32:50,060 Finished 3 from 16 processes
2025-07-11 02:32:55,064 Finished 3 from 16 processes
2025-07-11 02:33:00,068 Finished 3 from 16 processes
2025-07-11 02:33:05,072 Finished 3 from 16 processes
2025-07-11 02:33:10,076 Finished 3 from 16 processes
2025-07-11 02:33:15,080 Finished 3 from 16 processes
2025-07-11 02:33:20,084 Finished 3 from 16 processes
2025-07-11 02:33:25,088 Finished 3 from 16 processes
2025-07-11 02:33:30,095 Finished 3 from 16 processes
2025-07-11 02:33:35,100 Finished 3 from 16 processes
2025-07-11 02:33:40,104 Finished 3 from 16 processes
2025-07-11 02:33:45,108 Finished 3 from 16 processes
2025-07-11 02:33:50,112 Finished 3 from 16 processes
2025-07-11 02:33:55,116 Finished 3 from 16 processes
2025-07-11 02:34:00,120 Finished 3 from 16 processes
2025-07-11 02:34:05,124 Finished 3 from 16 processes
2025-07-11 02:34:10,128 Finished 3 from 16 processes
2025-07-11 02:34:15,132 Finished 3 from 16 processes
2025-07-11 02:34:20,136 Finished 3 from 16 processes
2025-07-11 02:34:25,140 Finished 3 from 16 processes
2025-07-11 02:34:30,144 Finished 3 from 16 processes
2025-07-11 02:34:35,148 Finished 3 from 16 processes
2025-07-11 02:34:40,152 Finished 3 from 16 processes
2025-07-11 02:34:45,157 Finished 3 from 16 processes
2025-07-11 02:34:50,160 Finished 3 from 16 processes
2025-07-11 02:34:55,164 Finished 3 from 16 processes
2025-07-11 02:35:00,168 Finished 3 from 16 processes
2025-07-11 02:35:05,172 Finished 3 from 16 processes
2025-07-11 02:35:10,176 Finished 3 from 16 processes
2025-07-11 02:35:15,180 Finished 3 from 16 processes
2025-07-11 02:35:20,184 Finished 3 from 16 processes
2025-07-11 02:35:25,189 Finished 3 from 16 processes
2025-07-11 02:35:30,192 Finished 3 from 16 processes
2025-07-11 02:35:35,196 Finished 3 from 16 processes
2025-07-11 02:35:40,200 Finished 3 from 16 processes
2025-07-11 02:35:45,204 Finished 3 from 16 processes
2025-07-11 02:35:50,208 Finished 3 from 16 processes
2025-07-11 02:35:55,212 Finished 3 from 16 processes
2025-07-11 02:36:00,216 Finished 3 from 16 processes
2025-07-11 02:36:05,220 Finished 3 from 16 processes
2025-07-11 02:36:10,224 Finished 3 from 16 processes
2025-07-11 02:36:15,228 Finished 3 from 16 processes
2025-07-11 02:36:20,232 Finished 3 from 16 processes
2025-07-11 02:36:25,234 Finished 3 from 16 processes
2025-07-11 02:36:30,236 Finished 3 from 16 processes
2025-07-11 02:36:35,240 Finished 3 from 16 processes
2025-07-11 02:36:40,244 Finished 3 from 16 processes
2025-07-11 02:36:45,248 Finished 3 from 16 processes
2025-07-11 02:36:50,252 Finished 3 from 16 processes
2025-07-11 02:36:55,256 Finished 3 from 16 processes
2025-07-11 02:37:00,260 Finished 3 from 16 processes
2025-07-11 02:37:05,264 Finished 3 from 16 processes
2025-07-11 02:37:10,268 Finished 3 from 16 processes
2025-07-11 02:37:15,272 Finished 3 from 16 processes
2025-07-11 02:37:20,276 Finished 3 from 16 processes
2025-07-11 02:37:25,280 Finished 3 from 16 processes
2025-07-11 02:37:30,284 Finished 3 from 16 processes
2025-07-11 02:37:35,288 Finished 3 from 16 processes
2025-07-11 02:37:40,292 Finished 3 from 16 processes
2025-07-11 02:37:45,296 Finished 3 from 16 processes
2025-07-11 02:37:50,300 Finished 3 from 16 processes
2025-07-11 02:37:55,304 Finished 3 from 16 processes
2025-07-11 02:38:00,308 Finished 3 from 16 processes
2025-07-11 02:38:05,312 Finished 3 from 16 processes
2025-07-11 02:38:10,316 Finished 3 from 16 processes
2025-07-11 02:38:15,320 Finished 3 from 16 processes
2025-07-11 02:38:20,324 Finished 3 from 16 processes
2025-07-11 02:38:25,328 Finished 3 from 16 processes
2025-07-11 02:38:30,332 Finished 3 from 16 processes
2025-07-11 02:38:35,336 Finished 3 from 16 processes
2025-07-11 02:38:40,340 Finished 3 from 16 processes
2025-07-11 02:38:45,344 Finished 3 from 16 processes
2025-07-11 02:38:50,348 Finished 3 from 16 processes
2025-07-11 02:38:55,352 Finished 3 from 16 processes
2025-07-11 02:39:00,356 Finished 3 from 16 processes
2025-07-11 02:39:05,360 Finished 3 from 16 processes
2025-07-11 02:39:10,364 Finished 3 from 16 processes
2025-07-11 02:39:15,368 Finished 3 from 16 processes
2025-07-11 02:39:20,372 Finished 3 from 16 processes
2025-07-11 02:39:25,377 Finished 3 from 16 processes
2025-07-11 02:39:30,380 Finished 3 from 16 processes
2025-07-11 02:39:35,384 Finished 3 from 16 processes
2025-07-11 02:39:40,388 Finished 3 from 16 processes
2025-07-11 02:39:45,392 Finished 3 from 16 processes
2025-07-11 02:39:50,396 Finished 3 from 16 processes
2025-07-11 02:39:55,400 Finished 3 from 16 processes
2025-07-11 02:40:00,404 Finished 3 from 16 processes
2025-07-11 02:40:05,407 Finished 3 from 16 processes
2025-07-11 02:40:10,412 Finished 3 from 16 processes
2025-07-11 02:40:15,416 Finished 3 from 16 processes
2025-07-11 02:40:20,421 Finished 3 from 16 processes
2025-07-11 02:40:25,424 Finished 3 from 16 processes
2025-07-11 02:40:30,428 Finished 3 from 16 processes
2025-07-11 02:40:35,432 Finished 3 from 16 processes
2025-07-11 02:40:40,436 Finished 3 from 16 processes
2025-07-11 02:40:45,440 Finished 3 from 16 processes
2025-07-11 02:40:50,445 Finished 3 from 16 processes
2025-07-11 02:40:55,448 Finished 3 from 16 processes
2025-07-11 02:41:00,452 Finished 3 from 16 processes
2025-07-11 02:41:05,456 Finished 3 from 16 processes
2025-07-11 02:41:10,460 Finished 3 from 16 processes
2025-07-11 02:41:15,464 Finished 3 from 16 processes
2025-07-11 02:41:20,468 Finished 3 from 16 processes
2025-07-11 02:41:25,472 Finished 3 from 16 processes
2025-07-11 02:41:30,476 Finished 3 from 16 processes
2025-07-11 02:41:35,480 Finished 3 from 16 processes
2025-07-11 02:41:40,484 Finished 3 from 16 processes
2025-07-11 02:41:45,488 Finished 3 from 16 processes
2025-07-11 02:41:50,492 Finished 3 from 16 processes
2025-07-11 02:41:55,496 Finished 3 from 16 processes
2025-07-11 02:42:00,500 Finished 3 from 16 processes
2025-07-11 02:42:05,504 Finished 3 from 16 processes
2025-07-11 02:42:10,508 Finished 3 from 16 processes
2025-07-11 02:42:15,512 Finished 3 from 16 processes
2025-07-11 02:42:20,516 Finished 3 from 16 processes
2025-07-11 02:42:25,520 Finished 3 from 16 processes
2025-07-11 02:42:30,524 Finished 3 from 16 processes
2025-07-11 02:42:35,528 Finished 3 from 16 processes
2025-07-11 02:42:40,532 Finished 3 from 16 processes
2025-07-11 02:42:45,536 Finished 3 from 16 processes
2025-07-11 02:42:50,540 Finished 3 from 16 processes
2025-07-11 02:42:55,542 Finished 3 from 16 processes
2025-07-11 02:43:00,544 Finished 3 from 16 processes
2025-07-11 02:43:05,548 Finished 3 from 16 processes
2025-07-11 02:43:10,549 Finished 3 from 16 processes
2025-07-11 02:43:15,552 Finished 3 from 16 processes
2025-07-11 02:43:20,556 Finished 3 from 16 processes
2025-07-11 02:43:25,560 Finished 3 from 16 processes
2025-07-11 02:43:30,564 Finished 3 from 16 processes
2025-07-11 02:43:35,568 Finished 3 from 16 processes
2025-07-11 02:43:40,572 Finished 3 from 16 processes
2025-07-11 02:43:45,576 Finished 3 from 16 processes
2025-07-11 02:43:50,581 Finished 3 from 16 processes
2025-07-11 02:43:55,585 Finished 3 from 16 processes
2025-07-11 02:44:00,588 Finished 3 from 16 processes
2025-07-11 02:44:05,592 Finished 3 from 16 processes
2025-07-11 02:44:10,596 Finished 3 from 16 processes
2025-07-11 02:44:15,600 Finished 3 from 16 processes
2025-07-11 02:44:20,604 Finished 3 from 16 processes
2025-07-11 02:44:25,608 Finished 3 from 16 processes
2025-07-11 02:44:30,612 Finished 3 from 16 processes
2025-07-11 02:44:35,614 Finished 3 from 16 processes
2025-07-11 02:44:40,616 Finished 3 from 16 processes
2025-07-11 02:44:45,620 Finished 3 from 16 processes
2025-07-11 02:44:50,624 Finished 3 from 16 processes
2025-07-11 02:44:55,628 Finished 3 from 16 processes
2025-07-11 02:45:00,632 Finished 3 from 16 processes
2025-07-11 02:45:05,636 Finished 5 from 16 processes
2025-07-11 02:45:10,640 Finished 6 from 16 processes
2025-07-11 02:45:15,644 Finished 8 from 16 processes
2025-07-11 02:45:20,649 Finished 10 from 16 processes
2025-07-11 02:45:25,654 Finished 10 from 16 processes
2025-07-11 02:45:30,656 Finished 10 from 16 processes
2025-07-11 02:45:35,661 Finished 10 from 16 processes
2025-07-11 02:45:40,666 Finished 10 from 16 processes
2025-07-11 02:45:45,668 Finished 10 from 16 processes
2025-07-11 02:45:50,672 Finished 10 from 16 processes
2025-07-11 02:45:55,677 Finished 10 from 16 processes
2025-07-11 02:46:00,677 Finished 10 from 16 processes
2025-07-11 02:46:05,680 Finished 10 from 16 processes
2025-07-11 02:46:10,684 Finished 10 from 16 processes
2025-07-11 02:46:15,685 Finished 10 from 16 processes
2025-07-11 02:46:20,689 Finished 10 from 16 processes
2025-07-11 02:46:25,692 Finished 10 from 16 processes
2025-07-11 02:46:30,696 Finished 10 from 16 processes
2025-07-11 02:46:35,701 Finished 10 from 16 processes
2025-07-11 02:46:40,704 Finished 10 from 16 processes
2025-07-11 02:46:45,708 Finished 10 from 16 processes
2025-07-11 02:46:50,711 Finished 10 from 16 processes
2025-07-11 02:46:55,716 Finished 10 from 16 processes
2025-07-11 02:47:00,720 Finished 10 from 16 processes
2025-07-11 02:47:05,724 Finished 10 from 16 processes
2025-07-11 02:47:10,729 Finished 10 from 16 processes
2025-07-11 02:47:15,734 Finished 10 from 16 processes
2025-07-11 02:47:20,739 Finished 10 from 16 processes
2025-07-11 02:47:25,744 Finished 10 from 16 processes
2025-07-11 02:47:30,749 Finished 10 from 16 processes
2025-07-11 02:47:35,752 Finished 10 from 16 processes
2025-07-11 02:47:40,756 Finished 10 from 16 processes
2025-07-11 02:47:45,760 Finished 10 from 16 processes
2025-07-11 02:47:50,764 Finished 10 from 16 processes
2025-07-11 02:47:55,769 Finished 10 from 16 processes
2025-07-11 02:48:00,772 Finished 10 from 16 processes
2025-07-11 02:48:05,774 Finished 10 from 16 processes
2025-07-11 02:48:10,776 Finished 10 from 16 processes
2025-07-11 02:48:15,781 Finished 10 from 16 processes
2025-07-11 02:48:20,782 Finished 10 from 16 processes
2025-07-11 02:48:25,784 Finished 10 from 16 processes
2025-07-11 02:48:30,788 Finished 10 from 16 processes
2025-07-11 02:48:35,793 Finished 10 from 16 processes
2025-07-11 02:48:40,796 Finished 10 from 16 processes
2025-07-11 02:48:45,800 Finished 10 from 16 processes
2025-07-11 02:48:50,800 Finished 10 from 16 processes
2025-07-11 02:48:55,803 Finished 10 from 16 processes
2025-07-11 02:49:00,808 Finished 10 from 16 processes
2025-07-11 02:49:05,813 Finished 10 from 16 processes
2025-07-11 02:49:10,818 Finished 10 from 16 processes
2025-07-11 02:49:15,823 Finished 10 from 16 processes
2025-07-11 02:49:20,828 Finished 10 from 16 processes
2025-07-11 02:49:25,829 Finished 10 from 16 processes
2025-07-11 02:49:30,834 Finished 10 from 16 processes
2025-07-11 02:49:35,840 Finished 10 from 16 processes
2025-07-11 02:49:40,844 Finished 10 from 16 processes
2025-07-11 02:49:45,849 Finished 10 from 16 processes
2025-07-11 02:49:50,852 Finished 10 from 16 processes
2025-07-11 02:49:55,856 Finished 11 from 16 processes
2025-07-11 02:50:00,860 Finished 11 from 16 processes
2025-07-11 02:50:05,862 Finished 11 from 16 processes
2025-07-11 02:50:10,867 Finished 11 from 16 processes
2025-07-11 02:50:15,869 Finished 11 from 16 processes
2025-07-11 02:50:20,873 Finished 12 from 16 processes
2025-07-11 02:50:25,876 Finished 12 from 16 processes
2025-07-11 02:50:30,881 Finished 13 from 16 processes
2025-07-11 02:50:35,884 Finished 13 from 16 processes
2025-07-11 02:50:40,888 Finished 13 from 16 processes
2025-07-11 02:50:45,893 Finished 13 from 16 processes
2025-07-11 02:50:50,896 Finished 13 from 16 processes
2025-07-11 02:50:55,898 Finished 13 from 16 processes
2025-07-11 02:51:00,900 Finished 13 from 16 processes
2025-07-11 02:51:05,904 Finished 13 from 16 processes
2025-07-11 02:51:10,908 Finished 13 from 16 processes
2025-07-11 02:51:15,912 Finished 13 from 16 processes
2025-07-11 02:51:20,917 Finished 13 from 16 processes
2025-07-11 02:51:25,920 Finished 13 from 16 processes
2025-07-11 02:51:30,925 Finished 13 from 16 processes
2025-07-11 02:51:35,930 Finished 13 from 16 processes
2025-07-11 02:51:40,935 Finished 13 from 16 processes
2025-07-11 02:51:45,941 Finished 13 from 16 processes
2025-07-11 02:51:50,944 Finished 13 from 16 processes
2025-07-11 02:51:55,944 Finished 13 from 16 processes
2025-07-11 02:52:00,948 Finished 14 from 16 processes
2025-07-11 02:52:05,952 Finished 14 from 16 processes
2025-07-11 02:52:10,956 Finished 14 from 16 processes
2025-07-11 02:52:15,961 Finished 14 from 16 processes
2025-07-11 02:52:20,965 Finished 14 from 16 processes
2025-07-11 02:52:25,968 Finished 15 from 16 processes
2025-07-11 02:52:30,973 Finished 15 from 16 processes
2025-07-11 02:52:35,976 Finished 15 from 16 processes
2025-07-11 02:52:40,980 Finished 15 from 16 processes
2025-07-11 02:52:45,984 Finished 15 from 16 processes
2025-07-11 02:52:50,988 Finished 15 from 16 processes
2025-07-11 02:52:55,992 Finished 15 from 16 processes
2025-07-11 02:53:00,992 Finished 15 from 16 processes
2025-07-11 02:53:05,997 Finished 15 from 16 processes
2025-07-11 02:53:11,000 Finished 15 from 16 processes
2025-07-11 02:53:16,005 Finished 15 from 16 processes
2025-07-11 02:53:21,008 Finished 15 from 16 processes
2025-07-11 02:53:26,012 Finished 15 from 16 processes
2025-07-11 02:53:31,016 All processes finished
2025-07-11 02:53:31,016 Compressing stress logs
2025-07-11 02:53:31,052 Logs compressed
2025-07-11 02:53:31,052 Will terminate gdb (if any)
2025-07-11 02:53:31,052 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:53:31,056 Command returned 2, retrying
/bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or
kill -l [exitstatus]
2025-07-11 02:53:31,059 Command returned 2, retrying
/bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or
kill -l [exitstatus]
2025-07-11 02:53:32,064 Command returned 2, retrying
/bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or
kill -l [exitstatus]
2025-07-11 02:53:34,070 Command returned 2, retrying
/bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or
kill -l [exitstatus]
2025-07-11 02:53:37,075 Command returned 2, retrying
2025-07-11 02:53:41,079 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:53:41,089 Running command: kill -CONT $(cat /var/run/clickhouse-server/clickhouse-server.pid) && clickhouse client -q 'SELECT 1 FORMAT Null'
2025-07-11 02:53:41,404 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:53:41,669 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:53:41,983 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:53:42,298 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:53:42,613 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:53:42,928 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:53:43,193 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:53:43,508 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:53:43,822 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:53:44,087 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:53:44,352 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:53:44,617 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:53:44,882 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 60090.099561 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:54:46,969 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.63 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. 62064 0.062 5.63 MiB 0.032 99 501 ['Trace'] 1 Nothing to merge in partition {} with max_total_size_to_merge = {} (looked up {} ranges)
2. 55482 0.055 12.02 MiB 0.069 1 196 ['Debug'] 0 (from {}{}{}){}{}{} {} (stage: {})
3. 53924 0.054 8.09 MiB 0.046 19621 193 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {}
4. 47832 0.048 1.32 MiB 0.008 1 193 ['Debug'] 0 Processed in {} sec.
5. 40554 0.04 1.00 MiB 0.006 1 299 ['Trace'] 0.035 Query to stage {}{}
6. 39941 0.04 1.91 MiB 0.011 1 299 ['Trace'] 0.035 Query from stage {} to stage {}{}
7. 29869 0.03 2.32 MiB 0.013 1 155 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec.
8. 27171 0.027 1.19 MiB 0.007 1 3 ['Trace'] 1 Processing requests batch, size: {}, bytes: {}
9. 19940 0.02 945.14 KiB 0.005 19940 267 ['Debug'] 0.995 Authenticating user '{}' from {}
10. 19782 0.02 2.17 MiB 0.012 19782 267 ['Debug'] 0.995 {} Authenticated with global context as user {}
11. 19719 0.02 1.69 MiB 0.01 19719 267 ['Debug'] 0.995 {} Logout, user_id: {}
12. 19051 0.019 1.36 MiB 0.008 19051 193 ['Debug'] 1 Creating session context with user_id: {}
13. 15143 0.015 1.04 MiB 0.006 1 863 ['Trace'] 0.484 Reserved {} on local disk {}, having unreserved {}.
14. 15123 0.015 492.31 KiB 0.003 2 193 ['Trace'] 1 TCP Request. Address: {}
15. 15092 0.015 1.38 MiB 0.008 1 193 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}.
16. 14987 0.015 395.17 KiB 0.002 1 193 ['Debug'] 1 Done processing connection.
17. 13261 0.013 1.49 MiB 0.009 1214 367 ['Trace'] 0.298 Renaming temporary part {} to {} with tid {}.
18. 13002 0.013 598.16 KiB 0.003 1 368 ['Trace'] 0.258 filled checksums {}
19. 12916 0.013 895.64 KiB 0.005 1216 840 ['Trace'] 0.395 Trying to reserve {} using storage policy from min volume index {}
20. 12612 0.013 478.63 KiB 0.003 1 205 ['Debug'] 0.154 {}{} memory usage: {}.
21. 11737 0.012 492.86 KiB 0.003 1053 266 ['Debug'] 0.034 Found {} non used tables in detached tables.
22. 11737 0.012 699.18 KiB 0.004 1053 266 ['Debug'] 0.034 There are {} detached tables. Start searching non used tables.
23. 9212 0.009 955.03 KiB 0.005 1 76 ['Trace'] 0.002 Checking existence of path: {}
24. 9178 0.009 372.78 KiB 0.002 1 214 ['Trace'] 0.014 Read steps statistics: {}
25. 8226 0.008 469.56 KiB 0.003 2 49 ['Trace'] 0.947 Loading config file '{}'.
26. 7235 0.007 651.17 KiB 0.004 1 193 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.)
27. 7232 0.007 1.38 MiB 0.008 1 144 ['Trace'] 0 No query result found for query {}
28. 7070 0.007 211.96 KiB 0.001 1 191 ['Trace'] 0 Aggregation method: {}
29. 6507 0.006 173.56 KiB 0.001 797 221 ['Debug'] 0.019 Key condition: {}
30. 6326 0.006 588.90 KiB 0.003 1 102 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part
31. 6006 0.006 683.58 KiB 0.004 790 219 ['Debug'] 0.021 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges
32. 5724 0.006 1.38 MiB 0.008 1 227 ['Trace'] 0 {}Keys: {}, datatype: {}, kind: {}, strictness: {}, right header: {}
33. 5687 0.006 249.92 KiB 0.001 792 219 ['Trace'] 0.022 Filtering marks by primary and secondary keys
34. 5513 0.005 425.32 KiB 0.002 1 160 ['Trace'] 0 Query span trace_id for opentelemetry log: {}
35. 5452 0.005 122.46 KiB 0.001 1 186 ['Trace'] 0 Merging aggregated data
36. 5426 0.005 280.84 KiB 0.002 709 217 ['Trace'] 0.023 Spreading mark ranges among streams (default reading)
37. 5411 0.005 1.06 MiB 0.006 2 152 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {}
38. 5344 0.005 8.84 MiB 0.05 2 152 ['Trace'] 1 Request URI: {}
39. 5262 0.005 606.36 KiB 0.003 1 156 ['Debug'] 0 Done waiting for the table {} to be dropped. The outcome: {}
40. 5262 0.005 390.54 KiB 0.002 1 156 ['Debug'] 0 Waiting for table {} to be finally dropped
41. 5241 0.005 405.76 KiB 0.002 563 208 ['Trace'] 0.024 Reading {} ranges in{}order from part {}, approx. {} rows starting from {}
42. 4764 0.005 1.02 MiB 0.006 1 150 ['Information'] 1 Removing metadata {} of dropped table {}
43. 4746 0.005 50.98 KiB 0 1 173 ['Trace'] 0 Aggregating
44. 4663 0.005 1.03 MiB 0.006 1 131 ['Trace'] 0 Stored query result of query {}
45. 4661 0.005 513.27 KiB 0.003 1 152 ['Trace'] 0 Adjusting memory limit before external aggregation with {} (ratio: {}, available system memory: {})
46. 4557 0.005 93.45 KiB 0.001 2 149 ['Debug'] 0.128 Done processing query
47. 4461 0.004 492.51 KiB 0.003 1 29 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {}
48. 4385 0.004 299.45 KiB 0.002 1 123 ['Trace'] 0 Query result found for query {}
49. 3948 0.004 285.32 KiB 0.002 1 511 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {} tables
50. 3920 0.004 507.68 KiB 0.003 1 11 ['Trace'] 1 Creating part at path {}
51. 3904 0.004 1.19 MiB 0.007 1 230 ['Trace'] 0.022 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: {})
52. 3902 0.004 315.81 KiB 0.002 1 176 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={}
53. 3312 0.003 191.42 KiB 0.001 18 42 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {}
54. 3311 0.003 118.39 KiB 0.001 18 42 ['Trace'] 1 Flushed system log up to offset {}
55. 3307 0.003 96.88 KiB 0.001 100 63 ['Trace'] 1 Checking task {}
56. 3297 0.003 315.12 KiB 0.002 100 63 ['Debug'] 1 Will not execute task {}: {}
57. 3046 0.003 314.29 KiB 0.002 1 162 ['Trace'] 0 Adjusting memory limit before external sort with {} (ratio: {}, available system memory: {})
58. 3014 0.003 218.68 KiB 0.001 1 134 ['Trace'] 0 Handling request from replica {}, minimal marks size is {}, request count {}
59. 3014 0.003 383.44 KiB 0.002 1 134 ['Debug'] 0 Going to respond to replica {} with {}; mine_marks={}, stolen_by_hash={}, stolen_rest={}
60. 2917 0.003 416.85 KiB 0.002 1 144 ['Trace'] 0 Before join block: '{}'
61. 2895 0.003 714.43 KiB 0.004 1 144 ['Trace'] 0 After join block: '{}'
62. 2785 0.003 238.10 KiB 0.001 187 507 ['Trace'] 1 Scheduling next merge selecting task after {}ms, current attempt status: {}
63. 2710 0.003 19.46 MiB 0.111 5 18 ['Error'] 0.999 Missing columns: {} while processing: '{}', required columns:{}{}
64. 2706 0.003 245.93 KiB 0.001 109 500 ['Trace'] 0.997 Insert entry {} to queue with type {}
65. 2617 0.003 104.78 KiB 0.001 14 167 ['Trace'] 0.003 Sending external_roles with query: [{}] ({})
66. 2568 0.003 327.87 KiB 0.002 1 84 ['Debug'] 0 Could not find entry for table_uuid: {}, part: {}, condition_hash: {}
67. 2457 0.002 96.01 KiB 0.001 1 306 ['Debug'] 0.542 Spawn loader worker #{} in {}
68. 2457 0.002 69.60 KiB 0 1 228 ['Debug'] 1 Stop worker in {}
69. 2456 0.002 188.65 KiB 0.001 1 137 ['Debug'] 0.034 Schedule load job '{}' into {}
70. 2456 0.002 181.45 KiB 0.001 1 209 ['Debug'] 1 Execute load job '{}' in {}
71. 2456 0.002 171.84 KiB 0.001 1 209 ['Debug'] 1 Finish load job '{}' with status {}
72. 2447 0.002 228.62 KiB 0.001 1 139 ['Debug'] 0.023 Prioritize load job '{}': {} -> {}
73. 2413 0.002 190.65 KiB 0.001 97 218 ['Trace'] 0.9 Part {} is not stored on zero-copy replicated disk, blobs can be removed
74. 2409 0.002 393.91 KiB 0.002 99 501 ['Trace'] 1 Checked {} partitions, found {} partitions with parts that may be merged: [{}] (max_total_size_to_merge={}, merge_with_ttl_allowed={}, can_use_ttl_merges={})
75. 2287 0.002 67.00 KiB 0 187 514 ['Debug'] 0.995 Updating strategy picker state
76. 2261 0.002 75.06 KiB 0 1 302 ['Debug'] 0.505 Change current priority: {} -> {}
77. 2249 0.002 19.77 KiB 0 2 137 ['Trace'] 0.004 No tables
78. 2140 0.002 95.46 KiB 0.001 1 16 ['Trace'] 0 Mutating part {} to mutation version {}
79. 2112 0.002 49.66 KiB 0 1 84 ['Debug'] 0 Chosen segment size: {}
80. 2112 0.002 173.96 KiB 0.001 1 84 ['Debug'] 0 mark_segment_size={}, min_marks_per_task*threads={}, sum_marks/number_of_replicas^2={}
81. 2102 0.002 291.29 KiB 0.002 1 197 ['Debug'] 0 Initial request: {}
82. 2102 0.002 86.24 KiB 0 1 197 ['Debug'] 0 Sent initial requests: {} Replicas count: {}
83. 2070 0.002 10.78 MiB 0.062 4 20 ['Error'] 0.5 Value passed to '{}' function is non-zero
84. 2053 0.002 204.64 KiB 0.001 1263 525 ['Trace'] 1 Didn't start merge: {}
85. 1992 0.002 126.45 KiB 0.001 1 92 ['Trace'] 0.537 Creating temporary file '{}'
86. 1992 0.002 126.45 KiB 0.001 1 90 ['Trace'] 0.022 Removing temporary file '{}'
87. 1972 0.002 114.21 KiB 0.001 569 16 ['Trace'] 1 Executing log entry to mutate part {} to {}
88. 1971 0.002 276.42 KiB 0.002 568 16 ['Trace'] 1 Mutating part {} with mutation commands from {} mutations ({}): {}
89. 1957 0.002 142.59 KiB 0.001 1 110 ['Trace'] 0 The min valid primary key position for moving to the tail of PREWHERE is {}
90. 1900 0.002 151.33 KiB 0.001 1 176 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={}
91. 1900 0.002 76.07 KiB 0 1 97 ['Trace'] 0 PREWHERE condition was split into {} steps
92. 1860 0.002 107.17 KiB 0.001 108 499 ['Debug'] 0.996 Pulling {} entries to queue: {} - {}
93. 1858 0.002 47.18 KiB 0 108 499 ['Debug'] 0.996 Pulled {} entries to queue.
94. 1839 0.002 198.78 KiB 0.001 894 282 ['Debug'] 0.971 Removing {} parts from filesystem (serially): Parts: [{}]
95. 1809 0.002 245.84 KiB 0.001 1 188 ['Debug'] 0.779 (internal) {} (stage: {})
96. 1794 0.002 435.59 KiB 0.002 59 135 ['Debug'] 0 Proposing query: {}
97. 1784 0.002 153.31 KiB 0.001 58 135 ['Debug'] 0 Waiting for worker thread to process all entries before {} (timeout: {}s{})
98. 1762 0.002 431.71 KiB 0.002 53 138 ['Debug'] 0.005 Executing query: {}
99. 1762 0.002 514.30 KiB 0.003 53 138 ['Debug'] 0.005 Processing task {} (query: {}, backup restore: {})
100. 1757 0.002 167.08 KiB 0.001 53 43 ['Trace'] 1 Waiting for initiator {} to commit or rollback entry {}
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. 174 IfthesignaturecheckfailedThiscou If the signature check failed. This could be because of a time skew. Attempting to adjust the signer. ('/AWSLogger.cpp',70)
2. 82 voidDBStorageReplicatedMergeTree void DB::StorageReplicatedMergeTree::mutationsUpdatingTask(): Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): ↴ ('/Exception.cpp',285)
↳ ↴
↳0. ./contrib/llvm-project/libcxx/include/__exce
3. 80 CodeDBExceptionReceivedfromDBExc Code: 452. DB::Exception: Received from 127.2:9000. DB::Exception: Setting max_execution_time shouldn't be greater than 60.. Stack trace: ↴ ('/executeQuery.cpp',301)
↳ ↴
↳0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:106: Poco::Exception::Exception(String const&, int)
4. 28 CodeCoordinationExceptionSession Code: 999. Coordination::Exception: Session expired (fault injected on recv). (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): ↴ ('/Exception.cpp',285)
↳ ↴
↳0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:106: Poco::Exceptio
5. 8 voidDBReplicatedMergeTreeCleanup void DB::ReplicatedMergeTreeCleanupThread::run(): Code: 999. Coordination::Exception: Session expired (fault injected on send). (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): ↴ ('/Exception.cpp',285)
↳ ↴
↳0. ./contrib/llvm-project/libcxx/i
6. 7 autoDBStorageReplicatedMergeTree auto DB::StorageReplicatedMergeTree::processQueueEntry(ReplicatedMergeTreeQueue::SelectedEntryPtr)::(anonymous class)::operator()(LogEntryPtr &) const: Poco::Exception. Code: 1000, e.code() = 0, Malformed message: Unexpected EOF, Stack trace (when copying ('/Exception.cpp',285)
7. 6 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 0 ('/LoggerWrapper.h',43)
8. 6 CodeDBExceptionSyntaxerrorfailed Code: 62. DB::Exception: Syntax error: failed at position 27 ('expand'): expand c, d;. Max query size exceeded (can be increased with the `max_query_size` setting): 'expand'. (SYNTAX_ERROR) (version 25.3.3.20366.altinityantalya (altinity build)) (from [::1 ('/executeQuery.cpp',301)
9. 3 Connectiontomysqlfailedtimes Connection to mysql failed 1 times ('',0)
10. 3 Forkedachildprocesstowatch Forked a child process to watch ('',0)
11. 3 statemachinecommitindexprecommit state machine commit index 0, precommit index 0, last log index 0 ('/LoggerWrapper.h',43)
12. 3 snapshotidxlogtermcreatedcompact snapshot idx 20000 log_term 3 created, compact the log store if needed ('/LoggerWrapper.h',43)
13. 3 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',43)
14. 3 skippedconfiglatestconfig skipped config 1, latest config 1 ('/LoggerWrapper.h',43)
15. 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
16. 3 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',43)
17. 3 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',43)
18. 3 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',43)
19. 3 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1 ↴ ('/LoggerWrapper.h',43)
↳my id: 1, voting_member ↴
↳num peers: 0
20. 3 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',43)
21. 3 RaftASIOlistenerinitiatedonunsec Raft ASIO listener initiated on :::9234, unsecured ('/LoggerWrapper.h',43)
22. 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)
23. 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 --
24. 3 createsnapshotidxlogtermdoneusel create snapshot idx 20000 log_term 3 done: 269 us elapsed ('/LoggerWrapper.h',43)
25. 3 PRIORITYdecaytargetmine [PRIORITY] decay, target 1 -> 1, mine 1 ('/LoggerWrapper.h',43)
26. 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)
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 newconfiglogidxprevlogidxcurconf new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0 ('/LoggerWrapper.h',43)
29. 3 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 1 ('/LoggerWrapper.h',43)
30. 3 StartingClickHousealtinityantaly Starting ClickHouse 25.3.3.20366.altinityantalya (revision: 4294967295, git hash: 1abef611c9a40dce30ed011ede491e532b2a3e72, build id: 272D1DBBE949F13C5AC5781F4B66957032A6F910), PID 436 ('',0)
Top messages not matching their format strings:
message_format_string count() any_message
1. 285 Forked a child process to watch
2. {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 51 /var/lib/clickhouse/store/dcf/dcfc99c9-09cc-43f0-b410-bc77ff98f1ad/tmp_insert_201403_8_8_0/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 6 similar messages)
3. Cannot find '{}' in '{}' 6 Cannot find 'kernel' in '/sys/fs/cgroup/memory.stat' (skipped 5859 similar messages)
4. Substitution '\{}' in replacement argument is invalid, regexp has only {} capturing groups 4 Code: 36. DB::Exception: Substitution '\1' in replacement argument is invalid, regexp has only 0 capturing groups. (BAD_ARGUMENTS) (version 25.3.3.20366.altinityantalya (altinity build)) (from [::1]:42928) (comment: 02864_replace_regexp_string_fallback.sql) (query 2, line 7) (in query: -- negative tests↴
↳ -- Even if the fallback is used, invalid substitutions must throw an exception. ↴
↳ SELECT 'Hello' AS haystack, 'l' AS needle, '\\1' AS replacement, replaceRegexpOne(materialize(haystack), needle, replacement);), Stack trace (when copying this message, always include the lines below): ↴
↳ ↴
↳0. ./contrib/llvm-project/libcxx/include/__exception/exception.h:106: Poco::Exception::Exception(String const&, int) @ 0x0000000020d7ef40 ↴
↳1. ./build_docker/./src/Common/Exception.cpp:108: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000010abfa94 ↴
↳2. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x00000000087a7cc0 ↴
↳3. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, int&, int&&) @ 0x000000000eac2246 ↴
↳4. DB::ReplaceRegexpImpl::checkSubstitutions(std::basic_string_view>, int) @ 0x000000000eac73b5 ↴
↳5. DB::FunctionStringReplace, DB::(anonymous namespace)::NameReplaceRegexpOne>::executeImpl(std::vector> const&, std::shared_ptr const&, unsigned long) const @ 0x000000000eac42bb↴
↳6. DB::IFunction::executeImplDryRun(std::vector> const&, std::shared_ptr const&, unsigned long) const @ 0x00000000087a66e4 ↴
↳7. ./build_docker/./src/Functions/IFunctionAdaptors.cpp:16: DB::FunctionToExecutableFunctionAdaptor::executeDryRunImpl(std::vector> const&, std::shared_ptr const&, unsigned long) const @ 0x0000000015e8725c↴
↳8. DB::IExecutableFunction::executeWithoutLowCardinalityColumns(std::vector> const&, std::shared_ptr const&, unsigned long, bool) const @ 0x0000000015e7e5b8 ↴
↳9. DB::IExecutableFunction::executeWithoutSparseColumns(std::vector> const&, std::shared_ptr const&, unsigned long, bool) const @ 0x0000000015e8014e ↴
↳10. DB::IExecutableFunction::execute(std::vector> const&, std::shared_ptr const&, unsigned long, bool) const @ 0x0000000015e8197a ↴
↳11. ./build_docker/./src/Interpreters/ActionsDAG.cpp:812: DB::ActionsDAG::evaluatePartialResult(std::unordered_map, std::equal_to, std::allocator>>&, std::vector> const&, unsigned long, bool) @ 0x0000000017973cdf↴
↳12. ./build_docker/./src/Interpreters/ActionsDAG.cpp:892: DB::ActionsDAG::updateHeader(DB::Block const&) const @ 0x000000001797286a ↴
↳13. ./build_docker/./src/Processors/Transforms/ExpressionTransform.cpp:10: DB::ExpressionTransform::transformHeader(DB::Block const&, DB::ActionsDAG const&) @ 0x000000001c0605aa ↴
↳14. ./build_docker/./src/Processors/QueryPlan/ExpressionStep.cpp:38: DB::ExpressionStep::ExpressionStep(DB::Block const&, DB::ActionsDAG) @ 0x000000001c2b697b ↴
↳15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:634: std::__unique_if::__unique_single std::make_unique[abi:ne190107](DB::Block const&, DB::ActionsDAG&&) @ 0x00000000163f2522↴
↳16. ./build_docker/./src/Planner/Planner.cpp:394: DB::(anonymous namespace)::addExpressionStep(DB::QueryPlan&, std::shared_ptr&, String const&, std::unordered_set, std::hash>, std::equal_to>, std::allocator>>&) @ 0x0000000018931dc4↴
↳17. ./build_docker/./src/Planner/Planner.cpp:1663: DB::Planner::buildPlanForQueryNode() @ 0x0000000018929d19 ↴
↳18. ./build_docker/./src/Planner/Planner.cpp:1323: DB::Planner::buildQueryPlanIfNeeded() @ 0x0000000018922460 ↴
↳19. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:255: DB::InterpreterSelectQueryAnalyzer::getQueryPlan() @ 0x000000001891f1fb ↴
↳20. ./build_docker/./src/Interpreters/executeQuery.cpp:1405: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*, std::shared_ptr&) @ 0x0000000018db76bd↴
↳21. ./build_docker/./src/Interpreters/executeQuery.cpp:1624: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000018db2e4f ↴
↳22. ./build_docker/./src/Server/TCPHandler.cpp:663: DB::TCPHandler::runImpl() @ 0x000000001bb80285 ↴
↳23. ./build_docker/./src/Server/TCPHandler.cpp:2628: DB::TCPHandler::run() @ 0x000000001bba6fe8 ↴
↳24. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:40: Poco::Net::TCPServerConnection::start() @ 0x0000000020e8c983 ↴
↳25. ./build_docker/./base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x0000000020e8d1f2 ↴
↳26. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:205: Poco::PooledThread::run() @ 0x0000000020e07543 ↴
↳27. ./build_docker/./base/poco/Foundation/src/Thread.cpp:45: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x0000000020e058f0 ↴
↳28. ./base/poco/Foundation/src/Thread_POSIX.cpp:335: Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000020e03caa ↴
↳29. __tsan_thread_start_func @ 0x000000000871b428 ↴
↳30. ? @ 0x00007f8556593ac3 ↴
↳31. ? @ 0x00007f8556625850 ↴
5. (from {}{}{}){}{}{} {} (stage: {}) 1 (from [::1]:50222) (comment: 02685_bson2.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 JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion2 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID OriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime &�Q Age Sex Income Interests Robotness RemoteIP ^DI�WindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �|3�b.�CLID ^ WatchID �F�ӓ2qJavaEnable Title GoodEvent EventTime n$�Q EventDate > CounterID ClientIP �z�RegionID G UserID � �:6�CounterClass OS UserAgent URL Referer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor �OCookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID OriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime ǘ�Q Age Sex Income Interests Robotness RemoteIP ^DI�WindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �|3�b.�CLID ^ WatchID l!�|�@HJavaEnable Title GoodEvent EventTime �)�Q EventDate > CounterID ClientIP �z�RegionID G UserID � �:6�CounterClass OS UserAgent URL Referer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor �OCookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID OriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime }�Q Age Sex Income Interests Robotness RemoteIP ^DI�WindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �|3�b.�CLID ^ WatchID �ǐ=ЌWJavaEnable Title GoodEvent EventTime 8*�Q EventDate > CounterID ClientIP �z�RegionID G UserID � �:6�CounterClass OS UserAgent URL Referer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor �OCookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID OriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime ݞ�Q Age Sex Income Interests Robotness RemoteIP ^DI�WindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �|3�b.�CLID � WatchID �E&LyJavaEnable Title GoodEvent EventTime J�Q EventDate > CounterID ClientIP �I`RegionID ' UserID q�Jd8CounterClass OS UserAgent URL - http://holodilnik.ru/russia/05jul2013&model=0Referer IsRefresh RefererCategoryID RefererRegionID URLCategoryID �9 URLRegionID ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor
UserAgentMinor D�CookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �d9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID %�l�+kOriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime '�Q Age Sex Income Interests �: Robotness RemoteIP 9�3NWindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �↴
↳o�eCLID � WatchID �k=�pJavaEnable Title GoodEvent EventTime ��Q EventDate > CounterID ClientIP �z�RegionID G UserID
�Ks}�CounterClass OS UserAgent URL H http://afisha.mail.ru/catalog/314/women.ru/ency=1&page3/?errovat-pinnikiReferer IsRefresh RefererCategoryID RefererRegionID URLCategoryID 0= URLRegionID � ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor FlashMinor FlashMinor2 NetMajor NetMinor UserAgentMajor UserAgentMinor D�CookieEnable JavascriptEnable IsMobile MobilePhone MobilePhoneModel Params IPNetworkID �9 TraficSourceID SearchEngineID SearchPhrase AdvEngineID IsArtifical WindowClientWidth WindowClientHeight ClientTimeZone �ClientEventTime � SilverlightVersion1 SilverlightVersion2 SilverlightVersion3 SilverlightVersion4 PageCharset CodeVersion IsLink IsDownload IsNotBounce FUniqID :�W�mOriginalURL HID IsOldCounter IsEvent IsParameter DontCountHits WithHash HitColor 5LocalEventTime A�Q Age Sex Income Interests Robotness RemoteIP ^DI�WindowName �OpenerName �HistoryLength �BrowserLanguage �BrowserCountry �SocialNetwork SocialAction HTTPError SendTiming DNSTiming ConnectTiming ResponseStartTiming ResponseEndTiming FetchTiming SocialSourceNetworkID SocialSourcePage ParamPrice ParamOrderID ParamCurrency NHParamCurrencyID OpenstatServiceName OpenstatCampaignID OpenstatAdID OpenstatSourceID UTMSource UTMMedium UTMCampaign UTMContent UTMTerm FromTag HasGCLID RefererHash X+�'�URLHash �
�#�\CLID � WatchID �1�o�CJavaEnable Title GoodEvent EventTime �0�Q EventDate > CounterID ClientIP �^{]RegionID � UserID &n%�t"6CounterClass OS ' UserAgent URL > http://bonprix.ru/index.ru/cinema/art/0 986 424 233 сезонReferer IsRefresh RefererCategoryID RefererRegionID URLCategoryID URLRegionID � ResolutionWidth ResolutionHeight ResolutionDepth FlashMajor 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 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 $$); (stage: Complete)
6. Close WriteBufferFromAzureBlobStorage. {}. 1 Close WriteBufferFromAzureBlobStorage. slirhctsatzunzrwehrnqzucbfkbtllx. (LogSeriesLimiter: on interval from 2025-07-11 02:37:15 to 2025-07-11 02:37:26 accepted series 1 / 1 for the logger WriteBufferFromAzureBlobStorage)
Top short messages:
c message_format_string substr(any(toValidUTF8(message)), 1, 120) min_length_without_exception_boilerplate
1. 356 {} ThreadFuzzer is enabled. Application will run slowly and unstable. 34
2. 59 Cannot TRUNCATE dictionary Code: 62. DB::Exception: Cannot TRUNCATE dictionary. (SYNTAX_ERROR) (version 25.3.3.20366.altinityantalya (altinity buil 27
3. 8 Unknown data type family: {} Code: 50. DB::Exception: Unknown data type family: ab. (UNKNOWN_TYPE) (version 25.3.3.20366.altinityantalya (altinity bu 29
4. 5 Creating {}: {} Creating table test_k9uasksy.test_empty_blobs: CREATE TABLE IF NOT EXISTS test_k9uasksy.test_empty_blobs UUID 'b1d13d25- 178
5. 2 Session {} not found Code: 372. DB::Exception: Session test_9_6 not found. (SESSION_NOT_FOUND), Stack trace (when copying this message, alway 28
6. 2 Invalid cache key hex: {} Code: 36. DB::Exception: Invalid cache key hex: kek. (BAD_ARGUMENTS) (version 25.3.3.20366.altinityantalya (altinity bui 27
7. 2 Found {} on {} Found changelog_1_100000.bin on LocalLogDisk 18
8. 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.0026944637221779223,'Missing columns: {} while processing: \'{}\', required columns:{}{}') Error
(0.0007904423096426008,'ZooKeeper session has expired. Switching to a new session.') Warning
(0.004736688255518679,'Removing metadata {} of dropped table {}') Information
(0.05516790187777276,'(from {}{}{}){}{}{} {} (stage: {})') Debug
(0.061708190573155186,'Nothing to merge in partition {} with max_total_size_to_merge = {} (looked up {} ranges)') Trace
2025-07-11 02:55:13,655 Stress test finished
+ echo -e 'Test script exit code\tOK\t\N\t'
+ grep -Fa OK
+ rg -Fa 'No queries hung' /test_output/test_results.tsv
No queries hung OK \N
+ stop_server
+ local max_tries=90
+ local check_hang=true
+ local pid
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ pid=2884
+ 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 = 2884.
The process with pid = 2884 is running.
Sent terminate signal to process with pid 2884.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2884.
The process with pid = 2884 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2884.
The process with pid = 2884 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2884.
The process with pid = 2884 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2884.
The process with pid = 2884 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2884.
The process with pid = 2884 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2884.
The process with pid = 2884 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2884.
The process with pid = 2884 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'
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'
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 159450
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=159450
+ 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 = 159450.
The process with pid = 159450 is running.
Sent terminate signal to process with pid 159450.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 159450.
The process with pid = 159450 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 159450.
The process with pid = 159450 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 159450.
The process with pid = 159450 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 159450.
The process with pid = 159450 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 159450.
The process with pid = 159450 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 159450.
The process with pid = 159450 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 159450.
The process with pid = 159450 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 159450.
The process with pid = 159450 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 159450.
The process with pid = 159450 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 159450.
The process with pid = 159450 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 159450.
The process with pid = 159450 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 159450.
The process with pid = 159450 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'
+ rg -Fa 'it is lost forever' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ grep SharedMergeTreePartCheckThread
+ echo -e 'No SharedMergeTree lost forever in clickhouse-server.log\tOK\t\N\t'
+ '[' -s /test_output/no_such_key_errors.txt ']'
+ rm /test_output/no_such_key_errors.txt
+ rg -Fa '#######################################' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'Not crashed\tOK\t\N\t'
+ rg -Fa ' ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No fatal messages in clickhouse-server.log\tOK\t\N\t'
+ '[' -s /test_output/fatal_messages.txt ']'
+ rm /test_output/fatal_messages.txt
+ rg -Faz '########################################' /test_output/gdb.log /test_output/stress_run_logs.tar.zst /test_output/test_results.tsv
+ rg -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