+ 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.42.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.42.altinitystable+ubsan_amd64.deb ...
Unpacking clickhouse-common-static (23.8.16.42.altinitystable+ubsan) ...
Setting up clickhouse-common-static (23.8.16.42.altinitystable+ubsan) ...
+ dpkg -i package_folder/clickhouse-common-static-dbg_23.8.16.42.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.42.altinitystable+ubsan_amd64.deb ...
Unpacking clickhouse-common-static-dbg (23.8.16.42.altinitystable+ubsan) ...
Setting up clickhouse-common-static-dbg (23.8.16.42.altinitystable+ubsan) ...
+ dpkg -i package_folder/clickhouse-server_23.8.16.42.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.42.altinitystable+ubsan_amd64.deb ...
Unpacking clickhouse-server (23.8.16.42.altinitystable+ubsan) ...
Setting up clickhouse-server (23.8.16.42.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.42.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.42.altinitystable+ubsan_amd64.deb ...
Unpacking clickhouse-client (23.8.16.42.altinitystable+ubsan) ...
Setting up clickhouse-client (23.8.16.42.altinitystable+ubsan) ...
+ export THREAD_FUZZER_CPU_TIME_PERIOD_US=1000
+ THREAD_FUZZER_CPU_TIME_PERIOD_US=1000
+ export THREAD_FUZZER_SLEEP_PROBABILITY=0.1
+ THREAD_FUZZER_SLEEP_PROBABILITY=0.1
+ export THREAD_FUZZER_SLEEP_TIME_US=100000
+ THREAD_FUZZER_SLEEP_TIME_US=100000
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_MIGRATE_PROBABILITY=1
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_PROBABILITY=0.001
+ export THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US=10000
+ THREAD_FUZZER_pthread_mutex_lock_BEFORE_SLEEP_TIME_US=10000
+ export THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US=10000
+ THREAD_FUZZER_pthread_mutex_lock_AFTER_SLEEP_TIME_US=10000
+ export THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US=10000
+ THREAD_FUZZER_pthread_mutex_unlock_BEFORE_SLEEP_TIME_US=10000
+ export THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US=10000
+ THREAD_FUZZER_pthread_mutex_unlock_AFTER_SLEEP_TIME_US=10000
+ export THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01
+ THREAD_FUZZER_EXPLICIT_SLEEP_PROBABILITY=0.01
+ export THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01
+ THREAD_FUZZER_EXPLICIT_MEMORY_EXCEPTION_PROBABILITY=0.01
+ export ZOOKEEPER_FAULT_INJECTION=1
+ ZOOKEEPER_FAULT_INJECTION=1
+ configure
+ export USE_DATABASE_ORDINARY=1
+ USE_DATABASE_ORDINARY=1
+ export EXPORT_S3_STORAGE_POLICIES=1
+ EXPORT_S3_STORAGE_POLICIES=1
+ /usr/share/clickhouse-test/config/install.sh
+ DEST_SERVER_PATH=/etc/clickhouse-server
+ DEST_CLIENT_PATH=/etc/clickhouse-client
+++ dirname /usr/share/clickhouse-test/config/install.sh
++ cd /usr/share/clickhouse-test/config
++ pwd -P
+ SRC_PATH=/usr/share/clickhouse-test/config
+ echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server'
Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server
+ mkdir -p /etc/clickhouse-server/config.d/
+ mkdir -p /etc/clickhouse-server/users.d/
+ mkdir -p /etc/clickhouse-client
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/disks.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/metadata_cache.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/reverse_dns_query_function.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/
+ '[' /etc/clickhouse-server = /etc/clickhouse-server ']'
+ ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/
+ ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ rm -f /etc/clickhouse-server/config.d/zookeeper.xml
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/
+ create_snapshot_on_exit=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
x86_64
+ [[ '' -eq 1 ]]
+ [[ x86_64 == \a\a\r\c\h\6\4 ]]
+ echo 'Adding azure configuration'
+ ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/
Adding azure configuration
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|100000|10000|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\'''
+ export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ sudo chown root: /var/lib/clickhouse
+ echo '1'
+ local total_mem
++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo
+ total_mem=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
Setting max_memory_usage_for_user=9856951910 and max_memory_usage for queries to 10G
+ 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
+ cat
+ cat
+ ./setup_minio.sh stateless
+ azurite-blob --blobHost 0.0.0.0 --blobPort 10000 --debug /azurite_log
+ export MINIO_ROOT_USER=clickhouse
+ MINIO_ROOT_USER=clickhouse
+ export MINIO_ROOT_PASSWORD=clickhouse
+ MINIO_ROOT_PASSWORD=clickhouse
+ main stateless
+ local query_dir
++ check_arg stateless
++ local query_dir
++ '[' '!' 1 -eq 1 ']'
++ case "$1" in
++ query_dir=0_stateless
++ echo 0_stateless
+ query_dir=0_stateless
+ '[' '!' -f ./minio ']'
+ start_minio
+ mkdir -p ./minio_data
+ ./minio --version
Azurite Blob service is starting on 0.0.0.0:10000
Azurite Blob service successfully listens on http://0.0.0.0:10000
minio version RELEASE.2022-01-03T18-22-58Z
+ wait_for_it
+ local counter=0
+ local max_counter=60
+ local url=http://localhost:11111
+ params=('--silent' '--verbose')
+ local params
+ ./minio server --address :11111 ./minio_data
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
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
+ [[ 1 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ 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
trying to connect to minio
+ [[ 3 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
+ counter=4
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 4 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ counter=5
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
trying to connect to minio
+ [[ 5 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
+ counter=6
+ grep AccessDenied
+ curl --silent --verbose http://localhost:11111
+ [[ 6 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
+ 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
trying to connect to minio
+ [[ 9 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
+ counter=10
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
+ [[ 10 == \6\0 ]]
+ echo 'trying to connect to minio'
+ sleep 1
trying to connect to minio
API: http://172.17.0.2:11111 http://127.0.0.1:11111
Console: http://172.17.0.2:41745 http://127.0.0.1:41745
Documentation: https://docs.min.io
WARNING: Console endpoint is listening on a dynamic port (41745), please use --console-address ":PORT" to choose a static port.
+ counter=11
+ curl --silent --verbose http://localhost:11111
+ grep AccessDenied
AccessDenied
Access Denied./180096A5EE2E86F17762cd8c-3d41-4fc0-ad30-084dee88fbcb
+ lsof -i :11111
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
minio 247 root 10u IPv6 30408 0t0 TCP *:11111 (LISTEN)
+ sleep 5
+ setup_minio stateless
+ local test_type=stateless
+ ./mc alias set clickminio http://localhost:11111 clickhouse clickhouse
Added `clickminio` successfully.
+ ./mc admin user add clickminio test testtest
Added user `test` successfully.
+ ./mc admin policy set clickminio readwrite user=test
Policy `readwrite` is set on user `test`
+ ./mc mb clickminio/test
Bucket created successfully `clickminio/test`.
+ '[' stateless = stateless ']'
+ ./mc policy set public clickminio/test
Access permission for `clickminio/test` is set to `public`
+ upload_data 0_stateless /usr/share/clickhouse-test
+ local query_dir=0_stateless
+ local test_path=/usr/share/clickhouse-test
+ local data_path=/usr/share/clickhouse-test/queries/0_stateless/data_minio
++ ls /usr/share/clickhouse-test/queries/0_stateless/data_minio
+ for file in $(ls "${data_path}")
+ echo 02366_data.jsonl
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl clickminio/test/02366_data.jsonl
02366_data.jsonl
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/02366_data.jsonl` -> `clickminio/test/02366_data.jsonl`
Total: 0 B, Transferred: 0 B, Speed: 0 B/s
02731.arrow
+ for file in $(ls "${data_path}")
+ echo 02731.arrow
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow clickminio/test/02731.arrow
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/02731.arrow` -> `clickminio/test/02731.arrow`
Total: 0 B, Transferred: 3.82 MiB, Speed: 160.98 MiB/s
+ 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
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: 97.03 MiB/s
+ for file in $(ls "${data_path}")
+ echo a.tsv
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv clickminio/test/a.tsv
a.tsv
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/a.tsv` -> `clickminio/test/a.tsv`
Total: 0 B, Transferred: 24 B, Speed: 3.10 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.80 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.51 KiB/s
tsv_with_header.tsv
+ for file in $(ls "${data_path}")
+ echo tsv_with_header.tsv
+ ./mc cp /usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv clickminio/test/tsv_with_header.tsv
`/usr/share/clickhouse-test/queries/0_stateless/data_minio/tsv_with_header.tsv` -> `clickminio/test/tsv_with_header.tsv`
Total: 0 B, Transferred: 44 B, Speed: 6.73 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
127.0.0.1 - - [21/Oct/2024:21:58:29 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 201 -
127.0.0.1 - - [21/Oct/2024:21:58:29 +0000] "PUT /devstoreaccount1/cont/ueiykbtjghfsvjtpdvhgbxywkkxeqgza?blockid=wfrdofmhjfllxfifwbydjrdhubbrrphmcclgtganripymzfojexivtycrvnsweih&comp=block HTTP/1.1" 201 -
127.0.0.1 - - [21/Oct/2024:21:58:29 +0000] "PUT /devstoreaccount1/cont/ueiykbtjghfsvjtpdvhgbxywkkxeqgza?comp=blocklist HTTP/1.1" 201 -
127.0.0.1 - - [21/Oct/2024:21:58:29 +0000] "GET /devstoreaccount1/cont/ueiykbtjghfsvjtpdvhgbxywkkxeqgza HTTP/1.1" 206 4
127.0.0.1 - - [21/Oct/2024:21:58:29 +0000] "GET /devstoreaccount1/cont/ueiykbtjghfsvjtpdvhgbxywkkxeqgza HTTP/1.1" 206 2
127.0.0.1 - - [21/Oct/2024:21:58:29 +0000] "DELETE /devstoreaccount1/cont/ueiykbtjghfsvjtpdvhgbxywkkxeqgza HTTP/1.1" 202 -
+ counter=8
+ clickhouse-client --query 'SELECT 1'
1
+ attach_gdb_to_clickhouse
++ kill -l SIGRTMIN
+ RTMIN=34
+ echo '
set follow-fork-mode parent
handle SIGHUP nostop noprint pass
handle SIGINT nostop noprint pass
handle SIGQUIT nostop noprint pass
handle SIGPIPE nostop noprint pass
handle SIGTERM nostop noprint pass
handle SIGUSR1 nostop noprint pass
handle SIGUSR2 nostop noprint pass
handle SIG34 nostop noprint pass
info signals
continue
backtrace full
thread apply all backtrace full
info registers
disassemble /s
up
disassemble /s
up
disassemble /s
p "done"
detach
quit
'
+ sleep 5
+ ts '%Y-%m-%d %H:%M:%S'
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ gdb -batch -command script.gdb -p 516
+ 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/rt8vukqk
INFO:root:Content length is 1271623680 bytes
INFO:root:Downloading finished
INFO:root:Will unpack data from temp path /tmp/rt8vukqk to clickhouse db /var/lib/clickhouse/
INFO:root:Unpack finished
INFO:root:Will remove downloaded file /tmp/rt8vukqk 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/8f2_7uyw
INFO:root:Content length is 563968000 bytes
INFO:root:Downloading finished
INFO:root:Will unpack data from temp path /tmp/8f2_7uyw to clickhouse db /var/lib/clickhouse/
INFO:root:Unpack finished
INFO:root:Will remove downloaded file /tmp/8f2_7uyw 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=516
+ 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 = 516.
The process with pid = 516 is running.
Sent terminate signal to process with pid 516.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 516.
The process with pid = 516 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 516.
The process with pid = 516 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 516.
The process with pid = 516 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 516.
The process with pid = 516 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 516.
The process with pid = 516 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
+ counter=6
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 6 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
127.0.0.1 - - [21/Oct/2024:22:00:14 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 -
127.0.0.1 - - [21/Oct/2024:22:00:14 +0000] "PUT /devstoreaccount1/cont/nzvgciwzamwyfqbxjjasqzbeiwkvvtsm?blockid=wlevlozktgatxfwaqlmwectpoxfazumxijwetyaxouufwndjpnnihxplckzsazsa&comp=block HTTP/1.1" 201 -
127.0.0.1 - - [21/Oct/2024:22:00:14 +0000] "PUT /devstoreaccount1/cont/nzvgciwzamwyfqbxjjasqzbeiwkvvtsm?comp=blocklist HTTP/1.1" 201 -
127.0.0.1 - - [21/Oct/2024:22:00:14 +0000] "GET /devstoreaccount1/cont/nzvgciwzamwyfqbxjjasqzbeiwkvvtsm HTTP/1.1" 206 4
127.0.0.1 - - [21/Oct/2024:22:00:14 +0000] "GET /devstoreaccount1/cont/nzvgciwzamwyfqbxjjasqzbeiwkvvtsm HTTP/1.1" 206 2
127.0.0.1 - - [21/Oct/2024:22:00:14 +0000] "DELETE /devstoreaccount1/cont/nzvgciwzamwyfqbxjjasqzbeiwkvvtsm HTTP/1.1" 202 -
+ counter=7
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 7 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=8
+ clickhouse-client --query 'SELECT 1'
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 943
+ 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=943
+ 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 = 943.
The process with pid = 943 is running.
Sent terminate signal to process with pid 943.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 943.
The process with pid = 943 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 943.
The process with pid = 943 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 943.
The process with pid = 943 is running.
Waiting for server to stop
Now there is no clickhouse-server process.
Server stopped
+ return
+ export USE_S3_STORAGE_FOR_MERGE_TREE=1
+ USE_S3_STORAGE_FOR_MERGE_TREE=1
+ export ZOOKEEPER_FAULT_INJECTION=1
+ ZOOKEEPER_FAULT_INJECTION=1
+ configure
+ export USE_DATABASE_ORDINARY=1
+ USE_DATABASE_ORDINARY=1
+ export EXPORT_S3_STORAGE_POLICIES=1
+ EXPORT_S3_STORAGE_POLICIES=1
+ /usr/share/clickhouse-test/config/install.sh
+ DEST_SERVER_PATH=/etc/clickhouse-server
+ DEST_CLIENT_PATH=/etc/clickhouse-client
+++ dirname /usr/share/clickhouse-test/config/install.sh
++ cd /usr/share/clickhouse-test/config
++ pwd -P
+ SRC_PATH=/usr/share/clickhouse-test/config
+ echo 'Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server'
+ mkdir -p /etc/clickhouse-server/config.d/
Going to install test configs from /usr/share/clickhouse-test/config into /etc/clickhouse-server
+ mkdir -p /etc/clickhouse-server/users.d/
+ mkdir -p /etc/clickhouse-client
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_write.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/listen.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/text_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_settings_prefixes.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_access_control_improvements.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/macros.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/disks.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/secure_ports.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/clusters.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/graphite.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/database_atomic.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/max_concurrent_queries.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_settings.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree_old_dirs_cleanup.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/test_cluster_with_incorrect_pw.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/keeper_port.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logging_no_rotate.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/merge_tree.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/lost_forever_check.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/metadata_cache.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/tcp_with_proxy.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/prometheus.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_lists.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/top_level_domains_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/transactions.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/encryption.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/CORS.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/logger_trace.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/named_collection.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/ssl_certs.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_cache_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/session_log.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/system_unfreeze.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_zero_copy_replication.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/nlp.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/forbidden_headers.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_keeper_map.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/custom_disks_base_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/display_name.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/reverse_dns_query_function.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/compressed_marks_and_index.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/disable_s3_env_credentials.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/enable_wait_for_shutdown_replicated_tables.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/backups.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/filesystem_caches_path.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/validate_tcp_client_information.xml /etc/clickhouse-server/config.d/
+ '[' /etc/clickhouse-server = /etc/clickhouse-server ']'
+ ln -sf /usr/share/clickhouse-test/config/config.d/legacy_geobase.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/log_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/readonly.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/access_management.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_atomic_drop_detach_sync.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/opentelemetry.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/remote_queries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/session_log_test.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/memory_profiler.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/no_fsync_metadata.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/filelog.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/enable_blobs_check.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/marks.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/insert_keeper_retries.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/prefetch_settings.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/nonconst_timezone.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/timeouts.xml /etc/clickhouse-server/users.d/
+ ln -sf /usr/share/clickhouse-test/config/ints_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/strings_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/decimals_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/executable_pool_dictionary.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/test_function.xml /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/top_level_domains /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/regions_hierarchy.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/regions_names_en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-en.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/ext-ru.txt /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/lem-en.bin /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/server.key /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/server.crt /etc/clickhouse-server/
+ ln -sf /usr/share/clickhouse-test/config/dhparam.pem /etc/clickhouse-server/
+ ln -sf --backup=simple --suffix=_original.xml /usr/share/clickhouse-test/config/config.d/query_masking_rules.xml /etc/clickhouse-server/config.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ rm -f /etc/clickhouse-server/config.d/zookeeper.xml
+ ln -sf /usr/share/clickhouse-test/config/config.d/zookeeper_fault_injection.xml /etc/clickhouse-server/config.d/
+ create_snapshot_on_exit=1
+ sed --follow-symlinks -i 's|true|1|' /etc/clickhouse-server/config.d/keeper_port.xml
+ [[ -n '' ]]
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/users.d/database_ordinary.xml /etc/clickhouse-server/users.d/
+ [[ -n 1 ]]
+ [[ 1 -eq 1 ]]
+ ln -sf /usr/share/clickhouse-test/config/config.d/s3_storage_policy_by_default.xml /etc/clickhouse-server/config.d/
+ ARM=aarch64
++ uname -m
+ OS=x86_64
+ [[ -n 1 ]]
+ echo x86_64
+ [[ '' -eq 1 ]]
+ [[ x86_64 == \a\a\r\c\h\6\4 ]]
x86_64
Adding azure configuration
+ echo 'Adding azure configuration'
+ ln -sf /usr/share/clickhouse-test/config/config.d/azure_storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/config.d/storage_conf.xml /etc/clickhouse-server/config.d/
+ ln -sf /usr/share/clickhouse-test/config/users.d/s3_cache.xml /etc/clickhouse-server/users.d/
+ [[ -n '' ]]
+ ln -sf /usr/share/clickhouse-test/config/client_config.xml /etc/clickhouse-client/config.xml
+ sudo cat /etc/clickhouse-server/config.d/keeper_port.xml
+ sed 's|100000|10000|'
+ sudo mv /etc/clickhouse-server/config.d/keeper_port.xml.tmp /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chown clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ sudo chgrp clickhouse /etc/clickhouse-server/config.d/keeper_port.xml
+ echo 'ASAN_OPTIONS='\''malloc_context_size=10 verbosity=1 allocator_release_to_os_interval_ms=10000'\'''
+ export 'ASAN_OPTIONS=malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ ASAN_OPTIONS='malloc_context_size=10 allocator_release_to_os_interval_ms=10000'
+ sudo chown root: /var/lib/clickhouse
+ echo '1'
+ local total_mem
++ awk '/MemTotal/ { print $(NF-1) }' /proc/meminfo
+ total_mem=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
Setting max_memory_usage_for_user=9856951910 and max_memory_usage for queries to 10G
+ 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
+ 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
127.0.0.1 - - [21/Oct/2024:22:14:21 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 -
127.0.0.1 - - [21/Oct/2024:22:14:21 +0000] "PUT /devstoreaccount1/cont/xisnogqvbfbzbkowbkbfefkcdstjsxnp?blockid=xlheiuhsrapepnmdnmsryetuompaofktsbrwyyjruhnlrjmlptroauuwzzxuhsmu&comp=block HTTP/1.1" 201 -
127.0.0.1 - - [21/Oct/2024:22:14:21 +0000] "PUT /devstoreaccount1/cont/xisnogqvbfbzbkowbkbfefkcdstjsxnp?comp=blocklist HTTP/1.1" 201 -
127.0.0.1 - - [21/Oct/2024:22:14:21 +0000] "GET /devstoreaccount1/cont/xisnogqvbfbzbkowbkbfefkcdstjsxnp HTTP/1.1" 206 4
127.0.0.1 - - [21/Oct/2024:22:14:21 +0000] "GET /devstoreaccount1/cont/xisnogqvbfbzbkowbkbfefkcdstjsxnp HTTP/1.1" 206 2
+ counter=8
+ clickhouse-client --query 'SELECT 1'
127.0.0.1 - - [21/Oct/2024:22:14:21 +0000] "DELETE /devstoreaccount1/cont/xisnogqvbfbzbkowbkbfefkcdstjsxnp HTTP/1.1" 202 -
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 8 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=9
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 9 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=10
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 10 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=11
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 11 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=12
+ clickhouse-client --query 'SELECT 1'
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)
+ '[' 12 -gt 120 ']'
+ clickhouse start --user root
+ sleep 0.5
+ counter=13
+ clickhouse-client --query 'SELECT 1'
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'
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 1754
+ 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-10-22 00:15:18,710 Run func tests '/usr/bin/clickhouse-test --global_time_limit=1200 '
2024-10-22 00:15:19,212 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_1 --client-option join_use_nulls=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 group_by_use_nulls=1 --global_time_limit=1200 '
2024-10-22 00:15:19,713 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_2', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 use_query_cache=1 --global_time_limit=1200 '
2024-10-22 00:15:20,214 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_3 --client-option join_algorithm='partial_merge' group_by_use_nulls=1 --global_time_limit=1200 '
2024-10-22 00:15:20,716 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 '
2024-10-22 00:15:21,217 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-10-22 00:15:21,718 Run func tests '/usr/bin/clickhouse-test --order=random --client-option memory_tracker_fault_probability=0.001 --global_time_limit=1200 '
2024-10-22 00:15:22,219 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-10-22 00:15:22,720 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 use_query_cache=1 --global_time_limit=1200 '
2024-10-22 00:15:23,221 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-10-22 00:15:23,723 Run func tests '/usr/bin/clickhouse-test --order=random --client-option join_use_nulls=1 --global_time_limit=1200 '
2024-10-22 00:15:24,224 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_11', 's1', 'r1')" --database=test_11 --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 join_algorithm='parallel_hash' memory_tracker_fault_probability=0.001 group_by_use_nulls=1 --global_time_limit=1200 '
2024-10-22 00:15:24,725 Run func tests '/usr/bin/clickhouse-test --order=random --client-option implicit_transaction=1 throw_on_unsupported_query_inside_transaction=0 --global_time_limit=1200 '
2024-10-22 00:15:25,226 Run func tests '/usr/bin/clickhouse-test --order=random --database=test_13 --client-option join_use_nulls=1 join_algorithm='partial_merge' group_by_use_nulls=1 --global_time_limit=1200 '
2024-10-22 00:15:25,728 Run func tests '/usr/bin/clickhouse-test --order=random --db-engine="Replicated('/test/db/test_14', 's1', 'r1')" --client-option allow_experimental_database_replicated=1 enable_deflate_qpl_codec=1 use_query_cache=1 --global_time_limit=1200 '
2024-10-22 00:15:26,229 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-10-22 00:15:26,730 Will wait functests to finish
2024-10-22 00:15:26,730 Finished 0 from 16 processes
2024-10-22 00:15:31,732 Finished 0 from 16 processes
2024-10-22 00:15:36,737 Finished 0 from 16 processes
2024-10-22 00:15:41,740 Finished 0 from 16 processes
2024-10-22 00:15:46,744 Finished 0 from 16 processes
2024-10-22 00:15:51,748 Finished 0 from 16 processes
2024-10-22 00:15:56,752 Finished 0 from 16 processes
2024-10-22 00:16:01,756 Finished 0 from 16 processes
2024-10-22 00:16:06,760 Finished 0 from 16 processes
2024-10-22 00:16:11,760 Finished 0 from 16 processes
2024-10-22 00:16:16,764 Finished 0 from 16 processes
2024-10-22 00:16:21,769 Finished 0 from 16 processes
2024-10-22 00:16:26,772 Finished 0 from 16 processes
2024-10-22 00:16:31,776 Finished 0 from 16 processes
2024-10-22 00:16:36,780 Finished 0 from 16 processes
2024-10-22 00:16:41,784 Finished 0 from 16 processes
2024-10-22 00:16:46,788 Finished 0 from 16 processes
2024-10-22 00:16:51,792 Finished 0 from 16 processes
2024-10-22 00:16:56,797 Finished 0 from 16 processes
2024-10-22 00:17:01,800 Finished 0 from 16 processes
2024-10-22 00:17:06,804 Finished 0 from 16 processes
2024-10-22 00:17:11,809 Finished 0 from 16 processes
2024-10-22 00:17:16,812 Finished 0 from 16 processes
2024-10-22 00:17:21,816 Finished 0 from 16 processes
2024-10-22 00:17:26,821 Finished 0 from 16 processes
2024-10-22 00:17:31,825 Finished 0 from 16 processes
2024-10-22 00:17:36,830 Finished 0 from 16 processes
2024-10-22 00:17:41,835 Finished 0 from 16 processes
2024-10-22 00:17:46,839 Finished 0 from 16 processes
2024-10-22 00:17:51,844 Finished 0 from 16 processes
2024-10-22 00:17:56,848 Finished 0 from 16 processes
2024-10-22 00:18:01,852 Finished 0 from 16 processes
2024-10-22 00:18:06,856 Finished 0 from 16 processes
2024-10-22 00:18:11,860 Finished 0 from 16 processes
2024-10-22 00:18:16,864 Finished 0 from 16 processes
2024-10-22 00:18:21,865 Finished 0 from 16 processes
2024-10-22 00:18:26,868 Finished 0 from 16 processes
2024-10-22 00:18:31,872 Finished 0 from 16 processes
2024-10-22 00:18:36,877 Finished 0 from 16 processes
2024-10-22 00:18:41,883 Finished 0 from 16 processes
2024-10-22 00:18:46,884 Finished 0 from 16 processes
2024-10-22 00:18:51,888 Finished 0 from 16 processes
2024-10-22 00:18:56,893 Finished 0 from 16 processes
2024-10-22 00:19:01,898 Finished 0 from 16 processes
2024-10-22 00:19:06,903 Finished 0 from 16 processes
2024-10-22 00:19:11,908 Finished 0 from 16 processes
2024-10-22 00:19:16,913 Finished 0 from 16 processes
2024-10-22 00:19:21,916 Finished 0 from 16 processes
2024-10-22 00:19:26,920 Finished 0 from 16 processes
2024-10-22 00:19:31,924 Finished 0 from 16 processes
2024-10-22 00:19:36,928 Finished 0 from 16 processes
2024-10-22 00:19:41,932 Finished 0 from 16 processes
2024-10-22 00:19:46,937 Finished 0 from 16 processes
2024-10-22 00:19:51,943 Finished 0 from 16 processes
2024-10-22 00:19:56,944 Finished 0 from 16 processes
2024-10-22 00:20:01,948 Finished 0 from 16 processes
2024-10-22 00:20:06,952 Finished 0 from 16 processes
2024-10-22 00:20:11,957 Finished 0 from 16 processes
2024-10-22 00:20:16,959 Finished 0 from 16 processes
2024-10-22 00:20:21,964 Finished 0 from 16 processes
2024-10-22 00:20:26,969 Finished 0 from 16 processes
2024-10-22 00:20:31,975 Finished 0 from 16 processes
2024-10-22 00:20:36,978 Finished 0 from 16 processes
2024-10-22 00:20:41,984 Finished 0 from 16 processes
2024-10-22 00:20:46,986 Finished 0 from 16 processes
2024-10-22 00:20:51,991 Finished 0 from 16 processes
2024-10-22 00:20:56,996 Finished 0 from 16 processes
2024-10-22 00:21:02,000 Finished 0 from 16 processes
2024-10-22 00:21:07,004 Finished 0 from 16 processes
2024-10-22 00:21:12,008 Finished 0 from 16 processes
2024-10-22 00:21:17,012 Finished 0 from 16 processes
2024-10-22 00:21:22,016 Finished 0 from 16 processes
2024-10-22 00:21:27,019 Finished 0 from 16 processes
2024-10-22 00:21:32,020 Finished 0 from 16 processes
2024-10-22 00:21:37,024 Finished 0 from 16 processes
2024-10-22 00:21:42,028 Finished 0 from 16 processes
2024-10-22 00:21:47,033 Finished 0 from 16 processes
2024-10-22 00:21:52,038 Finished 0 from 16 processes
2024-10-22 00:21:57,044 Finished 0 from 16 processes
2024-10-22 00:22:02,046 Finished 0 from 16 processes
2024-10-22 00:22:07,048 Finished 0 from 16 processes
2024-10-22 00:22:12,052 Finished 0 from 16 processes
2024-10-22 00:22:17,058 Finished 0 from 16 processes
2024-10-22 00:22:22,060 Finished 0 from 16 processes
2024-10-22 00:22:27,064 Finished 0 from 16 processes
2024-10-22 00:22:32,068 Finished 0 from 16 processes
2024-10-22 00:22:37,072 Finished 0 from 16 processes
2024-10-22 00:22:42,076 Finished 0 from 16 processes
2024-10-22 00:22:47,080 Finished 0 from 16 processes
2024-10-22 00:22:52,084 Finished 0 from 16 processes
2024-10-22 00:22:57,088 Finished 0 from 16 processes
2024-10-22 00:23:02,092 Finished 0 from 16 processes
2024-10-22 00:23:07,093 Finished 0 from 16 processes
2024-10-22 00:23:12,096 Finished 0 from 16 processes
2024-10-22 00:23:17,101 Finished 0 from 16 processes
2024-10-22 00:23:22,104 Finished 0 from 16 processes
2024-10-22 00:23:27,108 Finished 0 from 16 processes
2024-10-22 00:23:32,112 Finished 0 from 16 processes
2024-10-22 00:23:37,116 Finished 0 from 16 processes
2024-10-22 00:23:42,121 Finished 0 from 16 processes
2024-10-22 00:23:47,127 Finished 0 from 16 processes
2024-10-22 00:23:52,132 Finished 0 from 16 processes
2024-10-22 00:23:57,136 Finished 0 from 16 processes
2024-10-22 00:24:02,140 Finished 0 from 16 processes
2024-10-22 00:24:07,144 Finished 0 from 16 processes
2024-10-22 00:24:12,148 Finished 0 from 16 processes
2024-10-22 00:24:17,153 Finished 0 from 16 processes
2024-10-22 00:24:22,159 Finished 0 from 16 processes
2024-10-22 00:24:27,160 Finished 0 from 16 processes
2024-10-22 00:24:32,164 Finished 0 from 16 processes
2024-10-22 00:24:37,168 Finished 0 from 16 processes
2024-10-22 00:24:42,170 Finished 0 from 16 processes
2024-10-22 00:24:47,175 Finished 0 from 16 processes
2024-10-22 00:24:52,179 Finished 0 from 16 processes
2024-10-22 00:24:57,183 Finished 0 from 16 processes
2024-10-22 00:25:02,188 Finished 0 from 16 processes
2024-10-22 00:25:07,193 Finished 0 from 16 processes
2024-10-22 00:25:12,194 Finished 0 from 16 processes
2024-10-22 00:25:17,196 Finished 0 from 16 processes
2024-10-22 00:25:22,198 Finished 0 from 16 processes
2024-10-22 00:25:27,204 Finished 0 from 16 processes
2024-10-22 00:25:32,207 Finished 0 from 16 processes
2024-10-22 00:25:37,212 Finished 0 from 16 processes
2024-10-22 00:25:42,216 Finished 0 from 16 processes
2024-10-22 00:25:47,220 Finished 0 from 16 processes
2024-10-22 00:25:52,224 Finished 0 from 16 processes
2024-10-22 00:25:57,228 Finished 0 from 16 processes
2024-10-22 00:26:02,231 Finished 0 from 16 processes
2024-10-22 00:26:07,232 Finished 0 from 16 processes
2024-10-22 00:26:12,237 Finished 0 from 16 processes
2024-10-22 00:26:17,240 Finished 0 from 16 processes
2024-10-22 00:26:22,244 Finished 0 from 16 processes
2024-10-22 00:26:27,249 Finished 0 from 16 processes
2024-10-22 00:26:32,252 Finished 0 from 16 processes
2024-10-22 00:26:37,253 Finished 0 from 16 processes
2024-10-22 00:26:42,257 Finished 0 from 16 processes
2024-10-22 00:26:47,260 Finished 0 from 16 processes
2024-10-22 00:26:52,264 Finished 0 from 16 processes
2024-10-22 00:26:57,268 Finished 0 from 16 processes
2024-10-22 00:27:02,270 Finished 0 from 16 processes
2024-10-22 00:27:07,275 Finished 0 from 16 processes
2024-10-22 00:27:12,281 Finished 0 from 16 processes
2024-10-22 00:27:17,284 Finished 0 from 16 processes
2024-10-22 00:27:22,288 Finished 0 from 16 processes
2024-10-22 00:27:27,293 Finished 0 from 16 processes
2024-10-22 00:27:32,299 Finished 0 from 16 processes
2024-10-22 00:27:37,300 Finished 0 from 16 processes
2024-10-22 00:27:42,304 Finished 0 from 16 processes
2024-10-22 00:27:47,309 Finished 0 from 16 processes
2024-10-22 00:27:52,312 Finished 0 from 16 processes
2024-10-22 00:27:57,316 Finished 0 from 16 processes
2024-10-22 00:28:02,321 Finished 0 from 16 processes
2024-10-22 00:28:07,324 Finished 0 from 16 processes
2024-10-22 00:28:12,328 Finished 0 from 16 processes
2024-10-22 00:28:17,332 Finished 0 from 16 processes
2024-10-22 00:28:22,336 Finished 0 from 16 processes
2024-10-22 00:28:27,340 Finished 0 from 16 processes
2024-10-22 00:28:32,344 Finished 0 from 16 processes
2024-10-22 00:28:37,348 Finished 0 from 16 processes
2024-10-22 00:28:42,352 Finished 0 from 16 processes
2024-10-22 00:28:47,356 Finished 0 from 16 processes
2024-10-22 00:28:52,360 Finished 0 from 16 processes
2024-10-22 00:28:57,364 Finished 0 from 16 processes
2024-10-22 00:29:02,368 Finished 0 from 16 processes
2024-10-22 00:29:07,373 Finished 0 from 16 processes
2024-10-22 00:29:12,376 Finished 0 from 16 processes
2024-10-22 00:29:17,382 Finished 0 from 16 processes
2024-10-22 00:29:22,384 Finished 0 from 16 processes
2024-10-22 00:29:27,389 Finished 0 from 16 processes
2024-10-22 00:29:32,392 Finished 0 from 16 processes
2024-10-22 00:29:37,396 Finished 0 from 16 processes
2024-10-22 00:29:42,401 Finished 0 from 16 processes
2024-10-22 00:29:47,404 Finished 0 from 16 processes
2024-10-22 00:29:52,408 Finished 0 from 16 processes
2024-10-22 00:29:57,411 Finished 0 from 16 processes
2024-10-22 00:30:02,416 Finished 0 from 16 processes
2024-10-22 00:30:07,420 Finished 0 from 16 processes
2024-10-22 00:30:12,424 Finished 0 from 16 processes
2024-10-22 00:30:17,428 Finished 0 from 16 processes
2024-10-22 00:30:22,432 Finished 0 from 16 processes
2024-10-22 00:30:27,436 Finished 0 from 16 processes
2024-10-22 00:30:32,440 Finished 0 from 16 processes
2024-10-22 00:30:37,444 Finished 0 from 16 processes
2024-10-22 00:30:42,448 Finished 0 from 16 processes
2024-10-22 00:30:47,452 Finished 0 from 16 processes
2024-10-22 00:30:52,456 Finished 0 from 16 processes
2024-10-22 00:30:57,460 Finished 0 from 16 processes
2024-10-22 00:31:02,464 Finished 0 from 16 processes
2024-10-22 00:31:07,468 Finished 0 from 16 processes
2024-10-22 00:31:12,472 Finished 0 from 16 processes
2024-10-22 00:31:17,476 Finished 0 from 16 processes
2024-10-22 00:31:22,480 Finished 0 from 16 processes
2024-10-22 00:31:27,486 Finished 0 from 16 processes
2024-10-22 00:31:32,488 Finished 0 from 16 processes
2024-10-22 00:31:37,490 Finished 0 from 16 processes
2024-10-22 00:31:42,495 Finished 0 from 16 processes
2024-10-22 00:31:47,500 Finished 0 from 16 processes
2024-10-22 00:31:52,504 Finished 0 from 16 processes
2024-10-22 00:31:57,509 Finished 0 from 16 processes
2024-10-22 00:32:02,514 Finished 0 from 16 processes
2024-10-22 00:32:07,516 Finished 0 from 16 processes
2024-10-22 00:32:12,520 Finished 0 from 16 processes
2024-10-22 00:32:17,524 Finished 0 from 16 processes
2024-10-22 00:32:22,528 Finished 0 from 16 processes
2024-10-22 00:32:27,529 Finished 0 from 16 processes
2024-10-22 00:32:32,532 Finished 0 from 16 processes
2024-10-22 00:32:37,536 Finished 0 from 16 processes
2024-10-22 00:32:42,540 Finished 0 from 16 processes
2024-10-22 00:32:47,544 Finished 0 from 16 processes
2024-10-22 00:32:52,548 Finished 0 from 16 processes
2024-10-22 00:32:57,552 Finished 0 from 16 processes
2024-10-22 00:33:02,557 Finished 0 from 16 processes
2024-10-22 00:33:07,560 Finished 0 from 16 processes
2024-10-22 00:33:12,564 Finished 0 from 16 processes
2024-10-22 00:33:17,567 Finished 0 from 16 processes
2024-10-22 00:33:22,572 Finished 0 from 16 processes
2024-10-22 00:33:27,577 Finished 0 from 16 processes
2024-10-22 00:33:32,580 Finished 0 from 16 processes
2024-10-22 00:33:37,584 Finished 0 from 16 processes
2024-10-22 00:33:42,588 Finished 0 from 16 processes
2024-10-22 00:33:47,593 Finished 0 from 16 processes
2024-10-22 00:33:52,598 Finished 0 from 16 processes
2024-10-22 00:33:57,603 Finished 0 from 16 processes
2024-10-22 00:34:02,608 Finished 0 from 16 processes
2024-10-22 00:34:07,612 Finished 0 from 16 processes
2024-10-22 00:34:12,613 Finished 0 from 16 processes
2024-10-22 00:34:17,618 Finished 0 from 16 processes
2024-10-22 00:34:22,623 Finished 0 from 16 processes
2024-10-22 00:34:27,628 Finished 0 from 16 processes
2024-10-22 00:34:32,632 Finished 0 from 16 processes
2024-10-22 00:34:37,637 Finished 0 from 16 processes
2024-10-22 00:34:42,643 Finished 0 from 16 processes
2024-10-22 00:34:47,647 Finished 0 from 16 processes
2024-10-22 00:34:52,652 Finished 0 from 16 processes
2024-10-22 00:34:57,657 Finished 0 from 16 processes
2024-10-22 00:35:02,660 Finished 0 from 16 processes
2024-10-22 00:35:07,665 Finished 0 from 16 processes
2024-10-22 00:35:12,668 Finished 0 from 16 processes
2024-10-22 00:35:17,672 Finished 0 from 16 processes
2024-10-22 00:35:22,676 Finished 0 from 16 processes
2024-10-22 00:35:27,681 Finished 1 from 16 processes
2024-10-22 00:35:32,682 Finished 2 from 16 processes
2024-10-22 00:35:37,684 Finished 2 from 16 processes
2024-10-22 00:35:42,688 Finished 3 from 16 processes
2024-10-22 00:35:47,693 Finished 4 from 16 processes
2024-10-22 00:35:52,696 Finished 5 from 16 processes
2024-10-22 00:35:57,700 Finished 5 from 16 processes
2024-10-22 00:36:02,705 Finished 7 from 16 processes
2024-10-22 00:36:07,710 Finished 7 from 16 processes
2024-10-22 00:36:12,712 Finished 8 from 16 processes
2024-10-22 00:36:17,717 Finished 8 from 16 processes
2024-10-22 00:36:22,720 Finished 8 from 16 processes
2024-10-22 00:36:27,724 Finished 9 from 16 processes
2024-10-22 00:36:32,728 Finished 9 from 16 processes
2024-10-22 00:36:37,732 Finished 9 from 16 processes
2024-10-22 00:36:42,738 Finished 9 from 16 processes
2024-10-22 00:36:47,740 Finished 9 from 16 processes
2024-10-22 00:36:52,744 Finished 10 from 16 processes
2024-10-22 00:36:57,748 Finished 10 from 16 processes
2024-10-22 00:37:02,752 Finished 10 from 16 processes
2024-10-22 00:37:07,756 Finished 11 from 16 processes
2024-10-22 00:37:12,760 Finished 11 from 16 processes
2024-10-22 00:37:17,766 Finished 11 from 16 processes
2024-10-22 00:37:22,768 Finished 12 from 16 processes
2024-10-22 00:37:27,769 Finished 12 from 16 processes
2024-10-22 00:37:32,772 Finished 12 from 16 processes
2024-10-22 00:37:37,777 Finished 12 from 16 processes
2024-10-22 00:37:42,780 Finished 13 from 16 processes
2024-10-22 00:37:47,784 Finished 13 from 16 processes
2024-10-22 00:37:52,788 Finished 13 from 16 processes
2024-10-22 00:37:57,793 Finished 13 from 16 processes
2024-10-22 00:38:02,796 Finished 13 from 16 processes
2024-10-22 00:38:07,800 Finished 13 from 16 processes
2024-10-22 00:38:12,804 Finished 13 from 16 processes
2024-10-22 00:38:17,808 Finished 13 from 16 processes
2024-10-22 00:38:22,812 Finished 13 from 16 processes
2024-10-22 00:38:27,817 Finished 13 from 16 processes
2024-10-22 00:38:32,823 Finished 13 from 16 processes
2024-10-22 00:38:37,828 Finished 13 from 16 processes
2024-10-22 00:38:42,832 Finished 13 from 16 processes
2024-10-22 00:38:47,837 Finished 13 from 16 processes
2024-10-22 00:38:52,843 Finished 13 from 16 processes
2024-10-22 00:38:57,848 Finished 13 from 16 processes
2024-10-22 00:39:02,852 Finished 13 from 16 processes
2024-10-22 00:39:07,856 Finished 13 from 16 processes
2024-10-22 00:39:12,861 Finished 13 from 16 processes
2024-10-22 00:39:17,864 Finished 13 from 16 processes
2024-10-22 00:39:22,868 Finished 13 from 16 processes
2024-10-22 00:39:27,873 Finished 13 from 16 processes
2024-10-22 00:39:32,879 Finished 13 from 16 processes
2024-10-22 00:39:37,880 Finished 13 from 16 processes
2024-10-22 00:39:42,885 Finished 13 from 16 processes
2024-10-22 00:39:47,891 Finished 13 from 16 processes
2024-10-22 00:39:52,892 Finished 14 from 16 processes
2024-10-22 00:39:57,896 Finished 14 from 16 processes
2024-10-22 00:40:02,899 Finished 14 from 16 processes
2024-10-22 00:40:07,904 Finished 14 from 16 processes
2024-10-22 00:40:12,910 Finished 14 from 16 processes
2024-10-22 00:40:17,912 Finished 14 from 16 processes
2024-10-22 00:40:22,917 Finished 14 from 16 processes
2024-10-22 00:40:27,922 Finished 15 from 16 processes
2024-10-22 00:40:32,924 Finished 15 from 16 processes
2024-10-22 00:40:37,929 Finished 15 from 16 processes
2024-10-22 00:40:42,932 Finished 15 from 16 processes
2024-10-22 00:40:47,936 Finished 15 from 16 processes
2024-10-22 00:40:52,940 Finished 15 from 16 processes
2024-10-22 00:40:57,944 Finished 15 from 16 processes
2024-10-22 00:41:02,948 Finished 15 from 16 processes
2024-10-22 00:41:07,953 Finished 15 from 16 processes
2024-10-22 00:41:12,956 Finished 15 from 16 processes
2024-10-22 00:41:17,960 Finished 15 from 16 processes
2024-10-22 00:41:22,964 Finished 15 from 16 processes
2024-10-22 00:41:27,968 Finished 15 from 16 processes
2024-10-22 00:41:32,972 Finished 15 from 16 processes
2024-10-22 00:41:37,975 Finished 15 from 16 processes
2024-10-22 00:41:42,980 Finished 15 from 16 processes
2024-10-22 00:41:47,984 Finished 15 from 16 processes
2024-10-22 00:41:52,988 Finished 15 from 16 processes
2024-10-22 00:41:57,992 Finished 15 from 16 processes
2024-10-22 00:42:02,997 All processes finished
2024-10-22 00:42:02,998 Compressing stress logs
2024-10-22 00:42:03,030 Logs compressed
2024-10-22 00:42:03,030 Will terminate gdb (if any)
Quit
2024-10-22 00:47:07,592 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.33 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)
9323 0.04 539.65 KiB 0.011 4 306 ['Trace'] 0.001 Access granted: {}{}
9270 0.04 1.47 MiB 0.03 1 229 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {})
9052 0.039 1.36 MiB 0.028 3 228 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {}
8431 0.037 378.04 KiB 0.008 1 1 ['Trace'] 1 Processing requests batch, size: {}, bytes: {}
8108 0.035 228.90 KiB 0.005 1 227 ['Debug'] 0 Processed in {} sec.
6480 0.028 449.31 KiB 0.009 133 259 ['Trace'] 0.887 Trying to reserve {} using storage policy from min volume index {}
5980 0.026 519.09 KiB 0.01 1 1916 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.)
5842 0.025 656.08 KiB 0.013 4 246 ['Debug'] 0.997 {} Authenticated with global context as user {}
5842 0.025 475.46 KiB 0.01 4 246 ['Debug'] 0.997 {} Authenticating user \'{}\' from {}
5836 0.025 512.93 KiB 0.01 4 246 ['Debug'] 0.997 {} Logout, user_id: {}
5814 0.025 635.91 KiB 0.013 3 228 ['Debug'] 1 {} Creating session context with user_id: {}
5722 0.025 432.47 KiB 0.009 1 205 ['Debug'] 0.119 Remove from cache. Key: {}, offset: {}, size: {}
5713 0.025 340.33 KiB 0.007 1 74 ['Debug'] 0.975 Key {} is removed from metadata
5434 0.024 160.06 KiB 0.003 1 1883 ['Trace'] 0 Aggregation method: {}
5001 0.022 288.14 KiB 0.006 1 136 ['Debug'] 0.023 Submitting key {} for removal
4915 0.021 159.36 KiB 0.003 2 227 ['Trace'] 1 TCP Request. Address: {}
4915 0.021 476.78 KiB 0.01 1 227 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}.
4893 0.021 129.01 KiB 0.003 1 227 ['Debug'] 1 Done processing connection.
4863 0.021 399.98 KiB 0.008 1 214 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec.
3977 0.017 223.04 KiB 0.004 35 144 ['Debug'] 0.993 Selected {} parts from {} to {}
3760 0.016 443.17 KiB 0.009 138 145 ['Trace'] 0.671 Renaming temporary part {} to {} with tid {}.
3720 0.016 88.44 KiB 0.002 1 236 ['Trace'] 0.002 {} -> {}
3598 0.016 160.29 KiB 0.003 1 220 ['Debug'] 0.136 Peak memory usage{}: {}.
3118 0.014 148.87 KiB 0.003 1 132 ['Trace'] 0.613 filled checksums {}
2639 0.011 28.35 KiB 0.001 1 1526 ['Trace'] 0 Aggregating
2362 0.01 6.33 MiB 0.131 3 88 ['Error'] 0 ReplicatedMergeTree (table {}) does not support transactions
2339 0.01 220.29 KiB 0.004 1 27 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part
2316 0.01 192.19 KiB 0.004 1 1360 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={}
2307 0.01 1.42 MiB 0.029 1 566 ['Debug'] 0.986 Objects with paths [{}] were removed from S3
2219 0.01 6.81 MiB 0.141 11 129 ['Error'] 0.999 Table is in readonly mode (replica path: {})
2132 0.009 3.13 MiB 0.065 1 540 ['Debug'] 0.986 metadata and objects were removed for [{}], only metadata were removed for [{}].
2035 0.009 623.01 KiB 0.013 2016 399 ['Information'] 0 Setting download as failed: {}
2019 0.009 378.76 KiB 0.008 11 13 ['Trace'] 0 ZooKeeperWithFaultInjection call SUCCEEDED: seed={} func={} path={}
1911 0.008 68.32 KiB 0.001 11 11 ['Trace'] 1 Flushed system log up to offset {}
1911 0.008 109.86 KiB 0.002 11 11 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {}
1814 0.008 145.75 KiB 0.003 1797 362 ['Trace'] 0 No space left in cache to reserve {} bytes, will continue without cache download
1520 0.007 300.64 KiB 0.006 2 84 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {}
1519 0.007 504.31 KiB 0.01 2 84 ['Trace'] 1 Request URI: {}
1503 0.007 165.28 KiB 0.003 1 19 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {}
1469 0.006 30.13 KiB 0.001 2 83 ['Debug'] 0.417 Done processing query
1367 0.006 29.91 KiB 0.001 127 130 ['Trace'] 1 Execution took {} ms.
1295 0.006 90.86 KiB 0.002 1 158 ['Trace'] 0.066 Rolling back transaction {}{}
1234 0.005 109.48 KiB 0.002 27 134 ['Trace'] 0.992 Insert entry {} to queue with type {}
1159 0.005 98.99 KiB 0.002 23 920 ['Trace'] 0.998 Part {} local references is zero, will check blobs can be removed in zookeeper
1157 0.005 192.57 KiB 0.004 22 918 ['Trace'] 1 Remove zookeeper lock {} for part {}
1077 0.005 52.40 KiB 0.001 37 128 ['Trace'] 1 Scheduling next merge selecting task after {}ms
1044 0.005 57.46 KiB 0.001 1 300 ['Trace'] 0.314 Created HTTP(S) session with {}:{} ({}:{})
969 0.004 90.78 KiB 0.002 1 57 ['Trace'] 0 No entry found for query {}
915 0.004 70.59 KiB 0.001 1 176 ['Trace'] 0 Query span trace_id for opentelemetry log: {}
892 0.004 122.59 KiB 0.002 22 128 ['Trace'] 1 Checked {} partitions, found {} partitions with parts that may be merged: [{}](max_total_size_to_merge={}, merge_with_ttl_allowed{})
729 0.003 18.51 KiB 0 27 134 ['Debug'] 0.992 Pulled {} entries to queue.
729 0.003 42.00 KiB 0.001 27 134 ['Debug'] 0.992 Pulling {} entries to queue: {} - {}
687 0.003 78.50 KiB 0.002 551 286 ['Trace'] 0 Bypassing cache because file segment state is `PARTIALLY_DOWNLOADED_NO_CONTINUATION` and downloaded part already used
678 0.003 26.07 KiB 0.001 18 24 ['Debug'] 0.897 Part {} committed to zookeeper
678 0.003 26.73 KiB 0.001 18 24 ['Debug'] 0.897 Committing part {} to zookeeper
620 0.003 148.37 KiB 0.003 1 33 ['Trace'] 0.989 Sending request to {}
613 0.003 39.51 KiB 0.001 17 28 ['Trace'] 1 Trying to reserve {} on the selected disk: {} (with type {})
613 0.003 102.08 KiB 0.002 17 28 ['Trace'] 1 Zookeeper temporary ephemeral lock {} created
613 0.003 17.37 KiB 0 17 28 ['Trace'] 1 Checking disk {} with type {}
613 0.003 47.30 KiB 0.001 17 28 ['Trace'] 1 Disk for fetch is not provided, getting disk from reservation {} with type \'{}\'
613 0.003 60.02 KiB 0.001 17 28 ['Debug'] 1 Downloading part {} unique id {} metadata onto disk {}.
613 0.003 14.52 KiB 0 13 40 ['Trace'] 1 Sending part {}
613 0.003 31.73 KiB 0.001 17 28 ['Trace'] 1 Disk {} (with type {}) supports zero-copy replication
613 0.003 99.68 KiB 0.002 17 28 ['Trace'] 1 Set zookeeper temporary ephemeral lock {}
613 0.003 52.68 KiB 0.001 17 28 ['Trace'] 1 Trying to fetch with zero-copy replication, but disk is not provided, will try to select
612 0.003 25.85 KiB 0.001 14 453 ['Trace'] 1 Blobs of part {} cannot be removed
612 0.003 65.29 KiB 0.001 16 28 ['Debug'] 1 Download of part {} unique id {} metadata onto disk {} finished.
611 0.003 96.84 KiB 0.002 14 452 ['Trace'] 1 Found {} ({}) zookeeper locks for {}
609 0.003 66.11 KiB 0.001 17 24 ['Debug'] 1 Fetching part {} from {}:{}
608 0.003 65.40 KiB 0.001 16 24 ['Debug'] 1 Fetched part {} from {}:{}{}
564 0.002 4.96 KiB 0 2 52 ['Trace'] 0.004 No tables
546 0.002 100.08 KiB 0.002 12 466 ['Trace'] 1 No more children left for for {}, will try to remove the whole node
545 0.002 89.10 KiB 0.002 11 465 ['Trace'] 1 Removed last parent zookeeper lock {} for part {} (part is finally unlocked)
545 0.002 120.50 KiB 0.002 11 465 ['Trace'] 1 Removed last parent zookeeper lock {} for part {} with id {}
509 0.002 41.00 KiB 0.001 1 55 ['Trace'] 0.008 Reading {} ranges in order from part {}, approx. {} rows starting from {}
500 0.002 2.90 MiB 0.06 2 21 ['Error'] 0 Error while executing table function merge. Either there is no database, which matches regular expression `{}`, or there are no tables in database matches `{}`, which fit tables expression: {}
499 0.002 91.32 KiB 0.002 15 20 ['Trace'] 0.008 Trying to create zookeeper persistent lock {} with hardlinks [{}]
483 0.002 40.07 KiB 0.001 1 30 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {}
483 0.002 16.50 KiB 0 1 30 ['Debug'] 0 Selected MergeAlgorithm: {}
481 0.002 31.39 KiB 0.001 33 30 ['Trace'] 0 Merged {} parts: [{}, {}] -> {}
481 0.002 62.76 KiB 0.001 1 30 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec.
480 0.002 75.18 KiB 0.002 15 20 ['Trace'] 0.008 Zookeeper persistent lock {} created
477 0.002 31.98 KiB 0.001 11 16 ['Debug'] 1 Part {} is rendered obsolete by fetching part {}
477 0.002 34.31 KiB 0.001 14 16 ['Debug'] 0 Wrote block with ID \'{}\', {} rows{}
416 0.002 1.46 MiB 0.03 4 64 ['Error'] 0.026 Table {}.{} does not exist
414 0.002 65.04 KiB 0.001 13 15 ['Trace'] 0 ZooKeeperWithFaultInjection report: name={} seed={} calls_total={} calls_succeeded={} calls_failed={} failure_rate={}
413 0.002 55.83 KiB 0.001 12 14 ['Trace'] 0 ZooKeeperWithFaultInjection created: name={} seed={} fault_probability={}
399 0.002 13.94 KiB 0 102 69 ['Debug'] 0.01 Key condition: {}
394 0.002 84.14 KiB 0.002 28 36 ['Information'] 1 {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting)
391 0.002 44.96 KiB 0.001 101 69 ['Debug'] 0.01 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges
372 0.002 8.36 KiB 0 1 321 ['Trace'] 0 Merging aggregated data
355 0.002 31.31 KiB 0.001 1 54 ['Trace'] 0.704 Close WriteBufferFromS3. {}.
355 0.002 87.08 KiB 0.002 1 54 ['Trace'] 0.699 Create WriteBufferFromS3, {}
353 0.002 36.96 KiB 0.001 1 94 ['Trace'] 0.703 Single part upload has completed. {}, size {}
347 0.002 10.17 KiB 0 36 125 ['Debug'] 0.945 Updating strategy picker state
346 0.002 32.82 KiB 0.001 1 54 ['Trace'] 0.717 finalizeImpl WriteBufferFromS3. {}.
328 0.001 66.92 KiB 0.001 1 119 ['Information'] 1 Removing metadata {} of dropped table {}
328 0.001 42.52 KiB 0.001 1 119 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {}
328 0.001 24.34 KiB 0 1 69 ['Debug'] 0 Waiting for table {} to be finally dropped
327 0.001 16.92 KiB 0 88 66 ['Trace'] 0.012 Spreading mark ranges among streams (default reading)
Top messages without format string (fmt::runtime):
count pattern runtime_message line
UInt64 String String Tuple(String, UInt64)
48 CodeDBExceptionOkwhileexecutingF Code: 395. DB::Exception: Ok: while executing \'FUNCTION throwIf(greater(number, 10000000) :: 1, \'Ok\' :: 4) -> throwIf(greater(number, 10000000), \'Ok\') UInt8 : 3\'. (FUNCTION_THROW_IF_VALUE_IS_NON_ZERO) (version 23.8.16.42.altinitystable (altinity build)) (f ('/executeQuery.cpp',207)
9 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() @ 0x000000001db0d175 in /usr/bin/clickhouse\n1. ./build_docker/./base/poco/Foundation/ ('/Exception.cpp',235)
8 EntryconnectionsendingPINGtochec Entry(connection 0): sending PING to check if it is alive. ('',0)
8 EntryconnectionPINGok Entry(connection 0): PING ok. ('',0)
4 RunningMySQLqueryusingconnection Running MySQL query using connection 0 ('',0)
4 CreatedMySQLPoolwithsettingsconn Created MySQL Pool with settings: connect_timeout=10, read_write_timeout=300, default_connections_number=1, max_connections_number=16 ('',0)
3 Connectingtomysqldbasusermysqlus Connecting to mysql_db@127.123.0.1:3306 as user mysql_user ('',0)
3 mysqlxxConnectionFailed mysqlxx::ConnectionFailed ('',0)
3 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 18 ('/LoggerWrapper.h',42)
3 Connectiontomysqlfailedtimes Connection to mysql failed 1 times ('',0)
3 Connectiontomysqldbasusermysqlus Connection to mysql_db@127.123.0.1:3306 as user mysql_user failed: mysqlxx::ConnectionFailed: Can\'t connect to MySQL server on \'127.123.0.1\' (115) ((nullptr):0) ('',0)
3 CreatinganewMySQLconnectiontomys Creating a new MySQL connection to mysql_db@127.123.0.1:3306 as user mysql_user with settings: connect_timeout=10, read_write_timeout=300 ('',0)
2 systemasuserUSERRemovingconnecti (system@127.0.0.1:9004 as user 02834_USER_13466): Removing connection. ('',0)
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.42.altinitystabl ('/executeQuery.cpp',207)
2 CodeDBExceptionBadURIsyntaxURIco Code: 1000. DB::Exception: Bad URI syntax: URI contains invalid characters. (POCO_EXCEPTION), Stack trace (when copying this message, always include the lines below):\n\n0. std::exception::capture() @ 0x000000001db0d175 in /usr/bin/clickhouse\n1. ./build_dock ('/TCPHandler.cpp',680)
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 ConnectingtosystemasuserUSER Connecting to system@127.0.0.1:9004 as user 02834_USER_13466 ('',0)
2 skippedconfiglatestconfig skipped config 1, latest config 18 ('/LoggerWrapper.h',42)
2 CodeDBExceptionCodeDBExceptionTa Code: 60. DB::Exception: Code: 60. DB::Exception: Table test_7.table_for_dict does not exist. (UNKNOWN_TABLE) (version 23.8.16.42.altinitystable (altinity build)). (UNKNOWN_TABLE) (version 23.8.16.42.altinitystable (altinity build)) (from [::1]:49716) (com ('/executeQuery.cpp',207)
2 CreatinganewMySQLconnectiontosys Creating a new MySQL connection to system@127.0.0.1:9004 as user 02834_USER_13466 with settings: connect_timeout=10, read_write_timeout=300 ('',0)
2 CodeDBExceptionSyntaxerrorcolumn Code: 62. DB::Exception: Syntax error (columns declaration list): failed at position 1 (\'\0\'): \0. Unrecognized token: \'\0\'. (SYNTAX_ERROR) (version 23.8.16.42.altinitystable (altinity build)) (from [::1]:40820) (comment: 00746_sql_fuzzy.sh) (in query: SELECT ('/executeQuery.cpp',207)
2 PocoExceptionCodeecodeBadURIsynt Poco::Exception. Code: 1000, e.code() = 0, Bad URI syntax: URI contains invalid characters (version 23.8.16.42.altinitystable (altinity build)) (from [::1]:34398) (comment: 00746_sql_fuzzy.sh) (in query: SELECT * FROM url(\'\\0\', \'!DuXzs\');), Stack trace (wh ('/executeQuery.cpp',207)
1 IfthesignaturecheckfailedThiscou If the signature check failed. This could be because of a time skew. Attempting to adjust the signer. ('/AWSLogger.cpp',71)
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 Forkedachildprocesstowatch Forked a child process to watch ('',0)
1 ThreadFuzzerisenabledApplication ThreadFuzzer is enabled. Application will run slowly and unstable. ('',0)
1 newconfigurationlogidxprevlogidx new configuration: log idx 105, prev log idx 18\npeer 1, DC ID 0, localhost:9234, voting member, 1\nmy id: 1, leader: 1, term: 3 ('/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) 266 /var/lib/clickhouse/disks/s3_disk/store/22a/22a56910-e49f-4d4d-abba-60ab2b1fb177/tmp_merge_201403_5_21_1/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 1 similar messages)
97 Forked a child process to watch
(from {}{}{}){}{} {} (stage: {}) 1 (from [::1]:40630) (comment: 01674_unicode_asan.sql) SELECT positionCaseInsensitiveUTF8(\'иголка.ру\', \'иголка.р�\\0\') AS res; (stage: Complete)
Top short messages:
c message_format_string substring(any(message), 1, 120) min_length_without_exception_boilerplate
UInt64 LowCardinality(String) String Int64
6 Session expired void DB::StorageReplicatedMergeTree::mutationsUpdatingTask(): Code: 999. Coordination::Exception: Session expired. (KEEP 77
2 Illegal type {} of first argument of function {}. Conversion functions with postfix \'OrZero\' or \'OrNull\' should take String argument Code: 43. DB::Exception: Illegal type Array(Array(String)) of first argument of function toUUIDOrNull. Conversion functi -15
1 Found {} on {} Found changelog_1_100000.bin.zstd on LocalLogDisk 23
Top messages by level:
(0.010249333923472798,'ReplicatedMergeTree (table {}) does not support transactions') Error
(0.00012149930137901708,'It\'s not recommended to explicitly specify zookeeper_path and replica_name in ReplicatedMergeTree arguments') Warning
(0.00883039565379642,'Setting download as failed: {}') Information
(0.040224947277981725,'(from {}{}{}){}{} {} (stage: {})') Debug
(0.040454928098449146,'Access granted: {}{}') Trace
2024-10-22 00:47:11,379 Stress test finished
+ echo -e 'Test script exit code\tOK\t\N\t'
+ rg -Fa 'No queries hung' /test_output/test_results.tsv
+ grep -Fa OK
No queries hung OK \N
+ stop
+ local max_tries=90
+ local check_hang=true
+ local pid
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ pid=1754
+ clickhouse stop --max-tries 90 --do-not-kill
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1754.
The process with pid = 1754 is running.
Sent terminate signal to process with pid 1754.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1754.
The process with pid = 1754 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1754.
The process with pid = 1754 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1754.
The process with pid = 1754 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1754.
The process with pid = 1754 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1754.
The process with pid = 1754 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1754.
The process with pid = 1754 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1754.
The process with pid = 1754 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 1754.
The process with pid = 1754 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 - - [21/Oct/2024:22:47:19 +0000] "PUT /devstoreaccount1/cont?restype=container HTTP/1.1" 409 -
127.0.0.1 - - [21/Oct/2024:22:47:20 +0000] "PUT /devstoreaccount1/cont/ztdbfxmsvkvqaedwhifenmaekrzyands?blockid=whtrwdvtkebfzvnpkhractcbjyusteaeqbvzblzqwnkkcdgpcgtcrpmvhkftkeyv&comp=block HTTP/1.1" 201 -
127.0.0.1 - - [21/Oct/2024:22:47:20 +0000] "PUT /devstoreaccount1/cont/ztdbfxmsvkvqaedwhifenmaekrzyands?comp=blocklist HTTP/1.1" 201 -
127.0.0.1 - - [21/Oct/2024:22:47:20 +0000] "GET /devstoreaccount1/cont/ztdbfxmsvkvqaedwhifenmaekrzyands HTTP/1.1" 206 4
127.0.0.1 - - [21/Oct/2024:22:47:20 +0000] "GET /devstoreaccount1/cont/ztdbfxmsvkvqaedwhifenmaekrzyands HTTP/1.1" 206 2
127.0.0.1 - - [21/Oct/2024:22:47:20 +0000] "DELETE /devstoreaccount1/cont/ztdbfxmsvkvqaedwhifenmaekrzyands 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
++ cat /var/run/clickhouse-server/clickhouse-server.pid
+ ts '%Y-%m-%d %H:%M:%S'
+ gdb -batch -command script.gdb -p 28456
+ 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=28456
+ 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 = 28456.
The process with pid = 28456 is running.
Sent terminate signal to process with pid 28456.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 28456.
The process with pid = 28456 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 28456.
The process with pid = 28456 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 28456.
The process with pid = 28456 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 28456.
The process with pid = 28456 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 28456.
The process with pid = 28456 is running.
Waiting for server to stop
/var/run/clickhouse-server/clickhouse-server.pid file exists and contains pid = 28456.
The process with pid = 28456 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