CH test log

03540_system_dashboards.log

Starting ClickHouse server replica 0, command: clickhouse-server --config-file /etc/clickhouse-server/config.xml --pid-file /etc/clickhouse-server/clickhouse-server.pid -- --path /home/aaf/ClickHouse/ci/tmp/run_r0 --user_files_path /home/aaf/ClickHouse/ci/tmp/run_r0/user_files --top_level_domains_path /etc/clickhouse-server/top_level_domains --logger.stderr /home/aaf/ClickHouse/ci/tmp/var/log/clickhouse-server/stderr.log
rm: cannot remove '/etc/clickhouse-server/clickhouse-server.pid': No such file or directory
Run command: [rm -rf /home/aaf/ClickHouse/ci/tmp/run_r0 && mkdir -p /home/aaf/ClickHouse/ci/tmp/run_r0]
Run command: [rm -rf /home/aaf/ClickHouse/ci/tmp/jemalloc_profiles && mkdir -p /home/aaf/ClickHouse/ci/tmp/jemalloc_profiles]
TSAN_OPTIONS = memory_limit_mb=5146
WARNING: stderr: cat: /etc/clickhouse-server/clickhouse-server.pid: No such file or directory
Got pid from fs [1591]
ClickHouse server replica 0 started successfully, pid [1591]
Run command [clickhouse-client --port 9000 --query "select 1"]
Server replica 0 ready
Run command: [clickhouse-client --enable_json_type=1 --query "CREATE TABLE system.minio_audit_logs (log JSON(time DateTime64(9))) ENGINE = MergeTree ORDER BY tuple()"]
Run command: [clickhouse-client --enable_json_type=1 --query "CREATE TABLE system.minio_server_logs (log JSON(time DateTime64(9))) ENGINE = MergeTree ORDER BY tuple()"]
Run command: [/mc admin config set clickminio logger_webhook:ch_server_webhook endpoint="http://localhost:8123/?async_insert=1&wait_for_async_insert=0&async_insert_busy_timeout_min_ms=5000&async_insert_busy_timeout_max_ms=5000&async_insert_max_query_number=1000&async_insert_max_data_size=10485760&date_time_input_format=best_effort&query=INSERT%20INTO%20system.minio_server_logs%20FORMAT%20JSONAsObject" queue_size=1000000 batch_size=500]
Successfully applied new settings.
Run command: [/mc admin config set clickminio audit_webhook:ch_audit_webhook endpoint="http://localhost:8123/?async_insert=1&wait_for_async_insert=0&async_insert_busy_timeout_min_ms=5000&async_insert_busy_timeout_max_ms=5000&async_insert_max_query_number=1000&async_insert_max_data_size=10485760&date_time_input_format=best_effort&query=INSERT%20INTO%20system.minio_audit_logs%20FORMAT%20JSONAsObject" queue_size=1000000 batch_size=500]
Successfully applied new settings.
Run command [/mc admin service restart clickminio --wait --json 2>&1 | jq -r .status]
INFORMATION_SCHEMA
default
information_schema
system
hits_v1
visits_v1
Received exception from server (version 25.8.1):
Code: 241. DB::Exception: Received from localhost:9000. DB::Exception: (total) memory limit exceeded: would use 5.16 GiB (attempt to allocate chunk of 1.02 MiB bytes), current RSS: 4.47 GiB, maximum: 5.16 GiB. OvercommitTracker decision: Query was selected to stop by OvercommitTracker: (while reading column IsLink): (while reading from part 201403_1_1_2/ in table test.hits (7ef7e221-0a0d-45a0-badf-4b6630fa9d93) located on disk __tmp_internal_325334521043092652615993805997949893747 of type web, from mark 176 with max_rows_to_read = 8192, offset = 0): While executing MergeTreeSelect(pool: ReadPool, algorithm: Thread). (MEMORY_LIMIT_EXCEEDED)
(query: INSERT INTO test.hits_s3 SELECT * FROM test.hits SETTINGS enable_filesystem_cache_on_write_operations=0, write_through_distributed_cache=0, max_insert_threads=16)