+ ln -s /usr/share/clickhouse-test/ci/stress.py /usr/bin/stress + ln -s /usr/share/clickhouse-test/clickhouse-test /usr/bin/clickhouse-test + source /usr/share/clickhouse-test/ci/attach_gdb.lib ++ source /usr/share/clickhouse-test/ci/utils.lib + source /usr/share/clickhouse-test/ci/stress_tests.lib ++ sysctl kernel.core_pattern=core.%e.%p-%P kernel.core_pattern = core.%e.%p-%P ++ OK='\tOK\t\N\t' ++ FAIL='\tFAIL\t\N\t' ++ FAILURE_CONTEXT_LINES=100 ++ FAILURE_CONTEXT_MAX_LINE_WIDTH=300 + install_packages package_folder + dpkg -i package_folder/clickhouse-common-static_23.8.16.41.altinitystable+tsan_amd64.deb Selecting previously unselected package clickhouse-common-static. (Reading database ... 58479 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static_23.8.16.41.altinitystable+tsan_amd64.deb ... Unpacking clickhouse-common-static (23.8.16.41.altinitystable+tsan) ... Setting up clickhouse-common-static (23.8.16.41.altinitystable+tsan) ... + dpkg -i package_folder/clickhouse-common-static-dbg_23.8.16.41.altinitystable+tsan_amd64.deb Selecting previously unselected package clickhouse-common-static-dbg. (Reading database ... 58493 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static-dbg_23.8.16.41.altinitystable+tsan_amd64.deb ... Unpacking clickhouse-common-static-dbg (23.8.16.41.altinitystable+tsan) ... Setting up clickhouse-common-static-dbg (23.8.16.41.altinitystable+tsan) ... + dpkg -i package_folder/clickhouse-server_23.8.16.41.altinitystable+tsan_amd64.deb Selecting previously unselected package clickhouse-server. (Reading database ... 58502 files and directories currently installed.) Preparing to unpack .../clickhouse-server_23.8.16.41.altinitystable+tsan_amd64.deb ... Unpacking clickhouse-server (23.8.16.41.altinitystable+tsan) ... Setting up clickhouse-server (23.8.16.41.altinitystable+tsan) ... ClickHouse binary is already located at /usr/bin/clickhouse Symlink /usr/bin/clickhouse-server already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-server to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-client to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-local to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-benchmark to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-copier already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-copier to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-obfuscator to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-git-import to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-compressor to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-format to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-extract-from-config already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-extract-from-config to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-keeper already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-keeper-converter already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper-converter to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-disks to /usr/bin/clickhouse. Creating clickhouse group if it does not exist. groupadd -r clickhouse Creating clickhouse user if it does not exist. useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse clickhouse Will set ulimits for clickhouse user in /etc/security/limits.d/clickhouse.conf. Creating config directory /etc/clickhouse-server/config.d that is used for tweaks of main server configuration. Creating config directory /etc/clickhouse-server/users.d that is used for tweaks of users configuration. Config file /etc/clickhouse-server/config.xml already exists, will keep it and extract path info from it. /etc/clickhouse-server/config.xml has /var/lib/clickhouse/ as data path. /etc/clickhouse-server/config.xml has /var/log/clickhouse-server/ as log path. Users config file /etc/clickhouse-server/users.xml already exists, will keep it and extract users info from it. Log directory /var/log/clickhouse-server/ already exists. Creating data directory /var/lib/clickhouse/. Creating pid directory /var/run/clickhouse-server. chown -R clickhouse:clickhouse '/var/log/clickhouse-server/' chown -R clickhouse:clickhouse '/var/run/clickhouse-server' chown clickhouse:clickhouse '/var/lib/clickhouse/' groupadd -r clickhouse-bridge useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse-bridge clickhouse-bridge chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-odbc-bridge' chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-library-bridge' Password for default user is empty string. See /etc/clickhouse-server/users.xml and /etc/clickhouse-server/users.d to change it. Setting capabilities for clickhouse binary. This is optional. chown -R clickhouse:clickhouse '/etc/clickhouse-server' ClickHouse has been successfully installed. Start clickhouse-server with: sudo clickhouse start Start clickhouse-client with: clickhouse-client + dpkg -i package_folder/clickhouse-client_23.8.16.41.altinitystable+tsan_amd64.deb Selecting previously unselected package clickhouse-client. (Reading database ... 58521 files and directories currently installed.) Preparing to unpack .../clickhouse-client_23.8.16.41.altinitystable+tsan_amd64.deb ... Unpacking clickhouse-client (23.8.16.41.altinitystable+tsan) ... Setting up clickhouse-client (23.8.16.41.altinitystable+tsan) ... + export THREAD_FUZZER_CPU_TIME_PERIOD_US=1000 + THREAD_FUZZER_CPU_TIME_PERIOD_US=1000 + export THREAD_FUZZER_SLEEP_PROBABILITY=0.1 + THREAD_FUZZER_SLEEP_PROBABILITY=0.1 + export THREAD_FUZZER_SLEEP_TIME_US=100000 + THREAD_FUZZER_SLEEP_TIME_US=100000 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001 + export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US=10000 + THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US=10000 + export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US=10000 + THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US=10000 + export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US=10000 + THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US=10000 + export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US=10000 + THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US=10000 + export THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01 + THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01 + export THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01 + THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01 + export ZOOKEEPER_FAULT_INJECTION=1 + ZOOKEEPER_FAULT_INJECTION=1 + configure + export USE_DATABASE_ORDINARY=1 + USE_DATABASE_ORDINARY=1 + export EXPORT_S3_STORAGE_POLICIES=1 + EXPORT_S3_STORAGE_POLICIES=1 + /usr/share/clickhouse-test/config/install.sh + DEST_SERVER_PATH=/etc/clickhouse-server + DEST_CLIENT_PATH=/etc/clickhouse-client +++ dirname /usr/share/clickhouse-test/config/install.sh ++ cd /usr/share/clickhouse-test/config ++ pwd -P + SRC_PATH=/usr/share/clickhouse-test/config + echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server' + mkdir -p /etc/clickhouse-server/config.d/ Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + mkdir -p /etc/clickhouse-server/users.d/ + mkdir -p /etc/clickhouse-client + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disks.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/metadata_cache.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/reverse_dns_query_function.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/ + '[' /etc/clickhouse-server = /etc/clickhouse-server ']' + ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/ + ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + rm -f /etc/clickhouse-server/config.d/zookeeper.xml + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/ + create_snapshot_on_exit=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 trying to connect to minio + [[ 0 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=1 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 1 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=2 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 2 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=3 + grep AccessDenied + curl --silent --verbose http://localhost:11111 + [[ 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 trying to connect to minio + [[ 4 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=5 + grep AccessDenied + curl --silent --verbose http://localhost:11111 + [[ 5 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=6 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 6 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=7 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 7 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=8 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 8 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=9 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 9 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=10 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 10 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio API: http://172.17.0.2:11111 http://127.0.0.1:11111 Console: http://172.17.0.2:43149 http://127.0.0.1:43149 Documentation: https://docs.min.io WARNING: Console endpoint is listening on a dynamic port (43149), please use --console-address ":PORT" to choose a static port. + counter=11 + curl --silent --verbose http://localhost:11111 + grep AccessDenied AccessDeniedAccess Denied./17F804119C415ABB80151fb0-f63f-4f03-a12f-8d64585f3d40 + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 258 root 10u IPv6 31495 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: 150.34 MiB/s 02731.parquet + for file in $(ls "${data_path}") + echo 02731.parquet + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet clickminio/test/02731.parquet `/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet` -> `clickminio/test/02731.parquet` Total: 0 B, Transferred: 1.57 MiB, Speed: 93.96 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.84 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: 4.75 KiB/s c.tsv + for file in $(ls "${data_path}") + echo c.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv clickminio/test/c.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv` -> `clickminio/test/c.tsv` Total: 0 B, Transferred: 33 B, Speed: 4.45 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: 5.33 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 127.0.0.1 - - [23/Sep/2024:23:42:20 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [23/Sep/2024:23:42:20 +0000] "PUT /devstoreaccount1/cont/tlfvbtthovwwjclahhsyjhslalocndrg?blockid=xohrfkouerwiwvyxwwfejkitdjeifcomfivmhtobrnxslmdjlbtzljddckvmghqj&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [23/Sep/2024:23:42:20 +0000] "PUT /devstoreaccount1/cont/tlfvbtthovwwjclahhsyjhslalocndrg?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [23/Sep/2024:23:42:20 +0000] "GET /devstoreaccount1/cont/tlfvbtthovwwjclahhsyjhslalocndrg HTTP/1.1" 206 4 127.0.0.1 - - [23/Sep/2024:23:42:20 +0000] "GET /devstoreaccount1/cont/tlfvbtthovwwjclahhsyjhslalocndrg HTTP/1.1" 206 2 127.0.0.1 - - [23/Sep/2024:23:42:20 +0000] "DELETE /devstoreaccount1/cont/tlfvbtthovwwjclahhsyjhslalocndrg HTTP/1.1" 202 - + counter=5 + 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 534 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + setup_logs_replication + set +x File /tmp/export-logs-config.sh does not exist, do not setup + /s3downloader --url-prefix https://s3.amazonaws.com/clickhouse-datasets --dataset-names hits visits INFO:root:Will fetch following datasets: hits, visits INFO:root:Processing hits INFO:root:Downloading from https://s3.amazonaws.com/clickhouse-datasets/hits/partitions/hits_v1.tar to temp path /tmp/rea211a7 INFO:root:Content length is 1271623680 bytes INFO:root:Downloading finished INFO:root:Will unpack data from temp path /tmp/rea211a7 to clickhouse db /var/lib/clickhouse/ INFO:root:Unpack finished INFO:root:Will remove downloaded file /tmp/rea211a7 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/t657lafc INFO:root:Content length is 563968000 bytes INFO:root:Downloading finished INFO:root:Will unpack data from temp path /tmp/t657lafc to clickhouse db /var/lib/clickhouse/ INFO:root:Unpack finished INFO:root:Will remove downloaded file /tmp/t657lafc 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=534 + 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 = 534. The process with pid = 534 is running. Sent terminate signal to process with pid 534. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 534. The process with pid = 534 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 534. The process with pid = 534 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 534. The process with pid = 534 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 534. The process with pid = 534 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' 127.0.0.1 - - [23/Sep/2024:23:43:58 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [23/Sep/2024:23:43:58 +0000] "PUT /devstoreaccount1/cont/xqdofnjwgyrkunfrbelzszafvxakswii?blockid=jsfbhjtkqqkflfjlyhzdkrxjdngyudlqnolaljlxtkhrttrjkfrcmueqmebemzyo&comp=block HTTP/1.1" 201 - Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 127.0.0.1 - - [23/Sep/2024:23:43:58 +0000] "PUT /devstoreaccount1/cont/xqdofnjwgyrkunfrbelzszafvxakswii?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [23/Sep/2024:23:43:58 +0000] "GET /devstoreaccount1/cont/xqdofnjwgyrkunfrbelzszafvxakswii HTTP/1.1" 206 4 + '[' 3 -gt 120 ']' + clickhouse start --user root 127.0.0.1 - - [23/Sep/2024:23:43:58 +0000] "GET /devstoreaccount1/cont/xqdofnjwgyrkunfrbelzszafvxakswii HTTP/1.1" 206 2 127.0.0.1 - - [23/Sep/2024:23:43:58 +0000] "DELETE /devstoreaccount1/cont/xqdofnjwgyrkunfrbelzszafvxakswii HTTP/1.1" 202 - + 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' 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 958 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + clickhouse-client --query 'SHOW TABLES FROM datasets' hits_v1 visits_v1 + clickhouse-client --query 'SHOW TABLES FROM test' + clickhouse-client --query 'CREATE TABLE test.hits_s3 (WatchID UInt64, JavaEnable UInt8, Title String, GoodEvent Int16, EventTime DateTime, EventDate Date, CounterID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RegionID UInt32, UserID UInt64, CounterClass Int8, OS UInt8, UserAgent UInt8, URL String, Referer String, URLDomain String, RefererDomain String, Refresh UInt8, IsRobot UInt8, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32), RefererRegions Array(UInt32), ResolutionWidth UInt16, ResolutionHeight UInt16, ResolutionDepth UInt8, FlashMajor UInt8, FlashMinor UInt8, FlashMinor2 String, NetMajor UInt8, NetMinor UInt8, UserAgentMajor UInt16, UserAgentMinor FixedString(2), CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, MobilePhone UInt8, MobilePhoneModel String, Params String, IPNetworkID UInt32, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, IsArtifical UInt8, WindowClientWidth UInt16, WindowClientHeight UInt16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 UInt8, SilverlightVersion2 UInt8, SilverlightVersion3 UInt32, SilverlightVersion4 UInt16, PageCharset String, CodeVersion UInt32, IsLink UInt8, IsDownload UInt8, IsNotBounce UInt8, FUniqID UInt64, HID UInt32, IsOldCounter UInt8, IsEvent UInt8, IsParameter UInt8, DontCountHits UInt8, WithHash UInt8, HitColor FixedString(1), UTCEventTime DateTime, Age UInt8, Sex UInt8, Income UInt8, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), RemoteIP UInt32, RemoteIP6 FixedString(16), WindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage FixedString(2), BrowserCountry FixedString(2), SocialNetwork String, SocialAction String, HTTPError UInt16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, FetchTiming Int32, RedirectTiming Int32, DOMInteractiveTiming Int32, DOMContentLoadedTiming Int32, DOMCompleteTiming Int32, LoadEventStartTiming Int32, LoadEventEndTiming Int32, NSToDOMContentLoadedTiming Int32, FirstPaintTiming Int32, RedirectCount Int8, SocialSourceNetworkID UInt8, SocialSourcePage String, ParamPrice Int64, ParamOrderID String, ParamCurrency FixedString(3), ParamCurrencyID UInt16, GoalsReached Array(UInt32), OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, RefererHash UInt64, URLHash UInt64, CLID UInt32, YCLID UInt64, ShareService String, ShareURL String, ShareTitle String, ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64), IslandID FixedString(16), RequestNum UInt32, RequestTry UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate) ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''s3_cache'\''' + clickhouse-client --query 'CREATE TABLE test.hits (WatchID UInt64, JavaEnable UInt8, Title String, GoodEvent Int16, EventTime DateTime, EventDate Date, CounterID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RegionID UInt32, UserID UInt64, CounterClass Int8, OS UInt8, UserAgent UInt8, URL String, Referer String, URLDomain String, RefererDomain String, Refresh UInt8, IsRobot UInt8, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32), RefererRegions Array(UInt32), ResolutionWidth UInt16, ResolutionHeight UInt16, ResolutionDepth UInt8, FlashMajor UInt8, FlashMinor UInt8, FlashMinor2 String, NetMajor UInt8, NetMinor UInt8, UserAgentMajor UInt16, UserAgentMinor FixedString(2), CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, MobilePhone UInt8, MobilePhoneModel String, Params String, IPNetworkID UInt32, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, IsArtifical UInt8, WindowClientWidth UInt16, WindowClientHeight UInt16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 UInt8, SilverlightVersion2 UInt8, SilverlightVersion3 UInt32, SilverlightVersion4 UInt16, PageCharset String, CodeVersion UInt32, IsLink UInt8, IsDownload UInt8, IsNotBounce UInt8, FUniqID UInt64, HID UInt32, IsOldCounter UInt8, IsEvent UInt8, IsParameter UInt8, DontCountHits UInt8, WithHash UInt8, HitColor FixedString(1), UTCEventTime DateTime, Age UInt8, Sex UInt8, Income UInt8, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), RemoteIP UInt32, RemoteIP6 FixedString(16), WindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage FixedString(2), BrowserCountry FixedString(2), SocialNetwork String, SocialAction String, HTTPError UInt16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, FetchTiming Int32, RedirectTiming Int32, DOMInteractiveTiming Int32, DOMContentLoadedTiming Int32, DOMCompleteTiming Int32, LoadEventStartTiming Int32, LoadEventEndTiming Int32, NSToDOMContentLoadedTiming Int32, FirstPaintTiming Int32, RedirectCount Int8, SocialSourceNetworkID UInt8, SocialSourcePage String, ParamPrice Int64, ParamOrderID String, ParamCurrency FixedString(3), ParamCurrencyID UInt16, GoalsReached Array(UInt32), OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, RefererHash UInt64, URLHash UInt64, CLID UInt32, YCLID UInt64, ShareService String, ShareURL String, ShareTitle String, ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64), IslandID FixedString(16), RequestNum UInt32, RequestTry UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate) ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''s3_cache'\''' + clickhouse-client --query 'CREATE TABLE test.visits (CounterID UInt32, StartDate Date, Sign Int8, IsNew UInt8, VisitID UInt64, UserID UInt64, StartTime DateTime, Duration UInt32, UTCStartTime DateTime, PageViews Int32, Hits Int32, IsBounce UInt8, Referer String, StartURL String, RefererDomain String, StartURLDomain String, EndURL String, LinkURL String, IsDownload UInt8, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, PlaceID Int32, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32), RefererRegions Array(UInt32), IsYandex UInt8, GoalReachesDepth Int32, GoalReachesURL Int32, GoalReachesAny Int32, SocialSourceNetworkID UInt8, SocialSourcePage String, MobilePhoneModel String, ClientEventTime DateTime, RegionID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RemoteIP UInt32, RemoteIP6 FixedString(16), IPNetworkID UInt32, SilverlightVersion3 UInt32, CodeVersion UInt32, ResolutionWidth UInt16, ResolutionHeight UInt16, UserAgentMajor UInt16, UserAgentMinor UInt16, WindowClientWidth UInt16, WindowClientHeight UInt16, SilverlightVersion2 UInt8, SilverlightVersion4 UInt16, FlashVersion3 UInt16, FlashVersion4 UInt16, ClientTimeZone Int16, OS UInt8, UserAgent UInt8, ResolutionDepth UInt8, FlashMajor UInt8, FlashMinor UInt8, NetMajor UInt8, NetMinor UInt8, MobilePhone UInt8, SilverlightVersion1 UInt8, Age UInt8, Sex UInt8, Income UInt8, JavaEnable UInt8, CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, BrowserLanguage UInt16, BrowserCountry UInt16, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), Params Array(String), Goals Nested(ID UInt32, Serial UInt32, EventTime DateTime, Price Int64, OrderID String, CurrencyID UInt32), WatchIDs Array(UInt64), ParamSumPrice Int64, ParamCurrency FixedString(3), ParamCurrencyID UInt16, ClickLogID UInt64, ClickEventID Int32, ClickGoodEvent Int32, ClickEventTime DateTime, ClickPriorityID Int32, ClickPhraseID Int32, ClickPageID Int32, ClickPlaceID Int32, ClickTypeID Int32, ClickResourceID Int32, ClickCost UInt32, ClickClientIP UInt32, ClickDomainID UInt32, ClickURL String, ClickAttempt UInt8, ClickOrderID UInt32, ClickBannerID UInt32, ClickMarketCategoryID UInt32, ClickMarketPP UInt32, ClickMarketCategoryName String, ClickMarketPPName String, ClickAWAPSCampaignName String, ClickPageName String, ClickTargetType UInt16, ClickTargetPhraseID UInt64, ClickContextType UInt8, ClickSelectType Int8, ClickOptions String, ClickGroupBannerID Int32, OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, FirstVisit DateTime, PredLastVisit Date, LastVisit Date, TotalVisits UInt32, TraficSource Nested(ID Int8, SearchEngineID UInt16, AdvEngineID UInt8, PlaceID UInt16, SocialSourceNetworkID UInt8, Domain String, SearchPhrase String, SocialSourcePage String), Attendance FixedString(16), CLID UInt32, YCLID UInt64, NormalizedRefererHash UInt64, SearchPhraseHash UInt64, RefererDomainHash UInt64, NormalizedStartURLHash UInt64, StartURLDomainHash UInt64, NormalizedEndURLHash UInt64, TopLevelDomain UInt64, URLScheme UInt64, OpenstatServiceNameHash UInt64, OpenstatCampaignIDHash UInt64, OpenstatAdIDHash UInt64, OpenstatSourceIDHash UInt64, UTMSourceHash UInt64, UTMMediumHash UInt64, UTMCampaignHash UInt64, UTMContentHash UInt64, UTMTermHash UInt64, FromHash UInt64, WebVisorEnabled UInt8, WebVisorActivity UInt32, ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64), Market Nested(Type UInt8, GoalID UInt32, OrderID String, OrderPrice Int64, PP UInt32, DirectPlaceID UInt32, DirectOrderID UInt32, DirectBannerID UInt32, GoodID String, GoodName String, GoodQuantity Int32, GoodPrice Int64), IslandID FixedString(16)) ENGINE = CollapsingMergeTree(Sign) PARTITION BY toYYYYMM(StartDate) ORDER BY (CounterID, StartDate, intHash32(UserID), VisitID) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''s3_cache'\''' + clickhouse-client --query 'INSERT INTO test.hits_s3 SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0' + clickhouse-client --query 'INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0' + clickhouse-client --query 'INSERT INTO test.visits SELECT * FROM datasets.visits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0' + clickhouse-client --query 'DROP TABLE datasets.visits_v1 SYNC' + clickhouse-client --query 'DROP TABLE datasets.hits_v1 SYNC' + clickhouse-client --query 'SHOW TABLES FROM test' hits hits_s3 visits + clickhouse-client --query 'SYSTEM STOP THREAD FUZZER' + stop + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=958 + 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 = 958. The process with pid = 958 is running. Sent terminate signal to process with pid 958. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 958. The process with pid = 958 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 958. The process with pid = 958 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 958. The process with pid = 958 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 958. The process with pid = 958 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 958. The process with pid = 958 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 + echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server' + mkdir -p /etc/clickhouse-server/config.d/ Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + mkdir -p /etc/clickhouse-server/users.d/ + mkdir -p /etc/clickhouse-client + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disks.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/metadata_cache.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/reverse_dns_query_function.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/ + '[' /etc/clickhouse-server = /etc/clickhouse-server ']' + ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/ + ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + rm -f /etc/clickhouse-server/config.d/zookeeper.xml + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/ + create_snapshot_on_exit=0 + sed --follow-symlinks -i 's|true|0|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/config.d/s3_storage_policy_by_default.xml /etc/clickhouse-server/config.d/ + ARM=aarch64 ++ uname -m + OS=x86_64 x86_64 Adding azure configuration + [[ -n 1 ]] + echo x86_64 + [[ '' -eq 1 ]] + [[ x86_64 == \a\a\r\c\h\6\4 ]] + echo 'Adding azure configuration' + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|100000|10000|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\''' + export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + sudo chown root: /var/lib/clickhouse + echo '1' + local total_mem ++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo + total_mem=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 + 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 Setting max_memory_usage_for_user=9860806656 and max_memory_usage for queries to 10G + cat + cat + sudo cat /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sed 's|
s3
|
s3
default|' + mv /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml.tmp /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo cat /etc/clickhouse-server/config.d/logger_trace.xml + sed 's|trace|test|' + mv /etc/clickhouse-server/config.d/logger_trace.xml.tmp /etc/clickhouse-server/config.d/logger_trace.xml + start + counter=0 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root 127.0.0.1 - - [24/Sep/2024:00:24:26 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [24/Sep/2024:00:24:26 +0000] "PUT /devstoreaccount1/cont/wojxgdzltaezgwlmdeqibrejjbctwraf?blockid=tseamdgwypdsoqajqgaresqkoycjcvkeyzgzuoyjiuulhcjyotqqvhtsbgtthsqo&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [24/Sep/2024:00:24:26 +0000] "PUT /devstoreaccount1/cont/wojxgdzltaezgwlmdeqibrejjbctwraf?comp=blocklist HTTP/1.1" 201 - + sleep 0.5 127.0.0.1 - - [24/Sep/2024:00:24:26 +0000] "GET /devstoreaccount1/cont/wojxgdzltaezgwlmdeqibrejjbctwraf HTTP/1.1" 206 4 127.0.0.1 - - [24/Sep/2024:00:24:26 +0000] "GET /devstoreaccount1/cont/wojxgdzltaezgwlmdeqibrejjbctwraf HTTP/1.1" 206 2 127.0.0.1 - - [24/Sep/2024:00:24:26 +0000] "DELETE /devstoreaccount1/cont/wojxgdzltaezgwlmdeqibrejjbctwraf HTTP/1.1" 202 - + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' 1 + attach_gdb_to_clickhouse ++ kill -l SIGRTMIN + RTMIN=34 + echo ' set follow-fork-mode parent handle SIGHUP nostop noprint pass handle SIGINT nostop noprint pass handle SIGQUIT nostop noprint pass handle SIGPIPE nostop noprint pass handle SIGTERM nostop noprint pass handle SIGUSR1 nostop noprint pass handle SIGUSR2 nostop noprint pass handle SIG34 nostop noprint pass info signals continue backtrace full thread apply all backtrace full info registers disassemble /s up disassemble /s up disassemble /s p "done" detach quit ' + sleep 5 + ts '%Y-%m-%d %H:%M:%S' ++ cat /var/run/clickhouse-server/clickhouse-server.pid + gdb -batch -command script.gdb -p 1728 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + stress --hung-check --drop-databases --output-folder test_output --skip-func-tests '' --global-time-limit 1200 2024-09-24 02:25:18,144 Run func tests '/usr/bin/clickhouse-test --global_time_limit=1200 ' 2024-09-24 02:25:18,646 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-09-24 02:25:19,147 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_2', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 --global_time_limit=1200 ' 2024-09-24 02:25:19,648 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_3 --client-option join_algorithm='partial_merge' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-09-24 02:25:20,149 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 use_query_cache=1 --global_time_limit=1200 ' 2024-09-24 02:25:20,650 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-09-24 02:25:21,152 Run func tests '/usr/bin/clickhouse-test --order=random --client-option memory_tracker_fault_probability=0.001 --global_time_limit=1200 ' 2024-09-24 02:25:21,653 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_7 --client-option join_use_nulls=1 join_algorithm='grace_hash' use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-09-24 02:25:22,154 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 use_query_cache=1 --global_time_limit=1200 ' 2024-09-24 02:25:22,655 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-09-24 02:25:23,172 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 use_query_cache=1 --global_time_limit=1200 ' 2024-09-24 02:25:23,673 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' memory_tracker_fault_probability=0.001 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-09-24 02:25:24,174 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-09-24 02:25:24,675 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_13 --client-option join_use_nulls=1 join_algorithm='partial_merge' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-09-24 02:25:25,177 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_14', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 use_query_cache=1 --global_time_limit=1200 ' 2024-09-24 02:25:25,678 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_merge' use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-09-24 02:25:26,179 Will wait functests to finish 2024-09-24 02:25:26,179 Finished 0 from 16 processes 2024-09-24 02:25:31,181 Finished 0 from 16 processes 2024-09-24 02:25:36,185 Finished 0 from 16 processes 2024-09-24 02:25:41,189 Finished 0 from 16 processes 2024-09-24 02:25:46,193 Finished 0 from 16 processes 2024-09-24 02:25:51,197 Finished 0 from 16 processes 2024-09-24 02:25:56,201 Finished 0 from 16 processes 2024-09-24 02:26:01,205 Finished 0 from 16 processes 2024-09-24 02:26:06,209 Finished 0 from 16 processes 2024-09-24 02:26:11,213 Finished 0 from 16 processes 2024-09-24 02:26:16,217 Finished 0 from 16 processes 2024-09-24 02:26:21,221 Finished 0 from 16 processes 2024-09-24 02:26:26,225 Finished 0 from 16 processes 2024-09-24 02:26:31,229 Finished 0 from 16 processes 2024-09-24 02:26:36,233 Finished 0 from 16 processes 2024-09-24 02:26:41,237 Finished 0 from 16 processes 2024-09-24 02:26:46,241 Finished 0 from 16 processes 2024-09-24 02:26:51,245 Finished 0 from 16 processes 2024-09-24 02:26:56,249 Finished 0 from 16 processes 2024-09-24 02:27:01,253 Finished 0 from 16 processes 2024-09-24 02:27:06,257 Finished 0 from 16 processes 2024-09-24 02:27:11,261 Finished 0 from 16 processes 2024-09-24 02:27:16,266 Finished 0 from 16 processes 2024-09-24 02:27:21,269 Finished 0 from 16 processes 2024-09-24 02:27:26,273 Finished 0 from 16 processes 2024-09-24 02:27:31,277 Finished 0 from 16 processes 2024-09-24 02:27:36,281 Finished 0 from 16 processes 2024-09-24 02:27:41,285 Finished 0 from 16 processes 2024-09-24 02:27:46,289 Finished 0 from 16 processes 2024-09-24 02:27:51,293 Finished 0 from 16 processes 2024-09-24 02:27:56,298 Finished 0 from 16 processes 2024-09-24 02:28:01,301 Finished 0 from 16 processes 2024-09-24 02:28:06,305 Finished 0 from 16 processes 2024-09-24 02:28:11,309 Finished 0 from 16 processes 2024-09-24 02:28:16,313 Finished 0 from 16 processes 2024-09-24 02:28:21,317 Finished 0 from 16 processes 2024-09-24 02:28:26,321 Finished 0 from 16 processes 2024-09-24 02:28:31,325 Finished 0 from 16 processes 2024-09-24 02:28:36,329 Finished 0 from 16 processes 2024-09-24 02:28:41,333 Finished 0 from 16 processes 2024-09-24 02:28:46,337 Finished 0 from 16 processes 2024-09-24 02:28:51,341 Finished 0 from 16 processes 2024-09-24 02:28:56,345 Finished 0 from 16 processes 2024-09-24 02:29:01,349 Finished 0 from 16 processes 2024-09-24 02:29:06,353 Finished 0 from 16 processes 2024-09-24 02:29:11,357 Finished 0 from 16 processes 2024-09-24 02:29:16,361 Finished 0 from 16 processes 2024-09-24 02:29:21,365 Finished 0 from 16 processes 2024-09-24 02:29:26,369 Finished 0 from 16 processes 2024-09-24 02:29:31,373 Finished 0 from 16 processes 2024-09-24 02:29:36,377 Finished 0 from 16 processes 2024-09-24 02:29:41,382 Finished 0 from 16 processes 2024-09-24 02:29:46,385 Finished 0 from 16 processes 2024-09-24 02:29:51,390 Finished 0 from 16 processes 2024-09-24 02:29:56,393 Finished 0 from 16 processes 2024-09-24 02:30:01,397 Finished 0 from 16 processes 2024-09-24 02:30:06,402 Finished 0 from 16 processes 2024-09-24 02:30:11,405 Finished 0 from 16 processes 2024-09-24 02:30:16,408 Finished 0 from 16 processes 2024-09-24 02:30:21,410 Finished 0 from 16 processes 2024-09-24 02:30:26,413 Finished 0 from 16 processes 2024-09-24 02:30:31,417 Finished 0 from 16 processes 2024-09-24 02:30:36,421 Finished 0 from 16 processes 2024-09-24 02:30:41,421 Finished 0 from 16 processes 2024-09-24 02:30:46,425 Finished 0 from 16 processes 2024-09-24 02:30:51,430 Finished 0 from 16 processes 2024-09-24 02:30:56,433 Finished 0 from 16 processes 2024-09-24 02:31:01,437 Finished 0 from 16 processes 2024-09-24 02:31:06,441 Finished 0 from 16 processes 2024-09-24 02:31:11,445 Finished 0 from 16 processes 2024-09-24 02:31:16,450 Finished 0 from 16 processes 2024-09-24 02:31:21,453 Finished 0 from 16 processes 2024-09-24 02:31:26,457 Finished 0 from 16 processes 2024-09-24 02:31:31,461 Finished 0 from 16 processes 2024-09-24 02:31:36,465 Finished 0 from 16 processes 2024-09-24 02:31:41,470 Finished 0 from 16 processes 2024-09-24 02:31:46,473 Finished 0 from 16 processes 2024-09-24 02:31:51,477 Finished 0 from 16 processes 2024-09-24 02:31:56,482 Finished 0 from 16 processes 2024-09-24 02:32:01,485 Finished 0 from 16 processes 2024-09-24 02:32:06,489 Finished 0 from 16 processes 2024-09-24 02:32:11,493 Finished 0 from 16 processes 2024-09-24 02:32:16,497 Finished 0 from 16 processes 2024-09-24 02:32:21,501 Finished 0 from 16 processes 2024-09-24 02:32:26,505 Finished 0 from 16 processes 2024-09-24 02:32:31,509 Finished 0 from 16 processes 2024-09-24 02:32:36,511 Finished 0 from 16 processes 2024-09-24 02:32:41,513 Finished 0 from 16 processes 2024-09-24 02:32:46,517 Finished 0 from 16 processes 2024-09-24 02:32:51,521 Finished 0 from 16 processes 2024-09-24 02:32:56,525 Finished 0 from 16 processes 2024-09-24 02:33:01,529 Finished 0 from 16 processes 2024-09-24 02:33:06,533 Finished 0 from 16 processes 2024-09-24 02:33:11,537 Finished 0 from 16 processes 2024-09-24 02:33:16,541 Finished 0 from 16 processes 2024-09-24 02:33:21,545 Finished 0 from 16 processes 2024-09-24 02:33:26,550 Finished 0 from 16 processes 2024-09-24 02:33:31,553 Finished 0 from 16 processes 2024-09-24 02:33:36,557 Finished 0 from 16 processes 2024-09-24 02:33:41,561 Finished 0 from 16 processes 2024-09-24 02:33:46,566 Finished 0 from 16 processes 2024-09-24 02:33:51,569 Finished 0 from 16 processes 2024-09-24 02:33:56,573 Finished 0 from 16 processes 2024-09-24 02:34:01,577 Finished 0 from 16 processes 2024-09-24 02:34:06,581 Finished 0 from 16 processes 2024-09-24 02:34:11,585 Finished 0 from 16 processes 2024-09-24 02:34:16,589 Finished 0 from 16 processes 2024-09-24 02:34:21,593 Finished 0 from 16 processes 2024-09-24 02:34:26,597 Finished 0 from 16 processes 2024-09-24 02:34:31,601 Finished 0 from 16 processes 2024-09-24 02:34:36,605 Finished 0 from 16 processes 2024-09-24 02:34:41,609 Finished 0 from 16 processes 2024-09-24 02:34:46,613 Finished 0 from 16 processes 2024-09-24 02:34:51,617 Finished 0 from 16 processes 2024-09-24 02:34:56,622 Finished 0 from 16 processes 2024-09-24 02:35:01,625 Finished 0 from 16 processes 2024-09-24 02:35:06,629 Finished 0 from 16 processes 2024-09-24 02:35:11,633 Finished 0 from 16 processes 2024-09-24 02:35:16,637 Finished 0 from 16 processes 2024-09-24 02:35:21,641 Finished 0 from 16 processes 2024-09-24 02:35:26,646 Finished 0 from 16 processes 2024-09-24 02:35:31,649 Finished 0 from 16 processes 2024-09-24 02:35:36,653 Finished 0 from 16 processes 2024-09-24 02:35:41,657 Finished 0 from 16 processes 2024-09-24 02:35:46,661 Finished 0 from 16 processes 2024-09-24 02:35:51,665 Finished 0 from 16 processes 2024-09-24 02:35:56,669 Finished 0 from 16 processes 2024-09-24 02:36:01,674 Finished 0 from 16 processes 2024-09-24 02:36:06,677 Finished 0 from 16 processes 2024-09-24 02:36:11,685 Finished 0 from 16 processes 2024-09-24 02:36:16,690 Finished 0 from 16 processes 2024-09-24 02:36:21,693 Finished 0 from 16 processes 2024-09-24 02:36:26,697 Finished 0 from 16 processes 2024-09-24 02:36:31,700 Finished 0 from 16 processes 2024-09-24 02:36:36,705 Finished 0 from 16 processes 2024-09-24 02:36:41,709 Finished 0 from 16 processes 2024-09-24 02:36:46,713 Finished 0 from 16 processes 2024-09-24 02:36:51,717 Finished 0 from 16 processes 2024-09-24 02:36:56,722 Finished 0 from 16 processes 2024-09-24 02:37:01,727 Finished 0 from 16 processes 2024-09-24 02:37:06,729 Finished 0 from 16 processes 2024-09-24 02:37:11,733 Finished 0 from 16 processes 2024-09-24 02:37:16,738 Finished 0 from 16 processes 2024-09-24 02:37:21,741 Finished 0 from 16 processes 2024-09-24 02:37:26,745 Finished 0 from 16 processes 2024-09-24 02:37:31,749 Finished 0 from 16 processes 2024-09-24 02:37:36,753 Finished 0 from 16 processes 2024-09-24 02:37:41,757 Finished 0 from 16 processes 2024-09-24 02:37:46,761 Finished 0 from 16 processes 2024-09-24 02:37:51,765 Finished 0 from 16 processes 2024-09-24 02:37:56,769 Finished 0 from 16 processes 2024-09-24 02:38:01,773 Finished 0 from 16 processes 2024-09-24 02:38:06,777 Finished 0 from 16 processes 2024-09-24 02:38:11,781 Finished 0 from 16 processes 2024-09-24 02:38:16,785 Finished 0 from 16 processes 2024-09-24 02:38:21,790 Finished 0 from 16 processes 2024-09-24 02:38:26,793 Finished 0 from 16 processes 2024-09-24 02:38:31,797 Finished 0 from 16 processes 2024-09-24 02:38:36,801 Finished 0 from 16 processes 2024-09-24 02:38:41,805 Finished 0 from 16 processes 2024-09-24 02:38:46,809 Finished 0 from 16 processes 2024-09-24 02:38:51,813 Finished 0 from 16 processes 2024-09-24 02:38:56,817 Finished 0 from 16 processes 2024-09-24 02:39:01,821 Finished 0 from 16 processes 2024-09-24 02:39:06,825 Finished 0 from 16 processes 2024-09-24 02:39:11,829 Finished 0 from 16 processes 2024-09-24 02:39:16,833 Finished 0 from 16 processes 2024-09-24 02:39:21,837 Finished 0 from 16 processes 2024-09-24 02:39:26,841 Finished 0 from 16 processes 2024-09-24 02:39:31,846 Finished 0 from 16 processes 2024-09-24 02:39:36,849 Finished 0 from 16 processes 2024-09-24 02:39:41,853 Finished 0 from 16 processes 2024-09-24 02:39:46,857 Finished 0 from 16 processes 2024-09-24 02:39:51,861 Finished 0 from 16 processes 2024-09-24 02:39:56,865 Finished 0 from 16 processes 2024-09-24 02:40:01,871 Finished 0 from 16 processes 2024-09-24 02:40:06,873 Finished 0 from 16 processes 2024-09-24 02:40:11,877 Finished 0 from 16 processes 2024-09-24 02:40:16,881 Finished 0 from 16 processes 2024-09-24 02:40:21,885 Finished 0 from 16 processes 2024-09-24 02:40:26,889 Finished 0 from 16 processes 2024-09-24 02:40:31,893 Finished 0 from 16 processes 2024-09-24 02:40:36,897 Finished 0 from 16 processes 2024-09-24 02:40:41,901 Finished 0 from 16 processes 2024-09-24 02:40:46,905 Finished 0 from 16 processes 2024-09-24 02:40:51,909 Finished 0 from 16 processes 2024-09-24 02:40:56,913 Finished 0 from 16 processes 2024-09-24 02:41:01,917 Finished 0 from 16 processes 2024-09-24 02:41:06,922 Finished 0 from 16 processes 2024-09-24 02:41:11,926 Finished 0 from 16 processes 2024-09-24 02:41:16,929 Finished 0 from 16 processes 2024-09-24 02:41:21,934 Finished 0 from 16 processes 2024-09-24 02:41:26,937 Finished 0 from 16 processes 2024-09-24 02:41:31,941 Finished 0 from 16 processes 2024-09-24 02:41:36,945 Finished 0 from 16 processes 2024-09-24 02:41:41,949 Finished 0 from 16 processes 2024-09-24 02:41:46,953 Finished 0 from 16 processes 2024-09-24 02:41:51,957 Finished 0 from 16 processes 2024-09-24 02:41:56,961 Finished 0 from 16 processes 2024-09-24 02:42:01,965 Finished 0 from 16 processes 2024-09-24 02:42:06,969 Finished 0 from 16 processes 2024-09-24 02:42:11,973 Finished 0 from 16 processes 2024-09-24 02:42:16,977 Finished 0 from 16 processes 2024-09-24 02:42:21,981 Finished 0 from 16 processes 2024-09-24 02:42:26,986 Finished 0 from 16 processes 2024-09-24 02:42:31,990 Finished 0 from 16 processes 2024-09-24 02:42:36,993 Finished 0 from 16 processes 2024-09-24 02:42:41,998 Finished 0 from 16 processes 2024-09-24 02:42:47,001 Finished 0 from 16 processes 2024-09-24 02:42:52,005 Finished 0 from 16 processes 2024-09-24 02:42:57,009 Finished 0 from 16 processes 2024-09-24 02:43:02,013 Finished 0 from 16 processes 2024-09-24 02:43:07,017 Finished 0 from 16 processes 2024-09-24 02:43:12,022 Finished 0 from 16 processes 2024-09-24 02:43:17,025 Finished 0 from 16 processes 2024-09-24 02:43:22,033 Finished 0 from 16 processes 2024-09-24 02:43:27,037 Finished 0 from 16 processes 2024-09-24 02:43:32,041 Finished 0 from 16 processes 2024-09-24 02:43:37,046 Finished 0 from 16 processes 2024-09-24 02:43:42,050 Finished 0 from 16 processes 2024-09-24 02:43:47,055 Finished 0 from 16 processes 2024-09-24 02:43:52,057 Finished 0 from 16 processes 2024-09-24 02:43:57,061 Finished 0 from 16 processes 2024-09-24 02:44:02,065 Finished 0 from 16 processes 2024-09-24 02:44:07,069 Finished 0 from 16 processes 2024-09-24 02:44:12,073 Finished 0 from 16 processes 2024-09-24 02:44:17,077 Finished 0 from 16 processes 2024-09-24 02:44:22,081 Finished 0 from 16 processes 2024-09-24 02:44:27,085 Finished 0 from 16 processes 2024-09-24 02:44:32,089 Finished 0 from 16 processes 2024-09-24 02:44:37,093 Finished 0 from 16 processes 2024-09-24 02:44:42,097 Finished 0 from 16 processes 2024-09-24 02:44:47,101 Finished 0 from 16 processes 2024-09-24 02:44:52,105 Finished 0 from 16 processes 2024-09-24 02:44:57,109 Finished 0 from 16 processes 2024-09-24 02:45:02,113 Finished 0 from 16 processes 2024-09-24 02:45:07,117 Finished 0 from 16 processes 2024-09-24 02:45:12,121 Finished 0 from 16 processes 2024-09-24 02:45:17,125 Finished 0 from 16 processes 2024-09-24 02:45:22,129 Finished 0 from 16 processes 2024-09-24 02:45:27,134 Finished 1 from 16 processes 2024-09-24 02:45:32,137 Finished 1 from 16 processes 2024-09-24 02:45:37,141 Finished 1 from 16 processes 2024-09-24 02:45:42,145 Finished 3 from 16 processes 2024-09-24 02:45:47,149 Finished 3 from 16 processes 2024-09-24 02:45:52,153 Finished 3 from 16 processes 2024-09-24 02:45:57,158 Finished 4 from 16 processes 2024-09-24 02:46:02,161 Finished 5 from 16 processes 2024-09-24 02:46:07,165 Finished 5 from 16 processes 2024-09-24 02:46:12,169 Finished 6 from 16 processes 2024-09-24 02:46:17,173 Finished 8 from 16 processes 2024-09-24 02:46:22,177 Finished 9 from 16 processes 2024-09-24 02:46:27,181 Finished 10 from 16 processes 2024-09-24 02:46:32,185 Finished 10 from 16 processes 2024-09-24 02:46:37,189 Finished 10 from 16 processes 2024-09-24 02:46:42,193 Finished 11 from 16 processes 2024-09-24 02:46:47,197 Finished 11 from 16 processes 2024-09-24 02:46:52,201 Finished 12 from 16 processes 2024-09-24 02:46:57,205 Finished 13 from 16 processes 2024-09-24 02:47:02,210 Finished 13 from 16 processes 2024-09-24 02:47:07,213 Finished 13 from 16 processes 2024-09-24 02:47:12,217 Finished 13 from 16 processes 2024-09-24 02:47:17,221 Finished 13 from 16 processes 2024-09-24 02:47:22,225 Finished 14 from 16 processes 2024-09-24 02:47:27,229 Finished 14 from 16 processes 2024-09-24 02:47:32,233 Finished 14 from 16 processes 2024-09-24 02:47:37,237 Finished 14 from 16 processes 2024-09-24 02:47:42,241 Finished 14 from 16 processes 2024-09-24 02:47:47,245 Finished 14 from 16 processes 2024-09-24 02:47:52,250 Finished 14 from 16 processes 2024-09-24 02:47:57,253 Finished 14 from 16 processes 2024-09-24 02:48:02,257 Finished 15 from 16 processes 2024-09-24 02:48:07,261 Finished 15 from 16 processes 2024-09-24 02:48:12,265 Finished 15 from 16 processes 2024-09-24 02:48:17,270 Finished 15 from 16 processes 2024-09-24 02:48:22,275 Finished 15 from 16 processes 2024-09-24 02:48:27,281 Finished 15 from 16 processes 2024-09-24 02:48:32,286 Finished 15 from 16 processes 2024-09-24 02:48:37,291 Finished 15 from 16 processes 2024-09-24 02:48:42,293 Finished 15 from 16 processes 2024-09-24 02:48:47,298 Finished 15 from 16 processes 2024-09-24 02:48:52,301 Finished 15 from 16 processes 2024-09-24 02:48:57,305 Finished 15 from 16 processes 2024-09-24 02:49:02,309 Finished 15 from 16 processes 2024-09-24 02:49:07,313 Finished 15 from 16 processes 2024-09-24 02:49:12,317 Finished 15 from 16 processes 2024-09-24 02:49:17,322 Finished 15 from 16 processes 2024-09-24 02:49:22,327 Finished 15 from 16 processes 2024-09-24 02:49:27,333 Finished 15 from 16 processes 2024-09-24 02:49:32,338 Finished 15 from 16 processes 2024-09-24 02:49:37,341 Finished 15 from 16 processes 2024-09-24 02:49:42,345 Finished 15 from 16 processes 2024-09-24 02:49:47,350 Finished 15 from 16 processes 2024-09-24 02:49:52,355 Finished 15 from 16 processes 2024-09-24 02:49:57,357 Finished 15 from 16 processes 2024-09-24 02:50:02,362 Finished 15 from 16 processes 2024-09-24 02:50:07,365 Finished 15 from 16 processes 2024-09-24 02:50:12,370 Finished 15 from 16 processes 2024-09-24 02:50:17,375 Finished 15 from 16 processes 2024-09-24 02:50:22,381 Finished 15 from 16 processes 2024-09-24 02:50:27,386 Finished 15 from 16 processes 2024-09-24 02:50:32,391 Finished 15 from 16 processes 2024-09-24 02:50:37,396 Finished 15 from 16 processes 2024-09-24 02:50:42,402 Finished 15 from 16 processes 2024-09-24 02:50:47,407 Finished 15 from 16 processes 2024-09-24 02:50:52,412 Finished 15 from 16 processes 2024-09-24 02:50:57,417 Finished 15 from 16 processes 2024-09-24 02:51:02,423 Finished 15 from 16 processes 2024-09-24 02:51:07,425 Finished 15 from 16 processes 2024-09-24 02:51:12,429 Finished 15 from 16 processes 2024-09-24 02:51:17,433 Finished 15 from 16 processes 2024-09-24 02:51:22,438 Finished 15 from 16 processes 2024-09-24 02:51:27,441 Finished 15 from 16 processes 2024-09-24 02:51:32,445 Finished 15 from 16 processes 2024-09-24 02:51:37,450 Finished 15 from 16 processes 2024-09-24 02:51:42,453 Finished 15 from 16 processes 2024-09-24 02:51:47,458 Finished 15 from 16 processes 2024-09-24 02:51:52,463 All processes finished 2024-09-24 02:51:52,463 Compressing stress logs 2024-09-24 02:51:52,515 Logs compressed 2024-09-24 02:51:52,515 Will terminate gdb (if any) Quit 2024-09-24 02:56:57,010 Checking if some queries hung Using queries from '/usr/share/clickhouse-test/queries' directory Connecting to ClickHouse server... OK Running 1 stateless tests (MainProcess). 00001_select_1: [ OK ] 1 tests passed. 0 tests skipped. 0.37 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) 17449 0.052 954.27 KiB 0.024 1 918 ['Trace'] 0.206 Created HTTP(S) session with {}:{} ({}:{}) 17429 0.052 1.94 MiB 0.05 913 1645 ['Trace'] 0 Bypassing cache because file segment state is `PARTIALLY_DOWNLOADED_NO_CONTINUATION` and downloaded part already used 16250 0.048 1.04 MiB 0.027 2 268 ['Trace'] 0 Access granted: {}{} 14944 0.044 2.49 MiB 0.064 1 217 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 14075 0.042 2.11 MiB 0.054 3 216 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 11674 0.035 523.17 KiB 0.013 1 1 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 11601 0.034 328.90 KiB 0.008 1 216 ['Debug'] 0.001 Processed in {} sec. 9185 0.027 871.81 KiB 0.022 1 2113 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 7710 0.023 219.69 KiB 0.005 1 1770 ['Trace'] 0 Aggregation method: {} 7600 0.023 587.28 KiB 0.015 1 671 ['Debug'] 0.182 Remove from cache. Key: {}, offset: {}, size: {} 7551 0.022 622.14 KiB 0.016 1 206 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 7068 0.021 575.37 KiB 0.014 4 221 ['Debug'] 0.999 {} Authenticating user \'{}\' from {} 7068 0.021 793.77 KiB 0.02 4 221 ['Debug'] 0.999 {} Authenticated with global context as user {} 7061 0.021 772.30 KiB 0.019 3 216 ['Debug'] 1 {} Creating session context with user_id: {} 7060 0.021 620.51 KiB 0.016 4 221 ['Debug'] 0.999 {} Logout, user_id: {} 6791 0.02 72.95 KiB 0.002 1 1567 ['Trace'] 0 Aggregating 6209 0.018 369.87 KiB 0.009 1 94 ['Debug'] 0.966 Key {} is removed from metadata 5851 0.017 140.12 KiB 0.004 1 247 ['Trace'] 0.011 {} -> {} 5128 0.015 222.10 KiB 0.006 1 239 ['Debug'] 0.104 Peak memory usage{}: {}. 4899 0.015 282.27 KiB 0.007 1 363 ['Debug'] 0.037 Submitting key {} for removal 4606 0.014 439.08 KiB 0.011 1 216 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 4606 0.014 149.91 KiB 0.004 1 216 ['Trace'] 1 TCP Request. Address: {} 4483 0.013 376.46 KiB 0.009 1 1521 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 4242 0.013 111.85 KiB 0.003 1 216 ['Debug'] 1 Done processing connection. 3510 0.01 168.01 KiB 0.004 1 261 ['Trace'] 0.507 filled checksums {} 3470 0.01 240.68 KiB 0.006 199 372 ['Trace'] 0.651 Trying to reserve {} using storage policy from min volume index {} 3087 0.009 366.64 KiB 0.009 198 265 ['Trace'] 0.581 Renaming temporary part {} to {} with tid {}. 3065 0.009 1.59 MiB 0.041 1 401 ['Debug'] 0.887 Objects with paths [{}] were removed from S3 2882 0.009 909.76 KiB 0.023 1642 670 ['Information'] 0.005 Setting download as failed: {} 2803 0.008 3.51 MiB 0.09 1 391 ['Debug'] 0.897 metadata and objects were removed for [{}], only metadata were removed for [{}]. 2637 0.008 247.67 KiB 0.006 1 26 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 2476 0.007 451.83 KiB 0.011 2 104 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {} 2474 0.007 814.92 KiB 0.02 2 104 ['Trace'] 1 Request URI: {} 2459 0.007 50.43 KiB 0.001 2 104 ['Debug'] 0.005 Done processing query 2365 0.007 94.69 KiB 0.002 1 942 ['Trace'] 0 Converting aggregation data to two-level. 2358 0.007 204.18 KiB 0.005 1 67 ['Trace'] 0 PREWHERE condition was split into {} steps: {} 2335 0.007 70.57 KiB 0.002 22 1501 ['Trace'] 0 Found (RIGHT) boundary mark: {} 2335 0.007 66.17 KiB 0.002 22 1501 ['Trace'] 0 Found {} range in {} steps 2335 0.007 157.72 KiB 0.004 22 1501 ['Trace'] 0 Running binary search on index range for part {} ({} marks) 2335 0.007 68.26 KiB 0.002 22 1501 ['Trace'] 0 Found (LEFT) boundary mark: {} 2098 0.006 306.99 KiB 0.008 1 128 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {} 2098 0.006 155.71 KiB 0.004 1 71 ['Debug'] 0 Waiting for table {} to be finally dropped 2098 0.006 495.05 KiB 0.012 1 128 ['Information'] 1 Removing metadata {} of dropped table {} 2040 0.006 67.98 KiB 0.002 1 46 ['Debug'] 0 ({}) Keys: {} 2040 0.006 335.41 KiB 0.008 1 46 ['Debug'] 0 ({}) Datatype: {}, kind: {}, strictness: {}, right header: {} 2035 0.006 165.06 KiB 0.004 1 53 ['Trace'] 0.003 ({}) Join data is being destroyed, {} bytes and {} rows in hash table 2013 0.006 501.70 KiB 0.013 1 28 ['Information'] 0.017 WriteBufferFromS3 is not finalized in destructor. The file might not be written to S3. {}. 1761 0.005 101.82 KiB 0.003 13 13 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 1761 0.005 63.15 KiB 0.002 13 13 ['Trace'] 1 Flushed system log up to offset {} 1732 0.005 213.24 KiB 0.005 1 2 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 1699 0.005 198.62 KiB 0.005 1 16 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 1640 0.005 139.83 KiB 0.003 1 80 ['Trace'] 0.003 Reading {} ranges in order from part {}, approx. {} rows starting from {} 1617 0.005 192.18 KiB 0.005 1 55 ['Trace'] 0 Have {} pending inserts with total {} bytes of data for query \'{}\' 1567 0.005 160.49 KiB 0.004 584 492 ['Trace'] 0 Predownload failed because of space limit. Will read from remote filesystem starting from offset: {} 1504 0.004 116.03 KiB 0.003 1 187 ['Trace'] 0 Query span trace_id for opentelemetry log: {} 1331 0.004 65.70 KiB 0.002 1 146 ['Trace'] 0 Merging partially aggregated blocks (bucket = {}). 1331 0.004 195.94 KiB 0.005 1 146 ['Debug'] 0 Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.) 1312 0.004 156.29 KiB 0.004 1 83 ['Trace'] 0 No entry found for query {} 1300 0.004 41.83 KiB 0.001 150 121 ['Debug'] 0.01 Key condition: {} 1250 0.004 146.03 KiB 0.004 143 121 ['Debug'] 0.01 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 1182 0.004 96.81 KiB 0.002 581 472 ['Trace'] 0 No space left in cache to reserve {} bytes, will continue without cache download 1130 0.003 108.87 KiB 0.003 1 444 ['Debug'] 0.098 Will evict {} file segments (while reserving {} bytes for {}:{}) 1119 0.003 57.92 KiB 0.001 119 111 ['Trace'] 0.012 Spreading mark ranges among streams (default reading) 1082 0.003 24.30 KiB 0.001 1 739 ['Trace'] 0 Merging aggregated data 1048 0.003 73.73 KiB 0.002 4 4 ['Debug'] 0 Flushing buffer with {} rows, {} bytes, age {} seconds, took {} ms {}. 999 0.003 29.27 KiB 0.001 85 81 ['Trace'] 1 Checking task {} 994 0.003 94.40 KiB 0.002 84 80 ['Debug'] 1 Will not execute task {}: {} 910 0.003 180.87 KiB 0.005 43 67 ['Debug'] 0 Proposing query: {} 910 0.003 63.98 KiB 0.002 43 67 ['Debug'] 0 Waiting for worker thread to process all entries before {} 886 0.003 204.21 KiB 0.005 44 68 ['Debug'] 0.005 Processing task {} ({}) 885 0.003 188.44 KiB 0.005 44 68 ['Debug'] 0.005 Executing query: {} 882 0.003 80.10 KiB 0.002 43 41 ['Trace'] 1 Waiting for initiator {} to commit or rollback entry {} 880 0.003 215.08 KiB 0.005 44 67 ['Debug'] 0 Executed query: {} 849 0.003 29.52 KiB 0.001 33 92 ['Debug'] 0 MinMax index condition: {} 737 0.002 33.80 KiB 0.001 1 704 ['Debug'] 0 Aggregated. {} to {} rows (from {}) 729 0.002 53.01 KiB 0.001 1 68 ['Trace'] 0 The min valid primary key position for moving to the tail of PREWHERE is {} 715 0.002 13.96 KiB 0 1 680 ['Trace'] 0 Aggregating in order 699 0.002 56.06 KiB 0.001 1 75 ['Trace'] 0 Entry found for query {} 650 0.002 57.07 KiB 0.001 19 310 ['Trace'] 0.569 Part {} local references is zero, will check blobs can be removed in zookeeper 603 0.002 31.81 KiB 0.001 61 134 ['Debug'] 0.957 Selected {} parts from {} to {} 597 0.002 18.61 KiB 0 16 22 ['Debug'] 0 Requested flush up to offset {} 585 0.002 23.91 KiB 0.001 56 84 ['Debug'] 0.014 Reading approx. {} rows with {} streams 567 0.002 91.01 KiB 0.002 1 123 ['Debug'] 0.681 Recursively remove path {}: metadata and objects were removed for [{}], only metadata were removed for [{}]. 529 0.002 48.10 KiB 0.001 1 64 ['Debug'] 0 MergeTreeWhereOptimizer: condition "{}" moved to PREWHERE 524 0.002 4.61 KiB 0 2 51 ['Trace'] 0.004 No tables 505 0.001 17.25 KiB 0 1 26 ['Debug'] 0 Selected MergeAlgorithm: {} 505 0.001 41.96 KiB 0.001 1 26 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {} 495 0.001 64.83 KiB 0.002 1 26 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec. 494 0.001 32.17 KiB 0.001 53 26 ['Trace'] 0 Merged {} parts: [{}, {}] -> {} 476 0.001 63.39 KiB 0.002 15 41 ['Debug'] 0 Part: {}, sum_marks: {}, approx mark size: {}, prefetch_step_bytes: {}, prefetch_step_marks: {}, (ranges: {}) 471 0.001 82.98 KiB 0.002 1 40 ['Debug'] 0 After join block: \'{}\' 471 0.001 60.83 KiB 0.002 1 40 ['Debug'] 0 Before join block: \'{}\' 470 0.001 98.02 KiB 0.002 38 10 ['Information'] 1 {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 469 0.001 64.73 KiB 0.002 19 122 ['Trace'] 1 Checked {} partitions, found {} partitions with parts that may be merged: [{}](max_total_size_to_merge={}, merge_with_ttl_allowed{}) 462 0.001 57.32 KiB 0.001 183 100 ['Debug'] 0.994 Removing {} parts from filesystem (serially): Parts: [{}] 457 0.001 14.29 KiB 0 1 69 ['Debug'] 0.018 min_marks_for_concurrent_read={} 443 0.001 21.56 KiB 0.001 23 126 ['Trace'] 1 Scheduling next merge selecting task after {}ms 409 0.001 33.34 KiB 0.001 1 340 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={} 407 0.001 37.45 KiB 0.001 1 358 ['Debug'] 0 Merge sorted {} blocks, {} rows in {} sec., {} rows/sec., {}/sec 389 0.001 35.27 KiB 0.001 21 122 ['Trace'] 1 Insert entry {} to queue with type {} Top messages without format string (fmt::runtime): count pattern runtime_message line UInt64 String String Tuple(String, UInt64) 4 EntryconnectionPINGok Entry(connection 0): PING ok. ('',0) 4 EntryconnectionsendingPINGtochec Entry(connection 0): sending PING to check if it is alive. ('',0) 3 CodeDBExceptionCannotmodifyminco Code: 164. DB::Exception: Cannot modify \'min_compress_block_size\' setting in readonly mode. (READONLY), Stack trace (when copying this message, always include the lines below):\n\n0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:134: Poco::E ('/TCPHandler.cpp',680) 3 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 18 ('/LoggerWrapper.h',42) 2 RunningMySQLqueryusingconnection Running MySQL query using connection 0 ('',0) 2 CodeDBExceptionCannotmodifyoutpu Code: 164. DB::Exception: Cannot modify \'output_format_json_quote_64bit_integers\' setting in readonly mode. (READONLY) (version 23.8.16.41.altinitystable (altinity build)) (from [::1]:38980) (comment: 00474_readonly_settings.sh) (in query: set output_forma ('/executeQuery.cpp',207) 2 CodeDBExceptionSyntaxerrorfailed Code: 62. DB::Exception: Syntax error: failed at position 2 (\'error\'): error here \n. Expected one of: Query, Query with output, EXPLAIN, SELECT query, possibly with UNION, list of union elements, SELECT query, subquery, possibly with UNION, SELECT subquery ('/executeQuery.cpp',207) 2 skippedconfiglatestconfig skipped config 1, latest config 18 ('/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.16.41.altinitystabl ('/executeQuery.cpp',207) 1 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',42) 1 Thesettingmergetreemetadatacache The setting \'merge_tree_metadata_cache\' is enabled. But the feature of \'metadata cache in RocksDB\' is experimental and is not ready for production. The usage of this feature can lead to data corruption and loss. The setting should be disabled in production ('',0) 1 TablesystemsessionlogisenabledIt Table system.session_log is enabled. It\'s unreliable and may contain garbage. Do not use it for any kind of security monitoring. ('',0) 1 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',42) 1 ThreadFuzzerisenabledApplication ThreadFuzzer is enabled. Application will run slowly and unstable. ('',0) 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_docker/./contrib/llvm-project/libcxx/include/exception:134: Poco::Exception::Exception ('/Exception.cpp',235) 1 newconfigurationlogidxprevlogidx new configuration: log idx 261, prev log idx 18\npeer 1, DC ID 0, localhost:9234, voting member, 1\nmy id: 1, leader: 1, term: 3 ('/LoggerWrapper.h',42) 1 ConnectingtosystemasuserUSER Connecting to system@127.0.0.1:9004 as user 02834_USER_8996 ('',0) 1 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',42) 1 snapshotidxlogtermcreatedcompact snapshot idx 10000 log_term 3 created, compact the log store if needed ('/LoggerWrapper.h',42) 1 detectaconfigurationchangethatis detect a configuration change that is not committed yet at index 1 ('/LoggerWrapper.h',42) 1 statemachinecommitindexprecommit state machine commit index 0, precommit index 260, last log index 260 ('/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 Forkedachildprocesstowatch Forked a child process to watch ('',0) 1 systemasuserUSERRemovingconnecti (system@127.0.0.1:9004 as user 02834_USER_8996): Removing connection. ('',0) 1 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',42) 1 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1\nmy id: 1, voting_member\nnum peers: 0 ('/LoggerWrapper.h',42) 1 INITRAFTSERVERcommitindextermele === INIT RAFT SERVER ===\ncommit index 0\nterm 2\nelection timer allowed\nlog store start 1, end 260\nconfig log idx 18, prev log idx 1 ('/LoggerWrapper.h',42) 1 createsnapshotidxlogtermdoneusel create snapshot idx 10000 log_term 3 done: 372 us elapsed ('/LoggerWrapper.h',42) 1 CreatinganewMySQLconnectiontosys Creating a new MySQL connection to system@127.0.0.1:9004 as user 02834_USER_8996 with settings: connect_timeout=10, read_write_timeout=300 ('',0) 1 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 261 ('/LoggerWrapper.h',42) Top messages that does not match its format string: message_format_string count() any_message LowCardinality(String) UInt64 String {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 244 /var/lib/clickhouse/disks/s3_disk/store/4f1/4f117e07-f6fd-4e22-85b0-e3cb70d722d1/tmp_merge_201403_1_8_1/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 1 similar messages) 55 Forked a child process to watch Top short messages: c message_format_string substring(any(message), 1, 120) min_length_without_exception_boilerplate UInt64 LowCardinality(String) String Int64 5 Session expired void DB::StorageReplicatedMergeTree::queueUpdatingTask(): Code: 999. Coordination::Exception: Session expired. (KEEPER_E 85 2 Froze {} parts Froze 1 parts -13 2 Substitution {} is not set Code: 456. DB::Exception: Substitution `s` is not set. (UNKNOWN_QUERY_PARAMETER) (version 23.8.16.41.altinitystable (alt 29 1 Found {} on {} Found changelog_1_100000.bin.zstd on LocalLogDisk 23 Top messages by level: (0.0009439517548921262,'Database {} does not exist. Maybe you meant {}?') Error (0.0000798956030786439,'Client has gone away.') Warning (0.008528115854542656,'Setting download as failed: {}') Information (0.0442296140450552,'(from {}{}{}){}{} {} (stage: {})') Debug (0.051633273263676206,'Created HTTP(S) session with {}:{} ({}:{})') Trace 2024-09-24 02:57:18,559 Stress test finished + echo -e 'Test script exit code\tOK\t\N\t' + grep -Fa OK + rg -Fa 'No queries hung' /test_output/test_results.tsv No queries hung OK \N + stop + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=1728 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1728. The process with pid = 1728 is running. Sent terminate signal to process with pid 1728. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1728. The process with pid = 1728 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1728. The process with pid = 1728 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1728. The process with pid = 1728 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1728. The process with pid = 1728 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1728. The process with pid = 1728 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1728. The process with pid = 1728 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1728. The process with pid = 1728 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1728. The process with pid = 1728 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1728. The process with pid = 1728 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 127.0.0.1 - - [24/Sep/2024:00:57:30 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [24/Sep/2024:00:57:30 +0000] "PUT /devstoreaccount1/cont/vjeyrcleqbwiiaieurlcwwnafqkywyca?blockid=hrkuthorvjpvnfscnzghmezfcjrcfiachaxoavnahqlbddxalgjwmrmmdxwbjvpv&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [24/Sep/2024:00:57:30 +0000] "PUT /devstoreaccount1/cont/vjeyrcleqbwiiaieurlcwwnafqkywyca?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [24/Sep/2024:00:57:30 +0000] "GET /devstoreaccount1/cont/vjeyrcleqbwiiaieurlcwwnafqkywyca HTTP/1.1" 206 4 127.0.0.1 - - [24/Sep/2024:00:57:30 +0000] "GET /devstoreaccount1/cont/vjeyrcleqbwiiaieurlcwwnafqkywyca HTTP/1.1" 206 2 127.0.0.1 - - [24/Sep/2024:00:57:30 +0000] "DELETE /devstoreaccount1/cont/vjeyrcleqbwiiaieurlcwwnafqkywyca HTTP/1.1" 202 - + 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' 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 634246 + run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' + [[ hxB =~ e ]] + set_e=false + set +e + local total_retries=60 + shift + local retry=0 + '[' 0 -ge 60 ']' + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb + false + return + check_server_start + clickhouse-client --query 'SELECT '\''Server successfully started'\'', '\''OK'\'', NULL, '\'''\''' + '[' -s /test_output/application_errors.txt ']' + rm /test_output/application_errors.txt rm: cannot remove '/test_output/application_errors.txt': No such file or directory + stop + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=634246 + 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 = 634246. The process with pid = 634246 is running. Sent terminate signal to process with pid 634246. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 634246. The process with pid = 634246 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 634246. The process with pid = 634246 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 634246. The process with pid = 634246 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 634246. The process with pid = 634246 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