+ 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/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.3.19.33.altinitystable+msan_amd64.deb Selecting previously unselected package clickhouse-common-static. (Reading database ... 55078 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static_23.3.19.33.altinitystable+msan_amd64.deb ... Unpacking clickhouse-common-static (23.3.19.33.altinitystable+msan) ... Setting up clickhouse-common-static (23.3.19.33.altinitystable+msan) ... + dpkg -i package_folder/clickhouse-common-static-dbg_23.3.19.33.altinitystable+msan_amd64.deb Selecting previously unselected package clickhouse-common-static-dbg. (Reading database ... 55092 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static-dbg_23.3.19.33.altinitystable+msan_amd64.deb ... Unpacking clickhouse-common-static-dbg (23.3.19.33.altinitystable+msan) ... Setting up clickhouse-common-static-dbg (23.3.19.33.altinitystable+msan) ... + dpkg -i package_folder/clickhouse-server_23.3.19.33.altinitystable+msan_amd64.deb Selecting previously unselected package clickhouse-server. (Reading database ... 55101 files and directories currently installed.) Preparing to unpack .../clickhouse-server_23.3.19.33.altinitystable+msan_amd64.deb ... Unpacking clickhouse-server (23.3.19.33.altinitystable+msan) ... Setting up clickhouse-server (23.3.19.33.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. 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 Processing triggers for systemd (245.4-4ubuntu3.23) ... + dpkg -i package_folder/clickhouse-client_23.3.19.33.altinitystable+msan_amd64.deb Selecting previously unselected package clickhouse-client. (Reading database ... 55115 files and directories currently installed.) Preparing to unpack .../clickhouse-client_23.3.19.33.altinitystable+msan_amd64.deb ... Unpacking clickhouse-client (23.3.19.33.altinitystable+msan) ... Setting up clickhouse-client (23.3.19.33.altinitystable+msan) ... ++ clickhouse local -q 'select value like '\''% -fsanitize=thread %'\'' from system.build_options where name='\''CXX_FLAGS'\''' + is_tsan_build=0 + '[' 0 -eq 0 ']' + 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/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_test.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/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/ + '[' /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/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 x86_64 Adding azure configuration + [[ -n 1 ]] + echo x86_64 + [[ '' -eq 1 ]] + [[ x86_64 == \a\a\r\c\h\6\4 ]] + echo 'Adding azure configuration' + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|100000|10000|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\''' + export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + sudo chown root: /var/lib/clickhouse + echo '1' + local total_mem ++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo + total_mem=32098980 + total_mem=32869355520 + max_server_memory_usage_to_ram_ratio=0.5 + 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 + local url=http://localhost:11111 + params=(--silent --verbose) + ./minio server --address :11111 ./minio_data + 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 trying to connect to minio + [[ 3 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=4 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 4 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=5 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 5 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=6 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 6 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=7 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 7 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=8 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 8 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=9 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 9 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=10 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 10 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 API: http://172.17.0.2:11111 http://127.0.0.1:11111 Console: http://172.17.0.2:34591 http://127.0.0.1:34591 Documentation: https://docs.min.io WARNING: Console endpoint is listening on a dynamic port (34591), please use --console-address ":PORT" to choose a static port. + counter=11 + curl --silent --verbose http://localhost:11111 + grep AccessDenied AccessDeniedAccess Denied./17B8BDD2BAE534EAab389b72-749e-4984-83fa-8901cb1d7633 + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 243 root 10u IPv6 22500 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 + 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 a.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv` -> `clickminio/test/a.tsv` Total: 0 B, Transferred: 24 B, Speed: 2.92 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: 3.00 KiB/s + for file in $(ls "${data_path}") + echo c.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv clickminio/test/c.tsv c.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv` -> `clickminio/test/c.tsv` Total: 0 B, Transferred: 33 B, Speed: 4.29 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: 4.47 KiB/s + setup_aws_credentials + local minio_root_user=clickhouse + local minio_root_password=clickhouse + mkdir -p /root/.aws + cat + 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 127.0.0.1 - - [01/Mar/2024:20:27:17 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:20:27:17 +0000] "PUT /devstoreaccount1/cont/sphyftgjtwlencmnikpliqefsmprgnhx?blockid=zigsgzjrkqegkgadcifdpxhdpumrmubdjcekkbowgizlbqqhzdmsfebyktegzdey&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:20:27:17 +0000] "PUT /devstoreaccount1/cont/sphyftgjtwlencmnikpliqefsmprgnhx?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:20:27:17 +0000] "GET /devstoreaccount1/cont/sphyftgjtwlencmnikpliqefsmprgnhx HTTP/1.1" 206 4 127.0.0.1 - - [01/Mar/2024:20:27:17 +0000] "GET /devstoreaccount1/cont/sphyftgjtwlencmnikpliqefsmprgnhx HTTP/1.1" 206 2 127.0.0.1 - - [01/Mar/2024:20:27:17 +0000] "DELETE /devstoreaccount1/cont/sphyftgjtwlencmnikpliqefsmprgnhx HTTP/1.1" 202 - + counter=55 + clickhouse-client --query 'SELECT 1' 1 ++ 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 502 + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb real 0m1.189s user 0m0.393s sys 0m0.105s + shellcheck disable=SC2086 /run.sh: line 59: shellcheck: command not found + /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/8inld1gz INFO:root:Content length is 1271623680 bytes INFO:root:Downloading finished INFO:root:Will unpack data from temp path /tmp/8inld1gz to clickhouse db /var/lib/clickhouse/ INFO:root:Unpack finished INFO:root:Will remove downloaded file /tmp/8inld1gz 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/sfp_a8aq INFO:root:Content length is 563968000 bytes INFO:root:Downloading finished INFO:root:Will unpack data from temp path /tmp/sfp_a8aq to clickhouse db /var/lib/clickhouse/ INFO:root:Unpack finished INFO:root:Will remove downloaded file /tmp/sfp_a8aq 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=502 + 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 = 502. The process with pid = 502 is running. Sent terminate signal to process with pid 502. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 502. The process with pid = 502 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 502. The process with pid = 502 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 502. The process with pid = 502 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 502. The process with pid = 502 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 502. The process with pid = 502 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 502. The process with pid = 502 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 502. The process with pid = 502 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 502. The process with pid = 502 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' 127.0.0.1 - - [01/Mar/2024:20:29:20 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 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 127.0.0.1 - - [01/Mar/2024:20:29:23 +0000] "PUT /devstoreaccount1/cont/vdkcplonhhylxsyefxvnxpxbtdkkkwjm?blockid=nwjcimdpoepbqgxrasafszpyqithskvvigypspuxvizmxuqfflvcrakriirvnmwt&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:20:29:23 +0000] "PUT /devstoreaccount1/cont/vdkcplonhhylxsyefxvnxpxbtdkkkwjm?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:20:29:23 +0000] "GET /devstoreaccount1/cont/vdkcplonhhylxsyefxvnxpxbtdkkkwjm HTTP/1.1" 206 4 127.0.0.1 - - [01/Mar/2024:20:29:23 +0000] "GET /devstoreaccount1/cont/vdkcplonhhylxsyefxvnxpxbtdkkkwjm HTTP/1.1" 206 2 127.0.0.1 - - [01/Mar/2024:20:29:23 +0000] "DELETE /devstoreaccount1/cont/vdkcplonhhylxsyefxvnxpxbtdkkkwjm HTTP/1.1" 202 - + 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' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 67 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=68 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 68 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=69 + clickhouse-client --query 'SELECT 1' 1 ++ 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 1034 + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb real 0m1.284s user 0m0.413s sys 0m0.065s + 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=1034 + 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 = 1034. The process with pid = 1034 is running. Sent terminate signal to process with pid 1034. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1034. The process with pid = 1034 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1034. The process with pid = 1034 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1034. The process with pid = 1034 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1034. The process with pid = 1034 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1034. The process with pid = 1034 is running. Waiting for server to stop Found pid = 1034 in the list of running processes. The process with pid = 1034 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' Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + mkdir -p /etc/clickhouse-server/config.d/ + mkdir -p /etc/clickhouse-server/users.d/ + mkdir -p /etc/clickhouse-client + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disks.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/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_test.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/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/ + '[' /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/timeouts.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/ + ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + rm -f /etc/clickhouse-server/config.d/zookeeper.xml + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/ + create_snapshot_on_exit=0 + sed --follow-symlinks -i 's|true|0|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/ + [[ -n 1 ]] + [[ 1 -eq 1 ]] + ln -sf /usr/share/clickhouse-test/config/config.d/s3_storage_policy_by_default.xml /etc/clickhouse-server/config.d/ + ARM=aarch64 ++ uname -m + OS=x86_64 x86_64 Adding azure configuration + [[ -n 1 ]] + echo x86_64 + [[ '' -eq 1 ]] + [[ x86_64 == \a\a\r\c\h\6\4 ]] + echo 'Adding azure configuration' + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|100000|10000|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\''' + export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + sudo chown root: /var/lib/clickhouse + echo '1' + local total_mem ++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo + total_mem=32098980 + total_mem=32869355520 + max_server_memory_usage_to_ram_ratio=0.5 Setting max_server_memory_usage_to_ram_ratio to 0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat + local max_users_mem + max_users_mem=9860806656 + echo 'Setting max_memory_usage_for_user=9860806656 and max_memory_usage for queries to 10G' + cat Setting max_memory_usage_for_user=9860806656 and max_memory_usage for queries to 10G + cat + cat + sudo cat /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sed 's|
s3
|
s3
default|' + mv /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml.tmp /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml + 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' 127.0.0.1 - - [01/Mar/2024:21:14:58 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 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 127.0.0.1 - - [01/Mar/2024:21:15:02 +0000] "PUT /devstoreaccount1/cont/wastftwicbmczadrbzrntciotkgeehbf?blockid=xblyqoaiexxrmxotfmzkpxhonzrklflowmwpcjkizbmrdxxupmddrcqavemnkdhv&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:21:15:02 +0000] "PUT /devstoreaccount1/cont/wastftwicbmczadrbzrntciotkgeehbf?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:21:15:02 +0000] "GET /devstoreaccount1/cont/wastftwicbmczadrbzrntciotkgeehbf HTTP/1.1" 206 4 127.0.0.1 - - [01/Mar/2024:21:15:02 +0000] "GET /devstoreaccount1/cont/wastftwicbmczadrbzrntciotkgeehbf HTTP/1.1" 206 2 127.0.0.1 - - [01/Mar/2024:21:15:02 +0000] "DELETE /devstoreaccount1/cont/wastftwicbmczadrbzrntciotkgeehbf HTTP/1.1" 202 - + 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' 1 ++ 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 1983 + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb real 0m1.066s user 0m0.410s sys 0m0.092s + stress --hung-check --drop-databases --output-folder test_output --skip-func-tests '' --global-time-limit 1200 2024-03-02 00:15:17,533 Run func tests '/usr/bin/clickhouse-test --global_time_limit=1200 ' 2024-03-02 00:15:18,036 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-03-02 00:15:18,539 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 allow_experimental_query_cache=1 use_query_cache=1 --global_time_limit=1200 ' 2024-03-02 00:15:19,042 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-03-02 00:15:19,544 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 ' 2024-03-02 00:15:20,047 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 join_algorithm='full_sorting_merge' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-03-02 00:15:20,550 Run func tests '/usr/bin/clickhouse-test --order=random --client-option memory_tracker_fault_probability=0.001 --global_time_limit=1200 ' 2024-03-02 00:15:21,052 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_7 --client-option join_use_nulls=1 join_algorithm='grace_hash' allow_experimental_query_cache=1 use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-03-02 00:15:21,555 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 --global_time_limit=1200 ' 2024-03-02 00:15:22,057 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_9 --client-option join_algorithm='auto' max_rows_in_join=1000 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-03-02 00:15:22,559 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 ' 2024-03-02 00:15:23,062 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 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-03-02 00:15:23,564 Run func tests '/usr/bin/clickhouse-test --order=random --client-option allow_experimental_query_cache=1 use_query_cache=1 implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 --global_time_limit=1200 ' 2024-03-02 00:15:24,067 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-03-02 00:15:24,570 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 allow_experimental_query_cache=1 use_query_cache=1 --global_time_limit=1200 ' 2024-03-02 00:15:25,072 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_merge' allow_experimental_query_cache=1 use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-03-02 00:15:25,574 Will wait functests to finish 2024-03-02 00:15:25,575 Finished 0 from 16 processes 2024-03-02 00:15:30,576 Finished 0 from 16 processes 2024-03-02 00:15:35,580 Finished 0 from 16 processes 2024-03-02 00:15:40,586 Finished 0 from 16 processes 2024-03-02 00:15:45,588 Finished 0 from 16 processes 2024-03-02 00:15:50,592 Finished 0 from 16 processes 2024-03-02 00:15:55,596 Finished 0 from 16 processes 2024-03-02 00:16:00,600 Finished 0 from 16 processes 2024-03-02 00:16:05,604 Finished 0 from 16 processes 2024-03-02 00:16:10,610 Finished 0 from 16 processes 2024-03-02 00:16:15,612 Finished 0 from 16 processes 2024-03-02 00:16:20,614 Finished 0 from 16 processes 2024-03-02 00:16:25,619 Finished 0 from 16 processes 2024-03-02 00:16:30,620 Finished 0 from 16 processes 2024-03-02 00:16:35,625 Finished 0 from 16 processes 2024-03-02 00:16:40,628 Finished 0 from 16 processes 2024-03-02 00:16:45,632 Finished 0 from 16 processes 2024-03-02 00:16:50,636 Finished 0 from 16 processes 2024-03-02 00:16:55,640 Finished 0 from 16 processes 2024-03-02 00:17:00,644 Finished 0 from 16 processes 2024-03-02 00:17:05,649 Finished 0 from 16 processes 2024-03-02 00:17:10,654 Finished 0 from 16 processes 2024-03-02 00:17:15,656 Finished 0 from 16 processes 2024-03-02 00:17:20,661 Finished 0 from 16 processes 2024-03-02 00:17:25,665 Finished 0 from 16 processes 2024-03-02 00:17:30,668 Finished 0 from 16 processes 2024-03-02 00:17:35,672 Finished 0 from 16 processes 2024-03-02 00:17:40,677 Finished 0 from 16 processes 2024-03-02 00:17:45,677 Finished 0 from 16 processes 2024-03-02 00:17:50,682 Finished 0 from 16 processes 2024-03-02 00:17:55,684 Finished 0 from 16 processes 2024-03-02 00:18:00,689 Finished 0 from 16 processes 2024-03-02 00:18:05,692 Finished 0 from 16 processes 2024-03-02 00:18:10,696 Finished 0 from 16 processes 2024-03-02 00:18:15,700 Finished 0 from 16 processes 2024-03-02 00:18:20,704 Finished 0 from 16 processes 2024-03-02 00:18:25,708 Finished 0 from 16 processes 2024-03-02 00:18:30,712 Finished 0 from 16 processes 2024-03-02 00:18:35,716 Finished 0 from 16 processes 2024-03-02 00:18:40,720 Finished 0 from 16 processes 2024-03-02 00:18:45,724 Finished 0 from 16 processes 2024-03-02 00:18:50,728 Finished 0 from 16 processes 2024-03-02 00:18:55,732 Finished 0 from 16 processes 2024-03-02 00:19:00,738 Finished 0 from 16 processes 2024-03-02 00:19:05,741 Finished 0 from 16 processes 2024-03-02 00:19:10,747 Finished 0 from 16 processes 2024-03-02 00:19:15,752 Finished 0 from 16 processes 2024-03-02 00:19:20,756 Finished 0 from 16 processes 2024-03-02 00:19:25,760 Finished 0 from 16 processes 2024-03-02 00:19:30,764 Finished 0 from 16 processes 2024-03-02 00:19:35,768 Finished 0 from 16 processes 2024-03-02 00:19:40,772 Finished 0 from 16 processes 2024-03-02 00:19:45,776 Finished 0 from 16 processes 2024-03-02 00:19:50,782 Finished 0 from 16 processes 2024-03-02 00:19:55,787 Finished 0 from 16 processes 2024-03-02 00:20:00,788 Finished 0 from 16 processes 2024-03-02 00:20:05,792 Finished 0 from 16 processes 2024-03-02 00:20:10,796 Finished 0 from 16 processes 2024-03-02 00:20:15,800 Finished 0 from 16 processes 2024-03-02 00:20:20,804 Finished 0 from 16 processes 2024-03-02 00:20:25,808 Finished 0 from 16 processes 2024-03-02 00:20:30,812 Finished 0 from 16 processes 2024-03-02 00:20:35,816 Finished 0 from 16 processes 2024-03-02 00:20:40,821 Finished 0 from 16 processes 2024-03-02 00:20:45,824 Finished 0 from 16 processes 2024-03-02 00:20:50,828 Finished 0 from 16 processes 2024-03-02 00:20:55,832 Finished 0 from 16 processes 2024-03-02 00:21:00,836 Finished 0 from 16 processes 2024-03-02 00:21:05,842 Finished 0 from 16 processes 2024-03-02 00:21:10,847 Finished 0 from 16 processes 2024-03-02 00:21:15,847 Finished 0 from 16 processes 2024-03-02 00:21:20,852 Finished 0 from 16 processes 2024-03-02 00:21:25,857 Finished 0 from 16 processes 2024-03-02 00:21:30,860 Finished 0 from 16 processes 2024-03-02 00:21:35,865 Finished 0 from 16 processes 2024-03-02 00:21:40,868 Finished 0 from 16 processes 2024-03-02 00:21:45,872 Finished 0 from 16 processes 2024-03-02 00:21:50,876 Finished 0 from 16 processes 2024-03-02 00:21:55,880 Finished 0 from 16 processes 2024-03-02 00:22:00,884 Finished 0 from 16 processes 2024-03-02 00:22:05,888 Finished 0 from 16 processes 2024-03-02 00:22:10,892 Finished 0 from 16 processes 2024-03-02 00:22:15,897 Finished 0 from 16 processes 2024-03-02 00:22:20,900 Finished 0 from 16 processes 2024-03-02 00:22:25,904 Finished 0 from 16 processes 2024-03-02 00:22:30,909 Finished 0 from 16 processes 2024-03-02 00:22:35,912 Finished 0 from 16 processes 2024-03-02 00:22:40,916 Finished 0 from 16 processes 2024-03-02 00:22:45,922 Finished 0 from 16 processes 2024-03-02 00:22:50,925 Finished 0 from 16 processes 2024-03-02 00:22:55,928 Finished 0 from 16 processes 2024-03-02 00:23:00,931 Finished 0 from 16 processes 2024-03-02 00:23:05,937 Finished 0 from 16 processes 2024-03-02 00:23:10,940 Finished 0 from 16 processes 2024-03-02 00:23:15,944 Finished 0 from 16 processes 2024-03-02 00:23:20,948 Finished 0 from 16 processes 2024-03-02 00:23:25,952 Finished 0 from 16 processes 2024-03-02 00:23:30,956 Finished 0 from 16 processes 2024-03-02 00:23:35,960 Finished 0 from 16 processes 2024-03-02 00:23:40,964 Finished 0 from 16 processes 2024-03-02 00:23:45,968 Finished 0 from 16 processes 2024-03-02 00:23:50,972 Finished 0 from 16 processes 2024-03-02 00:23:55,976 Finished 0 from 16 processes 2024-03-02 00:24:00,980 Finished 0 from 16 processes 2024-03-02 00:24:05,985 Finished 0 from 16 processes 2024-03-02 00:24:10,987 Finished 0 from 16 processes 2024-03-02 00:24:15,993 Finished 0 from 16 processes 2024-03-02 00:24:20,998 Finished 0 from 16 processes 2024-03-02 00:24:26,000 Finished 0 from 16 processes 2024-03-02 00:24:31,004 Finished 0 from 16 processes 2024-03-02 00:24:36,008 Finished 0 from 16 processes 2024-03-02 00:24:41,012 Finished 0 from 16 processes 2024-03-02 00:24:46,016 Finished 0 from 16 processes 2024-03-02 00:24:51,020 Finished 0 from 16 processes 2024-03-02 00:24:56,024 Finished 0 from 16 processes 2024-03-02 00:25:01,028 Finished 0 from 16 processes 2024-03-02 00:25:06,032 Finished 0 from 16 processes 2024-03-02 00:25:11,036 Finished 0 from 16 processes 2024-03-02 00:25:16,040 Finished 0 from 16 processes 2024-03-02 00:25:21,042 Finished 0 from 16 processes 2024-03-02 00:25:26,044 Finished 0 from 16 processes 2024-03-02 00:25:31,049 Finished 0 from 16 processes 2024-03-02 00:25:36,052 Finished 0 from 16 processes 2024-03-02 00:25:41,058 Finished 0 from 16 processes 2024-03-02 00:25:46,063 Finished 0 from 16 processes 2024-03-02 00:25:51,068 Finished 0 from 16 processes 2024-03-02 00:25:56,072 Finished 0 from 16 processes 2024-03-02 00:26:01,077 Finished 0 from 16 processes 2024-03-02 00:26:06,080 Finished 0 from 16 processes 2024-03-02 00:26:11,085 Finished 0 from 16 processes 2024-03-02 00:26:16,088 Finished 0 from 16 processes 2024-03-02 00:26:21,089 Finished 0 from 16 processes 2024-03-02 00:26:26,092 Finished 0 from 16 processes 2024-03-02 00:26:31,096 Finished 0 from 16 processes 2024-03-02 00:26:36,100 Finished 0 from 16 processes 2024-03-02 00:26:41,104 Finished 0 from 16 processes 2024-03-02 00:26:46,105 Finished 0 from 16 processes 2024-03-02 00:26:51,108 Finished 0 from 16 processes 2024-03-02 00:26:56,111 Finished 1 from 16 processes 2024-03-02 00:27:01,117 Finished 2 from 16 processes 2024-03-02 00:27:06,122 Finished 2 from 16 processes 2024-03-02 00:27:11,124 Finished 2 from 16 processes 2024-03-02 00:27:16,127 Finished 2 from 16 processes 2024-03-02 00:27:21,129 Finished 2 from 16 processes 2024-03-02 00:27:26,132 Finished 2 from 16 processes 2024-03-02 00:27:31,136 Finished 2 from 16 processes 2024-03-02 00:27:36,140 Finished 2 from 16 processes 2024-03-02 00:27:41,144 Finished 2 from 16 processes 2024-03-02 00:27:46,148 Finished 2 from 16 processes 2024-03-02 00:27:51,152 Finished 2 from 16 processes 2024-03-02 00:27:56,156 Finished 2 from 16 processes 2024-03-02 00:28:01,160 Finished 2 from 16 processes 2024-03-02 00:28:06,164 Finished 2 from 16 processes 2024-03-02 00:28:11,168 Finished 2 from 16 processes 2024-03-02 00:28:16,173 Finished 2 from 16 processes 2024-03-02 00:28:21,176 Finished 2 from 16 processes 2024-03-02 00:28:26,180 Finished 2 from 16 processes 2024-03-02 00:28:31,186 Finished 2 from 16 processes 2024-03-02 00:28:36,191 Finished 2 from 16 processes 2024-03-02 00:28:41,196 Finished 2 from 16 processes 2024-03-02 00:28:46,200 Finished 2 from 16 processes 2024-03-02 00:28:51,204 Finished 2 from 16 processes 2024-03-02 00:28:56,207 Finished 2 from 16 processes 2024-03-02 00:29:01,212 Finished 2 from 16 processes 2024-03-02 00:29:06,214 Finished 2 from 16 processes 2024-03-02 00:29:11,216 Finished 2 from 16 processes 2024-03-02 00:29:16,220 Finished 2 from 16 processes 2024-03-02 00:29:21,224 Finished 2 from 16 processes 2024-03-02 00:29:26,228 Finished 2 from 16 processes 2024-03-02 00:29:31,232 Finished 2 from 16 processes 2024-03-02 00:29:36,236 Finished 2 from 16 processes 2024-03-02 00:29:41,240 Finished 2 from 16 processes 2024-03-02 00:29:46,246 Finished 2 from 16 processes 2024-03-02 00:29:51,248 Finished 2 from 16 processes 2024-03-02 00:29:56,250 Finished 2 from 16 processes 2024-03-02 00:30:01,252 Finished 2 from 16 processes 2024-03-02 00:30:06,253 Finished 2 from 16 processes 2024-03-02 00:30:11,256 Finished 2 from 16 processes 2024-03-02 00:30:16,260 Finished 2 from 16 processes 2024-03-02 00:30:21,264 Finished 2 from 16 processes 2024-03-02 00:30:26,268 Finished 2 from 16 processes 2024-03-02 00:30:31,272 Finished 2 from 16 processes 2024-03-02 00:30:36,277 Finished 2 from 16 processes 2024-03-02 00:30:41,281 Finished 2 from 16 processes 2024-03-02 00:30:46,284 Finished 2 from 16 processes 2024-03-02 00:30:51,288 Finished 2 from 16 processes 2024-03-02 00:30:56,292 Finished 2 from 16 processes 2024-03-02 00:31:01,297 Finished 2 from 16 processes 2024-03-02 00:31:06,300 Finished 2 from 16 processes 2024-03-02 00:31:11,304 Finished 2 from 16 processes 2024-03-02 00:31:16,308 Finished 2 from 16 processes 2024-03-02 00:31:21,312 Finished 2 from 16 processes 2024-03-02 00:31:26,318 Finished 2 from 16 processes 2024-03-02 00:31:31,321 Finished 2 from 16 processes 2024-03-02 00:31:36,326 Finished 2 from 16 processes 2024-03-02 00:31:41,332 Finished 2 from 16 processes 2024-03-02 00:31:46,336 Finished 2 from 16 processes 2024-03-02 00:31:51,340 Finished 2 from 16 processes 2024-03-02 00:31:56,346 Finished 2 from 16 processes 2024-03-02 00:32:01,348 Finished 2 from 16 processes 2024-03-02 00:32:06,354 Finished 2 from 16 processes 2024-03-02 00:32:11,356 Finished 2 from 16 processes 2024-03-02 00:32:16,360 Finished 2 from 16 processes 2024-03-02 00:32:21,364 Finished 2 from 16 processes 2024-03-02 00:32:26,369 Finished 2 from 16 processes 2024-03-02 00:32:31,374 Finished 2 from 16 processes 2024-03-02 00:32:36,379 Finished 2 from 16 processes 2024-03-02 00:32:41,380 Finished 2 from 16 processes 2024-03-02 00:32:46,384 Finished 2 from 16 processes 2024-03-02 00:32:51,388 Finished 2 from 16 processes 2024-03-02 00:32:56,392 Finished 2 from 16 processes 2024-03-02 00:33:01,396 Finished 2 from 16 processes 2024-03-02 00:33:06,400 Finished 2 from 16 processes 2024-03-02 00:33:11,404 Finished 2 from 16 processes 2024-03-02 00:33:16,408 Finished 2 from 16 processes 2024-03-02 00:33:21,412 Finished 2 from 16 processes 2024-03-02 00:33:26,417 Finished 2 from 16 processes 2024-03-02 00:33:31,419 Finished 2 from 16 processes 2024-03-02 00:33:36,424 Finished 2 from 16 processes 2024-03-02 00:33:41,428 Finished 2 from 16 processes 2024-03-02 00:33:46,431 Finished 2 from 16 processes 2024-03-02 00:33:51,436 Finished 2 from 16 processes 2024-03-02 00:33:56,441 Finished 2 from 16 processes 2024-03-02 00:34:01,446 Finished 2 from 16 processes 2024-03-02 00:34:06,448 Finished 2 from 16 processes 2024-03-02 00:34:11,452 Finished 3 from 16 processes 2024-03-02 00:34:16,454 Finished 3 from 16 processes 2024-03-02 00:34:21,456 Finished 3 from 16 processes 2024-03-02 00:34:26,460 Finished 3 from 16 processes 2024-03-02 00:34:31,464 Finished 3 from 16 processes 2024-03-02 00:34:36,468 Finished 3 from 16 processes 2024-03-02 00:34:41,472 Finished 3 from 16 processes 2024-03-02 00:34:46,476 Finished 3 from 16 processes 2024-03-02 00:34:51,480 Finished 3 from 16 processes 2024-03-02 00:34:56,484 Finished 3 from 16 processes 2024-03-02 00:35:01,488 Finished 3 from 16 processes 2024-03-02 00:35:06,494 Finished 3 from 16 processes 2024-03-02 00:35:11,498 Finished 3 from 16 processes 2024-03-02 00:35:16,501 Finished 3 from 16 processes 2024-03-02 00:35:21,506 Finished 3 from 16 processes 2024-03-02 00:35:26,511 Finished 3 from 16 processes 2024-03-02 00:35:31,517 Finished 4 from 16 processes 2024-03-02 00:35:36,520 Finished 4 from 16 processes 2024-03-02 00:35:41,524 Finished 4 from 16 processes 2024-03-02 00:35:46,528 Finished 7 from 16 processes 2024-03-02 00:35:51,534 Finished 10 from 16 processes 2024-03-02 00:35:56,539 Finished 10 from 16 processes 2024-03-02 00:36:01,544 Finished 11 from 16 processes 2024-03-02 00:36:06,548 Finished 11 from 16 processes 2024-03-02 00:36:11,552 Finished 11 from 16 processes 2024-03-02 00:36:16,558 Finished 12 from 16 processes 2024-03-02 00:36:21,560 Finished 12 from 16 processes 2024-03-02 00:36:26,564 Finished 13 from 16 processes 2024-03-02 00:36:31,568 Finished 13 from 16 processes 2024-03-02 00:36:36,572 Finished 13 from 16 processes 2024-03-02 00:36:41,578 Finished 13 from 16 processes 2024-03-02 00:36:46,580 Finished 13 from 16 processes 2024-03-02 00:36:51,586 Finished 13 from 16 processes 2024-03-02 00:36:56,591 Finished 13 from 16 processes 2024-03-02 00:37:01,597 Finished 13 from 16 processes 2024-03-02 00:37:06,602 Finished 13 from 16 processes 2024-03-02 00:37:11,607 Finished 13 from 16 processes 2024-03-02 00:37:16,611 Finished 13 from 16 processes 2024-03-02 00:37:21,612 Finished 13 from 16 processes 2024-03-02 00:37:26,613 Finished 13 from 16 processes 2024-03-02 00:37:31,616 Finished 13 from 16 processes 2024-03-02 00:37:36,620 Finished 13 from 16 processes 2024-03-02 00:37:41,624 Finished 13 from 16 processes 2024-03-02 00:37:46,630 Finished 13 from 16 processes 2024-03-02 00:37:51,635 Finished 13 from 16 processes 2024-03-02 00:37:56,640 Finished 13 from 16 processes 2024-03-02 00:38:01,646 Finished 13 from 16 processes 2024-03-02 00:38:06,651 Finished 13 from 16 processes 2024-03-02 00:38:11,656 Finished 13 from 16 processes 2024-03-02 00:38:16,660 Finished 13 from 16 processes 2024-03-02 00:38:21,666 Finished 14 from 16 processes 2024-03-02 00:38:26,668 Finished 14 from 16 processes 2024-03-02 00:38:31,672 Finished 14 from 16 processes 2024-03-02 00:38:36,674 Finished 14 from 16 processes 2024-03-02 00:38:41,676 Finished 14 from 16 processes 2024-03-02 00:38:46,682 Finished 14 from 16 processes 2024-03-02 00:38:51,687 Finished 14 from 16 processes 2024-03-02 00:38:56,692 Finished 14 from 16 processes 2024-03-02 00:39:01,698 Finished 14 from 16 processes 2024-03-02 00:39:06,703 Finished 14 from 16 processes 2024-03-02 00:39:11,708 Finished 14 from 16 processes 2024-03-02 00:39:16,713 Finished 14 from 16 processes 2024-03-02 00:39:21,719 Finished 14 from 16 processes 2024-03-02 00:39:26,724 Finished 14 from 16 processes 2024-03-02 00:39:31,729 Finished 14 from 16 processes 2024-03-02 00:39:36,732 Finished 14 from 16 processes 2024-03-02 00:39:41,738 Finished 14 from 16 processes 2024-03-02 00:39:46,743 Finished 14 from 16 processes 2024-03-02 00:39:51,749 Finished 14 from 16 processes 2024-03-02 00:39:56,754 Finished 14 from 16 processes 2024-03-02 00:40:01,759 Finished 14 from 16 processes 2024-03-02 00:40:06,764 Finished 14 from 16 processes 2024-03-02 00:40:11,767 Finished 14 from 16 processes 2024-03-02 00:40:16,772 Finished 14 from 16 processes 2024-03-02 00:40:21,778 Finished 14 from 16 processes 2024-03-02 00:40:26,783 Finished 14 from 16 processes 2024-03-02 00:40:31,789 Finished 14 from 16 processes 2024-03-02 00:40:36,794 Finished 14 from 16 processes 2024-03-02 00:40:41,799 Finished 14 from 16 processes 2024-03-02 00:40:46,805 Finished 15 from 16 processes 2024-03-02 00:40:51,810 Finished 15 from 16 processes 2024-03-02 00:40:56,816 Finished 15 from 16 processes 2024-03-02 00:41:01,821 Finished 15 from 16 processes 2024-03-02 00:41:06,827 Finished 15 from 16 processes 2024-03-02 00:41:11,828 Finished 15 from 16 processes 2024-03-02 00:41:16,834 Finished 15 from 16 processes 2024-03-02 00:41:21,836 Finished 15 from 16 processes 2024-03-02 00:41:26,840 Finished 15 from 16 processes 2024-03-02 00:41:31,846 Finished 15 from 16 processes 2024-03-02 00:41:36,851 Finished 15 from 16 processes 2024-03-02 00:41:41,856 Finished 15 from 16 processes 2024-03-02 00:41:46,860 Finished 15 from 16 processes 2024-03-02 00:41:51,864 Finished 15 from 16 processes 2024-03-02 00:41:56,870 Finished 15 from 16 processes 2024-03-02 00:42:01,872 Finished 15 from 16 processes 2024-03-02 00:42:06,878 Finished 15 from 16 processes 2024-03-02 00:42:11,883 Finished 15 from 16 processes 2024-03-02 00:42:16,889 Finished 15 from 16 processes 2024-03-02 00:42:21,892 Finished 15 from 16 processes 2024-03-02 00:42:26,896 Finished 15 from 16 processes 2024-03-02 00:42:31,900 Finished 15 from 16 processes 2024-03-02 00:42:36,904 Finished 15 from 16 processes 2024-03-02 00:42:41,910 Finished 15 from 16 processes 2024-03-02 00:42:46,912 Finished 15 from 16 processes 2024-03-02 00:42:51,916 Finished 15 from 16 processes 2024-03-02 00:42:56,921 Finished 15 from 16 processes 2024-03-02 00:43:01,927 Finished 15 from 16 processes 2024-03-02 00:43:06,932 Finished 15 from 16 processes 2024-03-02 00:43:11,938 Finished 15 from 16 processes 2024-03-02 00:43:16,943 Finished 15 from 16 processes 2024-03-02 00:43:21,948 Finished 15 from 16 processes 2024-03-02 00:43:26,954 Finished 15 from 16 processes 2024-03-02 00:43:31,959 Finished 15 from 16 processes 2024-03-02 00:43:36,960 Finished 15 from 16 processes 2024-03-02 00:43:41,964 Finished 15 from 16 processes 2024-03-02 00:43:46,970 Finished 15 from 16 processes 2024-03-02 00:43:51,972 Finished 15 from 16 processes 2024-03-02 00:43:56,978 Finished 15 from 16 processes 2024-03-02 00:44:01,982 Finished 15 from 16 processes 2024-03-02 00:44:06,983 Finished 15 from 16 processes 2024-03-02 00:44:11,988 Finished 15 from 16 processes 2024-03-02 00:44:16,993 Finished 15 from 16 processes 2024-03-02 00:44:21,999 Finished 15 from 16 processes 2024-03-02 00:44:27,000 Finished 15 from 16 processes 2024-03-02 00:44:32,006 Finished 15 from 16 processes 2024-03-02 00:44:37,011 All processes finished 2024-03-02 00:44:37,011 Compressing stress logs 2024-03-02 00:44:37,050 Logs compressed 2024-03-02 00:44:37,050 Will terminate gdb (if any) 2024-03-02 00:49:48,342 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.71 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) 114333 0.072 21.87 MiB 0.099 1 673 ['Test'] 0.031 read() returned {}, sample block {} 91434 0.058 17.19 MiB 0.078 1 673 ['Test'] 0.019 First reader returned: {}, requested columns: {} 73096 0.046 2.15 MiB 0.01 1 649 ['Trace'] 0 Aggregation method: {} 71996 0.046 6.22 MiB 0.028 1 647 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 70289 0.044 5.58 MiB 0.025 1 640 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 68478 0.043 24.32 MiB 0.11 1 854 ['Test'] 0.136 Current count: {}, position: {}, read range: {}, file segment: {} 68446 0.043 7.10 MiB 0.032 1 854 ['Test'] 0.137 Read {} bytes, read type {}, position: {}, offset: {}, remaining read range: {} 68314 0.043 24.37 MiB 0.11 1 854 ['Test'] 0.137 Key: {}. Returning with {} bytes, buffer position: {} (offset: {}, predownloaded: {}), buffer available: {}, current range: {}, current offset: {}, file segment state: {}, current write offset: {}, read_type: {}, reading until position: {}, started with offset: {}, remaining ranges: {} 66748 0.042 717.02 KiB 0.003 1 645 ['Trace'] 0 Aggregating 40573 0.026 3.88 MiB 0.018 2 172 ['Test'] 0.325 Write file: {} 40267 0.025 4.92 MiB 0.022 1 148 ['Trace'] 0.463 Single part upload has completed. Bucket: {}, Key: {}, Object size: {}, WithPool: {} 40267 0.025 4.38 MiB 0.02 1 171 ['Trace'] 0.327 Making single part upload. Bucket: {}, Key: {}, Size: {}, WithPool: {} 40076 0.025 2.94 MiB 0.013 1 163 ['Trace'] 0.329 Checking object {} exists after upload 40075 0.025 2.60 MiB 0.012 1 163 ['Trace'] 0.329 Object {} exists after upload 38557 0.024 3.26 MiB 0.015 1 853 ['Test'] 0.23 Current file segment: {}, read type: {}, current file offset: {} 35561 0.023 2.22 MiB 0.01 1 853 ['Test'] 0.246 Having {} file segments to read: {}, current offset: {} 28364 0.018 1.96 MiB 0.009 1 461 ['Test'] 0 Downloader id: {}, caller id: {} 26099 0.017 8.36 MiB 0.038 1 630 ['Test'] 0.02 Completed file segment: {} 26099 0.017 9.14 MiB 0.041 1 630 ['Test'] 0.02 Complete based on current state (is_last_holder: {}, {}) 25794 0.016 2.69 MiB 0.012 1 748 ['Test'] 0.462 Read S3 object. Bucket: {}, Key: {}, Version: {}, Range: {}-{} 25225 0.016 3.64 MiB 0.016 1 594 ['Test'] 0.07 ReadResult::optimize() before: {} 25225 0.016 3.72 MiB 0.017 1 594 ['Test'] 0.07 ReadResult::optimize() after: {} 25224 0.016 3.55 MiB 0.016 1 594 ['Test'] 0.07 After execute prewhere {} 25224 0.016 1.80 MiB 0.008 1 594 ['Test'] 0.07 Executing prewhere actions on block: {} 21611 0.014 6.00 MiB 0.027 1 170 ['Test'] 0.407 Detached file segment: {} 20351 0.013 1.08 MiB 0.005 1 486 ['Test'] 0.023 Updated state from {} to {} 18812 0.012 836.82 KiB 0.004 1 589 ['Test'] 0.001 ReadResult::applyFilter() num_rows after: {} 18812 0.012 874.71 KiB 0.004 1 589 ['Test'] 0.001 ReadResult::applyFilter() num_rows before: {} 16691 0.011 885.30 KiB 0.004 1 166 ['Trace'] 0.001 Access granted: {}{} 16574 0.01 1.58 MiB 0.007 1 133 ['Test'] 0.503 Bypassing cache because `read_from_filesystem_cache_if_exists_otherwise_bypass_cache` option is used 11661 0.007 579.57 KiB 0.003 1 220 ['Test'] 1 Nothing to clean up from store/ on disk {} 10775 0.007 492.79 KiB 0.002 1 121 ['Debug'] 0.108 Peak memory usage{}: {}. 10206 0.006 415.32 KiB 0.002 1 482 ['Test'] 0.045 Resetting downloader from {} 9660 0.006 1.95 MiB 0.009 1 85 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 9588 0.006 1.44 MiB 0.006 3 85 ['Debug'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 9210 0.006 221.98 KiB 0.001 1 136 ['Trace'] 0.007 {} -> {} 8943 0.006 252.69 KiB 0.001 1 85 ['Debug'] 0 Processed in {} sec. 8213 0.005 2.52 MiB 0.011 1 459 ['Test'] 0 Complete batch. ({}) 7461 0.005 871.59 KiB 0.004 1 33 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 7055 0.004 213.35 KiB 0.001 17 546 ['Trace'] 0 Found (RIGHT) boundary mark: {} 7055 0.004 206.42 KiB 0.001 17 546 ['Trace'] 0 Found (LEFT) boundary mark: {} 7055 0.004 197.82 KiB 0.001 17 546 ['Trace'] 0 Found {} range in {} steps 7055 0.004 475.59 KiB 0.002 17 546 ['Trace'] 0 Running binary search on index range for part {} ({} marks) 6088 0.004 315.10 KiB 0.001 1 340 ['Test'] 0.289 ReadResult::optimize() combined filter is const False 5806 0.004 471.73 KiB 0.002 1 78 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 5529 0.003 525.96 KiB 0.002 1 40 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 5286 0.003 366.70 KiB 0.002 90 395 ['Trace'] 0.899 Trying to reserve {} using storage policy from min volume index {} 5103 0.003 830.68 KiB 0.004 1 58 ['Test'] 0.1 Trying to lock removal_tid by {}, table: {}, part: {} 5045 0.003 245.13 KiB 0.001 1 164 ['Trace'] 0.698 filled checksums {} 5029 0.003 437.17 KiB 0.002 92 172 ['Test'] 0.706 preparePartForCommit: inserting {} into data_parts_indexes 5026 0.003 606.32 KiB 0.003 92 172 ['Trace'] 0.706 Renaming temporary part {} to {} with tid {}. 4611 0.003 204.81 KiB 0.001 1 3 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 4362 0.003 536.52 KiB 0.002 1 3 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 4042 0.003 336.28 KiB 0.001 26 46 ['Test'] 0.999 removePartsFinally: removing {} from data_parts_indexes 3825 0.002 287.95 KiB 0.001 1 407 ['Test'] 0 Added entry into LRU queue, key: {}, offset: {} 3247 0.002 229.78 KiB 0.001 1 289 ['Trace'] 0.933 Reserved {} on local disk {}, having unreserved {}. 3199 0.002 212.53 KiB 0.001 1 66 ['Debug'] 0.143 Remove from cache. Key: {}, offset: {} 3115 0.002 240.13 KiB 0.001 1 66 ['Test'] 0.147 Removed entry from LRU queue, key: {}, offset: {} 3042 0.002 107.77 KiB 0 11 26 ['Trace'] 1 Flushed system log up to offset {} 3035 0.002 173.53 KiB 0.001 11 26 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 2987 0.002 67.09 KiB 0 1 595 ['Trace'] 0.005 Merging aggregated data 2935 0.002 435.66 KiB 0.002 1 37 ['Test'] 0.056 Caching file `{}` to `{}` with key {} 2910 0.002 348.24 KiB 0.002 1 58 ['Trace'] 0.06 PREWHERE condition was split into {} steps: {} 2909 0.002 2.84 MiB 0.013 1 58 ['Test'] 0.061 Original PREWHERE DAG:\n{}\nPREWHERE actions:\n{} 2435 0.002 110.39 KiB 0 1 26 ['Test'] 0.001 Resize cell {} to downloaded: {} 2401 0.002 158.08 KiB 0.001 2 243 ['Trace'] 0.776 Reserved {} on remote disk {}, having unreserved {}. 2306 0.001 189.16 KiB 0.001 4 102 ['Debug'] 0.993 {} Authenticating user \'{}\' from {} 2304 0.001 258.75 KiB 0.001 4 102 ['Debug'] 0.993 {} Authenticated with global context as user {} 2287 0.001 250.14 KiB 0.001 3 85 ['Debug'] 1 {} Creating session context with user_id: {} 2077 0.001 64.97 KiB 0 1 409 ['Test'] 0 Successfully written {} bytes 1925 0.001 163.37 KiB 0.001 1 52 ['Trace'] 0.001 Reading {} ranges in order from part {}, approx. {} rows starting from {} 1841 0.001 51.84 KiB 0 1 350 ['Test'] 0.059 New segment: {} 1837 0.001 127.36 KiB 0.001 1 350 ['Test'] 0.059 Removing file segment: {}, downloader: {}, state: {} 1837 0.001 60.99 KiB 0 1 350 ['Test'] 0.059 Completed segment: {} 1762 0.001 70.55 KiB 0 1 576 ['Trace'] 0 Converting aggregation data to two-level. 1699 0.001 251.97 KiB 0.001 1 195 ['Debug'] 0 Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.) 1699 0.001 83.82 KiB 0 1 195 ['Trace'] 0 Merging partially aggregated blocks (bucket = {}). 1647 0.001 55.32 KiB 0 1 85 ['Trace'] 1 TCP Request. Address: {} 1646 0.001 150.19 KiB 0.001 1 85 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 1627 0.001 1.20 MiB 0.005 1 94 ['Trace'] 0.961 Objects with paths [{}] were removed from S3 1623 0.001 42.79 KiB 0 1 82 ['Debug'] 1 Done processing connection. 1573 0.001 92.17 KiB 0 1 82 ['Test'] 1 Closing connection (open: {}, cancelled: {}, eof: {}) 1566 0.001 59.00 KiB 0 66 84 ['Debug'] 0.01 Key condition: {} 1560 0.001 182.56 KiB 0.001 65 84 ['Debug'] 0.01 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 1514 0.001 57.82 KiB 0 1 1 ['Debug'] 0 Will kill query {} (synchronously) 1446 0.001 74.84 KiB 0 60 82 ['Trace'] 0.01 Spreading mark ranges among streams (default reading) 1422 0.001 45.05 KiB 0 26 77 ['Debug'] 0.008 MinMax index condition: {} 1402 0.001 251.96 KiB 0.001 1 456 ['Test'] 0.009 ReadResult::optimize() after colapseZeroTails {} 1153 0.001 224.47 KiB 0.001 1 128 ['Information'] 1 Removing metadata {} of dropped table {} 1153 0.001 144.31 KiB 0.001 1 128 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {} 1152 0.001 130.22 KiB 0.001 86 76 ['Debug'] 0.994 Removing {} parts from filesystem (serially): Parts: [{}] 1152 0.001 85.50 KiB 0 1 54 ['Debug'] 0 Waiting for table {} to be finally dropped 1119 0.001 38.19 KiB 0 1 40 ['Debug'] 0 Selected MergeAlgorithm: {} 1118 0.001 94.27 KiB 0 1 40 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {} 1112 0.001 61.32 KiB 0 27 256 ['Debug'] 0.992 Selected {} parts from {} to {} 1090 0.001 106.32 KiB 0 26 47 ['Trace'] 0.995 Found {} old parts to remove. Parts: [{}] 1088 0.001 107.19 KiB 0 26 46 ['Debug'] 0.995 Removing {} parts from memory: Parts: [{}] 1035 0.001 84.85 KiB 0 1 57 ['Debug'] 0.024 MergeTreeWhereOptimizer: condition "{}" moved to PREWHERE 1014 0.001 40.09 KiB 0 1 4 ['Test'] 1 {} for session {} took {} ms 987 0.001 129.46 KiB 0.001 1 40 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec. Top messages without format string (fmt::runtime): count pattern runtime_message line UInt64 String String Tuple(String, UInt64) 34 CodeDBErrnoExceptionCannotopenfi Code: 107. DB::ErrnoException: Cannot open file /var/lib/clickhouse/disks/s3/store/34f/34fdff39-90e5-4265-beb2-f077af463d6e/tmp_merge_202403_43_79_3/transaction_id%2E3.cmrk2, errno: 2, strerror: No such file or directory. (FILE_DOESNT_EXIST), Stack trace ( ('/Exception.cpp',193) 15 virtualboolDBReplicatedMergeMuta virtual bool DB::ReplicatedMergeMutateTaskBase::executeStep(): Poco::Exception. Code: 1000, e.code() = 104, Connection reset by peer, Stack trace (when copying this message, always include the lines below):\n\n0. ./build_docker/./contrib/llvm-project/libcxx/ ('/Exception.cpp',193) 12 voidDBStorageReplicatedMergeTree void DB::StorageReplicatedMergeTree::queueUpdatingTask(): Code: 999. Coordination::Exception: Connection loss. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below):\n\n0. ./build_docker/./contrib/llvm-project/libcxx/inc ('/Exception.cpp',193) 10 CodeDBExceptionReceivedfromDBExc Code: 241. DB::Exception: Received from 127.0.0.1:9000. DB::Exception: Memory tracker (for query): fault injected. Would use 27.35 MiB (attempt to allocate chunk of 1938986 bytes), maximum: 9.31 GiB: (while reading column FUniqID): (while reading from part ('/executeQuery.cpp',205) 9 voidDBReplicatedMergeTreeCleanup void DB::ReplicatedMergeTreeCleanupThread::run(): Code: 999. Coordination::Exception: Session expired, path: Session expired (fault injected on recv). (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below):\n\n0. ./build_ ('/Exception.cpp',193) 7 Cannotremoveclickhousetablespara Cannot remove /clickhouse/tables/01079_parallel_alter_detach_table_zookeeper_test_o6k8dnrp/concurrent_alter_detach/replicas/2/is_active: Code: 999. Coordination::Exception: Session expired, path: Session expired. (KEEPER_EXCEPTION), Stack trace (when copyi ('/Exception.cpp',193) 5 autoDBStorageReplicatedMergeTree auto DB::StorageReplicatedMergeTree::processQueueEntry(ReplicatedMergeTreeQueue::SelectedEntryPtr)::(anonymous class)::operator()(DB::StorageReplicatedMergeTree::LogEntryPtr &) const: Poco::Exception. Code: 1000, e.code() = 104, Connection reset by peer, S ('/Exception.cpp',193) 4 CodeDBErrnoExceptionCannotrmdirv Code: 566. DB::ErrnoException: Cannot rmdir /var/lib/clickhouse/disks/s3/store/34f/34fdff39-90e5-4265-beb2-f077af463d6e/tmp_merge_202403_43_86_3/, errno: 39, strerror: Directory not empty. (CANNOT_RMDIR), Stack trace (when copying this message, always incl ('/Exception.cpp',193) 3 Cannotremovetestdbtestreplicassr Cannot remove /test/db/test_8/replicas/s1|r1/active: Code: 999. Coordination::Exception: Session expired, path: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below):\n\n0. ./build_docker/./contrib/llvm- ('/Exception.cpp',193) 3 PocoExceptionCodeecodeExceptionC Poco::Exception. Code: 1000, e.code() = 0, Exception: Cannot load time zone qqq (version 23.3.19.33.altinitystable (altinity build)) (from [::1]:42836) (comment: 00921_datetime64_basic.sql) (in query: SELECT CAST(1 as DateTime64(3, \'qqq\'));), Stack trace ( ('/executeQuery.cpp',205) 3 CodeDBExceptionExceptionCannotlo Code: 1000. DB::Exception: Exception: Cannot load time zone qqq. (POCO_EXCEPTION), Stack trace (when copying this message, always include the lines below):\n\n0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:0: Poco::Exception::Exception(Str ('/TCPHandler.cpp',606) 2 CodeDBErrnoExceptionCannotunlink Code: 458. DB::ErrnoException: Cannot unlink file /var/lib/clickhouse/disks/s3/store/aee/aeed9498-d2b2-47e8-93c8-397e2051c5e1/tmp_mut_all_1_1_0_9/e.bin, errno: 2, strerror: No such file or directory: While rolling back operation #0. (CANNOT_UNLINK) (versio ('/MutatePlainMergeTreeTask.cpp',111) 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.3.19.33.altinitystabl ('/executeQuery.cpp',205) 2 Cannotremovetesttestreplicasisac Cannot remove /test/02432/test_9/replicas/1/is_active: Code: 999. Coordination::Exception: Session expired, path: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this message, always include the lines below):\n\n0. ./build_docker/./contrib/llv ('/Exception.cpp',193) 2 CodeDBExceptionParameterscalefor Code: 43. DB::Exception: Parameter #0 \'scale\' for DateTime64 has wrong type: Int64, expected UInt64 literal: While processing CAST(1, \'DateTime64(-1)\'). (ILLEGAL_TYPE_OF_ARGUMENT) (version 23.3.19.33.altinitystable (altinity build)) (from [::1]:42836) (com ('/executeQuery.cpp',205) 1 PocoExceptionCodeecodeIOerrorBro Poco::Exception. Code: 1000, e.code() = 32, I/O error: Broken pipe, Stack trace (when copying this message, always include the lines below):\n\n0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:0: Poco::Exception::Exception(String const&, int ('/Exception.cpp',193) 1 PocoExceptionCodeecodeNotfoundbo Poco::Exception. Code: 1000, e.code() = 0, Not found: boundary, Stack trace (when copying this message, always include the lines below):\n\n0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:0: Poco::Exception::Exception(String const&, int) @ ('/Exception.cpp',193) 1 CodeDBExceptionstdruntimeerrorra Code: 1001. DB::Exception: std::runtime_error: ran out of bytes. (STD_EXCEPTION), Stack trace (when copying this message, always include the lines below):\n\n0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:134: std::runtime_error::runtime_e ('/TCPHandler.cpp',606) 1 stdexceptionCodetypestdruntimeer std::exception. Code: 1001, type: std::runtime_error, e.what() = ran out of bytes (version 23.3.19.33.altinitystable (altinity build)) (from [::1]:39406) (comment: 02688_aggregate_states.sql) (in query: SELECT \'\\x01\\x01\\x01\'::AggregateFunction(groupBitmap, ('/executeQuery.cpp',205) 1 Anerroroccurredwhileexecutingtra An error occurred while executing transaction\'s operation #0 (RemoveRecursiveObjectStorageOperation (path: store/34f/34fdff39-90e5-4265-beb2-f077af463d6e/tmp_merge_202403_43_79_3/)): Code: 107. DB::ErrnoException: Cannot open file /var/lib/clickhouse/disks ('/Exception.cpp',193) 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:0: Poco::Exception::Exception(S ('/Exception.cpp',193) 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) 206 /var/lib/clickhouse/disks/s3/store/c9e/c9e470ee-f233-49d4-8539-b37ea3c7f311/tmp_insert_17_18_18_0/ is in use (by merge/m 8 std::exception. Code: 1001, type: std::runtime_error, e.what() = ran out of bytes (version 23.3.19.33.altinitystable (al Not executing log entry {} for part {} because it is not disjoint with part {} that is currently executing. 3 Not executing log entry queue-0000000016 for part all_0_13_2_2 because it is not disjoint with part all_11_11_0 that is Failed communicating with {} with error \'{}\' will try to reconnect session 1 Failed communicating with e7bf215513c3 with error \'Received error from remote server /?endpoint=DataPartsExchange%3A%2Fc Top short messages: c message_format_string substring(any(message), 1, 120) UInt64 LowCardinality(String) String 40728 Write file: {} Write file: store/edf/edfa6191-a01d-4f00-ad43-f9a05597e21a/tmp_insert_202403_33_33_0/primary.cidx 19 Table {} doesn\'t exist Code: 60. DB::Exception: Table test_1.concurrent_mutate_mt_3 doesn\'t exist. (UNKNOWN_TABLE) (version 23.3.19.33.altinity 10 File {} doesn\'t exist Code: 107. DB::Exception: File /var/lib/clickhouse/user_files/nonexist.txt doesn\'t exist. (FILE_DOESNT_EXIST) (version 2 10 Terminating Terminating 4 Database {} doesn\'t exist Could not update cache dictionary \'one_cell_cache_ints\', next update is scheduled at 2024-03-02 00:26:15: Code: 81. DB:: 4 Scale {} is out of bounds Code: 69. DB::Exception: Scale 100 is out of bounds: While processing CAST(1, \'DateTime64(100)\'). (ARGUMENT_OUT_OF_BOUND 3 Unknown parent id {} Could not update external dictionary \'5c50a9ad-a131-4e1d-b81d-ba215e00c1bb\', leaving the previous version: Code: 489. DB 3 There are duplicate id {} Could not update external dictionary \'5c50a9ad-a131-4e1d-b81d-ba215e00c1bb\', leaving the previous version: Code: 489. DB 2 Cannot ALTER column Code: 524. DB::Exception: Cannot ALTER column: Cannot apply mutation because it breaks projection p1. (ALTER_OF_COLUMN_I 2 Unknown format {} Code: 73. DB::Exception: Unknown format aaa: While processing formatRow(\'aaa\', number). (UNKNOWN_FORMAT) (version 23.3.1 2 Unexpected packet from client Code: 101. DB::NetException: Unexpected packet from client. (UNEXPECTED_PACKET_FROM_CLIENT), Stack trace (when copying t 2 INTO OUTFILE is not allowed Code: 358. DB::Exception: INTO OUTFILE is not allowed. (INTO_OUTFILE_NOT_ALLOWED) (version 23.3.19.33.altinitystable (al 2 Point is not valid Code: 36. DB::Exception: Point is not valid: While processing s2ToGeo(toUInt64(-1)). (BAD_ARGUMENTS) (version 23.3.19.33 2 Shutdown is called for table Code: 236. DB::Exception: Shutdown is called for table. (ABORTED) (version 23.3.19.33.altinitystable (altinity build)) ( 2 Arguments must not be NaN Code: 43. DB::Exception: Arguments must not be NaN: While processing geoToS2(nan, nan). (ILLEGAL_TYPE_OF_ARGUMENT) (vers 1 Chunk size exceeded the limit Cannot send exception to client: Code: 69. DB::Exception: Chunk size exceeded the limit. (ARGUMENT_OUT_OF_BOUND), Stack 1 Invalid credentials from: ::1, user: default: Authentication failed: Code: 193. DB::Exception: Invalid credentials. (WRONG_PASSWORD), Stack Top messages by level: (0.000608935546659765,'Memory limit{}{} exceeded: would use {} (attempt to allocate chunk of {} bytes), maximum: {}.{}{}') Error (0.000030226376669771168,'Client has gone away.') Warning (0.0007260627562551283,'Removing metadata {} of dropped table {}') Information (0.00679337815653107,'Peak memory usage{}: {}.') Debug (0.04604799570785451,'Aggregation method: {}') Trace (0.07295828697047954,'read() returned {}, sample block {}') Test 2024-03-02 00:50:15,366 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=1983 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1983. The process with pid = 1983 is running. Sent terminate signal to process with pid 1983. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1983. The process with pid = 1983 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1983. The process with pid = 1983 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1983. The process with pid = 1983 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1983. The process with pid = 1983 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1983. The process with pid = 1983 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1983. The process with pid = 1983 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1983. The process with pid = 1983 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1983. The process with pid = 1983 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1983. The process with pid = 1983 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 127.0.0.1 - - [01/Mar/2024:21:50:43 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - + sleep 0.5 + counter=18 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) 127.0.0.1 - - [01/Mar/2024:21:50:44 +0000] "PUT /devstoreaccount1/cont/gomqeganunxprlcgfobigxzyenmdcbly?blockid=nqpcyainapdhgesiicqipzppihgszbovgugcfzhbgtrhnwydewasxblzooicdnse&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:21:50:44 +0000] "PUT /devstoreaccount1/cont/gomqeganunxprlcgfobigxzyenmdcbly?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:21:50:44 +0000] "GET /devstoreaccount1/cont/gomqeganunxprlcgfobigxzyenmdcbly HTTP/1.1" 206 4 + '[' 18 -gt 120 ']' + clickhouse start --user root 127.0.0.1 - - [01/Mar/2024:21:50:44 +0000] "GET /devstoreaccount1/cont/gomqeganunxprlcgfobigxzyenmdcbly HTTP/1.1" 206 2 127.0.0.1 - - [01/Mar/2024:21:50:44 +0000] "DELETE /devstoreaccount1/cont/gomqeganunxprlcgfobigxzyenmdcbly HTTP/1.1" 202 - + 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' 1 ++ 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 12808 + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb real 0m1.306s user 0m0.436s sys 0m0.091s + 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=12808 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12808. The process with pid = 12808 is running. Sent terminate signal to process with pid 12808. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12808. The process with pid = 12808 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12808. The process with pid = 12808 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12808. The process with pid = 12808 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12808. The process with pid = 12808 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12808. The process with pid = 12808 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12808. The process with pid = 12808 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12808. The process with pid = 12808 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12808. The process with pid = 12808 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12808. The process with pid = 12808 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12808. The process with pid = 12808 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 12808. The process with pid = 12808 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 script.gdb:13: Error in sourced command file: No stack. + 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 -Fa '########################################' /test_output/gdb.log /test_output/stress_run_logs.tar.zst /test_output/test_results.tsv + rg -Fa ' received signal ' /test_output/gdb.log + dmesg -T + grep -q -F -e 'Out of memory: Killed process' -e 'oom_reaper: reaped process' -e oom-kill:constraint=CONSTRAINT_NONE /test_output/dmesg.log + echo -e 'No OOM in dmesg\tOK\t\N\t' + tar -chf /test_output/coordination.tar /var/lib/clickhouse/coordination tar: Removing leading `/' from member names tar: Removing leading `/' from hard link targets + collect_query_and_trace_logs + for table in query_log trace_log + zstd --threads=0 + clickhouse-local --path /var/lib/clickhouse/ --only-system-tables -q 'select * from system.query_log format TSVWithNamesAndTypes' + for table in query_log trace_log + zstd --threads=0 + clickhouse-local --path /var/lib/clickhouse/ --only-system-tables -q 'select * from system.trace_log format TSVWithNamesAndTypes' + 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' + collect_core_dumps + find . -type f -maxdepth 1 -name 'core.*' + read core