+ 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 /usr/share/clickhouse-test/ci/attach_gdb.lib ++ source /usr/share/clickhouse-test/ci/utils.lib + source /usr/share/clickhouse-test/ci/stress_tests.lib ++ sysctl kernel.core_pattern=core.%e.%p-%P kernel.core_pattern = core.%e.%p-%P ++ OK='\tOK\t\N\t' ++ FAIL='\tFAIL\t\N\t' ++ FAILURE_CONTEXT_LINES=100 ++ FAILURE_CONTEXT_MAX_LINE_WIDTH=300 + install_packages package_folder + dpkg -i package_folder/clickhouse-common-static_23.8.16.43.altinitystable+tsan_amd64.deb Selecting previously unselected package clickhouse-common-static. (Reading database ... 58488 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static_23.8.16.43.altinitystable+tsan_amd64.deb ... Unpacking clickhouse-common-static (23.8.16.43.altinitystable+tsan) ... Setting up clickhouse-common-static (23.8.16.43.altinitystable+tsan) ... + dpkg -i package_folder/clickhouse-common-static-dbg_23.8.16.43.altinitystable+tsan_amd64.deb Selecting previously unselected package clickhouse-common-static-dbg. (Reading database ... 58502 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static-dbg_23.8.16.43.altinitystable+tsan_amd64.deb ... Unpacking clickhouse-common-static-dbg (23.8.16.43.altinitystable+tsan) ... Setting up clickhouse-common-static-dbg (23.8.16.43.altinitystable+tsan) ... + dpkg -i package_folder/clickhouse-server_23.8.16.43.altinitystable+tsan_amd64.deb Selecting previously unselected package clickhouse-server. (Reading database ... 58511 files and directories currently installed.) Preparing to unpack .../clickhouse-server_23.8.16.43.altinitystable+tsan_amd64.deb ... Unpacking clickhouse-server (23.8.16.43.altinitystable+tsan) ... Setting up clickhouse-server (23.8.16.43.altinitystable+tsan) ... ClickHouse binary is already located at /usr/bin/clickhouse Symlink /usr/bin/clickhouse-server already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-server to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-client to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-local to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-benchmark to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-copier already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-copier 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 clickhouse group if it does not exist. groupadd -r clickhouse Creating clickhouse user if it does not exist. useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse clickhouse Will set ulimits for clickhouse user in /etc/security/limits.d/clickhouse.conf. Creating config directory /etc/clickhouse-server/config.d that is used for tweaks of main server configuration. Creating config directory /etc/clickhouse-server/users.d that is used for tweaks of users configuration. Config file /etc/clickhouse-server/config.xml already exists, will keep it and extract path info from it. /etc/clickhouse-server/config.xml has /var/lib/clickhouse/ as data path. /etc/clickhouse-server/config.xml has /var/log/clickhouse-server/ as log path. Users config file /etc/clickhouse-server/users.xml already exists, will keep it and extract users info from it. Log directory /var/log/clickhouse-server/ already exists. Creating data directory /var/lib/clickhouse/. Creating pid directory /var/run/clickhouse-server. chown -R clickhouse:clickhouse '/var/log/clickhouse-server/' chown -R clickhouse:clickhouse '/var/run/clickhouse-server' chown clickhouse:clickhouse '/var/lib/clickhouse/' groupadd -r clickhouse-bridge useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse-bridge clickhouse-bridge chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-odbc-bridge' chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-library-bridge' Password for default user is 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_23.8.16.43.altinitystable+tsan_amd64.deb Selecting previously unselected package clickhouse-client. (Reading database ... 58530 files and directories currently installed.) Preparing to unpack .../clickhouse-client_23.8.16.43.altinitystable+tsan_amd64.deb ... Unpacking clickhouse-client (23.8.16.43.altinitystable+tsan) ... Setting up clickhouse-client (23.8.16.43.altinitystable+tsan) ... + 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=100000 + THREAD_FUZZER_SLEEP_TIME_US=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=10000 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US=10000 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US=10000 + THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US=10000 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US=10000 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US=10000 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US=10000 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US=10000 + export THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01 + THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01 + export THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01 + THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01 + export ZOOKEEPER_FAULT_INJECTION=1 + ZOOKEEPER_FAULT_INJECTION=1 + configure + export USE_DATABASE_ORDINARY=1 + USE_DATABASE_ORDINARY=1 + export EXPORT_S3_STORAGE_POLICIES=1 + EXPORT_S3_STORAGE_POLICIES=1 + /usr/share/clickhouse-test/config/install.sh + DEST_SERVER_PATH=/etc/clickhouse-server + DEST_CLIENT_PATH=/etc/clickhouse-client +++ dirname /usr/share/clickhouse-test/config/install.sh ++ cd /usr/share/clickhouse-test/config ++ pwd -P + SRC_PATH=/usr/share/clickhouse-test/config + echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server' + 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/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/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disks.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/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/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/metadata_cache.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/reverse_dns_query_function.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/ + '[' /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/ + [[ -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/ + create_snapshot_on_exit=1 + sed --follow-symlinks -i 's|true|1|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ARM=aarch64 ++ uname -m + OS=x86_64 x86_64 Adding azure configuration + [[ -n 1 ]] + echo x86_64 + [[ '' -eq 1 ]] + [[ x86_64 == \a\a\r\c\h\6\4 ]] + echo 'Adding azure configuration' + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.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 + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\''' + export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + sudo chown root: /var/lib/clickhouse + echo '1' + local total_mem ++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo + total_mem=32086448 + total_mem=32856522752 + max_server_memory_usage_to_ram_ratio=0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat Setting max_server_memory_usage_to_ram_ratio to 0.5 + local max_users_mem + max_users_mem=9856956825 + echo 'Setting max_memory_usage_for_user=9856956825 and max_memory_usage for queries to 10G' + cat Setting max_memory_usage_for_user=9856956825 and max_memory_usage for queries to 10G + cat + cat + ./setup_minio.sh stateless + azurite-blob --blobHost 0.0.0.0 --blobPort 10000 --debug /azurite_log + export MINIO_ROOT_USER=clickhouse + MINIO_ROOT_USER=clickhouse + export MINIO_ROOT_PASSWORD=clickhouse + MINIO_ROOT_PASSWORD=clickhouse + main stateless + local query_dir ++ check_arg stateless ++ local query_dir ++ '[' '!' 1 -eq 1 ']' ++ case "$1" in ++ query_dir=0_stateless ++ echo 0_stateless + query_dir=0_stateless + '[' '!' -f ./minio ']' + start_minio + mkdir -p ./minio_data + ./minio --version Azurite Blob service is starting on 0.0.0.0:10000 Azurite Blob service successfully listens on http://0.0.0.0:10000 minio version RELEASE.2022-01-03T18-22-58Z + wait_for_it + local counter=0 + local max_counter=60 + local url=http://localhost:11111 + params=('--silent' '--verbose') + local params + ./minio server --address :11111 ./minio_data + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 0 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=1 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 1 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=2 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 2 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=3 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 3 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=4 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 4 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=5 + grep AccessDenied + curl --silent --verbose http://localhost:11111 trying to connect to minio + [[ 5 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=6 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 6 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=7 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 7 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=8 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 8 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=9 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 9 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=10 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 10 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio API: http://172.17.0.2:11111 http://127.0.0.1:11111 Console: http://172.17.0.2:40079 http://127.0.0.1:40079 Documentation: https://docs.min.io WARNING: Console endpoint is listening on a dynamic port (40079), please use --console-address ":PORT" to choose a static port. + counter=11 + grep AccessDenied + curl --silent --verbose http://localhost:11111 AccessDeniedAccess Denied./1811CB093E05F7113ee64d6d-8712-4680-8366-b0453397ffcc + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 259 root 10u IPv6 20030 0t0 TCP *:11111 (LISTEN) + sleep 5 + setup_minio stateless + local test_type=stateless + ./mc alias set clickminio http://localhost:11111 clickhouse clickhouse Added `clickminio` successfully. + ./mc admin user add clickminio test testtest Added user `test` successfully. + ./mc admin policy set clickminio readwrite user=test Policy `readwrite` is set on user `test` + ./mc mb clickminio/test Bucket created successfully `clickminio/test`. + '[' stateless = stateless ']' + ./mc policy set public clickminio/test Access permission for `clickminio/test` is set to `public` + upload_data 0_stateless /usr/share/clickhouse-test + local query_dir=0_stateless + local test_path=/usr/share/clickhouse-test + local data_path=/usr/share/clickhouse-test/queries/0_stateless/data_minio ++ ls /usr/share/clickhouse-test/queries/0_stateless/data_minio 02366_data.jsonl + for file in $(ls "${data_path}") + echo 02366_data.jsonl + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl clickminio/test/02366_data.jsonl `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl` -> `clickminio/test/02366_data.jsonl` Total: 0 B, Transferred: 0 B, Speed: 0 B/s + for file in $(ls "${data_path}") + echo 02731.arrow + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow clickminio/test/02731.arrow 02731.arrow `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow` -> `clickminio/test/02731.arrow` Total: 0 B, Transferred: 3.82 MiB, Speed: 117.81 MiB/s 02731.parquet + for file in $(ls "${data_path}") + echo 02731.parquet + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet clickminio/test/02731.parquet `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet` -> `clickminio/test/02731.parquet` Total: 0 B, Transferred: 1.57 MiB, Speed: 104.33 MiB/s a.tsv + for file in $(ls "${data_path}") + echo a.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv clickminio/test/a.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv` -> `clickminio/test/a.tsv` Total: 0 B, Transferred: 24 B, Speed: 3.18 KiB/s + for file in $(ls "${data_path}") + echo b.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv clickminio/test/b.tsv b.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv` -> `clickminio/test/b.tsv` Total: 0 B, Transferred: 33 B, Speed: 4.27 KiB/s c.tsv + for file in $(ls "${data_path}") + echo c.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv clickminio/test/c.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv` -> `clickminio/test/c.tsv` Total: 0 B, Transferred: 33 B, Speed: 5.34 KiB/s tsv_with_header.tsv + for file in $(ls "${data_path}") + echo tsv_with_header.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv clickminio/test/tsv_with_header.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv` -> `clickminio/test/tsv_with_header.tsv` Total: 0 B, Transferred: 44 B, Speed: 6.08 KiB/s + setup_aws_credentials + local minio_root_user=clickhouse + local minio_root_password=clickhouse + mkdir -p /root/.aws + cat + config_logs_export_cluster /etc/clickhouse-server/config.d/system_logs_export.yaml + set +x File /tmp/export-logs-config.sh does not exist, do not setup + start + counter=0 + 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 127.0.0.1 - - [16/Dec/2024:23:09:41 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [16/Dec/2024:23:09:41 +0000] "PUT /devstoreaccount1/cont/kbwsuetsmllakhdfrkrwwkgklhqbkrcd?blockid=liyyvdmxejqpffkoexlixnnodjvyduiiwcagyhtpvgpzmzhzdvgdhnjthmfnnxrw&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [16/Dec/2024:23:09:41 +0000] "PUT /devstoreaccount1/cont/kbwsuetsmllakhdfrkrwwkgklhqbkrcd?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [16/Dec/2024:23:09:41 +0000] "GET /devstoreaccount1/cont/kbwsuetsmllakhdfrkrwwkgklhqbkrcd HTTP/1.1" 206 4 127.0.0.1 - - [16/Dec/2024:23:09:41 +0000] "GET /devstoreaccount1/cont/kbwsuetsmllakhdfrkrwwkgklhqbkrcd HTTP/1.1" 206 2 127.0.0.1 - - [16/Dec/2024:23:09:41 +0000] "DELETE /devstoreaccount1/cont/kbwsuetsmllakhdfrkrwwkgklhqbkrcd HTTP/1.1" 202 - + counter=4 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ kill -l SIGRTMIN + RTMIN=34 + echo ' set follow-fork-mode parent handle SIGHUP nostop noprint pass handle SIGINT nostop noprint pass handle SIGQUIT nostop noprint pass handle SIGPIPE nostop noprint pass handle SIGTERM nostop noprint pass handle SIGUSR1 nostop noprint pass handle SIGUSR2 nostop noprint pass handle SIG34 nostop noprint pass info signals continue backtrace full thread apply all backtrace full info registers disassemble /s up disassemble /s up disassemble /s p "done" detach quit ' + sleep 5 + ts '%Y-%m-%d %H:%M:%S' ++ cat /var/run/clickhouse-server/clickhouse-server.pid + gdb -batch -command script.gdb -p 535 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + setup_logs_replication + set +x File /tmp/export-logs-config.sh does not exist, do not setup + /s3downloader --url-prefix https://s3.amazonaws.com/clickhouse-datasets --dataset-names hits visits INFO:root:Will fetch following datasets: hits, visits INFO:root:Processing hits INFO:root:Downloading from https://s3.amazonaws.com/clickhouse-datasets/hits/partitions/hits_v1.tar to temp path /tmp/ae5f92ue INFO:root:Content length is 1271623680 bytes INFO:root:Downloading finished INFO:root:Will unpack data from temp path /tmp/ae5f92ue to clickhouse db /var/lib/clickhouse/ INFO:root:Unpack finished INFO:root:Will remove downloaded file /tmp/ae5f92ue from filesystem if it exists INFO:root:Processing of hits finished INFO:root:Processing visits INFO:root:Downloading from https://s3.amazonaws.com/clickhouse-datasets/visits/partitions/visits_v1.tar to temp path /tmp/bkctxocx INFO:root:Content length is 563968000 bytes INFO:root:Downloading finished INFO:root:Will unpack data from temp path /tmp/bkctxocx to clickhouse db /var/lib/clickhouse/ INFO:root:Unpack finished INFO:root:Will remove downloaded file /tmp/bkctxocx from filesystem if it exists INFO:root:Processing of visits finished INFO:root:Fetch finished, enjoy your tables! + chmod 777 -R /var/lib/clickhouse + clickhouse-client --query 'ATTACH DATABASE IF NOT EXISTS datasets ENGINE = Ordinary' + clickhouse-client --query 'CREATE DATABASE IF NOT EXISTS test' + stop + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=535 + clickhouse stop --max-tries 90 --do-not-kill script.gdb:13: Error in sourced command file: No stack. /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 535. The process with pid = 535 is running. Sent terminate signal to process with pid 535. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 535. The process with pid = 535 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 535. The process with pid = 535 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 535. The process with pid = 535 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 535. The process with pid = 535 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 535. The process with pid = 535 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 535. The process with pid = 535 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 + start + counter=0 + 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 127.0.0.1 - - [16/Dec/2024:23:11:22 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [16/Dec/2024:23:11:22 +0000] "PUT /devstoreaccount1/cont/clznwmkddbhhxhfsbewzyuienizvqaup?blockid=hrezogvwfpaeoyjsyfonugiaasqvwpitrpvkzdfnauwbxouefgnliarvhsvbtmjr&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [16/Dec/2024:23:11:22 +0000] "PUT /devstoreaccount1/cont/clznwmkddbhhxhfsbewzyuienizvqaup?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [16/Dec/2024:23:11:22 +0000] "GET /devstoreaccount1/cont/clznwmkddbhhxhfsbewzyuienizvqaup HTTP/1.1" 206 4 127.0.0.1 - - [16/Dec/2024:23:11:22 +0000] "GET /devstoreaccount1/cont/clznwmkddbhhxhfsbewzyuienizvqaup HTTP/1.1" 206 2 127.0.0.1 - - [16/Dec/2024:23:11:22 +0000] "DELETE /devstoreaccount1/cont/clznwmkddbhhxhfsbewzyuienizvqaup HTTP/1.1" 202 - + 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' 1 + attach_gdb_to_clickhouse ++ kill -l SIGRTMIN + RTMIN=34 + echo ' set follow-fork-mode parent handle SIGHUP nostop noprint pass handle SIGINT nostop noprint pass handle SIGQUIT nostop noprint pass handle SIGPIPE nostop noprint pass handle SIGTERM nostop noprint pass handle SIGUSR1 nostop noprint pass handle SIGUSR2 nostop noprint pass handle SIG34 nostop noprint pass info signals continue backtrace full thread apply all backtrace full info registers disassemble /s up disassemble /s up disassemble /s p "done" detach quit ' + sleep 5 + ts '%Y-%m-%d %H:%M:%S' ++ cat /var/run/clickhouse-server/clickhouse-server.pid + gdb -batch -command script.gdb -p 956 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + clickhouse-client --query 'SHOW TABLES FROM datasets' hits_v1 visits_v1 + clickhouse-client --query 'SHOW TABLES FROM test' + clickhouse-client --query 'CREATE TABLE test.hits_s3 (WatchID UInt64, JavaEnable UInt8, Title String, GoodEvent Int16, EventTime DateTime, EventDate Date, CounterID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RegionID UInt32, UserID UInt64, CounterClass Int8, OS UInt8, UserAgent UInt8, URL String, Referer String, URLDomain String, RefererDomain String, Refresh UInt8, IsRobot UInt8, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32), RefererRegions Array(UInt32), ResolutionWidth UInt16, ResolutionHeight UInt16, ResolutionDepth UInt8, FlashMajor UInt8, FlashMinor UInt8, FlashMinor2 String, NetMajor UInt8, NetMinor UInt8, UserAgentMajor UInt16, UserAgentMinor FixedString(2), CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, MobilePhone UInt8, MobilePhoneModel String, Params String, IPNetworkID UInt32, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, IsArtifical UInt8, WindowClientWidth UInt16, WindowClientHeight UInt16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 UInt8, SilverlightVersion2 UInt8, SilverlightVersion3 UInt32, SilverlightVersion4 UInt16, PageCharset String, CodeVersion UInt32, IsLink UInt8, IsDownload UInt8, IsNotBounce UInt8, FUniqID UInt64, HID UInt32, IsOldCounter UInt8, IsEvent UInt8, IsParameter UInt8, DontCountHits UInt8, WithHash UInt8, HitColor FixedString(1), UTCEventTime DateTime, Age UInt8, Sex UInt8, Income UInt8, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), RemoteIP UInt32, RemoteIP6 FixedString(16), WindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage FixedString(2), BrowserCountry FixedString(2), SocialNetwork String, SocialAction String, HTTPError UInt16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, FetchTiming Int32, RedirectTiming Int32, DOMInteractiveTiming Int32, DOMContentLoadedTiming Int32, DOMCompleteTiming Int32, LoadEventStartTiming Int32, LoadEventEndTiming Int32, NSToDOMContentLoadedTiming Int32, FirstPaintTiming Int32, RedirectCount Int8, SocialSourceNetworkID UInt8, SocialSourcePage String, ParamPrice Int64, ParamOrderID String, ParamCurrency FixedString(3), ParamCurrencyID UInt16, GoalsReached Array(UInt32), OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, RefererHash UInt64, URLHash UInt64, CLID UInt32, YCLID UInt64, ShareService String, ShareURL String, ShareTitle String, ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64), IslandID FixedString(16), RequestNum UInt32, RequestTry UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate) ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''s3_cache'\''' + clickhouse-client --query 'CREATE TABLE test.hits (WatchID UInt64, JavaEnable UInt8, Title String, GoodEvent Int16, EventTime DateTime, EventDate Date, CounterID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RegionID UInt32, UserID UInt64, CounterClass Int8, OS UInt8, UserAgent UInt8, URL String, Referer String, URLDomain String, RefererDomain String, Refresh UInt8, IsRobot UInt8, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32), RefererRegions Array(UInt32), ResolutionWidth UInt16, ResolutionHeight UInt16, ResolutionDepth UInt8, FlashMajor UInt8, FlashMinor UInt8, FlashMinor2 String, NetMajor UInt8, NetMinor UInt8, UserAgentMajor UInt16, UserAgentMinor FixedString(2), CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, MobilePhone UInt8, MobilePhoneModel String, Params String, IPNetworkID UInt32, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, IsArtifical UInt8, WindowClientWidth UInt16, WindowClientHeight UInt16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 UInt8, SilverlightVersion2 UInt8, SilverlightVersion3 UInt32, SilverlightVersion4 UInt16, PageCharset String, CodeVersion UInt32, IsLink UInt8, IsDownload UInt8, IsNotBounce UInt8, FUniqID UInt64, HID UInt32, IsOldCounter UInt8, IsEvent UInt8, IsParameter UInt8, DontCountHits UInt8, WithHash UInt8, HitColor FixedString(1), UTCEventTime DateTime, Age UInt8, Sex UInt8, Income UInt8, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), RemoteIP UInt32, RemoteIP6 FixedString(16), WindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage FixedString(2), BrowserCountry FixedString(2), SocialNetwork String, SocialAction String, HTTPError UInt16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, FetchTiming Int32, RedirectTiming Int32, DOMInteractiveTiming Int32, DOMContentLoadedTiming Int32, DOMCompleteTiming Int32, LoadEventStartTiming Int32, LoadEventEndTiming Int32, NSToDOMContentLoadedTiming Int32, FirstPaintTiming Int32, RedirectCount Int8, SocialSourceNetworkID UInt8, SocialSourcePage String, ParamPrice Int64, ParamOrderID String, ParamCurrency FixedString(3), ParamCurrencyID UInt16, GoalsReached Array(UInt32), OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, RefererHash UInt64, URLHash UInt64, CLID UInt32, YCLID UInt64, ShareService String, ShareURL String, ShareTitle String, ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64), IslandID FixedString(16), RequestNum UInt32, RequestTry UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate) ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''s3_cache'\''' + clickhouse-client --query 'CREATE TABLE test.visits (CounterID UInt32, StartDate Date, Sign Int8, IsNew UInt8, VisitID UInt64, UserID UInt64, StartTime DateTime, Duration UInt32, UTCStartTime DateTime, PageViews Int32, Hits Int32, IsBounce UInt8, Referer String, StartURL String, RefererDomain String, StartURLDomain String, EndURL String, LinkURL String, IsDownload UInt8, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, PlaceID Int32, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32), RefererRegions Array(UInt32), IsYandex UInt8, GoalReachesDepth Int32, GoalReachesURL Int32, GoalReachesAny Int32, SocialSourceNetworkID UInt8, SocialSourcePage String, MobilePhoneModel String, ClientEventTime DateTime, RegionID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RemoteIP UInt32, RemoteIP6 FixedString(16), IPNetworkID UInt32, SilverlightVersion3 UInt32, CodeVersion UInt32, ResolutionWidth UInt16, ResolutionHeight UInt16, UserAgentMajor UInt16, UserAgentMinor UInt16, WindowClientWidth UInt16, WindowClientHeight UInt16, SilverlightVersion2 UInt8, SilverlightVersion4 UInt16, FlashVersion3 UInt16, FlashVersion4 UInt16, ClientTimeZone Int16, OS UInt8, UserAgent UInt8, ResolutionDepth UInt8, FlashMajor UInt8, FlashMinor UInt8, NetMajor UInt8, NetMinor UInt8, MobilePhone UInt8, SilverlightVersion1 UInt8, Age UInt8, Sex UInt8, Income UInt8, JavaEnable UInt8, CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, BrowserLanguage UInt16, BrowserCountry UInt16, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), Params Array(String), Goals Nested(ID UInt32, Serial UInt32, EventTime DateTime, Price Int64, OrderID String, CurrencyID UInt32), WatchIDs Array(UInt64), ParamSumPrice Int64, ParamCurrency FixedString(3), ParamCurrencyID UInt16, ClickLogID UInt64, ClickEventID Int32, ClickGoodEvent Int32, ClickEventTime DateTime, ClickPriorityID Int32, ClickPhraseID Int32, ClickPageID Int32, ClickPlaceID Int32, ClickTypeID Int32, ClickResourceID Int32, ClickCost UInt32, ClickClientIP UInt32, ClickDomainID UInt32, ClickURL String, ClickAttempt UInt8, ClickOrderID UInt32, ClickBannerID UInt32, ClickMarketCategoryID UInt32, ClickMarketPP UInt32, ClickMarketCategoryName String, ClickMarketPPName String, ClickAWAPSCampaignName String, ClickPageName String, ClickTargetType UInt16, ClickTargetPhraseID UInt64, ClickContextType UInt8, ClickSelectType Int8, ClickOptions String, ClickGroupBannerID Int32, OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, FirstVisit DateTime, PredLastVisit Date, LastVisit Date, TotalVisits UInt32, TraficSource Nested(ID Int8, SearchEngineID UInt16, AdvEngineID UInt8, PlaceID UInt16, SocialSourceNetworkID UInt8, Domain String, SearchPhrase String, SocialSourcePage String), Attendance FixedString(16), CLID UInt32, YCLID UInt64, NormalizedRefererHash UInt64, SearchPhraseHash UInt64, RefererDomainHash UInt64, NormalizedStartURLHash UInt64, StartURLDomainHash UInt64, NormalizedEndURLHash UInt64, TopLevelDomain UInt64, URLScheme UInt64, OpenstatServiceNameHash UInt64, OpenstatCampaignIDHash UInt64, OpenstatAdIDHash UInt64, OpenstatSourceIDHash UInt64, UTMSourceHash UInt64, UTMMediumHash UInt64, UTMCampaignHash UInt64, UTMContentHash UInt64, UTMTermHash UInt64, FromHash UInt64, WebVisorEnabled UInt8, WebVisorActivity UInt32, ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64), Market Nested(Type UInt8, GoalID UInt32, OrderID String, OrderPrice Int64, PP UInt32, DirectPlaceID UInt32, DirectOrderID UInt32, DirectBannerID UInt32, GoodID String, GoodName String, GoodQuantity Int32, GoodPrice Int64), IslandID FixedString(16)) ENGINE = CollapsingMergeTree(Sign) PARTITION BY toYYYYMM(StartDate) ORDER BY (CounterID, StartDate, intHash32(UserID), VisitID) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''s3_cache'\''' + clickhouse-client --query 'INSERT INTO test.hits_s3 SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0' + clickhouse-client --query 'INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0' + clickhouse-client --query 'INSERT INTO test.visits SELECT * FROM datasets.visits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0' + clickhouse-client --query 'DROP TABLE datasets.visits_v1 SYNC' + clickhouse-client --query 'DROP TABLE datasets.hits_v1 SYNC' + clickhouse-client --query 'SHOW TABLES FROM test' hits hits_s3 visits + clickhouse-client --query 'SYSTEM STOP THREAD FUZZER' + stop + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=956 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 956. The process with pid = 956 is running. Sent terminate signal to process with pid 956. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 956. The process with pid = 956 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 956. The process with pid = 956 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 956. The process with pid = 956 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 956. The process with pid = 956 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + export USE_S3_STORAGE_FOR_MERGE_TREE=1 + USE_S3_STORAGE_FOR_MERGE_TREE=1 + export 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 script.gdb:13: Error in sourced command file: No stack. ++ 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/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/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disks.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/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/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/metadata_cache.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/reverse_dns_query_function.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/ + '[' /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/ + [[ -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/ + create_snapshot_on_exit=0 + sed --follow-symlinks -i 's|true|0|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/config.d/s3_storage_policy_by_default.xml /etc/clickhouse-server/config.d/ + ARM=aarch64 ++ uname -m + OS=x86_64 + [[ -n 1 ]] + echo x86_64 + [[ '' -eq 1 ]] + [[ x86_64 == \a\a\r\c\h\6\4 ]] x86_64 Adding azure configuration + echo 'Adding azure configuration' + 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/users.d/s3_cache.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 + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\''' + export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + sudo chown root: /var/lib/clickhouse + echo '1' + local total_mem ++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo + total_mem=32086448 + total_mem=32856522752 + max_server_memory_usage_to_ram_ratio=0.5 Setting max_server_memory_usage_to_ram_ratio to 0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat Setting max_memory_usage_for_user=9856956825 and max_memory_usage for queries to 10G + local max_users_mem + max_users_mem=9856956825 + echo 'Setting max_memory_usage_for_user=9856956825 and max_memory_usage for queries to 10G' + cat + cat + cat + sudo cat /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sed 's|
s3
|
s3
default|' + mv /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml.tmp /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + 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 + start + counter=0 + 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 127.0.0.1 - - [16/Dec/2024:23:52:12 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [16/Dec/2024:23:52:12 +0000] "PUT /devstoreaccount1/cont/yykaijxiunvostnwbnfylqvoopttjgkl?blockid=ebhqlnuspbwoxpaiealyivkwjvkgtiuqwgfkfltlitnlxhtjuhysizvapbzgaeza&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [16/Dec/2024:23:52:12 +0000] "PUT /devstoreaccount1/cont/yykaijxiunvostnwbnfylqvoopttjgkl?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [16/Dec/2024:23:52:12 +0000] "GET /devstoreaccount1/cont/yykaijxiunvostnwbnfylqvoopttjgkl HTTP/1.1" 206 4 127.0.0.1 - - [16/Dec/2024:23:52:12 +0000] "GET /devstoreaccount1/cont/yykaijxiunvostnwbnfylqvoopttjgkl HTTP/1.1" 206 2 127.0.0.1 - - [16/Dec/2024:23:52:12 +0000] "DELETE /devstoreaccount1/cont/yykaijxiunvostnwbnfylqvoopttjgkl HTTP/1.1" 202 - + 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' 1 + attach_gdb_to_clickhouse ++ kill -l SIGRTMIN + RTMIN=34 + echo ' set follow-fork-mode parent handle SIGHUP nostop noprint pass handle SIGINT nostop noprint pass handle SIGQUIT nostop noprint pass handle SIGPIPE nostop noprint pass handle SIGTERM nostop noprint pass handle SIGUSR1 nostop noprint pass handle SIGUSR2 nostop noprint pass handle SIG34 nostop noprint pass info signals continue backtrace full thread apply all backtrace full info registers disassemble /s up disassemble /s up disassemble /s p "done" detach quit ' + sleep 5 + ts '%Y-%m-%d %H:%M:%S' ++ cat /var/run/clickhouse-server/clickhouse-server.pid + gdb -batch -command script.gdb -p 1738 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + stress --hung-check --drop-databases --output-folder test_output --skip-func-tests '' --global-time-limit 1200 2024-12-17 00:53:09,556 Run func tests '/usr/bin/clickhouse-test --global_time_limit=1200 ' 2024-12-17 00:53:10,057 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_1 --client-option join_use_nulls=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-12-17 00:53:10,559 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_2', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 --global_time_limit=1200 ' 2024-12-17 00:53:11,060 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_3 --client-option join_algorithm='partial_merge' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-12-17 00:53:11,561 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 ' 2024-12-17 00:53:12,062 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_5', 's1', 'r1')" --database=test_5 --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 join_algorithm='full_sorting_merge' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-12-17 00:53:12,563 Run func tests '/usr/bin/clickhouse-test --order=random --client-option use_query_cache=1 memory_tracker_fault_probability=0.001 --global_time_limit=1200 ' 2024-12-17 00:53:13,064 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_7 --client-option join_use_nulls=1 join_algorithm='grace_hash' use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-12-17 00:53:13,565 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_8', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 --global_time_limit=1200 ' 2024-12-17 00:53:14,067 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_9 --client-option join_algorithm='auto' max_rows_in_join=1000 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-12-17 00:53:14,568 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 ' 2024-12-17 00:53:15,069 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_11', 's1', 'r1')" --database=test_11 --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 join_algorithm='parallel_hash' use_query_cache=1 memory_tracker_fault_probability=0.001 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-12-17 00:53:15,570 Run func tests '/usr/bin/clickhouse-test --order=random --client-option implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 --global_time_limit=1200 ' 2024-12-17 00:53:16,071 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_13 --client-option join_use_nulls=1 join_algorithm='partial_merge' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-12-17 00:53:16,572 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_14', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 use_query_cache=1 --global_time_limit=1200 ' 2024-12-17 00:53:17,074 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_merge' use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-12-17 00:53:17,575 Will wait functests to finish 2024-12-17 00:53:17,575 Finished 0 from 16 processes 2024-12-17 00:53:22,580 Finished 0 from 16 processes 2024-12-17 00:53:27,583 Finished 0 from 16 processes 2024-12-17 00:53:32,588 Finished 0 from 16 processes 2024-12-17 00:53:37,591 Finished 0 from 16 processes 2024-12-17 00:53:42,595 Finished 0 from 16 processes 2024-12-17 00:53:47,599 Finished 0 from 16 processes 2024-12-17 00:53:52,603 Finished 0 from 16 processes 2024-12-17 00:53:57,607 Finished 0 from 16 processes 2024-12-17 00:54:02,611 Finished 0 from 16 processes 2024-12-17 00:54:07,616 Finished 0 from 16 processes 2024-12-17 00:54:12,619 Finished 0 from 16 processes 2024-12-17 00:54:17,623 Finished 0 from 16 processes 2024-12-17 00:54:22,627 Finished 0 from 16 processes 2024-12-17 00:54:27,628 Finished 0 from 16 processes 2024-12-17 00:54:32,631 Finished 0 from 16 processes 2024-12-17 00:54:37,635 Finished 0 from 16 processes 2024-12-17 00:54:42,640 Finished 0 from 16 processes 2024-12-17 00:54:47,643 Finished 0 from 16 processes 2024-12-17 00:54:52,648 Finished 0 from 16 processes 2024-12-17 00:54:57,651 Finished 0 from 16 processes 2024-12-17 00:55:02,655 Finished 0 from 16 processes 2024-12-17 00:55:07,659 Finished 0 from 16 processes 2024-12-17 00:55:12,664 Finished 0 from 16 processes 2024-12-17 00:55:17,668 Finished 0 from 16 processes 2024-12-17 00:55:22,671 Finished 0 from 16 processes 2024-12-17 00:55:27,675 Finished 0 from 16 processes 2024-12-17 00:55:32,679 Finished 0 from 16 processes 2024-12-17 00:55:37,684 Finished 0 from 16 processes 2024-12-17 00:55:42,687 Finished 0 from 16 processes 2024-12-17 00:55:47,691 Finished 0 from 16 processes 2024-12-17 00:55:52,695 Finished 0 from 16 processes 2024-12-17 00:55:57,699 Finished 0 from 16 processes 2024-12-17 00:56:02,704 Finished 0 from 16 processes 2024-12-17 00:56:07,707 Finished 0 from 16 processes 2024-12-17 00:56:12,711 Finished 0 from 16 processes 2024-12-17 00:56:17,715 Finished 0 from 16 processes 2024-12-17 00:56:22,719 Finished 0 from 16 processes 2024-12-17 00:56:27,723 Finished 0 from 16 processes 2024-12-17 00:56:32,727 Finished 0 from 16 processes 2024-12-17 00:56:37,731 Finished 0 from 16 processes 2024-12-17 00:56:42,735 Finished 0 from 16 processes 2024-12-17 00:56:47,739 Finished 0 from 16 processes 2024-12-17 00:56:52,744 Finished 0 from 16 processes 2024-12-17 00:56:57,747 Finished 0 from 16 processes 2024-12-17 00:57:02,751 Finished 0 from 16 processes 2024-12-17 00:57:07,755 Finished 0 from 16 processes 2024-12-17 00:57:12,760 Finished 0 from 16 processes 2024-12-17 00:57:17,763 Finished 0 from 16 processes 2024-12-17 00:57:22,767 Finished 0 from 16 processes 2024-12-17 00:57:27,771 Finished 0 from 16 processes 2024-12-17 00:57:32,775 Finished 0 from 16 processes 2024-12-17 00:57:37,780 Finished 0 from 16 processes 2024-12-17 00:57:42,783 Finished 0 from 16 processes 2024-12-17 00:57:47,787 Finished 0 from 16 processes 2024-12-17 00:57:52,792 Finished 0 from 16 processes 2024-12-17 00:57:57,798 Finished 0 from 16 processes 2024-12-17 00:58:02,803 Finished 0 from 16 processes 2024-12-17 00:58:07,807 Finished 0 from 16 processes 2024-12-17 00:58:12,811 Finished 0 from 16 processes 2024-12-17 00:58:17,815 Finished 0 from 16 processes 2024-12-17 00:58:22,819 Finished 0 from 16 processes 2024-12-17 00:58:27,823 Finished 0 from 16 processes 2024-12-17 00:58:32,827 Finished 0 from 16 processes 2024-12-17 00:58:37,831 Finished 0 from 16 processes 2024-12-17 00:58:42,835 Finished 0 from 16 processes 2024-12-17 00:58:47,839 Finished 0 from 16 processes 2024-12-17 00:58:52,843 Finished 0 from 16 processes 2024-12-17 00:58:57,847 Finished 0 from 16 processes 2024-12-17 00:59:02,851 Finished 0 from 16 processes 2024-12-17 00:59:07,855 Finished 0 from 16 processes 2024-12-17 00:59:12,859 Finished 0 from 16 processes 2024-12-17 00:59:17,865 Finished 0 from 16 processes 2024-12-17 00:59:22,869 Finished 0 from 16 processes 2024-12-17 00:59:27,871 Finished 0 from 16 processes 2024-12-17 00:59:32,875 Finished 0 from 16 processes 2024-12-17 00:59:37,879 Finished 0 from 16 processes 2024-12-17 00:59:42,883 Finished 0 from 16 processes 2024-12-17 00:59:47,887 Finished 0 from 16 processes 2024-12-17 00:59:52,891 Finished 0 from 16 processes 2024-12-17 00:59:57,894 Finished 0 from 16 processes 2024-12-17 01:00:02,897 Finished 0 from 16 processes 2024-12-17 01:00:07,902 Finished 0 from 16 processes 2024-12-17 01:00:12,907 Finished 0 from 16 processes 2024-12-17 01:00:17,911 Finished 0 from 16 processes 2024-12-17 01:00:22,916 Finished 0 from 16 processes 2024-12-17 01:00:27,919 Finished 0 from 16 processes 2024-12-17 01:00:32,923 Finished 0 from 16 processes 2024-12-17 01:00:37,927 Finished 0 from 16 processes 2024-12-17 01:00:42,931 Finished 0 from 16 processes 2024-12-17 01:00:47,935 Finished 0 from 16 processes 2024-12-17 01:00:52,940 Finished 0 from 16 processes 2024-12-17 01:00:57,945 Finished 0 from 16 processes 2024-12-17 01:01:02,950 Finished 0 from 16 processes 2024-12-17 01:01:07,955 Finished 0 from 16 processes 2024-12-17 01:01:12,960 Finished 0 from 16 processes 2024-12-17 01:01:17,963 Finished 0 from 16 processes 2024-12-17 01:01:22,967 Finished 0 from 16 processes 2024-12-17 01:01:27,971 Finished 0 from 16 processes 2024-12-17 01:01:32,975 Finished 0 from 16 processes 2024-12-17 01:01:37,979 Finished 0 from 16 processes 2024-12-17 01:01:42,981 Finished 0 from 16 processes 2024-12-17 01:01:47,983 Finished 0 from 16 processes 2024-12-17 01:01:52,987 Finished 0 from 16 processes 2024-12-17 01:01:57,991 Finished 0 from 16 processes 2024-12-17 01:02:02,996 Finished 0 from 16 processes 2024-12-17 01:02:07,999 Finished 0 from 16 processes 2024-12-17 01:02:13,003 Finished 0 from 16 processes 2024-12-17 01:02:18,007 Finished 0 from 16 processes 2024-12-17 01:02:23,011 Finished 0 from 16 processes 2024-12-17 01:02:28,015 Finished 0 from 16 processes 2024-12-17 01:02:33,020 Finished 0 from 16 processes 2024-12-17 01:02:38,023 Finished 0 from 16 processes 2024-12-17 01:02:43,027 Finished 0 from 16 processes 2024-12-17 01:02:48,033 Finished 0 from 16 processes 2024-12-17 01:02:53,035 Finished 0 from 16 processes 2024-12-17 01:02:58,040 Finished 0 from 16 processes 2024-12-17 01:03:03,043 Finished 0 from 16 processes 2024-12-17 01:03:08,047 Finished 0 from 16 processes 2024-12-17 01:03:13,051 Finished 0 from 16 processes 2024-12-17 01:03:18,056 Finished 0 from 16 processes 2024-12-17 01:03:23,059 Finished 0 from 16 processes 2024-12-17 01:03:28,063 Finished 0 from 16 processes 2024-12-17 01:03:33,067 Finished 0 from 16 processes 2024-12-17 01:03:38,071 Finished 0 from 16 processes 2024-12-17 01:03:43,075 Finished 0 from 16 processes 2024-12-17 01:03:48,079 Finished 0 from 16 processes 2024-12-17 01:03:53,083 Finished 0 from 16 processes 2024-12-17 01:03:58,087 Finished 0 from 16 processes 2024-12-17 01:04:03,091 Finished 0 from 16 processes 2024-12-17 01:04:08,095 Finished 0 from 16 processes 2024-12-17 01:04:13,099 Finished 0 from 16 processes 2024-12-17 01:04:18,103 Finished 0 from 16 processes 2024-12-17 01:04:23,107 Finished 0 from 16 processes 2024-12-17 01:04:28,111 Finished 0 from 16 processes 2024-12-17 01:04:33,115 Finished 0 from 16 processes 2024-12-17 01:04:38,119 Finished 0 from 16 processes 2024-12-17 01:04:43,123 Finished 0 from 16 processes 2024-12-17 01:04:48,127 Finished 0 from 16 processes 2024-12-17 01:04:53,131 Finished 0 from 16 processes 2024-12-17 01:04:58,135 Finished 0 from 16 processes 2024-12-17 01:05:03,139 Finished 0 from 16 processes 2024-12-17 01:05:08,143 Finished 0 from 16 processes 2024-12-17 01:05:13,147 Finished 0 from 16 processes 2024-12-17 01:05:18,151 Finished 0 from 16 processes 2024-12-17 01:05:23,155 Finished 0 from 16 processes 2024-12-17 01:05:28,160 Finished 0 from 16 processes 2024-12-17 01:05:33,163 Finished 0 from 16 processes 2024-12-17 01:05:38,167 Finished 0 from 16 processes 2024-12-17 01:05:43,172 Finished 0 from 16 processes 2024-12-17 01:05:48,175 Finished 0 from 16 processes 2024-12-17 01:05:53,179 Finished 0 from 16 processes 2024-12-17 01:05:58,183 Finished 0 from 16 processes 2024-12-17 01:06:03,187 Finished 0 from 16 processes 2024-12-17 01:06:08,191 Finished 0 from 16 processes 2024-12-17 01:06:13,196 Finished 0 from 16 processes 2024-12-17 01:06:18,199 Finished 0 from 16 processes 2024-12-17 01:06:23,204 Finished 0 from 16 processes 2024-12-17 01:06:28,207 Finished 0 from 16 processes 2024-12-17 01:06:33,211 Finished 0 from 16 processes 2024-12-17 01:06:38,215 Finished 0 from 16 processes 2024-12-17 01:06:43,219 Finished 0 from 16 processes 2024-12-17 01:06:48,223 Finished 0 from 16 processes 2024-12-17 01:06:53,227 Finished 0 from 16 processes 2024-12-17 01:06:58,231 Finished 0 from 16 processes 2024-12-17 01:07:03,235 Finished 0 from 16 processes 2024-12-17 01:07:08,239 Finished 0 from 16 processes 2024-12-17 01:07:13,243 Finished 0 from 16 processes 2024-12-17 01:07:18,247 Finished 0 from 16 processes 2024-12-17 01:07:23,251 Finished 0 from 16 processes 2024-12-17 01:07:28,255 Finished 0 from 16 processes 2024-12-17 01:07:33,259 Finished 0 from 16 processes 2024-12-17 01:07:38,263 Finished 0 from 16 processes 2024-12-17 01:07:43,267 Finished 0 from 16 processes 2024-12-17 01:07:48,271 Finished 0 from 16 processes 2024-12-17 01:07:53,275 Finished 0 from 16 processes 2024-12-17 01:07:58,279 Finished 0 from 16 processes 2024-12-17 01:08:03,284 Finished 0 from 16 processes 2024-12-17 01:08:08,287 Finished 0 from 16 processes 2024-12-17 01:08:13,290 Finished 0 from 16 processes 2024-12-17 01:08:18,295 Finished 0 from 16 processes 2024-12-17 01:08:23,299 Finished 0 from 16 processes 2024-12-17 01:08:28,303 Finished 0 from 16 processes 2024-12-17 01:08:33,308 Finished 0 from 16 processes 2024-12-17 01:08:38,311 Finished 0 from 16 processes 2024-12-17 01:08:43,315 Finished 0 from 16 processes 2024-12-17 01:08:48,319 Finished 0 from 16 processes 2024-12-17 01:08:53,324 Finished 0 from 16 processes 2024-12-17 01:08:58,327 Finished 0 from 16 processes 2024-12-17 01:09:03,331 Finished 0 from 16 processes 2024-12-17 01:09:08,335 Finished 0 from 16 processes 2024-12-17 01:09:13,339 Finished 0 from 16 processes 2024-12-17 01:09:18,343 Finished 0 from 16 processes 2024-12-17 01:09:23,347 Finished 0 from 16 processes 2024-12-17 01:09:28,351 Finished 0 from 16 processes 2024-12-17 01:09:33,355 Finished 0 from 16 processes 2024-12-17 01:09:38,360 Finished 0 from 16 processes 2024-12-17 01:09:43,363 Finished 0 from 16 processes 2024-12-17 01:09:48,367 Finished 0 from 16 processes 2024-12-17 01:09:53,373 Finished 0 from 16 processes 2024-12-17 01:09:58,375 Finished 0 from 16 processes 2024-12-17 01:10:03,379 Finished 0 from 16 processes 2024-12-17 01:10:08,383 Finished 0 from 16 processes 2024-12-17 01:10:13,387 Finished 0 from 16 processes 2024-12-17 01:10:18,392 Finished 0 from 16 processes 2024-12-17 01:10:23,395 Finished 0 from 16 processes 2024-12-17 01:10:28,399 Finished 0 from 16 processes 2024-12-17 01:10:33,403 Finished 0 from 16 processes 2024-12-17 01:10:38,408 Finished 0 from 16 processes 2024-12-17 01:10:43,411 Finished 0 from 16 processes 2024-12-17 01:10:48,415 Finished 0 from 16 processes 2024-12-17 01:10:53,419 Finished 0 from 16 processes 2024-12-17 01:10:58,423 Finished 0 from 16 processes 2024-12-17 01:11:03,427 Finished 0 from 16 processes 2024-12-17 01:11:08,431 Finished 0 from 16 processes 2024-12-17 01:11:13,435 Finished 0 from 16 processes 2024-12-17 01:11:18,439 Finished 0 from 16 processes 2024-12-17 01:11:23,443 Finished 0 from 16 processes 2024-12-17 01:11:28,447 Finished 0 from 16 processes 2024-12-17 01:11:33,451 Finished 0 from 16 processes 2024-12-17 01:11:38,456 Finished 0 from 16 processes 2024-12-17 01:11:43,459 Finished 0 from 16 processes 2024-12-17 01:11:48,464 Finished 0 from 16 processes 2024-12-17 01:11:53,469 Finished 0 from 16 processes 2024-12-17 01:11:58,471 Finished 0 from 16 processes 2024-12-17 01:12:03,475 Finished 0 from 16 processes 2024-12-17 01:12:08,479 Finished 0 from 16 processes 2024-12-17 01:12:13,484 Finished 0 from 16 processes 2024-12-17 01:12:18,487 Finished 0 from 16 processes 2024-12-17 01:12:23,492 Finished 0 from 16 processes 2024-12-17 01:12:28,495 Finished 0 from 16 processes 2024-12-17 01:12:33,499 Finished 0 from 16 processes 2024-12-17 01:12:38,503 Finished 0 from 16 processes 2024-12-17 01:12:43,507 Finished 0 from 16 processes 2024-12-17 01:12:48,511 Finished 0 from 16 processes 2024-12-17 01:12:53,515 Finished 0 from 16 processes 2024-12-17 01:12:58,519 Finished 0 from 16 processes 2024-12-17 01:13:03,523 Finished 0 from 16 processes 2024-12-17 01:13:08,529 Finished 0 from 16 processes 2024-12-17 01:13:13,531 Finished 0 from 16 processes 2024-12-17 01:13:18,535 Finished 1 from 16 processes 2024-12-17 01:13:23,539 Finished 1 from 16 processes 2024-12-17 01:13:28,543 Finished 3 from 16 processes 2024-12-17 01:13:33,548 Finished 4 from 16 processes 2024-12-17 01:13:38,553 Finished 5 from 16 processes 2024-12-17 01:13:43,556 Finished 5 from 16 processes 2024-12-17 01:13:48,559 Finished 5 from 16 processes 2024-12-17 01:13:53,563 Finished 7 from 16 processes 2024-12-17 01:13:58,567 Finished 7 from 16 processes 2024-12-17 01:14:03,571 Finished 7 from 16 processes 2024-12-17 01:14:08,575 Finished 7 from 16 processes 2024-12-17 01:14:13,579 Finished 8 from 16 processes 2024-12-17 01:14:18,583 Finished 8 from 16 processes 2024-12-17 01:14:23,588 Finished 8 from 16 processes 2024-12-17 01:14:28,594 Finished 8 from 16 processes 2024-12-17 01:14:33,595 Finished 8 from 16 processes 2024-12-17 01:14:38,599 Finished 8 from 16 processes 2024-12-17 01:14:43,604 Finished 8 from 16 processes 2024-12-17 01:14:48,607 Finished 8 from 16 processes 2024-12-17 01:14:53,611 Finished 8 from 16 processes 2024-12-17 01:14:58,616 Finished 8 from 16 processes 2024-12-17 01:15:03,621 Finished 8 from 16 processes 2024-12-17 01:15:08,623 Finished 8 from 16 processes 2024-12-17 01:15:13,627 Finished 9 from 16 processes 2024-12-17 01:15:18,631 Finished 9 from 16 processes 2024-12-17 01:15:23,636 Finished 9 from 16 processes 2024-12-17 01:15:28,641 Finished 9 from 16 processes 2024-12-17 01:15:33,647 Finished 10 from 16 processes 2024-12-17 01:15:38,651 Finished 10 from 16 processes 2024-12-17 01:15:43,655 Finished 10 from 16 processes 2024-12-17 01:15:48,659 Finished 10 from 16 processes 2024-12-17 01:15:53,663 Finished 10 from 16 processes 2024-12-17 01:15:58,667 Finished 10 from 16 processes 2024-12-17 01:16:03,671 Finished 10 from 16 processes 2024-12-17 01:16:08,675 Finished 10 from 16 processes 2024-12-17 01:16:13,679 Finished 10 from 16 processes 2024-12-17 01:16:18,683 Finished 10 from 16 processes 2024-12-17 01:16:23,687 Finished 10 from 16 processes 2024-12-17 01:16:28,691 Finished 10 from 16 processes 2024-12-17 01:16:33,695 Finished 10 from 16 processes 2024-12-17 01:16:38,699 Finished 10 from 16 processes 2024-12-17 01:16:43,703 Finished 10 from 16 processes 2024-12-17 01:16:48,707 Finished 10 from 16 processes 2024-12-17 01:16:53,711 Finished 10 from 16 processes 2024-12-17 01:16:58,715 Finished 10 from 16 processes 2024-12-17 01:17:03,715 Finished 10 from 16 processes 2024-12-17 01:17:08,719 Finished 10 from 16 processes 2024-12-17 01:17:13,723 Finished 10 from 16 processes 2024-12-17 01:17:18,726 Finished 11 from 16 processes 2024-12-17 01:17:23,731 Finished 11 from 16 processes 2024-12-17 01:17:28,735 Finished 11 from 16 processes 2024-12-17 01:17:33,744 Finished 12 from 16 processes 2024-12-17 01:17:38,749 Finished 12 from 16 processes 2024-12-17 01:17:43,751 Finished 12 from 16 processes 2024-12-17 01:17:48,756 Finished 12 from 16 processes 2024-12-17 01:17:53,759 Finished 12 from 16 processes 2024-12-17 01:17:58,764 Finished 12 from 16 processes 2024-12-17 01:18:03,770 Finished 12 from 16 processes 2024-12-17 01:18:08,771 Finished 12 from 16 processes 2024-12-17 01:18:13,776 Finished 12 from 16 processes 2024-12-17 01:18:18,782 Finished 12 from 16 processes 2024-12-17 01:18:23,783 Finished 12 from 16 processes 2024-12-17 01:18:28,788 Finished 13 from 16 processes 2024-12-17 01:18:33,791 Finished 13 from 16 processes 2024-12-17 01:18:38,795 Finished 13 from 16 processes 2024-12-17 01:18:43,799 Finished 13 from 16 processes 2024-12-17 01:18:48,804 Finished 13 from 16 processes 2024-12-17 01:18:53,807 Finished 13 from 16 processes 2024-12-17 01:18:58,811 Finished 13 from 16 processes 2024-12-17 01:19:03,816 Finished 14 from 16 processes 2024-12-17 01:19:08,821 Finished 14 from 16 processes 2024-12-17 01:19:13,827 Finished 14 from 16 processes 2024-12-17 01:19:18,831 Finished 14 from 16 processes 2024-12-17 01:19:23,836 Finished 14 from 16 processes 2024-12-17 01:19:28,842 Finished 14 from 16 processes 2024-12-17 01:19:33,843 Finished 14 from 16 processes 2024-12-17 01:19:38,847 Finished 14 from 16 processes 2024-12-17 01:19:43,852 Finished 14 from 16 processes 2024-12-17 01:19:48,858 Finished 14 from 16 processes 2024-12-17 01:19:53,859 Finished 14 from 16 processes 2024-12-17 01:19:58,864 Finished 14 from 16 processes 2024-12-17 01:20:03,867 Finished 14 from 16 processes 2024-12-17 01:20:08,871 Finished 14 from 16 processes 2024-12-17 01:20:13,875 Finished 14 from 16 processes 2024-12-17 01:20:18,879 Finished 14 from 16 processes 2024-12-17 01:20:23,883 Finished 14 from 16 processes 2024-12-17 01:20:28,887 Finished 14 from 16 processes 2024-12-17 01:20:33,891 Finished 14 from 16 processes 2024-12-17 01:20:38,896 Finished 15 from 16 processes 2024-12-17 01:20:43,899 Finished 15 from 16 processes 2024-12-17 01:20:48,904 All processes finished 2024-12-17 01:20:48,904 Compressing stress logs 2024-12-17 01:20:48,925 Logs compressed 2024-12-17 01:20:48,925 Will terminate gdb (if any) Quit 2024-12-17 01:25:53,843 Checking if some queries hung Using queries from '/usr/share/clickhouse-test/queries' directory Connecting to ClickHouse server... OK Running 1 stateless tests (MainProcess). 00001_select_1: [ OK ] 1 tests passed. 0 tests skipped. 0.43 s elapsed (MainProcess). Won't run stateful tests because test data wasn't loaded. 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 UInt64 Float64 String Float64 UInt64 UInt64 Array(String) Float64 LowCardinality(String) 33217 0.07 113.53 MiB 0.668 15 128 ['Error'] 1 Table is in readonly mode (replica path: {}) 29097 0.061 2.61 MiB 0.015 1 1809 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 26266 0.055 1018.78 KiB 0.006 1 1731 ['Trace'] 0 Aggregation method: {} 23781 0.05 255.46 KiB 0.001 1 1688 ['Trace'] 0 Aggregating 22527 0.048 1.19 MiB 0.007 5 253 ['Trace'] 0 Access granted: {}{} 21800 0.046 4.27 MiB 0.025 1 189 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 21179 0.045 1.70 MiB 0.01 1 1374 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 20995 0.044 3.14 MiB 0.018 2 188 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 19396 0.041 547.97 KiB 0.003 1 188 ['Debug'] 0.001 Processed in {} sec. 14683 0.031 1.16 MiB 0.007 1 176 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 12364 0.026 299.33 KiB 0.002 1 234 ['Trace'] 0.002 {} -> {} 10857 0.023 485.08 KiB 0.003 1 1 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 10470 0.022 855.81 KiB 0.005 3 209 ['Debug'] 0.998 {} Authenticating user \'{}\' from {} 10466 0.022 1.15 MiB 0.007 3 209 ['Debug'] 0.998 {} Authenticated with global context as user {} 10436 0.022 917.23 KiB 0.005 3 208 ['Debug'] 0.998 {} Logout, user_id: {} 10418 0.022 1.11 MiB 0.007 2 188 ['Debug'] 1 {} Creating session context with user_id: {} 9069 0.019 394.61 KiB 0.002 1 192 ['Debug'] 0.096 Peak memory usage{}: {}. 8868 0.019 289.90 KiB 0.002 2 188 ['Trace'] 1 TCP Request. Address: {} 8868 0.019 833.81 KiB 0.005 1 188 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 6060 0.013 159.79 KiB 0.001 1 187 ['Debug'] 1 Done processing connection. 5386 0.011 615.39 KiB 0.004 116 1351 ['Trace'] 0 Bypassing cache because file segment state is `PARTIALLY_DOWNLOADED_NO_CONTINUATION` and downloaded part already used 5035 0.011 584.95 KiB 0.003 428 287 ['Trace'] 0.386 Renaming temporary part {} to {} with tid {}. 4976 0.01 231.01 KiB 0.001 1 275 ['Trace'] 0.384 filled checksums {} 4929 0.01 2.43 MiB 0.014 1 366 ['Debug'] 0.984 Objects with paths [{}] were removed from S3 4912 0.01 340.61 KiB 0.002 418 386 ['Trace'] 0.551 Trying to reserve {} using storage policy from min volume index {} 4380 0.009 5.19 MiB 0.031 1 357 ['Debug'] 0.995 metadata and objects were removed for [{}], only metadata were removed for [{}]. 4306 0.009 331.28 KiB 0.002 1 483 ['Debug'] 0.388 Remove from cache. Key: {}, offset: {}, size: {} 3912 0.008 360.31 KiB 0.002 1 44 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 3796 0.008 226.13 KiB 0.001 1 132 ['Debug'] 0.932 Key {} is removed from metadata 3421 0.007 74.69 KiB 0 72 132 ['Trace'] 1 Execution took {} ms. 3299 0.007 74.10 KiB 0 1 1291 ['Trace'] 0 Merging aggregated data 2424 0.005 350.72 KiB 0.002 1 105 ['Trace'] 0 No entry found for query {} 2148 0.005 165.71 KiB 0.001 1 163 ['Trace'] 0 Query span trace_id for opentelemetry log: {} 1996 0.004 115.00 KiB 0.001 1 277 ['Debug'] 0.056 Submitting key {} for removal 1919 0.004 220.06 KiB 0.001 1 21 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 1908 0.004 110.78 KiB 0.001 12 12 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 1908 0.004 68.61 KiB 0 12 12 ['Trace'] 1 Flushed system log up to offset {} 1821 0.004 224.75 KiB 0.001 1 2 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 1816 0.004 72.71 KiB 0 1 1051 ['Trace'] 0 Converting aggregation data to two-level. 1735 0.004 3.70 MiB 0.022 2 37 ['Error'] 1 Database {} does not exist. Maybe you meant {}? 1624 0.003 293.29 KiB 0.002 3 117 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {} 1623 0.003 996.48 KiB 0.006 2 117 ['Trace'] 1 Request URI: {} 1557 0.003 31.93 KiB 0 2 115 ['Debug'] 0.021 Done processing query 1476 0.003 40.66 KiB 0 271 144 ['Debug'] 0.003 Key condition: {} 1420 0.003 166.02 KiB 0.001 263 144 ['Debug'] 0.004 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 1396 0.003 113.99 KiB 0.001 1 93 ['Trace'] 0 Reading {} ranges in order from part {}, approx. {} rows starting from {} 1239 0.003 64.13 KiB 0 236 135 ['Trace'] 0.004 Spreading mark ranges among streams (default reading) 1160 0.002 10.20 KiB 0 2 100 ['Trace'] 0.002 No tables 1067 0.002 342.96 KiB 0.002 602 537 ['Information'] 0.005 Setting download as failed: {} 1043 0.002 16.30 KiB 0 191 179 ['Debug'] 1 Scheduling tasks 1031 0.002 25.17 KiB 0 191 179 ['Debug'] 1 Waiting for queue updates 1031 0.002 231.34 KiB 0.001 191 179 ['Trace'] 1 scheduleTasks: initialized={}, size_before_filtering={}, queue_size={}, entries={}..{}, first_failed_task_name={}, current_tasks_size={}, last_current_task={}, last_skipped_entry_name={} 1018 0.002 29.82 KiB 0 191 179 ['Trace'] 1 Checking task {} 1018 0.002 51.70 KiB 0 191 179 ['Debug'] 1 Will schedule {} tasks starting from {} 1016 0.002 97.46 KiB 0.001 190 178 ['Debug'] 1 Will not execute task {}: {} 980 0.002 2.02 MiB 0.012 1 44 ['Error'] 1 Database {} does not exist 964 0.002 95.42 KiB 0.001 1 60 ['Trace'] 0 PREWHERE condition was split into {} steps: {} 957 0.002 144.60 KiB 0.001 1 135 ['Debug'] 0.989 Recursively remove path {}: metadata and objects were removed for [{}], only metadata were removed for [{}]. 931 0.002 46.25 KiB 0 151 158 ['Debug'] 0.85 Selected {} parts from {} to {} 929 0.002 31.74 KiB 0 1 46 ['Debug'] 0 Selected MergeAlgorithm: {} 929 0.002 73.09 KiB 0 1 46 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {} 924 0.002 118.98 KiB 0.001 1 46 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec. 924 0.002 55.23 KiB 0 147 46 ['Trace'] 0 Merged {} parts: [{}, {}] -> {} 865 0.002 166.65 KiB 0.001 1 128 ['Information'] 1 Removing metadata {} of dropped table {} 865 0.002 64.20 KiB 0 1 95 ['Debug'] 0 Waiting for table {} to be finally dropped 865 0.002 107.37 KiB 0.001 1 128 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {} 828 0.002 189.87 KiB 0.001 90 69 ['Debug'] 0.002 Executing query: {} 828 0.002 204.42 KiB 0.001 90 69 ['Debug'] 0.002 Processing task {} ({}) 826 0.002 178.47 KiB 0.001 89 68 ['Debug'] 0 Proposing query: {} 826 0.002 74.63 KiB 0 89 87 ['Trace'] 1 Waiting for initiator {} to commit or rollback entry {} 826 0.002 58.08 KiB 0 89 68 ['Debug'] 0 Waiting for worker thread to process all entries before {} 814 0.002 34.18 KiB 0 92 87 ['Trace'] 1 Too early to clean queue, will do it later. 807 0.002 211.99 KiB 0.001 89 69 ['Debug'] 0 Executed query: {} 773 0.002 97.09 KiB 0.001 414 138 ['Debug'] 0.983 Removing {} parts from filesystem (serially): Parts: [{}] 760 0.002 41.79 KiB 0 1 336 ['Trace'] 0.103 Created HTTP(S) session with {}:{} ({}:{}) 736 0.002 25.57 KiB 0 57 118 ['Debug'] 0 MinMax index condition: {} 721 0.002 57.88 KiB 0 1 541 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={} 698 0.001 48.71 KiB 0 1 187 ['Trace'] 0.759 Rolling back transaction {}{} 623 0.001 25.85 KiB 0 55 112 ['Debug'] 0.008 Reading approx. {} rows with {} streams 592 0.001 128.80 KiB 0.001 1 45 ['Debug'] 0.003 After join block: \'{}\' 592 0.001 82.18 KiB 0 1 45 ['Debug'] 0.003 Before join block: \'{}\' 583 0.001 10.82 KiB 0 529 100 ['Information'] 0.007 Starting up tables. 583 0.001 47.66 KiB 0 529 100 ['Information'] 0.007 Metadata processed, database {} has {} tables and {} dictionaries in total. 581 0.001 34.55 KiB 0 1 100 ['Information'] 0.003 Parsed metadata of {} tables in {} databases in {} sec 539 0.001 28.18 KiB 0 6 102 ['Trace'] 0.946 List of all grants: {} 539 0.001 41.58 KiB 0 6 102 ['Trace'] 0.946 Settings: readonly = {}, allow_ddl = {}, allow_introspection_functions = {} 539 0.001 53.12 KiB 0 6 102 ['Trace'] 0.946 List of all grants including implicit: {} 536 0.001 18.84 KiB 0 1 103 ['Trace'] 0 Skipping inserting block with {} rows 524 0.001 50.29 KiB 0 1 278 ['Debug'] 0.099 Will evict {} file segments (while reserving {} bytes for {}:{}) 523 0.001 9.19 KiB 0 518 105 ['Debug'] 0.036 Loading data parts 518 0.001 11.63 KiB 0 515 102 ['Debug'] 0.031 There are no data parts 517 0.001 27.10 KiB 0 1 45 ['Debug'] 0.004 ({}) Keys: {} 517 0.001 42.67 KiB 0 1 50 ['Trace'] 0.012 ({}) Join data is being destroyed, {} bytes and {} rows in hash table 517 0.001 92.04 KiB 0.001 1 45 ['Debug'] 0.004 ({}) Datatype: {}, kind: {}, strictness: {}, right header: {} 512 0.001 82.01 KiB 0 14 434 ['Debug'] 0 Sent data for {} scalars, total {} rows in {} sec., {} rows/sec., {} ({}/sec.), compressed {} times to {} ({}/sec.) 474 0.001 65.96 KiB 0 12 56 ['Debug'] 0 Part: {}, sum_marks: {}, approx mark size: {}, prefetch_step_bytes: {}, prefetch_step_marks: {}, (ranges: {}) 470 0.001 35.34 KiB 0 470 123 ['Information'] 1 dropAllData: remove format_version.txt, detached, moving and write ahead logs 470 0.001 22.49 KiB 0 470 123 ['Trace'] 1 dropAllData: removing all data parts from memory. 470 0.001 27.20 KiB 0 470 123 ['Trace'] 1 dropAllData: removing data parts (count {}) from filesystem. 470 0.001 30.29 KiB 0 470 123 ['Information'] 1 dropAllData: removing table directory recursive to cleanup garbage Top messages without format string (fmt::runtime): count pattern runtime_message line UInt64 String String Tuple(String, UInt64) 21 Gatheringmetadata Gathering metadata (1) ('/BackupEntriesCollector.cpp',141) 10 CodeDBExceptionReceivedfromDBExc Code: 241. DB::Exception: Received from 127.0.0.3:9000. DB::Exception: Memory tracker (for query): fault injected. Would use 20.29 MiB (attempt to allocate chunk of 1080676 bytes), maximum: 9.31 GiB: (while reading column CounterID): (while reading from pa ('/executeQuery.cpp',207) 9 PocoExceptionCodeecodeIOerrorBro Poco::Exception. Code: 1000, e.code() = 32, I/O error: Broken pipe, Stack trace (when copying this message, always include the lines below):\n\n0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:134: Poco::Exception::Exception(String const&, i ('/Exception.cpp',235) 7 Runningposttasks Running post-tasks ('/BackupEntriesCollector.cpp',141) 7 Extractingdatafromtables Extracting data from tables ('/BackupEntriesCollector.cpp',141) 6 CodeDBExceptionFailedtodecryptOp Code: 454. DB::Exception: Failed to decrypt. OpenSSL error code: 503316603: While processing ignore(decrypt(\'aes-128-ecb\', \'[HIDDEN]\')). (OPENSSL_ERROR) (version 23.8.16.43.altinitystable (altinity build)) (from [::1]:38356) (comment: 01318_decrypt.sql) (i ('/executeQuery.cpp',207) 6 PocoExceptionCodeecodeNetExcepti Poco::Exception. Code: 1000, e.code() = 107, Net Exception: Socket is not connected, Stack trace (when copying this message, always include the lines below):\n\n0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:134: Poco::Exception::Exception ('/Exception.cpp',235) 4 Creatingtables Creating tables ('/RestorerFromBackup.cpp',148) 4 CodeDBExceptionTherequestsignatu Code: 499. DB::Exception: The request signature we calculated does not match the signature you provided. Check your key and signing method. (S3_ERROR) (version 23.8.16.43.altinitystable (altinity build)) (from [::1]:39576) (comment: 02843_backup_use_same_s ('/executeQuery.cpp',207) 4 Insertingdatatotables Inserting data to tables ('/RestorerFromBackup.cpp',148) 4 CodeDBErrnoExceptionCannotopenfi Code: 107. DB::ErrnoException: Cannot open file /var/lib/clickhouse/user_files/nonexistent.txt, errno: 2, strerror: No such file or directory: While processing file(\'nonexistent.txt\'). (FILE_DOESNT_EXIST) (version 23.8.16.43.altinitystable (altinity build) ('/executeQuery.cpp',207) 4 Creatingdatabases Creating databases ('/RestorerFromBackup.cpp',148) 4 Findingtablesinbackup Finding tables in backup ('/RestorerFromBackup.cpp',148) 3 Connectingtomysqldbasusermysqlus Connecting to mysql_db@127.123.0.1:3306 as user mysql_user ('',0) 3 Connectiontomysqldbasusermysqlus Connection to mysql_db@127.123.0.1:3306 as user mysql_user failed: mysqlxx::ConnectionFailed: Can\'t connect to MySQL server on \'127.123.0.1\' (115) ((nullptr):0) ('',0) 3 CreatinganewMySQLconnectiontomys Creating a new MySQL connection to mysql_db@127.123.0.1:3306 as user mysql_user with settings: connect_timeout=10, read_write_timeout=300 ('',0) 3 Connectiontomysqlfailedtimes Connection to mysql failed 1 times ('',0) 3 IfthesignaturecheckfailedThiscou If the signature check failed. This could be because of a time skew. Attempting to adjust the signer. ('/AWSLogger.cpp',71) 3 mysqlxxConnectionFailed mysqlxx::ConnectionFailed ('',0) 2 CodeDBErrnoExceptionCannotrename Code: 521. DB::ErrnoException: Cannot rename /var/lib/clickhouse/metadata/test.sql.tmp to /var/lib/clickhouse/metadata/test.sql because the second path already exists, errno: 17, strerror: File exists. (ATOMIC_RENAME_FAIL) (version 23.8.16.43.altinitystabl ('/executeQuery.cpp',207) 2 CreatedMySQLPoolwithsettingsconn Created MySQL Pool with settings: connect_timeout=10, read_write_timeout=300, default_connections_number=1, max_connections_number=16 ('',0) 2 CodeDBExceptionCannotmodifyallow Code: 392. DB::Exception: Cannot modify \'allow_ddl\' setting when DDL queries are prohibited for the user. (QUERY_IS_PROHIBITED) (version 23.8.16.43.altinitystable (altinity build)) (from [::1]:46578) (comment: 00716_allow_ddl.sql) (in query: SET allow_ddl ('/executeQuery.cpp',207) 2 CodeDBExceptionCouldnotlistobjec Code: 499. DB::Exception: Could not list objects in bucket \'datasets-documentation\' with prefix \'MyPrefix/BU - UNIT - 1/\', S3 exception: `InvalidAccessKeyId`, message: \'The AWS Access Key Id you provided does not exist in our records.\'. (S3_ERROR) (version ('/executeQuery.cpp',207) 1 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',42) 1 INITRAFTSERVERcommitindextermele === INIT RAFT SERVER ===\ncommit index 261\nterm 2\nelection timer allowed\nlog store start 1, end 261\nconfig log idx 18, prev log idx 1 ('/LoggerWrapper.h',42) 1 Thesettingmergetreemetadatacache The setting \'merge_tree_metadata_cache\' is enabled. But the feature of \'metadata cache in RocksDB\' is experimental and is not ready for production. The usage of this feature can lead to data corruption and loss. The setting should be disabled in production ('',0) 1 TablesystemsessionlogisenabledIt Table system.session_log is enabled. It\'s unreliable and may contain garbage. Do not use it for any kind of security monitoring. ('',0) 1 PocoExceptionCodeecodeExceptionC Poco::Exception. Code: 1000, e.code() = 0, Exception: Connections to mysql failed: mysql_db@127.123.0.1:3306 as user mysql_user, ERROR 2002 : mysqlxx::ConnectionFailed: Can\'t connect to MySQL server on \'127.123.0.1\' (115) ((nullptr):0) (version 23.8.16.43. ('/executeQuery.cpp',207) 1 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',42) 1 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',42) Top messages that does not match its format string: message_format_string count() any_message LowCardinality(String) UInt64 String {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 236 /var/lib/clickhouse/disks/s3/store/262/2627399a-0249-49a2-8cee-1777824a918f/tmp_insert_202412_116_116_0/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 1 similar messages) 116 Poco::Exception. Code: 1000, e.code() = 32, I/O error: Broken pipe, Stack trace (when copying this message, always include the lines below):\n\n0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:134: Poco::Exception::Exception(String const&, int) @ 0x000000001f616b03 in /usr/bin/clickhouse\n1. ./build_docker/./base/poco/Foundation/src/Exception.cpp:164: Poco::IOException::IOException(String const&, int) @ 0x000000001f622aaa in /usr/bin/clickhouse\n2. ./build_docker/./base/poco/Net/src/SocketImpl.cpp:1008: Poco::Net::SocketImpl::error(int, String const&) @ 0x000000001f44066d in /usr/bin/clickhouse\n3. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: Poco::Net::SocketImpl::sendBytes(void const*, int, int) @ 0x000000001f441eb2 in /usr/bin/clickhouse\n4. ./build_docker/./base/poco/Net/src/StreamSocketImpl.cpp:0: Poco::Net::StreamSocketImpl::sendBytes(void const*, int, int) @ 0x000000001f449a4e in /usr/bin/clickhouse\n5. ./build_docker/./base/poco/Net/src/StreamSocket.cpp:114: Poco::Net::StreamSocket::sendBytes(void const*, int, int) @ 0x000000001f447988 in /usr/bin/clickhouse\n6. ./build_docker/./base/poco/Net/src/HTTPSession.cpp:144: Poco::Net::HTTPSession::write(char const*, long) @ 0x000000001f41788d in /usr/bin/clickhouse\n7. ./build_docker/./base/poco/Net/src/HTTPChunkedStream.cpp:146: Poco::Net::HTTPChunkedStreamBuf::writeToDevice(char const*, long) @ 0x000000001f3f80c4 in /usr/bin/clickhouse\n8. ./build_docker/./base/poco/Foundation/include/Poco/BufferedStreamBuf.h:0: Poco::BasicBufferedStreamBuf, Poco::BufferAllocator>::sync() @ 0x000000001f3a995f in /usr/bin/clickhouse\n9. ./build_docker/./base/poco/Net/src/HTTPChunkedStream.cpp:55: Poco::Net::HTTPChunkedIOS::~HTTPChunkedIOS() @ 0x000000001f3f8581 in /usr/bin/clickhouse\n10. ./build_docker/./base/poco/Net/src/HTTPChunkedStream.cpp:207: Poco::Net::HTTPChunkedOutputStream::~HTTPChunkedOutputStream() @ 0x000000001f3f92b4 in /usr/bin/clickhouse\n11. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:313: std::__shared_ptr_emplace>::__on_zero_shared() @ 0x000000001af4fd28 in /usr/bin/clickhouse\n12. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:216: DB::HTTPServerConnection::run() @ 0x000000001af4b247 in /usr/bin/clickhouse\n13. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000001f44b1e3 in /usr/bin/clickhouse\n14. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000001f44ba5b in /usr/bin/clickhouse\n15. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x000000001f6a31e7 in /usr/bin/clickhouse\n16. ./build_docker/./base/poco/Foundation/src/Thread.cpp:46: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x000000001f6a14d0 in /usr/bin/clickhouse\n17. ./build_docker/./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001f69fa8a in /usr/bin/clickhouse\n18. __tsan_thread_start_func @ 0x0000000007bf996f in /usr/bin/clickhouse\n19. ? @ 0x00007f4532b43ac3 in ?\n20. ? @ 0x00007f4532bd5850 in ?\n (version 23.8.16.43.altinitystable (altinity build)) Top short messages: c message_format_string substring(any(message), 1, 120) min_length_without_exception_boilerplate UInt64 LowCardinality(String) String Int64 15 Session expired void DB::StorageReplicatedMergeTree::mutationsUpdatingTask(): Code: 999. Coordination::Exception: Session expired. (KEEP 89 7 {} building file infos -7 4 Froze {} parts Froze 10 parts -13 4 Creating {}: {} Creating table test_pfazseew.data_1: CREATE TABLE IF NOT EXISTS test_pfazseew.data_1 (`key` Int32) ENGINE = MergeTree OR 656 3 Found {} on {} Found snapshot_261.bin.zstd on LocalSnapshotDisk 21 Top messages by level: (0.0699573310194643,'Table is in readonly mode (replica path: {})') Error (0.0001642734689923297,'Client has gone away.') Warning (0.002247176813010459,'Setting download as failed: {}') Information (0.04592075279370201,'(from {}{}{}){}{} {} (stage: {})') Debug (0.06134982245828928,'Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.)') Trace 2024-12-17 01:26:22,265 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 + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=1738 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1738. The process with pid = 1738 is running. Sent terminate signal to process with pid 1738. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1738. The process with pid = 1738 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1738. The process with pid = 1738 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1738. The process with pid = 1738 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1738. The process with pid = 1738 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1738. The process with pid = 1738 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1738. The process with pid = 1738 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1738. The process with pid = 1738 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1738. The process with pid = 1738 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1738. The process with pid = 1738 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 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 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 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 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 + start + counter=0 + 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' 127.0.0.1 - - [17/Dec/2024:00:26:33 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [17/Dec/2024:00:26:33 +0000] "PUT /devstoreaccount1/cont/uudsppdfsbihlqlhmieczlgzmrvambnw?blockid=mjuhctbxveghghcqtjrlhtphixlzocbzbyhnxctdtrthybkgzjmziuecyxnmhust&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [17/Dec/2024:00:26:33 +0000] "PUT /devstoreaccount1/cont/uudsppdfsbihlqlhmieczlgzmrvambnw?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [17/Dec/2024:00:26:33 +0000] "GET /devstoreaccount1/cont/uudsppdfsbihlqlhmieczlgzmrvambnw HTTP/1.1" 206 4 Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 127.0.0.1 - - [17/Dec/2024:00:26:33 +0000] "GET /devstoreaccount1/cont/uudsppdfsbihlqlhmieczlgzmrvambnw HTTP/1.1" 206 2 127.0.0.1 - - [17/Dec/2024:00:26:33 +0000] "DELETE /devstoreaccount1/cont/uudsppdfsbihlqlhmieczlgzmrvambnw HTTP/1.1" 202 - + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ kill -l SIGRTMIN + RTMIN=34 + echo ' set follow-fork-mode parent handle SIGHUP nostop noprint pass handle SIGINT nostop noprint pass handle SIGQUIT nostop noprint pass handle SIGPIPE nostop noprint pass handle SIGTERM nostop noprint pass handle SIGUSR1 nostop noprint pass handle SIGUSR2 nostop noprint pass handle SIG34 nostop noprint pass info signals continue backtrace full thread apply all backtrace full info registers disassemble /s up disassemble /s up disassemble /s p "done" detach quit ' + sleep 5 + ts '%Y-%m-%d %H:%M:%S' ++ cat /var/run/clickhouse-server/clickhouse-server.pid + gdb -batch -command script.gdb -p 45766 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + check_server_start + clickhouse-client --query 'SELECT '\''Server successfully started'\'', '\''OK'\'', NULL, '\'''\''' + '[' -s /test_output/application_errors.txt ']' + rm /test_output/application_errors.txt rm: cannot remove '/test_output/application_errors.txt': No such file or directory + stop + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=45766 + clickhouse stop --max-tries 90 --do-not-kill script.gdb:13: Error in sourced command file: No stack. /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 45766. The process with pid = 45766 is running. Sent terminate signal to process with pid 45766. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 45766. The process with pid = 45766 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 45766. The process with pid = 45766 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 45766. The process with pid = 45766 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 45766. The process with pid = 45766 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 45766. The process with pid = 45766 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 + rg -Fa ================== /var/log/clickhouse-server/stderr.log + rg -v 'in query:' + rg -Fa WARNING /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 + echo -e 'No lost s3 keys\tOK\t\N\t' + '[' -s /test_output/no_such_key_errors.txt ']' + rm /test_output/no_such_key_errors.txt + rg -Fa '########################################' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'Not crashed\tOK\t\N\t' + rg -Fa ' ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No fatal messages in clickhouse-server.log\tOK\t\N\t' + '[' -s /test_output/fatal_messages.txt ']' + rm /test_output/fatal_messages.txt + rg -Faz '########################################' /test_output/gdb.log /test_output/stress_run_logs.tar.zst /test_output/test_results.tsv + rg -Fa ' received signal ' /test_output/gdb.log + dmesg -T + grep -q -F -e 'Out of memory: Killed process' -e 'oom_reaper: reaped process' -e oom-kill:constraint=CONSTRAINT_NONE /test_output/dmesg.log + echo -e 'No OOM in dmesg\tOK\t\N\t' + tar -chf /test_output/coordination.tar /var/lib/clickhouse/coordination tar: Removing leading `/' from member names tar: Removing leading `/' from hard link targets + collect_query_and_trace_logs + for table in query_log trace_log + clickhouse-local --path /var/lib/clickhouse/ --only-system-tables -q 'select * from system.query_log format TSVWithNamesAndTypes' + zstd --threads=0 + for table in query_log trace_log + clickhouse-local --path /var/lib/clickhouse/ --only-system-tables -q 'select * from system.trace_log format TSVWithNamesAndTypes' + zstd --threads=0 + 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 core