resource-isolation

Diagnose StarRocks resource isolation failures via audit logs and metrics.

73|12|Updated Apr 24, 2026
One-click install
npx skills add https://github.com/StarRocks/starrocks-debug-skills --skill resource-isolation
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: resource-isolation
Source: https://github.com/StarRocks/starrocks-debug-skills/tree/main/resource-isolation
Command: npx skills add https://github.com/StarRocks/starrocks-debug-skills --skill resource-isolation

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

It helps teams diagnose and correct StarRocks workload isolation failures that make queries slow, get rejected, or starve other workloads.

Core Features & Use Cases

  • Unclassified Query Detection: Finds queries falling into default_wg so you can add the right classifiers.
  • Governance Tuning: Guides resource group limits, query queue sizing, big query circuit breakers, and SQL blacklisting.
  • Production Incident Response: Helps with memory spill contention, queue full rejections, and statistics collection saturation.
  • Recovery Validation: Shows how to confirm classification, limit enforcement, and latency recovery after a fix.

Quick Start

Use this Skill to analyze the attached StarRocks incident details and recommend the fastest safe configuration changes to stop workload starvation.

Frequently Asked Questions about resource-isolation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
Why are StarRocks queries falling into default_wg instead of their assigned resource groups?

StarRocks queries fall into default_wg when resource group classifiers are missing or mismatched. Diagnose this by analyzing audit logs to identify unclassified queries and adding the correct classifiers to enforce proper workload isolation.

How do I stop long-running analytical queries from bypassing memory limits and triggering spilling in StarRocks?

To stop long-running analytical queries from bypassing limits and triggering spilling, inspect BE metrics and tune big query circuit breakers. Adjusting resource group limits and queue sizing prevents memory spill contention and restores stable latency.

What is the best way to handle StarRocks query queue full rejections during traffic bursts?

The best way to handle StarRocks query queue full rejections during traffic bursts is to review and adjust query queue sizing. Configuring resource group limits and big query circuit breakers safely absorbs bursts without starving other workloads.

How do I prevent statistics collection jobs from overwhelming StarRocks BRPC worker threads?

Prevent statistics collection jobs from overwhelming StarRocks BRPC worker threads by diagnosing statistics collection saturation. Inspect FE and BE metrics to identify the saturation point and apply emergency configuration changes to restore fair scheduling.

Can I use a SQL blacklist to block specific big queries from starving StarRocks workloads?

Yes, you can use a SQL blacklist to block specific big queries from starving StarRocks workloads. Governance tuning guides the configuration of SQL blacklists alongside resource group limits and circuit breakers to enforce query isolation.

How do I validate StarRocks workload isolation and latency recovery after changing resource group configurations?

Validate StarRocks workload isolation and latency recovery by confirming query classification and limit enforcement. Analyze audit logs and FE metrics to verify that queries are no longer falling into default_wg and fair scheduling is restored.