+ 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+msan_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+msan_amd64.deb ... Unpacking clickhouse-common-static (23.8.16.41.altinitystable+msan) ... Setting up clickhouse-common-static (23.8.16.41.altinitystable+msan) ... + dpkg -i package_folder/clickhouse-common-static-dbg_23.8.16.41.altinitystable+msan_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+msan_amd64.deb ... Unpacking clickhouse-common-static-dbg (23.8.16.41.altinitystable+msan) ... Setting up clickhouse-common-static-dbg (23.8.16.41.altinitystable+msan) ... + dpkg -i package_folder/clickhouse-server_23.8.16.41.altinitystable+msan_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+msan_amd64.deb ... Unpacking clickhouse-server (23.8.16.41.altinitystable+msan) ... Setting up clickhouse-server (23.8.16.41.altinitystable+msan) ... 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+msan_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+msan_amd64.deb ... Unpacking clickhouse-client (23.8.16.41.altinitystable+msan) ... Setting up clickhouse-client (23.8.16.41.altinitystable+msan) ... + 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 + 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 + ./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 + ./minio server --address :11111 ./minio_data + local url=http://localhost:11111 + params=('--silent' '--verbose') + local params + 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 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 3 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=4 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 4 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=5 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 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 + [[ 7 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=8 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 8 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=9 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 9 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=10 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 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:37987 http://127.0.0.1:37987 Documentation: https://docs.min.io WARNING: Console endpoint is listening on a dynamic port (37987), please use --console-address ":PORT" to choose a static port. + counter=11 + curl --silent --verbose http://localhost:11111 + grep AccessDenied AccessDeniedAccess Denied./17F80420D50040B3b94c8b6e-a3d5-419e-8cbf-a6c9c5209bbd + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 248 root 10u IPv6 55735 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 + 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 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: 115.56 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: 110.62 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: 4.04 KiB/s b.tsv + for file in $(ls "${data_path}") + echo b.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv clickminio/test/b.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv` -> `clickminio/test/b.tsv` Total: 0 B, Transferred: 33 B, Speed: 5.33 KiB/s c.tsv + for file in $(ls "${data_path}") + echo c.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv clickminio/test/c.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv` -> `clickminio/test/c.tsv` Total: 0 B, Transferred: 33 B, Speed: 5.70 KiB/s tsv_with_header.tsv + for file in $(ls "${data_path}") + echo tsv_with_header.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv clickminio/test/tsv_with_header.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv` -> `clickminio/test/tsv_with_header.tsv` Total: 0 B, Transferred: 44 B, Speed: 7.69 KiB/s + setup_aws_credentials + local minio_root_user=clickhouse + local minio_root_password=clickhouse + mkdir -p /root/.aws + cat + config_logs_export_cluster /etc/clickhouse-server/config.d/system_logs_export.yaml + set +x File /tmp/export-logs-config.sh does not exist, do not setup + start + counter=0 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 15 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=16 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 16 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=17 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 17 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=18 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 18 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=19 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 19 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=20 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 20 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=21 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 21 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=22 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 22 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=23 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 23 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=24 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 24 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=25 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 25 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=26 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 26 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=27 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 27 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=28 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 28 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=29 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 29 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=30 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 30 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=31 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 31 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=32 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 32 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=33 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 33 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=34 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 34 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=35 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 35 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=36 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 36 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=37 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 37 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=38 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 38 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=39 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 39 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=40 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 40 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=41 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 41 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=42 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 42 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=43 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 43 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=44 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 44 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=45 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 45 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=46 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 46 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=47 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 47 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=48 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 48 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=49 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 49 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=50 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 50 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=51 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 51 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=52 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 52 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=53 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 53 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=54 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 54 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=55 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 55 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=56 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 56 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=57 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 57 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=58 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 58 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=59 + clickhouse-client --query 'SELECT 1' 127.0.0.1 - - [23/Sep/2024:23:44:04 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [23/Sep/2024:23:44:04 +0000] "PUT /devstoreaccount1/cont/nsbxektqnkdxzcgwhjpzvfzrlkkiyxsp?blockid=wbfsyekravsteqrsotrkelxutwltczzitxchdjxbzgzqvkdbnpockiubbcwktfaw&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [23/Sep/2024:23:44:04 +0000] "PUT /devstoreaccount1/cont/nsbxektqnkdxzcgwhjpzvfzrlkkiyxsp?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [23/Sep/2024:23:44:04 +0000] "GET /devstoreaccount1/cont/nsbxektqnkdxzcgwhjpzvfzrlkkiyxsp HTTP/1.1" 206 4 127.0.0.1 - - [23/Sep/2024:23:44:04 +0000] "GET /devstoreaccount1/cont/nsbxektqnkdxzcgwhjpzvfzrlkkiyxsp HTTP/1.1" 206 2 127.0.0.1 - - [23/Sep/2024:23:44:04 +0000] "DELETE /devstoreaccount1/cont/nsbxektqnkdxzcgwhjpzvfzrlkkiyxsp HTTP/1.1" 202 - 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 521 + 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/u7xmdvac INFO:root:Content length is 1271623680 bytes INFO:root:Downloading finished INFO:root:Will unpack data from temp path /tmp/u7xmdvac to clickhouse db /var/lib/clickhouse/ INFO:root:Unpack finished INFO:root:Will remove downloaded file /tmp/u7xmdvac 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/wpwgysq9 INFO:root:Content length is 563968000 bytes INFO:root:Downloading finished INFO:root:Will unpack data from temp path /tmp/wpwgysq9 to clickhouse db /var/lib/clickhouse/ INFO:root:Unpack finished INFO:root:Will remove downloaded file /tmp/wpwgysq9 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=521 + 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 = 521. The process with pid = 521 is running. Sent terminate signal to process with pid 521. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 521. The process with pid = 521 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 521. The process with pid = 521 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 521. The process with pid = 521 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 521. The process with pid = 521 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 521. The process with pid = 521 is running. Waiting for server to stop Found pid = 521 in the list of running processes. The process with pid = 521 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.initial.log + start + counter=0 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 15 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=16 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 16 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=17 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 17 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=18 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 18 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=19 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 19 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=20 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 20 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=21 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 21 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=22 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 22 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=23 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 23 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=24 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 24 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=25 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 25 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=26 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 26 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=27 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 27 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=28 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 28 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=29 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 29 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=30 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 30 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=31 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 31 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=32 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 32 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=33 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 33 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=34 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 34 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=35 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 35 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=36 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 36 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=37 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 37 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=38 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 38 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=39 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 39 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=40 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 40 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=41 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 41 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=42 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 42 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=43 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 43 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=44 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 44 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=45 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 45 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=46 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 46 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=47 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 47 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=48 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 48 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=49 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 49 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=50 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 50 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=51 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 51 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=52 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 52 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=53 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 53 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=54 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 54 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=55 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 55 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=56 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 56 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=57 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 57 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=58 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 58 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=59 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 59 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=60 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 60 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=61 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 61 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=62 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 62 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=63 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 63 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=64 + clickhouse-client --query 'SELECT 1' 127.0.0.1 - - [23/Sep/2024:23:46:37 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [23/Sep/2024:23:46:37 +0000] "PUT /devstoreaccount1/cont/hlhroaxqssmsrmqdnzsuwfmzcdggkaqt?blockid=fycrunwrlyktjliutukamhljnynrijaktqfnvvofuygtwbcthnjneoeqnbmodsxr&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [23/Sep/2024:23:46:37 +0000] "PUT /devstoreaccount1/cont/hlhroaxqssmsrmqdnzsuwfmzcdggkaqt?comp=blocklist HTTP/1.1" 201 - Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 127.0.0.1 - - [23/Sep/2024:23:46:37 +0000] "GET /devstoreaccount1/cont/hlhroaxqssmsrmqdnzsuwfmzcdggkaqt HTTP/1.1" 206 4 127.0.0.1 - - [23/Sep/2024:23:46:37 +0000] "GET /devstoreaccount1/cont/hlhroaxqssmsrmqdnzsuwfmzcdggkaqt HTTP/1.1" 206 2 127.0.0.1 - - [23/Sep/2024:23:46:37 +0000] "DELETE /devstoreaccount1/cont/hlhroaxqssmsrmqdnzsuwfmzcdggkaqt HTTP/1.1" 202 - + '[' 64 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=65 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 65 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=66 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 66 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=67 + 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 1102 + 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=1102 + 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 = 1102. The process with pid = 1102 is running. Sent terminate signal to process with pid 1102. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1102. The process with pid = 1102 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1102. The process with pid = 1102 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1102. The process with pid = 1102 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1102. The process with pid = 1102 is running. Waiting for server to stop Found pid = 1102 in the list of running processes. The process with pid = 1102 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=1 + sed --follow-symlinks -i 's|true|1|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/ + [[ -n 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 + [[ -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/ Adding azure configuration + 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 + local max_users_mem + max_users_mem=9860806656 Setting max_memory_usage_for_user=9860806656 and max_memory_usage for queries to 10G + echo 'Setting max_memory_usage_for_user=9860806656 and max_memory_usage for queries to 10G' + cat + cat + cat + sudo cat /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sed 's|
s3
|
s3
default|' + mv /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml.tmp /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + 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 + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 15 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=16 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 16 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=17 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 17 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=18 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 18 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=19 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 19 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=20 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 20 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=21 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 21 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=22 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 22 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=23 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 23 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=24 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 24 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=25 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 25 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=26 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 26 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=27 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 27 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=28 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 28 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=29 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 29 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=30 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 30 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=31 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 31 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=32 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 32 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=33 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 33 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=34 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 34 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=35 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 35 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=36 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 36 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=37 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 37 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=38 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 38 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=39 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 39 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=40 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 40 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=41 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 41 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=42 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 42 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=43 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 43 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=44 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 44 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=45 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 45 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=46 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 46 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=47 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 47 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=48 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 48 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=49 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 49 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=50 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 50 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=51 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 51 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=52 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 52 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=53 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 53 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=54 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 54 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=55 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 55 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=56 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 56 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=57 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 57 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=58 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 58 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=59 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 59 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=60 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 60 -gt 120 ']' + clickhouse start --user root + sleep 0.5 127.0.0.1 - - [24/Sep/2024:00:24:10 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [24/Sep/2024:00:24:10 +0000] "PUT /devstoreaccount1/cont/wqifszptgphzornakwdgygydvdilwdcl?blockid=edzcisdovywswpvmiydjbtthldqsltihxnnwemxalkcdikixeernzidluijqmbhj&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [24/Sep/2024:00:24:10 +0000] "PUT /devstoreaccount1/cont/wqifszptgphzornakwdgygydvdilwdcl?comp=blocklist HTTP/1.1" 201 - + counter=61 + clickhouse-client --query 'SELECT 1' 127.0.0.1 - - [24/Sep/2024:00:24:10 +0000] "GET /devstoreaccount1/cont/wqifszptgphzornakwdgygydvdilwdcl HTTP/1.1" 206 4 127.0.0.1 - - [24/Sep/2024:00:24:10 +0000] "GET /devstoreaccount1/cont/wqifszptgphzornakwdgygydvdilwdcl HTTP/1.1" 206 2 127.0.0.1 - - [24/Sep/2024:00:24:10 +0000] "DELETE /devstoreaccount1/cont/wqifszptgphzornakwdgygydvdilwdcl HTTP/1.1" 202 - Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 61 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=62 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 62 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=63 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 63 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=64 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 64 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=65 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 65 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=66 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 66 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=67 + 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 2113 + 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:07,634 Run func tests '/usr/bin/clickhouse-test --global_time_limit=1200 ' 2024-09-24 02:25:08,136 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:08,637 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:09,138 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:09,640 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 ' 2024-09-24 02:25:10,141 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_5', 's1', 'r1')" --database=test_5 --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 join_algorithm='full_sorting_merge' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-09-24 02:25:10,642 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:11,143 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_7 --client-option join_use_nulls=1 join_algorithm='grace_hash' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-09-24 02:25:11,644 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_8', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 --global_time_limit=1200 ' 2024-09-24 02:25:12,145 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_9 --client-option join_algorithm='auto' max_rows_in_join=1000 use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-09-24 02:25:12,646 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 ' 2024-09-24 02:25:13,147 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:13,649 Run func tests '/usr/bin/clickhouse-test --order=random --client-option implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 --global_time_limit=1200 ' 2024-09-24 02:25:14,150 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:14,651 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_14', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 --global_time_limit=1200 ' 2024-09-24 02:25:15,152 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_merge' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-09-24 02:25:15,653 Will wait functests to finish 2024-09-24 02:25:15,654 Finished 0 from 16 processes 2024-09-24 02:25:20,657 Finished 0 from 16 processes 2024-09-24 02:25:25,662 Finished 0 from 16 processes 2024-09-24 02:25:30,666 Finished 0 from 16 processes 2024-09-24 02:25:35,671 Finished 0 from 16 processes 2024-09-24 02:25:40,674 Finished 0 from 16 processes 2024-09-24 02:25:45,678 Finished 0 from 16 processes 2024-09-24 02:25:50,682 Finished 0 from 16 processes 2024-09-24 02:25:55,686 Finished 0 from 16 processes 2024-09-24 02:26:00,690 Finished 0 from 16 processes 2024-09-24 02:26:05,694 Finished 0 from 16 processes 2024-09-24 02:26:10,698 Finished 0 from 16 processes 2024-09-24 02:26:15,702 Finished 0 from 16 processes 2024-09-24 02:26:20,706 Finished 0 from 16 processes 2024-09-24 02:26:25,710 Finished 0 from 16 processes 2024-09-24 02:26:30,714 Finished 0 from 16 processes 2024-09-24 02:26:35,719 Finished 0 from 16 processes 2024-09-24 02:26:40,722 Finished 0 from 16 processes 2024-09-24 02:26:45,726 Finished 0 from 16 processes 2024-09-24 02:26:50,730 Finished 0 from 16 processes 2024-09-24 02:26:55,734 Finished 0 from 16 processes 2024-09-24 02:27:00,738 Finished 0 from 16 processes 2024-09-24 02:27:05,742 Finished 0 from 16 processes 2024-09-24 02:27:10,747 Finished 0 from 16 processes 2024-09-24 02:27:15,750 Finished 0 from 16 processes 2024-09-24 02:27:20,754 Finished 0 from 16 processes 2024-09-24 02:27:25,758 Finished 0 from 16 processes 2024-09-24 02:27:30,762 Finished 0 from 16 processes 2024-09-24 02:27:35,766 Finished 0 from 16 processes 2024-09-24 02:27:40,771 Finished 0 from 16 processes 2024-09-24 02:27:45,775 Finished 0 from 16 processes 2024-09-24 02:27:50,780 Finished 0 from 16 processes 2024-09-24 02:27:55,782 Finished 0 from 16 processes 2024-09-24 02:28:00,786 Finished 0 from 16 processes 2024-09-24 02:28:05,788 Finished 0 from 16 processes 2024-09-24 02:28:10,790 Finished 0 from 16 processes 2024-09-24 02:28:15,794 Finished 0 from 16 processes 2024-09-24 02:28:20,798 Finished 0 from 16 processes 2024-09-24 02:28:25,802 Finished 0 from 16 processes 2024-09-24 02:28:30,806 Finished 0 from 16 processes 2024-09-24 02:28:35,810 Finished 0 from 16 processes 2024-09-24 02:28:40,814 Finished 0 from 16 processes 2024-09-24 02:28:45,818 Finished 0 from 16 processes 2024-09-24 02:28:50,822 Finished 0 from 16 processes 2024-09-24 02:28:55,826 Finished 0 from 16 processes 2024-09-24 02:29:00,830 Finished 0 from 16 processes 2024-09-24 02:29:05,834 Finished 0 from 16 processes 2024-09-24 02:29:10,838 Finished 0 from 16 processes 2024-09-24 02:29:15,842 Finished 0 from 16 processes 2024-09-24 02:29:20,847 Finished 0 from 16 processes 2024-09-24 02:29:25,850 Finished 0 from 16 processes 2024-09-24 02:29:30,854 Finished 0 from 16 processes 2024-09-24 02:29:35,858 Finished 0 from 16 processes 2024-09-24 02:29:40,862 Finished 0 from 16 processes 2024-09-24 02:29:45,866 Finished 0 from 16 processes 2024-09-24 02:29:50,870 Finished 0 from 16 processes 2024-09-24 02:29:55,874 Finished 0 from 16 processes 2024-09-24 02:30:00,878 Finished 0 from 16 processes 2024-09-24 02:30:05,882 Finished 0 from 16 processes 2024-09-24 02:30:10,886 Finished 0 from 16 processes 2024-09-24 02:30:15,890 Finished 0 from 16 processes 2024-09-24 02:30:20,894 Finished 0 from 16 processes 2024-09-24 02:30:25,899 Finished 0 from 16 processes 2024-09-24 02:30:30,902 Finished 0 from 16 processes 2024-09-24 02:30:35,906 Finished 0 from 16 processes 2024-09-24 02:30:40,914 Finished 0 from 16 processes 2024-09-24 02:30:45,918 Finished 0 from 16 processes 2024-09-24 02:30:50,923 Finished 0 from 16 processes 2024-09-24 02:30:55,928 Finished 0 from 16 processes 2024-09-24 02:31:00,933 Finished 0 from 16 processes 2024-09-24 02:31:05,938 Finished 0 from 16 processes 2024-09-24 02:31:10,942 Finished 0 from 16 processes 2024-09-24 02:31:15,946 Finished 0 from 16 processes 2024-09-24 02:31:20,950 Finished 0 from 16 processes 2024-09-24 02:31:25,954 Finished 0 from 16 processes 2024-09-24 02:31:30,956 Finished 0 from 16 processes 2024-09-24 02:31:35,958 Finished 0 from 16 processes 2024-09-24 02:31:40,962 Finished 0 from 16 processes 2024-09-24 02:31:45,966 Finished 0 from 16 processes 2024-09-24 02:31:50,970 Finished 0 from 16 processes 2024-09-24 02:31:55,975 Finished 0 from 16 processes 2024-09-24 02:32:00,978 Finished 0 from 16 processes 2024-09-24 02:32:05,982 Finished 0 from 16 processes 2024-09-24 02:32:10,988 Finished 0 from 16 processes 2024-09-24 02:32:15,990 Finished 0 from 16 processes 2024-09-24 02:32:20,994 Finished 0 from 16 processes 2024-09-24 02:32:25,998 Finished 0 from 16 processes 2024-09-24 02:32:31,003 Finished 0 from 16 processes 2024-09-24 02:32:36,006 Finished 0 from 16 processes 2024-09-24 02:32:41,010 Finished 0 from 16 processes 2024-09-24 02:32:46,014 Finished 0 from 16 processes 2024-09-24 02:32:51,018 Finished 0 from 16 processes 2024-09-24 02:32:56,022 Finished 0 from 16 processes 2024-09-24 02:33:01,027 Finished 0 from 16 processes 2024-09-24 02:33:06,030 Finished 0 from 16 processes 2024-09-24 02:33:11,034 Finished 0 from 16 processes 2024-09-24 02:33:16,038 Finished 0 from 16 processes 2024-09-24 02:33:21,042 Finished 0 from 16 processes 2024-09-24 02:33:26,046 Finished 0 from 16 processes 2024-09-24 02:33:31,050 Finished 0 from 16 processes 2024-09-24 02:33:36,054 Finished 0 from 16 processes 2024-09-24 02:33:41,058 Finished 0 from 16 processes 2024-09-24 02:33:46,062 Finished 0 from 16 processes 2024-09-24 02:33:51,066 Finished 0 from 16 processes 2024-09-24 02:33:56,070 Finished 0 from 16 processes 2024-09-24 02:34:01,074 Finished 0 from 16 processes 2024-09-24 02:34:06,078 Finished 0 from 16 processes 2024-09-24 02:34:11,082 Finished 0 from 16 processes 2024-09-24 02:34:16,086 Finished 0 from 16 processes 2024-09-24 02:34:21,091 Finished 0 from 16 processes 2024-09-24 02:34:26,094 Finished 0 from 16 processes 2024-09-24 02:34:31,098 Finished 0 from 16 processes 2024-09-24 02:34:36,102 Finished 0 from 16 processes 2024-09-24 02:34:41,106 Finished 0 from 16 processes 2024-09-24 02:34:46,110 Finished 0 from 16 processes 2024-09-24 02:34:51,114 Finished 0 from 16 processes 2024-09-24 02:34:56,118 Finished 0 from 16 processes 2024-09-24 02:35:01,122 Finished 0 from 16 processes 2024-09-24 02:35:06,126 Finished 0 from 16 processes 2024-09-24 02:35:11,130 Finished 0 from 16 processes 2024-09-24 02:35:16,134 Finished 0 from 16 processes 2024-09-24 02:35:21,138 Finished 0 from 16 processes 2024-09-24 02:35:26,139 Finished 0 from 16 processes 2024-09-24 02:35:31,142 Finished 0 from 16 processes 2024-09-24 02:35:36,147 Finished 1 from 16 processes 2024-09-24 02:35:41,150 Finished 1 from 16 processes 2024-09-24 02:35:46,154 Finished 1 from 16 processes 2024-09-24 02:35:51,158 Finished 1 from 16 processes 2024-09-24 02:35:56,163 Finished 1 from 16 processes 2024-09-24 02:36:01,168 Finished 1 from 16 processes 2024-09-24 02:36:06,173 Finished 1 from 16 processes 2024-09-24 02:36:11,178 Finished 1 from 16 processes 2024-09-24 02:36:16,180 Finished 1 from 16 processes 2024-09-24 02:36:21,182 Finished 1 from 16 processes 2024-09-24 02:36:26,187 Finished 1 from 16 processes 2024-09-24 02:36:31,192 Finished 1 from 16 processes 2024-09-24 02:36:36,194 Finished 1 from 16 processes 2024-09-24 02:36:41,199 Finished 1 from 16 processes 2024-09-24 02:36:46,202 Finished 1 from 16 processes 2024-09-24 02:36:51,207 Finished 1 from 16 processes 2024-09-24 02:36:56,213 Finished 1 from 16 processes 2024-09-24 02:37:01,217 Finished 1 from 16 processes 2024-09-24 02:37:06,222 Finished 1 from 16 processes 2024-09-24 02:37:11,226 Finished 1 from 16 processes 2024-09-24 02:37:16,230 Finished 1 from 16 processes 2024-09-24 02:37:21,234 Finished 1 from 16 processes 2024-09-24 02:37:26,238 Finished 1 from 16 processes 2024-09-24 02:37:31,242 Finished 1 from 16 processes 2024-09-24 02:37:36,246 Finished 1 from 16 processes 2024-09-24 02:37:41,251 Finished 1 from 16 processes 2024-09-24 02:37:46,256 Finished 1 from 16 processes 2024-09-24 02:37:51,259 Finished 1 from 16 processes 2024-09-24 02:37:56,262 Finished 1 from 16 processes 2024-09-24 02:38:01,268 Finished 1 from 16 processes 2024-09-24 02:38:06,270 Finished 1 from 16 processes 2024-09-24 02:38:11,274 Finished 1 from 16 processes 2024-09-24 02:38:16,279 Finished 1 from 16 processes 2024-09-24 02:38:21,282 Finished 1 from 16 processes 2024-09-24 02:38:26,287 Finished 1 from 16 processes 2024-09-24 02:38:31,290 Finished 2 from 16 processes 2024-09-24 02:38:36,294 Finished 2 from 16 processes 2024-09-24 02:38:41,295 Finished 2 from 16 processes 2024-09-24 02:38:46,300 Finished 2 from 16 processes 2024-09-24 02:38:51,302 Finished 3 from 16 processes 2024-09-24 02:38:56,304 Finished 3 from 16 processes 2024-09-24 02:39:01,308 Finished 3 from 16 processes 2024-09-24 02:39:06,310 Finished 3 from 16 processes 2024-09-24 02:39:11,315 Finished 3 from 16 processes 2024-09-24 02:39:16,318 Finished 3 from 16 processes 2024-09-24 02:39:21,322 Finished 4 from 16 processes 2024-09-24 02:39:26,327 Finished 4 from 16 processes 2024-09-24 02:39:31,333 Finished 4 from 16 processes 2024-09-24 02:39:36,337 Finished 4 from 16 processes 2024-09-24 02:39:41,342 Finished 4 from 16 processes 2024-09-24 02:39:46,346 Finished 4 from 16 processes 2024-09-24 02:39:51,350 Finished 4 from 16 processes 2024-09-24 02:39:56,353 Finished 4 from 16 processes 2024-09-24 02:40:01,357 Finished 4 from 16 processes 2024-09-24 02:40:06,358 Finished 4 from 16 processes 2024-09-24 02:40:11,359 Finished 4 from 16 processes 2024-09-24 02:40:16,362 Finished 4 from 16 processes 2024-09-24 02:40:21,367 Finished 4 from 16 processes 2024-09-24 02:40:26,370 Finished 4 from 16 processes 2024-09-24 02:40:31,373 Finished 4 from 16 processes 2024-09-24 02:40:36,378 Finished 4 from 16 processes 2024-09-24 02:40:41,382 Finished 5 from 16 processes 2024-09-24 02:40:46,386 Finished 5 from 16 processes 2024-09-24 02:40:51,390 Finished 5 from 16 processes 2024-09-24 02:40:56,395 Finished 5 from 16 processes 2024-09-24 02:41:01,396 Finished 5 from 16 processes 2024-09-24 02:41:06,398 Finished 5 from 16 processes 2024-09-24 02:41:11,402 Finished 5 from 16 processes 2024-09-24 02:41:16,406 Finished 5 from 16 processes 2024-09-24 02:41:21,412 Finished 5 from 16 processes 2024-09-24 02:41:26,417 Finished 7 from 16 processes 2024-09-24 02:41:31,422 Finished 7 from 16 processes 2024-09-24 02:41:36,426 Finished 7 from 16 processes 2024-09-24 02:41:41,431 Finished 7 from 16 processes 2024-09-24 02:41:46,436 Finished 7 from 16 processes 2024-09-24 02:41:51,442 Finished 7 from 16 processes 2024-09-24 02:41:56,447 Finished 7 from 16 processes 2024-09-24 02:42:01,452 Finished 7 from 16 processes 2024-09-24 02:42:06,457 Finished 7 from 16 processes 2024-09-24 02:42:11,463 Finished 7 from 16 processes 2024-09-24 02:42:16,468 Finished 7 from 16 processes 2024-09-24 02:42:21,473 Finished 7 from 16 processes 2024-09-24 02:42:26,478 Finished 7 from 16 processes 2024-09-24 02:42:31,484 Finished 7 from 16 processes 2024-09-24 02:42:36,489 Finished 7 from 16 processes 2024-09-24 02:42:41,490 Finished 7 from 16 processes 2024-09-24 02:42:46,495 Finished 7 from 16 processes 2024-09-24 02:42:51,499 Finished 7 from 16 processes 2024-09-24 02:42:56,502 Finished 7 from 16 processes 2024-09-24 02:43:01,506 Finished 7 from 16 processes 2024-09-24 02:43:06,511 Finished 7 from 16 processes 2024-09-24 02:43:11,514 Finished 7 from 16 processes 2024-09-24 02:43:16,519 Finished 7 from 16 processes 2024-09-24 02:43:21,522 Finished 7 from 16 processes 2024-09-24 02:43:26,527 Finished 7 from 16 processes 2024-09-24 02:43:31,533 Finished 7 from 16 processes 2024-09-24 02:43:36,538 Finished 7 from 16 processes 2024-09-24 02:43:41,542 Finished 7 from 16 processes 2024-09-24 02:43:46,547 Finished 7 from 16 processes 2024-09-24 02:43:51,553 Finished 7 from 16 processes 2024-09-24 02:43:56,554 Finished 7 from 16 processes 2024-09-24 02:44:01,558 Finished 7 from 16 processes 2024-09-24 02:44:06,561 Finished 7 from 16 processes 2024-09-24 02:44:11,562 Finished 7 from 16 processes 2024-09-24 02:44:16,566 Finished 7 from 16 processes 2024-09-24 02:44:21,567 Finished 7 from 16 processes 2024-09-24 02:44:26,570 Finished 7 from 16 processes 2024-09-24 02:44:31,576 Finished 7 from 16 processes 2024-09-24 02:44:36,578 Finished 7 from 16 processes 2024-09-24 02:44:41,582 Finished 7 from 16 processes 2024-09-24 02:44:46,586 Finished 7 from 16 processes 2024-09-24 02:44:51,591 Finished 7 from 16 processes 2024-09-24 02:44:56,594 Finished 7 from 16 processes 2024-09-24 02:45:01,598 Finished 7 from 16 processes 2024-09-24 02:45:06,602 Finished 7 from 16 processes 2024-09-24 02:45:11,606 Finished 7 from 16 processes 2024-09-24 02:45:16,609 Finished 7 from 16 processes 2024-09-24 02:45:21,615 Finished 8 from 16 processes 2024-09-24 02:45:26,620 Finished 10 from 16 processes 2024-09-24 02:45:31,624 Finished 13 from 16 processes 2024-09-24 02:45:36,626 Finished 13 from 16 processes 2024-09-24 02:45:41,630 Finished 13 from 16 processes 2024-09-24 02:45:46,634 Finished 13 from 16 processes 2024-09-24 02:45:51,637 Finished 14 from 16 processes 2024-09-24 02:45:56,642 Finished 15 from 16 processes 2024-09-24 02:46:01,647 Finished 15 from 16 processes 2024-09-24 02:46:06,653 Finished 15 from 16 processes 2024-09-24 02:46:11,658 Finished 15 from 16 processes 2024-09-24 02:46:16,662 Finished 15 from 16 processes 2024-09-24 02:46:21,667 All processes finished 2024-09-24 02:46:21,668 Compressing stress logs 2024-09-24 02:46:21,701 Logs compressed 2024-09-24 02:46:21,701 Will terminate gdb (if any) Quit 2024-09-24 02:51:27,898 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.61 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) 11465 0.044 792.75 KiB 0.023 3 208 ['Trace'] 0.003 Access granted: {}{} 10768 0.041 1009.56 KiB 0.029 1 2396 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 10631 0.041 309.66 KiB 0.009 1 2442 ['Trace'] 0 Aggregation method: {} 9128 0.035 720.77 KiB 0.021 1 1083 ['Debug'] 0.224 Remove from cache. Key: {}, offset: {}, size: {} 8905 0.034 1.60 MiB 0.047 1 85 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 8650 0.033 1.30 MiB 0.038 2 85 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 8402 0.032 90.26 KiB 0.003 1 2353 ['Trace'] 0 Aggregating 7757 0.03 219.21 KiB 0.006 1 97 ['Debug'] 0.001 Processed in {} sec. 6705 0.026 399.42 KiB 0.011 1 86 ['Debug'] 0.991 Key {} is removed from metadata 6648 0.026 552.15 KiB 0.016 1 2294 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 6195 0.024 418.01 KiB 0.012 26 2480 ['Trace'] 0 Running binary search on index range for part {} ({} marks) 6195 0.024 174.87 KiB 0.005 26 2480 ['Trace'] 0 Found {} range in {} steps 6195 0.024 187.31 KiB 0.005 26 2480 ['Trace'] 0 Found (RIGHT) boundary mark: {} 6195 0.024 181.16 KiB 0.005 26 2480 ['Trace'] 0 Found (LEFT) boundary mark: {} 6156 0.024 147.60 KiB 0.004 1 163 ['Trace'] 0.013 {} -> {} 5673 0.022 326.86 KiB 0.009 1 725 ['Debug'] 0.112 Submitting key {} for removal 5603 0.022 250.13 KiB 0.007 1 1 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 5590 0.021 708.48 KiB 0.02 1 80 ['Trace'] 0.046 PREWHERE condition was split into {} steps: {} 5497 0.021 446.64 KiB 0.013 1 79 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 4534 0.017 518.04 KiB 0.015 165 1326 ['Trace'] 0 Bypassing cache because file segment state is `PARTIALLY_DOWNLOADED_NO_CONTINUATION` and downloaded part already used 3696 0.014 415.08 KiB 0.012 3 191 ['Debug'] 0.991 {} Authenticated with global context as user {} 3696 0.014 304.76 KiB 0.009 3 191 ['Debug'] 0.991 {} Authenticating user \'{}\' from {} 3651 0.014 399.33 KiB 0.011 2 154 ['Debug'] 1 {} Creating session context with user_id: {} 3621 0.014 318.25 KiB 0.009 3 134 ['Debug'] 0.99 {} Logout, user_id: {} 3538 0.014 153.18 KiB 0.004 1 106 ['Debug'] 0.103 Peak memory usage{}: {}. 3481 0.013 302.23 KiB 0.009 1 62 ['Trace'] 0 Reading {} ranges in order from part {}, approx. {} rows starting from {} 3089 0.012 302.95 KiB 0.009 1 921 ['Debug'] 0.169 Will evict {} file segments (while reserving {} bytes for {}:{}) 2779 0.011 250.96 KiB 0.007 1 154 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 2778 0.011 93.63 KiB 0.003 1 154 ['Trace'] 1 TCP Request. Address: {} 2650 0.01 69.87 KiB 0.002 1 94 ['Debug'] 1 Done processing connection. 2368 0.009 591.03 KiB 0.017 1 31 ['Information'] 0.105 WriteBufferFromS3 is not finalized in destructor. The file might not be written to S3. {}. 2120 0.008 97.66 KiB 0.003 1 922 ['Debug'] 0 Aggregated. {} to {} rows (from {}) 2078 0.008 144.19 KiB 0.004 183 342 ['Trace'] 0.706 Trying to reserve {} using storage policy from min volume index {} 2076 0.008 83.12 KiB 0.002 1 1075 ['Trace'] 0 Converting aggregation data to two-level. 2066 0.008 40.35 KiB 0.001 1 934 ['Trace'] 0 Aggregating in order 2038 0.008 75.37 KiB 0.002 144 113 ['Debug'] 0.022 Key condition: {} 1997 0.008 233.92 KiB 0.007 141 113 ['Debug'] 0.023 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 1942 0.007 182.54 KiB 0.005 1 22 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 1901 0.007 90.46 KiB 0.003 1 235 ['Trace'] 0.555 filled checksums {} 1888 0.007 223.47 KiB 0.006 188 243 ['Trace'] 0.557 Renaming temporary part {} to {} with tid {}. 1828 0.007 94.61 KiB 0.003 126 108 ['Trace'] 0.024 Spreading mark ranges among streams (default reading) 1775 0.007 567.23 KiB 0.016 690 816 ['Information'] 0.041 Setting download as failed: {} 1706 0.007 38.32 KiB 0.001 1 1141 ['Trace'] 0 Merging aggregated data 1686 0.006 58.30 KiB 0.002 46 83 ['Debug'] 0.008 MinMax index condition: {} 1458 0.006 207.04 KiB 0.006 14 48 ['Debug'] 0 Part: {}, sum_marks: {}, approx mark size: {}, prefetch_step_bytes: {}, prefetch_step_marks: {}, (ranges: {}) 1319 0.005 95.68 KiB 0.003 1 80 ['Trace'] 0.02 The min valid primary key position for moving to the tail of PREWHERE is {} 1279 0.005 766.70 KiB 0.022 1 107 ['Debug'] 0.988 Objects with paths [{}] were removed from S3 1158 0.004 63.59 KiB 0.002 1 446 ['Trace'] 0.115 Created HTTP(S) session with {}:{} ({}:{}) 1156 0.004 41.38 KiB 0.001 12 12 ['Trace'] 1 Flushed system log up to offset {} 1150 0.004 172.07 KiB 0.005 1 245 ['Debug'] 0 Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.) 1148 0.004 56.51 KiB 0.002 1 244 ['Trace'] 0 Merging partially aggregated blocks (bucket = {}). 1109 0.004 64.21 KiB 0.002 12 12 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 1092 0.004 1.62 MiB 0.048 1 96 ['Debug'] 0.987 metadata and objects were removed for [{}], only metadata were removed for [{}]. 1088 0.004 135.22 KiB 0.004 1 2 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 1062 0.004 119.31 KiB 0.003 1 80 ['Debug'] 0.025 MergeTreeWhereOptimizer: condition "{}" moved to PREWHERE 1013 0.004 83.65 KiB 0.002 205 503 ['Trace'] 0 No space left in cache to reserve {} bytes, will continue without cache download 966 0.004 74.53 KiB 0.002 1 69 ['Trace'] 0 Query span trace_id for opentelemetry log: {} 907 0.003 373.69 KiB 0.011 2 54 ['Trace'] 1 Request URI: {} 907 0.003 158.88 KiB 0.005 2 54 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {} 848 0.003 17.39 KiB 0 2 57 ['Debug'] 0.032 Done processing query 724 0.003 30.10 KiB 0.001 45 98 ['Debug'] 0.059 Reading approx. {} rows with {} streams 710 0.003 2.38 MiB 0.07 1 128 ['Error'] 1 Table is in readonly mode (replica path: {}) 668 0.003 74.86 KiB 0.002 1 16 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 643 0.002 66.15 KiB 0.002 67 468 ['Trace'] 0 Predownload failed because of space limit. Will read from remote filesystem starting from offset: {} 609 0.002 45.05 KiB 0.001 15 444 ['Trace'] 0.085 Used generic exclusion search over index for part {} with {} steps 606 0.002 4.80 MiB 0.14 24 98 ['Error'] 0.526 Memory limit{}{} exceeded: would use {} (attempt to allocate chunk of {} bytes), maximum: {}.{}{} 579 0.002 73.92 KiB 0.002 1 23 ['Debug'] 0 ({}) Datatype: {}, kind: {}, strictness: {}, right header: {} 579 0.002 5.09 KiB 0 2 49 ['Trace'] 0.003 No tables 579 0.002 23.04 KiB 0.001 1 23 ['Debug'] 0 ({}) Keys: {} 563 0.002 93.58 KiB 0.003 1 131 ['Debug'] 0.757 Recursively remove path {}: metadata and objects were removed for [{}], only metadata were removed for [{}]. 559 0.002 45.56 KiB 0.001 1 26 ['Trace'] 0.005 ({}) Join data is being destroyed, {} bytes and {} rows in hash table 502 0.002 40.89 KiB 0.001 1 397 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={} 468 0.002 14.66 KiB 0 1 94 ['Debug'] 0.092 min_marks_for_concurrent_read={} 459 0.002 72.84 KiB 0.002 17 394 ['Debug'] 0 Sent data for {} scalars, total {} rows in {} sec., {} rows/sec., {} ({}/sec.), compressed {} times to {} ({}/sec.) 452 0.002 9.96 KiB 0 29 130 ['Trace'] 1 Execution took {} ms. 441 0.002 39.60 KiB 0.001 1 397 ['Debug'] 0 Merge sorted {} blocks, {} rows in {} sec., {} rows/sec., {}/sec 423 0.002 13.32 KiB 0 16 20 ['Debug'] 0 Requested flush up to offset {} 417 0.002 30.95 KiB 0.001 1 56 ['Debug'] 0 Waiting for table {} to be finally dropped 416 0.002 82.48 KiB 0.002 1 123 ['Information'] 1 Removing metadata {} of dropped table {} 415 0.002 52.66 KiB 0.002 1 123 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {} 404 0.002 6.31 KiB 0 116 114 ['Debug'] 1 Scheduling tasks 398 0.002 88.61 KiB 0.003 116 114 ['Trace'] 1 scheduleTasks: initialized={}, size_before_filtering={}, queue_size={}, entries={}..{}, first_failed_task_name={}, current_tasks_size={}, last_current_task={}, last_skipped_entry_name={} 397 0.002 9.69 KiB 0 116 114 ['Debug'] 1 Waiting for queue updates 393 0.002 19.96 KiB 0.001 115 113 ['Debug'] 1 Will schedule {} tasks starting from {} 393 0.002 11.51 KiB 0 115 113 ['Trace'] 1 Checking task {} 392 0.002 37.94 KiB 0.001 115 113 ['Debug'] 1 Will not execute task {}: {} 349 0.001 18.06 KiB 0.001 41 127 ['Debug'] 0.957 Selected {} parts from {} to {} 349 0.001 28.36 KiB 0.001 1 22 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {} 342 0.001 11.62 KiB 0 1 22 ['Debug'] 0 Selected MergeAlgorithm: {} 326 0.001 67.41 KiB 0.002 51 13 ['Information'] 1 {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 325 0.001 16.56 KiB 0 18 267 ['Trace'] 0 Connecting. Database: {}. User: {}{}{} 323 0.001 24.78 KiB 0.001 1 49 ['Debug'] 0 Will kill query {} (synchronously) 320 0.001 14.69 KiB 0 18 266 ['Trace'] 0 Connected to {} server version {}.{}.{}. 307 0.001 37.38 KiB 0.001 1 28 ['Debug'] 0 Before join block: \'{}\' 306 0.001 51.18 KiB 0.001 1 28 ['Debug'] 0 After join block: \'{}\' 300 0.001 19.21 KiB 0.001 1 255 ['Trace'] 0 Creating set, key: {} 293 0.001 5.44 KiB 0 290 49 ['Information'] 0.014 Starting up tables. 293 0.001 23.96 KiB 0.001 290 49 ['Information'] 0.014 Metadata processed, database {} has {} tables and {} dictionaries in total. 291 0.001 17.31 KiB 0 1 49 ['Information'] 0.007 Parsed metadata of {} tables in {} databases in {} sec 283 0.001 21.83 KiB 0.001 3 56 ['Trace'] 0.94 Settings: readonly = {}, allow_ddl = {}, allow_introspection_functions = {} Top messages without format string (fmt::runtime): count pattern runtime_message line UInt64 String String Tuple(String, UInt64) 6 CodeDBExceptionReceivedfromDBExc Code: 507. DB::Exception: Received from 127.0.0.2:9000. DB::Exception: Sharding key modulo(sub_key, 2) is not used. Stack trace:\n\n0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:134: Poco::Exception::Exception(String const&, int) @ 0x0000 ('/executeQuery.cpp',207) 4 CodeDBErrnoExceptionCannotopenfi Code: 107. DB::ErrnoException: Cannot open file /var/lib/clickhouse/format_schemas/nonexist, errno: 2, strerror: No such file or directory: While executing File. (FILE_DOESNT_EXIST) (version 23.8.16.41.altinitystable (altinity build)) (from [::1]:36258) (i ('/executeQuery.cpp',207) 3 CodeDBErrnoExceptionCannotrmdirv Code: 566. DB::ErrnoException: Cannot rmdir /var/lib/clickhouse/disks/s3/store/ac8/ac860a65-c7ac-46f7-9b65-d9351c8c648b/tmp_merge_202409_62_67_1/, errno: 2, strerror: No such file or directory. (CANNOT_RMDIR), Stack trace (when copying this message, always ('/Exception.cpp',235) 3 Exceptionwhileexecutingbackgroun Exception while executing background task {ac860a65-c7ac-46f7-9b65-d9351c8c648b::lambda}: Code: 566. DB::ErrnoException: Cannot rmdir /var/lib/clickhouse/disks/s3/store/ac8/ac860a65-c7ac-46f7-9b65-d9351c8c648b/tmp_merge_202409_62_67_1/, errno: 2, strerror: ('/Exception.cpp',235) 3 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 18 ('/LoggerWrapper.h',42) 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 239, 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 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',42) 1 detectaconfigurationchangethatis detect a configuration change that is not committed yet at index 1 ('/LoggerWrapper.h',42) 1 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/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 INITRAFTSERVERcommitindextermele === INIT RAFT SERVER ===\ncommit index 0\nterm 2\nelection timer allowed\nlog store start 1, end 238\nconfig log idx 18, prev log idx 1 ('/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 statemachinecommitindexprecommit state machine commit index 0, precommit index 238, last log index 238 ('/LoggerWrapper.h',42) 1 newconfiglogidxprevlogidxcurconf new config log idx 239, prev log idx 18, cur config log idx 18, prev log idx 1 ('/LoggerWrapper.h',42) 1 CodeDBExceptionSyntaxerrorfailed Code: 62. DB::Exception: Syntax error: failed at position 8 (\'(\'): ([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([([. Unmatched parentheses: ([([ ('/Exception.cpp',235) 1 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',42) 1 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',42) 1 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 239 ('/LoggerWrapper.h',42) 1 ELECTIONTIMEOUTcurrentrolefollow [ELECTION TIMEOUT] current role: follower, log last term 2, state term 2, target p 1, my p 1, hb dead, pre-vote NOT done ('/LoggerWrapper.h',42) 1 ServerwasbuiltwithsanitizerItwil Server was built with sanitizer. It will work slowly. ('',0) 1 startingup starting up ('',0) 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) 142 /var/lib/clickhouse/disks/s3_disk/store/fc5/fc5ff1b5-b7bd-4122-8a88-50cb28f33be3/tmp_merge_201403_1_8_1/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 1 similar messages) 37 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 6 Database {} does not exist Code: 81. DB::Exception: Database kek does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always 28 2 Froze {} parts Froze 1 parts -13 1 Session expired void DB::StorageReplicatedMergeTree::mutationsUpdatingTask(): Code: 999. Coordination::Exception: Session expired. (KEEP 89 1 Found {} on {} Found changelog_1_100000.bin.zstd on LocalLogDisk 23 Top messages by level: (0.002726124334307315,'Table is in readonly mode (replica path: {})') Error (0.00018430136344612833,'Client has gone away.') Warning (0.009092200596675664,'WriteBufferFromS3 is not finalized in destructor. The file might not be written to S3. {}.') Information (0.035047975948672073,'Remove from cache. Key: {}, offset: {}, size: {}') Debug (0.044036507028409284,'Access granted: {}{}') Trace 2024-09-24 02:51:49,430 Stress test finished + echo -e 'Test script exit code\tOK\t\N\t' + rg -Fa 'No queries hung' /test_output/test_results.tsv + grep -Fa OK No queries hung OK \N + stop + local max_tries=90 + local check_hang=true + local pid ++ cat /var/run/clickhouse-server/clickhouse-server.pid + pid=2113 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 is running. Sent terminate signal to process with pid 2113. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 2113. The process with pid = 2113 does not exist. Server stopped + return + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.stress.log + unset THREAD_FUZZER_CPU_TIME_PERIOD_US THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY THREAD_FUZZER_SLEEP_PROBABILITY THREAD_FUZZER_SLEEP_TIME_US THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US + start + counter=0 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=15 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 15 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=16 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 16 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=17 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 17 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=18 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 18 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=19 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 19 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=20 + clickhouse-client --query 'SELECT 1' 127.0.0.1 - - [24/Sep/2024:00:52:19 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 127.0.0.1 - - [24/Sep/2024:00:52:19 +0000] "PUT /devstoreaccount1/cont/vjzledtratkewbxwmcqjtxzoufizfpst?blockid=nentxisaasgzgvphsxjzvxjakijixotbrsgvngwvookghmtyjmoveyvttpbwlyvm&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [24/Sep/2024:00:52:19 +0000] "PUT /devstoreaccount1/cont/vjzledtratkewbxwmcqjtxzoufizfpst?comp=blocklist HTTP/1.1" 201 - + '[' 20 -gt 120 ']' + clickhouse start --user root 127.0.0.1 - - [24/Sep/2024:00:52:19 +0000] "GET /devstoreaccount1/cont/vjzledtratkewbxwmcqjtxzoufizfpst HTTP/1.1" 206 4 127.0.0.1 - - [24/Sep/2024:00:52:19 +0000] "GET /devstoreaccount1/cont/vjzledtratkewbxwmcqjtxzoufizfpst HTTP/1.1" 206 2 127.0.0.1 - - [24/Sep/2024:00:52:19 +0000] "DELETE /devstoreaccount1/cont/vjzledtratkewbxwmcqjtxzoufizfpst HTTP/1.1" 202 - + sleep 0.5 + counter=21 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 21 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=22 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 22 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=23 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 23 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=24 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 24 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=25 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 25 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=26 + clickhouse-client --query 'SELECT 1' 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 26129 + 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=26129 + 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 = 26129. The process with pid = 26129 is running. Sent terminate signal to process with pid 26129. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 26129. The process with pid = 26129 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 26129. The process with pid = 26129 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 26129. The process with pid = 26129 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 26129. The process with pid = 26129 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 26129. The process with pid = 26129 is running. Waiting for server to stop Found pid = 26129 in the list of running processes. The process with pid = 26129 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + '[' -f /var/log/clickhouse-server/clickhouse-server.log ']' + '[' -f /var/log/clickhouse-server/stderr.log ']' + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.final.log + check_logs_for_critical_errors + rg -Fa ================== /var/log/clickhouse-server/stderr.log + rg -v 'in query:' + rg -Fa WARNING /var/log/clickhouse-server/stderr.log + rg -Fav -e 'ASan doesn'\''t fully support makecontext/swapcontext functions' -e DB::Exception /test_output/tmp + echo -e 'No sanitizer asserts\tOK\t\N\t' + rm -f /test_output/tmp + rg -Fa ' Application: Child process was terminated by signal 9' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No OOM messages in clickhouse-server.log\tOK\t\N\t' + rg -Fa 'Code: 49. DB::Exception: ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No logical errors\tOK\t\N\t' + '[' -s /test_output/logical_errors.txt ']' + rm /test_output/logical_errors.txt + rg --text 'Code: 499.*The specified key does not exist' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No lost s3 keys\tOK\t\N\t' + '[' -s /test_output/no_such_key_errors.txt ']' + rm /test_output/no_such_key_errors.txt + rg -Fa '########################################' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'Not crashed\tOK\t\N\t' + rg -Fa ' ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No fatal messages in clickhouse-server.log\tOK\t\N\t' + '[' -s /test_output/fatal_messages.txt ']' + rm /test_output/fatal_messages.txt + rg -Faz '########################################' /test_output/gdb.log /test_output/stress_run_logs.tar.zst /test_output/test_results.tsv + rg -Fa ' received signal ' /test_output/gdb.log + dmesg -T + grep -q -F -e 'Out of memory: Killed process' -e 'oom_reaper: reaped process' -e oom-kill:constraint=CONSTRAINT_NONE /test_output/dmesg.log + echo -e 'No OOM in dmesg\tOK\t\N\t' + tar -chf /test_output/coordination.tar /var/lib/clickhouse/coordination tar: Removing leading `/' from member names tar: Removing leading `/' from hard link targets + collect_query_and_trace_logs + for table in query_log trace_log + clickhouse-local --path /var/lib/clickhouse/ --only-system-tables -q 'select * from system.query_log format TSVWithNamesAndTypes' + zstd --threads=0 + for table in query_log trace_log + clickhouse-local --path /var/lib/clickhouse/ --only-system-tables -q 'select * from system.trace_log format TSVWithNamesAndTypes' + zstd --threads=0 + mv /var/log/clickhouse-server/stderr.log /test_output/ + clickhouse-local --structure 'test String, res String, time Nullable(Float32), desc String' -q 'SELECT '\''failure'\'', test FROM table WHERE res != '\''OK'\'' order by (test like '\''%Sanitizer%'\'') DESC, (test like '\''%Killed by signal%'\'') DESC, (test like '\''%gdb.log%'\'') DESC, (test ilike '\''%possible deadlock%'\'') DESC, (test like '\''%start%'\'') DESC, (test like '\''%dmesg%'\'') DESC, (test like '\''%OOM%'\'') DESC, (test like '\''%Signal 9%'\'') DESC, (test like '\''%Fatal message%'\'') DESC, rowNumberInAllBlocks() LIMIT 1' + '[' -s /test_output/check_status.tsv ']' + echo -e 'success\tNo errors found' + rg 'OOM in dmesg|Signal 9' /test_output/check_status.tsv + collect_core_dumps + find . -type f -maxdepth 1 -name 'core.*' + read core