+ 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.16.43.altinitystable+ubsan_amd64.deb
Selecting previously unselected package clickhouse-common-static.
(Reading database ... 58488 files and directories currently installed.)
Preparing to unpack .../clickhouse-common-static_23.8.16.43.altinitystable+ubsan_amd64.deb ...
Unpacking clickhouse-common-static (23.8.16.43.altinitystable+ubsan) ...
Setting up clickhouse-common-static (23.8.16.43.altinitystable+ubsan) ...
+ dpkg -i package_folder/clickhouse-common-static-dbg_23.8.16.43.altinitystable+ubsan_amd64.deb
Selecting previously unselected package clickhouse-common-static-dbg.
(Reading database ... 58502 files and directories currently installed.)
Preparing to unpack .../clickhouse-common-static-dbg_23.8.16.43.altinitystable+ubsan_amd64.deb ...
Unpacking clickhouse-common-static-dbg (23.8.16.43.altinitystable+ubsan) ...
Setting up clickhouse-common-static-dbg (23.8.16.43.altinitystable+ubsan) ...
+ dpkg -i package_folder/clickhouse-server_23.8.16.43.altinitystable+ubsan_amd64.deb
Selecting previously unselected package clickhouse-server.
(Reading database ... 58511 files and directories currently installed.)
Preparing to unpack .../clickhouse-server_23.8.16.43.altinitystable+ubsan_amd64.deb ...
Unpacking clickhouse-server (23.8.16.43.altinitystable+ubsan) ...
Setting up clickhouse-server (23.8.16.43.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.16.43.altinitystable+ubsan_amd64.deb
Selecting previously unselected package clickhouse-client.
(Reading database ... 58530 files and directories currently installed.)
Preparing to unpack .../clickhouse-client_23.8.16.43.altinitystable+ubsan_amd64.deb ...
Unpacking clickhouse-client (23.8.16.43.altinitystable+ubsan) ...
Setting up clickhouse-client (23.8.16.43.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
Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server
+ SRC_PATH=/usr/share/clickhouse-test/config
+ echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server'
+ mkdir -p /etc/clickhouse-server/config.d/
+ mkdir -p /etc/clickhouse-server/users.d/
+ mkdir -p /etc/clickhouse-client
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/disks.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/metadata_cache.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/reverse_dns_query_function.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/
+ '[' /etc/clickhouse-server = /etc/clickhouse-server ']'
+ ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/
+ ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ rm -f /etc/clickhouse-server/config.d/zookeeper.xml
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/
+ create_snapshot_on_exit=0
+ sed --follow-symlinks -i 's|true|0|' /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n '' ]]
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ARM=aarch64
++ uname -m
+ OS=x86_64
+ [[ -n 1 ]]
+ echo x86_64
+ [[ '' -eq 1 ]]
+ [[ x86_64 == \a\a\r\c\h\6\4 ]]
+ echo 'Adding azure configuration'
x86_64
Adding azure configuration
+ ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|100000|10000|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\'''
+ export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ sudo chown root: /var/lib/clickhouse
+ echo '1'
+ local total_mem
++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo
+ total_mem=32086432
+ total_mem=32856506368
+ 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=9856951910
+ echo 'Setting max_memory_usage_for_user=9856951910 and max_memory_usage for queries to 10G'
+ cat
Setting max_memory_usage_for_user=9856951910 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
+ ./minio server --address :11111 ./minio_data
+ params=('--silent' '--verbose')
+ local params
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
trying to connect to minio
+ [[ 0 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
+ counter=1
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
trying to connect to minio
+ [[ 1 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
+ counter=2
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 2 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=3
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 3 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ 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
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 7 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=8
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 8 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=9
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 9 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=10
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
trying to connect to minio
+ [[ 10 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
API: http://172.17.0.2:11111 http://127.0.0.1:11111
Console: http://172.17.0.2:41221 http://127.0.0.1:41221
Documentation: https://docs.min.io
WARNING: Console endpoint is listening on a dynamic port (41221), please use --console-address ":PORT" to choose a static port.
+ counter=11
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
AccessDenied
Access Denied./1811CAAF91175CC353a30d46-ddc0-412b-ba6c-83ed07de3ba6
+ lsof -i :11111
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
minio 248 root 10u IPv6 26180 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
02366_data.jsonl
+ 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
`/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: 80.17 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: 60.48 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: 2.89 KiB/s
b.tsv
+ for file in $(ls "${data_path}")
+ echo b.tsv
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv clickminio/test/b.tsv
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/b.tsv` -> `clickminio/test/b.tsv`
Total: 0 B, Transferred: 33 B, Speed: 3.56 KiB/s
c.tsv
+ for file in $(ls "${data_path}")
+ echo c.tsv
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv clickminio/test/c.tsv
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/c.tsv` -> `clickminio/test/c.tsv`
Total: 0 B, Transferred: 33 B, Speed: 3.69 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: 5.42 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'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
127.0.0.1 - - [16/Dec/2024:23:03:20 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 -
127.0.0.1 - - [16/Dec/2024:23:03:20 +0000] "PUT /devstoreaccount1/cont/dyipdnrfldduuvteqfcjcoalzzpzwnqg?blockid=wodctnykfpfzqjfprdbohwmdxetxqylivocoarnoaaygnochjyciwaeoxgjcgjmc&comp=block HTTP/1.1" 201 -
127.0.0.1 - - [16/Dec/2024:23:03:20 +0000] "PUT /devstoreaccount1/cont/dyipdnrfldduuvteqfcjcoalzzpzwnqg?comp=blocklist HTTP/1.1" 201 -
127.0.0.1 - - [16/Dec/2024:23:03:20 +0000] "GET /devstoreaccount1/cont/dyipdnrfldduuvteqfcjcoalzzpzwnqg HTTP/1.1" 206 4
127.0.0.1 - - [16/Dec/2024:23:03:20 +0000] "GET /devstoreaccount1/cont/dyipdnrfldduuvteqfcjcoalzzpzwnqg HTTP/1.1" 206 2
127.0.0.1 - - [16/Dec/2024:23:03:20 +0000] "DELETE /devstoreaccount1/cont/dyipdnrfldduuvteqfcjcoalzzpzwnqg HTTP/1.1" 202 -
+ counter=9
+ 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 523
+ 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/dexnamwm
INFO:root:Content length is 1271623680 bytes
INFO:root:Downloading finished
INFO:root:Will unpack data from temp path /tmp/dexnamwm to clickhouse db /var/lib/clickhouse/
INFO:root:Unpack finished
INFO:root:Will remove downloaded file /tmp/dexnamwm 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/awmp0tpa
INFO:root:Content length is 563968000 bytes
INFO:root:Downloading finished
INFO:root:Will unpack data from temp path /tmp/awmp0tpa to clickhouse db /var/lib/clickhouse/
INFO:root:Unpack finished
INFO:root:Will remove downloaded file /tmp/awmp0tpa 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=523
+ 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 = 523.
The process with pid = 523 is running.
Sent terminate signal to process with pid 523.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 523.
The process with pid = 523 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 523.
The process with pid = 523 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 523.
The process with pid = 523 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 523.
The process with pid = 523 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 523.
The process with pid = 523 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ mv /var/log/clickhouse-server/clickhouse-server.log /var/log/clickhouse-server/clickhouse-server.initial.log
+ start
+ counter=0
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 0 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=1
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 1 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=2
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 2 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=3
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 3 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=4
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 4 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=5
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 5 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
127.0.0.1 - - [16/Dec/2024:23:04:59 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 -
127.0.0.1 - - [16/Dec/2024:23:04:59 +0000] "PUT /devstoreaccount1/cont/hksbklnughohpdacpgdbsikhltpphwjj?blockid=yweyvypngwqazpdycbrqegoeramvwtllyctyujtpgfguwfnhroospikdrhzvqolq&comp=block HTTP/1.1" 201 -
+ counter=6
+ clickhouse-client --query 'SELECT 1'
127.0.0.1 - - [16/Dec/2024:23:04:59 +0000] "PUT /devstoreaccount1/cont/hksbklnughohpdacpgdbsikhltpphwjj?comp=blocklist HTTP/1.1" 201 -
127.0.0.1 - - [16/Dec/2024:23:04:59 +0000] "GET /devstoreaccount1/cont/hksbklnughohpdacpgdbsikhltpphwjj HTTP/1.1" 206 4
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
127.0.0.1 - - [16/Dec/2024:23:04:59 +0000] "GET /devstoreaccount1/cont/hksbklnughohpdacpgdbsikhltpphwjj HTTP/1.1" 206 2
127.0.0.1 - - [16/Dec/2024:23:04:59 +0000] "DELETE /devstoreaccount1/cont/hksbklnughohpdacpgdbsikhltpphwjj HTTP/1.1" 202 -
+ sleep 0.5
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
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
/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
Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server
+ echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server'
+ mkdir -p /etc/clickhouse-server/config.d/
+ mkdir -p /etc/clickhouse-server/users.d/
+ mkdir -p /etc/clickhouse-client
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/disks.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/metadata_cache.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/reverse_dns_query_function.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/
+ '[' /etc/clickhouse-server = /etc/clickhouse-server ']'
+ ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/
+ ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ rm -f /etc/clickhouse-server/config.d/zookeeper.xml
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/
+ create_snapshot_on_exit=0
+ sed --follow-symlinks -i 's|true|0|' /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n '' ]]
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/config.d/s3_storage_policy_by_default.xml /etc/clickhouse-server/config.d/
+ ARM=aarch64
++ uname -m
x86_64
Adding azure configuration
+ 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/
+ 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=32086432
+ total_mem=32856506368
+ 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=9856951910
+ echo 'Setting max_memory_usage_for_user=9856951910 and max_memory_usage for queries to 10G'
+ cat
Setting max_memory_usage_for_user=9856951910 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
+ 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
127.0.0.1 - - [16/Dec/2024:23:19:17 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 -
127.0.0.1 - - [16/Dec/2024:23:19:17 +0000] "PUT /devstoreaccount1/cont/nvmrqslupanbpuytaemzgxvvtaixnrom?blockid=kwjztdvbvqdswccznzqydayaplsenkebvarlpgroquoshklyidphkrlycuvulcsd&comp=block HTTP/1.1" 201 -
127.0.0.1 - - [16/Dec/2024:23:19:17 +0000] "PUT /devstoreaccount1/cont/nvmrqslupanbpuytaemzgxvvtaixnrom?comp=blocklist HTTP/1.1" 201 -
+ counter=9
+ clickhouse-client --query 'SELECT 1'
127.0.0.1 - - [16/Dec/2024:23:19:17 +0000] "GET /devstoreaccount1/cont/nvmrqslupanbpuytaemzgxvvtaixnrom HTTP/1.1" 206 4
127.0.0.1 - - [16/Dec/2024:23:19:17 +0000] "GET /devstoreaccount1/cont/nvmrqslupanbpuytaemzgxvvtaixnrom HTTP/1.1" 206 2
127.0.0.1 - - [16/Dec/2024:23:19:17 +0000] "DELETE /devstoreaccount1/cont/nvmrqslupanbpuytaemzgxvvtaixnrom HTTP/1.1" 202 -
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 13 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=14
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 14 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=15
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 15 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=16
+ clickhouse-client --query 'SELECT 1'
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 1759
+ 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-12-17 00:20:12,952 Run func tests '/usr/bin/clickhouse-test --global_time_limit=1200 '
2024-12-17 00:20:13,453 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_1 --client-option join_use_nulls=1 join_algorithm='parallel_hash' use_query_cache=1 memory_tracker_fault_probability=0.001 group_by_use_nulls=1 --global_time_limit=1200 '
2024-12-17 00:20:13,954 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 --global_time_limit=1200 '
2024-12-17 00:20:14,455 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-12-17 00:20:14,956 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 '
2024-12-17 00:20:15,457 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-12-17 00:20:15,958 Run func tests '/usr/bin/clickhouse-test --order=random --client-option memory_tracker_fault_probability=0.001 --global_time_limit=1200 '
2024-12-17 00:20:16,460 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-12-17 00:20:16,961 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-12-17 00:20:17,462 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-12-17 00:20:17,963 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 '
2024-12-17 00:20:18,464 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' use_query_cache=1 memory_tracker_fault_probability=0.001 group_by_use_nulls=1 --global_time_limit=1200 '
2024-12-17 00:20:18,966 Run func tests '/usr/bin/clickhouse-test --order=random --client-option use_query_cache=1 implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 --global_time_limit=1200 '
2024-12-17 00:20:19,467 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-12-17 00:20:19,968 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 --global_time_limit=1200 '
2024-12-17 00:20:20,469 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_15 --client-option join_algorithm='full_sorting_merge' group_by_use_nulls=1 --global_time_limit=1200 '
2024-12-17 00:20:20,970 Will wait functests to finish
2024-12-17 00:20:20,970 Finished 0 from 16 processes
2024-12-17 00:20:25,973 Finished 0 from 16 processes
2024-12-17 00:20:30,977 Finished 0 from 16 processes
2024-12-17 00:20:35,981 Finished 0 from 16 processes
2024-12-17 00:20:40,985 Finished 0 from 16 processes
2024-12-17 00:20:45,989 Finished 0 from 16 processes
2024-12-17 00:20:50,993 Finished 0 from 16 processes
2024-12-17 00:20:55,997 Finished 0 from 16 processes
2024-12-17 00:21:01,001 Finished 0 from 16 processes
2024-12-17 00:21:06,005 Finished 0 from 16 processes
2024-12-17 00:21:11,009 Finished 0 from 16 processes
2024-12-17 00:21:16,013 Finished 0 from 16 processes
2024-12-17 00:21:21,018 Finished 0 from 16 processes
2024-12-17 00:21:26,021 Finished 0 from 16 processes
2024-12-17 00:21:31,025 Finished 0 from 16 processes
2024-12-17 00:21:36,029 Finished 0 from 16 processes
2024-12-17 00:21:41,031 Finished 0 from 16 processes
2024-12-17 00:21:46,036 Finished 0 from 16 processes
2024-12-17 00:21:51,041 Finished 0 from 16 processes
2024-12-17 00:21:56,045 Finished 0 from 16 processes
2024-12-17 00:22:01,050 Finished 0 from 16 processes
2024-12-17 00:22:06,051 Finished 0 from 16 processes
2024-12-17 00:22:11,053 Finished 0 from 16 processes
2024-12-17 00:22:16,057 Finished 0 from 16 processes
2024-12-17 00:22:21,061 Finished 0 from 16 processes
2024-12-17 00:22:26,065 Finished 0 from 16 processes
2024-12-17 00:22:31,070 Finished 0 from 16 processes
2024-12-17 00:22:36,073 Finished 0 from 16 processes
2024-12-17 00:22:41,077 Finished 0 from 16 processes
2024-12-17 00:22:46,081 Finished 0 from 16 processes
2024-12-17 00:22:51,085 Finished 0 from 16 processes
2024-12-17 00:22:56,089 Finished 0 from 16 processes
2024-12-17 00:23:01,094 Finished 0 from 16 processes
2024-12-17 00:23:06,099 Finished 0 from 16 processes
2024-12-17 00:23:11,101 Finished 0 from 16 processes
2024-12-17 00:23:16,103 Finished 0 from 16 processes
2024-12-17 00:23:21,105 Finished 0 from 16 processes
2024-12-17 00:23:26,108 Finished 0 from 16 processes
2024-12-17 00:23:31,113 Finished 0 from 16 processes
2024-12-17 00:23:36,117 Finished 0 from 16 processes
2024-12-17 00:23:41,121 Finished 0 from 16 processes
2024-12-17 00:23:46,123 Finished 0 from 16 processes
2024-12-17 00:23:51,125 Finished 0 from 16 processes
2024-12-17 00:23:56,129 Finished 0 from 16 processes
2024-12-17 00:24:01,133 Finished 0 from 16 processes
2024-12-17 00:24:06,138 Finished 0 from 16 processes
2024-12-17 00:24:11,141 Finished 0 from 16 processes
2024-12-17 00:24:16,145 Finished 0 from 16 processes
2024-12-17 00:24:21,150 Finished 0 from 16 processes
2024-12-17 00:24:26,153 Finished 0 from 16 processes
2024-12-17 00:24:31,157 Finished 0 from 16 processes
2024-12-17 00:24:36,161 Finished 0 from 16 processes
2024-12-17 00:24:41,165 Finished 0 from 16 processes
2024-12-17 00:24:46,169 Finished 0 from 16 processes
2024-12-17 00:24:51,171 Finished 0 from 16 processes
2024-12-17 00:24:56,173 Finished 0 from 16 processes
2024-12-17 00:25:01,177 Finished 0 from 16 processes
2024-12-17 00:25:06,181 Finished 0 from 16 processes
2024-12-17 00:25:11,185 Finished 0 from 16 processes
2024-12-17 00:25:16,190 Finished 0 from 16 processes
2024-12-17 00:25:21,194 Finished 0 from 16 processes
2024-12-17 00:25:26,199 Finished 0 from 16 processes
2024-12-17 00:25:31,201 Finished 0 from 16 processes
2024-12-17 00:25:36,205 Finished 0 from 16 processes
2024-12-17 00:25:41,209 Finished 0 from 16 processes
2024-12-17 00:25:46,213 Finished 0 from 16 processes
2024-12-17 00:25:51,217 Finished 0 from 16 processes
2024-12-17 00:25:56,219 Finished 0 from 16 processes
2024-12-17 00:26:01,221 Finished 0 from 16 processes
2024-12-17 00:26:06,225 Finished 0 from 16 processes
2024-12-17 00:26:11,229 Finished 0 from 16 processes
2024-12-17 00:26:16,233 Finished 0 from 16 processes
2024-12-17 00:26:21,236 Finished 0 from 16 processes
2024-12-17 00:26:26,241 Finished 0 from 16 processes
2024-12-17 00:26:31,245 Finished 0 from 16 processes
2024-12-17 00:26:36,249 Finished 0 from 16 processes
2024-12-17 00:26:41,253 Finished 0 from 16 processes
2024-12-17 00:26:46,257 Finished 0 from 16 processes
2024-12-17 00:26:51,261 Finished 0 from 16 processes
2024-12-17 00:26:56,265 Finished 0 from 16 processes
2024-12-17 00:27:01,269 Finished 0 from 16 processes
2024-12-17 00:27:06,273 Finished 0 from 16 processes
2024-12-17 00:27:11,277 Finished 0 from 16 processes
2024-12-17 00:27:16,281 Finished 0 from 16 processes
2024-12-17 00:27:21,285 Finished 0 from 16 processes
2024-12-17 00:27:26,289 Finished 0 from 16 processes
2024-12-17 00:27:31,293 Finished 0 from 16 processes
2024-12-17 00:27:36,297 Finished 0 from 16 processes
2024-12-17 00:27:41,301 Finished 0 from 16 processes
2024-12-17 00:27:46,305 Finished 0 from 16 processes
2024-12-17 00:27:51,309 Finished 0 from 16 processes
2024-12-17 00:27:56,313 Finished 0 from 16 processes
2024-12-17 00:28:01,570 Finished 0 from 16 processes
2024-12-17 00:28:06,609 Finished 0 from 16 processes
2024-12-17 00:28:11,610 Finished 0 from 16 processes
2024-12-17 00:28:16,613 Finished 0 from 16 processes
2024-12-17 00:28:21,618 Finished 0 from 16 processes
2024-12-17 00:28:26,621 Finished 0 from 16 processes
2024-12-17 00:28:31,625 Finished 0 from 16 processes
2024-12-17 00:28:36,629 Finished 0 from 16 processes
2024-12-17 00:28:41,633 Finished 0 from 16 processes
2024-12-17 00:28:46,637 Finished 0 from 16 processes
2024-12-17 00:28:51,642 Finished 0 from 16 processes
2024-12-17 00:28:56,645 Finished 0 from 16 processes
2024-12-17 00:29:01,649 Finished 0 from 16 processes
2024-12-17 00:29:06,653 Finished 0 from 16 processes
2024-12-17 00:29:11,657 Finished 0 from 16 processes
2024-12-17 00:29:16,661 Finished 0 from 16 processes
2024-12-17 00:29:21,665 Finished 0 from 16 processes
2024-12-17 00:29:26,669 Finished 0 from 16 processes
2024-12-17 00:29:31,673 Finished 0 from 16 processes
2024-12-17 00:29:36,677 Finished 0 from 16 processes
2024-12-17 00:29:41,681 Finished 0 from 16 processes
2024-12-17 00:29:46,687 Finished 0 from 16 processes
2024-12-17 00:29:51,691 Finished 0 from 16 processes
2024-12-17 00:29:56,695 Finished 0 from 16 processes
2024-12-17 00:30:01,701 Finished 0 from 16 processes
2024-12-17 00:30:06,705 Finished 0 from 16 processes
2024-12-17 00:30:11,781 Finished 0 from 16 processes
2024-12-17 00:30:16,787 Finished 0 from 16 processes
2024-12-17 00:30:21,789 Finished 0 from 16 processes
2024-12-17 00:30:26,794 Finished 0 from 16 processes
2024-12-17 00:30:31,797 Finished 0 from 16 processes
2024-12-17 00:30:36,801 Finished 0 from 16 processes
2024-12-17 00:30:41,805 Finished 0 from 16 processes
2024-12-17 00:30:46,858 Finished 0 from 16 processes
2024-12-17 00:30:51,861 Finished 0 from 16 processes
2024-12-17 00:30:56,865 Finished 0 from 16 processes
2024-12-17 00:31:01,869 Finished 0 from 16 processes
2024-12-17 00:31:06,881 Finished 0 from 16 processes
2024-12-17 00:31:11,885 Finished 0 from 16 processes
2024-12-17 00:31:16,889 Finished 0 from 16 processes
2024-12-17 00:31:21,894 Finished 0 from 16 processes
2024-12-17 00:31:26,897 Finished 0 from 16 processes
2024-12-17 00:31:31,901 Finished 0 from 16 processes
2024-12-17 00:31:36,905 Finished 0 from 16 processes
2024-12-17 00:31:41,910 Finished 0 from 16 processes
2024-12-17 00:31:47,092 Finished 0 from 16 processes
2024-12-17 00:31:52,097 Finished 0 from 16 processes
2024-12-17 00:31:57,101 Finished 0 from 16 processes
2024-12-17 00:32:02,106 Finished 0 from 16 processes
2024-12-17 00:32:07,109 Finished 0 from 16 processes
2024-12-17 00:32:12,113 Finished 0 from 16 processes
2024-12-17 00:32:17,117 Finished 0 from 16 processes
2024-12-17 00:32:22,121 Finished 0 from 16 processes
2024-12-17 00:32:27,125 Finished 0 from 16 processes
2024-12-17 00:32:32,129 Finished 0 from 16 processes
2024-12-17 00:32:37,133 Finished 1 from 16 processes
2024-12-17 00:32:42,137 Finished 1 from 16 processes
2024-12-17 00:32:47,141 Finished 1 from 16 processes
2024-12-17 00:32:52,145 Finished 1 from 16 processes
2024-12-17 00:32:57,149 Finished 1 from 16 processes
2024-12-17 00:33:02,153 Finished 1 from 16 processes
2024-12-17 00:33:07,157 Finished 1 from 16 processes
2024-12-17 00:33:12,161 Finished 1 from 16 processes
2024-12-17 00:33:17,166 Finished 1 from 16 processes
2024-12-17 00:33:22,169 Finished 1 from 16 processes
2024-12-17 00:33:27,174 Finished 1 from 16 processes
2024-12-17 00:33:32,177 Finished 1 from 16 processes
2024-12-17 00:33:37,181 Finished 1 from 16 processes
2024-12-17 00:33:42,185 Finished 1 from 16 processes
2024-12-17 00:33:47,189 Finished 1 from 16 processes
2024-12-17 00:33:52,193 Finished 1 from 16 processes
2024-12-17 00:33:57,198 Finished 1 from 16 processes
2024-12-17 00:34:02,202 Finished 1 from 16 processes
2024-12-17 00:34:07,205 Finished 1 from 16 processes
2024-12-17 00:34:12,209 Finished 1 from 16 processes
2024-12-17 00:34:17,213 Finished 1 from 16 processes
2024-12-17 00:34:22,217 Finished 1 from 16 processes
2024-12-17 00:34:27,222 Finished 1 from 16 processes
2024-12-17 00:34:32,225 Finished 1 from 16 processes
2024-12-17 00:34:37,229 Finished 1 from 16 processes
2024-12-17 00:34:42,233 Finished 1 from 16 processes
2024-12-17 00:34:47,238 Finished 1 from 16 processes
2024-12-17 00:34:52,241 Finished 1 from 16 processes
2024-12-17 00:34:57,245 Finished 1 from 16 processes
2024-12-17 00:35:02,249 Finished 1 from 16 processes
2024-12-17 00:35:07,254 Finished 1 from 16 processes
2024-12-17 00:35:12,257 Finished 1 from 16 processes
2024-12-17 00:35:17,261 Finished 1 from 16 processes
2024-12-17 00:35:22,265 Finished 1 from 16 processes
2024-12-17 00:35:27,269 Finished 1 from 16 processes
2024-12-17 00:35:32,273 Finished 1 from 16 processes
2024-12-17 00:35:37,278 Finished 1 from 16 processes
2024-12-17 00:35:42,281 Finished 1 from 16 processes
2024-12-17 00:35:47,285 Finished 1 from 16 processes
2024-12-17 00:35:52,289 Finished 1 from 16 processes
2024-12-17 00:35:57,293 Finished 1 from 16 processes
2024-12-17 00:36:02,297 Finished 1 from 16 processes
2024-12-17 00:36:07,301 Finished 1 from 16 processes
2024-12-17 00:36:12,305 Finished 1 from 16 processes
2024-12-17 00:36:17,310 Finished 1 from 16 processes
2024-12-17 00:36:22,311 Finished 1 from 16 processes
2024-12-17 00:36:27,316 Finished 1 from 16 processes
2024-12-17 00:36:32,321 Finished 1 from 16 processes
2024-12-17 00:36:37,325 Finished 1 from 16 processes
2024-12-17 00:36:42,329 Finished 1 from 16 processes
2024-12-17 00:36:47,333 Finished 1 from 16 processes
2024-12-17 00:36:52,337 Finished 1 from 16 processes
2024-12-17 00:36:57,341 Finished 1 from 16 processes
2024-12-17 00:37:02,345 Finished 1 from 16 processes
2024-12-17 00:37:07,349 Finished 1 from 16 processes
2024-12-17 00:37:12,354 Finished 1 from 16 processes
2024-12-17 00:37:17,358 Finished 1 from 16 processes
2024-12-17 00:37:22,361 Finished 1 from 16 processes
2024-12-17 00:37:27,365 Finished 1 from 16 processes
2024-12-17 00:37:32,369 Finished 1 from 16 processes
2024-12-17 00:37:37,373 Finished 1 from 16 processes
2024-12-17 00:37:42,377 Finished 1 from 16 processes
2024-12-17 00:37:47,381 Finished 1 from 16 processes
2024-12-17 00:37:52,385 Finished 1 from 16 processes
2024-12-17 00:37:57,389 Finished 1 from 16 processes
2024-12-17 00:38:02,393 Finished 1 from 16 processes
2024-12-17 00:38:07,397 Finished 1 from 16 processes
2024-12-17 00:38:12,401 Finished 1 from 16 processes
2024-12-17 00:38:17,405 Finished 1 from 16 processes
2024-12-17 00:38:22,410 Finished 1 from 16 processes
2024-12-17 00:38:27,413 Finished 1 from 16 processes
2024-12-17 00:38:32,417 Finished 1 from 16 processes
2024-12-17 00:38:37,422 Finished 1 from 16 processes
2024-12-17 00:38:42,425 Finished 1 from 16 processes
2024-12-17 00:38:47,429 Finished 1 from 16 processes
2024-12-17 00:38:52,433 Finished 1 from 16 processes
2024-12-17 00:38:57,437 Finished 1 from 16 processes
2024-12-17 00:39:02,442 Finished 1 from 16 processes
2024-12-17 00:39:07,445 Finished 1 from 16 processes
2024-12-17 00:39:12,449 Finished 1 from 16 processes
2024-12-17 00:39:17,453 Finished 1 from 16 processes
2024-12-17 00:39:22,457 Finished 1 from 16 processes
2024-12-17 00:39:27,461 Finished 1 from 16 processes
2024-12-17 00:39:32,466 Finished 1 from 16 processes
2024-12-17 00:39:37,469 Finished 1 from 16 processes
2024-12-17 00:39:42,473 Finished 1 from 16 processes
2024-12-17 00:39:47,477 Finished 1 from 16 processes
2024-12-17 00:39:52,477 Finished 1 from 16 processes
2024-12-17 00:39:57,481 Finished 1 from 16 processes
2024-12-17 00:40:02,486 Finished 1 from 16 processes
2024-12-17 00:40:07,489 Finished 1 from 16 processes
2024-12-17 00:40:12,494 Finished 1 from 16 processes
2024-12-17 00:40:17,499 Finished 1 from 16 processes
2024-12-17 00:40:22,505 Finished 1 from 16 processes
2024-12-17 00:40:27,509 Finished 1 from 16 processes
2024-12-17 00:40:32,514 Finished 1 from 16 processes
2024-12-17 00:40:37,519 Finished 1 from 16 processes
2024-12-17 00:40:42,521 Finished 1 from 16 processes
2024-12-17 00:40:47,525 Finished 1 from 16 processes
2024-12-17 00:40:52,529 Finished 1 from 16 processes
2024-12-17 00:40:57,533 Finished 1 from 16 processes
2024-12-17 00:41:02,537 Finished 1 from 16 processes
2024-12-17 00:41:07,541 Finished 1 from 16 processes
2024-12-17 00:41:12,545 Finished 2 from 16 processes
2024-12-17 00:41:17,549 Finished 2 from 16 processes
2024-12-17 00:41:22,554 Finished 2 from 16 processes
2024-12-17 00:41:27,559 Finished 2 from 16 processes
2024-12-17 00:41:32,564 Finished 2 from 16 processes
2024-12-17 00:41:37,569 Finished 2 from 16 processes
2024-12-17 00:41:42,573 Finished 2 from 16 processes
2024-12-17 00:41:47,577 Finished 2 from 16 processes
2024-12-17 00:41:52,581 Finished 2 from 16 processes
2024-12-17 00:41:57,584 Finished 2 from 16 processes
2024-12-17 00:42:02,589 Finished 3 from 16 processes
2024-12-17 00:42:07,593 Finished 3 from 16 processes
2024-12-17 00:42:12,598 Finished 3 from 16 processes
2024-12-17 00:42:17,601 Finished 3 from 16 processes
2024-12-17 00:42:22,606 Finished 4 from 16 processes
2024-12-17 00:42:27,609 Finished 4 from 16 processes
2024-12-17 00:42:32,613 Finished 4 from 16 processes
2024-12-17 00:42:37,617 Finished 4 from 16 processes
2024-12-17 00:42:42,621 Finished 4 from 16 processes
2024-12-17 00:42:47,626 Finished 4 from 16 processes
2024-12-17 00:42:52,629 Finished 4 from 16 processes
2024-12-17 00:42:57,633 Finished 4 from 16 processes
2024-12-17 00:43:02,637 Finished 4 from 16 processes
2024-12-17 00:43:07,642 Finished 4 from 16 processes
2024-12-17 00:43:12,645 Finished 4 from 16 processes
2024-12-17 00:43:17,648 Finished 7 from 16 processes
2024-12-17 00:43:22,653 Finished 7 from 16 processes
2024-12-17 00:43:27,657 Finished 7 from 16 processes
2024-12-17 00:43:32,661 Finished 7 from 16 processes
2024-12-17 00:43:37,665 Finished 7 from 16 processes
2024-12-17 00:43:42,669 Finished 7 from 16 processes
2024-12-17 00:43:47,674 Finished 7 from 16 processes
2024-12-17 00:43:52,677 Finished 7 from 16 processes
2024-12-17 00:43:57,682 Finished 7 from 16 processes
2024-12-17 00:44:02,685 Finished 7 from 16 processes
2024-12-17 00:44:07,690 Finished 7 from 16 processes
2024-12-17 00:44:12,693 Finished 7 from 16 processes
2024-12-17 00:44:17,697 Finished 7 from 16 processes
2024-12-17 00:44:22,702 Finished 7 from 16 processes
2024-12-17 00:44:27,705 Finished 8 from 16 processes
2024-12-17 00:44:32,709 Finished 8 from 16 processes
2024-12-17 00:44:37,713 Finished 8 from 16 processes
2024-12-17 00:44:42,717 Finished 8 from 16 processes
2024-12-17 00:44:47,721 Finished 8 from 16 processes
2024-12-17 00:44:52,725 Finished 9 from 16 processes
2024-12-17 00:44:57,729 Finished 9 from 16 processes
2024-12-17 00:45:02,733 Finished 9 from 16 processes
2024-12-17 00:45:07,737 Finished 9 from 16 processes
2024-12-17 00:45:12,738 Finished 9 from 16 processes
2024-12-17 00:45:17,741 Finished 9 from 16 processes
2024-12-17 00:45:22,746 Finished 9 from 16 processes
2024-12-17 00:45:27,749 Finished 9 from 16 processes
2024-12-17 00:45:32,752 Finished 9 from 16 processes
2024-12-17 00:45:37,757 Finished 10 from 16 processes
2024-12-17 00:45:42,761 Finished 11 from 16 processes
2024-12-17 00:45:47,766 Finished 12 from 16 processes
2024-12-17 00:45:52,769 Finished 12 from 16 processes
2024-12-17 00:45:57,774 Finished 12 from 16 processes
2024-12-17 00:46:02,779 Finished 12 from 16 processes
2024-12-17 00:46:07,784 Finished 12 from 16 processes
2024-12-17 00:46:12,789 Finished 12 from 16 processes
2024-12-17 00:46:17,793 Finished 12 from 16 processes
2024-12-17 00:46:22,797 Finished 12 from 16 processes
2024-12-17 00:46:27,801 Finished 12 from 16 processes
2024-12-17 00:46:32,807 Finished 12 from 16 processes
2024-12-17 00:46:37,809 Finished 12 from 16 processes
2024-12-17 00:46:42,813 Finished 12 from 16 processes
2024-12-17 00:46:47,817 Finished 12 from 16 processes
2024-12-17 00:46:52,821 Finished 12 from 16 processes
2024-12-17 00:46:57,826 Finished 12 from 16 processes
2024-12-17 00:47:02,829 Finished 12 from 16 processes
2024-12-17 00:47:07,833 Finished 12 from 16 processes
2024-12-17 00:47:12,838 Finished 12 from 16 processes
2024-12-17 00:47:17,841 Finished 12 from 16 processes
2024-12-17 00:47:22,845 Finished 13 from 16 processes
2024-12-17 00:47:27,850 Finished 13 from 16 processes
2024-12-17 00:47:32,855 Finished 13 from 16 processes
2024-12-17 00:47:37,857 Finished 13 from 16 processes
2024-12-17 00:47:42,862 Finished 13 from 16 processes
2024-12-17 00:47:47,865 Finished 14 from 16 processes
2024-12-17 00:47:52,870 Finished 14 from 16 processes
2024-12-17 00:47:57,875 Finished 14 from 16 processes
2024-12-17 00:48:02,880 Finished 14 from 16 processes
2024-12-17 00:48:07,885 Finished 14 from 16 processes
2024-12-17 00:48:12,889 Finished 14 from 16 processes
2024-12-17 00:48:17,894 Finished 14 from 16 processes
2024-12-17 00:48:22,897 Finished 14 from 16 processes
2024-12-17 00:48:27,901 Finished 14 from 16 processes
2024-12-17 00:48:32,905 Finished 14 from 16 processes
2024-12-17 00:48:37,909 Finished 14 from 16 processes
2024-12-17 00:48:42,913 Finished 14 from 16 processes
2024-12-17 00:48:47,917 Finished 14 from 16 processes
2024-12-17 00:48:52,921 Finished 14 from 16 processes
2024-12-17 00:48:57,925 Finished 14 from 16 processes
2024-12-17 00:49:02,929 Finished 14 from 16 processes
2024-12-17 00:49:07,933 Finished 14 from 16 processes
2024-12-17 00:49:12,937 Finished 14 from 16 processes
2024-12-17 00:49:17,941 Finished 14 from 16 processes
2024-12-17 00:49:22,945 Finished 14 from 16 processes
2024-12-17 00:49:27,949 Finished 14 from 16 processes
2024-12-17 00:49:32,953 Finished 14 from 16 processes
2024-12-17 00:49:37,957 Finished 14 from 16 processes
2024-12-17 00:49:42,961 Finished 15 from 16 processes
2024-12-17 00:49:47,965 Finished 15 from 16 processes
2024-12-17 00:49:52,969 Finished 15 from 16 processes
2024-12-17 00:49:57,973 Finished 15 from 16 processes
2024-12-17 00:50:02,977 Finished 15 from 16 processes
2024-12-17 00:50:07,981 Finished 15 from 16 processes
2024-12-17 00:50:12,985 Finished 15 from 16 processes
2024-12-17 00:50:17,989 All processes finished
2024-12-17 00:50:17,989 Compressing stress logs
2024-12-17 00:50:18,010 Logs compressed
2024-12-17 00:50:18,011 Will terminate gdb (if any)
Quit
2024-12-17 00:55:23,073 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.34 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)
32820 0.074 86.99 MiB 0.64 3 133 ['Error'] 0 ReplicatedMergeTree (table {}) does not support transactions
26392 0.06 3.55 MiB 0.026 1 140 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {})
26220 0.059 3.93 MiB 0.029 3 140 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {}
25480 0.057 719.30 KiB 0.005 1 140 ['Debug'] 0 Processed in {} sec.
24687 0.056 1.39 MiB 0.01 5 252 ['Trace'] 0.001 Access granted: {}{}
22541 0.051 1.79 MiB 0.013 4 172 ['Debug'] 0.999 {} Authenticating user \'{}\' from {}
22541 0.051 2.47 MiB 0.018 4 172 ['Debug'] 0.999 {} Authenticated with global context as user {}
22530 0.051 1.93 MiB 0.014 4 172 ['Debug'] 0.999 {} Logout, user_id: {}
22508 0.051 2.40 MiB 0.018 3 140 ['Debug'] 1 {} Creating session context with user_id: {}
21789 0.049 705.75 KiB 0.005 1 140 ['Trace'] 1 TCP Request. Address: {}
21789 0.049 2.07 MiB 0.015 1 140 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}.
21744 0.049 573.33 KiB 0.004 1 139 ['Debug'] 1 Done processing connection.
16749 0.038 1.16 MiB 0.009 1 256 ['Trace'] 0.02 Rolling back transaction {}{}
7844 0.018 594.70 KiB 0.004 1 355 ['Debug'] 0.128 Remove from cache. Key: {}, offset: {}, size: {}
7834 0.018 466.67 KiB 0.003 1 69 ['Debug'] 0.994 Key {} is removed from metadata
7137 0.016 581.11 KiB 0.004 1 140 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec.
6907 0.016 397.96 KiB 0.003 1 287 ['Debug'] 0.019 Submitting key {} for removal
5461 0.012 243.81 KiB 0.002 1 1 ['Trace'] 1 Processing requests batch, size: {}, bytes: {}
4771 0.011 118.18 KiB 0.001 1 215 ['Trace'] 0.014 {} -> {}
4185 0.009 188.76 KiB 0.001 1 154 ['Debug'] 0.152 Peak memory usage{}: {}.
3464 0.008 311.57 KiB 0.002 1 1225 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.)
3362 0.008 400.32 KiB 0.003 130 169 ['Trace'] 0.665 Renaming temporary part {} to {} with tid {}.
3344 0.008 160.32 KiB 0.001 1 166 ['Trace'] 0.666 filled checksums {}
3333 0.008 231.10 KiB 0.002 131 273 ['Trace'] 0.851 Trying to reserve {} using storage policy from min volume index {}
2865 0.006 270.16 KiB 0.002 1 26 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part
2727 0.006 1.67 MiB 0.012 1 219 ['Debug'] 0.961 Objects with paths [{}] were removed from S3
2700 0.006 208.30 KiB 0.001 1 134 ['Trace'] 0 Query span trace_id for opentelemetry log: {}
2582 0.006 3.69 MiB 0.027 1 199 ['Debug'] 0.963 metadata and objects were removed for [{}], only metadata were removed for [{}].
2216 0.005 79.50 KiB 0.001 12 12 ['Trace'] 1 Flushed system log up to offset {}
2216 0.005 128.14 KiB 0.001 12 12 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {}
2111 0.005 241.20 KiB 0.002 829 442 ['Trace'] 0 Bypassing cache because file segment state is `PARTIALLY_DOWNLOADED_NO_CONTINUATION` and downloaded part already used
2107 0.005 158.88 KiB 0.001 1 125 ['Trace'] 0 Entry found for query {}
2053 0.005 59.94 KiB 0 1 972 ['Trace'] 0 Aggregation method: {}
1970 0.004 604.53 KiB 0.004 1574 555 ['Information'] 0.001 Setting download as failed: {}
1753 0.004 141.30 KiB 0.001 1400 505 ['Trace'] 0 No space left in cache to reserve {} bytes, will continue without cache download
1486 0.003 81.36 KiB 0.001 1 419 ['Trace'] 0.138 Created HTTP(S) session with {}:{} ({}:{})
1402 0.003 128.18 KiB 0.001 1 250 ['Debug'] 0.009 Will evict {} file segments (while reserving {} bytes for {}:{})
1302 0.003 166.58 KiB 0.001 11 97 ['Debug'] 0 Part: {}, sum_marks: {}, approx mark size: {}, prefetch_step_bytes: {}, prefetch_step_marks: {}, (ranges: {})
1248 0.003 13.41 KiB 0 1 806 ['Trace'] 0 Aggregating
1193 0.003 142.47 KiB 0.001 1 117 ['Trace'] 0 No entry found for query {}
1171 0.003 3.55 MiB 0.026 7 129 ['Error'] 0.998 Table is in readonly mode (replica path: {})
1023 0.002 222.48 KiB 0.002 42 18 ['Information'] 1 {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting)
1007 0.002 83.13 KiB 0.001 1 572 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={}
1006 0.002 263.02 KiB 0.002 3 3 ['Debug'] 0 ZooKeeperRetriesControl: {}/{}: {}: retry_count={} timeout={}ms error={} message={}
992 0.002 221.72 KiB 0.002 2 2 ['Trace'] 0 ZooKeeperRetriesControl: {}/{}: setUserError: error={} message={}
834 0.002 211.54 KiB 0.002 1 7 ['Information'] 0.149 WriteBufferFromS3 is not finalized in destructor. The file might not be written to S3. {}.
784 0.002 88.22 KiB 0.001 1 18 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {}
747 0.002 128.56 KiB 0.001 2 115 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {}
744 0.002 267.45 KiB 0.002 2 115 ['Trace'] 1 Request URI: {}
728 0.002 19.58 KiB 0 97 152 ['Debug'] 0.027 Key condition: {}
707 0.002 82.26 KiB 0.001 93 152 ['Debug'] 0.028 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges
688 0.002 33.89 KiB 0 1 147 ['Trace'] 0 Merging partially aggregated blocks (bucket = {}).
688 0.002 102.52 KiB 0.001 1 147 ['Debug'] 0 Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.)
680 0.002 13.95 KiB 0 2 114 ['Debug'] 0.016 Done processing query
631 0.001 34.08 KiB 0 32 140 ['Debug'] 0.968 Selected {} parts from {} to {}
606 0.001 31.37 KiB 0 83 146 ['Trace'] 0.033 Spreading mark ranges among streams (default reading)
596 0.001 111.14 KiB 0.001 8 6 ['Trace'] 0 ZooKeeperWithFaultInjection call SUCCEEDED: seed={} func={} path={}
587 0.001 47.39 KiB 0 1 74 ['Trace'] 0.002 Reading {} ranges in order from part {}, approx. {} rows starting from {}
570 0.001 19.47 KiB 0 1 28 ['Debug'] 0 Selected MergeAlgorithm: {}
570 0.001 47.53 KiB 0 1 28 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {}
568 0.001 74.64 KiB 0.001 1 28 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec.
568 0.001 37.38 KiB 0 30 28 ['Trace'] 0 Merged {} parts: [{}, {}] -> {}
533 0.001 11.62 KiB 0 79 128 ['Trace'] 1 Execution took {} ms.
490 0.001 1.52 MiB 0.011 2 102 ['Error'] 0 Timeout exceeded: elapsed {} seconds, maximum: {}
464 0.001 4.08 KiB 0 2 96 ['Trace'] 0.004 No tables
454 0.001 61.25 KiB 0 121 81 ['Debug'] 0.978 Removing {} parts from filesystem (serially): Parts: [{}]
433 0.001 14.82 KiB 0 31 120 ['Debug'] 0 MinMax index condition: {}
426 0.001 9.57 KiB 0 1 346 ['Trace'] 0 Merging aggregated data
424 0.001 17.40 KiB 0 30 132 ['Debug'] 0.045 Reading approx. {} rows with {} streams
404 0.001 35.55 KiB 0 1 60 ['Trace'] 0.71 Close WriteBufferFromS3. {}.
404 0.001 42.28 KiB 0 1 99 ['Trace'] 0.708 Single part upload has completed. {}, size {}
404 0.001 99.07 KiB 0.001 1 61 ['Trace'] 0.708 Create WriteBufferFromS3, {}
400 0.001 37.92 KiB 0 1 59 ['Trace'] 0.715 finalizeImpl WriteBufferFromS3. {}.
366 0.001 10.88 KiB 0 19 234 ['Trace'] 0 Found (RIGHT) boundary mark: {}
366 0.001 10.50 KiB 0 19 234 ['Trace'] 0 Found (LEFT) boundary mark: {}
366 0.001 11.00 KiB 0 19 234 ['Trace'] 0 Found {} range in {} steps
366 0.001 24.56 KiB 0 19 234 ['Trace'] 0 Running binary search on index range for part {} ({} marks)
355 0.001 57.06 KiB 0 12 268 ['Debug'] 0 Sent data for {} scalars, total {} rows in {} sec., {} rows/sec., {} ({}/sec.), compressed {} times to {} ({}/sec.)
344 0.001 45.67 KiB 0 23 16 ['Debug'] 0.988 Removing {} parts from memory: Parts: [{}]
344 0.001 45.33 KiB 0 23 16 ['Trace'] 0.988 Found {} old parts to remove. Parts: [{}]
330 0.001 42.03 KiB 0 1 120 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {}
329 0.001 24.42 KiB 0 1 89 ['Debug'] 0 Waiting for table {} to be finally dropped
329 0.001 65.62 KiB 0 1 120 ['Information'] 1 Removing metadata {} of dropped table {}
316 0.001 4.94 KiB 0 83 83 ['Debug'] 1 Scheduling tasks
301 0.001 45.85 KiB 0 1 91 ['Debug'] 0.877 Recursively remove path {}: metadata and objects were removed for [{}], only metadata were removed for [{}].
294 0.001 9.20 KiB 0 16 15 ['Debug'] 0 Requested flush up to offset {}
289 0.001 64.15 KiB 0 83 83 ['Trace'] 1 scheduleTasks: initialized={}, size_before_filtering={}, queue_size={}, entries={}..{}, first_failed_task_name={}, current_tasks_size={}, last_current_task={}, last_skipped_entry_name={}
289 0.001 7.06 KiB 0 83 83 ['Debug'] 1 Waiting for queue updates
279 0.001 14.21 KiB 0 13 211 ['Trace'] 0 Connecting. Database: {}. User: {}{}{}
279 0.001 12.81 KiB 0 13 211 ['Trace'] 0 Connected to {} server version {}.{}.{}.
266 0.001 37.19 KiB 0 1 26 ['Trace'] 0 PREWHERE condition was split into {} steps: {}
262 0.001 13.30 KiB 0 82 82 ['Debug'] 1 Will schedule {} tasks starting from {}
259 0.001 25.08 KiB 0 75 75 ['Debug'] 1 Will not execute task {}: {}
259 0.001 7.59 KiB 0 75 75 ['Trace'] 1 Checking task {}
255 0.001 12.41 KiB 0 20 110 ['Trace'] 1 Scheduling next merge selecting task after {}ms
250 0.001 7.82 KiB 0 1 103 ['Debug'] 0.076 min_marks_for_concurrent_read={}
245 0.001 9.81 KiB 0 1 202 ['Trace'] 0 Converting aggregation data to two-level.
238 0.001 23.75 KiB 0 1 106 ['Information'] 0.063 Change cancellation status from {} to {}. Log message: {}
238 0.001 28.86 KiB 0 1 2 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {}
235 0.001 4.36 KiB 0 232 96 ['Information'] 0.017 Starting up tables.
Top messages without format string (fmt::runtime):
count pattern runtime_message line
UInt64 String String Tuple(String, UInt64)
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() @ 0x000000001db05eb5 in /usr/bin/clickhouse\n1. ./build_docker/./base/poco/Foundation/ ('/Exception.cpp',235)
3 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 17 ('/LoggerWrapper.h',42)
2 CodeDBExceptionTableisinreadonly Code: 242. DB::Exception: Table is in readonly mode: replica_path=/clickhouse/tables/01810_max_part_removal_threads_long_test_1/rep_data_01810/replicas/1. (TABLE_IS_READ_ONLY) (version 23.8.16.43.altinitystable (altinity build)) (from [::1]:51446) (comment ('/executeQuery.cpp',207)
2 skippedconfiglatestconfig skipped config 1, latest config 17 ('/LoggerWrapper.h',42)
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 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.16.43.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 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() @ 0x000000001db05eb5 in /usr/bin/clickhouse\n1. ./build_docker/./base ('/Exception.cpp',235)
1 newconfigurationlogidxprevlogidx new configuration: log idx 105, prev log idx 17\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 detectaconfigurationchangethatis detect a configuration change that is not committed yet at index 1 ('/LoggerWrapper.h',42)
1 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/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 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 0\nterm 2\nelection timer allowed\nlog store start 1, end 104\nconfig log idx 17, prev log idx 1 ('/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 statemachinecommitindexprecommit state machine commit index 0, precommit index 104, last log index 104 ('/LoggerWrapper.h',42)
1 newconfiglogidxprevlogidxcurconf new config log idx 105, prev log idx 17, cur config log idx 17, prev log idx 1 ('/LoggerWrapper.h',42)
1 invalidelectiontimeoutlowerbound invalid election timeout lower bound detected, adjusted to 0 ('/LoggerWrapper.h',42)
1 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',42)
1 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 105 ('/LoggerWrapper.h',42)
1 ServerwasbuiltwithsanitizerItwil Server was built with sanitizer. It will work slowly. ('',0)
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 PRIORITYdecaytargetmine [PRIORITY] decay, target 1 -> 1, mine 1 ('/LoggerWrapper.h',42)
1 newelectiontimeoutrange new election timeout range: 0 - 0 ('/LoggerWrapper.h',42)
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) 830 /var/lib/clickhouse/disks/s3_disk/store/cce/cce89258-070c-4ec6-ad4d-67901acd1842/tmp_merge_201403_5_21_1/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 1 similar messages)
40 Forked a child process to watch
Top short messages:
c message_format_string substring(any(message), 1, 120) min_length_without_exception_boilerplate
UInt64 LowCardinality(String) String Int64
12 Session expired void DB::StorageReplicatedMergeTree::mutationsUpdatingTask(): Code: 999. Coordination::Exception: Session expired. (KEEP 70
2 Froze {} parts Froze 1 parts -13
1 Found {} on {} Found changelog_1_100000.bin.zstd on LocalLogDisk 23
Top messages by level:
(0.07403831403795309,'ReplicatedMergeTree (table {}) does not support transactions') Error
(0.0005188547296992447,'Client has gone away.') Warning
(0.004444103554380487,'Setting download as failed: {}') Information
(0.059537452287923766,'(from {}{}{}){}{} {} (stage: {})') Debug
(0.0591494391857139,'{} Creating query context from {} context, user_id: {}, parent context user: {}') Trace
2024-12-17 00:55:26,921 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=1759
+ clickhouse stop --max-tries 90 --do-not-kill
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1759.
The process with pid = 1759 is running.
Sent terminate signal to process with pid 1759.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1759.
The process with pid = 1759 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1759.
The process with pid = 1759 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1759.
The process with pid = 1759 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1759.
The process with pid = 1759 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1759.
The process with pid = 1759 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1759.
The process with pid = 1759 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1759.
The process with pid = 1759 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1759.
The process with pid = 1759 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 - - [16/Dec/2024:23:55:35 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 -
127.0.0.1 - - [16/Dec/2024:23:55:35 +0000] "PUT /devstoreaccount1/cont/pustiiqipvacalsvwnwsqarrahhmrquf?blockid=xlztxjupwpmwmkskxmdtllavfnmujfjhodknptvgubrixhzjwlimcuxokfkdxnnt&comp=block HTTP/1.1" 201 -
127.0.0.1 - - [16/Dec/2024:23:55:35 +0000] "PUT /devstoreaccount1/cont/pustiiqipvacalsvwnwsqarrahhmrquf?comp=blocklist HTTP/1.1" 201 -
127.0.0.1 - - [16/Dec/2024:23:55:35 +0000] "GET /devstoreaccount1/cont/pustiiqipvacalsvwnwsqarrahhmrquf HTTP/1.1" 206 4
127.0.0.1 - - [16/Dec/2024:23:55:35 +0000] "GET /devstoreaccount1/cont/pustiiqipvacalsvwnwsqarrahhmrquf HTTP/1.1" 206 2
127.0.0.1 - - [16/Dec/2024:23:55:35 +0000] "DELETE /devstoreaccount1/cont/pustiiqipvacalsvwnwsqarrahhmrquf 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'
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 42104
+ 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=42104
+ 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 = 42104.
The process with pid = 42104 is running.
Sent terminate signal to process with pid 42104.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 42104.
The process with pid = 42104 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 42104.
The process with pid = 42104 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 42104.
The process with pid = 42104 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 42104.
The process with pid = 42104 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