++ rg -v '#' /usr/share/zoneinfo/zone.tab ++ awk '{print $3}' ++ shuf ++ head -n1 + TZ=Australia/Melbourne + echo 'Choosen random timezone Australia/Melbourne' + ln -snf /usr/share/zoneinfo/Australia/Melbourne /etc/localtime Choosen random timezone Australia/Melbourne + echo Australia/Melbourne + dpkg -i package_folder/clickhouse-common-static_23.8.16.41.altinitystable+asan_amd64.deb Selecting previously unselected package clickhouse-common-static. (Reading database ... 58319 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static_23.8.16.41.altinitystable+asan_amd64.deb ... Unpacking clickhouse-common-static (23.8.16.41.altinitystable+asan) ... Setting up clickhouse-common-static (23.8.16.41.altinitystable+asan) ... + dpkg -i package_folder/clickhouse-common-static-dbg_23.8.16.41.altinitystable+asan_amd64.deb Selecting previously unselected package clickhouse-common-static-dbg. (Reading database ... 58333 files and directories currently installed.) Preparing to unpack .../clickhouse-common-static-dbg_23.8.16.41.altinitystable+asan_amd64.deb ... Unpacking clickhouse-common-static-dbg (23.8.16.41.altinitystable+asan) ... Setting up clickhouse-common-static-dbg (23.8.16.41.altinitystable+asan) ... + dpkg -i package_folder/clickhouse-server_23.8.16.41.altinitystable+asan_amd64.deb Selecting previously unselected package clickhouse-server. (Reading database ... 58342 files and directories currently installed.) Preparing to unpack .../clickhouse-server_23.8.16.41.altinitystable+asan_amd64.deb ... Unpacking clickhouse-server (23.8.16.41.altinitystable+asan) ... Setting up clickhouse-server (23.8.16.41.altinitystable+asan) ... 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. Symlink /usr/bin/clickhouse-keeper-converter already exists but it points to /clickhouse. Will replace the old symlink to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-keeper-converter to /usr/bin/clickhouse. Creating symlink /usr/bin/clickhouse-disks to /usr/bin/clickhouse. Creating clickhouse group if it does not exist. groupadd -r clickhouse Creating clickhouse user if it does not exist. useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse clickhouse Will set ulimits for clickhouse user in /etc/security/limits.d/clickhouse.conf. Creating config directory /etc/clickhouse-server/config.d that is used for tweaks of main server configuration. Creating config directory /etc/clickhouse-server/users.d that is used for tweaks of users configuration. Config file /etc/clickhouse-server/config.xml already exists, will keep it and extract path info from it. /etc/clickhouse-server/config.xml has /var/lib/clickhouse/ as data path. /etc/clickhouse-server/config.xml has /var/log/clickhouse-server/ as log path. Users config file /etc/clickhouse-server/users.xml already exists, will keep it and extract users info from it. Log directory /var/log/clickhouse-server/ already exists. Creating data directory /var/lib/clickhouse/. Creating pid directory /var/run/clickhouse-server. chown -R clickhouse:clickhouse '/var/log/clickhouse-server/' chown -R clickhouse:clickhouse '/var/run/clickhouse-server' chown clickhouse:clickhouse '/var/lib/clickhouse/' groupadd -r clickhouse-bridge useradd -r --shell /bin/false --home-dir /nonexistent -g clickhouse-bridge clickhouse-bridge chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-odbc-bridge' chown -R clickhouse-bridge:clickhouse-bridge '/usr/bin/clickhouse-library-bridge' Password for default user is empty string. See /etc/clickhouse-server/users.xml and /etc/clickhouse-server/users.d to change it. Setting capabilities for clickhouse binary. This is optional. chown -R clickhouse:clickhouse '/etc/clickhouse-server' ClickHouse has been successfully installed. Start clickhouse-server with: sudo clickhouse start Start clickhouse-client with: clickhouse-client + dpkg -i package_folder/clickhouse-client_23.8.16.41.altinitystable+asan_amd64.deb Selecting previously unselected package clickhouse-client. (Reading database ... 58361 files and directories currently installed.) Preparing to unpack .../clickhouse-client_23.8.16.41.altinitystable+asan_amd64.deb ... Unpacking clickhouse-client (23.8.16.41.altinitystable+asan) ... Setting up clickhouse-client (23.8.16.41.altinitystable+asan) ... + 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 Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server + 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/ + mkdir -p /etc/clickhouse-server/users.d/ + mkdir -p /etc/clickhouse-client + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disks.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/metadata_cache.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/reverse_dns_query_function.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/ + '[' /etc/clickhouse-server = /etc/clickhouse-server ']' + ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/ + ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/ + ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/ + ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/ + [[ -n '' ]] + 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=0 + sed --follow-symlinks -i 's|true|0|' /etc/clickhouse-server/config.d/keeper_port.xml + [[ -n '' ]] + [[ -n '' ]] + [[ -n '' ]] + ARM=aarch64 ++ uname -m + OS=x86_64 + [[ -n 1 ]] + echo x86_64 + [[ '' -eq 1 ]] + [[ x86_64 == \a\a\r\c\h\6\4 ]] + echo 'Adding azure configuration' + ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/ x86_64 Adding azure configuration + ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/ + ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/ + [[ -n '' ]] + ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml + ./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') + ./minio server --address :11111 ./minio_data + local params + curl --silent --verbose http://localhost:11111 + grep AccessDenied + [[ 0 == \6\0 ]] + echo 'trying to connect to minio' + sleep 1 trying to connect to minio Azurite Blob service is starting on 0.0.0.0:10000 Azurite Blob service successfully listens on http://0.0.0.0:10000 API: http://172.17.0.2:11111 http://127.0.0.1:11111 Console: http://172.17.0.2:33189 http://127.0.0.1:33189 Documentation: https://docs.min.io WARNING: Console endpoint is listening on a dynamic port (33189), please use --console-address ":PORT" to choose a static port. 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./17F802A19BF3B7E5ecfa3302-df4a-40b1-8f1e-f520bdc2d919 + lsof -i :11111 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME minio 231 root 10u IPv6 60521 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 + config_logs_export_cluster /etc/clickhouse-server/config.d/system_logs_export.yaml + set +x File /tmp/export-logs-config.sh does not exist, do not setup + start + [[ -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 = 346. The process with pid = 346 is already running. + sleep 0.5 + counter=2 + clickhouse-client --query 'SELECT 1' 127.0.0.1 - - [23/Sep/2024:23:15:58 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 - 127.0.0.1 - - [23/Sep/2024:23:15:58 +0000] "PUT /devstoreaccount1/cont/cgpednsizasvzinxwertbcnevulprzjf?blockid=fbtrkguvvrgdzxadqvjdcszozvirkndbuogzhbnwkosropkzxhnnfprlgnaifaiy&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [23/Sep/2024:23:15:58 +0000] "PUT /devstoreaccount1/cont/cgpednsizasvzinxwertbcnevulprzjf?comp=blocklist HTTP/1.1" 201 - 127.0.0.1 - - [23/Sep/2024:23:15:58 +0000] "GET /devstoreaccount1/cont/cgpednsizasvzinxwertbcnevulprzjf HTTP/1.1" 206 4 127.0.0.1 - - [23/Sep/2024:23:15:58 +0000] "GET /devstoreaccount1/cont/cgpednsizasvzinxwertbcnevulprzjf HTTP/1.1" 206 2 127.0.0.1 - - [23/Sep/2024:23:15:58 +0000] "DELETE /devstoreaccount1/cont/cgpednsizasvzinxwertbcnevulprzjf HTTP/1.1" 202 - 1 + setup_logs_replication + set +x File /tmp/export-logs-config.sh does not exist, do not setup + /s3downloader --url-prefix https://s3.amazonaws.com/clickhouse-datasets --dataset-names hits visits INFO:root:Will fetch following datasets: hits, visits INFO:root:Processing hits INFO:root:Downloading from https://s3.amazonaws.com/clickhouse-datasets/hits/partitions/hits_v1.tar to temp path /tmp/_8oy3q0b INFO:root:Content length is 1271623680 bytes INFO:root:Downloading finished INFO:root:Will unpack data from temp path /tmp/_8oy3q0b to clickhouse db /var/lib/clickhouse/ INFO:root:Unpack finished INFO:root:Will remove downloaded file /tmp/_8oy3q0b 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/hehvi1_x INFO:root:Content length is 563968000 bytes INFO:root:Downloading finished INFO:root:Will unpack data from temp path /tmp/hehvi1_x to clickhouse db /var/lib/clickhouse/ INFO:root:Unpack finished INFO:root:Will remove downloaded file /tmp/hehvi1_x 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 = 346. The process with pid = 346 is running. Sent terminate signal to process with pid 346. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 346. The process with pid = 346 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 127.0.0.1 - - [23/Sep/2024:23:16:34 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 - 127.0.0.1 - - [23/Sep/2024:23:16:34 +0000] "PUT /devstoreaccount1/cont/dwtknauaappuxekeslwnihxyjdubnyrv?blockid=nodbzqozcehieexepjohqmpvirbpdtveguhfismoxqvscqtnyhykuwxkxjrxoepd&comp=block HTTP/1.1" 201 - 127.0.0.1 - - [23/Sep/2024:23:16:34 +0000] "PUT /devstoreaccount1/cont/dwtknauaappuxekeslwnihxyjdubnyrv?comp=blocklist HTTP/1.1" 201 - + for _ in {1..120} + clickhouse-client --query 'SELECT 1' 127.0.0.1 - - [23/Sep/2024:23:16:34 +0000] "GET /devstoreaccount1/cont/dwtknauaappuxekeslwnihxyjdubnyrv HTTP/1.1" 206 4 127.0.0.1 - - [23/Sep/2024:23:16:34 +0000] "GET /devstoreaccount1/cont/dwtknauaappuxekeslwnihxyjdubnyrv HTTP/1.1" 206 2 127.0.0.1 - - [23/Sep/2024:23:16:34 +0000] "DELETE /devstoreaccount1/cont/dwtknauaappuxekeslwnihxyjdubnyrv HTTP/1.1" 202 - Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR) + sleep 1 + 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-09-24 09:18:02 Using queries from '/usr/share/clickhouse-test/queries' directory 2024-09-24 09:18:02 Connecting to ClickHouse server... OK 2024-09-24 09:18:02 Won't run stateless tests because they were manually disabled. 2024-09-24 09:18:02 Found 126 parallel tests and 5 sequential tests 2024-09-24 09:18:02 2024-09-24 09:18:02 Running about 63 stateful tests (ForkPoolWorker-2). 2024-09-24 09:18:02 2024-09-24 09:18:02 00176_distinct_limit_by_limit_bug_43377: [ OK ] 0.57 sec. 2024-09-24 09:18:03 00176_bson_parallel_parsing: [ SKIPPED ] 0.00 sec. - disabled 2024-09-24 09:18:06 2024-09-24 09:18:06 Running about 63 stateful tests (ForkPoolWorker-3). 2024-09-24 09:18:06 2024-09-24 09:18:06 00177_memory_bound_merging: [ OK ] 4.12 sec. 2024-09-24 09:18:06 00175_obfuscator_schema_inference: [ OK ] 3.42 sec. 2024-09-24 09:18:07 00175_counting_resources_in_subqueries: [ OK ] 0.80 sec. 2024-09-24 09:18:09 00174_distinct_in_order: [ OK ] 2.41 sec. 2024-09-24 09:18:10 00173_group_by_use_nulls: [ OK ] 2.96 sec. 2024-09-24 09:18:11 00172_early_constant_folding: [ OK ] 0.40 sec. 2024-09-24 09:18:17 00171_grouping_aggregated_transform_bug: [ OK ] 6.51 sec. 2024-09-24 09:18:34 00172_hits_joins: [ OK ] 25.62 sec. 2024-09-24 09:18:35 00169_contingency: [ OK ] 17.48 sec. 2024-09-24 09:18:53 00167_parallel_parsing_with_names_and_types: [ OK ] 18.14 sec. 2024-09-24 09:18:53 00167_read_bytes_from_fs: [ OK ] 18.11 sec. 2024-09-24 09:18:53 00166_explain_estimate: [ OK ] 0.42 sec. 2024-09-24 09:18:57 00164_quantileBfloat16: [ OK ] 3.79 sec. 2024-09-24 09:18:59 00165_jit_aggregate_functions: [ OK ] 5.51 sec. 2024-09-24 09:19:06 00163_column_oriented_formats: [ OK ] 8.83 sec. 2024-09-24 09:19:07 00162_mmap_compression_none: [ OK ] 8.63 sec. 2024-09-24 09:19:10 00160_decode_xml_component: [ OK ] 2.85 sec. 2024-09-24 09:19:14 00161_parallel_parsing_with_names: [ OK ] 8.12 sec. 2024-09-24 09:19:23 00159_parallel_formatting_http: [ OK ] 12.80 sec. 2024-09-24 09:19:57 00159_parallel_formatting_tsv_and_friends: [ OK ] 33.35 sec. 2024-09-24 09:20:18 00159_parallel_formatting_json_and_friends: [ OK ] 63.82 sec. 2024-09-24 09:20:22 00159_parallel_formatting_csv_and_friends: [ OK ] 24.78 sec. 2024-09-24 09:20:23 00154_avro: [ OK ] 1.17 sec. 2024-09-24 09:20:23 00156_max_execution_speed_sample_merge: [ OK ] 4.58 sec. 2024-09-24 09:20:24 00151_order_by_read_in_order: [ OK ] 0.91 sec. 2024-09-24 09:20:25 00153_aggregate_arena_race: [ OK ] 1.67 sec. 2024-09-24 09:20:25 00150_quantiles_timing_precision: [ OK ] 0.81 sec. 2024-09-24 09:20:31 00149_quantiles_timing_distributed: [ OK ] 6.43 sec. 2024-09-24 09:20:32 00148_monotonic_functions_and_index: [ OK ] 7.16 sec. 2024-09-24 09:20:35 00147_global_in_aggregate_function: [ OK ] 4.01 sec. 2024-09-24 09:20:38 00146_aggregate_function_uniq: [ OK ] 4.99 sec. 2024-09-24 09:20:38 00145_aggregate_functions_statistics: [ OK ] 2.04 sec. 2024-09-24 09:20:38 00144_functions_of_aggregation_states: [ OK ] 0.77 sec. 2024-09-24 09:20:39 00143_transform_non_const_default: [ OK ] 0.95 sec. 2024-09-24 09:20:39 00142_system_columns: [ OK ] 0.34 sec. 2024-09-24 09:20:39 00141_transform: [ OK ] 0.39 sec. 2024-09-24 09:20:40 00097_constexpr_in_index: [ OK ] 0.42 sec. 2024-09-24 09:20:43 00096_obfuscator_save_load: [ OK ] 3.07 sec. 2024-09-24 09:20:44 00139_like: [ OK ] 5.30 sec. 2024-09-24 09:20:47 00094_order_by_array_join_limit: [ OK ] 2.85 sec. 2024-09-24 09:20:48 00095_hyperscan_profiler: [ OK ] 5.11 sec. 2024-09-24 09:20:51 00093_prewhere_array_join: [ OK ] 3.05 sec. 2024-09-24 09:20:52 00092_obfuscator: [ OK ] 3.51 sec. 2024-09-24 09:21:11 00091_prewhere_two_conditions: [ OK ] 20.48 sec. 2024-09-24 09:21:14 00090_thread_pool_deadlock: [ OK ] 22.22 sec. 2024-09-24 09:21:17 00088_global_in_one_shard_and_rows_before_limit: [ FAIL ] 2.29 sec. - return code: 241 2024-09-24 09:21:17 [aa08eedc8d2f] 2024.09.24 09:21:16.771636 [ 1776 ] {c36c4a19-9cf3-42ab-b35b-e940cc9f181d} executeQuery: Code: 241. DB::Exception: Memory limit (total) exceeded: would use 27.72 GiB (attempt to allocate chunk of 1114397 bytes), maximum: 27.55 GiB. OvercommitTracker decision: Memory overcommit has freed not enough memory.: (while reading column UserID): (while reading from part /var/lib/clickhouse/store/5f5/5f55316c-8657-4e60-b714-e6ae3b6e5743/201403_10_18_2/ in table test.hits (5f55316c-8657-4e60-b714-e6ae3b6e5743) located on disk default of type local, from mark 0 with max_rows_to_read = 19001): While executing MergeTreeThread. (MEMORY_LIMIT_EXCEEDED) (version 23.8.16.41.altinitystable (altinity build)) (from [::1]:54706) (comment: 00088_global_in_one_shard_and_rows_before_limit.sql) (in query: SELECT EventDate, count() FROM remote('127.0.0.1', test.hits) WHERE UserID GLOBAL IN (SELECT UserID FROM test.hits) GROUP BY EventDate ORDER BY EventDate LIMIT 5 FORMAT JSONCompact;), Stack trace (when copying this message, always include the lines below): 2024-09-24 09:21:17 2024-09-24 09:21:17 0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:134: Poco::Exception::Exception(String const&, int) @ 0x000000003e077d33 in /usr/bin/clickhouse 2024-09-24 09:21:17 1. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001d5c5dd0 in /usr/bin/clickhouse 2024-09-24 09:21:17 2. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception>>(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type, std::type_identity::type, std::type_identity::type, std::type_identity::type, std::type_identity>>::type>, char const*&&, char const*&&, String&&, long&, String&&, char const*&&, std::basic_string_view>&&) @ 0x000000001d60ab71 in /usr/bin/clickhouse 2024-09-24 09:21:17 3. ./build_docker/./src/Common/MemoryTracker.cpp:340: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000001d608239 in /usr/bin/clickhouse 2024-09-24 09:21:17 4. ./build_docker/./src/Common/MemoryTracker.cpp:0: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000001d607bf4 in /usr/bin/clickhouse 2024-09-24 09:21:17 5. ./build_docker/./src/Common/MemoryTracker.cpp:0: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000001d607bf4 in /usr/bin/clickhouse 2024-09-24 09:21:17 6. ./build_docker/./src/Common/MemoryTracker.cpp:0: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000001d607bf4 in /usr/bin/clickhouse 2024-09-24 09:21:17 7. ./build_docker/./src/Common/CurrentMemoryTracker.cpp:59: CurrentMemoryTracker::alloc(long) @ 0x000000001d534f9d in /usr/bin/clickhouse 2024-09-24 09:21:17 8. ./build_docker/./src/Common/Allocator.h:102: Allocator::alloc(unsigned long, unsigned long) @ 0x000000001d52966f in /usr/bin/clickhouse 2024-09-24 09:21:17 9. void DB::PODArrayBase<8ul, 4096ul, Allocator, 63ul, 64ul>::resize<>(unsigned long) @ 0x000000000bd861c5 in /usr/bin/clickhouse 2024-09-24 09:21:17 10. ./build_docker/./src/Common/PODArray.h:321: DB::SerializationNumber::deserializeBinaryBulk(DB::IColumn&, DB::ReadBuffer&, unsigned long, double) const @ 0x000000002f211566 in /usr/bin/clickhouse 2024-09-24 09:21:17 11. ./build_docker/./src/DataTypes/Serializations/ISerialization.cpp:0: DB::ISerialization::deserializeBinaryBulkWithMultipleStreams(COW::immutable_ptr&, unsigned long, DB::ISerialization::DeserializeBinaryBulkSettings&, std::shared_ptr&, std::unordered_map::immutable_ptr, std::hash, std::equal_to, std::allocator::immutable_ptr>>>*) const @ 0x000000002f1387fe in /usr/bin/clickhouse 2024-09-24 09:21:17 12. ./build_docker/./contrib/boost/boost/smart_ptr/intrusive_ptr.hpp:196: DB::MergeTreeReaderWide::readData(DB::NameAndTypePair const&, std::shared_ptr const&, COW::immutable_ptr&, unsigned long, bool, unsigned long, unsigned long, std::unordered_map::immutable_ptr, std::hash, std::equal_to, std::allocator::immutable_ptr>>>&, bool) @ 0x000000003443c4ea in /usr/bin/clickhouse 2024-09-24 09:21:17 13. ./build_docker/./src/Storages/MergeTree/MergeTreeReaderWide.cpp:159: DB::MergeTreeReaderWide::readRows(unsigned long, unsigned long, bool, unsigned long, std::vector::immutable_ptr, std::allocator::immutable_ptr>>&) @ 0x000000003443ae0c in /usr/bin/clickhouse 2024-09-24 09:21:17 14. ./build_docker/./src/Storages/MergeTree/MergeTreeRangeReader.cpp:107: DB::MergeTreeRangeReader::DelayedStream::finalize(std::vector::immutable_ptr, std::allocator::immutable_ptr>>&) @ 0x0000000034481a8b in /usr/bin/clickhouse 2024-09-24 09:21:17 15. ./build_docker/./src/Storages/MergeTree/MergeTreeRangeReader.cpp:0: DB::MergeTreeRangeReader::startReadingChain(unsigned long, DB::MarkRanges&) @ 0x000000003449f7ea in /usr/bin/clickhouse 2024-09-24 09:21:17 16. ./build_docker/./src/Storages/MergeTree/MergeTreeRangeReader.cpp:0: DB::MergeTreeRangeReader::read(unsigned long, DB::MarkRanges&) @ 0x000000003449a2a1 in /usr/bin/clickhouse 2024-09-24 09:21:17 17. ./build_docker/./src/Storages/MergeTree/MergeTreeBaseSelectProcessor.cpp:398: DB::IMergeTreeSelectAlgorithm::readFromPartImpl() @ 0x0000000034475d99 in /usr/bin/clickhouse 2024-09-24 09:21:17 18. ./build_docker/./src/Storages/MergeTree/MergeTreeBaseSelectProcessor.cpp:441: DB::IMergeTreeSelectAlgorithm::readFromPart() @ 0x00000000344775c4 in /usr/bin/clickhouse 2024-09-24 09:21:17 19. ./build_docker/./src/Storages/MergeTree/MergeTreeBaseSelectProcessor.cpp:0: DB::IMergeTreeSelectAlgorithm::read() @ 0x000000003446fc60 in /usr/bin/clickhouse 2024-09-24 09:21:17 20. ./build_docker/./src/Storages/MergeTree/MergeTreeSource.cpp:181: DB::MergeTreeSource::tryGenerate() @ 0x0000000035d28b78 in /usr/bin/clickhouse 2024-09-24 09:21:17 21. ./build_docker/./contrib/llvm-project/libcxx/include/optional:344: DB::ISource::work() @ 0x0000000034fcc465 in /usr/bin/clickhouse 2024-09-24 09:21:17 22. ./build_docker/./src/Processors/Executors/ExecutionThreadContext.cpp:0: DB::ExecutionThreadContext::executeTask() @ 0x0000000035012b2e in /usr/bin/clickhouse 2024-09-24 09:21:17 23. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:251: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x0000000034ff53dc in /usr/bin/clickhouse 2024-09-24 09:21:17 24. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:359: void std::__function::__policy_invoker::__call_impl>(std::__function::__policy_storage const*) @ 0x0000000034ff8262 in /usr/bin/clickhouse 2024-09-24 09:21:17 25. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl>::worker(std::__list_iterator, void*>) @ 0x000000001d8a9b9c in /usr/bin/clickhouse 2024-09-24 09:21:17 26. ./build_docker/./src/Common/ThreadPool.h:243: ThreadFromGlobalPoolImpl::ThreadFromGlobalPoolImpl>::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>(void&&)::'lambda'()::operator()() @ 0x000000001d8b4000 in /usr/bin/clickhouse 2024-09-24 09:21:17 27. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl::worker(std::__list_iterator) @ 0x000000001d8a0692 in /usr/bin/clickhouse 2024-09-24 09:21:17 28. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x000000001d8ae96d in /usr/bin/clickhouse 2024-09-24 09:21:17 29. ? @ 0x00007f9fadd0cac3 in ? 2024-09-24 09:21:17 30. ? @ 0x00007f9fadd9da04 in ? 2024-09-24 09:21:17 2024-09-24 09:21:17 Received exception from server (version 23.8.16): 2024-09-24 09:21:17 Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (total) exceeded: would use 27.72 GiB (attempt to allocate chunk of 1114397 bytes), maximum: 27.55 GiB. OvercommitTracker decision: Memory overcommit has freed not enough memory.: (while reading column UserID): (while reading from part /var/lib/clickhouse/store/5f5/5f55316c-8657-4e60-b714-e6ae3b6e5743/201403_10_18_2/ in table test.hits (5f55316c-8657-4e60-b714-e6ae3b6e5743) located on disk default of type local, from mark 0 with max_rows_to_read = 19001): While executing MergeTreeThread. (MEMORY_LIMIT_EXCEEDED) 2024-09-24 09:21:17 (query: SELECT EventDate, count() FROM remote('127.0.0.1', test.hits) WHERE UserID GLOBAL IN (SELECT UserID FROM test.hits) GROUP BY EventDate ORDER BY EventDate LIMIT 5 FORMAT JSONCompact;) 2024-09-24 09:21:17 , result: 2024-09-24 09:21:17 2024-09-24 09:21:17 { 2024-09-24 09:21:17 "meta": 2024-09-24 09:21:17 [ 2024-09-24 09:21:17 { 2024-09-24 09:21:17 "name": "EventDate", 2024-09-24 09:21:17 "type": "Date" 2024-09-24 09:21:17 }, 2024-09-24 09:21:17 { 2024-09-24 09:21:17 "name": "count()", 2024-09-24 09:21:17 "type": "UInt64" 2024-09-24 09:21:17 } 2024-09-24 09:21:17 ], 2024-09-24 09:21:17 2024-09-24 09:21:17 "data": 2024-09-24 09:21:17 [ 2024-09-24 09:21:17 2024-09-24 09:21:17 ], 2024-09-24 09:21:17 2024-09-24 09:21:17 "rows": 0 2024-09-24 09:21:17 } 2024-09-24 09:21:17 2024-09-24 09:21:17 stdout: 2024-09-24 09:21:17 { 2024-09-24 09:21:17 "meta": 2024-09-24 09:21:17 [ 2024-09-24 09:21:17 { 2024-09-24 09:21:17 "name": "EventDate", 2024-09-24 09:21:17 "type": "Date" 2024-09-24 09:21:17 }, 2024-09-24 09:21:17 { 2024-09-24 09:21:17 "name": "count()", 2024-09-24 09:21:17 "type": "UInt64" 2024-09-24 09:21:17 } 2024-09-24 09:21:17 ], 2024-09-24 09:21:17 2024-09-24 09:21:17 "data": 2024-09-24 09:21:17 [ 2024-09-24 09:21:17 2024-09-24 09:21:17 ], 2024-09-24 09:21:17 2024-09-24 09:21:17 "rows": 0 2024-09-24 09:21:17 } 2024-09-24 09:21:17 2024-09-24 09:21:17 2024-09-24 09:21:17 Settings used in the test: --max_insert_threads 15 --group_by_two_level_threshold 297654 --group_by_two_level_threshold_bytes 1 --distributed_aggregation_memory_efficient 0 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 6421804 --max_read_buffer_size 617210 --prefer_localhost_replica 0 --max_block_size 19001 --max_threads 13 --optimize_or_like_chain 0 --optimize_read_in_order 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 67 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 44251245 --min_compress_block_size 619213 --max_compress_block_size 466766 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method pread_threadpool --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 12 --optimize_distinct_in_order 1 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 5812125 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 0 --session_timezone Australia/Melbourne 2024-09-24 09:21:17 2024-09-24 09:21:17 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 30212458 --merge_max_block_size 21020 --index_granularity 65047 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 82739 --primary_key_compress_block_size 13953 2024-09-24 09:21:17 2024-09-24 09:21:17 Database: test_pctw3i74 2024-09-24 09:21:17 00089_position_functions_with_non_constant_arg: [ FAIL ] 6.16 sec. - return code: 241 2024-09-24 09:21:17 [aa08eedc8d2f] 2024.09.24 01:21:17.277583 [ 1778 ] {af48bfb0-7942-4f3a-a580-43d97bbe94c3} executeQuery: Code: 241. DB::Exception: Memory limit (total) exceeded: would use 27.55 GiB (attempt to allocate chunk of 2883584 bytes), maximum: 27.55 GiB. OvercommitTracker decision: Memory overcommit has freed not enough memory.: (while reading column URL): (while reading from part /var/lib/clickhouse/store/5f5/5f55316c-8657-4e60-b714-e6ae3b6e5743/201403_10_18_2/ in table test.hits (5f55316c-8657-4e60-b714-e6ae3b6e5743) located on disk default of type local, from mark 40 with max_rows_to_read = 8192): While executing MergeTreeThread. (MEMORY_LIMIT_EXCEEDED) (version 23.8.16.41.altinitystable (altinity build)) (from [::1]:54676) (comment: 00089_position_functions_with_non_constant_arg.sql) (in query: SELECT count() FROM test.hits WHERE position(URL, 'metrika') != position(URL, materialize('metrika'));), Stack trace (when copying this message, always include the lines below): 2024-09-24 09:21:17 2024-09-24 09:21:17 0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:134: Poco::Exception::Exception(String const&, int) @ 0x000000003e077d33 in /usr/bin/clickhouse 2024-09-24 09:21:17 1. ./build_docker/./src/Common/Exception.cpp:98: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001d5c5dd0 in /usr/bin/clickhouse 2024-09-24 09:21:17 2. ./build_docker/./contrib/llvm-project/libcxx/include/string:1499: DB::Exception::Exception>>(int, FormatStringHelperImpl::type, std::type_identity::type, std::type_identity::type, std::type_identity::type, std::type_identity::type, std::type_identity::type, std::type_identity>>::type>, char const*&&, char const*&&, String&&, long&, String&&, char const*&&, std::basic_string_view>&&) @ 0x000000001d60ab71 in /usr/bin/clickhouse 2024-09-24 09:21:17 3. ./build_docker/./src/Common/MemoryTracker.cpp:340: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000001d608239 in /usr/bin/clickhouse 2024-09-24 09:21:17 4. ./build_docker/./src/Common/MemoryTracker.cpp:0: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000001d607bf4 in /usr/bin/clickhouse 2024-09-24 09:21:17 5. ./build_docker/./src/Common/MemoryTracker.cpp:0: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000001d607bf4 in /usr/bin/clickhouse 2024-09-24 09:21:17 6. ./build_docker/./src/Common/MemoryTracker.cpp:0: MemoryTracker::allocImpl(long, bool, MemoryTracker*, double) @ 0x000000001d607bf4 in /usr/bin/clickhouse 2024-09-24 09:21:17 7. ./build_docker/./src/Common/CurrentMemoryTracker.cpp:59: CurrentMemoryTracker::alloc(long) @ 0x000000001d534f9d in /usr/bin/clickhouse 2024-09-24 09:21:17 8. ./build_docker/./src/Common/Allocator.h:0: Allocator::realloc(void*, unsigned long, unsigned long, unsigned long) @ 0x000000001d52b2c7 in /usr/bin/clickhouse 2024-09-24 09:21:17 9. void DB::PODArrayBase<1ul, 4096ul, Allocator, 63ul, 64ul>::resize<>(unsigned long) @ 0x000000000bdbee29 in /usr/bin/clickhouse 2024-09-24 09:21:17 10. ./build_docker/./src/DataTypes/Serializations/SerializationString.cpp:176: void DB::deserializeBinarySSE2<4>(DB::PODArray, 63ul, 64ul>&, DB::PODArray, 63ul, 64ul>&, DB::ReadBuffer&, unsigned long) @ 0x000000002f275ec4 in /usr/bin/clickhouse 2024-09-24 09:21:17 11. ./build_docker/./src/DataTypes/Serializations/SerializationString.cpp:0: DB::SerializationString::deserializeBinaryBulk(DB::IColumn&, DB::ReadBuffer&, unsigned long, double) const @ 0x000000002f274736 in /usr/bin/clickhouse 2024-09-24 09:21:17 12. ./build_docker/./src/DataTypes/Serializations/ISerialization.cpp:0: DB::ISerialization::deserializeBinaryBulkWithMultipleStreams(COW::immutable_ptr&, unsigned long, DB::ISerialization::DeserializeBinaryBulkSettings&, std::shared_ptr&, std::unordered_map::immutable_ptr, std::hash, std::equal_to, std::allocator::immutable_ptr>>>*) const @ 0x000000002f1387fe in /usr/bin/clickhouse 2024-09-24 09:21:17 13. ./build_docker/./contrib/boost/boost/smart_ptr/intrusive_ptr.hpp:196: DB::MergeTreeReaderWide::readData(DB::NameAndTypePair const&, std::shared_ptr const&, COW::immutable_ptr&, unsigned long, bool, unsigned long, unsigned long, std::unordered_map::immutable_ptr, std::hash, std::equal_to, std::allocator::immutable_ptr>>>&, bool) @ 0x000000003443c4ea in /usr/bin/clickhouse 2024-09-24 09:21:17 14. ./build_docker/./src/Storages/MergeTree/MergeTreeReaderWide.cpp:159: DB::MergeTreeReaderWide::readRows(unsigned long, unsigned long, bool, unsigned long, std::vector::immutable_ptr, std::allocator::immutable_ptr>>&) @ 0x000000003443ae0c in /usr/bin/clickhouse 2024-09-24 09:21:17 15. ./build_docker/./src/Storages/MergeTree/MergeTreeRangeReader.cpp:107: DB::MergeTreeRangeReader::DelayedStream::finalize(std::vector::immutable_ptr, std::allocator::immutable_ptr>>&) @ 0x0000000034481a8b in /usr/bin/clickhouse 2024-09-24 09:21:17 16. ./build_docker/./src/Storages/MergeTree/MergeTreeRangeReader.cpp:0: DB::MergeTreeRangeReader::startReadingChain(unsigned long, DB::MarkRanges&) @ 0x000000003449f7ea in /usr/bin/clickhouse 2024-09-24 09:21:17 17. ./build_docker/./src/Storages/MergeTree/MergeTreeRangeReader.cpp:0: DB::MergeTreeRangeReader::read(unsigned long, DB::MarkRanges&) @ 0x000000003449a2a1 in /usr/bin/clickhouse 2024-09-24 09:21:17 18. ./build_docker/./src/Storages/MergeTree/MergeTreeBaseSelectProcessor.cpp:398: DB::IMergeTreeSelectAlgorithm::readFromPartImpl() @ 0x0000000034475d99 in /usr/bin/clickhouse 2024-09-24 09:21:17 19. ./build_docker/./src/Storages/MergeTree/MergeTreeBaseSelectProcessor.cpp:441: DB::IMergeTreeSelectAlgorithm::readFromPart() @ 0x00000000344775c4 in /usr/bin/clickhouse 2024-09-24 09:21:17 20. ./build_docker/./src/Storages/MergeTree/MergeTreeBaseSelectProcessor.cpp:0: DB::IMergeTreeSelectAlgorithm::read() @ 0x000000003446fc60 in /usr/bin/clickhouse 2024-09-24 09:21:17 21. ./build_docker/./src/Storages/MergeTree/MergeTreeSource.cpp:181: DB::MergeTreeSource::tryGenerate() @ 0x0000000035d28b78 in /usr/bin/clickhouse 2024-09-24 09:21:17 22. ./build_docker/./contrib/llvm-project/libcxx/include/optional:344: DB::ISource::work() @ 0x0000000034fcc465 in /usr/bin/clickhouse 2024-09-24 09:21:17 23. ./build_docker/./src/Processors/Executors/ExecutionThreadContext.cpp:0: DB::ExecutionThreadContext::executeTask() @ 0x0000000035012b2e in /usr/bin/clickhouse 2024-09-24 09:21:17 24. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:251: DB::PipelineExecutor::executeStepImpl(unsigned long, std::atomic*) @ 0x0000000034ff53dc in /usr/bin/clickhouse 2024-09-24 09:21:17 25. ./build_docker/./src/Processors/Executors/PipelineExecutor.cpp:359: void std::__function::__policy_invoker::__call_impl>(std::__function::__policy_storage const*) @ 0x0000000034ff8262 in /usr/bin/clickhouse 2024-09-24 09:21:17 26. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl>::worker(std::__list_iterator, void*>) @ 0x000000001d8a9b9c in /usr/bin/clickhouse 2024-09-24 09:21:17 27. ./build_docker/./src/Common/ThreadPool.h:243: ThreadFromGlobalPoolImpl::ThreadFromGlobalPoolImpl>::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>(void&&)::'lambda'()::operator()() @ 0x000000001d8b4000 in /usr/bin/clickhouse 2024-09-24 09:21:17 28. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl::worker(std::__list_iterator) @ 0x000000001d8a0692 in /usr/bin/clickhouse 2024-09-24 09:21:17 29. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: void* std::__thread_proxy[abi:v15000]>, void ThreadPoolImpl::scheduleImpl(std::function, Priority, std::optional, bool)::'lambda0'()>>(void*) @ 0x000000001d8ae96d in /usr/bin/clickhouse 2024-09-24 09:21:17 30. ? @ 0x00007f9fadd0cac3 in ? 2024-09-24 09:21:17 31. ? @ 0x00007f9fadd9da04 in ? 2024-09-24 09:21:17 2024-09-24 09:21:17 Received exception from server (version 23.8.16): 2024-09-24 09:21:17 Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: Memory limit (total) exceeded: would use 27.55 GiB (attempt to allocate chunk of 2883584 bytes), maximum: 27.55 GiB. OvercommitTracker decision: Memory overcommit has freed not enough memory.: (while reading column URL): (while reading from part /var/lib/clickhouse/store/5f5/5f55316c-8657-4e60-b714-e6ae3b6e5743/201403_10_18_2/ in table test.hits (5f55316c-8657-4e60-b714-e6ae3b6e5743) located on disk default of type local, from mark 40 with max_rows_to_read = 8192): While executing MergeTreeThread. (MEMORY_LIMIT_EXCEEDED) 2024-09-24 09:21:17 (query: SELECT count() FROM test.hits WHERE position(URL, 'metrika') != position(URL, materialize('metrika'));) 2024-09-24 09:21:17 , result: 2024-09-24 09:21:17 2024-09-24 09:21:17 2024-09-24 09:21:17 2024-09-24 09:21:17 stdout: 2024-09-24 09:21:17 2024-09-24 09:21:17 2024-09-24 09:21:17 Settings used in the test: --max_insert_threads 0 --group_by_two_level_threshold 445204 --group_by_two_level_threshold_bytes 50000000 --distributed_aggregation_memory_efficient 1 --fsync_metadata 1 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 122533 --max_read_buffer_size 649041 --prefer_localhost_replica 1 --max_block_size 93275 --max_threads 49 --optimize_or_like_chain 1 --optimize_read_in_order 0 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 24 --optimize_aggregation_in_order 1 --aggregation_in_order_max_block_bytes 40812772 --min_compress_block_size 167392 --max_compress_block_size 2626849 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 8288923630 --local_filesystem_read_method pread --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 128Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 1 --compile_sort_description 1 --merge_tree_coarse_index_granularity 31 --optimize_distinct_in_order 1 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 2986268 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone Africa/Juba 2024-09-24 09:21:17 2024-09-24 09:21:17 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 9034322353 --vertical_merge_algorithm_min_rows_to_activate 1 --vertical_merge_algorithm_min_columns_to_activate 100 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 1 --index_granularity_bytes 15445134 --merge_max_block_size 10065 --index_granularity 4360 --min_bytes_for_wide_part 0 --marks_compress_block_size 78997 --primary_key_compress_block_size 87978 2024-09-24 09:21:17 2024-09-24 09:21:17 Database: test_hytmakd2 2024-09-24 09:21:18 00087_where_0: [ OK ] 0.51 sec. 2024-09-24 09:21:20 00085_monotonic_evaluation_segfault: [ OK ] 1.06 sec. 2024-09-24 09:21:22 00086_array_reduce: [ OK ] 3.89 sec. 2024-09-24 09:21:24 00083_array_filter: [ OK ] 1.74 sec. 2024-09-24 09:21:31 00082_quantiles: [ OK ] 6.85 sec. 2024-09-24 09:21:32 00081_group_by_without_key_and_totals: [ OK ] 0.66 sec. 2024-09-24 09:21:33 00080_array_join_and_union: [ OK ] 0.39 sec. 2024-09-24 09:21:34 00079_array_join_not_used_joined_column: [ OK ] 1.08 sec. 2024-09-24 09:21:37 00078_group_by_arrays: [ OK ] 2.97 sec. 2024-09-24 09:21:42 00084_external_aggregation: [ OK ] 21.57 sec. 2024-09-24 09:21:42 00077_log_tinylog_stripelog: [ OK ] 5.10 sec. 2024-09-24 09:21:42 00076_system_columns_bytes: [ OK ] 0.35 sec. 2024-09-24 09:21:43 00075_left_array_join: [ OK ] 0.61 sec. 2024-09-24 09:21:43 00073_uniq_array: [ OK ] 0.40 sec. 2024-09-24 09:21:44 00074_full_join: [ OK ] 1.65 sec. 2024-09-24 09:21:49 00071_merge_tree_optimize_aio: [ OK ] 4.75 sec. 2024-09-24 09:21:50 00069_duplicate_aggregation_keys: [ OK ] 0.38 sec. 2024-09-24 09:21:50 00068_subquery_in_prewhere: [ OK ] 0.49 sec. 2024-09-24 09:21:52 00067_union_all: [ OK ] 1.26 sec. 2024-09-24 09:21:52 00066_sorting_distributed_many_replicas: [ OK ] 0.36 sec. 2024-09-24 09:21:52 00072_compare_date_and_string_index: [ OK ] 8.66 sec. 2024-09-24 09:21:53 00065_loyalty_with_storage_join: [ OK ] 1.04 sec. 2024-09-24 09:21:54 00062_loyalty: [ OK ] 0.80 sec. 2024-09-24 09:21:55 00063_loyalty_joins: [ OK ] 2.60 sec. 2024-09-24 09:21:56 00060_move_to_prewhere_and_sets: [ OK ] 0.57 sec. 2024-09-24 09:21:56 00061_storage_buffer: [ OK ] 1.72 sec. 2024-09-24 09:21:56 00059_merge_sorting_empty_array_joined: [ OK ] 0.33 sec. 2024-09-24 09:21:57 00055_index_and_not: [ OK ] 0.49 sec. 2024-09-24 09:21:57 00056_view: [ OK ] 1.01 sec. 2024-09-24 09:21:58 00054_merge_tree_partitions: [ OK ] 0.84 sec. 2024-09-24 09:21:58 00052_group_by_in: [ OK ] 0.35 sec. 2024-09-24 09:22:00 00053_replicate_segfault: [ OK ] 2.94 sec. 2024-09-24 09:22:02 00050_min_max: [ OK ] 1.31 sec. 2024-09-24 09:22:02 00051_min_max_array: [ OK ] 3.55 sec. 2024-09-24 09:22:02 00048_min_max: [ OK ] 0.38 sec. 2024-09-24 09:22:03 00049_max_string_if: [ OK ] 1.41 sec. 2024-09-24 09:22:03 00047_bar: [ OK ] 0.89 sec. 2024-09-24 09:22:04 00046_uniq_upto_distributed: [ OK ] 0.64 sec. 2024-09-24 09:22:04 00045_uniq_upto: [ OK ] 0.57 sec. 2024-09-24 09:22:05 00043_any_left_join: [ OK ] 0.91 sec. 2024-09-24 09:22:06 00042_any_left_join: [ OK ] 0.78 sec. 2024-09-24 09:22:07 00044_any_left_join_string: [ OK ] 2.47 sec. 2024-09-24 09:22:08 00041_aggregating_materialized_view: [ OK ] 1.93 sec. 2024-09-24 09:22:08 00040_aggregating_materialized_view: [ OK ] 1.58 sec. 2024-09-24 09:22:09 00039_primary_key: [ OK ] 0.36 sec. 2024-09-24 09:22:11 00038_uniq_state_merge2: [ OK ] 2.61 sec. 2024-09-24 09:22:12 00036_aggregate_hashed: [ OK ] 0.85 sec. 2024-09-24 09:22:12 00037_uniq_state_merge1: [ OK ] 3.81 sec. 2024-09-24 09:22:13 00035_aggregate_keys128: [ OK ] 0.46 sec. 2024-09-24 09:22:13 00034_aggregate_key_fixed_string: [ OK ] 0.76 sec. 2024-09-24 09:22:14 00033_aggregate_key_string: [ OK ] 0.79 sec. 2024-09-24 09:22:14 00032_aggregate_key64: [ OK ] 0.43 sec. 2024-09-24 09:22:14 00031_array_enumerate_uniq: [ OK ] 0.43 sec. 2024-09-24 09:22:15 00030_array_enumerate_uniq: [ OK ] 1.16 sec. 2024-09-24 09:22:16 00023_totals_limit: [ OK ] 0.35 sec. 2024-09-24 09:22:16 00022_merge_prewhere: [ OK ] 0.44 sec. 2024-09-24 09:22:17 00021_3_select_with_in: [ OK ] 0.34 sec. 2024-09-24 09:22:17 00021_2_select_with_in: [ OK ] 0.33 sec. 2024-09-24 09:22:18 00021_1_select_with_in: [ OK ] 0.34 sec. 2024-09-24 09:22:18 00020_distinct_order_by_distributed: [ OK ] 0.44 sec. 2024-09-24 09:22:19 00017_aggregation_uninitialized_memory: [ OK ] 0.34 sec. 2024-09-24 09:22:20 00016_any_if_distributed_cond_always_false: [ OK ] 0.72 sec. 2024-09-24 09:22:20 00015_totals_and_no_aggregate_functions: [ OK ] 0.33 sec. 2024-09-24 09:22:21 00014_filtering_arrays: [ OK ] 0.47 sec. 2024-09-24 09:22:21 00013_sorting_of_nested: [ OK ] 0.71 sec. 2024-09-24 09:22:22 00012_sorting_distributed: [ OK ] 0.57 sec. 2024-09-24 09:22:23 00011_sorting: [ OK ] 0.44 sec. 2024-09-24 09:22:23 00010_quantiles_segfault: [ OK ] 0.68 sec. 2024-09-24 09:22:25 00009_uniq_distributed: [ OK ] 1.15 sec. 2024-09-24 09:22:26 00008_uniq: [ OK ] 0.91 sec. 2024-09-24 09:22:26 00007_uniq: [ OK ] 0.34 sec. 2024-09-24 09:22:27 00006_agregates: [ OK ] 0.46 sec. 2024-09-24 09:22:27 00005_filtering: [ OK ] 0.36 sec. 2024-09-24 09:22:28 00004_top_counters: [ OK ] 0.53 sec. 2024-09-24 09:22:28 00002_count_visits: [ OK ] 0.33 sec. 2024-09-24 09:22:29 00001_count_hits: [ OK ] 0.37 sec. 2024-09-24 09:22:29 2024-09-24 09:22:29 Having 1 errors! 72 tests passed. 1 tests skipped. 267.16 s elapsed (ForkPoolWorker-2). 2024-09-24 09:22:43 00024_random_counters: [ OK ] 28.54 sec. 2024-09-24 09:22:43 2024-09-24 09:22:43 Having 1 errors! 51 tests passed. 0 tests skipped. 280.91 s elapsed (ForkPoolWorker-3). 2024-09-24 09:22:43 2024-09-24 09:22:43 Running 5 stateful tests (MainProcess). 2024-09-24 09:22:43 2024-09-24 09:23:15 00170_s3_cache: [ OK ] 32.10 sec. 2024-09-24 09:23:17 00158_cache_dictionary_has: [ OK ] 1.91 sec. 2024-09-24 09:23:26 00157_cache_dictionary: [ OK ] 8.86 sec. 2024-09-24 09:23:28 00152_insert_different_granularity: [ OK ] 1.88 sec. 2024-09-24 09:23:29 00140_rename: [ OK ] 0.55 sec. 2024-09-24 09:23:29 2024-09-24 09:23:29 5 tests passed. 0 tests skipped. 45.82 s elapsed (MainProcess). 2024-09-24 09:23:29 2024-09-24 09:23:29 No queries hung. 2024-09-24 09:23:29 All tests have finished. + set -e + echo 'Files in current directory' + ls -la ./ Files in current directory total 137376 drwxr-xr-x 1 root root 4096 Sep 24 09:16 . drwxr-xr-x 1 root root 4096 Sep 24 09:16 .. -rw-r--r-- 1 root root 1535 Sep 24 09:16 __azurite_db_blob_extent__.json -rw-r--r-- 1 root root 4237 Sep 24 09:16 __azurite_db_blob__.json -rw-r--r-- 1 root root 74957 Sep 24 09:22 azurite_log lrwxrwxrwx 1 root root 7 Sep 12 00:04 bin -> usr/bin drwxr-xr-x 2 root root 4096 Sep 24 09:15 __blobstorage__ drwxr-xr-x 2 root root 4096 Apr 18 2022 boot drwxr-xr-x 5 root root 340 Sep 24 09:14 dev -rwxr-xr-x 1 root root 0 Sep 24 09:14 .dockerenv drwxr-xr-x 1 root root 4096 Sep 24 09:15 etc drwxr-xr-x 10 1000 1000 4096 Jun 15 2021 hadoop-3.3.1 drwxr-xr-x 2 root root 4096 Apr 18 2022 home lrwxrwxrwx 1 root root 7 Sep 12 00:04 lib -> usr/lib lrwxrwxrwx 1 root root 9 Sep 12 00:04 lib32 -> usr/lib32 lrwxrwxrwx 1 root root 9 Sep 12 00:04 lib64 -> usr/lib64 lrwxrwxrwx 1 root root 10 Sep 12 00:04 libx32 -> usr/libx32 -rwxr-xr-x 1 root root 21843968 Jan 6 2022 mc drwxr-xr-x 2 root root 4096 Sep 12 00:04 media -rwxr-xr-x 1 root root 118595584 Jan 4 2022 minio drwxr-xr-x 4 root root 4096 Sep 24 09:15 minio_data drwxr-xr-x 2 root root 4096 Sep 12 00:04 mnt drwxr-xr-x 2 root root 4096 Sep 12 00:04 opt -rw-r--r-- 1 root root 0 Feb 15 2024 .package-cache-mutate drwxrwxr-x 2 1000 1000 4096 Sep 24 09:14 package_folder dr-xr-xr-x 305 root root 0 Sep 24 09:14 proc -rwxrwxr-x 1 root root 7989 Sep 24 06:39 process_functional_tests_result.py drwx------ 1 root root 4096 Sep 24 09:15 root drwxr-xr-x 1 root root 4096 Sep 24 09:15 run -rwxrwxr-x 1 root root 11600 Sep 24 06:39 run.sh -rwxrwxr-x 1 root root 4302 Sep 24 06:39 s3downloader lrwxrwxrwx 1 root root 8 Sep 12 00:04 sbin -> usr/sbin -rwxrwxr-x 1 root root 6870 Sep 24 06:39 setup_export_logs.sh -rwxrwxr-x 1 root root 351 Sep 24 06:39 setup_hdfs_minicluster.sh -rwxrwxr-x 1 root root 3465 Sep 24 06:39 setup_minio.sh drwxr-xr-x 2 root root 4096 Sep 12 00:04 srv dr-xr-xr-x 13 root root 0 Sep 24 09:14 sys drwxrwxr-x 2 1000 1000 4096 Sep 24 09:18 test_output drwxrwxrwt 1 root root 4096 Sep 24 09:23 tmp drwxr-xr-x 1 root root 4096 Sep 12 00:04 usr drwxr-xr-x 1 root root 4096 Sep 12 00:07 var Files in root directory + echo 'Files in root directory' + ls -la / total 137376 drwxr-xr-x 1 root root 4096 Sep 24 09:16 . drwxr-xr-x 1 root root 4096 Sep 24 09:16 .. -rw-r--r-- 1 root root 1535 Sep 24 09:16 __azurite_db_blob_extent__.json -rw-r--r-- 1 root root 4237 Sep 24 09:16 __azurite_db_blob__.json -rw-r--r-- 1 root root 74957 Sep 24 09:22 azurite_log lrwxrwxrwx 1 root root 7 Sep 12 00:04 bin -> usr/bin drwxr-xr-x 2 root root 4096 Sep 24 09:15 __blobstorage__ drwxr-xr-x 2 root root 4096 Apr 18 2022 boot drwxr-xr-x 5 root root 340 Sep 24 09:14 dev -rwxr-xr-x 1 root root 0 Sep 24 09:14 .dockerenv drwxr-xr-x 1 root root 4096 Sep 24 09:15 etc drwxr-xr-x 10 1000 1000 4096 Jun 15 2021 hadoop-3.3.1 drwxr-xr-x 2 root root 4096 Apr 18 2022 home lrwxrwxrwx 1 root root 7 Sep 12 00:04 lib -> usr/lib lrwxrwxrwx 1 root root 9 Sep 12 00:04 lib32 -> usr/lib32 lrwxrwxrwx 1 root root 9 Sep 12 00:04 lib64 -> usr/lib64 lrwxrwxrwx 1 root root 10 Sep 12 00:04 libx32 -> usr/libx32 -rwxr-xr-x 1 root root 21843968 Jan 6 2022 mc drwxr-xr-x 2 root root 4096 Sep 12 00:04 media -rwxr-xr-x 1 root root 118595584 Jan 4 2022 minio drwxr-xr-x 4 root root 4096 Sep 24 09:15 minio_data drwxr-xr-x 2 root root 4096 Sep 12 00:04 mnt drwxr-xr-x 2 root root 4096 Sep 12 00:04 opt -rw-r--r-- 1 root root 0 Feb 15 2024 .package-cache-mutate drwxrwxr-x 2 1000 1000 4096 Sep 24 09:14 package_folder dr-xr-xr-x 305 root root 0 Sep 24 09:14 proc -rwxrwxr-x 1 root root 7989 Sep 24 06:39 process_functional_tests_result.py drwx------ 1 root root 4096 Sep 24 09:15 root drwxr-xr-x 1 root root 4096 Sep 24 09:15 run -rwxrwxr-x 1 root root 11600 Sep 24 06:39 run.sh -rwxrwxr-x 1 root root 4302 Sep 24 06:39 s3downloader lrwxrwxrwx 1 root root 8 Sep 12 00:04 sbin -> usr/sbin -rwxrwxr-x 1 root root 6870 Sep 24 06:39 setup_export_logs.sh -rwxrwxr-x 1 root root 351 Sep 24 06:39 setup_hdfs_minicluster.sh -rwxrwxr-x 1 root root 3465 Sep 24 06:39 setup_minio.sh drwxr-xr-x 2 root root 4096 Sep 12 00:04 srv dr-xr-xr-x 13 root root 0 Sep 24 09:14 sys drwxrwxr-x 2 1000 1000 4096 Sep 24 09:18 test_output drwxrwxrwt 1 root root 4096 Sep 24 09:23 tmp drwxr-xr-x 1 root root 4096 Sep 12 00:04 usr drwxr-xr-x 1 root root 4096 Sep 12 00:07 var + /process_functional_tests_result.py 2024-09-24 09:23:29,446 Find files in result folder run.log,test_result.txt 2024-09-24 09:23:29,448 Is flaky check: False 2024-09-24 09:23:29,448 Result parsed 2024-09-24 09:23:29,448 Result written + sudo clickhouse stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 744. The process with pid = 744 is running. Sent terminate signal to process with pid 744. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 744. The process with pid = 744 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 744. The process with pid = 744 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 744. The process with pid = 744 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 744. The process with pid = 744 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 744. The process with pid = 744 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 744. The process with pid = 744 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 744. The process with pid = 744 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 744. The process with pid = 744 is running. Waiting for server to stop /var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 744. The process with pid = 744 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 '' ]]