++ rg -v '#' /usr/share/zoneinfo/zone.tab ++ awk '{print $3}' ++ shuf ++ head -n1 + TZ=Africa/Nairobi + echo 'Choosen random timezone Africa/Nairobi' + ln -snf /usr/share/zoneinfo/Africa/Nairobi /etc/localtime Choosen random timezone Africa/Nairobi + echo Africa/Nairobi + dpkg -i package_folder/clickhouse-common-static_23.3.19.33.altinitystable+msan_amd64.deb Selecting previously unselected package clickhouse-common-static. (Reading database ... 53515 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static_23.3.19.33.altinitystable+msan_amd64.deb ... Unpacking clickhouse-common-static (23.3.19.33.altinitystable+msan) ... Setting up clickhouse-common-static (23.3.19.33.altinitystable+msan) ... + dpkg -i package_folder/clickhouse-common-static-dbg_23.3.19.33.altinitystable+msan_amd64.deb Selecting previously unselected package clickhouse-common-static-dbg. (Reading database ... 53529 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static-dbg_23.3.19.33.altinitystable+msan_amd64.deb ... Unpacking clickhouse-common-static-dbg (23.3.19.33.altinitystable+msan) ... Setting up clickhouse-common-static-dbg (23.3.19.33.altinitystable+msan) ... + dpkg -i package_folder/clickhouse-server_23.3.19.33.altinitystable+msan_amd64.deb Selecting previously unselected package clickhouse-server. (Reading database ... 53538 files and directories currently installed.) Preparing to unpack .../clickhouse-server_23.3.19.33.altinitystable+msan_amd64.deb ... Unpacking clickhouse-server (23.3.19.33.altinitystable+msan) ... Setting up clickhouse-server (23.3.19.33.altinitystable+msan) ... Cannot set 'net_admin' or 'ipc_lock' or 'sys_nice' or 'net_bind_service' capability for clickhouse binary. This is optional. Taskstats accounting will be disabled. To enable taskstats accounting you may add the required capability later manually. ClickHouse binary is already located at /usr/bin/clickhouse Symlink /usr/bin/clickhouse-server already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-server to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-client to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-local to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-benchmark to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-copier already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-copier to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-obfuscator to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-git-import to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-compressor to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-format to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-extract-from-config already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-extract-from-config to /usr/bin/clickhouse. Symlink /usr/bin/clickhouse-keeper already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper-converter to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-disks to /usr/bin/clickhouse. Creating clickhouse group if it does not exist. groupadd -r clickhouse Creating clickhouse user if it does not exist. useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse clickhouse Will set ulimits for clickhouse user in /etc/security/limits.d/clickhouse.conf. Creating config directory /etc/clickhouse-server/config.d that is used for tweaks of main server configuration. Creating config directory /etc/clickhouse-server/users.d that is used for tweaks of users configuration. Config file /etc/clickhouse-server/config.xml already exists, will keep it and extract path info from it. /etc/clickhouse-server/config.xml has /var/lib/clickhouse/ as data path. /etc/clickhouse-server/config.xml has /var/log/clickhouse-server/ as log path. Users config file /etc/clickhouse-server/users.xml already exists, will keep it and extract users info from it. Log directory /var/log/clickhouse-server/ already exists. Creating data directory /var/lib/clickhouse/. Creating pid directory /var/run/clickhouse-server. chown -R clickhouse:clickhouse '/var/log/clickhouse-server/' chown -R clickhouse:clickhouse '/var/run/clickhouse-server' chown clickhouse:clickhouse '/var/lib/clickhouse/' groupadd -r clickhouse-bridge useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse-bridge clickhouse-bridge chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-odbc-bridge' chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-library-bridge' Password for default user is empty string. See /etc/clickhouse-server/users.xml and /etc/clickhouse-server/users.d to change it. Setting capabilities for clickhouse binary. This is optional. chown -R clickhouse:clickhouse '/etc/clickhouse-server' ClickHouse has been successfully installed. Start clickhouse-server with: sudo clickhouse start Start clickhouse-client with: clickhouse-client Processing triggers for systemd (245.4-4ubuntu3.23) ... + dpkg -i package_folder/clickhouse-client_23.3.19.33.altinitystable+msan_amd64.deb Selecting previously unselected package clickhouse-client. (Reading database ... 53552 files and directories currently installed.) Preparing to unpack .../clickhouse-client_23.3.19.33.altinitystable+msan_amd64.deb ... Unpacking clickhouse-client (23.3.19.33.altinitystable+msan) ... Setting up clickhouse-client (23.3.19.33.altinitystable+msan) ... + ln -s /usr/share/clickhouse-test/clickhouse-test /usr/bin/clickhouse-test + /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 '' ]] + rm -f /etc/clickhouse-server/config.d/zookeeper_fault_injection.xml + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper.xml /etc/clickhouse-server/config.d/ + create_snapshot_on_exit=1 + sed --follow-symlinks -i 's|true|1|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n '' ]] + [[ -n '' ]] + ARM=aarch64 ++ uname -m + OS=x86_64 x86_64 Adding azure configuration + [[ -n 1 ]] + echo x86_64 + [[ '' -eq 1 ]] + [[ x86_64 == \a\a\r\c\h\6\4 ]] + echo 'Adding azure configuration' + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml + ./setup_minio.sh stateful + 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 stateful + local query_dir ++ check_arg stateful ++ local query_dir ++ '[' '!' 1 -eq 1 ']' ++ case "$1" in ++ query_dir=1_stateful ++ echo 1_stateful + query_dir=1_stateful + '[' '!' -f ./minio ']' + start_minio + mkdir -p ./minio_data + ./minio --version 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 API: http://172.17.0.2:11111 http://127.0.0.1:11111 Console: http://172.17.0.2:41471 http://127.0.0.1:41471 Documentation: https://docs.min.io WARNING: Console endpoint is listening on a dynamic port (41471), please use --console-address ":PORT" to choose a static port. Azurite Blob service is starting on 0.0.0.0:10000 Azurite Blob service successfully listens on http://0.0.0.0:10000 You are running an older version of MinIO released 2 years ago Update: Run `mc admin update` + counter=1 + curl --silent --verbose http://localhost:11111 + grep AccessDenied AccessDeniedAccess Denied./17B9E5C74D8D5A6F082a5d1c-4f18-4fba-8ade-31017a823b2c + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 217 root 9u IPv6 49253 0t0 TCP *:11111 (LISTEN) + sleep 5 + setup_minio stateful + local test_type=stateful + ./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`. + '[' stateful = stateless ']' + upload_data 1_stateful /usr/share/clickhouse-test + local query_dir=1_stateful + local test_path=/usr/share/clickhouse-test + local data_path=/usr/share/clickhouse-test/queries/1_stateful/data_minio ++ ls /usr/share/clickhouse-test/queries/1_stateful/data_minio ls: cannot access '/usr/share/clickhouse-test/queries/1_stateful/data_minio': No such file or directory + setup_aws_credentials + local minio_root_user=clickhouse + local minio_root_password=clickhouse + mkdir -p /root/.aws + cat + start + [[ -n '' ]] + counter=0 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 0 -gt 120 ']' + timeout 120 service clickhouse-server start chown -R clickhouse: '/var/run/clickhouse-server/' Will run sudo --preserve-env -u 'clickhouse' /usr/bin/clickhouse-server --config-file /etc/clickhouse-server/config.xml --pid-file /var/run/clickhouse-server/clickhouse-server.pid --daemon Waiting for server to start Waiting for server to start Server started + sleep 0.5 + counter=1 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 1 -gt 120 ']' + timeout 120 service clickhouse-server start /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is already running. + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 2 -gt 120 ']' + timeout 120 service clickhouse-server start /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is already running. + sleep 0.5 + counter=3 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 3 -gt 120 ']' + timeout 120 service clickhouse-server start /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is already running. + sleep 0.5 + counter=4 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 4 -gt 120 ']' + timeout 120 service clickhouse-server start /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is already running. + sleep 0.5 + counter=5 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 5 -gt 120 ']' + timeout 120 service clickhouse-server start /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is already running. + sleep 0.5 + counter=6 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 6 -gt 120 ']' + timeout 120 service clickhouse-server start /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is already running. + sleep 0.5 + counter=7 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 7 -gt 120 ']' + timeout 120 service clickhouse-server start /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is already running. + sleep 0.5 + counter=8 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 8 -gt 120 ']' + timeout 120 service clickhouse-server start /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is already running. + sleep 0.5 + counter=9 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 9 -gt 120 ']' + timeout 120 service clickhouse-server start /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is already running. + sleep 0.5 + counter=10 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 10 -gt 120 ']' + timeout 120 service clickhouse-server start /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is already running. + sleep 0.5 + counter=11 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 11 -gt 120 ']' + timeout 120 service clickhouse-server start /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is already running. + sleep 0.5 + counter=12 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 12 -gt 120 ']' + timeout 120 service clickhouse-server start /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is already running. + sleep 0.5 + counter=13 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 13 -gt 120 ']' + timeout 120 service clickhouse-server start /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is already running. + sleep 0.5 + counter=14 + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + '[' 14 -gt 120 ']' + timeout 120 service clickhouse-server start /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is already running. + sleep 0.5 127.0.0.1 - - [05/Mar/2024:14:49:57 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [05/Mar/2024:14:49:57 +0000] "PUT /devstoreaccount1/cont/pjpzeajylktlbxenrnpncncqzlfsozbx?blockid=wfeprxerrcradgcohpqjabawmfdbghisvpuesxrutkojequpwsiuxzeazkgcvimv&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [05/Mar/2024:14:49:57 +0000] "PUT /devstoreaccount1/cont/pjpzeajylktlbxenrnpncncqzlfsozbx?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [05/Mar/2024:14:49:57 +0000] "GET /devstoreaccount1/cont/pjpzeajylktlbxenrnpncncqzlfsozbx HTTP/1.1" 206 4 127.0.0.1 - - [05/Mar/2024:14:49:57 +0000] "GET /devstoreaccount1/cont/pjpzeajylktlbxenrnpncncqzlfsozbx HTTP/1.1" 206 2 127.0.0.1 - - [05/Mar/2024:14:49:57 +0000] "DELETE /devstoreaccount1/cont/pjpzeajylktlbxenrnpncncqzlfsozbx HTTP/1.1" 202 - + counter=15 + clickhouse-client --query 'SELECT 1' 1 + /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/b1m8g_ji INFO:root:Content length is 1271623680 bytes INFO:root:Downloading finished INFO:root:Will unpack data from temp path /tmp/b1m8g_ji to clickhouse db /var/lib/clickhouse/ INFO:root:Unpack finished INFO:root:Will remove downloaded file /tmp/b1m8g_ji 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/8msr7k1z INFO:root:Content length is 563968000 bytes INFO:root:Downloading finished INFO:root:Will unpack data from temp path /tmp/8msr7k1z to clickhouse db /var/lib/clickhouse/ INFO:root:Unpack finished INFO:root:Will remove downloaded file /tmp/8msr7k1z 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 'SHOW DATABASES' INFORMATION_SCHEMA default information_schema system + clickhouse-client --query 'ATTACH DATABASE datasets ENGINE = Ordinary' + service clickhouse-server restart /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is running. Sent terminate signal to process with pid 336. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 336. The process with pid = 336 is running. Waiting for server to stop Found pid = 336 in the list of running processes. The process with pid = 336 is running. Waiting for server to stop Now there is no clickhouse-server process. Server stopped chown -R clickhouse: '/var/run/clickhouse-server/' Will run sudo --preserve-env -u 'clickhouse' /usr/bin/clickhouse-server --config-file /etc/clickhouse-server/config.xml --pid-file /var/run/clickhouse-server/clickhouse-server.pid --daemon Waiting for server to start Waiting for server to start Server started + for _ in {1..120} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 + for _ in {1..120} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 + for _ in {1..120} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 + for _ in {1..120} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 + for _ in {1..120} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 + for _ in {1..120} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 + for _ in {1..120} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 + for _ in {1..120} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 + for _ in {1..120} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 + for _ in {1..120} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 + for _ in {1..120} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 + for _ in {1..120} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 127.0.0.1 - - [05/Mar/2024:14:50:41 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - + for _ in {1..120} + clickhouse-client --query 'SELECT 1' Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 127.0.0.1 - - [05/Mar/2024:14:50:42 +0000] "PUT /devstoreaccount1/cont/dblpcyjdcwvrlmczocrqpzjyyascascv?blockid=sempyrbfxfmepubvdclpwzzyjmlpxykeqjujjkmajbsgdzmslojxcbodkdkuuxee&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [05/Mar/2024:14:50:42 +0000] "PUT /devstoreaccount1/cont/dblpcyjdcwvrlmczocrqpzjyyascascv?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [05/Mar/2024:14:50:42 +0000] "GET /devstoreaccount1/cont/dblpcyjdcwvrlmczocrqpzjyyascascv HTTP/1.1" 206 4 127.0.0.1 - - [05/Mar/2024:14:50:42 +0000] "GET /devstoreaccount1/cont/dblpcyjdcwvrlmczocrqpzjyyascascv HTTP/1.1" 206 2 127.0.0.1 - - [05/Mar/2024:14:50:42 +0000] "DELETE /devstoreaccount1/cont/dblpcyjdcwvrlmczocrqpzjyyascascv HTTP/1.1" 202 - + for _ in {1..120} + clickhouse-client --query 'SELECT 1' 1 + break + clickhouse-client --query 'SHOW TABLES FROM datasets' hits_v1 visits_v1 + [[ -n '' ]] + clickhouse-client --query 'CREATE DATABASE test' + clickhouse-client --query 'SHOW TABLES FROM test' + clickhouse-client --query 'RENAME TABLE datasets.hits_v1 TO test.hits' + clickhouse-client --query 'RENAME TABLE datasets.visits_v1 TO test.visits' + 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 'INSERT INTO test.hits_s3 SELECT * FROM test.hits SETTINGS enable_filesystem_cache_on_write_operations=0' + clickhouse-client --query 'SHOW TABLES FROM test' hits hits_s3 visits + clickhouse-client --query 'SELECT count() FROM test.hits' 8873898 + clickhouse-client --query 'SELECT count() FROM test.visits' 1676861 + export -f run_tests + timeout 3240 bash -c run_tests + read -ra ADDITIONAL_OPTIONS + [[ -n '' ]] + [[ -n '' ]] + set +e + [[ -n '' ]] + clickhouse-test -j 2 --testname --shard --zookeeper --check-zookeeper-session --no-stateless --hung-check --print-time --hung-check --print-time '' + ts '%Y-%m-%d %H:%M:%S' + tee test_output/test_result.txt 2024-03-05 17:54:11 Using queries from '/usr/share/clickhouse-test/queries' directory 2024-03-05 17:54:11 Connecting to ClickHouse server... OK 2024-03-05 17:54:12 Won't run stateless tests because they were manually disabled. 2024-03-05 17:54:12 Found 128 parallel tests and 5 sequential tests 2024-03-05 17:54:12 2024-03-05 17:54:12 Running about 64 stateful tests (ForkPoolWorker-2). 2024-03-05 17:54:12 2024-03-05 17:54:12 00178_query_datetime64_index: [ OK ] 0.65 sec. 2024-03-05 17:54:14 00176_distinct_limit_by_limit_bug_43377: [ OK ] 1.64 sec. 2024-03-05 17:54:14 00176_bson_parallel_parsing: [ SKIPPED ] 0.00 sec. - disabled 2024-03-05 17:54:18 2024-03-05 17:54:18 Running about 64 stateful tests (ForkPoolWorker-3). 2024-03-05 17:54:18 2024-03-05 17:54:18 00177_memory_bound_merging: [ OK ] 6.69 sec. 2024-03-05 17:54:19 00175_partition_by_ignore: [ OK ] 0.77 sec. 2024-03-05 17:54:20 00175_obfuscator_schema_inference: [ OK ] 6.22 sec. 2024-03-05 17:54:22 00175_counting_resources_in_subqueries: [ OK ] 3.01 sec. 2024-03-05 17:54:28 00174_distinct_in_order: [ OK ] 7.77 sec. 2024-03-05 17:54:31 00173_group_by_use_nulls: [ OK ] 8.82 sec. 2024-03-05 17:54:33 00172_early_constant_folding: [ OK ] 1.64 sec. 2024-03-05 17:54:47 00171_grouping_aggregated_transform_bug: [ OK ] 14.00 sec. 2024-03-05 17:55:40 00169_contingency: [ OK ] 53.75 sec. 2024-03-05 17:55:41 00172_hits_joins: [ OK ] 73.24 sec. 2024-03-05 17:56:12 00167_parallel_parsing_with_names_and_types: [ OK ] 31.34 sec. 2024-03-05 17:56:14 00166_explain_estimate: [ OK ] 1.69 sec. 2024-03-05 17:56:22 00167_read_bytes_from_fs: [ OK ] 40.59 sec. 2024-03-05 17:56:27 00165_jit_aggregate_functions: [ OK ] 13.31 sec. 2024-03-05 17:56:34 00164_quantileBfloat16: [ OK ] 11.80 sec. 2024-03-05 17:56:43 00163_column_oriented_formats: [ OK ] 15.83 sec. 2024-03-05 17:56:48 00162_mmap_compression_none: [ OK ] 14.50 sec. 2024-03-05 17:56:54 00160_decode_xml_component: [ OK ] 5.84 sec. 2024-03-05 17:56:57 00161_parallel_parsing_with_names: [ OK ] 14.53 sec. 2024-03-05 17:57:25 00159_parallel_formatting_http: [ OK ] 30.46 sec. 2024-03-05 17:58:44 00159_parallel_formatting_tsv_and_friends: [ OK ] 79.10 sec. 2024-03-05 17:59:39 00159_parallel_formatting_json_and_friends: [ OK ] 161.92 sec. 2024-03-05 17:59:40 00159_parallel_formatting_csv_and_friends: [ OK ] 55.93 sec. 2024-03-05 17:59:43 00154_avro: [ OK ] 3.46 sec. 2024-03-05 17:59:44 00156_max_execution_speed_sample_merge: [ OK ] 5.03 sec. 2024-03-05 17:59:45 00151_order_by_read_in_order: [ OK ] 0.97 sec. 2024-03-05 17:59:47 00150_quantiles_timing_precision: [ OK ] 1.96 sec. 2024-03-05 18:00:01 00149_quantiles_timing_distributed: [ OK ] 13.73 sec. 2024-03-05 18:00:02 00153_aggregate_arena_race: [ OK ] 18.97 sec. 2024-03-05 18:00:07 00148_monotonic_functions_and_index: [ OK ] 5.55 sec. 2024-03-05 18:00:12 00147_global_in_aggregate_function: [ OK ] 9.68 sec. 2024-03-05 18:00:17 00145_aggregate_functions_statistics: [ OK ] 4.70 sec. 2024-03-05 18:00:18 00144_functions_of_aggregation_states: [ OK ] 1.41 sec. 2024-03-05 18:00:19 00143_transform_non_const_default: [ OK ] 1.40 sec. 2024-03-05 18:00:20 00142_system_columns: [ OK ] 0.70 sec. 2024-03-05 18:00:21 00141_transform: [ OK ] 1.11 sec. 2024-03-05 18:00:22 00146_aggregate_function_uniq: [ OK ] 15.29 sec. 2024-03-05 18:00:23 00097_constexpr_in_index: [ OK ] 0.86 sec. 2024-03-05 18:00:28 00096_obfuscator_save_load: [ OK ] 4.93 sec. 2024-03-05 18:00:40 00095_hyperscan_profiler: [ OK ] 12.16 sec. 2024-03-05 18:00:40 00139_like: [ OK ] 18.93 sec. 2024-03-05 18:00:47 00093_prewhere_array_join: [ OK ] 7.10 sec. 2024-03-05 18:00:48 00094_order_by_array_join_limit: [ OK ] 7.78 sec. 2024-03-05 18:00:53 00092_obfuscator: [ OK ] 5.89 sec. 2024-03-05 18:01:09 00091_prewhere_two_conditions: [ OK ] 20.91 sec. 2024-03-05 18:01:18 00090_thread_pool_deadlock: [ OK ] 24.75 sec. 2024-03-05 18:01:20 00088_global_in_one_shard_and_rows_before_limit: [ OK ] 2.02 sec. 2024-03-05 18:01:21 00087_where_0: [ OK ] 0.86 sec. 2024-03-05 18:01:27 00086_array_reduce: [ OK ] 5.54 sec. 2024-03-05 18:01:27 00085_monotonic_evaluation_segfault: [ OK ] 0.84 sec. 2024-03-05 18:01:57 00089_position_functions_with_non_constant_arg: [ OK ] 47.79 sec. 2024-03-05 18:01:59 00083_array_filter: [ OK ] 2.05 sec. 2024-03-05 18:02:20 00082_quantiles: [ OK ] 21.72 sec. 2024-03-05 18:02:22 00081_group_by_without_key_and_totals: [ OK ] 1.42 sec. 2024-03-05 18:02:23 00080_array_join_and_union: [ OK ] 0.74 sec. 2024-03-05 18:02:25 00079_array_join_not_used_joined_column: [ OK ] 2.29 sec. 2024-03-05 18:02:37 00078_group_by_arrays: [ OK ] 11.75 sec. 2024-03-05 18:02:52 00084_external_aggregation: [ OK ] 84.20 sec. 2024-03-05 18:02:52 00076_system_columns_bytes: [ OK ] 0.63 sec. 2024-03-05 18:02:54 00077_log_tinylog_stripelog: [ OK ] 17.01 sec. 2024-03-05 18:02:54 00075_left_array_join: [ OK ] 1.55 sec. 2024-03-05 18:02:55 00073_uniq_array: [ OK ] 0.85 sec. 2024-03-05 18:03:00 00074_full_join: [ OK ] 5.72 sec. 2024-03-05 18:03:07 00072_compare_date_and_string_index: [ OK ] 12.03 sec. 2024-03-05 18:03:08 00069_duplicate_aggregation_keys: [ OK ] 0.72 sec. 2024-03-05 18:03:09 00068_subquery_in_prewhere: [ OK ] 0.87 sec. 2024-03-05 18:03:11 00067_union_all: [ OK ] 2.88 sec. 2024-03-05 18:03:12 00066_sorting_distributed_many_replicas: [ OK ] 0.64 sec. 2024-03-05 18:03:12 00071_merge_tree_optimize_aio: [ OK ] 12.76 sec. 2024-03-05 18:03:17 00065_loyalty_with_storage_join: [ OK ] 4.72 sec. 2024-03-05 18:03:19 00062_loyalty: [ OK ] 2.49 sec. 2024-03-05 18:03:21 00063_loyalty_joins: [ OK ] 8.97 sec. 2024-03-05 18:03:23 00060_move_to_prewhere_and_sets: [ OK ] 1.16 sec. 2024-03-05 18:03:23 00059_merge_sorting_empty_array_joined: [ OK ] 0.61 sec. 2024-03-05 18:03:25 00061_storage_buffer: [ OK ] 5.18 sec. 2024-03-05 18:03:25 00056_view: [ OK ] 1.52 sec. 2024-03-05 18:03:25 00055_index_and_not: [ OK ] 0.65 sec. 2024-03-05 18:03:27 00054_merge_tree_partitions: [ OK ] 1.78 sec. 2024-03-05 18:03:27 00052_group_by_in: [ OK ] 0.61 sec. 2024-03-05 18:03:33 00053_replicate_segfault: [ OK ] 8.04 sec. 2024-03-05 18:03:34 00051_min_max_array: [ OK ] 6.96 sec. 2024-03-05 18:03:35 00050_min_max: [ OK ] 1.99 sec. 2024-03-05 18:03:36 00048_min_max: [ OK ] 0.57 sec. 2024-03-05 18:03:37 00049_max_string_if: [ OK ] 2.36 sec. 2024-03-05 18:03:37 00047_bar: [ OK ] 0.94 sec. 2024-03-05 18:03:38 00046_uniq_upto_distributed: [ OK ] 1.58 sec. 2024-03-05 18:03:38 00045_uniq_upto: [ OK ] 1.20 sec. 2024-03-05 18:03:40 00043_any_left_join: [ OK ] 1.47 sec. 2024-03-05 18:03:41 00042_any_left_join: [ OK ] 1.00 sec. 2024-03-05 18:03:46 00041_aggregating_materialized_view: [ OK ] 4.92 sec. 2024-03-05 18:03:50 00040_aggregating_materialized_view: [ OK ] 4.29 sec. 2024-03-05 18:03:51 00039_primary_key: [ OK ] 0.69 sec. 2024-03-05 18:03:51 00044_any_left_join_string: [ OK ] 12.65 sec. 2024-03-05 18:04:02 00038_uniq_state_merge2: [ OK ] 11.48 sec. 2024-03-05 18:04:02 00037_uniq_state_merge1: [ OK ] 11.48 sec. 2024-03-05 18:04:03 00035_aggregate_keys128: [ OK ] 1.10 sec. 2024-03-05 18:04:05 00034_aggregate_key_fixed_string: [ OK ] 1.48 sec. 2024-03-05 18:04:07 00033_aggregate_key_string: [ OK ] 2.02 sec. 2024-03-05 18:04:08 00032_aggregate_key64: [ OK ] 0.93 sec. 2024-03-05 18:04:09 00031_array_enumerate_uniq: [ OK ] 1.11 sec. 2024-03-05 18:04:11 00030_array_enumerate_uniq: [ OK ] 2.28 sec. 2024-03-05 18:04:12 00036_aggregate_hashed: [ OK ] 9.51 sec. 2024-03-05 18:04:12 00023_totals_limit: [ OK ] 0.65 sec. 2024-03-05 18:04:13 00022_merge_prewhere: [ OK ] 0.79 sec. 2024-03-05 18:04:14 00021_3_select_with_in: [ OK ] 0.66 sec. 2024-03-05 18:04:15 00021_2_select_with_in: [ OK ] 0.61 sec. 2024-03-05 18:04:15 00021_1_select_with_in: [ OK ] 0.59 sec. 2024-03-05 18:04:16 00020_distinct_order_by_distributed: [ OK ] 0.89 sec. 2024-03-05 18:04:17 00017_aggregation_uninitialized_memory: [ OK ] 0.59 sec. 2024-03-05 18:04:19 00016_any_if_distributed_cond_always_false: [ OK ] 2.11 sec. 2024-03-05 18:04:20 00015_totals_and_no_aggregate_functions: [ OK ] 0.80 sec. 2024-03-05 18:04:21 00014_filtering_arrays: [ OK ] 1.05 sec. 2024-03-05 18:04:22 00013_sorting_of_nested: [ OK ] 1.59 sec. 2024-03-05 18:04:23 00012_sorting_distributed: [ OK ] 0.99 sec. 2024-03-05 18:04:24 00011_sorting: [ OK ] 0.83 sec. 2024-03-05 18:04:26 00010_quantiles_segfault: [ OK ] 1.78 sec. 2024-03-05 18:04:28 00009_uniq_distributed: [ OK ] 2.05 sec. 2024-03-05 18:04:30 00008_uniq: [ OK ] 1.51 sec. 2024-03-05 18:04:30 00007_uniq: [ OK ] 0.60 sec. 2024-03-05 18:04:31 00006_agregates: [ OK ] 0.95 sec. 2024-03-05 18:04:32 00005_filtering: [ OK ] 0.60 sec. 2024-03-05 18:04:33 00004_top_counters: [ OK ] 1.26 sec. 2024-03-05 18:04:34 00002_count_visits: [ OK ] 0.60 sec. 2024-03-05 18:04:34 00001_count_hits: [ OK ] 0.54 sec. 2024-03-05 18:04:34 2024-03-05 18:04:34 75 tests passed. 1 tests skipped. 622.96 s elapsed (ForkPoolWorker-2). 2024-03-05 18:05:47 00024_random_counters: [ OK ] 95.20 sec. 2024-03-05 18:05:47 2024-03-05 18:05:47 52 tests passed. 0 tests skipped. 695.08 s elapsed (ForkPoolWorker-3). 2024-03-05 18:05:47 2024-03-05 18:05:47 Running 5 stateful tests (MainProcess). 2024-03-05 18:05:47 2024-03-05 18:06:57 00170_s3_cache: [ OK ] 70.62 sec. 2024-03-05 18:07:02 00158_cache_dictionary_has: [ OK ] 4.93 sec. 2024-03-05 18:07:38 00157_cache_dictionary: [ OK ] 35.90 sec. 2024-03-05 18:07:44 00152_insert_different_granularity: [ OK ] 5.96 sec. 2024-03-05 18:07:46 00140_rename: [ OK ] 1.57 sec. 2024-03-05 18:07:46 2024-03-05 18:07:46 5 tests passed. 0 tests skipped. 119.12 s elapsed (MainProcess). 2024-03-05 18:07:46 2024-03-05 18:07:46 No queries hung. 2024-03-05 18:07:46 All tests have finished. + set -e Files in current directory + echo 'Files in current directory' + ls -la ./ total 137376 drwxr-xr-x 1 root root 4096 Mar 5 17:50 . drwxr-xr-x 1 root root 4096 Mar 5 17:50 .. -rwxr-xr-x 1 root root 0 Mar 5 17:48 .dockerenv -rw-r--r-- 1 root root 4237 Mar 5 17:50 __azurite_db_blob__.json -rw-r--r-- 1 root root 1535 Mar 5 17:50 __azurite_db_blob_extent__.json drwxr-xr-x 2 root root 4096 Mar 5 17:49 __blobstorage__ -rw-r--r-- 1 root root 74832 Mar 5 18:07 azurite_log lrwxrwxrwx 1 root root 7 Jan 23 06:14 bin -> usr/bin drwxr-xr-x 2 root root 4096 Apr 15 2020 boot drwxr-xr-x 5 root root 340 Mar 5 17:48 dev drwxr-xr-x 1 root root 4096 Mar 5 17:49 etc drwxr-xr-x 10 1000 1000 4096 Jun 15 2021 hadoop-3.3.1 drwxr-xr-x 2 root root 4096 Apr 15 2020 home lrwxrwxrwx 1 root root 7 Jan 23 06:14 lib -> usr/lib lrwxrwxrwx 1 root root 9 Jan 23 06:14 lib32 -> usr/lib32 lrwxrwxrwx 1 root root 9 Jan 23 06:14 lib64 -> usr/lib64 lrwxrwxrwx 1 root root 10 Jan 23 06:14 libx32 -> usr/libx32 -rwxr-xr-x 1 root root 21843968 Jan 6 2022 mc drwxr-xr-x 2 root root 4096 Jan 23 06:14 media -rwxr-xr-x 1 root root 118595584 Jan 4 2022 minio drwxr-xr-x 4 root root 4096 Mar 5 17:49 minio_data drwxr-xr-x 2 root root 4096 Jan 23 06:14 mnt drwxr-xr-x 1 root root 4096 Mar 5 16:13 node_modules drwxr-xr-x 2 root root 4096 Jan 23 06:14 opt -rw-r--r-- 1 root root 308 Mar 5 16:11 package-lock.json drwxrwxr-x 2 1000 1000 4096 Mar 5 17:48 package_folder dr-xr-xr-x 310 root root 0 Mar 5 17:48 proc -rwxrwxr-x 1 root root 6652 Feb 21 13:29 process_functional_tests_result.py drwx------ 1 root root 4096 Mar 5 17:49 root drwxr-xr-x 1 root root 4096 Mar 5 17:49 run -rwxrwxr-x 1 root root 11434 Mar 5 16:05 run.sh -rwxrwxr-x 1 root root 4302 Mar 5 16:05 s3downloader lrwxrwxrwx 1 root root 8 Jan 23 06:14 sbin -> usr/sbin -rwxrwxr-x 1 root root 351 Mar 5 16:05 setup_hdfs_minicluster.sh -rwxrwxr-x 1 root root 3465 Mar 5 16:05 setup_minio.sh drwxr-xr-x 2 root root 4096 Jan 23 06:14 srv dr-xr-xr-x 13 root root 0 Mar 5 17:48 sys drwxrwxr-x 2 1000 1000 4096 Mar 5 17:54 test_output drwxrwxrwt 1 root root 4096 Mar 5 18:07 tmp drwxr-xr-x 1 root root 4096 Feb 21 13:30 usr drwxr-xr-x 1 root root 4096 Jan 23 06:18 var Files in root directory + echo 'Files in root directory' + ls -la / total 137376 drwxr-xr-x 1 root root 4096 Mar 5 17:50 . drwxr-xr-x 1 root root 4096 Mar 5 17:50 .. -rwxr-xr-x 1 root root 0 Mar 5 17:48 .dockerenv -rw-r--r-- 1 root root 4237 Mar 5 17:50 __azurite_db_blob__.json -rw-r--r-- 1 root root 1535 Mar 5 17:50 __azurite_db_blob_extent__.json drwxr-xr-x 2 root root 4096 Mar 5 17:49 __blobstorage__ -rw-r--r-- 1 root root 74832 Mar 5 18:07 azurite_log lrwxrwxrwx 1 root root 7 Jan 23 06:14 bin -> usr/bin drwxr-xr-x 2 root root 4096 Apr 15 2020 boot drwxr-xr-x 5 root root 340 Mar 5 17:48 dev drwxr-xr-x 1 root root 4096 Mar 5 17:49 etc drwxr-xr-x 10 1000 1000 4096 Jun 15 2021 hadoop-3.3.1 drwxr-xr-x 2 root root 4096 Apr 15 2020 home lrwxrwxrwx 1 root root 7 Jan 23 06:14 lib -> usr/lib lrwxrwxrwx 1 root root 9 Jan 23 06:14 lib32 -> usr/lib32 lrwxrwxrwx 1 root root 9 Jan 23 06:14 lib64 -> usr/lib64 lrwxrwxrwx 1 root root 10 Jan 23 06:14 libx32 -> usr/libx32 -rwxr-xr-x 1 root root 21843968 Jan 6 2022 mc drwxr-xr-x 2 root root 4096 Jan 23 06:14 media -rwxr-xr-x 1 root root 118595584 Jan 4 2022 minio drwxr-xr-x 4 root root 4096 Mar 5 17:49 minio_data drwxr-xr-x 2 root root 4096 Jan 23 06:14 mnt drwxr-xr-x 1 root root 4096 Mar 5 16:13 node_modules drwxr-xr-x 2 root root 4096 Jan 23 06:14 opt -rw-r--r-- 1 root root 308 Mar 5 16:11 package-lock.json drwxrwxr-x 2 1000 1000 4096 Mar 5 17:48 package_folder dr-xr-xr-x 310 root root 0 Mar 5 17:48 proc -rwxrwxr-x 1 root root 6652 Feb 21 13:29 process_functional_tests_result.py drwx------ 1 root root 4096 Mar 5 17:49 root drwxr-xr-x 1 root root 4096 Mar 5 17:49 run -rwxrwxr-x 1 root root 11434 Mar 5 16:05 run.sh -rwxrwxr-x 1 root root 4302 Mar 5 16:05 s3downloader lrwxrwxrwx 1 root root 8 Jan 23 06:14 sbin -> usr/sbin -rwxrwxr-x 1 root root 351 Mar 5 16:05 setup_hdfs_minicluster.sh -rwxrwxr-x 1 root root 3465 Mar 5 16:05 setup_minio.sh drwxr-xr-x 2 root root 4096 Jan 23 06:14 srv dr-xr-xr-x 13 root root 0 Mar 5 17:48 sys drwxrwxr-x 2 1000 1000 4096 Mar 5 17:54 test_output drwxrwxrwt 1 root root 4096 Mar 5 18:07 tmp drwxr-xr-x 1 root root 4096 Feb 21 13:30 usr drwxr-xr-x 1 root root 4096 Jan 23 06:18 var + /process_functional_tests_result.py 2024-03-05 18:07:46,607 Find files in result folder run.log,test_result.txt 2024-03-05 18:07:46,608 Is flaky check: False 2024-03-05 18:07:46,608 Result parsed 2024-03-05 18:07:46,609 Result written + sudo clickhouse stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 825. The process with pid = 825 is running. Sent terminate signal to process with pid 825. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 825. The process with pid = 825 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 825. The process with pid = 825 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 825. The process with pid = 825 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 825. The process with pid = 825 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 825. The process with pid = 825 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 825. The process with pid = 825 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 825. The process with pid = 825 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 825. The process with pid = 825 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 825. The process with pid = 825 does not exist. Server stopped + [[ -n '' ]] + rg -Fa '' /var/log/clickhouse-server/clickhouse-server.log + : + zstd --threads=0 + rm /var/log/clickhouse-server/clickhouse-server.log + mv /var/log/clickhouse-server/stderr.log /test_output/ + [[ -n '' ]] + [[ -n '' ]]