StarRocks / starrocks

The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.
https://starrocks.io
Apache License 2.0
8.98k stars 1.8k forks source link

High System Load and abrtd Activity When Accessing BE Compaction Status on StarRocks 3.2.6 #45324

Open timlincool opened 6 months ago

timlincool commented 6 months ago

Steps to reproduce the behavior (Required)

  1. Navigate to the compaction status page via http://<ip>/api/compaction/show?tablet_id=
  2. Monitor system load and system logs as the load increases.

Expected behavior (Required)

The compaction status page should load without causing high system load or failures, displaying the current compaction status of the specified tablet.

Real behavior (Required)

Unable to view the compaction status page. The system's load spikes to 100%, and the abrtd service starts collecting crash reports, leading to significant performance degradation. Here are the relevant logs and system outputs:

abrtd.service - ABRT Automated Bug Reporting Tool Loaded: loaded (/usr/lib/systemd/system/abrtd.service; enabled; vendor preset: enabled) Active: active (running) since Fri 2024-04-19 10:01:29 CST; 2 weeks 6 days ago Main PID: 864 (abrtd) CGroup: /system.slice/abrtd.service └─864 /usr/sbin/abrtd -d -s

Apr 19 10:01:29 host32 systemd[1]: Started ABRT Automated Bug Reporting Tool. Apr 19 10:01:31 host32 abrtd[864]: Init complete, entering main loop May 09 10:14:15 host32 abrt-server[18280]: Executable '/root/StarRocks-3.2.6/be/lib/starrocks_be' doesn't belong to any package and ProcessUnpackaged is set to 'no' May 09 10:14:15 host32 abrt-server[18280]: 'post-create' on '/var/spool/abrt/ccpp-2024-05-09-10:13:32-18302' exited with 1 May 09 10:14:15 host32 abrt-server[18280]: Deleting problem directory '/var/spool/abrt/ccpp-2024-05-09-10:13:32-18302' May 09 10:36:03 host32 abrt-server[22381]: Executable '/root/StarRocks-3.2.4/be/lib/starrocks_be' doesn't belong to any package and ProcessUnpackaged is set to 'no' May 09 10:36:03 host32 abrt-server[22381]: 'post-create' on '/var/spool/abrt/ccpp-2024-05-09-10:30:36-18737' exited with 1 May 09 10:36:03 host32 abrt-server[22381]: Deleting problem directory '/var/spool/abrt/ccpp-2024-05-09-10:30:36-18737'

StarRocks version (Required)

Additional context

The issue appears to resolve itself temporarily, as subsequent attempts to access the page successfully display the compaction status without issues, though it's unclear if this is related to the error logs found in be.out, which include messages about segmentation faults during compaction status retrieval.

github-actions[bot] commented 3 days ago

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!