+ 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+tsan_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+tsan_amd64.deb ... Unpacking clickhouse-common-static (23.3.19.33.altinitystable+tsan) ... Setting up clickhouse-common-static (23.3.19.33.altinitystable+tsan) ... + dpkg -i package_folder/clickhouse-common-static-dbg_23.3.19.33.altinitystable+tsan_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+tsan_amd64.deb ... Unpacking clickhouse-common-static-dbg (23.3.19.33.altinitystable+tsan) ... Setting up clickhouse-common-static-dbg (23.3.19.33.altinitystable+tsan) ... + dpkg -i package_folder/clickhouse-server_23.3.19.33.altinitystable+tsan_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+tsan_amd64.deb ... Unpacking clickhouse-server (23.3.19.33.altinitystable+tsan) ... Setting up clickhouse-server (23.3.19.33.altinitystable+tsan) ... ClickHouse binary is already located at /usr/bin/clickhouse Symlink /usr/bin/clickhouse-server already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-server to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-client to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-local to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-benchmark to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-copier already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-copier to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-obfuscator to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-git-import to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-compressor to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-format to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-extract-from-config already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-extract-from-config to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-keeper already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper to /usr/bin/clickhouse. 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+tsan_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+tsan_amd64.deb ... Unpacking clickhouse-client (23.3.19.33.altinitystable+tsan) ... Setting up clickhouse-client (23.3.19.33.altinitystable+tsan) ... ++ clickhouse local -q 'select value like '\''% -fsanitize=thread %'\'' from system.build_options where name='\''CXX_FLAGS'\''' + is_tsan_build=1 + '[' 1 -eq 0 ']' + 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 + [[ -n 1 ]] + echo x86_64 + [[ '' -eq 1 ]] + [[ x86_64 == \a\a\r\c\h\6\4 ]] x86_64 Adding azure configuration + echo 'Adding azure configuration' + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml + sudo cat /etc/clickhouse-server/config.d/keeper_port.xml + sed 's|100000|10000|' + sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml + sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml + echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\''' + export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000' + sudo chown root: /var/lib/clickhouse + echo '1' + local total_mem ++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo + total_mem=32098980 + total_mem=32869355520 + max_server_memory_usage_to_ram_ratio=0.5 Setting max_server_memory_usage_to_ram_ratio to 0.5 + echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5' + cat + 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) + local params + ./minio server --address :11111 ./minio_data + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 0 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=1 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 1 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=2 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 2 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=3 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 3 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=4 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 4 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=5 + 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 trying to connect to minio + [[ 6 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=7 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 7 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=8 + curl --silent --verbose http://localhost:11111 + grep AccessDenied trying to connect to minio + [[ 8 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 + counter=9 + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 9 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio + counter=10 + curl --silent --verbose http://localhost:11111 + grep AccessDenied 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:45725 http://127.0.0.1:45725 Documentation: https://docs.min.io WARNING: Console endpoint is listening on a dynamic port (45725), please use --console-address ":PORT" to choose a static port. + counter=11 + curl --silent --verbose http://localhost:11111 + grep AccessDenied AccessDeniedAccess Denied./17B8BDD5A660782526a28d1f-730c-42a2-a53d-3fca556d4c9a + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 255 root 10u IPv6 54416 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 a.tsv + for file in $(ls "${data_path}") + echo a.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv clickminio/test/a.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv` -> `clickminio/test/a.tsv` Total: 0 B, Transferred: 24 B, Speed: 4.36 KiB/s b.tsv + for file in $(ls "${data_path}") + echo b.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv clickminio/test/b.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv` -> `clickminio/test/b.tsv` Total: 0 B, Transferred: 33 B, Speed: 5.55 KiB/s + for file in $(ls "${data_path}") + echo c.tsv + ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv clickminio/test/c.tsv c.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv` -> `clickminio/test/c.tsv` Total: 0 B, Transferred: 33 B, Speed: 5.94 KiB/s + 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 tsv_with_header.tsv `/usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv` -> `clickminio/test/tsv_with_header.tsv` Total: 0 B, Transferred: 44 B, Speed: 7.45 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 127.0.0.1 - - [01/Mar/2024:20:26:33 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:20:26:33 +0000] "PUT /devstoreaccount1/cont/dezdswwtltwkwnikfnzlqyglabdxtsdh?blockid=ovxhpbqswsxmghaiiqzwiikfwbllncsudonratmrsmcluwgpxmzuxwgeuplunvgc&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:20:26:33 +0000] "PUT /devstoreaccount1/cont/dezdswwtltwkwnikfnzlqyglabdxtsdh?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:20:26:33 +0000] "GET /devstoreaccount1/cont/dezdswwtltwkwnikfnzlqyglabdxtsdh HTTP/1.1" 206 4 127.0.0.1 - - [01/Mar/2024:20:26:33 +0000] "GET /devstoreaccount1/cont/dezdswwtltwkwnikfnzlqyglabdxtsdh HTTP/1.1" 206 2 127.0.0.1 - - [01/Mar/2024:20:26:33 +0000] "DELETE /devstoreaccount1/cont/dezdswwtltwkwnikfnzlqyglabdxtsdh HTTP/1.1" 202 - + counter=4 + 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 512 + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb real 0m0.199s user 0m0.123s sys 0m0.074s + 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/l7jed2c0 INFO:root:Content length is 1271623680 bytes INFO:root:Downloading finished INFO:root:Will unpack data from temp path /tmp/l7jed2c0 to clickhouse db /var/lib/clickhouse/ INFO:root:Unpack finished INFO:root:Will remove downloaded file /tmp/l7jed2c0 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/sg01b7gl INFO:root:Content length is 563968000 bytes INFO:root:Downloading finished INFO:root:Will unpack data from temp path /tmp/sg01b7gl to clickhouse db /var/lib/clickhouse/ INFO:root:Unpack finished INFO:root:Will remove downloaded file /tmp/sg01b7gl 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=512 + 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 = 512. The process with pid = 512 is running. Sent terminate signal to process with pid 512. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 512. The process with pid = 512 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 512. The process with pid = 512 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 512. The process with pid = 512 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 512. The process with pid = 512 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.initial.log + start + counter=0 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' 127.0.0.1 - - [01/Mar/2024:20:27:23 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + clickhouse start --user root + sleep 0.5 127.0.0.1 - - [01/Mar/2024:20:27:23 +0000] "PUT /devstoreaccount1/cont/wxonsjgydyqcqpdqedgojirvtogpzgsp?blockid=cbjpcdlwicagcpffehyqxlosmjvcinqepqkjrzoblbfvbsoagqyectxndupqpuzg&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:20:27:23 +0000] "PUT /devstoreaccount1/cont/wxonsjgydyqcqpdqedgojirvtogpzgsp?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:20:27:23 +0000] "GET /devstoreaccount1/cont/wxonsjgydyqcqpdqedgojirvtogpzgsp HTTP/1.1" 206 4 127.0.0.1 - - [01/Mar/2024:20:27:23 +0000] "GET /devstoreaccount1/cont/wxonsjgydyqcqpdqedgojirvtogpzgsp HTTP/1.1" 206 2 127.0.0.1 - - [01/Mar/2024:20:27:23 +0000] "DELETE /devstoreaccount1/cont/wxonsjgydyqcqpdqedgojirvtogpzgsp HTTP/1.1" 202 - + counter=4 + 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 899 + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb real 0m0.204s user 0m0.145s sys 0m0.057s + 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=899 + 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 = 899. The process with pid = 899 is running. Sent terminate signal to process with pid 899. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 899. The process with pid = 899 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 899. The process with pid = 899 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 899. The process with pid = 899 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 899. The process with pid = 899 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 899. The process with pid = 899 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + export USE_S3_STORAGE_FOR_MERGE_TREE=1 + USE_S3_STORAGE_FOR_MERGE_TREE=1 + export ZOOKEEPER_FAULT_INJECTION=1 + ZOOKEEPER_FAULT_INJECTION=1 + configure + export USE_DATABASE_ORDINARY=1 + USE_DATABASE_ORDINARY=1 + export EXPORT_S3_STORAGE_POLICIES=1 + EXPORT_S3_STORAGE_POLICIES=1 + /usr/share/clickhouse-test/config/install.sh + DEST_SERVER_PATH=/etc/clickhouse-server + DEST_CLIENT_PATH=/etc/clickhouse-client +++ dirname /usr/share/clickhouse-test/config/install.sh ++ cd /usr/share/clickhouse-test/config ++ pwd -P + SRC_PATH=/usr/share/clickhouse-test/config + echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server' + mkdir -p /etc/clickhouse-server/config.d/ Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + mkdir -p /etc/clickhouse-server/users.d/ + mkdir -p /etc/clickhouse-client + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disks.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/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 + 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 + 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 127.0.0.1 - - [01/Mar/2024:20:40:50 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [01/Mar/2024:20:40:50 +0000] "PUT /devstoreaccount1/cont/lwxfvxdtfgbjfryazcibmgkhskggovgo?blockid=ujhxqaljcgloeyljpxblthjbzipxkiwwloixzyhormntarfuvysgnrvcotclmips&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:20:40:50 +0000] "PUT /devstoreaccount1/cont/lwxfvxdtfgbjfryazcibmgkhskggovgo?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:20:40:50 +0000] "GET /devstoreaccount1/cont/lwxfvxdtfgbjfryazcibmgkhskggovgo HTTP/1.1" 206 4 127.0.0.1 - - [01/Mar/2024:20:40:50 +0000] "GET /devstoreaccount1/cont/lwxfvxdtfgbjfryazcibmgkhskggovgo HTTP/1.1" 206 2 127.0.0.1 - - [01/Mar/2024:20:40:50 +0000] "DELETE /devstoreaccount1/cont/lwxfvxdtfgbjfryazcibmgkhskggovgo HTTP/1.1" 202 - + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' 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 1547 + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb real 0m0.201s user 0m0.121s sys 0m0.077s + stress --hung-check --drop-databases --output-folder test_output --skip-func-tests '' --global-time-limit 1200 2024-03-01 23:40:57,301 Run func tests '/usr/bin/clickhouse-test --global_time_limit=1200 ' 2024-03-01 23:40:57,803 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-01 23:40:58,305 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 --global_time_limit=1200 ' 2024-03-01 23:40:58,818 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-01 23:40:59,321 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 ' 2024-03-01 23:40:59,823 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-01 23:41:00,325 Run func tests '/usr/bin/clickhouse-test --order=random --client-option memory_tracker_fault_probability=0.001 --global_time_limit=1200 ' 2024-03-01 23:41:00,827 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_7 --client-option join_use_nulls=1 join_algorithm='grace_hash' group_by_use_nulls=1 --global_time_limit=1200 ' 2024-03-01 23:41:01,329 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 allow_experimental_query_cache=1 use_query_cache=1 --global_time_limit=1200 ' 2024-03-01 23:41:01,831 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_9 --client-option join_algorithm='auto' max_rows_in_join=1000 allow_experimental_query_cache=1 use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-03-01 23:41:02,333 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 ' 2024-03-01 23:41:02,834 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-01 23:41:03,336 Run func tests '/usr/bin/clickhouse-test --order=random --client-option implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 --global_time_limit=1200 ' 2024-03-01 23:41:03,838 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_13 --client-option join_use_nulls=1 join_algorithm='partial_merge' allow_experimental_query_cache=1 use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 ' 2024-03-01 23:41:04,340 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-01 23:41:04,842 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-01 23:41:05,344 Will wait functests to finish 2024-03-01 23:41:05,344 Finished 0 from 16 processes 2024-03-01 23:41:10,348 Finished 0 from 16 processes 2024-03-01 23:41:15,352 Finished 0 from 16 processes 2024-03-01 23:41:20,356 Finished 0 from 16 processes 2024-03-01 23:41:25,356 Finished 0 from 16 processes 2024-03-01 23:41:30,360 Finished 0 from 16 processes 2024-03-01 23:41:35,364 Finished 0 from 16 processes 2024-03-01 23:41:40,368 Finished 0 from 16 processes 2024-03-01 23:41:45,372 Finished 0 from 16 processes 2024-03-01 23:41:50,376 Finished 0 from 16 processes 2024-03-01 23:41:55,381 Finished 0 from 16 processes 2024-03-01 23:42:00,384 Finished 0 from 16 processes 2024-03-01 23:42:05,388 Finished 0 from 16 processes 2024-03-01 23:42:10,393 Finished 0 from 16 processes 2024-03-01 23:42:15,397 Finished 0 from 16 processes 2024-03-01 23:42:20,400 Finished 0 from 16 processes [Detaching after fork from child process 4814] 2024-03-01 23:42:25,404 Finished 0 from 16 processes 2024-03-01 23:42:30,408 Finished 0 from 16 processes 2024-03-01 23:42:35,412 Finished 0 from 16 processes 2024-03-01 23:42:40,417 Finished 0 from 16 processes 2024-03-01 23:42:45,422 Finished 0 from 16 processes 2024-03-01 23:42:50,424 Finished 0 from 16 processes 2024-03-01 23:42:55,428 Finished 0 from 16 processes 2024-03-01 23:43:00,433 Finished 0 from 16 processes 2024-03-01 23:43:05,436 Finished 0 from 16 processes 2024-03-01 23:43:10,442 Finished 0 from 16 processes 2024-03-01 23:43:15,444 Finished 0 from 16 processes 2024-03-01 23:43:20,448 Finished 0 from 16 processes 2024-03-01 23:43:25,451 Finished 0 from 16 processes 2024-03-01 23:43:30,456 Finished 0 from 16 processes 2024-03-01 23:43:35,460 Finished 0 from 16 processes 2024-03-01 23:43:40,464 Finished 0 from 16 processes 2024-03-01 23:43:45,468 Finished 0 from 16 processes 2024-03-01 23:43:50,473 Finished 0 from 16 processes 2024-03-01 23:43:55,478 Finished 0 from 16 processes 2024-03-01 23:44:00,483 Finished 0 from 16 processes 2024-03-01 23:44:05,488 Finished 0 from 16 processes 2024-03-01 23:44:10,493 Finished 0 from 16 processes 2024-03-01 23:44:15,496 Finished 0 from 16 processes 2024-03-01 23:44:20,500 Finished 0 from 16 processes 2024-03-01 23:44:25,504 Finished 0 from 16 processes 2024-03-01 23:44:30,508 Finished 0 from 16 processes 2024-03-01 23:44:35,512 Finished 0 from 16 processes 2024-03-01 23:44:40,516 Finished 0 from 16 processes 2024-03-01 23:44:45,520 Finished 0 from 16 processes 2024-03-01 23:44:50,525 Finished 0 from 16 processes 2024-03-01 23:44:55,528 Finished 0 from 16 processes 2024-03-01 23:45:00,532 Finished 0 from 16 processes 2024-03-01 23:45:05,536 Finished 0 from 16 processes 2024-03-01 23:45:10,540 Finished 0 from 16 processes 2024-03-01 23:45:15,544 Finished 0 from 16 processes 2024-03-01 23:45:20,552 Finished 0 from 16 processes 2024-03-01 23:45:25,556 Finished 0 from 16 processes 2024-03-01 23:45:30,560 Finished 0 from 16 processes 2024-03-01 23:45:35,564 Finished 0 from 16 processes 2024-03-01 23:45:40,568 Finished 0 from 16 processes 2024-03-01 23:45:45,573 Finished 0 from 16 processes 2024-03-01 23:45:50,576 Finished 0 from 16 processes 2024-03-01 23:45:55,580 Finished 0 from 16 processes 2024-03-01 23:46:00,585 Finished 0 from 16 processes 2024-03-01 23:46:05,588 Finished 0 from 16 processes 2024-03-01 23:46:10,592 Finished 0 from 16 processes 2024-03-01 23:46:15,596 Finished 0 from 16 processes 2024-03-01 23:46:20,600 Finished 0 from 16 processes 2024-03-01 23:46:25,604 Finished 0 from 16 processes 2024-03-01 23:46:30,605 Finished 0 from 16 processes 2024-03-01 23:46:35,608 Finished 0 from 16 processes 2024-03-01 23:46:40,612 Finished 0 from 16 processes 2024-03-01 23:46:45,616 Finished 0 from 16 processes 2024-03-01 23:46:50,621 Finished 0 from 16 processes 2024-03-01 23:46:55,622 Finished 0 from 16 processes 2024-03-01 23:47:00,625 Finished 0 from 16 processes 2024-03-01 23:47:05,629 Finished 0 from 16 processes 2024-03-01 23:47:10,632 Finished 0 from 16 processes 2024-03-01 23:47:15,636 Finished 0 from 16 processes 2024-03-01 23:47:20,640 Finished 0 from 16 processes 2024-03-01 23:47:25,644 Finished 0 from 16 processes 2024-03-01 23:47:30,648 Finished 0 from 16 processes 2024-03-01 23:47:35,649 Finished 0 from 16 processes 2024-03-01 23:47:40,653 Finished 0 from 16 processes 2024-03-01 23:47:45,656 Finished 0 from 16 processes 2024-03-01 23:47:50,660 Finished 0 from 16 processes 2024-03-01 23:47:55,664 Finished 0 from 16 processes 2024-03-01 23:48:00,668 Finished 0 from 16 processes 2024-03-01 23:48:05,672 Finished 0 from 16 processes 2024-03-01 23:48:10,676 Finished 0 from 16 processes 2024-03-01 23:48:15,680 Finished 0 from 16 processes 2024-03-01 23:48:20,684 Finished 0 from 16 processes 2024-03-01 23:48:25,688 Finished 0 from 16 processes 2024-03-01 23:48:30,692 Finished 0 from 16 processes 2024-03-01 23:48:35,696 Finished 0 from 16 processes 2024-03-01 23:48:40,697 Finished 0 from 16 processes 2024-03-01 23:48:45,701 Finished 0 from 16 processes 2024-03-01 23:48:50,704 Finished 0 from 16 processes 2024-03-01 23:48:55,708 Finished 0 from 16 processes 2024-03-01 23:49:00,712 Finished 0 from 16 processes 2024-03-01 23:49:05,716 Finished 0 from 16 processes 2024-03-01 23:49:10,721 Finished 0 from 16 processes 2024-03-01 23:49:15,724 Finished 0 from 16 processes 2024-03-01 23:49:20,728 Finished 0 from 16 processes 2024-03-01 23:49:25,732 Finished 0 from 16 processes 2024-03-01 23:49:30,736 Finished 0 from 16 processes 2024-03-01 23:49:35,740 Finished 0 from 16 processes 2024-03-01 23:49:40,744 Finished 0 from 16 processes [Detaching after fork from child process 11619] 2024-03-01 23:49:45,748 Finished 0 from 16 processes 2024-03-01 23:49:50,752 Finished 0 from 16 processes 2024-03-01 23:49:55,753 Finished 0 from 16 processes 2024-03-01 23:50:00,756 Finished 0 from 16 processes 2024-03-01 23:50:05,760 Finished 0 from 16 processes 2024-03-01 23:50:10,764 Finished 0 from 16 processes 2024-03-01 23:50:15,768 Finished 0 from 16 processes 2024-03-01 23:50:20,772 Finished 0 from 16 processes 2024-03-01 23:50:25,776 Finished 0 from 16 processes 2024-03-01 23:50:30,780 Finished 0 from 16 processes 2024-03-01 23:50:35,784 Finished 0 from 16 processes 2024-03-01 23:50:40,788 Finished 0 from 16 processes 2024-03-01 23:50:45,792 Finished 0 from 16 processes 2024-03-01 23:50:50,796 Finished 0 from 16 processes 2024-03-01 23:50:55,800 Finished 0 from 16 processes 2024-03-01 23:51:00,804 Finished 0 from 16 processes 2024-03-01 23:51:05,808 Finished 0 from 16 processes 2024-03-01 23:51:10,812 Finished 0 from 16 processes 2024-03-01 23:51:15,816 Finished 0 from 16 processes 2024-03-01 23:51:20,820 Finished 0 from 16 processes 2024-03-01 23:51:25,824 Finished 0 from 16 processes 2024-03-01 23:51:30,828 Finished 1 from 16 processes 2024-03-01 23:51:35,832 Finished 1 from 16 processes 2024-03-01 23:51:40,839 Finished 1 from 16 processes 2024-03-01 23:51:45,844 Finished 1 from 16 processes 2024-03-01 23:51:50,848 Finished 1 from 16 processes 2024-03-01 23:51:55,852 Finished 1 from 16 processes 2024-03-01 23:52:00,856 Finished 1 from 16 processes 2024-03-01 23:52:05,860 Finished 1 from 16 processes 2024-03-01 23:52:10,864 Finished 1 from 16 processes 2024-03-01 23:52:15,868 Finished 1 from 16 processes 2024-03-01 23:52:20,872 Finished 1 from 16 processes 2024-03-01 23:52:25,876 Finished 1 from 16 processes 2024-03-01 23:52:30,880 Finished 1 from 16 processes 2024-03-01 23:52:35,884 Finished 1 from 16 processes 2024-03-01 23:52:40,885 Finished 1 from 16 processes 2024-03-01 23:52:45,890 Finished 1 from 16 processes 2024-03-01 23:52:50,892 Finished 1 from 16 processes 2024-03-01 23:52:55,896 Finished 1 from 16 processes 2024-03-01 23:53:00,900 Finished 1 from 16 processes 2024-03-01 23:53:05,904 Finished 1 from 16 processes 2024-03-01 23:53:10,908 Finished 1 from 16 processes 2024-03-01 23:53:15,912 Finished 1 from 16 processes 2024-03-01 23:53:20,916 Finished 1 from 16 processes 2024-03-01 23:53:25,921 Finished 1 from 16 processes 2024-03-01 23:53:30,924 Finished 1 from 16 processes 2024-03-01 23:53:35,928 Finished 1 from 16 processes 2024-03-01 23:53:40,932 Finished 1 from 16 processes 2024-03-01 23:53:45,936 Finished 1 from 16 processes 2024-03-01 23:53:50,940 Finished 1 from 16 processes 2024-03-01 23:53:55,944 Finished 1 from 16 processes 2024-03-01 23:54:00,948 Finished 1 from 16 processes 2024-03-01 23:54:05,952 Finished 1 from 16 processes 2024-03-01 23:54:10,956 Finished 1 from 16 processes 2024-03-01 23:54:15,960 Finished 1 from 16 processes 2024-03-01 23:54:20,965 Finished 1 from 16 processes 2024-03-01 23:54:25,968 Finished 1 from 16 processes 2024-03-01 23:54:30,972 Finished 1 from 16 processes 2024-03-01 23:54:35,976 Finished 1 from 16 processes 2024-03-01 23:54:40,980 Finished 1 from 16 processes 2024-03-01 23:54:45,984 Finished 1 from 16 processes 2024-03-01 23:54:50,989 Finished 1 from 16 processes 2024-03-01 23:54:55,994 Finished 1 from 16 processes 2024-03-01 23:55:00,996 Finished 1 from 16 processes 2024-03-01 23:55:06,000 Finished 1 from 16 processes 2024-03-01 23:55:11,004 Finished 1 from 16 processes 2024-03-01 23:55:16,008 Finished 1 from 16 processes 2024-03-01 23:55:21,012 Finished 1 from 16 processes 2024-03-01 23:55:26,017 Finished 1 from 16 processes 2024-03-01 23:55:31,021 Finished 1 from 16 processes 2024-03-01 23:55:36,024 Finished 1 from 16 processes 2024-03-01 23:55:41,028 Finished 1 from 16 processes 2024-03-01 23:55:46,032 Finished 1 from 16 processes 2024-03-01 23:55:51,036 Finished 1 from 16 processes 2024-03-01 23:55:56,040 Finished 1 from 16 processes 2024-03-01 23:56:01,044 Finished 1 from 16 processes 2024-03-01 23:56:06,048 Finished 1 from 16 processes 2024-03-01 23:56:11,052 Finished 1 from 16 processes 2024-03-01 23:56:16,054 Finished 1 from 16 processes 2024-03-01 23:56:21,056 Finished 1 from 16 processes 2024-03-01 23:56:26,060 Finished 1 from 16 processes 2024-03-01 23:56:34,412 Finished 1 from 16 processes 2024-03-01 23:56:39,460 Finished 1 from 16 processes 2024-03-01 23:56:44,464 Finished 1 from 16 processes 2024-03-01 23:56:49,469 Finished 1 from 16 processes 2024-03-01 23:56:54,472 Finished 1 from 16 processes 2024-03-01 23:56:59,476 Finished 1 from 16 processes 2024-03-01 23:57:04,481 Finished 1 from 16 processes 2024-03-01 23:57:09,484 Finished 1 from 16 processes 2024-03-01 23:57:14,484 Finished 1 from 16 processes 2024-03-01 23:57:19,489 Finished 1 from 16 processes 2024-03-01 23:57:24,492 Finished 1 from 16 processes 2024-03-01 23:57:29,496 Finished 1 from 16 processes 2024-03-01 23:57:34,500 Finished 1 from 16 processes 2024-03-01 23:57:39,505 Finished 1 from 16 processes 2024-03-01 23:57:44,508 Finished 1 from 16 processes 2024-03-01 23:57:49,512 Finished 1 from 16 processes 2024-03-01 23:57:54,516 Finished 1 from 16 processes 2024-03-01 23:57:59,520 Finished 1 from 16 processes 2024-03-01 23:58:04,524 Finished 1 from 16 processes 2024-03-01 23:58:09,528 Finished 1 from 16 processes 2024-03-01 23:58:14,532 Finished 1 from 16 processes 2024-03-01 23:58:19,536 Finished 1 from 16 processes 2024-03-01 23:58:24,540 Finished 1 from 16 processes 2024-03-01 23:58:29,544 Finished 1 from 16 processes 2024-03-01 23:58:34,548 Finished 1 from 16 processes 2024-03-01 23:58:39,552 Finished 1 from 16 processes 2024-03-01 23:58:44,556 Finished 1 from 16 processes 2024-03-01 23:58:49,560 Finished 1 from 16 processes 2024-03-01 23:58:54,564 Finished 1 from 16 processes 2024-03-01 23:58:59,568 Finished 1 from 16 processes 2024-03-01 23:59:04,572 Finished 1 from 16 processes 2024-03-01 23:59:09,576 Finished 1 from 16 processes 2024-03-01 23:59:14,580 Finished 1 from 16 processes 2024-03-01 23:59:19,584 Finished 1 from 16 processes 2024-03-01 23:59:24,588 Finished 1 from 16 processes 2024-03-01 23:59:29,592 Finished 1 from 16 processes 2024-03-01 23:59:34,596 Finished 1 from 16 processes 2024-03-01 23:59:39,600 Finished 1 from 16 processes 2024-03-01 23:59:44,604 Finished 1 from 16 processes 2024-03-01 23:59:49,608 Finished 1 from 16 processes 2024-03-01 23:59:54,612 Finished 1 from 16 processes 2024-03-01 23:59:59,616 Finished 1 from 16 processes 2024-03-02 00:00:04,620 Finished 1 from 16 processes 2024-03-02 00:00:09,624 Finished 1 from 16 processes 2024-03-02 00:00:14,628 Finished 1 from 16 processes 2024-03-02 00:00:19,632 Finished 1 from 16 processes 2024-03-02 00:00:24,636 Finished 1 from 16 processes 2024-03-02 00:00:29,640 Finished 1 from 16 processes 2024-03-02 00:00:34,644 Finished 1 from 16 processes 2024-03-02 00:00:39,648 Finished 1 from 16 processes 2024-03-02 00:00:44,652 Finished 1 from 16 processes 2024-03-02 00:00:49,656 Finished 1 from 16 processes 2024-03-02 00:00:54,660 Finished 1 from 16 processes 2024-03-02 00:00:59,664 Finished 2 from 16 processes 2024-03-02 00:01:04,668 Finished 4 from 16 processes 2024-03-02 00:01:09,673 Finished 6 from 16 processes 2024-03-02 00:01:14,676 Finished 9 from 16 processes 2024-03-02 00:01:19,680 Finished 9 from 16 processes 2024-03-02 00:01:24,685 Finished 9 from 16 processes 2024-03-02 00:01:29,688 Finished 10 from 16 processes 2024-03-02 00:01:34,692 Finished 10 from 16 processes 2024-03-02 00:01:39,697 Finished 10 from 16 processes 2024-03-02 00:01:44,702 Finished 11 from 16 processes 2024-03-02 00:01:49,707 Finished 12 from 16 processes 2024-03-02 00:01:54,713 Finished 12 from 16 processes 2024-03-02 00:01:59,716 Finished 12 from 16 processes 2024-03-02 00:02:04,717 Finished 13 from 16 processes 2024-03-02 00:02:09,720 Finished 13 from 16 processes 2024-03-02 00:02:14,725 Finished 13 from 16 processes 2024-03-02 00:02:19,730 Finished 13 from 16 processes 2024-03-02 00:02:24,736 Finished 13 from 16 processes 2024-03-02 00:02:29,741 Finished 13 from 16 processes 2024-03-02 00:02:34,746 Finished 14 from 16 processes 2024-03-02 00:02:39,752 Finished 14 from 16 processes 2024-03-02 00:02:44,756 Finished 14 from 16 processes 2024-03-02 00:02:49,761 Finished 14 from 16 processes 2024-03-02 00:02:54,764 Finished 14 from 16 processes 2024-03-02 00:02:59,769 Finished 14 from 16 processes 2024-03-02 00:03:04,774 Finished 14 from 16 processes 2024-03-02 00:03:09,779 Finished 14 from 16 processes 2024-03-02 00:03:14,785 Finished 14 from 16 processes 2024-03-02 00:03:19,788 Finished 14 from 16 processes 2024-03-02 00:03:24,791 Finished 14 from 16 processes 2024-03-02 00:03:29,795 Finished 14 from 16 processes 2024-03-02 00:03:34,800 Finished 14 from 16 processes 2024-03-02 00:03:39,805 Finished 14 from 16 processes 2024-03-02 00:03:44,811 Finished 14 from 16 processes 2024-03-02 00:03:49,816 Finished 14 from 16 processes 2024-03-02 00:03:54,821 Finished 14 from 16 processes 2024-03-02 00:03:59,826 Finished 14 from 16 processes 2024-03-02 00:04:04,831 Finished 14 from 16 processes 2024-03-02 00:04:09,837 Finished 14 from 16 processes 2024-03-02 00:04:14,840 Finished 14 from 16 processes 2024-03-02 00:04:19,845 Finished 14 from 16 processes 2024-03-02 00:04:24,850 Finished 14 from 16 processes 2024-03-02 00:04:29,852 Finished 14 from 16 processes 2024-03-02 00:04:34,857 Finished 14 from 16 processes 2024-03-02 00:04:39,862 Finished 14 from 16 processes 2024-03-02 00:04:44,867 Finished 14 from 16 processes 2024-03-02 00:04:49,873 Finished 14 from 16 processes 2024-03-02 00:04:54,876 Finished 14 from 16 processes 2024-03-02 00:04:59,880 Finished 14 from 16 processes 2024-03-02 00:05:04,885 Finished 14 from 16 processes 2024-03-02 00:05:09,890 Finished 14 from 16 processes 2024-03-02 00:05:14,895 Finished 14 from 16 processes 2024-03-02 00:05:19,901 Finished 14 from 16 processes 2024-03-02 00:05:24,904 Finished 14 from 16 processes 2024-03-02 00:05:29,908 Finished 14 from 16 processes 2024-03-02 00:05:34,913 Finished 14 from 16 processes 2024-03-02 00:05:39,918 Finished 14 from 16 processes 2024-03-02 00:05:44,923 Finished 14 from 16 processes 2024-03-02 00:05:49,927 Finished 14 from 16 processes 2024-03-02 00:05:54,932 Finished 14 from 16 processes 2024-03-02 00:05:59,938 Finished 14 from 16 processes 2024-03-02 00:06:04,943 Finished 14 from 16 processes 2024-03-02 00:06:09,948 Finished 14 from 16 processes 2024-03-02 00:06:14,952 Finished 14 from 16 processes 2024-03-02 00:06:19,957 Finished 14 from 16 processes 2024-03-02 00:06:24,962 Finished 14 from 16 processes 2024-03-02 00:06:29,967 Finished 14 from 16 processes 2024-03-02 00:06:34,972 Finished 14 from 16 processes 2024-03-02 00:06:39,976 Finished 14 from 16 processes 2024-03-02 00:06:44,981 Finished 14 from 16 processes 2024-03-02 00:06:49,984 Finished 14 from 16 processes 2024-03-02 00:06:54,989 Finished 14 from 16 processes 2024-03-02 00:06:59,994 Finished 14 from 16 processes 2024-03-02 00:07:04,996 Finished 14 from 16 processes 2024-03-02 00:07:09,997 Finished 14 from 16 processes 2024-03-02 00:07:15,002 Finished 14 from 16 processes 2024-03-02 00:07:20,008 Finished 14 from 16 processes 2024-03-02 00:07:25,013 Finished 14 from 16 processes 2024-03-02 00:07:30,018 Finished 14 from 16 processes 2024-03-02 00:07:35,024 Finished 14 from 16 processes 2024-03-02 00:07:40,029 Finished 14 from 16 processes 2024-03-02 00:07:45,032 Finished 14 from 16 processes 2024-03-02 00:07:50,034 Finished 14 from 16 processes 2024-03-02 00:07:55,036 Finished 14 from 16 processes 2024-03-02 00:08:00,040 Finished 14 from 16 processes 2024-03-02 00:08:05,045 Finished 14 from 16 processes 2024-03-02 00:08:10,048 Finished 14 from 16 processes 2024-03-02 00:08:15,053 Finished 14 from 16 processes 2024-03-02 00:08:20,058 Finished 14 from 16 processes 2024-03-02 00:08:25,063 Finished 14 from 16 processes 2024-03-02 00:08:30,068 Finished 14 from 16 processes 2024-03-02 00:08:35,072 Finished 14 from 16 processes 2024-03-02 00:08:40,076 Finished 14 from 16 processes 2024-03-02 00:08:45,081 Finished 14 from 16 processes 2024-03-02 00:08:50,086 Finished 14 from 16 processes 2024-03-02 00:08:55,092 Finished 14 from 16 processes 2024-03-02 00:09:00,097 Finished 14 from 16 processes 2024-03-02 00:09:05,100 Finished 14 from 16 processes 2024-03-02 00:09:10,104 Finished 14 from 16 processes 2024-03-02 00:09:15,109 Finished 14 from 16 processes 2024-03-02 00:09:20,114 Finished 14 from 16 processes 2024-03-02 00:09:25,120 Finished 14 from 16 processes 2024-03-02 00:09:30,124 Finished 14 from 16 processes 2024-03-02 00:09:35,128 Finished 14 from 16 processes 2024-03-02 00:09:40,133 Finished 14 from 16 processes 2024-03-02 00:09:45,136 Finished 15 from 16 processes 2024-03-02 00:09:50,141 Finished 15 from 16 processes 2024-03-02 00:09:55,144 All processes finished 2024-03-02 00:09:55,144 Compressing stress logs 2024-03-02 00:09:55,189 Logs compressed 2024-03-02 00:09:55,190 Will terminate gdb (if any) 2024-03-02 00:15:00,348 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.31 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) 155180 0.08 30.45 MiB 0.095 1 677 ['Test'] 0.062 read() returned {}, sample block {} 137740 0.071 25.51 MiB 0.079 1 677 ['Test'] 0.039 First reader returned: {}, requested columns: {} 97754 0.05 34.69 MiB 0.108 1 845 ['Test'] 0.11 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: {} 97742 0.05 35.32 MiB 0.11 1 845 ['Test'] 0.11 Current count: {}, position: {}, read range: {}, file segment: {} 97588 0.05 10.06 MiB 0.031 1 845 ['Test'] 0.11 Read {} bytes, read type {}, position: {}, offset: {}, remaining read range: {} 68299 0.035 6.40 MiB 0.02 4 376 ['Test'] 0.294 Write file: {} 68242 0.035 4.34 MiB 0.014 1 352 ['Trace'] 0.297 Object {} exists after upload 68242 0.035 4.93 MiB 0.015 1 352 ['Trace'] 0.297 Checking object {} exists after upload 68219 0.035 7.32 MiB 0.023 1 372 ['Trace'] 0.297 Making single part upload. Bucket: {}, Key: {}, Size: {}, WithPool: {} 68219 0.035 8.23 MiB 0.026 1 69 ['Trace'] 0.433 Single part upload has completed. Bucket: {}, Key: {}, Object size: {}, WithPool: {} 48732 0.025 4.13 MiB 0.013 1 845 ['Test'] 0.193 Current file segment: {}, read type: {}, current file offset: {} 44818 0.023 2.81 MiB 0.009 1 845 ['Test'] 0.21 Having {} file segments to read: {}, current offset: {} 43299 0.022 3.60 MiB 0.011 1 619 ['Test'] 0.02 Downloader id: {}, caller id: {} 40849 0.021 4.22 MiB 0.013 1 884 ['Test'] 0.365 Read S3 object. Bucket: {}, Key: {}, Version: {}, Range: {}-{} 38113 0.02 1.66 MiB 0.005 1 3 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 34188 0.018 11.02 MiB 0.034 1 713 ['Test'] 0.022 Completed file segment: {} 34188 0.018 12.05 MiB 0.038 1 713 ['Test'] 0.022 Complete based on current state (is_last_holder: {}, {}) 26642 0.014 1.65 MiB 0.005 4 477 ['Trace'] 0.003 Access granted: {}{} 25965 0.013 7.41 MiB 0.023 1 166 ['Test'] 0.375 Detached file segment: {} 25488 0.013 1.36 MiB 0.004 1 649 ['Test'] 0.053 Updated state from {} to {} 22915 0.012 971.96 KiB 0.003 1 155 ['Debug'] 0.055 Peak memory usage{}: {}. 22147 0.011 6.14 MiB 0.019 1 122 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 21528 0.011 3.22 MiB 0.01 2 121 ['Debug'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 21454 0.011 2.83 MiB 0.009 1 584 ['Test'] 0.202 ReadResult::optimize() after: {} 21454 0.011 3.11 MiB 0.01 1 584 ['Test'] 0.202 ReadResult::optimize() before: {} 21454 0.011 2.69 MiB 0.008 1 584 ['Test'] 0.202 After execute prewhere {} 21140 0.011 1.66 MiB 0.005 1 584 ['Test'] 0.204 Executing prewhere actions on block: {} 20099 0.01 567.40 KiB 0.002 1 121 ['Debug'] 0 Processed in {} sec. 17644 0.009 1.68 MiB 0.005 1 134 ['Test'] 0.507 Bypassing cache because `read_from_filesystem_cache_if_exists_otherwise_bypass_cache` option is used 16327 0.008 680.86 KiB 0.002 1 635 ['Test'] 0.048 Resetting downloader from {} 15546 0.008 370.94 KiB 0.001 1 214 ['Trace'] 0.009 {} -> {} 15398 0.008 449.45 KiB 0.001 1 678 ['Trace'] 0.002 Aggregation method: {} 15014 0.008 1.38 MiB 0.004 1 672 ['Trace'] 0.002 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 11778 0.006 951.24 KiB 0.003 1 109 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 11518 0.006 123.73 KiB 0 1 673 ['Trace'] 0.002 Aggregating 10672 0.005 3.29 MiB 0.01 1 619 ['Test'] 0.027 Complete batch. ({}) 10409 0.005 481.47 KiB 0.001 1 564 ['Test'] 0.003 ReadResult::applyFilter() num_rows before: {} 10409 0.005 459.39 KiB 0.001 1 564 ['Test'] 0.003 ReadResult::applyFilter() num_rows after: {} 10172 0.005 838.77 KiB 0.003 1 646 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 9108 0.005 1022.87 KiB 0.003 3 168 ['Debug'] 0.994 {} Authenticated with global context as user {} 9108 0.005 741.40 KiB 0.002 3 168 ['Debug'] 0.994 {} Authenticating user \'{}\' from {} 8900 0.005 1.00 MiB 0.003 1 36 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 8878 0.005 971.03 KiB 0.003 2 121 ['Debug'] 1 {} Creating session context with user_id: {} 8609 0.004 445.58 KiB 0.001 1 350 ['Test'] 0.492 ReadResult::optimize() combined filter is const False 8343 0.004 546.50 KiB 0.002 4 416 ['Trace'] 0.694 Reserved {} on remote disk {}, having unreserved {}. 7628 0.004 249.00 KiB 0.001 1 121 ['Trace'] 1 TCP Request. Address: {} 7625 0.004 714.98 KiB 0.002 1 121 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 7593 0.004 200.21 KiB 0.001 1 121 ['Debug'] 1 Done processing connection. 7496 0.004 379.66 KiB 0.001 1 161 ['Test'] 1 Nothing to clean up from store/ on disk {} 7316 0.004 428.67 KiB 0.001 1 120 ['Test'] 1 Closing connection (open: {}, cancelled: {}, eof: {}) 6819 0.004 520.61 KiB 0.002 1 545 ['Test'] 0.041 Added entry into LRU queue, key: {}, offset: {} 6260 0.003 741.29 KiB 0.002 368 333 ['Trace'] 0.431 Renaming temporary part {} to {} with tid {}. 6260 0.003 536.11 KiB 0.002 368 333 ['Test'] 0.431 preparePartForCommit: inserting {} into data_parts_indexes 6076 0.003 287.33 KiB 0.001 1 335 ['Trace'] 0.429 filled checksums {} 6068 0.003 410.72 KiB 0.001 1 52 ['Debug'] 0.082 Remove from cache. Key: {}, offset: {} 6040 0.003 473.61 KiB 0.001 1 47 ['Test'] 0.083 Removed entry from LRU queue, key: {}, offset: {} 5917 0.003 410.43 KiB 0.001 371 513 ['Trace'] 0.594 Trying to reserve {} using storage policy from min volume index {} 5780 0.003 939.74 KiB 0.003 1 78 ['Test'] 0.097 Trying to lock removal_tid by {}, table: {}, part: {} 5456 0.003 170.20 KiB 0.001 1 585 ['Test'] 0 Successfully written {} bytes 5005 0.003 578.91 KiB 0.002 1 111 ['Trace'] 0.084 PREWHERE condition was split into {} steps: {} 5005 0.003 5.27 MiB 0.016 1 111 ['Test'] 0.084 Original PREWHERE DAG:\n{}\nPREWHERE actions:\n{} 4894 0.003 2.54 MiB 0.008 1 191 ['Trace'] 0.972 Objects with paths [{}] were removed from S3 4077 0.002 335.49 KiB 0.001 59 49 ['Test'] 0.998 removePartsFinally: removing {} from data_parts_indexes 4059 0.002 383.36 KiB 0.001 1 49 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 3746 0.002 310.86 KiB 0.001 1 127 ['Trace'] 0.005 Reading {} ranges in order from part {}, approx. {} rows starting from {} 3619 0.002 114.13 KiB 0 293 169 ['Debug'] 0.021 Key condition: {} 3536 0.002 409.41 KiB 0.001 289 169 ['Debug'] 0.021 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 3369 0.002 233.64 KiB 0.001 271 16 ['Trace'] 1 Executing log entry to mutate part {} to {} 3313 0.002 171.47 KiB 0.001 255 167 ['Trace'] 0.022 Spreading mark ranges among streams (default reading) 3266 0.002 1.34 MiB 0.004 1 86 ['Trace'] 0 No entry found for query {} 3191 0.002 195.63 KiB 0.001 1 308 ['Test'] 0 Current write offset: {}, file offset of buffer end: {} 2862 0.001 109.74 KiB 0 100 125 ['Debug'] 0.007 MinMax index condition: {} 2840 0.001 119.95 KiB 0 1 71 ['Debug'] 0 ({}) Keys: {} 2840 0.001 519.88 KiB 0.002 1 71 ['Debug'] 0 ({}) Datatype: {}, kind: {}, strictness: {}, right header: {} 2804 0.001 228.37 KiB 0.001 1 48 ['Trace'] 0.003 ({}) Join data is being destroyed, {} bytes and {} rows in hash table 2757 0.001 245.08 KiB 0.001 1 207 ['Test'] 0.55 Beginning transaction {} ({}) 2721 0.001 61.12 KiB 0 1 554 ['Trace'] 0.013 Merging aggregated data 2634 0.001 119.77 KiB 0 1 21 ['Test'] 0.106 Resize cell {} to downloaded: {} 2612 0.001 318.93 KiB 0.001 1 3 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 2593 0.001 191.61 KiB 0.001 1 192 ['Test'] 0.58 Closing readonly transaction {} 2582 0.001 383.30 KiB 0.001 2 39 ['Test'] 0.111 Caching file `{}` to `{}` with key {} 2385 0.001 77.93 KiB 0 1 510 ['Test'] 0 Completed segment: {} 2385 0.001 164.07 KiB 0 1 510 ['Test'] 0 Removing file segment: {}, downloader: {}, state: {} 2385 0.001 66.45 KiB 0 1 510 ['Test'] 0 New segment: {} 2303 0.001 116.95 KiB 0 1 233 ['Test'] 0.03 ReadResult::optimize() combined filter is const True 2291 0.001 131.47 KiB 0 11 24 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 2290 0.001 81.48 KiB 0 11 24 ['Trace'] 1 Flushed system log up to offset {} 2075 0.001 271.07 KiB 0.001 15 16 ['Test'] 1 Adding zero-copy lock on {} 2050 0.001 203.76 KiB 0.001 40 16 ['Debug'] 1 Mutation of part {} started by some other replica, will wait it and mutated merged part 1969 0.001 78.84 KiB 0 1 523 ['Trace'] 0 Converting aggregation data to two-level. 1552 0.001 5.40 MiB 0.017 4 88 ['Error'] 0.006 Table {} doesn\'t exist 1522 0.001 278.51 KiB 0.001 2 93 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {} 1521 0.001 902.84 KiB 0.003 2 93 ['Trace'] 1 Request URI: {} 1473 0.001 59.90 KiB 0 98 119 ['Debug'] 0.037 Reading approx. {} rows with {} streams 1469 0.001 30.13 KiB 0 2 93 ['Debug'] 0.061 Done processing query 1353 0.001 182.18 KiB 0.001 34 57 ['Test'] 0 Got {} parts (of {}) visible in snapshot {} (TID {}): {} 1348 0.001 40.08 KiB 0 48 464 ['Trace'] 0 Found {} range in {} steps 1348 0.001 91.79 KiB 0 48 464 ['Trace'] 0 Running binary search on index range for part {} ({} marks) 1348 0.001 39.15 KiB 0 48 464 ['Trace'] 0 Found (LEFT) boundary mark: {} 1348 0.001 40.60 KiB 0 48 464 ['Trace'] 0 Found (RIGHT) boundary mark: {} Top messages without format string (fmt::runtime): count pattern runtime_message line UInt64 String String Tuple(String, UInt64) 14 CodeDBExceptionReceivedfromDBExc Code: 507. DB::Exception: Received from 127.0.0.2:9000. DB::Exception: Sharding key modulo(sub_key, 2) is not used. Stack trace:\n\n0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:0: Poco::Exception::Exception(String const&, int) @ 0x23912b ('/executeQuery.cpp',205) 8 virtualboolDBReplicatedMergeMuta virtual bool DB::ReplicatedMergeMutateTaskBase::executeStep(): 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/./con ('/Exception.cpp',193) 6 CodeDBExceptionSyntaxerrorfailed Code: 62. DB::Exception: Syntax error: failed at position 8 (\'$\'): $$ab\n. Expected one of: ALL, DISTINCT ON, DISTINCT, TOP, not empty list of expressions, list of expressions, list of elements, expression with optional alias, element of expression with opt ('/executeQuery.cpp',205) 5 voidDBStorageReplicatedMergeTree void DB::StorageReplicatedMergeTree::mutationsUpdatingTask(): 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/./cont ('/Exception.cpp',193) 5 Cannotremovetestdbtestreplicassr Cannot remove /test/db/test_11/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) 4 createsnapshotidxlogterm create snapshot idx 10000 log_term 3 ('/LoggerWrapper.h',42) 4 createsnapshotidxlogtermdoneusel create snapshot idx 10000 log_term 3 done: 11537 us elapsed ('/LoggerWrapper.h',42) 4 creatingasnapshotforindex creating a snapshot for index 10000 ('/LoggerWrapper.h',42) 4 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) 4 snapshotidxlogtermcreatedcompact snapshot idx 10000 log_term 3 created, compact the log store if needed ('/LoggerWrapper.h',42) 2 CodeDBErrnoExceptionCannotrename Code: 521. DB::ErrnoException: Cannot rename /var/lib/clickhouse/metadata/test.sql.tmp to /var/lib/clickhouse/metadata/test.sql because the second path already exists, errno: 17, strerror: File exists. (ATOMIC_RENAME_FAIL) (version 23.3.19.33.altinitystabl ('/executeQuery.cpp',205) 2 CodeDBExceptionCannotmodifyallow Code: 392. DB::Exception: Cannot modify \'allow_ddl\' setting when DDL queries are prohibited for the user. (QUERY_IS_PROHIBITED) (version 23.3.19.33.altinitystable (altinity build)) (from [::1]:44762) (comment: 00716_allow_ddl.sql) (in query: SET allow_ddl ('/executeQuery.cpp',205) 2 CodeDBExceptionUnknownstatusclie Code: 319. DB::Exception: Unknown status, client must retry. Reason: Code: 159. DB::Exception: Timeout while waiting for quorum. (TIMEOUT_EXCEEDED) (version 23.3.19.33.altinitystable (altinity build)). (UNKNOWN_STATUS_OF_INSERT) (version 23.3.19.33.altinit ('/executeQuery.cpp',205) 2 CodeDBExceptionReceivedfromlocal Code: 60. DB::Exception: Received from localhost:9000. DB::Exception: Table shard_1.data_01850 doesn\'t exist. Stack trace:\n\n0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:0: Poco::Exception::Exception(String const&, int) @ 0x23912b3e in ('/executeQuery.cpp',205) 2 CodeCoordinationExceptionSession Code: 999. Coordination::Exception: Session expired, path: Session expired. (KEEPER_EXCEPTION) (version 23.3.19.33.altinitystable (altinity build)) (from [::1]:42760) (comment: 01593_concurrent_alter_mutations_kill.sh) (in query: ALTER TABLE concurrent_mut ('/executeQuery.cpp',205) 2 CodeDBExceptionEmptyquerySYNTAXE Code: 62. DB::Exception: Empty query. (SYNTAX_ERROR) (version 23.3.19.33.altinitystable (altinity build)) (from [::ffff:127.0.0.1]:55104) (in query: ), Stack trace (when copying this message, always include the lines below):\n\n0. ./build_docker/./contrib/ll ('/executeQuery.cpp',205) 2 Cannotremoveclickhousetesttables Cannot remove /clickhouse/test_13/tables/test_cleanup/replicas/r1/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. ./buil ('/Exception.cpp',193) 1 PocoExceptionCodeecodeExceptionC Poco::Exception. Code: 1000, e.code() = 0, Exception: Cannot load time zone not a timezone (version 23.3.19.33.altinitystable (altinity build)) (from [::1]:34616) (comment: 02244_make_datetime.sql) (in query: select makeDateTime(1984, 1, 1, 0, 0, 0, \'not a ('/executeQuery.cpp',205) 1 Cannotremoveclickhousetablesconc Cannot remove /clickhouse/tables/01593_concurrent_alter_mutations_kill_test_uu3nv9ej/concurrent_mutate_kill/replicas/1/is_active: Code: 999. Coordination::Exception: Session expired, path: Session expired. (KEEPER_EXCEPTION), Stack trace (when copying this ('/Exception.cpp',193) 1 CodeDBExceptionExceptionCannotlo Code: 1000. DB::Exception: Exception: Cannot load time zone not a timezone. (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::Ex ('/TCPHandler.cpp',606) 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) 75 /var/lib/clickhouse/disks/s3_disk/store/b71/b7199fda-30c9-4536-a091-4a735168002b/tmp_merge_201403_8_16_1/ is in use (by 20 Poco::Exception. Code: 1000, e.code() = 32, I/O error: Broken pipe, Stack trace (when copying this message, always inclu (from {}{}{}){}{} {} (stage: {}) 1 (from [::1]:60424) (comment: 01957_heredoc_more.sql) SELECT hex($$����$$); (stage: Complete) Top short messages: c message_format_string substring(any(message), 1, 120) UInt64 LowCardinality(String) String 68492 Write file: {} Write file: store/8fb/8fb91b80-28e0-47e7-ad17-fb69d0c04f32/tmp_insert_20150101_20150101_4_4_0/default_compression_codec. 1552 Table {} doesn\'t exist Code: 60. DB::Exception: Table test_ofwo9v3l.view_00840 doesn\'t exist. (UNKNOWN_TABLE) (version 23.3.19.33.altinitystabl 158 Table {} already exists. Code: 57. DB::Exception: Table test_11.t2 already exists. (TABLE_ALREADY_EXISTS) (version 23.3.19.33.altinitystable (alt 106 Database {} doesn\'t exist Code: 81. DB::Exception: Database test_01444 doesn\'t exist. (UNKNOWN_DATABASE) (version 23.3.19.33.altinitystable (altin 42 Table {} does not exist Code: 60. DB::Exception: Table t1 does not exist. (UNKNOWN_TABLE) (version 23.3.19.33.altinitystable (altinity build)) ( 16 {} convert overflow Code: 407. DB::Exception: Decimal convert overflow: While processing toDecimal64(toDecimal64(\'1234567890\', 8), 10). (DEC 14 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 8 Invalid mode: {} Code: 36. DB::Exception: Invalid mode: blah blah blah: While processing aes_encrypt_mysql(\'blah blah blah\', \'[HIDDEN]\'). 6 Table {}.{} doesn\'t exist Code: 60. DB::Exception: Table `test_01109`.`t3` doesn\'t exist. (UNKNOWN_TABLE) (version 23.3.19.33.altinitystable (alti 4 Invalid partition format: {} Code: 248. DB::Exception: Invalid partition format: NO_SUCH_PART. (INVALID_PARTITION_VALUE) (version 23.3.19.33.altinity 4 No cache found by path: {} Code: 36. DB::Exception: No cache found by path: ./data. (BAD_ARGUMENTS) (version 23.3.19.33.altinitystable (altinity bu 3 Unknown data type family: {} Code: 50. DB::Exception: Unknown data type family: NULL. (UNKNOWN_TYPE) (version 23.3.19.33.altinitystable (altinity bui 2 Cannot ALTER column Code: 524. DB::Exception: Cannot ALTER column: Cannot apply mutation because it breaks projection p1. (ALTER_OF_COLUMN_I 2 Polygon is not valid: {} Code: 36. DB::Exception: Polygon is not valid: Geometry has interior rings defined outside the outer boundary: While pro 2 Array sizes are too large: {} Code: 128. DB::Exception: Array sizes are too large: 13830481612736675823: Cannot extract table structure from Native fo 2 Scale {} is out of bounds Code: 69. DB::Exception: Scale 19 is out of bounds: While processing toDateTime64(\'2011-11-11 11:11:11.++++++++++++11111 2 Tuple cannot be empty Code: 92. DB::Exception: Tuple cannot be empty: While processing CAST(0, \'Tuple\'). (EMPTY_DATA_PASSED) (version 23.3.19. 2 Unsupported cipher mode Code: 36. DB::Exception: Unsupported cipher mode: While processing aes_encrypt_mysql(\'aes-128-gcm\', \'[HIDDEN]\'). (BAD_AR 2 Table {} was suddenly removed Code: 415. DB::Exception: Table /clickhouse/tables/01305_replica_create_drop_zookeeper_test_ayokh38q/alter_table was sud 2 No additional keys found. Code: 117. DB::Exception: No additional keys found. (INCORRECT_DATA) (version 23.3.19.33.altinitystable (altinity build) Top messages by level: (0.0007931158363053884,'Table {} doesn\'t exist') Error (0.0001369555696712913,'Client has gone away.') Warning (0.00048292169156481445,'Removing metadata {} of dropped table {}') Information (0.01171787765881608,'Peak memory usage{}: {}.') Debug (0.03497221794945828,'Object {} exists after upload') Trace (0.08029377991750981,'read() returned {}, sample block {}') Test 2024-03-02 00:15:30,627 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=1547 + clickhouse stop --max-tries 90 --do-not-kill /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1547. The process with pid = 1547 is running. Sent terminate signal to process with pid 1547. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1547. The process with pid = 1547 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1547. The process with pid = 1547 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1547. The process with pid = 1547 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1547. The process with pid = 1547 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1547. The process with pid = 1547 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1547. The process with pid = 1547 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1547. The process with pid = 1547 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1547. The process with pid = 1547 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1547. The process with pid = 1547 does not exist. Server stopped + return + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.stress.log + unset + 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 127.0.0.1 - - [01/Mar/2024:21:15:42 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - + sleep 0.5 127.0.0.1 - - [01/Mar/2024:21:15:43 +0000] "PUT /devstoreaccount1/cont/mqalbqquztiuxqhkbwulqukbmshdtjhg?blockid=owllpbcbkjojainoqxrlkpsvjelsrklonrasiriwuiehhfquwmdabqbyyhmksbyv&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:21:15:43 +0000] "PUT /devstoreaccount1/cont/mqalbqquztiuxqhkbwulqukbmshdtjhg?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [01/Mar/2024:21:15:43 +0000] "GET /devstoreaccount1/cont/mqalbqquztiuxqhkbwulqukbmshdtjhg HTTP/1.1" 206 4 127.0.0.1 - - [01/Mar/2024:21:15:43 +0000] "GET /devstoreaccount1/cont/mqalbqquztiuxqhkbwulqukbmshdtjhg HTTP/1.1" 206 2 127.0.0.1 - - [01/Mar/2024:21:15:43 +0000] "DELETE /devstoreaccount1/cont/mqalbqquztiuxqhkbwulqukbmshdtjhg HTTP/1.1" 202 - + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + clickhouse start --user root + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' 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 41413 + clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\''' Connected to clickhouse-server after attaching gdb real 0m0.206s user 0m0.148s sys 0m0.056s + 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=41413 + 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 = 41413. The process with pid = 41413 is running. Sent terminate signal to process with pid 41413. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 41413. The process with pid = 41413 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 41413. The process with pid = 41413 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 41413. The process with pid = 41413 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 41413. The process with pid = 41413 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 41413. The process with pid = 41413 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped + return + '[' -f /var/log/clickhouse-server/clickhouse-server.log ']' + '[' -f /var/log/clickhouse-server/stderr.log ']' + mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.final.log + check_logs_for_critical_errors + rg -Fa ================== /var/log/clickhouse-server/stderr.log + rg -v 'in query:' + rg -Fa WARNING /var/log/clickhouse-server/stderr.log + rg -Fav -e 'ASan doesn'\''t fully support makecontext/swapcontext functions' -e DB::Exception /test_output/tmp + echo -e 'No sanitizer asserts\tOK\t\N\t' + rm -f /test_output/tmp + rg -Fa ' Application: Child process was terminated by signal 9' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No OOM messages in clickhouse-server.log\tOK\t\N\t' + rg -Fa 'Code: 49. DB::Exception: ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No logical errors\tOK\t\N\t' + '[' -s /test_output/logical_errors.txt ']' + rm /test_output/logical_errors.txt + rg --text 'Code: 499.*The specified key does not exist' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No lost s3 keys\tOK\t\N\t' + '[' -s /test_output/no_such_key_errors.txt ']' + rm /test_output/no_such_key_errors.txt + rg -Fa '########################################' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'Not crashed\tOK\t\N\t' + rg -Fa ' ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log + echo -e 'No fatal messages in clickhouse-server.log\tOK\t\N\t' + '[' -s /test_output/fatal_messages.txt ']' + rm /test_output/fatal_messages.txt + rg -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 + clickhouse-local --path /var/lib/clickhouse/ --only-system-tables -q 'select * from system.query_log format TSVWithNamesAndTypes' + zstd --threads=0 + for table in query_log trace_log + clickhouse-local --path /var/lib/clickhouse/ --only-system-tables -q 'select * from system.trace_log format TSVWithNamesAndTypes' + zstd --threads=0 + mv /var/log/clickhouse-server/stderr.log /test_output/ + clickhouse-local --structure 'test String, res String, time Nullable(Float32), desc String' -q 'SELECT '\''failure'\'', test FROM table WHERE res != '\''OK'\'' order by (test like '\''%Sanitizer%'\'') DESC, (test like '\''%Killed by signal%'\'') DESC, (test like '\''%gdb.log%'\'') DESC, (test ilike '\''%possible deadlock%'\'') DESC, (test like '\''%start%'\'') DESC, (test like '\''%dmesg%'\'') DESC, (test like '\''%OOM%'\'') DESC, (test like '\''%Signal 9%'\'') DESC, (test like '\''%Fatal message%'\'') DESC, rowNumberInAllBlocks() LIMIT 1' + '[' -s /test_output/check_status.tsv ']' + echo -e 'success\tNo errors found' + collect_core_dumps + find . -type f -maxdepth 1 -name 'core.*' + read core