+ ln -s /usr/share/clickhouse-test/ci/stress.py /usr/bin/stress
+ ln -s /usr/share/clickhouse-test/clickhouse-test /usr/bin/clickhouse-test
+ source /usr/share/clickhouse-test/ci/attach_gdb.lib
++ source /usr/share/clickhouse-test/ci/utils.lib
+ source /usr/share/clickhouse-test/ci/stress_tests.lib
++ sysctl kernel.core_pattern=core.%e.%p-%P
kernel.core_pattern = core.%e.%p-%P
++ OK='\tOK\t\N\t'
++ FAIL='\tFAIL\t\N\t'
++ FAILURE_CONTEXT_LINES=100
++ FAILURE_CONTEXT_MAX_LINE_WIDTH=300
+ install_packages package_folder
+ dpkg -i package_folder/clickhouse-common-static_23.8.11.29.altinitystable+ubsan_amd64.deb
Selecting previously unselected package clickhouse-common-static.
(Reading database ... 58438 files and directories currently installed.)
Preparing to unpack .../clickhouse-common-static_23.8.11.29.altinitystable+ubsan_amd64.deb ...
Unpacking clickhouse-common-static (23.8.11.29.altinitystable+ubsan) ...
Setting up clickhouse-common-static (23.8.11.29.altinitystable+ubsan) ...
+ dpkg -i package_folder/clickhouse-common-static-dbg_23.8.11.29.altinitystable+ubsan_amd64.deb
Selecting previously unselected package clickhouse-common-static-dbg.
(Reading database ... 58452 files and directories currently installed.)
Preparing to unpack .../clickhouse-common-static-dbg_23.8.11.29.altinitystable+ubsan_amd64.deb ...
Unpacking clickhouse-common-static-dbg (23.8.11.29.altinitystable+ubsan) ...
Setting up clickhouse-common-static-dbg (23.8.11.29.altinitystable+ubsan) ...
+ dpkg -i package_folder/clickhouse-server_23.8.11.29.altinitystable+ubsan_amd64.deb
Selecting previously unselected package clickhouse-server.
(Reading database ... 58461 files and directories currently installed.)
Preparing to unpack .../clickhouse-server_23.8.11.29.altinitystable+ubsan_amd64.deb ...
Unpacking clickhouse-server (23.8.11.29.altinitystable+ubsan) ...
Setting up clickhouse-server (23.8.11.29.altinitystable+ubsan) ...
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'
[1mPassword for default user is empty string. See /etc/clickhouse-server/users.xml and /etc/clickhouse-server/users.d to change it.[0m
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.11.29.altinitystable+ubsan_amd64.deb
Selecting previously unselected package clickhouse-client.
(Reading database ... 58480 files and directories currently installed.)
Preparing to unpack .../clickhouse-client_23.8.11.29.altinitystable+ubsan_amd64.deb ...
Unpacking clickhouse-client (23.8.11.29.altinitystable+ubsan) ...
Setting up clickhouse-client (23.8.11.29.altinitystable+ubsan) ...
+ export THREAD_FUZZER_CPU_TIME_PERIOD_US=1000
+ THREAD_FUZZER_CPU_TIME_PERIOD_US=1000
+ export THREAD_FUZZER_SLEEP_PROBABILITY=0.1
+ THREAD_FUZZER_SLEEP_PROBABILITY=0.1
+ export THREAD_FUZZER_SLEEP_TIME_US=100000
+ THREAD_FUZZER_SLEEP_TIME_US=100000
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US=10000
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US=10000
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US=10000
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US=10000
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US=10000
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US=10000
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US=10000
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US=10000
+ export THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01
+ THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01
+ export THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01
+ THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01
+ export ZOOKEEPER_FAULT_INJECTION=1
+ ZOOKEEPER_FAULT_INJECTION=1
+ configure
+ export USE_DATABASE_ORDINARY=1
+ USE_DATABASE_ORDINARY=1
+ export EXPORT_S3_STORAGE_POLICIES=1
+ EXPORT_S3_STORAGE_POLICIES=1
+ /usr/share/clickhouse-test/config/install.sh
+ DEST_SERVER_PATH=/etc/clickhouse-server
+ DEST_CLIENT_PATH=/etc/clickhouse-client
+++ dirname /usr/share/clickhouse-test/config/install.sh
++ cd /usr/share/clickhouse-test/config
++ pwd -P
+ SRC_PATH=/usr/share/clickhouse-test/config
+ echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server'
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 1 ]]
+ [[ 1 -eq 1 ]]
+ rm -f /etc/clickhouse-server/config.d/zookeeper.xml
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/
+ create_snapshot_on_exit=1
+ sed --follow-symlinks -i 's|true|1|' /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n '' ]]
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ARM=aarch64
++ uname -m
+ OS=x86_64
x86_64
+ [[ -n 1 ]]
+ echo x86_64
+ [[ '' -eq 1 ]]
+ [[ x86_64 == \a\a\r\c\h\6\4 ]]
+ echo 'Adding azure configuration'
+ ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/
Adding azure configuration
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|100000|10000|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\'''
+ export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ sudo chown root: /var/lib/clickhouse
+ echo '1'
+ local total_mem
++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo
+ total_mem=32098980
+ total_mem=32869355520
+ max_server_memory_usage_to_ram_ratio=0.5
+ echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5'
+ cat
Setting max_server_memory_usage_to_ram_ratio to 0.5
+ local max_users_mem
+ max_users_mem=9860806656
+ echo 'Setting max_memory_usage_for_user=9860806656 and max_memory_usage for queries to 10G'
+ cat
Setting max_memory_usage_for_user=9860806656 and max_memory_usage for queries to 10G
+ cat
+ cat
+ ./setup_minio.sh stateless
+ azurite-blob --blobHost 0.0.0.0 --blobPort 10000 --debug /azurite_log
+ export MINIO_ROOT_USER=clickhouse
+ MINIO_ROOT_USER=clickhouse
+ export MINIO_ROOT_PASSWORD=clickhouse
+ MINIO_ROOT_PASSWORD=clickhouse
+ main stateless
+ local query_dir
++ check_arg stateless
++ local query_dir
++ '[' '!' 1 -eq 1 ']'
++ case "$1" in
++ query_dir=0_stateless
++ echo 0_stateless
+ query_dir=0_stateless
+ '[' '!' -f ./minio ']'
+ start_minio
+ mkdir -p ./minio_data
+ ./minio --version
Azurite Blob service is starting on 0.0.0.0:10000
Azurite Blob service successfully listens on http://0.0.0.0:10000
minio version RELEASE.2022-01-03T18-22-58Z
+ wait_for_it
+ local counter=0
+ local max_counter=60
+ local url=http://localhost:11111
+ params=('--silent' '--verbose')
+ ./minio server --address :11111 ./minio_data
+ local params
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 0 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=1
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 1 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=2
+ grep AccessDenied
+ curl --silent --verbose http://localhost:11111
trying to connect to minio
+ [[ 2 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
+ counter=3
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
trying to connect to minio
+ [[ 3 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
+ counter=4
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
trying to connect to minio
+ [[ 4 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
+ counter=5
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 5 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=6
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
trying to connect to minio
+ [[ 6 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
+ counter=7
+ grep AccessDenied
+ curl --silent --verbose http://localhost:11111
+ [[ 7 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=8
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 8 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=9
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
trying to connect to minio
+ [[ 9 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
+ counter=10
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
trying to connect to minio
+ [[ 10 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
API: http://172.17.0.2:11111 http://127.0.0.1:11111
Console: http://172.17.0.2:37989 http://127.0.0.1:37989
Documentation: https://docs.min.io
WARNING: Console endpoint is listening on a dynamic port (37989), please use --console-address ":PORT" to choose a static port.
+ counter=11
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
AccessDenied
Access Denied./17CA7E5231F5544C46822fa5-a95d-4274-82e6-f795eb7b3048
+ lsof -i :11111
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
minio 248 root 10u IPv6 25483 0t0 TCP *:11111 (LISTEN)
+ sleep 5
+ setup_minio stateless
+ local test_type=stateless
+ ./mc alias set clickminio http://localhost:11111 clickhouse clickhouse
Added `clickminio` successfully.
+ ./mc admin user add clickminio test testtest
Added user `test` successfully.
+ ./mc admin policy set clickminio readwrite user=test
Policy `readwrite` is set on user `test`
+ ./mc mb clickminio/test
Bucket created successfully `clickminio/test`.
+ '[' stateless = stateless ']'
+ ./mc policy set public clickminio/test
Access permission for `clickminio/test` is set to `public`
+ upload_data 0_stateless /usr/share/clickhouse-test
+ local query_dir=0_stateless
+ local test_path=/usr/share/clickhouse-test
+ local data_path=/usr/share/clickhouse-test/queries/0_stateless/data_minio
++ ls /usr/share/clickhouse-test/queries/0_stateless/data_minio
+ for file in $(ls "${data_path}")
+ echo 02366_data.jsonl
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl clickminio/test/02366_data.jsonl
02366_data.jsonl
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl` -> `clickminio/test/02366_data.jsonl`
Total: 0 B, Transferred: 0 B, Speed: 0 B/s
02731.arrow
+ for file in $(ls "${data_path}")
+ echo 02731.arrow
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow clickminio/test/02731.arrow
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow` -> `clickminio/test/02731.arrow`
Total: 0 B, Transferred: 3.82 MiB, Speed: 128.11 MiB/s
02731.parquet
+ for file in $(ls "${data_path}")
+ echo 02731.parquet
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet clickminio/test/02731.parquet
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.parquet` -> `clickminio/test/02731.parquet`
Total: 0 B, Transferred: 1.57 MiB, Speed: 101.87 MiB/s
+ for file in $(ls "${data_path}")
+ echo a.tsv
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv clickminio/test/a.tsv
a.tsv
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv` -> `clickminio/test/a.tsv`
Total: 0 B, Transferred: 24 B, Speed: 3.44 KiB/s
b.tsv
+ for file in $(ls "${data_path}")
+ echo b.tsv
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv clickminio/test/b.tsv
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv` -> `clickminio/test/b.tsv`
Total: 0 B, Transferred: 33 B, Speed: 5.45 KiB/s
+ for file in $(ls "${data_path}")
+ echo c.tsv
c.tsv
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv clickminio/test/c.tsv
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv` -> `clickminio/test/c.tsv`
Total: 0 B, Transferred: 33 B, Speed: 4.74 KiB/s
tsv_with_header.tsv
+ for file in $(ls "${data_path}")
+ echo tsv_with_header.tsv
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv clickminio/test/tsv_with_header.tsv
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv` -> `clickminio/test/tsv_with_header.tsv`
Total: 0 B, Transferred: 44 B, Speed: 6.20 KiB/s
+ setup_aws_credentials
+ local minio_root_user=clickhouse
+ local minio_root_password=clickhouse
+ mkdir -p /root/.aws
+ cat
+ config_logs_export_cluster /etc/clickhouse-server/config.d/system_logs_export.yaml
+ set +x
File /tmp/export-logs-config.sh does not exist, do not setup
+ start
+ counter=0
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
127.0.0.1 - - [28/Apr/2024:16:25:11 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 -
127.0.0.1 - - [28/Apr/2024:16:25:11 +0000] "PUT /devstoreaccount1/cont/thhmaigtbnqxhhbmbrnidirywlbxrpkx?blockid=rjvrdvfmchwsofphdubzrwoppymnjvfqqeuxfhpcsqfnrhxpfuuuxqvsendomqez&comp=block HTTP/1.1" 201 -
127.0.0.1 - - [28/Apr/2024:16:25:11 +0000] "PUT /devstoreaccount1/cont/thhmaigtbnqxhhbmbrnidirywlbxrpkx?comp=blocklist HTTP/1.1" 201 -
127.0.0.1 - - [28/Apr/2024:16:25:11 +0000] "GET /devstoreaccount1/cont/thhmaigtbnqxhhbmbrnidirywlbxrpkx HTTP/1.1" 206 4
127.0.0.1 - - [28/Apr/2024:16:25:11 +0000] "GET /devstoreaccount1/cont/thhmaigtbnqxhhbmbrnidirywlbxrpkx HTTP/1.1" 206 2
127.0.0.1 - - [28/Apr/2024:16:25:11 +0000] "DELETE /devstoreaccount1/cont/thhmaigtbnqxhhbmbrnidirywlbxrpkx HTTP/1.1" 202 -
1
+ attach_gdb_to_clickhouse
++ kill -l SIGRTMIN
+ RTMIN=34
+ echo '
set follow-fork-mode parent
handle SIGHUP nostop noprint pass
handle SIGINT nostop noprint pass
handle SIGQUIT nostop noprint pass
handle SIGPIPE nostop noprint pass
handle SIGTERM nostop noprint pass
handle SIGUSR1 nostop noprint pass
handle SIGUSR2 nostop noprint pass
handle SIG34 nostop noprint pass
info signals
continue
backtrace full
thread apply all backtrace full
info registers
disassemble /s
up
disassemble /s
up
disassemble /s
p "done"
detach
quit
'
+ sleep 5
+ ts '%Y-%m-%d %H:%M:%S'
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ gdb -batch -command script.gdb -p 533
+ run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
+ [[ hxB =~ e ]]
+ set_e=false
+ set +e
+ local total_retries=60
+ shift
+ local retry=0
+ '[' 0 -ge 60 ']'
+ clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
Connected to clickhouse-server after attaching gdb
+ false
+ return
+ setup_logs_replication
+ set +x
File /tmp/export-logs-config.sh does not exist, do not setup
+ /s3downloader --url-prefix https://s3.amazonaws.com/clickhouse-datasets --dataset-names hits visits
INFO:root:Will fetch following datasets: hits, visits
INFO:root:Processing hits
INFO:root:Downloading from https://s3.amazonaws.com/clickhouse-datasets/hits/partitions/hits_v1.tar to temp path /tmp/s3c2an1y
INFO:root:Content length is 1271623680 bytes
INFO:root:Downloading finished
INFO:root:Will unpack data from temp path /tmp/s3c2an1y to clickhouse db /var/lib/clickhouse/
INFO:root:Unpack finished
INFO:root:Will remove downloaded file /tmp/s3c2an1y 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/8tzkqvrg
INFO:root:Content length is 563968000 bytes
INFO:root:Downloading finished
INFO:root:Will unpack data from temp path /tmp/8tzkqvrg to clickhouse db /var/lib/clickhouse/
INFO:root:Unpack finished
INFO:root:Will remove downloaded file /tmp/8tzkqvrg from filesystem if it exists
INFO:root:Processing of visits finished
INFO:root:Fetch finished, enjoy your tables!
+ chmod 777 -R /var/lib/clickhouse
+ clickhouse-client --query 'ATTACH DATABASE IF NOT EXISTS datasets ENGINE = Ordinary'
+ clickhouse-client --query 'CREATE DATABASE IF NOT EXISTS test'
+ stop
+ local max_tries=90
+ local check_hang=true
+ local pid
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ pid=533
+ clickhouse stop --max-tries 90 --do-not-kill
script.gdb:13: Error in sourced command file:
No stack.
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 533.
The process with pid = 533 is running.
Sent terminate signal to process with pid 533.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 533.
The process with pid = 533 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 533.
The process with pid = 533 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 533.
The process with pid = 533 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 533.
The process with pid = 533 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 533.
The process with pid = 533 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 533.
The process with pid = 533 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.initial.log
+ start
+ counter=0
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
127.0.0.1 - - [28/Apr/2024:16:26:54 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 -
127.0.0.1 - - [28/Apr/2024:16:26:54 +0000] "PUT /devstoreaccount1/cont/lzisiygosyefrtjzpvvkhzcjjwvqucjh?blockid=ycinxjbvyfjewvudrniijxknhhbtulxnsjwagbulduggkynopzqtlhvugrlsjssq&comp=block HTTP/1.1" 201 -
127.0.0.1 - - [28/Apr/2024:16:26:54 +0000] "PUT /devstoreaccount1/cont/lzisiygosyefrtjzpvvkhzcjjwvqucjh?comp=blocklist HTTP/1.1" 201 -
127.0.0.1 - - [28/Apr/2024:16:26:54 +0000] "GET /devstoreaccount1/cont/lzisiygosyefrtjzpvvkhzcjjwvqucjh HTTP/1.1" 206 4
127.0.0.1 - - [28/Apr/2024:16:26:54 +0000] "GET /devstoreaccount1/cont/lzisiygosyefrtjzpvvkhzcjjwvqucjh HTTP/1.1" 206 2
127.0.0.1 - - [28/Apr/2024:16:26:54 +0000] "DELETE /devstoreaccount1/cont/lzisiygosyefrtjzpvvkhzcjjwvqucjh HTTP/1.1" 202 -
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ kill -l SIGRTMIN
+ RTMIN=34
+ echo '
set follow-fork-mode parent
handle SIGHUP nostop noprint pass
handle SIGINT nostop noprint pass
handle SIGQUIT nostop noprint pass
handle SIGPIPE nostop noprint pass
handle SIGTERM nostop noprint pass
handle SIGUSR1 nostop noprint pass
handle SIGUSR2 nostop noprint pass
handle SIG34 nostop noprint pass
info signals
continue
backtrace full
thread apply all backtrace full
info registers
disassemble /s
up
disassemble /s
up
disassemble /s
p "done"
detach
quit
'
+ sleep 5
+ ts '%Y-%m-%d %H:%M:%S'
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ gdb -batch -command script.gdb -p 954
+ run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
+ [[ hxB =~ e ]]
+ set_e=false
+ set +e
+ local total_retries=60
+ shift
+ local retry=0
+ '[' 0 -ge 60 ']'
+ clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
Connected to clickhouse-server after attaching gdb
+ false
+ return
+ clickhouse-client --query 'SHOW TABLES FROM datasets'
hits_v1
visits_v1
+ clickhouse-client --query 'SHOW TABLES FROM test'
+ clickhouse-client --query 'CREATE TABLE test.hits_s3 (WatchID UInt64, JavaEnable UInt8, Title String, GoodEvent Int16,
EventTime DateTime, EventDate Date, CounterID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RegionID UInt32,
UserID UInt64, CounterClass Int8, OS UInt8, UserAgent UInt8, URL String, Referer String, URLDomain String, RefererDomain String,
Refresh UInt8, IsRobot UInt8, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32),
RefererRegions Array(UInt32), ResolutionWidth UInt16, ResolutionHeight UInt16, ResolutionDepth UInt8, FlashMajor UInt8,
FlashMinor UInt8, FlashMinor2 String, NetMajor UInt8, NetMinor UInt8, UserAgentMajor UInt16, UserAgentMinor FixedString(2),
CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, MobilePhone UInt8, MobilePhoneModel String, Params String,
IPNetworkID UInt32, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String, AdvEngineID UInt8, IsArtifical UInt8,
WindowClientWidth UInt16, WindowClientHeight UInt16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 UInt8,
SilverlightVersion2 UInt8, SilverlightVersion3 UInt32, SilverlightVersion4 UInt16, PageCharset String, CodeVersion UInt32,
IsLink UInt8, IsDownload UInt8, IsNotBounce UInt8, FUniqID UInt64, HID UInt32, IsOldCounter UInt8, IsEvent UInt8,
IsParameter UInt8, DontCountHits UInt8, WithHash UInt8, HitColor FixedString(1), UTCEventTime DateTime, Age UInt8,
Sex UInt8, Income UInt8, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16), RemoteIP UInt32,
RemoteIP6 FixedString(16), WindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage FixedString(2),
BrowserCountry FixedString(2), SocialNetwork String, SocialAction String, HTTPError UInt16, SendTiming Int32,
DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, FetchTiming Int32,
RedirectTiming Int32, DOMInteractiveTiming Int32, DOMContentLoadedTiming Int32, DOMCompleteTiming Int32,
LoadEventStartTiming Int32, LoadEventEndTiming Int32, NSToDOMContentLoadedTiming Int32, FirstPaintTiming Int32,
RedirectCount Int8, SocialSourceNetworkID UInt8, SocialSourcePage String, ParamPrice Int64, ParamOrderID String,
ParamCurrency FixedString(3), ParamCurrencyID UInt16, GoalsReached Array(UInt32), OpenstatServiceName String,
OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String,
UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, RefererHash UInt64,
URLHash UInt64, CLID UInt32, YCLID UInt64, ShareService String, ShareURL String, ShareTitle String,
ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64),
IslandID FixedString(16), RequestNum UInt32, RequestTry UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate)
ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''s3_cache'\'''
+ clickhouse-client --query 'CREATE TABLE test.hits (WatchID UInt64, JavaEnable UInt8, Title String, GoodEvent Int16,
EventTime DateTime, EventDate Date, CounterID UInt32, ClientIP UInt32, ClientIP6 FixedString(16), RegionID UInt32,
UserID UInt64, CounterClass Int8, OS UInt8, UserAgent UInt8, URL String, Referer String, URLDomain String,
RefererDomain String, Refresh UInt8, IsRobot UInt8, RefererCategories Array(UInt16), URLCategories Array(UInt16),
URLRegions Array(UInt32), RefererRegions Array(UInt32), ResolutionWidth UInt16, ResolutionHeight UInt16, ResolutionDepth UInt8,
FlashMajor UInt8, FlashMinor UInt8, FlashMinor2 String, NetMajor UInt8, NetMinor UInt8, UserAgentMajor UInt16,
UserAgentMinor FixedString(2), CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8, MobilePhone UInt8,
MobilePhoneModel String, Params String, IPNetworkID UInt32, TraficSourceID Int8, SearchEngineID UInt16,
SearchPhrase String, AdvEngineID UInt8, IsArtifical UInt8, WindowClientWidth UInt16, WindowClientHeight UInt16,
ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 UInt8, SilverlightVersion2 UInt8, SilverlightVersion3 UInt32,
SilverlightVersion4 UInt16, PageCharset String, CodeVersion UInt32, IsLink UInt8, IsDownload UInt8, IsNotBounce UInt8,
FUniqID UInt64, HID UInt32, IsOldCounter UInt8, IsEvent UInt8, IsParameter UInt8, DontCountHits UInt8, WithHash UInt8,
HitColor FixedString(1), UTCEventTime DateTime, Age UInt8, Sex UInt8, Income UInt8, Interests UInt16, Robotness UInt8,
GeneralInterests Array(UInt16), RemoteIP UInt32, RemoteIP6 FixedString(16), WindowName Int32, OpenerName Int32,
HistoryLength Int16, BrowserLanguage FixedString(2), BrowserCountry FixedString(2), SocialNetwork String, SocialAction String,
HTTPError UInt16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32,
FetchTiming Int32, RedirectTiming Int32, DOMInteractiveTiming Int32, DOMContentLoadedTiming Int32, DOMCompleteTiming Int32,
LoadEventStartTiming Int32, LoadEventEndTiming Int32, NSToDOMContentLoadedTiming Int32, FirstPaintTiming Int32,
RedirectCount Int8, SocialSourceNetworkID UInt8, SocialSourcePage String, ParamPrice Int64, ParamOrderID String,
ParamCurrency FixedString(3), ParamCurrencyID UInt16, GoalsReached Array(UInt32), OpenstatServiceName String,
OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String,
UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, RefererHash UInt64,
URLHash UInt64, CLID UInt32, YCLID UInt64, ShareService String, ShareURL String, ShareTitle String,
ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64),
IslandID FixedString(16), RequestNum UInt32, RequestTry UInt8) ENGINE = MergeTree() PARTITION BY toYYYYMM(EventDate)
ORDER BY (CounterID, EventDate, intHash32(UserID)) SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''s3_cache'\'''
+ clickhouse-client --query 'CREATE TABLE test.visits (CounterID UInt32, StartDate Date, Sign Int8, IsNew UInt8,
VisitID UInt64, UserID UInt64, StartTime DateTime, Duration UInt32, UTCStartTime DateTime, PageViews Int32,
Hits Int32, IsBounce UInt8, Referer String, StartURL String, RefererDomain String, StartURLDomain String,
EndURL String, LinkURL String, IsDownload UInt8, TraficSourceID Int8, SearchEngineID UInt16, SearchPhrase String,
AdvEngineID UInt8, PlaceID Int32, RefererCategories Array(UInt16), URLCategories Array(UInt16), URLRegions Array(UInt32),
RefererRegions Array(UInt32), IsYandex UInt8, GoalReachesDepth Int32, GoalReachesURL Int32, GoalReachesAny Int32,
SocialSourceNetworkID UInt8, SocialSourcePage String, MobilePhoneModel String, ClientEventTime DateTime, RegionID UInt32,
ClientIP UInt32, ClientIP6 FixedString(16), RemoteIP UInt32, RemoteIP6 FixedString(16), IPNetworkID UInt32,
SilverlightVersion3 UInt32, CodeVersion UInt32, ResolutionWidth UInt16, ResolutionHeight UInt16, UserAgentMajor UInt16,
UserAgentMinor UInt16, WindowClientWidth UInt16, WindowClientHeight UInt16, SilverlightVersion2 UInt8, SilverlightVersion4 UInt16,
FlashVersion3 UInt16, FlashVersion4 UInt16, ClientTimeZone Int16, OS UInt8, UserAgent UInt8, ResolutionDepth UInt8,
FlashMajor UInt8, FlashMinor UInt8, NetMajor UInt8, NetMinor UInt8, MobilePhone UInt8, SilverlightVersion1 UInt8,
Age UInt8, Sex UInt8, Income UInt8, JavaEnable UInt8, CookieEnable UInt8, JavascriptEnable UInt8, IsMobile UInt8,
BrowserLanguage UInt16, BrowserCountry UInt16, Interests UInt16, Robotness UInt8, GeneralInterests Array(UInt16),
Params Array(String), Goals Nested(ID UInt32, Serial UInt32, EventTime DateTime, Price Int64, OrderID String, CurrencyID UInt32),
WatchIDs Array(UInt64), ParamSumPrice Int64, ParamCurrency FixedString(3), ParamCurrencyID UInt16, ClickLogID UInt64,
ClickEventID Int32, ClickGoodEvent Int32, ClickEventTime DateTime, ClickPriorityID Int32, ClickPhraseID Int32, ClickPageID Int32,
ClickPlaceID Int32, ClickTypeID Int32, ClickResourceID Int32, ClickCost UInt32, ClickClientIP UInt32, ClickDomainID UInt32,
ClickURL String, ClickAttempt UInt8, ClickOrderID UInt32, ClickBannerID UInt32, ClickMarketCategoryID UInt32, ClickMarketPP UInt32,
ClickMarketCategoryName String, ClickMarketPPName String, ClickAWAPSCampaignName String, ClickPageName String, ClickTargetType UInt16,
ClickTargetPhraseID UInt64, ClickContextType UInt8, ClickSelectType Int8, ClickOptions String, ClickGroupBannerID Int32,
OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String,
UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID UInt8, FirstVisit DateTime,
PredLastVisit Date, LastVisit Date, TotalVisits UInt32, TraficSource Nested(ID Int8, SearchEngineID UInt16, AdvEngineID UInt8,
PlaceID UInt16, SocialSourceNetworkID UInt8, Domain String, SearchPhrase String, SocialSourcePage String), Attendance FixedString(16),
CLID UInt32, YCLID UInt64, NormalizedRefererHash UInt64, SearchPhraseHash UInt64, RefererDomainHash UInt64, NormalizedStartURLHash UInt64,
StartURLDomainHash UInt64, NormalizedEndURLHash UInt64, TopLevelDomain UInt64, URLScheme UInt64, OpenstatServiceNameHash UInt64,
OpenstatCampaignIDHash UInt64, OpenstatAdIDHash UInt64, OpenstatSourceIDHash UInt64, UTMSourceHash UInt64, UTMMediumHash UInt64,
UTMCampaignHash UInt64, UTMContentHash UInt64, UTMTermHash UInt64, FromHash UInt64, WebVisorEnabled UInt8, WebVisorActivity UInt32,
ParsedParams Nested(Key1 String, Key2 String, Key3 String, Key4 String, Key5 String, ValueDouble Float64),
Market Nested(Type UInt8, GoalID UInt32, OrderID String, OrderPrice Int64, PP UInt32, DirectPlaceID UInt32, DirectOrderID UInt32,
DirectBannerID UInt32, GoodID String, GoodName String, GoodQuantity Int32, GoodPrice Int64), IslandID FixedString(16))
ENGINE = CollapsingMergeTree(Sign) PARTITION BY toYYYYMM(StartDate) ORDER BY (CounterID, StartDate, intHash32(UserID), VisitID)
SAMPLE BY intHash32(UserID) SETTINGS index_granularity = 8192, storage_policy='\''s3_cache'\'''
+ clickhouse-client --query 'INSERT INTO test.hits_s3 SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0'
+ clickhouse-client --query 'INSERT INTO test.hits SELECT * FROM datasets.hits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0'
+ clickhouse-client --query 'INSERT INTO test.visits SELECT * FROM datasets.visits_v1 SETTINGS enable_filesystem_cache_on_write_operations=0'
+ clickhouse-client --query 'DROP TABLE datasets.visits_v1 SYNC'
+ clickhouse-client --query 'DROP TABLE datasets.hits_v1 SYNC'
+ clickhouse-client --query 'SHOW TABLES FROM test'
hits
hits_s3
visits
+ clickhouse-client --query 'SYSTEM STOP THREAD FUZZER'
+ stop
+ local max_tries=90
+ local check_hang=true
+ local pid
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ pid=954
+ clickhouse stop --max-tries 90 --do-not-kill
script.gdb:13: Error in sourced command file:
No stack.
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 954.
The process with pid = 954 is running.
Sent terminate signal to process with pid 954.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 954.
The process with pid = 954 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 954.
The process with pid = 954 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 954.
The process with pid = 954 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ export USE_S3_STORAGE_FOR_MERGE_TREE=1
+ USE_S3_STORAGE_FOR_MERGE_TREE=1
+ export ZOOKEEPER_FAULT_INJECTION=1
+ ZOOKEEPER_FAULT_INJECTION=1
+ configure
+ export USE_DATABASE_ORDINARY=1
+ USE_DATABASE_ORDINARY=1
+ export EXPORT_S3_STORAGE_POLICIES=1
+ EXPORT_S3_STORAGE_POLICIES=1
+ /usr/share/clickhouse-test/config/install.sh
+ DEST_SERVER_PATH=/etc/clickhouse-server
+ DEST_CLIENT_PATH=/etc/clickhouse-client
+++ dirname /usr/share/clickhouse-test/config/install.sh
++ cd /usr/share/clickhouse-test/config
++ pwd -P
+ SRC_PATH=/usr/share/clickhouse-test/config
+ echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server'
+ mkdir -p /etc/clickhouse-server/config.d/
Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server
+ mkdir -p /etc/clickhouse-server/users.d/
+ mkdir -p /etc/clickhouse-client
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/disks.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/metadata_cache.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/reverse_dns_query_function.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/
+ '[' /etc/clickhouse-server = /etc/clickhouse-server ']'
+ ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/
+ ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ rm -f /etc/clickhouse-server/config.d/zookeeper.xml
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/
+ create_snapshot_on_exit=1
+ sed --follow-symlinks -i 's|true|1|' /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n '' ]]
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/config.d/s3_storage_policy_by_default.xml /etc/clickhouse-server/config.d/
+ ARM=aarch64
++ uname -m
+ OS=x86_64
+ [[ -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
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|100000|10000|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\'''
+ export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ sudo chown root: /var/lib/clickhouse
+ echo '1'
+ local total_mem
++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo
+ total_mem=32098980
+ total_mem=32869355520
+ max_server_memory_usage_to_ram_ratio=0.5
Setting max_server_memory_usage_to_ram_ratio to 0.5
+ echo 'Setting max_server_memory_usage_to_ram_ratio to 0.5'
+ cat
+ local max_users_mem
+ max_users_mem=9860806656
+ echo 'Setting max_memory_usage_for_user=9860806656 and max_memory_usage for queries to 10G'
+ cat
Setting max_memory_usage_for_user=9860806656 and max_memory_usage for queries to 10G
+ cat
+ cat
+ sudo cat /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml
+ sed 's|s3|s3default|'
+ mv /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml.tmp /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/s3_storage_policy_by_default.xml
+ sudo cat /etc/clickhouse-server/config.d/logger_trace.xml
+ sed 's|trace|test|'
+ mv /etc/clickhouse-server/config.d/logger_trace.xml.tmp /etc/clickhouse-server/config.d/logger_trace.xml
+ start
+ counter=0
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
127.0.0.1 - - [28/Apr/2024:16:38:58 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 -
127.0.0.1 - - [28/Apr/2024:16:38:58 +0000] "PUT /devstoreaccount1/cont/jfdipksfnuaayqahtoalnziassgczerq?blockid=kroijpingxxbijgtqcabymyzingupqdiusdgmftvsnsstkstcnjesqproezntrgl&comp=block HTTP/1.1" 201 -
127.0.0.1 - - [28/Apr/2024:16:38:58 +0000] "PUT /devstoreaccount1/cont/jfdipksfnuaayqahtoalnziassgczerq?comp=blocklist HTTP/1.1" 201 -
127.0.0.1 - - [28/Apr/2024:16:38:58 +0000] "GET /devstoreaccount1/cont/jfdipksfnuaayqahtoalnziassgczerq HTTP/1.1" 206 4
127.0.0.1 - - [28/Apr/2024:16:38:58 +0000] "GET /devstoreaccount1/cont/jfdipksfnuaayqahtoalnziassgczerq HTTP/1.1" 206 2
127.0.0.1 - - [28/Apr/2024:16:38:58 +0000] "DELETE /devstoreaccount1/cont/jfdipksfnuaayqahtoalnziassgczerq HTTP/1.1" 202 -
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ kill -l SIGRTMIN
+ RTMIN=34
+ echo '
set follow-fork-mode parent
handle SIGHUP nostop noprint pass
handle SIGINT nostop noprint pass
handle SIGQUIT nostop noprint pass
handle SIGPIPE nostop noprint pass
handle SIGTERM nostop noprint pass
handle SIGUSR1 nostop noprint pass
handle SIGUSR2 nostop noprint pass
handle SIG34 nostop noprint pass
info signals
continue
backtrace full
thread apply all backtrace full
info registers
disassemble /s
up
disassemble /s
up
disassemble /s
p "done"
detach
quit
'
+ sleep 5
+ ts '%Y-%m-%d %H:%M:%S'
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ gdb -batch -command script.gdb -p 1772
+ run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
+ [[ hxB =~ e ]]
+ set_e=false
+ set +e
+ local total_retries=60
+ shift
+ local retry=0
+ '[' 0 -ge 60 ']'
+ clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
Connected to clickhouse-server after attaching gdb
+ false
+ return
+ stress --hung-check --drop-databases --output-folder test_output --skip-func-tests '' --global-time-limit 1200
2024-04-28 18:39:58,991 Run func tests '/usr/bin/clickhouse-test --global_time_limit=1200 '
2024-04-28 18:39:59,492 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_1 --client-option join_use_nulls=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 group_by_use_nulls=1 --global_time_limit=1200 '
2024-04-28 18:39:59,994 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_2', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 use_query_cache=1 --global_time_limit=1200 '
2024-04-28 18:40:00,495 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_3 --client-option join_algorithm='partial_merge' use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 '
2024-04-28 18:40:00,996 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 use_query_cache=1 --global_time_limit=1200 '
2024-04-28 18:40:01,497 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_5', 's1', 'r1')" --database=test_5 --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 join_algorithm='full_sorting_merge' group_by_use_nulls=1 --global_time_limit=1200 '
2024-04-28 18:40:01,998 Run func tests '/usr/bin/clickhouse-test --order=random --client-option memory_tracker_fault_probability=0.001 --global_time_limit=1200 '
2024-04-28 18:40:02,499 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_7 --client-option join_use_nulls=1 join_algorithm='grace_hash' group_by_use_nulls=1 --global_time_limit=1200 '
2024-04-28 18:40:03,000 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_8', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 --global_time_limit=1200 '
2024-04-28 18:40:03,502 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_9 --client-option join_algorithm='auto' max_rows_in_join=1000 group_by_use_nulls=1 --global_time_limit=1200 '
2024-04-28 18:40:04,002 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 '
2024-04-28 18:40:04,504 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_11', 's1', 'r1')" --database=test_11 --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 group_by_use_nulls=1 --global_time_limit=1200 '
2024-04-28 18:40:05,005 Run func tests '/usr/bin/clickhouse-test --order=random --client-option implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 --global_time_limit=1200 '
2024-04-28 18:40:05,506 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_13 --client-option join_use_nulls=1 join_algorithm='partial_merge' use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 '
2024-04-28 18:40:06,007 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_14', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 use_query_cache=1 --global_time_limit=1200 '
2024-04-28 18:40:06,508 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_merge' use_query_cache=1 group_by_use_nulls=1 --global_time_limit=1200 '
2024-04-28 18:40:07,009 Will wait functests to finish
2024-04-28 18:40:07,009 Finished 0 from 16 processes
2024-04-28 18:40:12,014 Finished 0 from 16 processes
2024-04-28 18:40:17,018 Finished 0 from 16 processes
2024-04-28 18:40:22,022 Finished 0 from 16 processes
2024-04-28 18:40:27,026 Finished 0 from 16 processes
2024-04-28 18:40:32,030 Finished 0 from 16 processes
2024-04-28 18:40:37,034 Finished 0 from 16 processes
2024-04-28 18:40:42,038 Finished 0 from 16 processes
2024-04-28 18:40:47,042 Finished 0 from 16 processes
2024-04-28 18:40:52,046 Finished 0 from 16 processes
2024-04-28 18:40:57,050 Finished 0 from 16 processes
2024-04-28 18:41:02,054 Finished 0 from 16 processes
2024-04-28 18:41:07,057 Finished 0 from 16 processes
2024-04-28 18:41:12,062 Finished 0 from 16 processes
2024-04-28 18:41:17,066 Finished 0 from 16 processes
2024-04-28 18:41:22,070 Finished 0 from 16 processes
2024-04-28 18:41:27,074 Finished 0 from 16 processes
2024-04-28 18:41:32,078 Finished 0 from 16 processes
2024-04-28 18:41:37,082 Finished 0 from 16 processes
2024-04-28 18:41:42,086 Finished 0 from 16 processes
2024-04-28 18:41:47,090 Finished 0 from 16 processes
2024-04-28 18:41:52,096 Finished 0 from 16 processes
2024-04-28 18:41:57,098 Finished 0 from 16 processes
2024-04-28 18:42:02,102 Finished 0 from 16 processes
2024-04-28 18:42:07,106 Finished 0 from 16 processes
2024-04-28 18:42:12,110 Finished 0 from 16 processes
2024-04-28 18:42:17,114 Finished 0 from 16 processes
2024-04-28 18:42:22,118 Finished 0 from 16 processes
2024-04-28 18:42:27,122 Finished 0 from 16 processes
2024-04-28 18:42:32,126 Finished 0 from 16 processes
2024-04-28 18:42:37,130 Finished 0 from 16 processes
2024-04-28 18:42:42,134 Finished 0 from 16 processes
2024-04-28 18:42:47,138 Finished 0 from 16 processes
2024-04-28 18:42:52,139 Finished 0 from 16 processes
2024-04-28 18:42:57,144 Finished 0 from 16 processes
2024-04-28 18:43:02,146 Finished 0 from 16 processes
2024-04-28 18:43:07,150 Finished 0 from 16 processes
2024-04-28 18:43:12,154 Finished 0 from 16 processes
2024-04-28 18:43:17,158 Finished 0 from 16 processes
2024-04-28 18:43:22,164 Finished 0 from 16 processes
2024-04-28 18:43:27,166 Finished 0 from 16 processes
2024-04-28 18:43:32,171 Finished 0 from 16 processes
2024-04-28 18:43:37,174 Finished 0 from 16 processes
2024-04-28 18:43:42,178 Finished 0 from 16 processes
2024-04-28 18:43:47,182 Finished 0 from 16 processes
2024-04-28 18:43:52,186 Finished 0 from 16 processes
2024-04-28 18:43:57,190 Finished 0 from 16 processes
2024-04-28 18:44:02,194 Finished 0 from 16 processes
2024-04-28 18:44:07,198 Finished 0 from 16 processes
2024-04-28 18:44:12,202 Finished 0 from 16 processes
2024-04-28 18:44:17,206 Finished 0 from 16 processes
2024-04-28 18:44:22,210 Finished 0 from 16 processes
2024-04-28 18:44:27,214 Finished 0 from 16 processes
2024-04-28 18:44:32,218 Finished 0 from 16 processes
2024-04-28 18:44:37,222 Finished 0 from 16 processes
2024-04-28 18:44:42,226 Finished 0 from 16 processes
2024-04-28 18:44:47,230 Finished 0 from 16 processes
2024-04-28 18:44:52,234 Finished 0 from 16 processes
2024-04-28 18:44:57,238 Finished 0 from 16 processes
2024-04-28 18:45:02,242 Finished 0 from 16 processes
2024-04-28 18:45:07,246 Finished 0 from 16 processes
2024-04-28 18:45:12,250 Finished 0 from 16 processes
2024-04-28 18:45:17,256 Finished 0 from 16 processes
2024-04-28 18:45:22,258 Finished 0 from 16 processes
2024-04-28 18:45:27,264 Finished 0 from 16 processes
2024-04-28 18:45:32,266 Finished 0 from 16 processes
2024-04-28 18:45:37,270 Finished 0 from 16 processes
2024-04-28 18:45:42,274 Finished 0 from 16 processes
2024-04-28 18:45:47,278 Finished 0 from 16 processes
2024-04-28 18:45:52,283 Finished 0 from 16 processes
2024-04-28 18:45:57,286 Finished 0 from 16 processes
2024-04-28 18:46:02,290 Finished 0 from 16 processes
2024-04-28 18:46:07,294 Finished 0 from 16 processes
2024-04-28 18:46:12,300 Finished 0 from 16 processes
2024-04-28 18:46:17,302 Finished 0 from 16 processes
2024-04-28 18:46:22,307 Finished 0 from 16 processes
2024-04-28 18:46:27,312 Finished 0 from 16 processes
2024-04-28 18:46:32,314 Finished 0 from 16 processes
2024-04-28 18:46:37,318 Finished 0 from 16 processes
2024-04-28 18:46:42,322 Finished 0 from 16 processes
2024-04-28 18:46:47,326 Finished 0 from 16 processes
2024-04-28 18:46:52,328 Finished 0 from 16 processes
2024-04-28 18:46:57,330 Finished 0 from 16 processes
2024-04-28 18:47:02,334 Finished 0 from 16 processes
2024-04-28 18:47:07,338 Finished 0 from 16 processes
2024-04-28 18:47:12,342 Finished 0 from 16 processes
2024-04-28 18:47:17,346 Finished 0 from 16 processes
2024-04-28 18:47:22,349 Finished 0 from 16 processes
2024-04-28 18:47:27,350 Finished 0 from 16 processes
2024-04-28 18:47:32,356 Finished 0 from 16 processes
2024-04-28 18:47:37,361 Finished 0 from 16 processes
2024-04-28 18:47:42,362 Finished 0 from 16 processes
2024-04-28 18:47:47,366 Finished 0 from 16 processes
2024-04-28 18:47:52,372 Finished 0 from 16 processes
2024-04-28 18:47:57,374 Finished 0 from 16 processes
2024-04-28 18:48:02,378 Finished 0 from 16 processes
2024-04-28 18:48:07,382 Finished 0 from 16 processes
2024-04-28 18:48:12,386 Finished 0 from 16 processes
2024-04-28 18:48:17,390 Finished 0 from 16 processes
2024-04-28 18:48:22,394 Finished 0 from 16 processes
2024-04-28 18:48:27,398 Finished 0 from 16 processes
2024-04-28 18:48:32,402 Finished 0 from 16 processes
2024-04-28 18:48:37,406 Finished 0 from 16 processes
2024-04-28 18:48:42,411 Finished 0 from 16 processes
2024-04-28 18:48:47,414 Finished 0 from 16 processes
2024-04-28 18:48:52,418 Finished 0 from 16 processes
2024-04-28 18:48:57,422 Finished 0 from 16 processes
2024-04-28 18:49:02,426 Finished 0 from 16 processes
2024-04-28 18:49:07,431 Finished 0 from 16 processes
2024-04-28 18:49:12,436 Finished 0 from 16 processes
2024-04-28 18:49:17,439 Finished 0 from 16 processes
2024-04-28 18:49:22,445 Finished 0 from 16 processes
2024-04-28 18:49:27,445 Finished 0 from 16 processes
2024-04-28 18:49:32,449 Finished 0 from 16 processes
2024-04-28 18:49:37,454 Finished 0 from 16 processes
2024-04-28 18:49:42,458 Finished 0 from 16 processes
2024-04-28 18:49:47,462 Finished 0 from 16 processes
2024-04-28 18:49:52,466 Finished 0 from 16 processes
2024-04-28 18:49:57,470 Finished 0 from 16 processes
2024-04-28 18:50:02,474 Finished 0 from 16 processes
2024-04-28 18:50:07,479 Finished 0 from 16 processes
2024-04-28 18:50:12,482 Finished 0 from 16 processes
2024-04-28 18:50:17,486 Finished 0 from 16 processes
2024-04-28 18:50:22,490 Finished 0 from 16 processes
2024-04-28 18:50:27,494 Finished 0 from 16 processes
2024-04-28 18:50:32,498 Finished 0 from 16 processes
2024-04-28 18:50:37,504 Finished 0 from 16 processes
2024-04-28 18:50:42,506 Finished 0 from 16 processes
2024-04-28 18:50:47,510 Finished 0 from 16 processes
2024-04-28 18:50:52,514 Finished 0 from 16 processes
2024-04-28 18:50:57,518 Finished 0 from 16 processes
2024-04-28 18:51:02,522 Finished 0 from 16 processes
2024-04-28 18:51:07,527 Finished 0 from 16 processes
2024-04-28 18:51:12,530 Finished 0 from 16 processes
2024-04-28 18:51:17,534 Finished 0 from 16 processes
2024-04-28 18:51:22,540 Finished 0 from 16 processes
2024-04-28 18:51:27,542 Finished 0 from 16 processes
2024-04-28 18:51:32,547 Finished 0 from 16 processes
2024-04-28 18:51:37,552 Finished 0 from 16 processes
2024-04-28 18:51:42,557 Finished 0 from 16 processes
2024-04-28 18:51:47,558 Finished 0 from 16 processes
2024-04-28 18:51:52,562 Finished 0 from 16 processes
2024-04-28 18:51:57,566 Finished 0 from 16 processes
2024-04-28 18:52:02,570 Finished 0 from 16 processes
2024-04-28 18:52:07,576 Finished 0 from 16 processes
2024-04-28 18:52:12,578 Finished 0 from 16 processes
2024-04-28 18:52:17,580 Finished 0 from 16 processes
2024-04-28 18:52:22,585 Finished 0 from 16 processes
2024-04-28 18:52:27,590 Finished 0 from 16 processes
2024-04-28 18:52:32,595 Finished 0 from 16 processes
2024-04-28 18:52:37,599 Finished 0 from 16 processes
2024-04-28 18:52:42,602 Finished 0 from 16 processes
2024-04-28 18:52:47,606 Finished 0 from 16 processes
2024-04-28 18:52:52,610 Finished 0 from 16 processes
2024-04-28 18:52:57,614 Finished 0 from 16 processes
2024-04-28 18:53:02,618 Finished 0 from 16 processes
2024-04-28 18:53:07,622 Finished 0 from 16 processes
2024-04-28 18:53:12,626 Finished 0 from 16 processes
2024-04-28 18:53:17,631 Finished 0 from 16 processes
2024-04-28 18:53:22,634 Finished 0 from 16 processes
2024-04-28 18:53:27,638 Finished 0 from 16 processes
2024-04-28 18:53:32,642 Finished 0 from 16 processes
2024-04-28 18:53:37,647 Finished 0 from 16 processes
2024-04-28 18:53:42,650 Finished 0 from 16 processes
2024-04-28 18:53:47,653 Finished 0 from 16 processes
2024-04-28 18:53:52,654 Finished 0 from 16 processes
2024-04-28 18:53:57,658 Finished 0 from 16 processes
2024-04-28 18:54:02,662 Finished 0 from 16 processes
2024-04-28 18:54:07,666 Finished 0 from 16 processes
2024-04-28 18:54:12,670 Finished 0 from 16 processes
2024-04-28 18:54:17,672 Finished 0 from 16 processes
2024-04-28 18:54:22,674 Finished 0 from 16 processes
2024-04-28 18:54:27,678 Finished 0 from 16 processes
2024-04-28 18:54:32,682 Finished 0 from 16 processes
2024-04-28 18:54:37,688 Finished 0 from 16 processes
2024-04-28 18:54:42,690 Finished 0 from 16 processes
2024-04-28 18:54:47,696 Finished 0 from 16 processes
2024-04-28 18:54:52,701 Finished 0 from 16 processes
2024-04-28 18:54:57,702 Finished 0 from 16 processes
2024-04-28 18:55:02,706 Finished 0 from 16 processes
2024-04-28 18:55:07,710 Finished 0 from 16 processes
2024-04-28 18:55:12,714 Finished 0 from 16 processes
2024-04-28 18:55:17,718 Finished 0 from 16 processes
2024-04-28 18:55:22,724 Finished 0 from 16 processes
2024-04-28 18:55:27,728 Finished 0 from 16 processes
2024-04-28 18:55:32,729 Finished 0 from 16 processes
2024-04-28 18:55:37,730 Finished 0 from 16 processes
2024-04-28 18:55:42,736 Finished 0 from 16 processes
2024-04-28 18:55:47,741 Finished 0 from 16 processes
2024-04-28 18:55:52,744 Finished 0 from 16 processes
2024-04-28 18:55:57,747 Finished 0 from 16 processes
2024-04-28 18:56:02,750 Finished 0 from 16 processes
2024-04-28 18:56:07,754 Finished 0 from 16 processes
2024-04-28 18:56:12,758 Finished 0 from 16 processes
2024-04-28 18:56:17,763 Finished 0 from 16 processes
2024-04-28 18:56:22,766 Finished 0 from 16 processes
2024-04-28 18:56:27,770 Finished 0 from 16 processes
2024-04-28 18:56:32,774 Finished 0 from 16 processes
2024-04-28 18:56:37,778 Finished 0 from 16 processes
2024-04-28 18:56:42,782 Finished 0 from 16 processes
2024-04-28 18:56:47,786 Finished 0 from 16 processes
2024-04-28 18:56:52,791 Finished 0 from 16 processes
2024-04-28 18:56:57,796 Finished 0 from 16 processes
2024-04-28 18:57:02,800 Finished 0 from 16 processes
2024-04-28 18:57:07,805 Finished 0 from 16 processes
2024-04-28 18:57:12,810 Finished 0 from 16 processes
2024-04-28 18:57:17,814 Finished 0 from 16 processes
2024-04-28 18:57:22,818 Finished 0 from 16 processes
2024-04-28 18:57:27,822 Finished 0 from 16 processes
2024-04-28 18:57:32,827 Finished 0 from 16 processes
2024-04-28 18:57:37,830 Finished 0 from 16 processes
2024-04-28 18:57:42,834 Finished 0 from 16 processes
2024-04-28 18:57:47,838 Finished 0 from 16 processes
2024-04-28 18:57:52,842 Finished 0 from 16 processes
2024-04-28 18:57:57,846 Finished 0 from 16 processes
2024-04-28 18:58:02,851 Finished 0 from 16 processes
2024-04-28 18:58:07,854 Finished 0 from 16 processes
2024-04-28 18:58:12,858 Finished 0 from 16 processes
2024-04-28 18:58:17,862 Finished 0 from 16 processes
2024-04-28 18:58:22,868 Finished 0 from 16 processes
2024-04-28 18:58:27,870 Finished 0 from 16 processes
2024-04-28 18:58:32,874 Finished 0 from 16 processes
2024-04-28 18:58:37,878 Finished 0 from 16 processes
2024-04-28 18:58:42,879 Finished 0 from 16 processes
2024-04-28 18:58:47,882 Finished 0 from 16 processes
2024-04-28 18:58:52,886 Finished 0 from 16 processes
2024-04-28 18:58:57,890 Finished 0 from 16 processes
2024-04-28 18:59:02,894 Finished 0 from 16 processes
2024-04-28 18:59:07,898 Finished 0 from 16 processes
2024-04-28 18:59:12,902 Finished 0 from 16 processes
2024-04-28 18:59:17,907 Finished 0 from 16 processes
2024-04-28 18:59:22,910 Finished 0 from 16 processes
2024-04-28 18:59:27,916 Finished 0 from 16 processes
2024-04-28 18:59:32,918 Finished 0 from 16 processes
2024-04-28 18:59:37,921 Finished 0 from 16 processes
2024-04-28 18:59:42,926 Finished 0 from 16 processes
2024-04-28 18:59:47,930 Finished 0 from 16 processes
2024-04-28 18:59:52,935 Finished 0 from 16 processes
2024-04-28 18:59:57,938 Finished 0 from 16 processes
2024-04-28 19:00:02,942 Finished 0 from 16 processes
2024-04-28 19:00:07,952 Finished 0 from 16 processes
2024-04-28 19:00:13,666 Finished 0 from 16 processes
2024-04-28 19:00:18,671 Finished 1 from 16 processes
2024-04-28 19:00:23,674 Finished 1 from 16 processes
2024-04-28 19:00:28,678 Finished 1 from 16 processes
2024-04-28 19:00:33,682 Finished 1 from 16 processes
2024-04-28 19:00:38,686 Finished 2 from 16 processes
2024-04-28 19:00:43,690 Finished 2 from 16 processes
2024-04-28 19:00:48,694 Finished 2 from 16 processes
2024-04-28 19:00:53,698 Finished 4 from 16 processes
2024-04-28 19:00:58,702 Finished 4 from 16 processes
2024-04-28 19:01:03,706 Finished 5 from 16 processes
2024-04-28 19:01:08,710 Finished 5 from 16 processes
2024-04-28 19:01:13,713 Finished 6 from 16 processes
2024-04-28 19:01:18,715 Finished 6 from 16 processes
2024-04-28 19:01:23,722 Finished 6 from 16 processes
2024-04-28 19:01:28,726 Finished 6 from 16 processes
2024-04-28 19:01:33,730 Finished 6 from 16 processes
2024-04-28 19:01:38,736 Finished 6 from 16 processes
2024-04-28 19:01:43,738 Finished 6 from 16 processes
2024-04-28 19:01:48,742 Finished 6 from 16 processes
2024-04-28 19:01:53,746 Finished 7 from 16 processes
2024-04-28 19:01:58,751 Finished 7 from 16 processes
2024-04-28 19:02:03,754 Finished 7 from 16 processes
2024-04-28 19:02:08,766 Finished 7 from 16 processes
2024-04-28 19:02:13,770 Finished 7 from 16 processes
2024-04-28 19:02:18,774 Finished 10 from 16 processes
2024-04-28 19:02:23,779 Finished 11 from 16 processes
2024-04-28 19:02:28,782 Finished 11 from 16 processes
2024-04-28 19:02:33,786 Finished 11 from 16 processes
2024-04-28 19:02:38,790 Finished 11 from 16 processes
2024-04-28 19:02:43,796 Finished 11 from 16 processes
2024-04-28 19:02:48,798 Finished 11 from 16 processes
2024-04-28 19:02:53,802 Finished 11 from 16 processes
2024-04-28 19:02:58,806 Finished 11 from 16 processes
2024-04-28 19:03:03,810 Finished 11 from 16 processes
2024-04-28 19:03:08,815 Finished 11 from 16 processes
2024-04-28 19:03:13,819 Finished 12 from 16 processes
2024-04-28 19:03:18,825 Finished 12 from 16 processes
2024-04-28 19:03:23,826 Finished 12 from 16 processes
2024-04-28 19:03:28,830 Finished 12 from 16 processes
2024-04-28 19:03:33,834 Finished 12 from 16 processes
2024-04-28 19:03:38,840 Finished 12 from 16 processes
2024-04-28 19:03:43,842 Finished 12 from 16 processes
2024-04-28 19:03:48,846 Finished 12 from 16 processes
2024-04-28 19:03:53,850 Finished 12 from 16 processes
2024-04-28 19:03:58,856 Finished 12 from 16 processes
2024-04-28 19:04:03,858 Finished 12 from 16 processes
2024-04-28 19:04:08,862 Finished 12 from 16 processes
2024-04-28 19:04:13,866 Finished 12 from 16 processes
2024-04-28 19:04:18,872 Finished 12 from 16 processes
2024-04-28 19:04:23,874 Finished 12 from 16 processes
2024-04-28 19:04:28,878 Finished 12 from 16 processes
2024-04-28 19:04:33,884 Finished 13 from 16 processes
2024-04-28 19:04:38,886 Finished 13 from 16 processes
2024-04-28 19:04:43,890 Finished 13 from 16 processes
2024-04-28 19:04:48,894 Finished 13 from 16 processes
2024-04-28 19:04:53,900 Finished 13 from 16 processes
2024-04-28 19:04:58,902 Finished 13 from 16 processes
2024-04-28 19:05:03,906 Finished 13 from 16 processes
2024-04-28 19:05:08,912 Finished 13 from 16 processes
2024-04-28 19:05:13,914 Finished 13 from 16 processes
2024-04-28 19:05:18,918 Finished 13 from 16 processes
2024-04-28 19:05:23,924 Finished 13 from 16 processes
2024-04-28 19:05:28,926 Finished 13 from 16 processes
2024-04-28 19:05:33,932 Finished 13 from 16 processes
2024-04-28 19:05:38,937 Finished 13 from 16 processes
2024-04-28 19:05:43,942 Finished 13 from 16 processes
2024-04-28 19:05:48,946 Finished 13 from 16 processes
2024-04-28 19:05:53,952 Finished 13 from 16 processes
2024-04-28 19:05:58,954 Finished 13 from 16 processes
2024-04-28 19:06:03,960 Finished 13 from 16 processes
2024-04-28 19:06:08,964 Finished 13 from 16 processes
2024-04-28 19:06:13,970 Finished 14 from 16 processes
2024-04-28 19:06:18,975 Finished 14 from 16 processes
2024-04-28 19:06:23,980 Finished 14 from 16 processes
2024-04-28 19:06:28,985 Finished 14 from 16 processes
2024-04-28 19:06:33,990 Finished 14 from 16 processes
2024-04-28 19:06:38,994 Finished 14 from 16 processes
2024-04-28 19:06:43,998 Finished 14 from 16 processes
2024-04-28 19:06:49,004 Finished 14 from 16 processes
2024-04-28 19:06:54,009 Finished 14 from 16 processes
2024-04-28 19:06:59,012 Finished 14 from 16 processes
2024-04-28 19:07:04,014 Finished 14 from 16 processes
2024-04-28 19:07:09,018 Finished 14 from 16 processes
2024-04-28 19:07:14,024 Finished 14 from 16 processes
2024-04-28 19:07:19,026 Finished 14 from 16 processes
2024-04-28 19:07:24,032 Finished 14 from 16 processes
2024-04-28 19:07:29,037 Finished 14 from 16 processes
2024-04-28 19:07:34,040 Finished 15 from 16 processes
2024-04-28 19:07:39,042 Finished 15 from 16 processes
2024-04-28 19:07:44,048 Finished 15 from 16 processes
2024-04-28 19:07:49,053 Finished 15 from 16 processes
2024-04-28 19:07:54,058 Finished 15 from 16 processes
2024-04-28 19:07:59,062 All processes finished
2024-04-28 19:07:59,062 Compressing stress logs
2024-04-28 19:07:59,104 Logs compressed
2024-04-28 19:07:59,105 Will terminate gdb (if any)
Quit
2024-04-28 19:13:04,386 Checking if some queries hung
Using queries from '/usr/share/clickhouse-test/queries' directory
Connecting to ClickHouse server... OK
Running 1 stateless tests (MainProcess).
00001_select_1: [ OK ]
1 tests passed. 0 tests skipped. 0.37 s elapsed (MainProcess).
Won't run stateful tests because test data wasn't loaded.
No queries hung.
All tests have finished.
Top patterns of log messages:
count count_% size size_% uniq_loggers uniq_threads levels background_% message_format_string
UInt64 Float64 String Float64 UInt64 UInt64 Array(String) Float64 LowCardinality(String)
16379 0.051 2.54 MiB 0.061 1 188 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {})
15862 0.049 2.37 MiB 0.057 3 188 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {}
14863 0.046 1.10 MiB 0.026 1 548 ['Debug'] 0.153 Remove from cache. Key: {}, offset: {}, size: {}
14733 0.046 415.94 KiB 0.01 1 188 ['Debug'] 0 Processed in {} sec.
14699 0.046 875.62 KiB 0.021 1 98 ['Debug'] 0.983 Key {} is removed from metadata
12579 0.039 724.77 KiB 0.017 1 453 ['Debug'] 0.028 Submitting key {} for removal
12006 0.037 690.69 KiB 0.016 5 381 ['Trace'] 0.005 Access granted: {}{}
8384 0.026 681.57 KiB 0.016 1 180 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec.
7479 0.023 182.41 KiB 0.004 1 285 ['Trace'] 0.015 {} -> {}
6691 0.021 611.93 KiB 0.014 1 1555 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.)
6565 0.02 294.20 KiB 0.007 1 1 ['Trace'] 1 Processing requests batch, size: {}, bytes: {}
5567 0.017 456.39 KiB 0.011 4 220 ['Debug'] 0.994 {} Authenticating user \'{}\' from {}
5565 0.017 624.98 KiB 0.015 4 220 ['Debug'] 0.994 {} Authenticated with global context as user {}
5551 0.017 487.88 KiB 0.011 4 220 ['Debug'] 0.994 {} Logout, user_id: {}
5531 0.017 604.95 KiB 0.014 3 188 ['Debug'] 1 {} Creating session context with user_id: {}
5324 0.017 238.35 KiB 0.006 1 195 ['Debug'] 0.134 Peak memory usage{}: {}.
5198 0.016 284.51 KiB 0.007 1 543 ['Trace'] 0.192 Created HTTP(S) session with {}:{} ({}:{})
5129 0.016 150.36 KiB 0.004 1 1417 ['Trace'] 0 Aggregation method: {}
4809 0.015 1.44 MiB 0.035 4120 593 ['Information'] 0.001 Setting download as failed: {}
4610 0.014 151.45 KiB 0.004 1 188 ['Trace'] 1 TCP Request. Address: {}
4610 0.014 429.49 KiB 0.01 1 188 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}.
4553 0.014 120.05 KiB 0.003 1 188 ['Debug'] 1 Done processing connection.
4281 0.013 298.57 KiB 0.007 1 58 ['Trace'] 0 No entry found for query {}
4161 0.013 335.41 KiB 0.008 3629 532 ['Trace'] 0 No space left in cache to reserve {} bytes, will continue without cache download
4131 0.013 377.77 KiB 0.009 1 375 ['Debug'] 0.014 Will evict {} file segments (while reserving {} bytes for {}:{})
3982 0.012 472.76 KiB 0.011 214 250 ['Trace'] 0.576 Renaming temporary part {} to {} with tid {}.
3762 0.012 179.65 KiB 0.004 1 245 ['Trace'] 0.575 filled checksums {}
3740 0.012 427.32 KiB 0.01 1475 746 ['Trace'] 0 Bypassing cache because file segment state is `PARTIALLY_DOWNLOADED_NO_CONTINUATION` and downloaded part already used
3685 0.011 255.54 KiB 0.006 217 356 ['Trace'] 0.754 Trying to reserve {} using storage policy from min volume index {}
3349 0.01 1.80 MiB 0.043 1 142 ['Debug'] 0.98 Objects with paths [{}] were removed from S3
3147 0.01 33.81 KiB 0.001 1 1045 ['Trace'] 0 Aggregating
3039 0.009 252.53 KiB 0.006 1 1233 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={}
2998 0.009 281.67 KiB 0.007 1 29 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part
2913 0.009 3.93 MiB 0.094 1 117 ['Debug'] 0.987 metadata and objects were removed for [{}], only metadata were removed for [{}].
2642 0.008 219.17 KiB 0.005 1 75 ['Trace'] 0.003 Reading {} ranges in order from part {}, approx. {} rows starting from {}
2628 0.008 190.58 KiB 0.004 1 69 ['Trace'] 0.013 PREWHERE condition was split into {} steps: {}
2168 0.007 672.38 KiB 0.016 2 7 ['Error'] 0 Number of arguments for function {} doesn\'t match: passed {}, should be {}
2150 0.007 77.14 KiB 0.002 11 11 ['Trace'] 1 Flushed system log up to offset {}
2150 0.007 124.15 KiB 0.003 11 11 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {}
1716 0.005 113.08 KiB 0.003 1 115 ['Debug'] 0 Will kill query {} (synchronously)
1696 0.005 50.84 KiB 0.001 32 742 ['Trace'] 0.006 Found (RIGHT) boundary mark: {}
1696 0.005 49.34 KiB 0.001 32 742 ['Trace'] 0.006 Found {} range in {} steps
1696 0.005 115.28 KiB 0.003 32 742 ['Trace'] 0.006 Running binary search on index range for part {} ({} marks)
1696 0.005 49.14 KiB 0.001 32 742 ['Trace'] 0.006 Found (LEFT) boundary mark: {}
1694 0.005 196.49 KiB 0.005 1 19 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {}
1596 0.005 123.13 KiB 0.003 1 151 ['Trace'] 0 Query span trace_id for opentelemetry log: {}
1217 0.004 27.33 KiB 0.001 1 755 ['Trace'] 0 Merging aggregated data
1176 0.004 322.99 KiB 0.008 2 4 ['Error'] 0 Illegal type {} of argument of function {}
1053 0.003 309.27 KiB 0.007 1 23 ['Trace'] 0.983 Got dangerous response with successful code {}, checking its body: \'{}\'
1037 0.003 112.42 KiB 0.003 1 16 ['Trace'] 0.99 Single operation copy has completed. Bucket: {}, Key: {}, Object size: {}
1037 0.003 65.83 KiB 0.002 1 16 ['Trace'] 0.99 Object {} exists after upload
1037 0.003 74.94 KiB 0.002 1 16 ['Trace'] 0.99 Checking object {} exists after upload
1018 0.003 189.40 KiB 0.004 2 82 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {}
1016 0.003 503.34 KiB 0.012 2 82 ['Trace'] 1 Request URI: {}
998 0.003 20.47 KiB 0 2 82 ['Debug'] 0.093 Done processing query
937 0.003 27.55 KiB 0.001 159 115 ['Debug'] 0.031 Key condition: {}
903 0.003 105.27 KiB 0.002 152 108 ['Debug'] 0.032 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges
834 0.003 41.15 KiB 0.001 1 100 ['Trace'] 0 Merging partially aggregated blocks (bucket = {}).
834 0.003 126.58 KiB 0.003 1 100 ['Debug'] 0 Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.)
801 0.002 102.39 KiB 0.002 13 29 ['Debug'] 0 Part: {}, sum_marks: {}, approx mark size: {}, prefetch_step_bytes: {}, prefetch_step_marks: {}, (ranges: {})
785 0.002 17.15 KiB 0 84 133 ['Trace'] 1 Execution took {} ms.
721 0.002 33.06 KiB 0.001 1 501 ['Debug'] 0 Aggregated. {} to {} rows (from {})
701 0.002 36.28 KiB 0.001 130 92 ['Trace'] 0.041 Spreading mark ranges among streams (default reading)
700 0.002 13.67 KiB 0 1 492 ['Trace'] 0 Aggregating in order
697 0.002 36.62 KiB 0.001 58 143 ['Debug'] 0.89 Selected {} parts from {} to {}
678 0.002 23.16 KiB 0.001 1 29 ['Debug'] 0 Selected MergeAlgorithm: {}
678 0.002 55.96 KiB 0.001 1 29 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {}
675 0.002 27.03 KiB 0.001 1 489 ['Trace'] 0 Converting aggregation data to two-level.
673 0.002 88.04 KiB 0.002 1 29 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec.
673 0.002 43.30 KiB 0.001 53 29 ['Trace'] 0 Merged {} parts: [{}, {}] -> {}
623 0.002 9.73 KiB 0 76 77 ['Debug'] 1 Scheduling tasks
617 0.002 40.92 KiB 0.001 4 24 ['Debug'] 1 There is no part {} in ZooKeeper, it was only in filesystem
616 0.002 139.25 KiB 0.003 76 77 ['Trace'] 1 scheduleTasks: initialized={}, size_before_filtering={}, queue_size={}, entries={}..{}, first_failed_task_name={}, current_tasks_size={}, last_current_task={}, last_skipped_entry_name={}
616 0.002 15.04 KiB 0 76 77 ['Debug'] 1 Waiting for queue updates
614 0.002 75.96 KiB 0.002 190 111 ['Debug'] 0.972 Removing {} parts from filesystem (serially): Parts: [{}]
609 0.002 58.10 KiB 0.001 72 72 ['Debug'] 1 Will not execute task {}: {}
609 0.002 116.58 KiB 0.003 1 126 ['Information'] 1 Removing metadata {} of dropped table {}
609 0.002 45.20 KiB 0.001 1 63 ['Debug'] 0 Waiting for table {} to be finally dropped
609 0.002 30.93 KiB 0.001 75 76 ['Debug'] 1 Will schedule {} tasks starting from {}
609 0.002 17.84 KiB 0 72 72 ['Trace'] 1 Checking task {}
609 0.002 75.16 KiB 0.002 1 126 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {}
589 0.002 93.35 KiB 0.002 1 122 ['Debug'] 0.964 Recursively remove path {}: metadata and objects were removed for [{}], only metadata were removed for [{}].
546 0.002 1.67 MiB 0.04 2 39 ['Error'] 0 Query was cancelled
542 0.002 22.70 KiB 0.001 1 30 ['Debug'] 0 ({}) Keys: {}
542 0.002 70.50 KiB 0.002 1 30 ['Debug'] 0 ({}) Datatype: {}, kind: {}, strictness: {}, right header: {}
541 0.002 43.86 KiB 0.001 1 32 ['Trace'] 0.007 ({}) Join data is being destroyed, {} bytes and {} rows in hash table
537 0.002 146.83 KiB 0.003 27 45 ['Debug'] 0 Processing task {} ({})
537 0.002 37.76 KiB 0.001 27 45 ['Debug'] 0 Waiting for worker thread to process all entries before {}
537 0.002 48.40 KiB 0.001 27 27 ['Trace'] 1 Waiting for initiator {} to commit or rollback entry {}
537 0.002 137.39 KiB 0.003 27 45 ['Debug'] 0 Executing query: {}
537 0.002 132.80 KiB 0.003 27 45 ['Debug'] 0 Proposing query: {}
525 0.002 152.99 KiB 0.004 27 45 ['Debug'] 0 Executed query: {}
497 0.002 20.87 KiB 0 29 29 ['Trace'] 1 Too early to clean queue, will do it later.
497 0.002 50.34 KiB 0.001 380 265 ['Trace'] 0 Predownload failed because of space limit. Will read from remote filesystem starting from offset: {}
481 0.001 34.97 KiB 0.001 1 77 ['Trace'] 0.029 The min valid primary key position for moving to the tail of PREWHERE is {}
458 0.001 41.45 KiB 0.001 1 396 ['Debug'] 0 Merge sorted {} blocks, {} rows in {} sec., {} rows/sec., {}/sec
456 0.001 116.58 KiB 0.003 1 8 ['Information'] 0.752 WriteBufferFromS3 is not finalized in destructor. The file might not be written to S3. {}.
449 0.001 51.82 KiB 0.001 36 30 ['Trace'] 0.971 Found {} old parts to remove. Parts: [{}]
449 0.001 52.26 KiB 0.001 36 30 ['Debug'] 0.971 Removing {} parts from memory: Parts: [{}]
440 0.001 15.37 KiB 0 47 69 ['Debug'] 0 MinMax index condition: {}
Top messages without format string (fmt::runtime):
count pattern runtime_message line
UInt64 String String Tuple(String, UInt64)
6 CodeDBExceptionSyntaxerrorfailed Code: 62. DB::Exception: Syntax error: failed at position 8 (\'1\'): 1. Max query size exceeded: \'1\'. (SYNTAX_ERROR) (version 23.8.11.29.altinitystable (altinity build)) (from [::ffff:127.0.0.1]:46588) (comment: 00612_h) (in query: select ), Stack trace (whe ('/executeQuery.cpp',207)
4 CodeDBExceptionReceivedfromDBExc Code: 507. DB::Exception: Received from 127.0.0.2:9000. DB::Exception: Sharding key modulo(sub_key, 2) is not used. Stack trace:\n\n0. std::exception::capture() @ 0x000000001dadbbf5 in /usr/bin/clickhouse\n1. ./build_docker/./base/poco/Foundation/src/Exceptio ('/executeQuery.cpp',207)
3 CodeDBExceptionCannotmodifyminco Code: 164. DB::Exception: Cannot modify \'min_compress_block_size\' setting in readonly mode. (READONLY), Stack trace (when copying this message, always include the lines below):\n\n0. std::exception::capture() @ 0x000000001dadbbf5 in /usr/bin/clickhouse\n1. ./ ('/TCPHandler.cpp',680)
3 PocoExceptionCodeecodeIOerrorBro Poco::Exception. Code: 1000, e.code() = 32, I/O error: Broken pipe, Stack trace (when copying this message, always include the lines below):\n\n0. std::exception::capture() @ 0x000000001dadbbf5 in /usr/bin/clickhouse\n1. ./build_docker/./base/poco/Foundation/ ('/Exception.cpp',235)
2 PocoExceptionCodeecodeNetExcepti Poco::Exception. Code: 1000, e.code() = 107, Net Exception: Socket is not connected, Stack trace (when copying this message, always include the lines below):\n\n0. std::exception::capture() @ 0x000000001dadbbf5 in /usr/bin/clickhouse\n1. ./build_docker/./base ('/Exception.cpp',235)
2 CodeDBExceptionCouldnotlistobjec Code: 499. DB::Exception: Could not list objects in bucket \'datasets-documentation\' with prefix \'MyPrefix/BU - UNIT - 1/\', S3 exception: `InvalidAccessKeyId`, message: \'The AWS Access Key Id you provided does not exist in our records.\'. (S3_ERROR) (version ('/executeQuery.cpp',207)
2 CodeDBExceptionReceivedfromlocal Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: There\'s no column \'a._shard_num\' in table \'a\': While processing a._shard_num: While processing ALL INNER JOIN ... ON a._shard_num = b.shard_num. Stack trace:\n\n0. std::exception::captur ('/executeQuery.cpp',207)
2 CodeDBExceptionCannotmodifygroup Code: 164. DB::Exception: Cannot modify \'group_by_use_nulls\' setting in readonly mode. (READONLY), Stack trace (when copying this message, always include the lines below):\n\n0. std::exception::capture() @ 0x000000001dadbbf5 in /usr/bin/clickhouse\n1. ./build ('/TCPHandler.cpp',680)
2 CodeDBErrnoExceptionCannotrename Code: 521. DB::ErrnoException: Cannot rename /var/lib/clickhouse/metadata/test.sql.tmp to /var/lib/clickhouse/metadata/test.sql because the second path already exists, errno: 17, strerror: File exists. (ATOMIC_RENAME_FAIL) (version 23.8.11.29.altinitystabl ('/executeQuery.cpp',207)
1 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',42)
1 Thesettingmergetreemetadatacache The setting \'merge_tree_metadata_cache\' is enabled. But the feature of \'metadata cache in RocksDB\' is experimental and is not ready for production. The usage of this feature can lead to data corruption and loss. The setting should be disabled in production ('',0)
1 TablesystemsessionlogisenabledIt Table system.session_log is enabled. It\'s unreliable and may contain garbage. Do not use it for any kind of security monitoring. ('',0)
1 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',42)
1 ThreadFuzzerisenabledApplication ThreadFuzzer is enabled. Application will run slowly and unstable. ('',0)
1 newconfigurationlogidxprevlogidx new configuration: log idx 92, prev log idx 18\npeer 1, DC ID 0, localhost:9234, voting member, 1\nmy id: 1, leader: 1, term: 3 ('/LoggerWrapper.h',42)
1 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',42)
1 statemachinecommitindexprecommit state machine commit index 91, precommit index 91, last log index 91 ('/LoggerWrapper.h',42)
1 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',42)
1 Forkedachildprocesstowatch Forked a child process to watch ('',0)
1 IfthesignaturecheckfailedThiscou If the signature check failed. This could be because of a time skew. Attempting to adjust the signer. ('/AWSLogger.cpp',71)
1 INITRAFTSERVERcommitindextermele === INIT RAFT SERVER ===\ncommit index 91\nterm 2\nelection timer allowed\nlog store start 1, end 91\nconfig log idx 18, prev log idx 1 ('/LoggerWrapper.h',42)
1 configatindexiscommittedprevconf config at index 92 is committed, prev config log idx 18 ('/LoggerWrapper.h',42)
1 Thesettingallowremotefszerocopyr The setting \'allow_remote_fs_zero_copy_replication\' is enabled for MergeTree tables. But the feature of \'zero-copy replication\' is under development and is not ready for production. The usage of this feature can lead to data corruption and loss. The settin ('',0)
1 newconfiglogidxprevlogidxcurconf new config log idx 92, prev log idx 18, cur config log idx 18, prev log idx 1 ('/LoggerWrapper.h',42)
1 ELECTIONTIMEOUTcurrentrolefollow [ELECTION TIMEOUT] current role: follower, log last term 2, state term 2, target p 1, my p 1, hb dead, pre-vote NOT done ('/LoggerWrapper.h',42)
1 peerDCIDlocalhostvotingmembermyi peer 1: DC ID 0, localhost:9234, voting member, 1\nmy id: 1, voting_member\nnum peers: 0 ('/LoggerWrapper.h',42)
1 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 92 ('/LoggerWrapper.h',42)
1 ServerwasbuiltwithsanitizerItwil Server was built with sanitizer. It will work slowly. ('',0)
1 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',42)
1 startingup starting up ('',0)
Top messages that does not match its format string:
message_format_string count() any_message
LowCardinality(String) UInt64 String
{} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 161 /var/lib/clickhouse/disks/s3_disk/store/443/443369b9-671c-4320-a642-f5a3080690b6/tmp_merge_201403_5_21_1/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 1 similar messages)
34 Forked a child process to watch
(from {}{}{}){}{} {} (stage: {}) 2 (from [::1]:55722) (comment: 02683_native_too_large_size.sql) SELECT * FROM format(\'Native\', \'WatchID Int64, JavaEnable Int16, Title String, GoodEvent Int16, EventTime DateTime, EventDate Date, CounterID Int32, ClientIP Int32, RegionID Int32, UserID Int64, CounterClass Int16, OS Int16, UserAgent Int16, URL String, Referer String, IsRefresh Int16, RefererCategoryID Int16, RefererRegionID Int32, URLCategoryID Int16, URLRegionID Int32, ResolutionWidth Int16, ResolutionHeight Int16, ResolutionDepth Int16, FlashMajor Int16, FlashMinor Int16, FlashMinor2 String, NetMajor Int16, NetMinor Int16, UserAgentMajor Int16, UserAgentMinor String, CookieEnable Int16, JavascriptEnable Int16, IsMobile Int16, MobilePhone Int16, MobilePhoneModel String, Params String, IPNetworkID Int32, TraficSourceID Int16, SearchEngineID Int16, SearchPhrase String, AdvEngineID Int32, IsArtifical Int16, WindowClientWidth Int16, WindowClientHeight Int16, ClientTimeZone Int16, ClientEventTime DateTime, SilverlightVersion1 Int16, SilverlightVersion2 Int16, SilverlightVersion3 Int32, SilverlightVersion4 Int16, PageCharset String, CodeVersion Int32, IsLink Int16, IsDownload Int16, IsNotBounce Int16, FUniqID Int64, OriginalURL String, HID Int32, IsOldCounter Int16, IsEvent Int16, IsParameter Int16, DontCountHits Int16, WithHash Int16, HitColor String, LocalEventTime DateTime, Age Int16, Sex Int16, Income Int16, Interests Int16, Robotness Int16, RemoteIP Int32, VindowName Int32, OpenerName Int32, HistoryLength Int16, BrowserLanguage String, BrowserCountry String, SocialNetwork String, SocialAction String, HTTPError Int16, SendTiming Int32, DNSTiming Int32, ConnectTiming Int32, ResponseStartTiming Int32, ResponseEndTiming Int32, FetchTiming Int32, SocialSourceNetworkID Int16, SocialSourcePage String, ParamPrice Int64, ParamOrderID String, ParamCurrency String, ParamCurrencyID Int16, OpenstatServiceName String, OpenstatCampaignID String, OpenstatAdID String, OpenstatSourceID String, UTMSource String, UTMMedium String, UTMCampaign String, UTMContent String, UTMTerm String, FromTag String, HasGCLID Int16, RefererHash Int64, URLHash Int64, CLID Int32\', $$i\nWatchIDInt64c*5/ !p~��F�ӓ2ql!�|�@H�ǐ=ЌW��E&Ly��k=��p�1��o�C»-�C_���\\�/E��J�{\nJavaEnableInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0TitleString\0\0\0\0\0\0\0\0\0\0\tGoodEventInt16\0\0\0\0\0\0\0\0\0\0\tEventTime\bDateTime7��Qn$�Q�)�Q8*�QJ��Q�\f�Q�0�Q83�Q� �Q�1�Q\tEventDateDate>>>>>>>>>>\tCounterIDInt32\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\bClientIPInt32��z���z���z���z���I`��z��^{]�^{]�gU��z�\bRegionIDInt32G\0\0G\0\0G\0\0G\0\0\'\0\0\0G\0\0�\0\0\0�\0\0\0�\0\0\0G\0\0UserIDInt64� ��:6��� ��:6��� ��:6��� ��:6��q��Jd8\r�Ks}��&n%�t"6&n%�t"6�s�yy��f� ��:6��\fCounterClassInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0OSInt16\0\0\0\0\0\0\0\0\0\0\'\0\'\0,\0\0\0\tUserAgentInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0URLString\0\0\0\0-http://holodilInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0WindowClientWidthInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0WindowClientHeightInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0ClientTimeZoneInt16��������������������ClientEventTime\bDateTime��������������������SilverlightVersion1Int16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0SilverlightVersion2Int16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0SilverlightVersion3Int32\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0SilverlightVersion4Int16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0PageCharsetString\0\0\0\0\0\0\0\0\0\0CodeVersionInt32\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0IsLinkInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\nIsDownloadInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0IsNotBounceInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0FUniqIDInt64\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0%�l��+k:��W��m\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0OriginalURLString\0\0\0\0\0\0\0\0\0\0HIDInt32\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\fIsOldCounterInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0IsEventInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0IsParameterInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\rDontCountHitsInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\bWithHashInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\bHitColorString5555555555LocalEventTime\bDateTime&��Qǘ�Q}��Qݞ�Q\'��QA��Q���Q\n��QY��Q���QAgeInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0SexInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0IncomeInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\tInterestsInt16\0\0\0\0\0\0\0\0�:\0\0\0\0\0\0\0\0\0\0\tRobotnessInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\bRemoteIPInt32^DI�^DI�^DI�^DI�9�3N^DI��U�U�=k^DI�\nWindowNameInt32����������������������������������������\nOpenerNameInt32����������������������������������������\rHistoryLengthInt16��������������������BrowserLanguageString����������BrowserCountryString�\f�\f�\f�\f�\f�\f�\f�\f�\f�\f\rSocialNetworkString\0\0\0\0\0\0\0\0\0\0\fSocialActionString\0\0\0\0\0\0\0\0\0\0\tHTTPErrorInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\nSendTimingInt32\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\tDNSTimingInt32\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\rConnectTimingInt32\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0ResponseStartTimingInt32\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0ResponseEndTimingInt32\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0FetchTimingInt32\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0SocialSourceNetworkIDInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0SocialSourcePageString\0\0\0\0\0\0\0\0\0\0\nParamPriceInt64\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\fParamOrderIDString\0\0\0\0\0\0\0\0\0\0\rParamCurrencyStringNHNHNHNHNHNHNHNHNHNHParamCurrencyIDInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0OpenstatServiceNameString\0\0\0\0\0\0\0\0\0\0OpenstatCampaignIDString\0\0\0\0\0\0\0\0\0\0\fOpenstatAdIDString\0\0\0\0\0\0\0\0\0\0OpenstatSourceIDString\0\0\0\0\0\0\0\0\0\0\tUTMSourceString\0\0\0\0\0\0\0\0\0\0\tUTMMediumString\0\0\0\0\0\0\0\0\0\0UTMCampaignString\0\0\0\0\0\0\0\0\0\0\nUTMContentString\0\0\0\0\0\0\0\0\0\0UTMTermString\0\0\0\0\0\0\0\0\0\0FromTagString\0\0\0\0\0\0\0\0\0\0\bHasGCLIDInt16\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0RefererHashInt64X+��\'���X+��\'���X+��\'���X+��\'���X+��\'���X+��\'���X+��\'���X+��\'���X+��\'���X+��\'���URLHashInt64�|3��b.��|3��b.��|3��b.��|3��b.��\no���e��\r�#�\\X-h��X v�v����h��9�D�|3��b.�CLIDInt32\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0$$); (stage: Complete)
Top short messages:
c message_format_string substring(any(message), 1, 120) min_length_without_exception_boilerplate
UInt64 LowCardinality(String) String Int64
45 Resetting nice Resetting nice -12
4 Session expired void DB::StorageReplicatedMergeTree::queueUpdatingTask(): Code: 999. Coordination::Exception: Session expired. (KEEPER_E 27
3 Found {} on {} Found snapshot_91.bin.zstd on LocalSnapshotDisk 21
2 Froze {} parts Froze 1 parts -13
Top messages by level:
(0.006731414093743014,'Number of arguments for function {} doesn\'t match: passed {}, should be {}') Error
(0.000978042176904543,'Part {} doesn\'t have metadata version on disk, setting it to {}. It\'s okay if the part was created by an old version of ClickHouse') Warning
(0.014931443900742691,'Setting download as failed: {}') Information
(0.05085508830323655,'(from {}{}{}){}{} {} (stage: {})') Debug
(0.049249857174793216,'{} Creating query context from {} context, user_id: {}, parent context user: {}') Trace
2024-04-28 19:13:08,009 Stress test finished
+ echo -e 'Test script exit code\tOK\t\N\t'
+ grep -Fa OK
+ rg -Fa 'No queries hung' /test_output/test_results.tsv
No queries hung OK \N
+ stop
+ local max_tries=90
+ local check_hang=true
+ local pid
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ pid=1772
+ clickhouse stop --max-tries 90 --do-not-kill
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1772.
The process with pid = 1772 is running.
Sent terminate signal to process with pid 1772.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1772.
The process with pid = 1772 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1772.
The process with pid = 1772 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1772.
The process with pid = 1772 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1772.
The process with pid = 1772 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1772.
The process with pid = 1772 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1772.
The process with pid = 1772 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1772.
The process with pid = 1772 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1772.
The process with pid = 1772 does not exist.
Server stopped
+ return
+ mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ unset THREAD_FUZZER_CPU_TIME_PERIOD_US THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY THREAD_FUZZER_SLEEP_PROBABILITY THREAD_FUZZER_SLEEP_TIME_US THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US
+ start
+ counter=0
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
127.0.0.1 - - [28/Apr/2024:17:13:16 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 -
127.0.0.1 - - [28/Apr/2024:17:13:16 +0000] "PUT /devstoreaccount1/cont/xhxphvsmhrciosdelkpvgoskpsusmezu?blockid=hcypkdzdzsojdcprhwtpdcqhzscqgdjbqruwaxwqjvscndqavriskpehpfxateli&comp=block HTTP/1.1" 201 -
127.0.0.1 - - [28/Apr/2024:17:13:16 +0000] "PUT /devstoreaccount1/cont/xhxphvsmhrciosdelkpvgoskpsusmezu?comp=blocklist HTTP/1.1" 201 -
127.0.0.1 - - [28/Apr/2024:17:13:16 +0000] "GET /devstoreaccount1/cont/xhxphvsmhrciosdelkpvgoskpsusmezu HTTP/1.1" 206 4
127.0.0.1 - - [28/Apr/2024:17:13:16 +0000] "GET /devstoreaccount1/cont/xhxphvsmhrciosdelkpvgoskpsusmezu HTTP/1.1" 206 2
127.0.0.1 - - [28/Apr/2024:17:13:16 +0000] "DELETE /devstoreaccount1/cont/xhxphvsmhrciosdelkpvgoskpsusmezu HTTP/1.1" 202 -
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ kill -l SIGRTMIN
+ RTMIN=34
+ echo '
set follow-fork-mode parent
handle SIGHUP nostop noprint pass
handle SIGINT nostop noprint pass
handle SIGQUIT nostop noprint pass
handle SIGPIPE nostop noprint pass
handle SIGTERM nostop noprint pass
handle SIGUSR1 nostop noprint pass
handle SIGUSR2 nostop noprint pass
handle SIG34 nostop noprint pass
info signals
continue
backtrace full
thread apply all backtrace full
info registers
disassemble /s
up
disassemble /s
up
disassemble /s
p "done"
detach
quit
'
+ sleep 5
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ gdb -batch -command script.gdb -p 26799
+ ts '%Y-%m-%d %H:%M:%S'
+ run_with_retry 60 clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
+ [[ hxB =~ e ]]
+ set_e=false
+ set +e
+ local total_retries=60
+ shift
+ local retry=0
+ '[' 0 -ge 60 ']'
+ clickhouse-client --query 'SELECT '\''Connected to clickhouse-server after attaching gdb'\'''
Connected to clickhouse-server after attaching gdb
+ false
+ return
+ check_server_start
+ clickhouse-client --query 'SELECT '\''Server successfully started'\'', '\''OK'\'', NULL, '\'''\'''
+ '[' -s /test_output/application_errors.txt ']'
+ rm /test_output/application_errors.txt
rm: cannot remove '/test_output/application_errors.txt': No such file or directory
+ stop
+ local max_tries=90
+ local check_hang=true
+ local pid
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ pid=26799
+ clickhouse stop --max-tries 90 --do-not-kill
API: PutObjectPart(bucket=test, object=common/vck/jvlghzwopicywbkfzrvsvvoduzudl)
Time: 17:14:20 UTC 04/28/2024
DeploymentID: 46822fa5-a95d-4274-82e6-f795eb7b3048
RequestID: 17CA810398E43860
RemoteHost: ::1
Host: localhost:11111
UserAgent: aws-sdk-cpp/1.11.61 Linux/5.15.0-73-generic x86_64 Clang/16.0.6
Error: open /minio_data/.minio.sys/multipart/555ee18b57969449c6cb6fc990034b31dd784771553d9d117d303bf8df54599b/ac2cffba-3d48-4c24-b9d5-81b93dca752e/00002.bb66f4eee7c546a4b3ed1c999ba9ca6a.16777216: no such file or directory (*fs.PathError)
uploadID=ac2cffba-3d48-4c24-b9d5-81b93dca752e, partPath=/minio_data/.minio.sys/multipart/555ee18b57969449c6cb6fc990034b31dd784771553d9d117d303bf8df54599b/ac2cffba-3d48-4c24-b9d5-81b93dca752e/00002.bb66f4eee7c546a4b3ed1c999ba9ca6a.16777216, filepath=/minio_data/.minio.sys/tmp/16727f66-7e37-4bc1-b4c4-e4bdd00c231f/ac2cffba-3d48-4c24-b9d5-81b93dca752e.736e6f83-cc94-4ced-b79d-3fab08398e37
1: cmd/fs-v1-multipart.go:121:cmd.(*FSObjects).backgroundAppend()
script.gdb:13: Error in sourced command file:
No stack.
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 26799.
The process with pid = 26799 is running.
Sent terminate signal to process with pid 26799.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 26799.
The process with pid = 26799 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 26799.
The process with pid = 26799 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 26799.
The process with pid = 26799 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 26799.
The process with pid = 26799 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 26799.
The process with pid = 26799 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ '[' -f /var/log/clickhouse-server/clickhouse-server.log ']'
+ '[' -f /var/log/clickhouse-server/stderr.log ']'
+ mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.final.log
+ check_logs_for_critical_errors
+ rg -Fa ================== /var/log/clickhouse-server/stderr.log
+ rg -v 'in query:'
+ rg -Fa WARNING /var/log/clickhouse-server/stderr.log
+ rg -Fav -e 'ASan doesn'\''t fully support makecontext/swapcontext functions' -e DB::Exception /test_output/tmp
+ echo -e 'No sanitizer asserts\tOK\t\N\t'
+ rm -f /test_output/tmp
+ rg -Fa ' Application: Child process was terminated by signal 9' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No OOM messages in clickhouse-server.log\tOK\t\N\t'
+ rg -Fa 'Code: 49. DB::Exception: ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No logical errors\tOK\t\N\t'
+ '[' -s /test_output/logical_errors.txt ']'
+ rm /test_output/logical_errors.txt
+ rg --text 'Code: 499.*The specified key does not exist' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No lost s3 keys\tOK\t\N\t'
+ '[' -s /test_output/no_such_key_errors.txt ']'
+ rm /test_output/no_such_key_errors.txt
+ rg -Fa '########################################' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'Not crashed\tOK\t\N\t'
+ rg -Fa ' ' /var/log/clickhouse-server/clickhouse-server.err.log /var/log/clickhouse-server/clickhouse-server.final.log /var/log/clickhouse-server/clickhouse-server.initial.log /var/log/clickhouse-server/clickhouse-server.stress.log
+ echo -e 'No fatal messages in clickhouse-server.log\tOK\t\N\t'
+ '[' -s /test_output/fatal_messages.txt ']'
+ rm /test_output/fatal_messages.txt
+ rg -Faz '########################################' /test_output/gdb.log /test_output/stress_run_logs.tar.zst /test_output/test_results.tsv
+ rg -Fa ' received signal ' /test_output/gdb.log
+ dmesg -T
+ grep -q -F -e 'Out of memory: Killed process' -e 'oom_reaper: reaped process' -e oom-kill:constraint=CONSTRAINT_NONE /test_output/dmesg.log
+ echo -e 'No OOM in dmesg\tOK\t\N\t'
+ tar -chf /test_output/coordination.tar /var/lib/clickhouse/coordination
tar: Removing leading `/' from member names
tar: Removing leading `/' from hard link targets
+ collect_query_and_trace_logs
+ for table in query_log trace_log
+ clickhouse-local --path /var/lib/clickhouse/ --only-system-tables -q 'select * from system.query_log format TSVWithNamesAndTypes'
+ zstd --threads=0
+ for table in query_log trace_log
+ clickhouse-local --path /var/lib/clickhouse/ --only-system-tables -q 'select * from system.trace_log format TSVWithNamesAndTypes'
+ zstd --threads=0
+ mv /var/log/clickhouse-server/stderr.log /test_output/
+ clickhouse-local --structure 'test String, res String, time Nullable(Float32), desc String' -q 'SELECT '\''failure'\'', test FROM table WHERE res != '\''OK'\'' order by
(test like '\''%Sanitizer%'\'') DESC,
(test like '\''%Killed by signal%'\'') DESC,
(test like '\''%gdb.log%'\'') DESC,
(test ilike '\''%possible deadlock%'\'') DESC,
(test like '\''%start%'\'') DESC,
(test like '\''%dmesg%'\'') DESC,
(test like '\''%OOM%'\'') DESC,
(test like '\''%Signal 9%'\'') DESC,
(test like '\''%Fatal message%'\'') DESC,
rowNumberInAllBlocks()
LIMIT 1'
+ '[' -s /test_output/check_status.tsv ']'
+ echo -e 'success\tNo errors found'
+ rg 'OOM in dmesg|Signal 9' /test_output/check_status.tsv
+ collect_core_dumps
+ find . -type f -maxdepth 1 -name 'core.*'
+ read core