+ ln -s /usr/share/clickhouse-test/ci/stress.py /usr/bin/stress + ln -s /usr/share/clickhouse-test/clickhouse-test /usr/bin/clickhouse-test + source /attach_gdb.lib ++ source /utils.lib +++ sysctl kernel.core_pattern=core.%e.%p-%P kernel.core_pattern = core.%e.%p-%P +++ sysctl fs.suid_dumpable=1 fs.suid_dumpable = 1 + source /stress_tests.lib ++ OK='\tOK\t\N\t' ++ FAIL='\tFAIL\t\N\t' ++ FAILURE_CONTEXT_LINES=100 ++ FAILURE_CONTEXT_MAX_LINE_WIDTH=300 + source /utils.lib ++ sysctl kernel.core_pattern=core.%e.%p-%P kernel.core_pattern = core.%e.%p-%P ++ sysctl fs.suid_dumpable=1 fs.suid_dumpable = 1 + install_packages package_folder + dpkg -i package_folder/clickhouse-common-static_24.8.14.10501.altinitytest+asan_amd64.deb Selecting previously unselected package clickhouse-common-static. (Reading database ... 48692 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static_24.8.14.10501.altinitytest+asan_amd64.deb ... Unpacking clickhouse-common-static (24.8.14.10501.altinitytest+asan) ... Setting up clickhouse-common-static (24.8.14.10501.altinitytest+asan) ... + dpkg -i package_folder/clickhouse-common-static-dbg_24.8.14.10501.altinitytest+asan_amd64.deb Selecting previously unselected package clickhouse-common-static-dbg. (Reading database ... 48719 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static-dbg_24.8.14.10501.altinitytest+asan_amd64.deb ... Unpacking clickhouse-common-static-dbg (24.8.14.10501.altinitytest+asan) ... Setting up clickhouse-common-static-dbg (24.8.14.10501.altinitytest+asan) ... + dpkg -i package_folder/clickhouse-server_24.8.14.10501.altinitytest+asan_amd64.deb Selecting previously unselected package clickhouse-server. (Reading database ... 48726 files and directories currently installed.) Preparing to unpack .../clickhouse-server_24.8.14.10501.altinitytest+asan_amd64.deb ... Unpacking clickhouse-server (24.8.14.10501.altinitytest+asan) ... Setting up clickhouse-server (24.8.14.10501.altinitytest+asan) ... ClickHouse binary is already located at /usr/bin/clickhouse Symlink /usr/bin/clickhouse-server already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-server to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-client to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-local to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-benchmark to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-obfuscator to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-git-import to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-compressor to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-format to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-extract-from-config already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-extract-from-config to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-keeper already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-keeper-converter already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper-converter to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-disks to /usr/bin/clickhouse. Creating symlink /usr/bin/ch to /usr/bin/clickhouse. Creating symlink /usr/bin/chl to /usr/bin/clickhouse. Creating symlink /usr/bin/chc to /usr/bin/clickhouse. Creating clickhouse group if it does not exist. groupadd -r clickhouse Creating clickhouse user if it does not exist. useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse clickhouse Will set ulimits for clickhouse user in /etc/security/limits.d/clickhouse.conf. Creating config directory /etc/clickhouse-server/config.d that is used for tweaks of main server configuration. Creating config directory /etc/clickhouse-server/users.d that is used for tweaks of users configuration. Config file /etc/clickhouse-server/config.xml already exists, will keep it and extract path info from it. /etc/clickhouse-server/config.xml has /var/lib/clickhouse/ as data path. /etc/clickhouse-server/config.xml has /var/log/clickhouse-server/ as log path. Users config file /etc/clickhouse-server/users.xml already exists, will keep it and extract users info from it. Log directory /var/log/clickhouse-server/ already exists. Creating data directory /var/lib/clickhouse/. Creating pid directory /var/run/clickhouse-server. chown -R clickhouse:clickhouse '/var/log/clickhouse-server/' chown -R clickhouse:clickhouse '/var/run/clickhouse-server' chown clickhouse:clickhouse '/var/lib/clickhouse/' Password for the default user is an empty string. See /etc/clickhouse-server/users.xml and /etc/clickhouse-server/users.d to change it. Setting capabilities for clickhouse binary. This is optional. chown -R clickhouse:clickhouse '/etc/clickhouse-server' ClickHouse has been successfully installed. Start clickhouse-server with: sudo clickhouse start Start clickhouse-client with: clickhouse-client + dpkg -i package_folder/clickhouse-client_24.8.14.10501.altinitytest+asan_amd64.deb Selecting previously unselected package clickhouse-client. (Reading database ... 48743 files and directories currently installed.) Preparing to unpack .../clickhouse-client_24.8.14.10501.altinitytest+asan_amd64.deb ... Unpacking clickhouse-client (24.8.14.10501.altinitytest+asan) ... Setting up clickhouse-client (24.8.14.10501.altinitytest+asan) ... + export THREAD_FUZZER_CPU_TIME_PERIOD_US=1000 + THREAD_FUZZER_CPU_TIME_PERIOD_US=1000 + export THREAD_FUZZER_SLEEP_PROBABILITY=0.1 + THREAD_FUZZER_SLEEP_PROBABILITY=0.1 + export THREAD_FUZZER_SLEEP_TIME_US_MAX=100000 + THREAD_FUZZER_SLEEP_TIME_US_MAX=100000 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX=10000 + export THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01 + THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01 + export THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01 + THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01 + export ZOOKEEPER_FAULT_INJECTION=1 + ZOOKEEPER_FAULT_INJECTION=1 + configure + export USE_DATABASE_ORDINARY=1 + USE_DATABASE_ORDINARY=1 + export EXPORT_S3_STORAGE_POLICIES=1 + EXPORT_S3_STORAGE_POLICIES=1 + /usr/share/clickhouse-test/config/install.sh + DEST_SERVER_PATH=/etc/clickhouse-server + DEST_CLIENT_PATH=/etc/clickhouse-client +++ dirname /usr/share/clickhouse-test/config/install.sh ++ cd /usr/share/clickhouse-test/config ++ pwd -P Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + SRC_PATH=/usr/share/clickhouse-test/config + echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server' + mkdir -p /etc/clickhouse-server/config.d/ + mkdir -p /etc/clickhouse-server/users.d/ + mkdir -p /etc/clickhouse-client + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_catalog_drop_table_concurrency.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/grpc_protocol.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/block_number.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/serverwide_trace_collector.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/rocksdb.xml /etc/clickhouse-server/config.d/ + '[' /etc/clickhouse-server = /etc/clickhouse-server ']' + ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/ + ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + rm -f /etc/clickhouse-server/config.d/zookeeper.xml + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/ + [[ -n '' ]] + rm -f /etc/clickhouse-server/config.d/cannot_allocate_thread_injection.xml + value=1 + sed --follow-symlinks -i 's|[01]|1|' /etc/clickhouse-server/config.d/keeper_port.xml + value=19052544 + sed --follow-symlinks -i 's|[[:digit:]]\+|19052544|' /etc/clickhouse-server/config.d/keeper_port.xml + value=2338816 + sed --follow-symlinks -i 's|[[:digit:]]\+|2338816|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/ + [[ '' == \1 ]] + [[ '' == \1 ]] + [[ -n 1 ]] + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|100000|10000|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value filtered_list keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value multi_read keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value check_not_exists keeper_port + value=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value create_if_not_exists keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value use_compression zookeeper_fault_injection + value=1 + sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + randomize_config_boolean_value enable_block_number_column block_number + value=0 + sudo cat /etc/clickhouse-server/config.d/block_number.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml + randomize_config_boolean_value enable_block_offset_column block_number + value=0 + sudo cat /etc/clickhouse-server/config.d/block_number.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml + echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\''' + export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + sudo chown root: /var/lib/clickhouse + local total_mem ++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo + total_mem=32086440 + total_mem=32856514560 + max_server_memory_usage_to_ram_ratio=0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat Setting max_server_memory_usage_to_ram_ratio to 0.5 + local max_users_mem + max_users_mem=9856954368 + echo 'Setting max_memory_usage_for_user=9856954368 and max_memory_usage for queries to 10G' + cat Setting max_memory_usage_for_user=9856954368 and max_memory_usage for queries to 10G + cat + ./setup_minio.sh stateless + azurite-blob --blobHost 0.0.0.0 --blobPort 10000 --debug /azurite_log + export MINIO_ROOT_USER=clickhouse + MINIO_ROOT_USER=clickhouse + export MINIO_ROOT_PASSWORD=clickhouse + MINIO_ROOT_PASSWORD=clickhouse + main stateless + local query_dir ++ check_arg stateless ++ local query_dir ++ '[' '!' 1 -eq 1 ']' ++ case "$1" in ++ query_dir=0_stateless ++ echo 0_stateless + query_dir=0_stateless + '[' '!' -f ./minio ']' + start_minio + mkdir -p ./minio_data + ./minio --version minio version RELEASE.2024-08-03T04-33-23Z (commit-id=6efb56851c40da88d1ca15112e2d686a4ecec6b3) Runtime: go1.22.5 linux/amd64 License: GNU AGPLv3 - https://www.gnu.org/licenses/agpl-3.0.html Copyright: 2015-2024 MinIO, Inc. + wait_for_it + local counter=0 + local max_counter=60 + local url=http://localhost:11111 + params=('--silent' '--verbose') + local params + ./minio server --address :11111 ./minio_data + grep AccessDenied + curl --silent --verbose http://localhost:11111 trying to connect to minio + [[ 0 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 Azurite Blob service is starting on 0.0.0.0:10000 Azurite Blob service successfully listens on http://0.0.0.0:10000 INFO: Formatting 1st pool, 1 set(s), 1 drives per set. INFO: WARNING: Host local has more than 0 drives of set. A host failure will result in data becoming unavailable. MinIO Object Storage Server Copyright: 2015-2025 MinIO, Inc. License: GNU AGPLv3 - https://www.gnu.org/licenses/agpl-3.0.html Version: RELEASE.2024-08-03T04-33-23Z (go1.22.5 linux/amd64) API: http://172.17.0.2:11111 http://127.0.0.1:11111 WebUI: http://172.17.0.2:43375 http://127.0.0.1:43375 Docs: https://min.io/docs/minio/linux/index.html + counter=1 + grep AccessDenied + curl --silent --verbose http://localhost:11111 AccessDeniedAccess Denied./184CE694822E145E7dc7eb22d3288ec80374614e9088e31d3668a6922ead55932dd2a8e56373820f + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 274 root 8u IPv4 20000 0t0 TCP localhost:11111 (LISTEN) minio 274 root 9u IPv6 20001 0t0 TCP *:11111 (LISTEN) minio 274 root 10u IPv6 20002 0t0 TCP localhost:11111 (LISTEN) + sleep 5 + setup_minio stateless + local test_type=stateless + ./mc alias set clickminio http://localhost:11111 clickhouse clickhouse Added `clickminio` successfully. + ./mc admin user add clickminio test testtest Added user `test` successfully. + ./mc admin policy attach clickminio readwrite --user=test Attached Policies: [readwrite] To User: test + ./mc mb --ignore-existing clickminio/test Bucket created successfully `clickminio/test`. + '[' stateless = stateless ']' + ./mc anonymous set public clickminio/test Access permission for `clickminio/test` is set to `public` + upload_data 0_stateless /usr/share/clickhouse-test + local query_dir=0_stateless + local test_path=/usr/share/clickhouse-test + local data_path=/usr/share/clickhouse-test/queries/0_stateless/data_minio + '[' -d /usr/share/clickhouse-test/queries/0_stateless/data_minio ']' + ./mc cp --recursive /usr/share/clickhouse-test/queries/0_stateless/data_minio/ clickminio/test/ `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet` -> `clickminio/test/02731.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl` -> `clickminio/test/02366_data.jsonl` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive1.zip` -> `clickminio/test/03036_archive1.zip` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive1.tar` -> `clickminio/test/03036_archive1.tar` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02876.parquet` -> `clickminio/test/02876.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow` -> `clickminio/test/02731.arrow` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive2.tar` -> `clickminio/test/03036_archive2.tar` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive2.zip` -> `clickminio/test/03036_archive2.zip` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_archive3.tar.gz` -> `clickminio/test/03036_archive3.tar.gz` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_compressed_file_archive.zip` -> `clickminio/test/03036_compressed_file_archive.zip` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/03036_json_archive.zip` -> `clickminio/test/03036_json_archive.zip` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv` -> `clickminio/test/a.tsv` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv` -> `clickminio/test/b.tsv` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv` -> `clickminio/test/c.tsv` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/hive_partitioning/column0=Elizabeth/column1=Gordon/sample.parquet` -> `clickminio/test/hive_partitioning/column0=Elizabeth/column1=Gordon/sample.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/hive_partitioning/column0=Elizabeth/column1=Schmidt/sample.parquet` -> `clickminio/test/hive_partitioning/column0=Elizabeth/column1=Schmidt/sample.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/hive_partitioning/column0=Elizabeth/sample.parquet` -> `clickminio/test/hive_partitioning/column0=Elizabeth/sample.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/hive_partitioning/non_existing_column=Elizabeth/sample.parquet` -> `clickminio/test/hive_partitioning/non_existing_column=Elizabeth/sample.parquet` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/json_data` -> `clickminio/test/json_data` `/usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv` -> `clickminio/test/tsv_with_header.tsv` Total: 5.42 MiB, Transferred: 5.42 MiB, Speed: 118.93 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 + 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 127.0.0.1 - - [27/Jun/2025:12:38:15 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 404 - 127.0.0.1 - - [27/Jun/2025:12:38:15 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [27/Jun/2025:12:38:15 +0000] "PUT /devstoreaccount1/cont/qecbuzbwrqkqmvjaiaapsgjridadoojh HTTP/1.1" 201 - 127.0.0.1 - - [27/Jun/2025:12:38:15 +0000] "GET /devstoreaccount1/cont/qecbuzbwrqkqmvjaiaapsgjridadoojh HTTP/1.1" 206 4 127.0.0.1 - - [27/Jun/2025:12:38:15 +0000] "GET /devstoreaccount1/cont/qecbuzbwrqkqmvjaiaapsgjridadoojh HTTP/1.1" 206 2 127.0.0.1 - - [27/Jun/2025:12:38:15 +0000] "DELETE /devstoreaccount1/cont/qecbuzbwrqkqmvjaiaapsgjridadoojh HTTP/1.1" 202 - + counter=10 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ [[ hxB =~ e ]] ++ set_e=false ++ set +e ++ local total_retries=5 ++ shift ++ local retry=0 ++ '[' 0 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ false ++ return + IS_ASAN=1 + [[ 1 = \1 ]] ASAN build detected. Not using gdb since it disables LeakSanitizer detections + echo 'ASAN build detected. Not using gdb since it disables LeakSanitizer detections' + setup_logs_replication + set +x File /tmp/export-logs-config.sh does not exist, do not setup + clickhouse-client --query 'CREATE DATABASE datasets' + clickhouse-client --multiquery + clickhouse-client --query 'SHOW TABLES FROM datasets' hits_v1 visits_v1 + clickhouse-client --query 'CREATE DATABASE IF NOT EXISTS test' + stop_server + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=407 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 407. The process with pid = 407 is running. Sent terminate signal to process with pid 407. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 407. The process with pid = 407 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 407. The process with pid = 407 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 407. The process with pid = 407 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 407. The process with pid = 407 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 407. The process with pid = 407 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 407. The process with pid = 407 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 407. The process with pid = 407 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 407. The process with pid = 407 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.initial.log Using cache policy: SLRU + cache_policy= + '[' 1 -eq 1 ']' + cache_policy=SLRU + echo 'Using cache policy: SLRU' + '[' SLRU = SLRU ']' + sudo cat /etc/clickhouse-server/config.d/storage_conf.xml + sed 's|LRU|SLRU|' + mv /etc/clickhouse-server/config.d/storage_conf.xml.tmp /etc/clickhouse-server/config.d/storage_conf.xml + sudo cat /etc/clickhouse-server/users.d/stress_tests_overrides.xml cat: /etc/clickhouse-server/users.d/stress_tests_overrides.xml: No such file or directory + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 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 127.0.0.1 - - [27/Jun/2025:12:38:53 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - 127.0.0.1 - - [27/Jun/2025:12:38:53 +0000] "PUT /devstoreaccount1/cont/rvypuzbhmwewymiqubznhqvorzhjggyl HTTP/1.1" 201 - 127.0.0.1 - - [27/Jun/2025:12:38:53 +0000] "GET /devstoreaccount1/cont/rvypuzbhmwewymiqubznhqvorzhjggyl HTTP/1.1" 206 4 127.0.0.1 - - [27/Jun/2025:12:38:53 +0000] "GET /devstoreaccount1/cont/rvypuzbhmwewymiqubznhqvorzhjggyl HTTP/1.1" 206 2 127.0.0.1 - - [27/Jun/2025:12:38:53 +0000] "DELETE /devstoreaccount1/cont/rvypuzbhmwewymiqubznhqvorzhjggyl HTTP/1.1" 202 - + 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' 1 + attach_gdb_to_clickhouse ++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ [[ hxB =~ e ]] ++ set_e=false ++ set +e ++ local total_retries=5 ++ shift ++ local retry=0 ++ '[' 0 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ false ++ return + IS_ASAN=1 + [[ 1 = \1 ]] + echo 'ASAN build detected. Not using gdb since it disables LeakSanitizer detections' ASAN build detected. Not using gdb since it disables LeakSanitizer detections + clickhouse-client --query 'SHOW TABLES FROM datasets' hits_v1 visits_v1 + clickhouse-client --query 'SHOW TABLES FROM test' + [[ '' == \1 ]] + [[ '' == \1 ]] + TEMP_POLICY=default + clickhouse-client --query 'CREATE TABLE test.hits_s3 (WatchID UInt64, JavaEnable UInt8, Title String, GoodEvent Int16, EventTime DateTime, EventDate Date, CounterID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RegionID UInt32, UserID UInt64, CounterClass Int8, OS UInt8, UserAgent UInt8, URL String, Referer String, URLDomain String, RefererDomain String, Refresh UInt8, IsRobot UInt8, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32), RefererRegions Array(UInt32), ResolutionWidth UInt16, ResolutionHeight UInt16, ResolutionDepth UInt8, FlashMajor UInt8, FlashMinor UInt8, FlashMinor2 String, NetMajor UInt8, NetMinor UInt8, UserAgentMajor UInt16, UserAgentMinor FixedString(2), CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, MobilePhone UInt8, MobilePhoneModel String, Params String, IPNetworkID UInt32, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, IsArtifical UInt8, WindowClientWidth UInt16, WindowClientHeight UInt16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 UInt8, SilverlightVersion2 UInt8, SilverlightVersion3 UInt32, SilverlightVersion4 UInt16, PageCharset String, CodeVersion UInt32, IsLink UInt8, IsDownload UInt8, IsNotBounce UInt8, FUniqID UInt64, HID UInt32, IsOldCounter UInt8, IsEvent UInt8, IsParameter UInt8, DontCountHits UInt8, WithHash UInt8, HitColor FixedString(1), UTCEventTime DateTime, Age UInt8, Sex UInt8, Income UInt8, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), RemoteIP UInt32, RemoteIP6 FixedString(16), WindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage FixedString(2), BrowserCountry FixedString(2), SocialNetwork String, SocialAction String, HTTPError UInt16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, FetchTiming Int32, RedirectTiming Int32, DOMInteractiveTiming Int32, DOMContentLoadedTiming Int32, DOMCompleteTiming Int32, LoadEventStartTiming Int32, LoadEventEndTiming Int32, NSToDOMContentLoadedTiming Int32, FirstPaintTiming Int32, RedirectCount Int8, SocialSourceNetworkID UInt8, SocialSourcePage String, ParamPrice Int64, ParamOrderID String, ParamCurrency FixedString(3), ParamCurrencyID UInt16, GoalsReached Array(UInt32), OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, RefererHash UInt64, URLHash UInt64, CLID UInt32, YCLID UInt64, ShareService String, ShareURL String, ShareTitle String, ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64), IslandID FixedString(16), RequestNum UInt32, RequestTry UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate) ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''default'\''' + clickhouse-client --query 'CREATE TABLE test.hits (WatchID UInt64, JavaEnable UInt8, Title String, GoodEvent Int16, EventTime DateTime, EventDate Date, CounterID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RegionID UInt32, UserID UInt64, CounterClass Int8, OS UInt8, UserAgent UInt8, URL String, Referer String, URLDomain String, RefererDomain String, Refresh UInt8, IsRobot UInt8, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32), RefererRegions Array(UInt32), ResolutionWidth UInt16, ResolutionHeight UInt16, ResolutionDepth UInt8, FlashMajor UInt8, FlashMinor UInt8, FlashMinor2 String, NetMajor UInt8, NetMinor UInt8, UserAgentMajor UInt16, UserAgentMinor FixedString(2), CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, MobilePhone UInt8, MobilePhoneModel String, Params String, IPNetworkID UInt32, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, IsArtifical UInt8, WindowClientWidth UInt16, WindowClientHeight UInt16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 UInt8, SilverlightVersion2 UInt8, SilverlightVersion3 UInt32, SilverlightVersion4 UInt16, PageCharset String, CodeVersion UInt32, IsLink UInt8, IsDownload UInt8, IsNotBounce UInt8, FUniqID UInt64, HID UInt32, IsOldCounter UInt8, IsEvent UInt8, IsParameter UInt8, DontCountHits UInt8, WithHash UInt8, HitColor FixedString(1), UTCEventTime DateTime, Age UInt8, Sex UInt8, Income UInt8, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), RemoteIP UInt32, RemoteIP6 FixedString(16), WindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage FixedString(2), BrowserCountry FixedString(2), SocialNetwork String, SocialAction String, HTTPError UInt16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, FetchTiming Int32, RedirectTiming Int32, DOMInteractiveTiming Int32, DOMContentLoadedTiming Int32, DOMCompleteTiming Int32, LoadEventStartTiming Int32, LoadEventEndTiming Int32, NSToDOMContentLoadedTiming Int32, FirstPaintTiming Int32, RedirectCount Int8, SocialSourceNetworkID UInt8, SocialSourcePage String, ParamPrice Int64, ParamOrderID String, ParamCurrency FixedString(3), ParamCurrencyID UInt16, GoalsReached Array(UInt32), OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, RefererHash UInt64, URLHash UInt64, CLID UInt32, YCLID UInt64, ShareService String, ShareURL String, ShareTitle String, ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64), IslandID FixedString(16), RequestNum UInt32, RequestTry UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate) ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''default'\''' + clickhouse-client --query 'CREATE TABLE test.visits (CounterID UInt32, StartDate Date, Sign Int8, IsNew UInt8, VisitID UInt64, UserID UInt64, StartTime DateTime, Duration UInt32, UTCStartTime DateTime, PageViews Int32, Hits Int32, IsBounce UInt8, Referer String, StartURL String, RefererDomain String, StartURLDomain String, EndURL String, LinkURL String, IsDownload UInt8, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, PlaceID Int32, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32), RefererRegions Array(UInt32), IsYandex UInt8, GoalReachesDepth Int32, GoalReachesURL Int32, GoalReachesAny Int32, SocialSourceNetworkID UInt8, SocialSourcePage String, MobilePhoneModel String, ClientEventTime DateTime, RegionID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RemoteIP UInt32, RemoteIP6 FixedString(16), IPNetworkID UInt32, SilverlightVersion3 UInt32, CodeVersion UInt32, ResolutionWidth UInt16, ResolutionHeight UInt16, UserAgentMajor UInt16, UserAgentMinor UInt16, WindowClientWidth UInt16, WindowClientHeight UInt16, SilverlightVersion2 UInt8, SilverlightVersion4 UInt16, FlashVersion3 UInt16, FlashVersion4 UInt16, ClientTimeZone Int16, OS UInt8, UserAgent UInt8, ResolutionDepth UInt8, FlashMajor UInt8, FlashMinor UInt8, NetMajor UInt8, NetMinor UInt8, MobilePhone UInt8, SilverlightVersion1 UInt8, Age UInt8, Sex UInt8, Income UInt8, JavaEnable UInt8, CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, BrowserLanguage UInt16, BrowserCountry UInt16, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), Params Array(String), Goals Nested(ID UInt32, Serial UInt32, EventTime DateTime, Price Int64, OrderID String, CurrencyID UInt32), WatchIDs Array(UInt64), ParamSumPrice Int64, ParamCurrency FixedString(3), ParamCurrencyID UInt16, ClickLogID UInt64, ClickEventID Int32, ClickGoodEvent Int32, ClickEventTime DateTime, ClickPriorityID Int32, ClickPhraseID Int32, ClickPageID Int32, ClickPlaceID Int32, ClickTypeID Int32, ClickResourceID Int32, ClickCost UInt32, ClickClientIP UInt32, ClickDomainID UInt32, ClickURL String, ClickAttempt UInt8, ClickOrderID UInt32, ClickBannerID UInt32, ClickMarketCategoryID UInt32, ClickMarketPP UInt32, ClickMarketCategoryName String, ClickMarketPPName String, ClickAWAPSCampaignName String, ClickPageName String, ClickTargetType UInt16, ClickTargetPhraseID UInt64, ClickContextType UInt8, ClickSelectType Int8, ClickOptions String, ClickGroupBannerID Int32, OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, FirstVisit DateTime, PredLastVisit Date, LastVisit Date, TotalVisits UInt32, TraficSource Nested(ID Int8, SearchEngineID UInt16, AdvEngineID UInt8, PlaceID UInt16, SocialSourceNetworkID UInt8, Domain String, SearchPhrase String, SocialSourcePage String), Attendance FixedString(16), CLID UInt32, YCLID UInt64, NormalizedRefererHash UInt64, SearchPhraseHash UInt64, RefererDomainHash UInt64, NormalizedStartURLHash UInt64, StartURLDomainHash UInt64, NormalizedEndURLHash UInt64, TopLevelDomain UInt64, URLScheme UInt64, OpenstatServiceNameHash UInt64, OpenstatCampaignIDHash UInt64, OpenstatAdIDHash UInt64, OpenstatSourceIDHash UInt64, UTMSourceHash UInt64, UTMMediumHash UInt64, UTMCampaignHash UInt64, UTMContentHash UInt64, UTMTermHash UInt64, FromHash UInt64, WebVisorEnabled UInt8, WebVisorActivity UInt32, ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64), Market Nested(Type UInt8, GoalID UInt32, OrderID String, OrderPrice Int64, PP UInt32, DirectPlaceID UInt32, DirectOrderID UInt32, DirectBannerID UInt32, GoodID String, GoodName String, GoodQuantity Int32, GoodPrice Int64), IslandID FixedString(16)) ENGINE = CollapsingMergeTree(Sign) PARTITION BY toYYYYMM(StartDate) ORDER BY (CounterID, StartDate, intHash32(UserID), VisitID) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''default'\''' + clickhouse-client --query 'INSERT INTO test.hits_s3 SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16' Received exception from server (version 24.8.14): Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (for user) exceeded: would use 9.18 GiB (attempt to allocate chunk of 1048704 bytes), maximum: 9.18 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.: (while reading column ParsedParams.Key1): (while reading from part store/78e/78ebf6a1-d987-4579-b3ec-00c1a087b1f3/201403_1_1_2/ in table datasets.hits_v1 (78ebf6a1-d987-4579-b3ec-00c1a087b1f3) located on disk __tmp_internal_262634248876485800814430204900764312493 of type web, from mark 224 with max_rows_to_read = 8192): While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (MEMORY_LIMIT_EXCEEDED) (query: INSERT INTO test.hits_s3 SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16) + clickhouse-client --query 'INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16' Received exception from server (version 24.8.14): Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (for user) exceeded: would use 9.18 GiB (attempt to allocate chunk of 1081472 bytes), maximum: 9.18 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker.: (while reading column RefererCategories): (while reading from part store/78e/78ebf6a1-d987-4579-b3ec-00c1a087b1f3/201403_1_1_2/ in table datasets.hits_v1 (78ebf6a1-d987-4579-b3ec-00c1a087b1f3) located on disk __tmp_internal_262634248876485800814430204900764312493 of type web, from mark 292 with max_rows_to_read = 8192): While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (MEMORY_LIMIT_EXCEEDED) (query: INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16) + clickhouse-client --query 'INSERT INTO test.visits SELECT * FROM datasets.visits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0, max_insert_threads=16' + 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=1278 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1278. The process with pid = 1278 is running. Sent terminate signal to process with pid 1278. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1278. The process with pid = 1278 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1278. The process with pid = 1278 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1278. The process with pid = 1278 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1278. The process with pid = 1278 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1278. The process with pid = 1278 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + export RANDOMIZE_OBJECT_KEY_TYPE=1 + RANDOMIZE_OBJECT_KEY_TYPE=1 + export ZOOKEEPER_FAULT_INJECTION=1 + ZOOKEEPER_FAULT_INJECTION=1 + export THREAD_POOL_FAULT_INJECTION=1 + THREAD_POOL_FAULT_INJECTION=1 + configure + export USE_DATABASE_ORDINARY=1 + USE_DATABASE_ORDINARY=1 + export EXPORT_S3_STORAGE_POLICIES=1 + EXPORT_S3_STORAGE_POLICIES=1 + /usr/share/clickhouse-test/config/install.sh + DEST_SERVER_PATH=/etc/clickhouse-server + DEST_CLIENT_PATH=/etc/clickhouse-client +++ dirname /usr/share/clickhouse-test/config/install.sh ++ cd /usr/share/clickhouse-test/config ++ pwd -P + SRC_PATH=/usr/share/clickhouse-test/config + echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server' + mkdir -p /etc/clickhouse-server/config.d/ Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + mkdir -p /etc/clickhouse-server/users.d/ + mkdir -p /etc/clickhouse-client + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_num_to_warn.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/blob_storage_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_catalog_drop_table_concurrency.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite_alternative.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/grpc_protocol.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backoff_failed_mutation.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zero_copy_destructive_operations.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/block_number.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/handlers.yaml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/serverwide_trace_collector.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/rocksdb.xml /etc/clickhouse-server/config.d/ + '[' /etc/clickhouse-server = /etc/clickhouse-server ']' + ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/allow_introspection_functions.yaml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/replicated_ddl_entry.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/ + ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + rm -f /etc/clickhouse-server/config.d/zookeeper.xml + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/config.d/cannot_allocate_thread_injection.xml /etc/clickhouse-server/config.d/ + value=1 + sed --follow-symlinks -i 's|[01]|1|' /etc/clickhouse-server/config.d/keeper_port.xml + value=63629312 + sed --follow-symlinks -i 's|[[:digit:]]\+|63629312|' /etc/clickhouse-server/config.d/keeper_port.xml + value=29982720 + sed --follow-symlinks -i 's|[[:digit:]]\+|29982720|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/ + [[ '' == \1 ]] + [[ '' == \1 ]] + [[ -n 1 ]] + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02944.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02963.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf_02961.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache_new.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|100000|10000|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value filtered_list keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value multi_read keeper_port + value=1 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value check_not_exists keeper_port + value=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + randomize_config_boolean_value create_if_not_exists keeper_port + value=0 + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n 1 ]] + [[ 1 -eq 1 ]] + randomize_config_boolean_value use_compression zookeeper_fault_injection + value=0 + sudo cat /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml.tmp /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + randomize_config_boolean_value enable_block_number_column block_number + value=0 + sudo cat /etc/clickhouse-server/config.d/block_number.xml + sed 's|[01]|0|' + sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml + randomize_config_boolean_value enable_block_offset_column block_number + value=1 + sudo cat /etc/clickhouse-server/config.d/block_number.xml + sed 's|[01]|1|' + sudo mv /etc/clickhouse-server/config.d/block_number.xml.tmp /etc/clickhouse-server/config.d/block_number.xml + echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\''' + export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + sudo chown root: /var/lib/clickhouse + local total_mem ++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo + total_mem=32086440 + total_mem=32856514560 + max_server_memory_usage_to_ram_ratio=0.5 Setting max_server_memory_usage_to_ram_ratio to 0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat + local max_users_mem + max_users_mem=9856954368 + echo 'Setting max_memory_usage_for_user=9856954368 and max_memory_usage for queries to 10G' + cat Setting max_memory_usage_for_user=9856954368 and max_memory_usage for queries to 10G + cat + [[ '' == \1 ]] + [[ '' == \1 ]] + sudo cat /etc/clickhouse-server/config.d/logger_trace.xml + sed 's|trace|test|' + mv /etc/clickhouse-server/config.d/logger_trace.xml.tmp /etc/clickhouse-server/config.d/logger_trace.xml + '[' 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' 127.0.0.1 - - [27/Jun/2025:12:41:11 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - 127.0.0.1 - - [27/Jun/2025:12:41:11 +0000] "PUT /devstoreaccount1/cont/atsltfwcavfwynigisuzxpqvzgcullen HTTP/1.1" 201 - 127.0.0.1 - - [27/Jun/2025:12:41:11 +0000] "GET /devstoreaccount1/cont/atsltfwcavfwynigisuzxpqvzgcullen HTTP/1.1" 206 4 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 127.0.0.1 - - [27/Jun/2025:12:41:11 +0000] "GET /devstoreaccount1/cont/atsltfwcavfwynigisuzxpqvzgcullen HTTP/1.1" 206 2 127.0.0.1 - - [27/Jun/2025:12:41:11 +0000] "DELETE /devstoreaccount1/cont/atsltfwcavfwynigisuzxpqvzgcullen HTTP/1.1" 202 - + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 15 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=16 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ [[ hxB =~ e ]] ++ set_e=false ++ set +e ++ local total_retries=5 ++ shift ++ local retry=0 ++ '[' 0 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' Received exception from server (version 24.8.14): Code: 439. DB::Exception: Received from localhost:9000. DB::Exception: Cannot schedule a task: fault injected (threads=1, jobs=1). (CANNOT_SCHEDULE_TASK) (query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value)) ++ retry=1 ++ sleep 5 ++ '[' 1 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ false ++ return ASAN build detected. Not using gdb since it disables LeakSanitizer detections + IS_ASAN=1 + [[ 1 = \1 ]] + echo 'ASAN build detected. Not using gdb since it disables LeakSanitizer detections' + stress --hung-check --drop-databases --output-folder test_output --skip-func-tests '' --global-time-limit 1200 2025-06-27 14:41:25,520 Run func tests '/usr/bin/clickhouse-test --client-option ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-06-27 14:41:26,022 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_1 --client-option join_use_nulls=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.5 --global_time_limit=1200 ' 2025-06-27 14:41:26,523 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.5 --global_time_limit=1200 ' 2025-06-27 14:41:27,025 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_3 --client-option join_algorithm='partial_merge' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-06-27 14:41:27,526 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-06-27 14:41:28,028 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.5 --global_time_limit=1200 ' 2025-06-27 14:41:28,529 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 http_make_head_request=0 ignore_drop_queries_probability=0.5 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 ' 2025-06-27 14:41:29,030 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 http_make_head_request=0 ignore_drop_queries_probability=0.5 enable_parallel_replicas=1 max_parallel_replicas=3 cluster_for_parallel_replicas='parallel_replicas' parallel_replicas_for_non_replicated_merge_tree=1 --global_time_limit=1200 ' 2025-06-27 14:41:29,532 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 optimize_trivial_approximate_count_query=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-06-27 14:41:30,033 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_9 --client-option join_algorithm='auto' max_rows_in_join=1000 use_query_cache=1 query_cache_nondeterministic_function_handling='ignore' query_cache_system_table_handling='ignore' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-06-27 14:41:30,534 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' http_make_head_request=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-06-27 14:41:31,035 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_11', 's1', 'r1')" --database=test_11 --client-option enable_deflate_qpl_codec=1 enable_zstd_qat_codec=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability=0.05 group_by_use_nulls=1 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-06-27 14:41:31,537 Run func tests '/usr/bin/clickhouse-test --order=random --client-option implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-06-27 14:41:32,038 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_13 --client-option join_use_nulls=1 join_algorithm='partial_merge' group_by_use_nulls=1 ignore_drop_queries_probability=0.5 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-06-27 14:41:32,539 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 ignore_drop_queries_probability=0.5 --global_time_limit=1200 ' 2025-06-27 14:41:33,041 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.5 --global_time_limit=1200 ' 2025-06-27 14:41:33,542 Will wait functests to finish 2025-06-27 14:41:33,542 Finished 7 from 16 processes 2025-06-27 14:41:38,546 Finished 7 from 16 processes 2025-06-27 14:41:43,550 Finished 7 from 16 processes 2025-06-27 14:41:48,555 Finished 7 from 16 processes 2025-06-27 14:41:53,558 Finished 7 from 16 processes 2025-06-27 14:41:58,562 Finished 7 from 16 processes 2025-06-27 14:42:03,566 Finished 7 from 16 processes 2025-06-27 14:42:08,570 Finished 7 from 16 processes 2025-06-27 14:42:13,574 Finished 7 from 16 processes 2025-06-27 14:42:18,579 Finished 7 from 16 processes 2025-06-27 14:42:23,582 Finished 7 from 16 processes 2025-06-27 14:42:28,583 Finished 7 from 16 processes 2025-06-27 14:42:33,586 Finished 7 from 16 processes 2025-06-27 14:42:38,590 Finished 7 from 16 processes 2025-06-27 14:42:43,594 Finished 7 from 16 processes 2025-06-27 14:42:48,598 Finished 7 from 16 processes 2025-06-27 14:42:53,602 Finished 7 from 16 processes 2025-06-27 14:42:58,606 Finished 7 from 16 processes 2025-06-27 14:43:03,610 Finished 7 from 16 processes 2025-06-27 14:43:08,614 Finished 8 from 16 processes 2025-06-27 14:43:13,618 Finished 8 from 16 processes 2025-06-27 14:43:18,622 Finished 8 from 16 processes 2025-06-27 14:43:23,627 Finished 9 from 16 processes 2025-06-27 14:43:28,630 Finished 9 from 16 processes 2025-06-27 14:43:33,634 Finished 9 from 16 processes 2025-06-27 14:43:38,639 Finished 9 from 16 processes 2025-06-27 14:43:43,642 Finished 9 from 16 processes 2025-06-27 14:43:48,646 Finished 9 from 16 processes 2025-06-27 14:43:53,650 Finished 9 from 16 processes 2025-06-27 14:43:58,654 Finished 9 from 16 processes 2025-06-27 14:44:03,658 Finished 9 from 16 processes 2025-06-27 14:44:08,662 Finished 9 from 16 processes 2025-06-27 14:44:13,666 Finished 9 from 16 processes 2025-06-27 14:44:18,671 Finished 9 from 16 processes 2025-06-27 14:44:23,674 Finished 9 from 16 processes 2025-06-27 14:44:28,678 Finished 9 from 16 processes 2025-06-27 14:44:33,682 Finished 9 from 16 processes 2025-06-27 14:44:38,686 Finished 9 from 16 processes 2025-06-27 14:44:43,690 Finished 9 from 16 processes 2025-06-27 14:44:48,694 Finished 9 from 16 processes 2025-06-27 14:44:53,698 Finished 9 from 16 processes 2025-06-27 14:44:58,702 Finished 9 from 16 processes 2025-06-27 14:45:03,706 Finished 9 from 16 processes 2025-06-27 14:45:08,710 Finished 9 from 16 processes 2025-06-27 14:45:13,714 Finished 9 from 16 processes 2025-06-27 14:45:18,718 Finished 9 from 16 processes 2025-06-27 14:45:23,722 Finished 9 from 16 processes 2025-06-27 14:45:28,726 Finished 9 from 16 processes 2025-06-27 14:45:33,730 Finished 9 from 16 processes 2025-06-27 14:45:38,734 Finished 9 from 16 processes 2025-06-27 14:45:43,738 Finished 9 from 16 processes 2025-06-27 14:45:48,742 Finished 9 from 16 processes 2025-06-27 14:45:53,746 Finished 9 from 16 processes 2025-06-27 14:45:58,751 Finished 9 from 16 processes 2025-06-27 14:46:03,754 Finished 9 from 16 processes 2025-06-27 14:46:08,758 Finished 9 from 16 processes 2025-06-27 14:46:13,762 Finished 9 from 16 processes 2025-06-27 14:46:18,766 Finished 9 from 16 processes 2025-06-27 14:46:23,770 Finished 9 from 16 processes 2025-06-27 14:46:28,774 Finished 9 from 16 processes 2025-06-27 14:46:33,778 Finished 9 from 16 processes 2025-06-27 14:46:38,782 Finished 9 from 16 processes 2025-06-27 14:46:43,786 Finished 9 from 16 processes 2025-06-27 14:46:48,790 Finished 9 from 16 processes 2025-06-27 14:46:53,794 Finished 9 from 16 processes 2025-06-27 14:46:58,798 Finished 9 from 16 processes 2025-06-27 14:47:03,802 Finished 9 from 16 processes 2025-06-27 14:47:08,806 Finished 9 from 16 processes 2025-06-27 14:47:13,810 Finished 9 from 16 processes 2025-06-27 14:47:18,814 Finished 9 from 16 processes 2025-06-27 14:47:23,818 Finished 9 from 16 processes 2025-06-27 14:47:28,821 Finished 9 from 16 processes 2025-06-27 14:47:33,822 Finished 9 from 16 processes 2025-06-27 14:47:38,826 Finished 9 from 16 processes 2025-06-27 14:47:43,830 Finished 9 from 16 processes 2025-06-27 14:47:48,834 Finished 9 from 16 processes 2025-06-27 14:47:53,838 Finished 9 from 16 processes 2025-06-27 14:47:58,842 Finished 9 from 16 processes 2025-06-27 14:48:03,846 Finished 9 from 16 processes 2025-06-27 14:48:08,850 Finished 9 from 16 processes 2025-06-27 14:48:13,854 Finished 9 from 16 processes 2025-06-27 14:48:18,858 Finished 9 from 16 processes 2025-06-27 14:48:23,862 Finished 9 from 16 processes 2025-06-27 14:48:28,866 Finished 9 from 16 processes 2025-06-27 14:48:33,870 Finished 9 from 16 processes 2025-06-27 14:48:38,875 Finished 9 from 16 processes 2025-06-27 14:48:43,878 Finished 9 from 16 processes 2025-06-27 14:48:48,882 Finished 9 from 16 processes 2025-06-27 14:48:53,886 Finished 9 from 16 processes 2025-06-27 14:48:58,890 Finished 9 from 16 processes 2025-06-27 14:49:03,894 Finished 9 from 16 processes 2025-06-27 14:49:08,898 Finished 9 from 16 processes 2025-06-27 14:49:13,902 Finished 9 from 16 processes 2025-06-27 14:49:18,906 Finished 9 from 16 processes 2025-06-27 14:49:23,910 Finished 9 from 16 processes 2025-06-27 14:49:28,914 Finished 9 from 16 processes 2025-06-27 14:49:33,918 Finished 9 from 16 processes 2025-06-27 14:49:38,923 Finished 9 from 16 processes 2025-06-27 14:49:43,926 Finished 9 from 16 processes 2025-06-27 14:49:48,930 Finished 9 from 16 processes 2025-06-27 14:49:53,934 Finished 9 from 16 processes 2025-06-27 14:49:58,938 Finished 9 from 16 processes 2025-06-27 14:50:03,942 Finished 9 from 16 processes 2025-06-27 14:50:08,946 Finished 9 from 16 processes 2025-06-27 14:50:13,950 Finished 9 from 16 processes 2025-06-27 14:50:18,954 Finished 9 from 16 processes 2025-06-27 14:50:23,958 Finished 9 from 16 processes 2025-06-27 14:50:28,962 Finished 9 from 16 processes 2025-06-27 14:50:33,966 Finished 9 from 16 processes 2025-06-27 14:50:38,970 Finished 9 from 16 processes 2025-06-27 14:50:43,974 Finished 9 from 16 processes 2025-06-27 14:50:48,978 Finished 9 from 16 processes 2025-06-27 14:50:53,982 Finished 9 from 16 processes 2025-06-27 14:50:58,986 Finished 9 from 16 processes 2025-06-27 14:51:03,990 Finished 9 from 16 processes 2025-06-27 14:51:08,994 Finished 9 from 16 processes 2025-06-27 14:51:13,998 Finished 9 from 16 processes 2025-06-27 14:51:19,002 Finished 9 from 16 processes 2025-06-27 14:51:24,006 Finished 9 from 16 processes 2025-06-27 14:51:29,010 Finished 9 from 16 processes 2025-06-27 14:51:34,014 Finished 9 from 16 processes 2025-06-27 14:51:39,018 Finished 9 from 16 processes 2025-06-27 14:51:44,022 Finished 9 from 16 processes 2025-06-27 14:51:49,026 Finished 9 from 16 processes 2025-06-27 14:51:54,030 Finished 9 from 16 processes 2025-06-27 14:51:59,034 Finished 9 from 16 processes 2025-06-27 14:52:04,038 Finished 9 from 16 processes 2025-06-27 14:52:09,042 Finished 9 from 16 processes 2025-06-27 14:52:14,046 Finished 9 from 16 processes 2025-06-27 14:52:19,050 Finished 9 from 16 processes 2025-06-27 14:52:24,054 Finished 9 from 16 processes 2025-06-27 14:52:29,058 Finished 9 from 16 processes 2025-06-27 14:52:34,062 Finished 9 from 16 processes 2025-06-27 14:52:39,066 Finished 9 from 16 processes 2025-06-27 14:52:44,070 Finished 9 from 16 processes 2025-06-27 14:52:49,074 Finished 9 from 16 processes 2025-06-27 14:52:54,078 Finished 9 from 16 processes 2025-06-27 14:52:59,082 Finished 9 from 16 processes 2025-06-27 14:53:04,086 Finished 9 from 16 processes 2025-06-27 14:53:09,090 Finished 9 from 16 processes 2025-06-27 14:53:14,094 Finished 10 from 16 processes 2025-06-27 14:53:19,098 Finished 10 from 16 processes 2025-06-27 14:53:24,102 Finished 10 from 16 processes 2025-06-27 14:53:29,106 Finished 10 from 16 processes 2025-06-27 14:53:34,110 Finished 10 from 16 processes 2025-06-27 14:53:39,114 Finished 10 from 16 processes 2025-06-27 14:53:44,118 Finished 10 from 16 processes 2025-06-27 14:53:49,122 Finished 10 from 16 processes 2025-06-27 14:53:54,126 Finished 10 from 16 processes 2025-06-27 14:53:59,130 Finished 10 from 16 processes 2025-06-27 14:54:04,135 Finished 10 from 16 processes 2025-06-27 14:54:09,138 Finished 10 from 16 processes 2025-06-27 14:54:14,143 Finished 10 from 16 processes 2025-06-27 14:54:19,146 Finished 10 from 16 processes 2025-06-27 14:54:24,150 Finished 10 from 16 processes 2025-06-27 14:54:29,154 Finished 10 from 16 processes 2025-06-27 14:54:34,158 Finished 10 from 16 processes 2025-06-27 14:54:39,162 Finished 10 from 16 processes 2025-06-27 14:54:44,166 Finished 10 from 16 processes 2025-06-27 14:54:49,170 Finished 10 from 16 processes 2025-06-27 14:54:54,172 Finished 10 from 16 processes 2025-06-27 14:54:59,174 Finished 10 from 16 processes 2025-06-27 14:55:04,178 Finished 10 from 16 processes 2025-06-27 14:55:09,182 Finished 10 from 16 processes 2025-06-27 14:55:14,186 Finished 10 from 16 processes 2025-06-27 14:55:19,190 Finished 10 from 16 processes 2025-06-27 14:55:24,194 Finished 10 from 16 processes 2025-06-27 14:55:29,198 Finished 10 from 16 processes 2025-06-27 14:55:34,202 Finished 10 from 16 processes 2025-06-27 14:55:39,206 Finished 10 from 16 processes 2025-06-27 14:55:44,210 Finished 10 from 16 processes 2025-06-27 14:55:49,215 Finished 10 from 16 processes 2025-06-27 14:55:54,218 Finished 10 from 16 processes 2025-06-27 14:55:59,222 Finished 10 from 16 processes 2025-06-27 14:56:04,226 Finished 10 from 16 processes 2025-06-27 14:56:09,230 Finished 10 from 16 processes 2025-06-27 14:56:14,234 Finished 10 from 16 processes 2025-06-27 14:56:19,238 Finished 10 from 16 processes 2025-06-27 14:56:24,242 Finished 10 from 16 processes 2025-06-27 14:56:29,247 Finished 10 from 16 processes 2025-06-27 14:56:34,250 Finished 10 from 16 processes 2025-06-27 14:56:39,254 Finished 10 from 16 processes 2025-06-27 14:56:44,258 Finished 10 from 16 processes 2025-06-27 14:56:49,262 Finished 10 from 16 processes 2025-06-27 14:56:54,267 Finished 10 from 16 processes 2025-06-27 14:56:59,273 Finished 10 from 16 processes 2025-06-27 14:57:04,276 Finished 10 from 16 processes 2025-06-27 14:57:09,282 Finished 10 from 16 processes 2025-06-27 14:57:14,286 Finished 10 from 16 processes 2025-06-27 14:57:19,290 Finished 10 from 16 processes 2025-06-27 14:57:24,294 Finished 10 from 16 processes 2025-06-27 14:57:29,298 Finished 10 from 16 processes 2025-06-27 14:57:34,303 Finished 10 from 16 processes 2025-06-27 14:57:39,306 Finished 10 from 16 processes 2025-06-27 14:57:44,310 Finished 10 from 16 processes 2025-06-27 14:57:49,314 Finished 10 from 16 processes 2025-06-27 14:57:54,318 Finished 10 from 16 processes 2025-06-27 14:57:59,322 Finished 10 from 16 processes 2025-06-27 14:58:04,323 Finished 10 from 16 processes 2025-06-27 14:58:09,326 Finished 10 from 16 processes 2025-06-27 14:58:14,330 Finished 10 from 16 processes 2025-06-27 14:58:19,334 Finished 10 from 16 processes 2025-06-27 14:58:24,338 Finished 10 from 16 processes 2025-06-27 14:58:29,342 Finished 10 from 16 processes 2025-06-27 14:58:34,346 Finished 10 from 16 processes 2025-06-27 14:58:39,350 Finished 10 from 16 processes 2025-06-27 14:58:44,351 Finished 10 from 16 processes 2025-06-27 14:58:49,354 Finished 10 from 16 processes 2025-06-27 14:58:54,358 Finished 10 from 16 processes 2025-06-27 14:58:59,362 Finished 10 from 16 processes 2025-06-27 14:59:04,366 Finished 10 from 16 processes 2025-06-27 14:59:09,371 Finished 10 from 16 processes 2025-06-27 14:59:14,374 Finished 10 from 16 processes 2025-06-27 14:59:19,379 Finished 10 from 16 processes 2025-06-27 14:59:24,382 Finished 10 from 16 processes 2025-06-27 14:59:29,386 Finished 10 from 16 processes 2025-06-27 14:59:34,390 Finished 10 from 16 processes 2025-06-27 14:59:39,394 Finished 10 from 16 processes 2025-06-27 14:59:44,398 Finished 10 from 16 processes 2025-06-27 14:59:49,402 Finished 10 from 16 processes 2025-06-27 14:59:54,406 Finished 10 from 16 processes 2025-06-27 14:59:59,410 Finished 10 from 16 processes 2025-06-27 15:00:04,414 Finished 10 from 16 processes 2025-06-27 15:00:09,418 Finished 10 from 16 processes 2025-06-27 15:00:14,422 Finished 10 from 16 processes 2025-06-27 15:00:19,426 Finished 10 from 16 processes 2025-06-27 15:00:24,430 Finished 10 from 16 processes 2025-06-27 15:00:29,434 Finished 10 from 16 processes 2025-06-27 15:00:34,438 Finished 10 from 16 processes 2025-06-27 15:00:39,442 Finished 10 from 16 processes 2025-06-27 15:00:44,446 Finished 10 from 16 processes 2025-06-27 15:00:49,450 Finished 10 from 16 processes 2025-06-27 15:00:54,454 Finished 10 from 16 processes 2025-06-27 15:00:59,458 Finished 10 from 16 processes 2025-06-27 15:01:04,462 Finished 10 from 16 processes 2025-06-27 15:01:09,466 Finished 10 from 16 processes 2025-06-27 15:01:14,470 Finished 10 from 16 processes 2025-06-27 15:01:19,475 Finished 10 from 16 processes 2025-06-27 15:01:24,478 Finished 10 from 16 processes 2025-06-27 15:01:29,482 Finished 11 from 16 processes 2025-06-27 15:01:34,486 Finished 11 from 16 processes 2025-06-27 15:01:39,490 Finished 13 from 16 processes 2025-06-27 15:01:44,495 Finished 13 from 16 processes 2025-06-27 15:01:49,498 Finished 13 from 16 processes 2025-06-27 15:01:54,502 Finished 13 from 16 processes 2025-06-27 15:01:59,506 Finished 13 from 16 processes 2025-06-27 15:02:04,510 Finished 13 from 16 processes 2025-06-27 15:02:09,514 Finished 13 from 16 processes 2025-06-27 15:02:14,518 Finished 14 from 16 processes 2025-06-27 15:02:19,522 Finished 14 from 16 processes 2025-06-27 15:02:24,526 Finished 14 from 16 processes 2025-06-27 15:02:29,530 Finished 15 from 16 processes 2025-06-27 15:02:34,535 Finished 15 from 16 processes 2025-06-27 15:02:39,538 Finished 15 from 16 processes 2025-06-27 15:02:44,543 All processes finished 2025-06-27 15:02:44,543 Compressing stress logs 2025-06-27 15:02:44,571 Logs compressed 2025-06-27 15:02:44,571 Will terminate gdb (if any) 2025-06-27 15:02:44,571 Running command: kill -TERM $(pidof gdb) /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-06-27 15:02:44,579 Command returend 2, retrying /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-06-27 15:02:44,583 Command returend 2, retrying /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-06-27 15:02:45,588 Command returend 2, retrying /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-06-27 15:02:47,594 Command returend 2, retrying /bin/sh: 1: kill: Usage: kill [-s sigspec | -signum | -sigspec] [pid | job]... or kill -l [exitstatus] 2025-06-27 15:02:50,600 Command returend 2, retrying 2025-06-27 15:02:54,604 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-06-27 15:02:54,612 Running command: kill -CONT $(cat /var/run/clickhouse-server/clickhouse-server.pid) && clickhouse client -q 'SELECT 1 FORMAT Null' 2025-06-27 15:02:54,877 Running command: clickhouse client -q "SYSTEM STOP THREAD FUZZER" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-06-27 15:02:55,142 Running command: clickhouse client -q "SYSTEM START MERGES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-06-27 15:02:55,407 Running command: clickhouse client -q "SYSTEM START DISTRIBUTED SENDS" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-06-27 15:02:55,622 Running command: clickhouse client -q "SYSTEM START TTL MERGES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-06-27 15:02:55,837 Running command: clickhouse client -q "SYSTEM START MOVES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-06-27 15:02:56,002 Running command: clickhouse client -q "SYSTEM START FETCHES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-06-27 15:02:56,167 Running command: clickhouse client -q "SYSTEM START REPLICATED SENDS" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-06-27 15:02:56,382 Running command: clickhouse client -q "SYSTEM START REPLICATION QUEUES" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-06-27 15:02:56,596 Running command: clickhouse client -q "SYSTEM DROP MARK CACHE" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-06-27 15:02:56,811 Running command: clickhouse client -q "KILL QUERY WHERE upper(query) LIKE 'WATCH %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-06-27 15:02:56,976 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'insert into tableB select %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-06-27 15:02:57,140 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'SELECT URL, uniq(SearchPhrase) AS u FROM test.hits GROUP BY URL ORDER BY u %'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 2025-06-27 15:02:57,305 Running command: clickhouse client -q "KILL QUERY WHERE query LIKE 'SELECT (SELECT number FROM system.numbers WHERE number = 1000000000000)%'" --max_untracked_memory=1Gi --memory_profiler_step=1Gi --max_memory_usage_for_user=0 --max_memory_usage_in_client=1000000000 Received exception from server (version 24.8.14): Code: 159. DB::Exception: Received from localhost:9000. DB::Exception: Timeout exceeded: elapsed 60.073054689 seconds, maximum: 60. (TIMEOUT_EXCEEDED) (query: SELECT sleepEachRow(( SELECT maxOrDefault(300 - elapsed) + 1 FROM system.processes WHERE query NOT LIKE '%FROM system.processes%' AND elapsed < 300 ) / 300) FROM numbers(300) FORMAT Null SETTINGS function_sleep_max_microseconds_per_block = 0 ) 2025-06-27 15:03:58,553 Checking if some queries hung Using queries from '/usr/share/clickhouse-test/queries' directory Connecting to ClickHouse server... OK Connected to server 24.8.14.10501.altinitytest @ d1f73c287081665b9e9ca2767a633a3cc8a41f08 HEAD Running 1 stateless tests (MainProcess). 00001_select_1: [ OK ] 1 tests passed. 0 tests skipped. 0.38 s elapsed (MainProcess). Won't run stateful tests because test data wasn't loaded. Checking the hung queries: done No queries hung. All tests have finished. Top patterns of log messages: count count_% size size_% uniq_loggers uniq_threads levels background_% message_format_string 1. 15292 0.062 2.72 MiB 0.045 1 107 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 2. 15137 0.061 2.27 MiB 0.038 7038 106 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 3. 12811 0.052 1.30 MiB 0.021 1 78 ['Trace'] 0.19 Checking existence of path: {} 4. 11642 0.047 328.55 KiB 0.005 1 97 ['Debug'] 0.056 Processed in {} sec. 5. 7479 0.03 178.44 KiB 0.003 1 140 ['Trace'] 0.005 Query to stage {}{} 6. 7439 0.03 352.56 KiB 0.006 1 140 ['Trace'] 0.005 Query from stage {} to stage {}{} 7. 7096 0.029 353.04 KiB 0.006 7096 120 ['Debug'] 0.998 Authenticating user '{}' from {} 8. 7081 0.029 795.23 KiB 0.013 7081 120 ['Debug'] 0.998 {} Authenticated with global context as user {} 9. 7063 0.029 620.77 KiB 0.01 7063 119 ['Debug'] 0.998 {} Logout, user_id: {} 10. 7055 0.029 516.72 KiB 0.008 7055 106 ['Debug'] 1 Creating session context with user_id: {} 11. 6823 0.028 305.33 KiB 0.005 1 3 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 12. 6180 0.025 491.50 KiB 0.008 1 96 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 13. 5466 0.022 13.69 MiB 0.227 5 512 ['Error'] 1 Table is in readonly mode (replica path: {}) 14. 4296 0.017 302.23 KiB 0.005 1 590 ['Trace'] 0.755 Reserved {} on local disk {}, having unreserved {}. 15. 4132 0.017 196.75 KiB 0.003 1 172 ['Trace'] 0.567 filled checksums {} 16. 4124 0.017 489.38 KiB 0.008 189 165 ['Trace'] 0.568 Renaming temporary part {} to {} with tid {}. 17. 4122 0.017 285.91 KiB 0.005 190 568 ['Trace'] 0.756 Trying to reserve {} using storage policy from min volume index {} 18. 3806 0.015 123.99 KiB 0.002 1 99 ['Trace'] 1 TCP Request. Address: {} 19. 3806 0.015 354.27 KiB 0.006 1 99 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 20. 3779 0.015 99.64 KiB 0.002 1 98 ['Debug'] 1 Done processing connection. 21. 3676 0.015 345.10 KiB 0.006 1 39 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 22. 3271 0.013 572.50 KiB 0.009 3 90 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {} 23. 3267 0.013 6.88 MiB 0.114 2 90 ['Trace'] 1 Request URI: {} 24. 3093 0.013 63.43 KiB 0.001 2 90 ['Debug'] 0.001 Done processing query 25. 2340 0.01 134.57 KiB 0.002 17 38 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 26. 2339 0.009 83.21 KiB 0.001 17 38 ['Trace'] 1 Flushed system log up to offset {} 27. 2200 0.009 747.02 KiB 0.012 2 5 ['Error'] 0 Number of arguments for function {} doesn't match: passed {}, should be {} 28. 2135 0.009 115.62 KiB 0.002 1 89 ['Debug'] 0.392 Peak memory usage{}: {}. 29. 2121 0.009 248.67 KiB 0.004 1 21 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 30. 2068 0.008 123.19 KiB 0.002 282 112 ['Debug'] 0.166 There are {} detached tables. Start searching non used tables. 31. 2068 0.008 86.84 KiB 0.001 282 112 ['Debug'] 0.166 Found {} non used tables in detached tables. 32. 1804 0.007 63.42 KiB 0.001 1 14 ['Trace'] 1 Keeper request. Address: {} 33. 1786 0.007 288.65 KiB 0.005 1 70 ['Trace'] 0 No query result found for query {} 34. 1786 0.007 125.81 KiB 0.002 1 324 ['Trace'] 0.241 Rolling back transaction {}{} 35. 1730 0.007 6.84 MiB 0.113 2 21 ['Error'] 0 Table {} doesn't exist 36. 1664 0.007 52.00 KiB 0.001 1 11 ['Debug'] 1 Receive four letter command {} 37. 1584 0.006 162.03 KiB 0.003 1 7 ['Trace'] 0.5 Adding file: {}, size: {} 38. 1476 0.006 113.87 KiB 0.002 1 93 ['Trace'] 0 Query span trace_id for opentelemetry log: {} 39. 1431 0.006 174.18 KiB 0.003 1 6 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 40. 1298 0.005 106.24 KiB 0.002 120 64 ['Trace'] 0.005 Reading {} ranges in{}order from part {}, approx. {} rows starting from {} 41. 1204 0.005 107.98 KiB 0.002 1 91 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 42. 1114 0.005 33.32 KiB 0.001 1 86 ['Trace'] 0 Aggregation method: {} 43. 997 0.004 132.67 KiB 0.002 1 45 ['Trace'] 0 Stored query result of query {} 44. 981 0.004 28.74 KiB 0 33 23 ['Trace'] 1 Checking task {} 45. 967 0.004 85.19 KiB 0.001 32 22 ['Debug'] 1 Will not execute task {}: {} 46. 871 0.004 13.61 KiB 0 33 25 ['Debug'] 1 Scheduling tasks 47. 867 0.004 21.17 KiB 0 33 25 ['Debug'] 1 Waiting for queue updates 48. 867 0.004 197.97 KiB 0.003 33 25 ['Trace'] 1 scheduleTasks: initialized={}, size_before_filtering={}, queue_size={}, entries={}..{}, first_failed_task_name={}, current_tasks_size={}, last_current_task={}, last_skipped_entry_name={} 49. 862 0.004 43.78 KiB 0.001 33 23 ['Debug'] 1 Will schedule {} tasks starting from {} 50. 834 0.003 115.15 KiB 0.002 3 42 ['Debug'] 0 Proposing query: {} 51. 833 0.003 58.57 KiB 0.001 3 42 ['Debug'] 0 Waiting for worker thread to process all entries before {} 52. 827 0.003 159.83 KiB 0.003 4 43 ['Debug'] 0.017 Processing task {} (query: {}, backup restore: {}) 53. 827 0.003 121.07 KiB 0.002 4 43 ['Debug'] 0.017 Executing query: {} 54. 823 0.003 18.49 KiB 0 1 90 ['Trace'] 0 Merging aggregated data 55. 813 0.003 73.08 KiB 0.001 3 3 ['Trace'] 1 Waiting for initiator {} to commit or rollback entry {} 56. 790 0.003 42.18 KiB 0.001 42 435 ['Debug'] 0.978 Selected {} parts from {} to {} 57. 787 0.003 65.10 KiB 0.001 1 41 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {} 58. 787 0.003 26.88 KiB 0 1 41 ['Debug'] 0 Selected MergeAlgorithm: {} 59. 784 0.003 32.92 KiB 0.001 4 4 ['Trace'] 1 Too early to clean queue, will do it later. 60. 753 0.003 98.71 KiB 0.002 1 38 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec. 61. 753 0.003 49.20 KiB 0.001 42 40 ['Trace'] 0 Merged {} parts: [{}, {}] -> {} 62. 683 0.003 19.36 KiB 0 1 134 ['Debug'] 1 Stop worker in {} 63. 683 0.003 26.71 KiB 0 1 127 ['Debug'] 0.584 Spawn loader worker #{} in {} 64. 682 0.003 46.69 KiB 0.001 1 112 ['Debug'] 1 Finish load job '{}' with status {} 65. 682 0.003 51.37 KiB 0.001 1 47 ['Debug'] 0.116 Schedule load job '{}' into {} 66. 682 0.003 49.37 KiB 0.001 1 112 ['Debug'] 1 Execute load job '{}' in {} 67. 673 0.003 61.90 KiB 0.001 1 48 ['Debug'] 0.077 Prioritize load job '{}': {} -> {} 68. 670 0.003 1.76 MiB 0.029 2 51 ['Error'] 0.979 Setting {} should not be changed 69. 665 0.003 20.24 KiB 0 138 71 ['Debug'] 0.011 Key condition: {} 70. 656 0.003 28.83 KiB 0 137 71 ['Trace'] 0.011 Filtering marks by primary and secondary keys 71. 637 0.003 6.84 KiB 0 1 76 ['Trace'] 0 Aggregating 72. 633 0.003 73.43 KiB 0.001 96 55 ['Debug'] 0.984 Removing {} parts from filesystem (serially): Parts: [{}] 73. 620 0.003 19.31 KiB 0 20 12 ['Debug'] 0 Requested flush up to offset {} 74. 618 0.003 35.78 KiB 0.001 2 14 ['Trace'] 0.977 Loading config file '{}'. 75. 608 0.002 58.03 KiB 0.001 33 60 ['Trace'] 0.985 Found {} old parts to remove. Parts: [{}] 76. 598 0.002 57.23 KiB 0.001 32 51 ['Debug'] 0.985 Removing {} parts from memory: Parts: [{}] 77. 596 0.002 68.61 KiB 0.001 135 70 ['Debug'] 0.012 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 78. 591 0.002 19.61 KiB 0 1 130 ['Debug'] 0.521 Change current priority: {} -> {} 79. 576 0.002 5.06 KiB 0 2 47 ['Trace'] 0.014 No tables 80. 555 0.002 44.85 KiB 0.001 1 73 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 81. 551 0.002 28.52 KiB 0 120 68 ['Trace'] 0.013 Spreading mark ranges among streams (default reading) 82. 468 0.002 1.79 MiB 0.03 16 70 ['Error'] 0.113 Cannot schedule a task: {} (threads={}, jobs={}) 83. 384 0.002 12.52 KiB 0 21 76 ['Trace'] 0 Found {} range {}in {} steps 84. 384 0.002 11.01 KiB 0 21 76 ['Trace'] 0 Found (LEFT) boundary mark: {} 85. 384 0.002 25.89 KiB 0 21 76 ['Trace'] 0 Running binary search on index range for part {} ({} marks) 86. 384 0.002 11.39 KiB 0 21 76 ['Trace'] 0 Found (RIGHT) boundary mark: {} 87. 383 0.002 15.20 KiB 0 46 55 ['Debug'] 0 MinMax index condition: {} 88. 382 0.002 78.80 KiB 0.001 1 29 ['Trace'] 0 PREWHERE condition was split into {} steps: {} 89. 370 0.002 15.90 KiB 0 1 3 ['Information'] 1 {} for session {} took {} ms 90. 344 0.001 967.22 KiB 0.016 2 18 ['Error'] 0 Table {}.{} does not exist 91. 334 0.001 26.60 KiB 0 1 83 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={} 92. 319 0.001 23.70 KiB 0 1 28 ['Trace'] 0 Condition {} moved to PREWHERE 93. 313 0.001 33.69 KiB 0.001 8 49 ['Trace'] 0.882 List of all grants including implicit: {} 94. 313 0.001 23.84 KiB 0 8 49 ['Trace'] 0.882 Settings: readonly = {}, allow_ddl = {}, allow_introspection_functions = {} 95. 313 0.001 16.83 KiB 0 8 49 ['Trace'] 0.882 List of all grants: {} 96. 303 0.001 5.33 KiB 0 272 87 ['Debug'] 0.155 Loading data parts 97. 294 0.001 23.97 KiB 0 285 47 ['Information'] 0.034 Metadata processed, database {} has {} tables and {} dictionaries in total. 98. 290 0.001 17.25 KiB 0 1 47 ['Information'] 0.021 Parsed metadata of {} tables in {} databases in {} sec 99. 287 0.001 1.43 MiB 0.024 3 38 ['Error'] 0.021 Limit for {} exceeded, max bytes: {}, current bytes: {} 100. 282 0.001 32.50 KiB 0.001 1 42 ['Debug'] 0 Done waiting for the table {} to be dropped. The outcome: {} 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. 18 CodeDBExceptionReceivedfromDBExc Code: 439. DB::Exception: Received from 127.0.0.2:9000. DB::Exception: Cannot schedule a task: fault injected (threads=8, jobs=1): While executing MergeTreeSelect(pool: ReadPoolInOrder, algorithm: InOrder). Stack trace: 0. ./contrib/llvm-project/libcxx/in ('/executeQuery.cpp',221) 2. 14 CodeDBExceptionSyntaxerrorfailed Code: 62. DB::Exception: Syntax error: failed at position 17 ('0.015234'): 0.015234. Expected one of: token sequence, Dot, token, OR, AND, IS NOT DISTINCT FROM, IS NULL, IS NOT NULL, BETWEEN, NOT BETWEEN, LIKE, ILIKE, NOT LIKE, NOT ILIKE, REGEXP, IN, NOT I ('/executeQuery.cpp',221) 3. 4 voidDBStorageReplicatedMergeTree void DB::StorageReplicatedMergeTree::mutationsUpdatingTask(): Code: 999. Coordination::Exception: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below): 0. ./contrib/llvm-project/libcxx/include/except ('/Exception.cpp',273) 4. 3 Connectiontomysqlfailedtimes Connection to mysql failed 1 times ('',0) 5. 3 startingup starting up ('',0) 6. 3 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',43) 7. 3 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',43) 8. 3 StartingClickHousealtinitytestre Starting ClickHouse 24.8.14.10501.altinitytest (revision: 4294967295, git hash: d1f73c287081665b9e9ca2767a633a3cc8a41f08, build id: A1F1F5FEFE9DA3CD010E37349FC2A167626623A0), PID 407 ('',0) 9. 3 newconfigurationlogidxprevlogidx new configuration: log idx 1, prev log idx 0 peer 1, DC ID 0, localhost:9234, voting member, 1 my id: 1, leader: 1, term: 1 ('/LoggerWrapper.h',43) 10. 3 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 11. 3 ConnectiontosystemasuserMYSQLUSE Connection to system@127.0.0.1:9004 as user 02833_MYSQL_USER_8151 failed: mysqlxx::ConnectionFailed: 02833_MYSQL_USER_8151: Authentication failed: password is incorrect, or there is no user with such name. ((nullptr):9004) ('',0) 12. 3 statemachinecommitindexprecommit state machine commit index 0, precommit index 0, last log index 0 ('/LoggerWrapper.h',43) 13. 3 Forkedachildprocesstowatch Forked a child process to watch ('',0) 14. 3 INITRAFTSERVERcommitindextermele === INIT RAFT SERVER === commit index 0 term 0 election timer allowed log store start 1, end 0 config log idx 0, prev log idx 0 -- ASYNC REPLICATION -- ('/LoggerWrapper.h',43) 15. 3 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 0 ('/LoggerWrapper.h',43) 16. 3 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1 my id: 1, voting_member num peers: 0 ('/LoggerWrapper.h',43) 17. 3 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',43) 18. 3 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 19. 3 RaftASIOlistenerinitiatedonunsec Raft ASIO listener initiated on :::9234, unsecured ('/LoggerWrapper.h',43) 20. 3 PRIORITYdecaytargetmine [PRIORITY] decay, target 1 -> 1, mine 1 ('/LoggerWrapper.h',43) 21. 3 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 1 ('/LoggerWrapper.h',43) 22. 3 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',43) 23. 3 ELECTIONTIMEOUTcurrentrolefollow [ELECTION TIMEOUT] current role: follower, log last term 0, state term 0, target p 1, my p 1, hb dead, pre-vote NOT done ('/LoggerWrapper.h',43) 24. 3 DBExceptionMYSQLUSERAuthenticati DB::Exception: 02833_MYSQL_USER_8151: Authentication failed: password is incorrect, or there is no user with such name. ('',0) 25. 3 newelectiontimeoutrange new election timeout range: 0 - 0 ('/LoggerWrapper.h',43) 26. 3 newconfiglogidxprevlogidxcurconf new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0 ('/LoggerWrapper.h',43) 27. 3 numberofpendingcommitelements number of pending commit elements: 0 ('/LoggerWrapper.h',43) 28. 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) 29. 3 parameterselectiontimeoutrangehe parameters: election timeout range 0 - 0, heartbeat 0, leadership expiry 0, max batch 100, backoff 50, snapshot distance 10000, enable randomized snapshot creation NO, log sync stop gap 99999, reserved logs 2147483647, client timeout 10000, auto forwarding ('/LoggerWrapper.h',43) 30. 2 prevotetermisdifferentresetitto pre-vote term (0) is different, reset it to 1 ('/LoggerWrapper.h',43) Top messages not matching their format strings: message_format_string count() any_message 1. 77 Forked a child process to watch 2. {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 5 /var/lib/clickhouse/store/3e2/3e24d72c-a7fb-41bb-a9c6-ca59975176b7/tmp_insert_201403_11_11_0/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 6 similar messages) 3. (from {}{}{}){}{} {} (stage: {}) 1 (from [::1]:33200) (comment: 02686_bson3.sql) -- It correctly throws exception about incorrect data: SELECT * FROM format(BSONEachRow, 'WatchID Int64, JavaEnable Int16, Title String, GoodEvent Int16, EventTime DateTime, EventDate Date, CounterID Int32, ClientIP Int32, RegionID Int32, UserID Int64, CounterClass Int16, OS Int16, UserAgent Int16, URL String, Referer String, IsRefresh Int16, RefererCategoryID Int16, RefererRegionID Int32, URLCategoryID Int16, URLRegionID Int32, ResolutionWidth Int16, ResolutionHeight Int16, ResolutionDepth Int16, FlashMajor Int16, FlashMinor Int16, FlashMinor2 String, NetMajor Int16, NetMinor Int16, UserAgentMajor Int16, UserAgentMinor String, CookieEnable Int16, JavascriptEnable Int16, IsMobile Int16, MobilePhone Int16, MobilePhoneModel String, Params String, IPNetworkID Int32, TraficSourceID Int16, SearchEngineID Int16, SearchPhrase String, AdvEngineID Int16, IsArtifical Int16, WindowClientWidth Int16, WindowClientHeight Int16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 Int16, SilverlightVersion2 Int16, SilverlightVersion3 Int32, SilverlightVersion4 Int16, PageCharset String, CodeVersion Int32, IsLink Int16, IsDownload Int16, IsNotBounce Int16, FUniqID Int64, OriginalURL String, HID Int32, IsOldCounter Int16, IsEvent Int16, IsParameter Int16, DontCountHits Int16, WithHash Int16, HitColor String, LocalEventTime DateTime, Age Int16, Sex Int16, Income Int16, Interests Int16, Robotness Int16, RemoteIP Int32, WindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage String, BrowserCountry String, SocialNetwork String, SocialAction String, HTTPError Int16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, FetchTiming Int32, SocialSourceNetworkID Int16, SocialSourcePage String, ParamPrice Int64, ParamOrderID String, ParamCurrency String, ParamCurrencyID Int16, OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID Int16, RefererHash Int64, URLHash Int64, CLID Int32', $$^WatchIDc*5/ !p~JavaEnableTitleGoodEventEventTime7�QEventDate>CounterIDClientIP�z�RegionIDGUserID� �:6�CounterClassOSUserAgentURLRefererIsRefreshRefererCategoryIDRefererRegionIDURLCategoryIDURLRegionIDResolutionWidthResolutionHeightResolutionDepthFlashMajorFlashMinorFlashMinor2NetMajorNetMinorUserAgentMajorUserAgentMinor�OCookieEnableJavascriptEnabl�sMobileMobilePhoneMobilePhoneModelParamsIPNetworkID�9TraficSourceIDSearchEngineIDSearchPhraseAdvEngineIDIsArtificalWindowClientWidthWindowClientHeightClientTimeZone�ClientEventTime�SilverlightVersion1SilverlightVersion2SilverlightVersion3SilverlightVersion4PageCharsetCodeVersionIsLinkIsDownloadIsNotBounceFUniqIDOriginalURLHIDIsOldCounterIsEventIsParameterDontCountHitsWithHashHitColor5LocalEventTime&�QAgeSexIncomeInterestsRobotnessRemoteIP^DI�WindowName�OpenerName�HistoryLength�BrowserLanguage�BrowserCountry� SocialNetworkSocialActionHTTPErrorSendTimingDNSTimingConnectTimingResponseStartTimingResponseEndTimingFetchTimingSocialSourceNetworkIDSocialSourcePageParamPriceParamOrderIDParamCurrencyNHParamCurrencyIDOpenstatServiceNameOpenstatCampaignIDOpenstatAdIDOpenstatSourceIDUTMSourceUTMMediumUTMCampaignUTMContentUTMTermFromTagHasGCLIDRefererHashX+�'�URLHash�|3�b.�CLID^WatchID�F�ӓ2qJavaEnableTitleGoodEventEventTimen$�QEventDate>CounterIDClientIP�z�RegionIDGUserID� �:6�CounterClassOSUserAgentURLRefererIsRefreshRefererCategoryIDRefererRegionIDURLCategoryIDURLRegionIDResolutionWidthResolutionHeightResolutionDepthFlashMajorFlashMinorFlashMinor2NetMajorNetMinorUserAgentMajorUserAgentMinor�OCookieEnableJavascriptEnableIsMobileMobilePhoneMobilePhoneModelParamsIPNetworkID�9TraficSourceIDSearchEngineIDSearchPhraseAdvEngineIDIsArtificalWindowClientWidthWindowClientHeightClientTimeZone�ClientEventTime�SilverlightVersion1SilverlightVersion2SilverlightVersion3SilverlightVersion4PageCharsetCodeVersionIsLinkIsDownloadIsNotBounceFUniqIDOriginalURLHIDIsOldCounterIsEventIsParameterDontCountHitsWithHashHitColor5LocalEventTimeǘ�QAgeSexIncomeInterestsRobotnessRemoteIP^DI�WindowName�OpenerName�HistoryLength�BrowserLanguage�BrowserCountry� SocialNetworkSocialActionHTTPErrorSendTimingDNSTimingConnectTimingResponseStartTimingResponseEndTimingFetchTimingSocialSourceNetworkIDSocialSourcePageP�amPriceParamOrderIDParamCurrencyNHParamCurrencyIDOpenstatServiceNameOpenstatCampaignIDOpenstatAdIDOpenstatSourceIDUTMSourceUTMMediumUTMCampaignUTMContentUTMTermFromTagHasGCLIDRefererHashX+�'�URLHash�|3�b.�CLID^WatchIDl!�|�@HJavaEnableTitleGoodEventEventTime�)�QEventDate>CounterIDClientIP�z�RegionIDGUserID� �:6�CounterClassOSUserAgentURLRefererIsRefreshRefererCategoryIDRefererRegionIDURLCategoryIDURLRegionIDResolutionWidthResolutionHeightResolutionDepthFlashMajorFlashMinorFlashMinor2NetMajorNetMinorUserAgentMajorUserAgentMinor�OCookieEnableJavascriptEnableIsMobileMobilePhoneMobilePhoneModelParamsIPNetworkID�9TraficSourceIDSearchEngineIDSearchPhraseAdvEngineIDIsArtificalWindowClientWidthWindowClientHeightClientTimeZone�ClientEventTime�SilverlightVersion1SilverlightVersion2SilverlightVersion3SilverlightVersion4PageCharsetCodeVersionIsLinkIsDownloadIsNotBounceFUniqIDOriginalURLHIDIsOldCounterIsEventIsParameterDontCountHitsWithHashHitColor5LocalEventTime}�QAgeSexIncomeInterestsRobotnessRemoteIP^DI�WindowName�OpenerName�HistoryLength�BrowserLanguage�BrowserCountry� SocialNetworkSocialActionHTTPErrorSendTimingDNSTimingConnectTimingResponseStartTimingResponseEndTimingFetchTimingSocialSourceNetworkIDSocialSourcePageParamPriceParamOrderIDParamCurrencyNHParamCurrencyIDOpenstatServiceNameOpenstatCampaignIDOpenstatAdIDOpenstatSourceIDUTMSourceUTMMediumUTMCampaignUTMContentUTMTermFromTagHasGCLIDRefererHashX+�'�URLHash�|3�b.�CLID^WatchID�ǐ=ЌWJavaEnableTitleGoodEventEventTime8*�QEventDate>CounterIDClientIP�z�RegionIDGUserID� �:6�CounterClassOSUserAgentURLRefererIsRefreshRefererCategoryIDRefererRegionIDURLCategoryIDURLRegionIDResolutionWidthResolutionHeightResolutionDepthFlashMajorFlashMinorFlashMinor2NetMajorNetMinorUserAgentMajorUserAgentMinor�OCookieEnableJavascriptEnableIsMobileMobilePhoneMobilePhoneModelParamsIPNetworkID�9TraficSourceIDSearchEngineIDSearchPhraseAdvEngineIDIsArtificalWindowClientWidthWindowClientHeightClientTimeZone�ClientEventTime�SilverlightVersion1SilverlightVersion2SilverlightVersion3SilverlightVersion4PageCharsetCodeVersionIsLinkIsDownloadIsNotBounceFUniqIDOriginalURLHIDIsOldCounterIsEventIsParameterDontCountHitsWithHashHitColor5LocalEventTimeݞ�QAgeSexIncomeInterestsRobotnessRemoteIP^DI�WindowName�OpenerName�HistoryLength�BrowserLanguage�BrowserCountry� SocialNetworkSocialActionHTTPErrorSendTimingDNSTimingConnectTimingResponseStartTimingResponseEndTimingFetchTimingSocialSourceNetworkIDSocialSourcePageParamPriceParamOrderIDParamCurrencyNHParamCurrencyIDOpenstatServiceNameOpenstatCampaignIDOpenstatAdIDOpenstatSourceIDUTMSourceUTMMediumUTMCampaignUTMContentUTMTermFromTagHasGCLIDRefererHashX+�'�URLHash�|3�b.�CLID�WatchID�E&LyJavaEnableTitleGoodEventEventTimeJ�QEventDate>CounterIDClientIP�I`RegionID'UserIDq�Jd8CounterClassOSUserAgentURL-http://holodilnik.ru/russia/05jul2013&model=0RefererIsRefreshRefererCategoryIDRefererRegionIDURLCateParams String, IPNetworkID Int32, TraficSourceID Int16, SearchEngineID Int16, SearchPhrase String, AdvEngineID Int16, IsArtifical Int16, WindowClientWidth Int16, WindowClientHeight Int16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 Int16, SilverlightVersion2 Int16, SilverlightVersion3 Int32, SilverlightVersion4 Int16, PageCharset String, CodeVersion Int32, IsLink Int16, IsDownload Int16, IsNotBounce Int16, FUniqID Int64, OriginalURL String, HID Int32, IsOldCounter Int16, IsEvent Int16, IsParameter Int16, DontCountHits Int16, WithHash Int16, HitColor String, LocalEventTime DateTime, Age Int16, Sex Int16, Income Int16, Interests Int16, Robotness Int16, RemoteIP Int32, WindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage String, BrowserCountry String, SocialNetwork String, SocialAction String, HTTPError Int16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32,�HistoryLength�BrowserLanguage�BrowserCountry� SocialNetworkSocialActionHTTPErrorSendTimingDNSTimingConnectTimingResponseStartTimingResponseEndTimingFetchTimingSocialSourceNetworkIDSocialSourcePageParamPriceParamOrderIDParamCurrencyNHParamCurrencyIDOpenstatServiceNameOpenstatCampaignIDOpenstatAdIDOpenstatSourceIDUTMSourceUTMMediumUTMCampaignUTMContentUTMTermFromTagHasGCLIDRefererHashX+�'�URLHash� o�eCLID�WatchID�k=�pJavaEnableTitleGoodEventEventTime� �QEventDate>CounterIDClien�Q9�HRegionIDGUserID �Ks}�CounterClassOSUserAgentURLHhttp://afisha.mail.ru/catalog/314/women.ru/ency=1&page3/?errovat-pinnikiRefererIsRefreshRefererCategoryIDRefererRegionIDURLCategoryID0=URLRegionID�ResolutionWidthResolutionHeightResolutionDepthFlashMajorFlashMinorFlashMinor2NetMajorNetMinorUserAgentMajorUserAgentMinorD�CookieEnableJavascriptEnableIsMobileMobilePhoneMobilePhoneModelParamsIPNetworkID�9TraficSourceIDSearchEngineIDSearchPhraseAdvEngineIDIsArtificalWindowClientWidthWindowClientHeightClientTimeZone�ClientEventTime�SilverlightVersion1SilverlightVersion2SilverlightVersion3SilverlightVersion4 PageCharsetCodeVersionIsLinkIsDownloadIsNotBounceFUniqID:�W�mOriginalURLHIDIsOldCounterIsEventIsParameterDontCountHitsWithHashHitColor5LocalEventTimeA�QAgeSexIncomeInterestsRobotnessRemoteIP^DI�WindowName�OpenerName�HistoryLength�BrowserLanguage�BrowserCountry� SocialNetworkSocialActionHTTPErrorSendTimingDNSTimingConnectTimingResponseStartTimingResponseEndTimingFetchTimingSocialSourceNetworkIDSocialSourcePageParamPriceParamOrderIDParamCurrencyNHParamCurrencyIDOpenstatServiceNameOpenstatCampaignIDOpenstatAdIDOpenstatSourceIDUTMSourceUTMMediumUTMCampaignUTMContentUTMTermFromTagHasGCLIDRefererHashX+�'�URLHash� �#�\CLID�Wa⋯ Top short messages: c message_format_string substr(any(toValidUTF8(message)), 1, 120) min_length_without_exception_boilerplate 1. 17 {} ThreadFuzzer is enabled. Application will run slowly and unstable. 35 2. 12 Cannot TRUNCATE dictionary Code: 62. DB::Exception: Cannot TRUNCATE dictionary. (SYNTAX_ERROR) (version 24.8.14.10501.altinitytest (altinity build) 27 3. 7 Froze {} parts Froze 1 parts -13 4. 5 Found {} on {} Found snapshot_9.bin.zstd on LocalSnapshotDisk 18 5. 4 Resetting nice Resetting nice -12 6. 3 Creating {}: {} Creating table test_6jau1sho.tbl1: CREATE TABLE IF NOT EXISTS test_6jau1sho.tbl1 UUID '631da9a4-80f5-42d7-96a4-93cc466fc 1041 Top messages by level: (0.022176151508635555,'Table is in readonly mode (replica path: {})') Error (0.0005355382362129332,'Not enabled four letter command {}') Warning (0.0015011299045362522,'{} for session {} took {} ms') Information (0.06205346456724859,'(from {}{}{}){}{} {} (stage: {})') Debug (0.0614246128504834,'{} Creating query context from {} context, user_id: {}, parent context user: {}') Trace 2025-06-27 15:04:04,941 Stress test finished + echo -e 'Test script exit code\tOK\t\N\t' + rg -Fa 'No queries hung' /test_output/test_results.tsv + grep -Fa OK No queries hung OK \N + stop_server + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=2695 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2695. The process with pid = 2695 is running. Sent terminate signal to process with pid 2695. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2695. The process with pid = 2695 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2695. The process with pid = 2695 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2695. The process with pid = 2695 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2695. The process with pid = 2695 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2695. The process with pid = 2695 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2695. The process with pid = 2695 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2695. The process with pid = 2695 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2695. The process with pid = 2695 does not exist. Server stopped + return + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.stress.log + unset THREAD_FUZZER_CPU_TIME_PERIOD_US THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY THREAD_FUZZER_SLEEP_PROBABILITY THREAD_FUZZER_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US_MAX THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US_MAX THREAD_POOL_FAULT_INJECTION + start_server + counter=0 + max_attempt=120 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 127.0.0.1 - - [27/Jun/2025:13:04:14 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - 127.0.0.1 - - [27/Jun/2025:13:04:14 +0000] "PUT /devstoreaccount1/cont/lcvntubxckzmetzcmhkrybloipuektdb HTTP/1.1" 201 - 127.0.0.1 - - [27/Jun/2025:13:04:14 +0000] "GET /devstoreaccount1/cont/lcvntubxckzmetzcmhkrybloipuektdb HTTP/1.1" 206 4 127.0.0.1 - - [27/Jun/2025:13:04:14 +0000] "GET /devstoreaccount1/cont/lcvntubxckzmetzcmhkrybloipuektdb HTTP/1.1" 206 2 127.0.0.1 - - [27/Jun/2025:13:04:14 +0000] "DELETE /devstoreaccount1/cont/lcvntubxckzmetzcmhkrybloipuektdb HTTP/1.1" 202 - + 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' 1 + attach_gdb_to_clickhouse ++ run_with_retry 5 clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ [[ hxB =~ e ]] ++ set_e=false ++ set +e ++ local total_retries=5 ++ shift ++ local retry=0 ++ '[' 0 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' Received exception from server (version 24.8.14): Code: 439. DB::Exception: Received from localhost:9000. DB::Exception: Cannot schedule a task: fault injected (threads=1, jobs=1). (CANNOT_SCHEDULE_TASK) (query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value)) ++ retry=1 ++ sleep 5 ++ '[' 1 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' Received exception from server (version 24.8.14): Code: 439. DB::Exception: Received from localhost:9000. DB::Exception: Cannot schedule a task: failed to start the thread (threads=8, jobs=8). (CANNOT_SCHEDULE_TASK) (query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value)) ++ retry=2 ++ sleep 5 ++ '[' 2 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' Received exception from server (version 24.8.14): Code: 439. DB::Exception: Received from localhost:9000. DB::Exception: Cannot schedule a task: failed to start the thread (threads=13, jobs=13). (CANNOT_SCHEDULE_TASK) (query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value)) ++ retry=3 ++ sleep 5 ++ '[' 3 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' Received exception from server (version 24.8.14): Code: 439. DB::Exception: Received from localhost:9000. DB::Exception: Cannot schedule a task: fault injected (threads=13, jobs=13). (CANNOT_SCHEDULE_TASK) (query: SELECT count() FROM system.build_options WHERE name = 'CXX_FLAGS' AND position('sanitize=address' IN value)) ++ retry=4 ++ sleep 5 ++ '[' 4 -ge 5 ']' ++ clickhouse-client --query 'SELECT count() FROM system.build_options WHERE name = '\''CXX_FLAGS'\'' AND position('\''sanitize=address'\'' IN value)' ++ false ++ return + IS_ASAN=1 + [[ 1 = \1 ]] + echo 'ASAN build detected. Not using gdb since it disables LeakSanitizer detections' ASAN build detected. Not using gdb since it disables LeakSanitizer detections + 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=38299 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 38299. The process with pid = 38299 is running. Sent terminate signal to process with pid 38299. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 38299. The process with pid = 38299 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 38299. The process with pid = 38299 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 38299. The process with pid = 38299 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 38299. The process with pid = 38299 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 38299. The process with pid = 38299 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 38299. The process with pid = 38299 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 38299. The process with pid = 38299 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 38299. The process with pid = 38299 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 38299. The process with pid = 38299 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 38299. The process with pid = 38299 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 38299. The process with pid = 38299 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 38299. The process with pid = 38299 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + '[' -f /var/log/clickhouse-server/clickhouse-server.log ']' + '[' -f /var/log/clickhouse-server/stderr.log ']' + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.final.log + check_logs_for_critical_errors + sed -n '/WARNING:.*anitizer/,/^$/p' /var/log/clickhouse-server/stderr.log + rg -Fav -e 'ASan doesn'\''t fully support makecontext/swapcontext functions' -e DB::Exception /test_output/tmp + echo -e 'No sanitizer asserts\tOK\t\N\t' + rm -f /test_output/tmp + rg -Fa ' Application: Child process was terminated by signal 9' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No OOM messages in clickhouse-server.log\tOK\t\N\t' + rg -Fa 'Code: 49. DB::Exception: ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No logical errors\tOK\t\N\t' + '[' -s /test_output/logical_errors.txt ']' + rm /test_output/logical_errors.txt + rg --text 'Code: 499.*The specified key does not exist' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + grep -v a.myext + echo -e 'No lost s3 keys\tOK\t\N\t' + rg -Fa 'it is lost forever' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + grep SharedMergeTreePartCheckThread + echo -e 'No SharedMergeTree lost forever in clickhouse-server.log\tOK\t\N\t' + '[' -s /test_output/no_such_key_errors.txt ']' + rm /test_output/no_such_key_errors.txt + rg -Fa '########################################' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'Not crashed\tOK\t\N\t' + rg -Fa ' ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No fatal messages in clickhouse-server.log\tOK\t\N\t' + '[' -s /test_output/fatal_messages.txt ']' + rm /test_output/fatal_messages.txt + rg -Faz '########################################' /test_output/stress_run_logs.tar.zst /test_output/test_results.tsv + rg -Fa ' received signal ' /test_output/gdb.log /test_output/gdb.log: No such file or directory (os error 2) + dmesg -T + grep -q -F -e 'Out of memory: Killed process' -e 'oom_reaper: reaped process' -e oom-kill:constraint=CONSTRAINT_NONE /test_output/dmesg.log + echo -e 'No OOM in dmesg\tOK\t\N\t' + tar -chf /test_output/coordination.tar /var/lib/clickhouse/coordination tar: Removing leading `/' from member names tar: Removing leading `/' from hard link targets + collect_query_and_trace_logs + for table in query_log trace_log metric_log + clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.query_log format TSVWithNamesAndTypes' + zstd --threads=0 Logging trace to /var/log/clickhouse-server/clickhouse-server.log Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log 127.0.0.1 - - [27/Jun/2025:13:04:50 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - + for table in query_log trace_log metric_log + clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.trace_log format TSVWithNamesAndTypes' + zstd --threads=0 Logging trace to /var/log/clickhouse-server/clickhouse-server.log Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log 127.0.0.1 - - [27/Jun/2025:13:04:54 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - + for table in query_log trace_log metric_log + clickhouse-local --config-file=/etc/clickhouse-server/config.xml --only-system-tables -q 'select * from system.metric_log format TSVWithNamesAndTypes' + zstd --threads=0 Logging trace to /var/log/clickhouse-server/clickhouse-server.log Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log 127.0.0.1 - - [27/Jun/2025:13:04:57 +0000] "GET /devstoreaccount1/cont?restype=container HTTP/1.1" 200 - + mv /var/log/clickhouse-server/stderr.log /test_output/ + clickhouse-local --structure 'test String, res String, time Nullable(Float32), desc String' -q 'SELECT '\''failure'\'', test FROM table WHERE res != '\''OK'\'' order by (test like '\''%Sanitizer%'\'') DESC, (test like '\''%Killed by signal%'\'') DESC, (test like '\''%gdb.log%'\'') DESC, (test ilike '\''%possible deadlock%'\'') DESC, (test like '\''%start%'\'') DESC, (test like '\''%dmesg%'\'') DESC, (test like '\''%OOM%'\'') DESC, (test like '\''%Signal 9%'\'') DESC, (test like '\''%Fatal message%'\'') DESC, rowNumberInAllBlocks() LIMIT 1' + '[' -s /test_output/check_status.tsv ']' + echo -e 'success\tNo errors found' + rg 'OOM in dmesg|Signal 9' /test_output/check_status.tsv + collect_core_dumps + find . -type f -maxdepth 1 -name 'core.*' + read -r core