How do I install the Doris Debug skill?

Run npx skillmds@latest add apache/doris-debug in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Doris Debug safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Doris Debug?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Doris Debug free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Doris Debug?

apache (@apache) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Doris Debug by apache — Agent Skill

Name: Doris Debug
Author: apache

Doris Debug

Apache Doris production diagnostics router. Use when Apache Doris queries are slow, imports are failing or timing out, compaction is raising -235 errors, nodes are OOM or crashing, materialized views are not rewriting, or tablet/replica health is degraded. Routes to the appropriate doris-debug-* skill. Covers shared-nothing and cloud (storage-compute separation) deployments.

apache 30ecac9 8 files · 46.6 KB Updated Sep 17, 2026

File contents

Doris Debug Router

How to use

Identify the symptom domain from the table below.
Read shared/references/01-common-commands.md for diagnostic SQL and API commands.
Read shared/references/02-source-map.md to map symptoms to Apache Doris source code locations.
Open the target skill (<domain>/SKILL.md) and follow its cause table and decision tree.
Check shared/references/03-case-index.md for matching production case patterns.

Skill routing

Symptom	Skill
Slow / timeout / hanging query, Profile analysis, Exchange WaitForData	`query/SKILL.md`
Stream Load / Broker Load / Routine Load failure, Group Commit WAL pile-up	`import/SKILL.md`
-235 / too many versions, compaction score high, compaction lag	`compaction/SKILL.md`
BE/FE OOM, crash, false Alive, memory leak	`node/SKILL.md`
Sync MV miss, async MTMV refresh/rewrite issues	`materialized-view/SKILL.md`
Tablet replica missing, clone backlog, disk skew, tablet repair	`tablet/SKILL.md`
FE/BE startup failure, port conflict, priority_networks misconfig	`deployment/SKILL.md`
Hive/Iceberg/Paimon/Glue catalog query failure, metadata refresh, S3/HDFS connectivity	`data-lake/SKILL.md`
Workload Group queue starvation, CPU/memory isolation leaks, spill issues	`resource-isolation/SKILL.md`
Storage-compute separation, meta-service latency, file cache, warmup	`cloud/SKILL.md`

Shared references

Document	Content
`shared/references/01-common-commands.md`	Diagnostic SQL, HTTP API, and CLI commands
`shared/references/02-source-map.md`	Symptom → Doris source code mapping (with version annotations)
`shared/references/03-case-index.md`	45 production case summaries across 8 domains
`shared/references/04-metrics-guide.md`	Per-domain key metrics with thresholds
`shared/references/05-config-quick-ref.md`	Per-domain key configuration parameters with tuning guidance
`shared/guides/`	Cross-module cascade troubleshooting

Companion skills

doris-profile-reader: Deep Profile analysis for query bottlenecks (referenced by query/SKILL.md Cause C — BE compute bottleneck).
doris-best-practices: Preventive table design and configuration guidance.
doris-architecture-advisor: Workload-aware architecture decisions.

Methodology

Client → FE → BE → Disk/Network top-down investigation
Logs / Metrics / Profile / SHOW PROC evidence first
Stop the bleeding (throttle, kill, reset_rpc_channel) before root cause
Verify hypotheses against Doris source code (02-source-map.md)
Match known case patterns (03-case-index.md) to avoid rediscovery

---name: doris-debugdescription: Apache Doris production diagnostics router. Use when Apache Doris queries are slow, imports are failing or timing out, compaction is raising -235 errors, nodes are OOM or crashing, materialized views are not rewriting, or tablet/replica health is degraded. Routes to the appropriate doris-debug-* skill. Covers shared-nothing and cloud (storage-compute separation) deployments.---# Doris Debug Router## How to use1. Identify the symptom domain from the table below.2. Read `shared/references/01-common-commands.md` for diagnostic SQL and API commands.3. Read `shared/references/02-source-map.md` to map symptoms to Apache Doris source code locations.4. Open the target skill (`<domain>/SKILL.md`) and follow its cause table and decision tree.5. Check `shared/references/03-case-index.md` for matching production case patterns.## Skill routing| Symptom | Skill ||---------|-------|| Slow / timeout / hanging query, Profile analysis, Exchange WaitForData | `query/SKILL.md` || Stream Load / Broker Load / Routine Load failure, Group Commit WAL pile-up | `import/SKILL.md` || -235 / too many versions, compaction score high, compaction lag | `compaction/SKILL.md` || BE/FE OOM, crash, false Alive, memory leak | `node/SKILL.md` || Sync MV miss, async MTMV refresh/rewrite issues | `materialized-view/SKILL.md` || Tablet replica missing, clone backlog, disk skew, tablet repair | `tablet/SKILL.md` || FE/BE startup failure, port conflict, priority_networks misconfig | `deployment/SKILL.md` || Hive/Iceberg/Paimon/Glue catalog query failure, metadata refresh, S3/HDFS connectivity | `data-lake/SKILL.md` || Workload Group queue starvation, CPU/memory isolation leaks, spill issues | `resource-isolation/SKILL.md` || Storage-compute separation, meta-service latency, file cache, warmup | `cloud/SKILL.md` |## Shared references| Document | Content ||----------|---------|| `shared/references/01-common-commands.md` | Diagnostic SQL, HTTP API, and CLI commands || `shared/references/02-source-map.md` | Symptom → Doris source code mapping (with version annotations) || `shared/references/03-case-index.md` | 45 production case summaries across 8 domains || `shared/references/04-metrics-guide.md` | Per-domain key metrics with thresholds || `shared/references/05-config-quick-ref.md` | Per-domain key configuration parameters with tuning guidance || `shared/guides/` | Cross-module cascade troubleshooting |## Companion skills- `doris-profile-reader`: Deep Profile analysis for query bottlenecks (referenced by `query/SKILL.md` Cause C — BE compute bottleneck).- `doris-best-practices`: Preventive table design and configuration guidance.- `doris-architecture-advisor`: Workload-aware architecture decisions.## Methodology1. Client → FE → BE → Disk/Network top-down investigation2. Logs / Metrics / Profile / `SHOW PROC` evidence first3. Stop the bleeding (throttle, kill, `reset_rpc_channel`) before root cause4. Verify hypotheses against Doris source code (`02-source-map.md`)5. Match known case patterns (`03-case-index.md`) to avoid rediscovery

Frequently asked questions