+ 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.11.29.altinitystable_amd64.deb Selecting previously unselected package clickhouse-common-static. (Reading database ... 58438 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static_23.8.11.29.altinitystable_amd64.deb ... Unpacking clickhouse-common-static (23.8.11.29.altinitystable) ... Setting up clickhouse-common-static (23.8.11.29.altinitystable) ... + dpkg -i package_folder/clickhouse-common-static-dbg_23.8.11.29.altinitystable_amd64.deb Selecting previously unselected package clickhouse-common-static-dbg. (Reading database ... 58452 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static-dbg_23.8.11.29.altinitystable_amd64.deb ... Unpacking clickhouse-common-static-dbg (23.8.11.29.altinitystable) ... Setting up clickhouse-common-static-dbg (23.8.11.29.altinitystable) ... + dpkg -i package_folder/clickhouse-server_23.8.11.29.altinitystable_amd64.deb Selecting previously unselected package clickhouse-server. (Reading database ... 58461 files and directories currently installed.) Preparing to unpack .../clickhouse-server_23.8.11.29.altinitystable_amd64.deb ... Unpacking clickhouse-server (23.8.11.29.altinitystable) ... Setting up clickhouse-server (23.8.11.29.altinitystable) ... 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.11.29.altinitystable_amd64.deb Selecting previously unselected package clickhouse-client. (Reading database ... 58480 files and directories currently installed.) Preparing to unpack .../clickhouse-client_23.8.11.29.altinitystable_amd64.deb ... Unpacking clickhouse-client (23.8.11.29.altinitystable) ... Setting up clickhouse-client (23.8.11.29.altinitystable) ... + 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=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 '' ]] + 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=32098980 + total_mem=32869355520 + max_server_memory_usage_to_ram_ratio=0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat Setting max_server_memory_usage_to_ram_ratio to 0.5 Setting max_memory_usage_for_user=9860806656 and max_memory_usage for queries to 10G + local max_users_mem + max_users_mem=9860806656 + echo 'Setting max_memory_usage_for_user=9860806656 and max_memory_usage for queries to 10G' + cat + 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 + [[ 0 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=1 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 1 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=2 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 2 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=3 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 3 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=4 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 4 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=5 + curl --silent --verbose http://localhost:11111 + grep AccessDenied 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 + [[ 8 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + 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 trying to connect to minio + [[ 10 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 API: http://172.17.0.2:11111 http://127.0.0.1:11111 Console: http://172.17.0.2:44067 http://127.0.0.1:44067 Documentation: https://docs.min.io WARNING: Console endpoint is listening on a dynamic port (44067), please use --console-address ":PORT" to choose a static port. + counter=11 + curl --silent --verbose http://localhost:11111 + grep AccessDenied AccessDeniedAccess Denied./17CA7D5D531644CAd23f6b12-fef8-4242-a3fb-364a3e561457 + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 248 root 10u IPv6 34319 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 02731.arrow + for file in $(ls "${data_path}") + echo 02731.arrow + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow clickminio/test/02731.arrow `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow` -> `clickminio/test/02731.arrow` Total: 0 B, Transferred: 3.82 MiB, Speed: 122.72 MiB/s + 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 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: 96.60 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.91 KiB/s b.tsv + for file in $(ls "${data_path}") + echo b.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv clickminio/test/b.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv` -> `clickminio/test/b.tsv` Total: 0 B, Transferred: 33 B, Speed: 5.64 KiB/s + 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 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.75 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: 7.07 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 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 15 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=16 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 16 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=17 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 17 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=18 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 18 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=19 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 19 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=20 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 20 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=21 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 21 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=22 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 22 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=23 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 23 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=24 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 24 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=25 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 25 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=26 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 26 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=27 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 27 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=28 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 28 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=29 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 29 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=30 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 30 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=31 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 31 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=32 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 32 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=33 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 33 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=34 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 34 -gt 120 ']' + clickhouse start --user root + sleep 0.5 127.0.0.1 - - [28/Apr/2024:16:08:06 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [28/Apr/2024:16:08:06 +0000] "PUT /devstoreaccount1/cont/jqwjigttjrynwotdluiqiyknilvnuikp?blockid=wkzkdmsjgirginbdnzybofxvqrvfvhvcmmwmabmsuamigzsuqpriirfydtzwwhdf&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [28/Apr/2024:16:08:06 +0000] "PUT /devstoreaccount1/cont/jqwjigttjrynwotdluiqiyknilvnuikp?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [28/Apr/2024:16:08:06 +0000] "GET /devstoreaccount1/cont/jqwjigttjrynwotdluiqiyknilvnuikp HTTP/1.1" 206 4 127.0.0.1 - - [28/Apr/2024:16:08:06 +0000] "GET /devstoreaccount1/cont/jqwjigttjrynwotdluiqiyknilvnuikp HTTP/1.1" 206 2 127.0.0.1 - - [28/Apr/2024:16:08:06 +0000] "DELETE /devstoreaccount1/cont/jqwjigttjrynwotdluiqiyknilvnuikp HTTP/1.1" 202 - + counter=35 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 35 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=36 + clickhouse-client --query 'SELECT 1' 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 522 + 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'\''' warning: Missing auto-load script at offset 0 in section .debug_gdb_scripts of file /usr/bin/clickhouse. Use `info auto-load python-scripts [REGEXP]' to list them. 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/wqg_77de INFO:root:Content length is 1271623680 bytes INFO:root:Downloading finished INFO:root:Will unpack data from temp path /tmp/wqg_77de to clickhouse db /var/lib/clickhouse/ INFO:root:Unpack finished INFO:root:Will remove downloaded file /tmp/wqg_77de 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/gumxdw2a INFO:root:Content length is 563968000 bytes INFO:root:Downloading finished INFO:root:Will unpack data from temp path /tmp/gumxdw2a to clickhouse db /var/lib/clickhouse/ INFO:root:Unpack finished INFO:root:Will remove downloaded file /tmp/gumxdw2a 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=522 + 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 = 522. The process with pid = 522 is running. Sent terminate signal to process with pid 522. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 522. The process with pid = 522 is running. Waiting for server to stop Found pid = 522 in the list of running processes. The process with pid = 522 is running. Waiting for server to stop Found pid = 522 in the list of running processes. The process with pid = 522 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 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 15 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=16 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 16 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=17 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 17 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=18 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 18 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=19 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 19 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=20 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 20 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=21 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 21 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=22 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 22 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=23 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 23 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=24 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 24 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=25 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 25 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=26 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 26 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=27 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 27 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=28 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 28 -gt 120 ']' + clickhouse start --user root + sleep 0.5 127.0.0.1 - - [28/Apr/2024:16:11:17 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [28/Apr/2024:16:11:17 +0000] "PUT /devstoreaccount1/cont/jvoznsnnefdmwrpfrvgpmtnobutyywge?blockid=nhjzwfprtsvzitaarvpukiusdhxrpnukzdcvtfkynfktqpspopbjyonwqujmmsaa&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [28/Apr/2024:16:11:17 +0000] "PUT /devstoreaccount1/cont/jvoznsnnefdmwrpfrvgpmtnobutyywge?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [28/Apr/2024:16:11:18 +0000] "GET /devstoreaccount1/cont/jvoznsnnefdmwrpfrvgpmtnobutyywge HTTP/1.1" 206 4 + counter=29 + clickhouse-client --query 'SELECT 1' 127.0.0.1 - - [28/Apr/2024:16:11:18 +0000] "GET /devstoreaccount1/cont/jvoznsnnefdmwrpfrvgpmtnobutyywge HTTP/1.1" 206 2 127.0.0.1 - - [28/Apr/2024:16:11:18 +0000] "DELETE /devstoreaccount1/cont/jvoznsnnefdmwrpfrvgpmtnobutyywge HTTP/1.1" 202 - Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 29 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=30 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 30 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=31 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 31 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=32 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 32 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=33 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 33 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=34 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 34 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=35 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 35 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=36 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 36 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=37 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 37 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=38 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 38 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=39 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 39 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=40 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 40 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=41 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 41 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=42 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 42 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=43 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 43 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=44 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 44 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=45 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 45 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=46 + clickhouse-client --query 'SELECT 1' 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 1038 + 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'\''' warning: Missing auto-load script at offset 0 in section .debug_gdb_scripts of file /usr/bin/clickhouse. Use `info auto-load python-scripts [REGEXP]' to list them. 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=1038 + 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 = 1038. The process with pid = 1038 is running. Sent terminate signal to process with pid 1038. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1038. The process with pid = 1038 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1038. The process with pid = 1038 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1038. The process with pid = 1038 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1038. The process with pid = 1038 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1038. The process with pid = 1038 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1038. The process with pid = 1038 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1038. The process with pid = 1038 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1038. The process with pid = 1038 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1038. The process with pid = 1038 is running. Waiting for server to stop Found pid = 1038 in the list of running processes. The process with pid = 1038 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 ++ cd /usr/share/clickhouse-test/config ++ pwd -P + SRC_PATH=/usr/share/clickhouse-test/config Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server' + mkdir -p /etc/clickhouse-server/config.d/ + mkdir -p /etc/clickhouse-server/users.d/ + mkdir -p /etc/clickhouse-client + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/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=32098980 + total_mem=32869355520 + 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=9860806656 and max_memory_usage for queries to 10G + local max_users_mem + max_users_mem=9860806656 + echo 'Setting max_memory_usage_for_user=9860806656 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 + sed 's|trace|test|' + sudo cat /etc/clickhouse-server/config.d/logger_trace.xml + mv /etc/clickhouse-server/config.d/logger_trace.xml.tmp /etc/clickhouse-server/config.d/logger_trace.xml + 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' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 15 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=16 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 16 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=17 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 17 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=18 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 18 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=19 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 19 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=20 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 20 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=21 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 21 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=22 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 22 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=23 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 23 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=24 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 24 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=25 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 25 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=26 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 26 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=27 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 27 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=28 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 28 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=29 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 29 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=30 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 30 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=31 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 31 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=32 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 32 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=33 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 33 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=34 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 34 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=35 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 35 -gt 120 ']' + clickhouse start --user root + sleep 0.5 127.0.0.1 - - [28/Apr/2024:17:19:31 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [28/Apr/2024:17:19:31 +0000] "PUT /devstoreaccount1/cont/xaqjpyafzncqwhsgtbbxlrwwlpwrldip?blockid=truslsaplchaaxgitzxjrfapanwarkttbkuykstcqnhrepcfvjyfujsvrbayupsa&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [28/Apr/2024:17:19:31 +0000] "PUT /devstoreaccount1/cont/xaqjpyafzncqwhsgtbbxlrwwlpwrldip?comp=blocklist HTTP/1.1" 201 - + counter=36 + clickhouse-client --query 'SELECT 1' 127.0.0.1 - - [28/Apr/2024:17:19:31 +0000] "GET /devstoreaccount1/cont/xaqjpyafzncqwhsgtbbxlrwwlpwrldip HTTP/1.1" 206 4 127.0.0.1 - - [28/Apr/2024:17:19:31 +0000] "GET /devstoreaccount1/cont/xaqjpyafzncqwhsgtbbxlrwwlpwrldip HTTP/1.1" 206 2 127.0.0.1 - - [28/Apr/2024:17:19:31 +0000] "DELETE /devstoreaccount1/cont/xaqjpyafzncqwhsgtbbxlrwwlpwrldip HTTP/1.1" 202 - Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 36 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=37 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 37 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=38 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 38 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=39 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 39 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=40 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 40 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=41 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 41 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=42 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 42 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=43 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 43 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=44 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 44 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=45 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 45 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=46 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 46 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=47 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 47 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=48 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 48 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=49 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 49 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=50 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 50 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=51 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 51 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=52 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 52 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=53 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 53 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=54 + clickhouse-client --query 'SELECT 1' 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 1927 + 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'\''' warning: Missing auto-load script at offset 0 in section .debug_gdb_scripts of file /usr/bin/clickhouse. Use `info auto-load python-scripts [REGEXP]' to list them. 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-04-28 19:21:27,371 Run func tests '/usr/bin/clickhouse-test --global_time_limit=1200 ' 2024-04-28 19:21:27,872 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-04-28 19:21:28,373 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 use_query_cache=1 --global_time_limit=1200 ' 2024-04-28 19:21:28,874 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_3 --client-option join_algorithm='partial_merge' use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-04-28 19:21:29,376 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 ' 2024-04-28 19:21:29,877 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' use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-04-28 19:21:30,378 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-04-28 19:21:30,879 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_7 --client-option join_use_nulls=1 join_algorithm='grace_hash' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-04-28 19:21:31,380 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-04-28 19:21:31,882 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-04-28 19:21:32,383 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 ' 2024-04-28 19:21:32,884 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-04-28 19:21:33,385 Run func tests '/usr/bin/clickhouse-test --order=random --client-option use_query_cache=1 implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 --global_time_limit=1200 ' 2024-04-28 19:21:33,886 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_13 --client-option join_use_nulls=1 join_algorithm='partial_merge' use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-04-28 19:21:34,387 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 --global_time_limit=1200 ' 2024-04-28 19:21:34,888 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_merge' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-04-28 19:21:35,389 Will wait functests to finish 2024-04-28 19:21:35,389 Finished 0 from 16 processes 2024-04-28 19:21:40,392 Finished 0 from 16 processes 2024-04-28 19:21:45,396 Finished 0 from 16 processes 2024-04-28 19:21:50,400 Finished 0 from 16 processes 2024-04-28 19:21:55,405 Finished 0 from 16 processes 2024-04-28 19:22:00,408 Finished 0 from 16 processes 2024-04-28 19:22:05,412 Finished 0 from 16 processes 2024-04-28 19:22:10,416 Finished 0 from 16 processes 2024-04-28 19:22:15,420 Finished 0 from 16 processes 2024-04-28 19:22:20,424 Finished 0 from 16 processes 2024-04-28 19:22:25,428 Finished 0 from 16 processes 2024-04-28 19:22:30,432 Finished 0 from 16 processes 2024-04-28 19:22:35,436 Finished 0 from 16 processes 2024-04-28 19:22:40,440 Finished 0 from 16 processes 2024-04-28 19:22:45,440 Finished 0 from 16 processes 2024-04-28 19:22:50,444 Finished 0 from 16 processes 2024-04-28 19:22:55,448 Finished 0 from 16 processes 2024-04-28 19:23:00,453 Finished 0 from 16 processes 2024-04-28 19:23:05,457 Finished 0 from 16 processes 2024-04-28 19:23:10,460 Finished 0 from 16 processes 2024-04-28 19:23:15,464 Finished 0 from 16 processes 2024-04-28 19:23:20,469 Finished 0 from 16 processes 2024-04-28 19:23:25,473 Finished 0 from 16 processes 2024-04-28 19:23:30,476 Finished 0 from 16 processes 2024-04-28 19:23:35,480 Finished 0 from 16 processes 2024-04-28 19:23:40,485 Finished 0 from 16 processes 2024-04-28 19:23:45,488 Finished 0 from 16 processes 2024-04-28 19:23:50,492 Finished 0 from 16 processes 2024-04-28 19:23:55,494 Finished 0 from 16 processes 2024-04-28 19:24:00,496 Finished 0 from 16 processes 2024-04-28 19:24:05,502 Finished 0 from 16 processes 2024-04-28 19:24:10,507 Finished 0 from 16 processes 2024-04-28 19:24:15,512 Finished 0 from 16 processes 2024-04-28 19:24:20,516 Finished 0 from 16 processes 2024-04-28 19:24:25,520 Finished 0 from 16 processes 2024-04-28 19:24:30,525 Finished 0 from 16 processes 2024-04-28 19:24:35,530 Finished 0 from 16 processes 2024-04-28 19:24:40,532 Finished 0 from 16 processes 2024-04-28 19:24:45,532 Finished 0 from 16 processes 2024-04-28 19:24:50,537 Finished 0 from 16 processes 2024-04-28 19:24:55,540 Finished 0 from 16 processes 2024-04-28 19:25:00,544 Finished 0 from 16 processes 2024-04-28 19:25:05,548 Finished 0 from 16 processes 2024-04-28 19:25:10,553 Finished 0 from 16 processes 2024-04-28 19:25:15,558 Finished 0 from 16 processes 2024-04-28 19:25:20,563 Finished 0 from 16 processes 2024-04-28 19:25:25,568 Finished 0 from 16 processes 2024-04-28 19:25:30,573 Finished 0 from 16 processes 2024-04-28 19:25:35,576 Finished 0 from 16 processes 2024-04-28 19:25:40,580 Finished 0 from 16 processes 2024-04-28 19:25:45,584 Finished 0 from 16 processes 2024-04-28 19:25:50,588 Finished 0 from 16 processes 2024-04-28 19:25:55,591 Finished 0 from 16 processes 2024-04-28 19:26:00,596 Finished 0 from 16 processes 2024-04-28 19:26:05,600 Finished 0 from 16 processes 2024-04-28 19:26:10,605 Finished 0 from 16 processes 2024-04-28 19:26:15,609 Finished 0 from 16 processes 2024-04-28 19:26:20,612 Finished 0 from 16 processes 2024-04-28 19:26:25,616 Finished 0 from 16 processes 2024-04-28 19:26:30,621 Finished 0 from 16 processes 2024-04-28 19:26:35,624 Finished 0 from 16 processes 2024-04-28 19:26:40,628 Finished 0 from 16 processes 2024-04-28 19:26:45,632 Finished 0 from 16 processes 2024-04-28 19:26:50,636 Finished 0 from 16 processes 2024-04-28 19:26:55,641 Finished 0 from 16 processes 2024-04-28 19:27:00,644 Finished 0 from 16 processes 2024-04-28 19:27:05,648 Finished 0 from 16 processes 2024-04-28 19:27:10,653 Finished 0 from 16 processes 2024-04-28 19:27:15,656 Finished 0 from 16 processes 2024-04-28 19:27:20,661 Finished 0 from 16 processes 2024-04-28 19:27:25,664 Finished 0 from 16 processes 2024-04-28 19:27:30,668 Finished 0 from 16 processes 2024-04-28 19:27:35,672 Finished 0 from 16 processes 2024-04-28 19:27:40,672 Finished 0 from 16 processes 2024-04-28 19:27:45,676 Finished 0 from 16 processes 2024-04-28 19:27:50,681 Finished 0 from 16 processes 2024-04-28 19:27:55,685 Finished 0 from 16 processes 2024-04-28 19:28:00,688 Finished 0 from 16 processes 2024-04-28 19:28:05,692 Finished 0 from 16 processes 2024-04-28 19:28:10,696 Finished 0 from 16 processes 2024-04-28 19:28:15,700 Finished 0 from 16 processes 2024-04-28 19:28:20,704 Finished 0 from 16 processes 2024-04-28 19:28:25,709 Finished 0 from 16 processes 2024-04-28 19:28:30,713 Finished 0 from 16 processes 2024-04-28 19:28:35,716 Finished 0 from 16 processes 2024-04-28 19:28:40,720 Finished 0 from 16 processes 2024-04-28 19:28:45,725 Finished 0 from 16 processes 2024-04-28 19:28:50,728 Finished 0 from 16 processes 2024-04-28 19:28:55,732 Finished 0 from 16 processes 2024-04-28 19:29:00,737 Finished 0 from 16 processes 2024-04-28 19:29:05,740 Finished 0 from 16 processes 2024-04-28 19:29:10,744 Finished 0 from 16 processes 2024-04-28 19:29:15,749 Finished 0 from 16 processes 2024-04-28 19:29:20,752 Finished 0 from 16 processes 2024-04-28 19:29:25,756 Finished 0 from 16 processes 2024-04-28 19:29:30,760 Finished 0 from 16 processes 2024-04-28 19:29:35,765 Finished 0 from 16 processes 2024-04-28 19:29:40,769 Finished 0 from 16 processes 2024-04-28 19:29:45,774 Finished 0 from 16 processes 2024-04-28 19:29:50,776 Finished 0 from 16 processes 2024-04-28 19:29:55,780 Finished 0 from 16 processes 2024-04-28 19:30:00,784 Finished 0 from 16 processes 2024-04-28 19:30:05,788 Finished 0 from 16 processes 2024-04-28 19:30:10,793 Finished 0 from 16 processes 2024-04-28 19:30:15,796 Finished 1 from 16 processes 2024-04-28 19:30:20,799 Finished 1 from 16 processes 2024-04-28 19:30:25,804 Finished 1 from 16 processes 2024-04-28 19:30:30,808 Finished 1 from 16 processes 2024-04-28 19:30:35,812 Finished 1 from 16 processes 2024-04-28 19:30:40,816 Finished 1 from 16 processes 2024-04-28 19:30:45,821 Finished 1 from 16 processes 2024-04-28 19:30:50,824 Finished 1 from 16 processes 2024-04-28 19:30:55,827 Finished 1 from 16 processes 2024-04-28 19:31:00,832 Finished 1 from 16 processes 2024-04-28 19:31:05,832 Finished 1 from 16 processes 2024-04-28 19:31:10,837 Finished 1 from 16 processes 2024-04-28 19:31:15,840 Finished 1 from 16 processes 2024-04-28 19:31:20,844 Finished 1 from 16 processes 2024-04-28 19:31:25,848 Finished 1 from 16 processes 2024-04-28 19:31:30,852 Finished 1 from 16 processes 2024-04-28 19:31:35,857 Finished 1 from 16 processes 2024-04-28 19:31:40,862 Finished 1 from 16 processes 2024-04-28 19:31:45,867 Finished 1 from 16 processes 2024-04-28 19:31:50,872 Finished 1 from 16 processes 2024-04-28 19:31:55,873 Finished 1 from 16 processes 2024-04-28 19:32:00,876 Finished 1 from 16 processes 2024-04-28 19:32:05,880 Finished 1 from 16 processes 2024-04-28 19:32:10,884 Finished 1 from 16 processes 2024-04-28 19:32:15,889 Finished 1 from 16 processes 2024-04-28 19:32:20,893 Finished 1 from 16 processes 2024-04-28 19:32:25,896 Finished 1 from 16 processes 2024-04-28 19:32:30,900 Finished 1 from 16 processes 2024-04-28 19:32:35,904 Finished 1 from 16 processes 2024-04-28 19:32:40,908 Finished 1 from 16 processes 2024-04-28 19:32:45,910 Finished 1 from 16 processes 2024-04-28 19:32:50,912 Finished 1 from 16 processes 2024-04-28 19:32:55,917 Finished 1 from 16 processes 2024-04-28 19:33:00,922 Finished 1 from 16 processes 2024-04-28 19:33:05,926 Finished 1 from 16 processes 2024-04-28 19:33:10,931 Finished 1 from 16 processes 2024-04-28 19:33:15,932 Finished 1 from 16 processes 2024-04-28 19:33:20,936 Finished 1 from 16 processes 2024-04-28 19:33:25,940 Finished 1 from 16 processes 2024-04-28 19:33:30,944 Finished 1 from 16 processes 2024-04-28 19:33:35,948 Finished 1 from 16 processes 2024-04-28 19:33:40,952 Finished 1 from 16 processes 2024-04-28 19:33:45,956 Finished 1 from 16 processes 2024-04-28 19:33:50,960 Finished 1 from 16 processes 2024-04-28 19:33:55,964 Finished 1 from 16 processes 2024-04-28 19:34:00,968 Finished 1 from 16 processes 2024-04-28 19:34:05,973 Finished 1 from 16 processes 2024-04-28 19:34:10,976 Finished 1 from 16 processes 2024-04-28 19:34:15,980 Finished 1 from 16 processes 2024-04-28 19:34:20,984 Finished 1 from 16 processes 2024-04-28 19:34:25,988 Finished 1 from 16 processes 2024-04-28 19:34:30,990 Finished 1 from 16 processes 2024-04-28 19:34:35,992 Finished 1 from 16 processes 2024-04-28 19:34:40,996 Finished 1 from 16 processes 2024-04-28 19:34:46,002 Finished 1 from 16 processes 2024-04-28 19:34:51,004 Finished 1 from 16 processes 2024-04-28 19:34:56,008 Finished 1 from 16 processes 2024-04-28 19:35:01,013 Finished 1 from 16 processes 2024-04-28 19:35:06,017 Finished 1 from 16 processes 2024-04-28 19:35:11,020 Finished 1 from 16 processes 2024-04-28 19:35:16,024 Finished 1 from 16 processes 2024-04-28 19:35:21,028 Finished 1 from 16 processes 2024-04-28 19:35:26,032 Finished 1 from 16 processes 2024-04-28 19:35:31,037 Finished 1 from 16 processes 2024-04-28 19:35:36,041 Finished 1 from 16 processes 2024-04-28 19:35:41,046 Finished 1 from 16 processes 2024-04-28 19:35:46,048 Finished 1 from 16 processes 2024-04-28 19:35:51,052 Finished 1 from 16 processes 2024-04-28 19:35:56,056 Finished 1 from 16 processes 2024-04-28 19:36:01,060 Finished 1 from 16 processes 2024-04-28 19:36:06,064 Finished 1 from 16 processes 2024-04-28 19:36:11,068 Finished 1 from 16 processes 2024-04-28 19:36:16,072 Finished 1 from 16 processes 2024-04-28 19:36:21,076 Finished 1 from 16 processes 2024-04-28 19:36:26,081 Finished 1 from 16 processes 2024-04-28 19:36:31,086 Finished 1 from 16 processes 2024-04-28 19:36:36,088 Finished 1 from 16 processes 2024-04-28 19:36:41,092 Finished 1 from 16 processes 2024-04-28 19:36:46,096 Finished 1 from 16 processes 2024-04-28 19:36:51,100 Finished 1 from 16 processes 2024-04-28 19:36:56,104 Finished 1 from 16 processes 2024-04-28 19:37:01,104 Finished 1 from 16 processes 2024-04-28 19:37:06,109 Finished 1 from 16 processes 2024-04-28 19:37:11,114 Finished 1 from 16 processes 2024-04-28 19:37:16,116 Finished 1 from 16 processes 2024-04-28 19:37:21,120 Finished 1 from 16 processes 2024-04-28 19:37:26,124 Finished 1 from 16 processes 2024-04-28 19:37:31,128 Finished 1 from 16 processes 2024-04-28 19:37:36,133 Finished 1 from 16 processes 2024-04-28 19:37:41,138 Finished 1 from 16 processes 2024-04-28 19:37:46,142 Finished 1 from 16 processes 2024-04-28 19:37:51,144 Finished 1 from 16 processes 2024-04-28 19:37:56,149 Finished 1 from 16 processes 2024-04-28 19:38:01,152 Finished 1 from 16 processes 2024-04-28 19:38:06,156 Finished 1 from 16 processes 2024-04-28 19:38:11,160 Finished 1 from 16 processes 2024-04-28 19:38:16,164 Finished 1 from 16 processes 2024-04-28 19:38:21,168 Finished 1 from 16 processes 2024-04-28 19:38:26,172 Finished 1 from 16 processes 2024-04-28 19:38:31,176 Finished 1 from 16 processes 2024-04-28 19:38:36,181 Finished 1 from 16 processes 2024-04-28 19:38:41,186 Finished 1 from 16 processes 2024-04-28 19:38:46,191 Finished 1 from 16 processes 2024-04-28 19:38:51,192 Finished 1 from 16 processes 2024-04-28 19:38:56,196 Finished 1 from 16 processes 2024-04-28 19:39:01,201 Finished 1 from 16 processes 2024-04-28 19:39:06,204 Finished 1 from 16 processes 2024-04-28 19:39:11,208 Finished 1 from 16 processes 2024-04-28 19:39:16,212 Finished 1 from 16 processes 2024-04-28 19:39:21,216 Finished 1 from 16 processes 2024-04-28 19:39:26,220 Finished 1 from 16 processes 2024-04-28 19:39:31,224 Finished 1 from 16 processes 2024-04-28 19:39:36,228 Finished 1 from 16 processes 2024-04-28 19:39:41,232 Finished 1 from 16 processes 2024-04-28 19:39:46,233 Finished 1 from 16 processes 2024-04-28 19:39:51,236 Finished 1 from 16 processes 2024-04-28 19:39:56,241 Finished 1 from 16 processes 2024-04-28 19:40:01,246 Finished 1 from 16 processes 2024-04-28 19:40:06,250 Finished 1 from 16 processes 2024-04-28 19:40:11,252 Finished 1 from 16 processes 2024-04-28 19:40:16,256 Finished 1 from 16 processes 2024-04-28 19:40:21,260 Finished 1 from 16 processes 2024-04-28 19:40:26,264 Finished 1 from 16 processes 2024-04-28 19:40:31,268 Finished 1 from 16 processes 2024-04-28 19:40:36,272 Finished 1 from 16 processes 2024-04-28 19:40:41,274 Finished 1 from 16 processes 2024-04-28 19:40:46,278 Finished 1 from 16 processes 2024-04-28 19:40:51,280 Finished 1 from 16 processes 2024-04-28 19:40:56,284 Finished 1 from 16 processes 2024-04-28 19:41:01,288 Finished 1 from 16 processes 2024-04-28 19:41:06,292 Finished 1 from 16 processes 2024-04-28 19:41:11,296 Finished 1 from 16 processes 2024-04-28 19:41:16,301 Finished 1 from 16 processes 2024-04-28 19:41:21,304 Finished 1 from 16 processes 2024-04-28 19:41:26,309 Finished 1 from 16 processes 2024-04-28 19:41:31,313 Finished 1 from 16 processes 2024-04-28 19:41:36,318 Finished 1 from 16 processes 2024-04-28 19:41:41,321 Finished 2 from 16 processes 2024-04-28 19:41:46,324 Finished 2 from 16 processes 2024-04-28 19:41:51,328 Finished 5 from 16 processes 2024-04-28 19:41:56,332 Finished 6 from 16 processes 2024-04-28 19:42:01,337 Finished 8 from 16 processes 2024-04-28 19:42:06,342 Finished 8 from 16 processes 2024-04-28 19:42:11,347 Finished 9 from 16 processes 2024-04-28 19:42:16,352 Finished 9 from 16 processes 2024-04-28 19:42:21,356 Finished 10 from 16 processes 2024-04-28 19:42:26,360 Finished 10 from 16 processes 2024-04-28 19:42:31,364 Finished 11 from 16 processes 2024-04-28 19:42:36,368 Finished 11 from 16 processes 2024-04-28 19:42:41,372 Finished 11 from 16 processes 2024-04-28 19:42:46,377 Finished 11 from 16 processes 2024-04-28 19:42:51,382 Finished 11 from 16 processes 2024-04-28 19:42:56,384 Finished 12 from 16 processes 2024-04-28 19:43:01,389 Finished 12 from 16 processes 2024-04-28 19:43:06,392 Finished 12 from 16 processes 2024-04-28 19:43:11,396 Finished 12 from 16 processes 2024-04-28 19:43:16,400 Finished 12 from 16 processes 2024-04-28 19:43:21,404 Finished 12 from 16 processes 2024-04-28 19:43:26,408 Finished 13 from 16 processes 2024-04-28 19:43:31,412 Finished 13 from 16 processes 2024-04-28 19:43:36,416 Finished 13 from 16 processes 2024-04-28 19:43:41,421 Finished 13 from 16 processes 2024-04-28 19:43:46,424 Finished 13 from 16 processes 2024-04-28 19:43:51,429 Finished 13 from 16 processes 2024-04-28 19:43:56,432 Finished 13 from 16 processes 2024-04-28 19:44:01,436 Finished 13 from 16 processes 2024-04-28 19:44:06,440 Finished 13 from 16 processes 2024-04-28 19:44:11,444 Finished 13 from 16 processes 2024-04-28 19:44:16,448 Finished 13 from 16 processes 2024-04-28 19:44:21,452 Finished 13 from 16 processes 2024-04-28 19:44:26,456 Finished 13 from 16 processes 2024-04-28 19:44:31,460 Finished 13 from 16 processes 2024-04-28 19:44:36,465 Finished 13 from 16 processes 2024-04-28 19:44:41,468 Finished 13 from 16 processes 2024-04-28 19:44:46,472 Finished 13 from 16 processes 2024-04-28 19:44:51,476 Finished 13 from 16 processes 2024-04-28 19:44:56,480 Finished 14 from 16 processes 2024-04-28 19:45:01,484 Finished 14 from 16 processes 2024-04-28 19:45:06,489 Finished 14 from 16 processes 2024-04-28 19:45:11,492 Finished 14 from 16 processes 2024-04-28 19:45:16,496 Finished 14 from 16 processes 2024-04-28 19:45:21,500 Finished 15 from 16 processes 2024-04-28 19:45:26,504 Finished 15 from 16 processes 2024-04-28 19:45:31,509 Finished 15 from 16 processes 2024-04-28 19:45:36,512 Finished 15 from 16 processes 2024-04-28 19:45:41,516 Finished 15 from 16 processes 2024-04-28 19:45:46,520 All processes finished 2024-04-28 19:45:46,520 Compressing stress logs 2024-04-28 19:45:46,531 Logs compressed 2024-04-28 19:45:46,531 Will terminate gdb (if any) Quit 2024-04-28 19:50:56,984 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. 2.45 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) 52508 0.254 2.80 MiB 0.056 1 1047 ['Trace'] 0.433 Created HTTP(S) session with {}:{} ({}:{}) 7032 0.034 532.13 KiB 0.01 1 200 ['Debug'] 0.444 Remove from cache. Key: {}, offset: {}, size: {} 7013 0.034 612.31 KiB 0.012 1 1780 ['Trace'] 0.001 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 6922 0.033 412.35 KiB 0.008 1 106 ['Debug'] 0.985 Key {} is removed from metadata 6530 0.032 370.59 KiB 0.007 1 118 ['Trace'] 0.004 Access granted: {}{} 6512 0.031 196.41 KiB 0.004 1 1753 ['Trace'] 0.001 Aggregation method: {} 5576 0.027 249.63 KiB 0.005 1 1 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 4936 0.024 563.98 KiB 0.011 993 407 ['Trace'] 0 Bypassing cache because file segment state is `PARTIALLY_DOWNLOADED_NO_CONTINUATION` and downloaded part already used 4873 0.024 856.19 KiB 0.017 1 63 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 4789 0.023 734.23 KiB 0.014 2 63 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 4164 0.02 117.68 KiB 0.002 1 63 ['Debug'] 0 Processed in {} sec. 3733 0.018 215.08 KiB 0.004 1 92 ['Debug'] 0.009 Submitting key {} for removal 3140 0.015 375.05 KiB 0.007 159 246 ['Trace'] 0.611 Renaming temporary part {} to {} with tid {}. 2941 0.014 141.15 KiB 0.003 1 239 ['Trace'] 0.579 filled checksums {} 2820 0.014 195.54 KiB 0.004 156 354 ['Trace'] 0.77 Trying to reserve {} using storage policy from min volume index {} 2723 0.013 64.59 KiB 0.001 1 100 ['Trace'] 0.014 {} -> {} 2712 0.013 215.57 KiB 0.004 1 59 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 2425 0.012 1.27 MiB 0.025 1 321 ['Debug'] 0.985 Objects with paths [{}] were removed from S3 2347 0.011 220.54 KiB 0.004 1 25 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 2293 0.011 24.63 KiB 0 1 1379 ['Trace'] 0.002 Aggregating 2254 0.011 2.75 MiB 0.055 1 310 ['Debug'] 0.985 metadata and objects were removed for [{}], only metadata were removed for [{}]. 2057 0.01 231.01 KiB 0.005 3 91 ['Debug'] 0.986 {} Authenticated with global context as user {} 2057 0.01 167.57 KiB 0.003 3 91 ['Debug'] 0.986 {} Authenticating user \'{}\' from {} 2050 0.01 180.18 KiB 0.004 3 91 ['Debug'] 0.986 {} Logout, user_id: {} 2045 0.01 165.80 KiB 0.003 1 1166 ['Trace'] 0.001 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 2042 0.01 626.44 KiB 0.012 1979 340 ['Information'] 0 Setting download as failed: {} 2023 0.01 221.27 KiB 0.004 2 63 ['Debug'] 1 {} Creating session context with user_id: {} 1804 0.009 23.90 MiB 0.478 2 128 ['Error'] 1 Table is in readonly mode (replica path: {}) 1772 0.009 94.76 KiB 0.002 1 74 ['Debug'] 0.339 Peak memory usage{}: {}. 1701 0.008 98.07 KiB 0.002 12 12 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 1701 0.008 60.70 KiB 0.001 12 12 ['Trace'] 1 Flushed system log up to offset {} 1698 0.008 136.52 KiB 0.003 1633 317 ['Trace'] 0 No space left in cache to reserve {} bytes, will continue without cache download 1411 0.007 45.87 KiB 0.001 1 63 ['Trace'] 1 TCP Request. Address: {} 1411 0.007 129.69 KiB 0.003 1 63 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 1220 0.006 133.63 KiB 0.003 1 18 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 1181 0.006 25.65 KiB 0.001 85 128 ['Trace'] 1 Execution took {} ms. 1159 0.006 30.56 KiB 0.001 1 63 ['Debug'] 1 Done processing connection. 839 0.004 158.73 KiB 0.003 2 48 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {} 839 0.004 296.67 KiB 0.006 2 48 ['Trace'] 1 Request URI: {} 822 0.004 96.11 KiB 0.002 1 37 ['Trace'] 0 No entry found for query {} 819 0.004 16.80 KiB 0 2 48 ['Debug'] 0.264 Done processing query 729 0.004 59.38 KiB 0.001 1 38 ['Trace'] 0.007 Reading {} ranges in order from part {}, approx. {} rows starting from {} 643 0.003 79.52 KiB 0.002 1 2 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 590 0.003 128.79 KiB 0.003 1 10 ['Debug'] 0 ({}) Datatype: {}, kind: {}, strictness: {}, right header: {} 590 0.003 47.77 KiB 0.001 1 10 ['Trace'] 0 ({}) Join data is being destroyed, {} bytes and {} rows in hash table 590 0.003 34.03 KiB 0.001 1 10 ['Debug'] 0 ({}) Keys: {} 557 0.003 28.49 KiB 0.001 48 133 ['Debug'] 0.842 Selected {} parts from {} to {} 553 0.003 75.65 KiB 0.001 19 127 ['Trace'] 1 Checked {} partitions, found {} partitions with parts that may be merged: [{}](max_total_size_to_merge={}, merge_with_ttl_allowed{}) 542 0.003 26.41 KiB 0.001 23 128 ['Trace'] 1 Scheduling next merge selecting task after {}ms 539 0.003 18.41 KiB 0 1 25 ['Debug'] 0 Selected MergeAlgorithm: {} 539 0.003 43.55 KiB 0.001 1 25 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {} 538 0.003 50.43 KiB 0.001 20 122 ['Trace'] 1 Insert entry {} to queue with type {} 533 0.003 69.85 KiB 0.001 1 25 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec. 532 0.003 33.12 KiB 0.001 46 25 ['Trace'] 0 Merged {} parts: [{}, {}] -> {} 470 0.002 36.26 KiB 0.001 1 44 ['Trace'] 0 Query span trace_id for opentelemetry log: {} 461 0.002 14.13 KiB 0 129 57 ['Debug'] 0.022 Key condition: {} 457 0.002 95.13 KiB 0.002 36 13 ['Information'] 1 {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 452 0.002 51.78 KiB 0.001 127 56 ['Debug'] 0.022 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 422 0.002 13.28 KiB 0 16 13 ['Debug'] 0 Requested flush up to offset {} 395 0.002 57.20 KiB 0.001 151 96 ['Debug'] 0.985 Removing {} parts from filesystem (serially): Parts: [{}] 393 0.002 36.53 KiB 0.001 19 32 ['Trace'] 0.954 Part {} local references is zero, will check blobs can be removed in zookeeper 388 0.002 26.99 KiB 0.001 1 133 ['Trace'] 0.912 Rolling back transaction {}{} 386 0.002 22.25 KiB 0 20 122 ['Debug'] 1 Pulling {} entries to queue: {} - {} 386 0.002 9.81 KiB 0 20 122 ['Debug'] 1 Pulled {} entries to queue. 375 0.002 62.55 KiB 0.001 19 18 ['Trace'] 1 Remove zookeeper lock {} for part {} 366 0.002 18.94 KiB 0 95 50 ['Trace'] 0.027 Spreading mark ranges among streams (default reading) 350 0.002 85.89 KiB 0.002 1 62 ['Trace'] 0.611 Create WriteBufferFromS3, {} 350 0.002 30.85 KiB 0.001 1 60 ['Trace'] 0.631 Close WriteBufferFromS3. {}. 349 0.002 36.64 KiB 0.001 1 95 ['Trace'] 0.613 Single part upload has completed. {}, size {} 347 0.002 7.79 KiB 0 1 288 ['Trace'] 0.012 Merging aggregated data 343 0.002 32.57 KiB 0.001 1 61 ['Trace'] 0.624 finalizeImpl WriteBufferFromS3. {}. 339 0.002 47.66 KiB 0.001 1 24 ['Trace'] 0.015 PREWHERE condition was split into {} steps: {} 333 0.002 2.93 KiB 0 2 35 ['Trace'] 0.006 No tables 324 0.002 15.51 KiB 0 14 24 ['Debug'] 0.667 Committing part {} to zookeeper 324 0.002 15.19 KiB 0 14 24 ['Debug'] 0.667 Part {} committed to zookeeper 322 0.002 16.45 KiB 0 11 10 ['Trace'] 1 Blobs of part {} cannot be removed 314 0.002 47.42 KiB 0.001 1 98 ['Debug'] 0.971 Recursively remove path {}: metadata and objects were removed for [{}], only metadata were removed for [{}]. 305 0.001 31.08 KiB 0.001 239 181 ['Trace'] 0 Predownload failed because of space limit. Will read from remote filesystem starting from offset: {} 300 0.001 38.27 KiB 0.001 200 14 ['Trace'] 1 Mutating part {} with mutation commands from {} mutations ({}): {} 300 0.001 26.40 KiB 0.001 200 14 ['Trace'] 1 Executing log entry to mutate part {} to {} 267 0.001 19.82 KiB 0 1 29 ['Debug'] 0 Waiting for table {} to be finally dropped 267 0.001 33.31 KiB 0.001 1 117 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {} 267 0.001 51.90 KiB 0.001 1 117 ['Information'] 1 Removing metadata {} of dropped table {} 259 0.001 33.28 KiB 0.001 17 9 ['Trace'] 0.992 Found {} old parts to remove. Parts: [{}] 259 0.001 33.54 KiB 0.001 17 9 ['Debug'] 0.992 Removing {} parts from memory: Parts: [{}] 221 0.001 6.60 KiB 0 12 30 ['Trace'] 1 Sending part {} 221 0.001 62.19 KiB 0.001 1 24 ['Trace'] 1 Sending request to {} 221 0.001 11.47 KiB 0 12 24 ['Trace'] 1 Disk {} (with type {}) supports zero-copy replication 221 0.001 6.29 KiB 0 12 24 ['Trace'] 1 Checking disk {} with type {} 221 0.001 18.99 KiB 0 12 24 ['Trace'] 1 Trying to fetch with zero-copy replication, but disk is not provided, will try to select 221 0.001 32.61 KiB 0.001 12 24 ['Debug'] 1 Fetching part {} from {}:{} 216 0.001 16.67 KiB 0 12 24 ['Trace'] 1 Disk for fetch is not provided, getting disk from reservation {} with type \'{}\' 216 0.001 13.93 KiB 0 12 24 ['Trace'] 1 Trying to reserve {} on the selected disk: {} (with type {}) 216 0.001 36.76 KiB 0.001 12 24 ['Trace'] 1 Zookeeper temporary ephemeral lock {} created 216 0.001 24.43 KiB 0 12 24 ['Debug'] 1 Download of part {} unique id {} metadata onto disk {} finished. 216 0.001 35.92 KiB 0.001 12 24 ['Trace'] 1 Set zookeeper temporary ephemeral lock {} 216 0.001 32.01 KiB 0.001 12 24 ['Debug'] 1 Fetched part {} from {}:{}{} 216 0.001 22.54 KiB 0 12 24 ['Debug'] 1 Downloading part {} unique id {} metadata onto disk {}. 209 0.001 6.12 KiB 0 23 101 ['Debug'] 1 Updating strategy picker state 209 0.001 16.80 KiB 0 1 188 ['Trace'] 0.005 Statistics updated for key={}: new sum_of_sizes={}, median_size={} Top messages without format string (fmt::runtime): count pattern runtime_message line UInt64 String String Tuple(String, UInt64) 8 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/contrib/llvm-project/libcxx/include/exception:134: std::exception::capture() @ 0x000000000b19ad42 in /us ('/Exception.cpp',235) 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.11.29.altinitystable (altinity build)) (from [::1]:44308) (comment: 01318_decrypt.sql) (i ('/executeQuery.cpp',207) 3 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 19 ('/LoggerWrapper.h',42) 2 CodeDBExceptionReceivedfromlocal Code: 60. DB::Exception: Received from localhost:9000. DB::Exception: Table shard_1.data_01850 does not exist. Stack trace:\n\n0. /build/contrib/llvm-project/libcxx/include/exception:134: std::exception::capture() @ 0x000000000b19ad42 in /usr/bin/clickhouse\n ('/executeQuery.cpp',207) 2 skippedconfiglatestconfig skipped config 1, latest config 19 ('/LoggerWrapper.h',42) 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.11.29.altinitystabl ('/executeQuery.cpp',207) 1 ThreadFuzzerisenabledApplication ThreadFuzzer is enabled. Application will run slowly and unstable. ('',0) 1 Serverlogginglevelissettotestand Server logging level is set to \'test\' and performance is degraded. This cannot be used in production. ('',0) 1 detectaconfigurationchangethatis detect a configuration change that is not committed yet at index 1 ('/LoggerWrapper.h',42) 1 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',42) 1 numberofpendingcommitelements number of pending commit elements: 0 ('/LoggerWrapper.h',42) 1 prevotetermisdifferentresetitto pre-vote term (0) is different, reset it to 2 ('/LoggerWrapper.h',42) 1 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 422 ('/LoggerWrapper.h',42) 1 Currentlyassignedconfigisnewerth Currently assigned config is newer than some uncomitted config. This can only happen during startup or force recovery. If that is not the case, this is a bug. ('/LoggerWrapper.h',42) 1 startingup starting up ('',0) 1 newconfigurationlogidxprevlogidx new configuration: log idx 422, prev log idx 19\npeer 1, DC ID 0, localhost:9234, voting member, 1\nmy id: 1, leader: 1, term: 3 ('/LoggerWrapper.h',42) 1 parameterselectiontimeoutrangehe parameters: election timeout range 0 - 0, heartbeat 0, leadership expiry 0, max batch 100, backoff 50, snapshot distance 10000, enable randomized snapshot creation NO, log sync stop gap 99999, reserved logs 2147483647, client timeout 10000, auto forwarding ('/LoggerWrapper.h',42) 1 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/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 newconfiglogidxprevlogidxcurconf new config log idx 422, prev log idx 19, cur config log idx 19, prev log idx 1 ('/LoggerWrapper.h',42) 1 INITRAFTSERVERcommitindextermele === INIT RAFT SERVER ===\ncommit index 0\nterm 2\nelection timer allowed\nlog store start 1, end 421\nconfig log idx 19, prev log idx 1 ('/LoggerWrapper.h',42) 1 RaftASIOlistenerinitiatedonunsec Raft ASIO listener initiated on :::9234, unsecured ('/LoggerWrapper.h',42) 1 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',42) 1 newelectiontimeoutrange new election timeout range: 0 - 0 ('/LoggerWrapper.h',42) 1 statemachinecommitindexprecommit state machine commit index 0, precommit index 421, last log index 421 ('/LoggerWrapper.h',42) 1 PocoExceptionCodeecodeNetExcepti Poco::Exception. Code: 1000, e.code() = 107, Net Exception: Socket is not connected, Stack trace (when copying this message, always include the lines below):\n\n0. /build/contrib/llvm-project/libcxx/include/exception:134: std::exception::capture() @ 0x000000 ('/Exception.cpp',235) 1 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1\nmy id: 1, voting_member\nnum peers: 0 ('/LoggerWrapper.h',42) 1 Thesettingallowremotefszerocopyr The setting \'allow_remote_fs_zero_copy_replication\' is enabled for MergeTree tables. But the feature of \'zero-copy replication\' is under development and is not ready for production. The usage of this feature can lead to data corruption and loss. The settin ('',0) 1 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',42) 1 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',42) Failed to get stats about log messages: timed out 2024-04-28 19:53:47,706 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=1927 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1927. The process with pid = 1927 is running. Sent terminate signal to process with pid 1927. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1927. The process with pid = 1927 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1927. The process with pid = 1927 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1927. The process with pid = 1927 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1927. The process with pid = 1927 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1927. The process with pid = 1927 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1927. The process with pid = 1927 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1927. The process with pid = 1927 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1927. The process with pid = 1927 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' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root 127.0.0.1 - - [28/Apr/2024:17:54:04 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [28/Apr/2024:17:54:04 +0000] "PUT /devstoreaccount1/cont/arignxfomadbvlwhdpvvvpbbsehfkgon?blockid=lzglvmtsaojgafddlrksymssocurogmbzmfccnxcdagmrvrtptjabrrvqaxwlibn&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [28/Apr/2024:17:54:04 +0000] "PUT /devstoreaccount1/cont/arignxfomadbvlwhdpvvvpbbsehfkgon?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [28/Apr/2024:17:54:04 +0000] "GET /devstoreaccount1/cont/arignxfomadbvlwhdpvvvpbbsehfkgon HTTP/1.1" 206 4 127.0.0.1 - - [28/Apr/2024:17:54:04 +0000] "GET /devstoreaccount1/cont/arignxfomadbvlwhdpvvvpbbsehfkgon HTTP/1.1" 206 2 127.0.0.1 - - [28/Apr/2024:17:54:04 +0000] "DELETE /devstoreaccount1/cont/arignxfomadbvlwhdpvvvpbbsehfkgon HTTP/1.1" 202 - + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 15 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=16 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ 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 12980 + 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'\''' warning: Missing auto-load script at offset 0 in section .debug_gdb_scripts of file /usr/bin/clickhouse. Use `info auto-load python-scripts [REGEXP]' to list them. 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=12980 + 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 = 12980. The process with pid = 12980 is running. Sent terminate signal to process with pid 12980. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12980. The process with pid = 12980 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12980. The process with pid = 12980 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12980. The process with pid = 12980 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12980. The process with pid = 12980 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12980. The process with pid = 12980 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12980. The process with pid = 12980 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12980. The process with pid = 12980 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12980. The process with pid = 12980 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12980. The process with pid = 12980 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12980. The process with pid = 12980 is running. Waiting for server to stop Found pid = 12980 in the list of running processes. The process with pid = 12980 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 + zstd --threads=0 + clickhouse-local --path /var/lib/clickhouse/ --only-system-tables -q 'select * from system.query_log format TSVWithNamesAndTypes' + 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