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.

Jump to install

Repository: apache/doris-skills
Last source activity: July 24, 2026 at 23:41
Detected SKILL.md language: English
Stars: 32
Forks: 9

Install options

The review-first prompt is selected by default. You can switch to a direct command or download a local copy.

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

A direct command skips the review prompt. Inspect the source before running it.

npx skills add https://github.com/apache/doris-skills --skill doris-debug

The command stays on one line. Scroll horizontally to inspect it before copying.

Prefer a local copy? Download the files currently available to SkillsMP.

Review the source files

Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.

File Explorer

34 files

SKILL.md

Source instructions · Read-only preview

Back to search Back to installation

doris-repo-review

Given a PR URL (`/doris-repo-review https://github.com/apache/doris/pull/66807`), first check whether the current directory's branch and commit match that PR, and if they do not, align the current directory to the PR head without disturbing local work (refuse to switch when tracked files are modified and hand the decision back to the user); then review it with the same pipeline apache/doris CI runs (Code Review Runner) - main-agent risk scan, 1-3 full-review subagents plus risk-focused subagents, shared-ledger convergence (at most 3 rounds), and one English plus one Chinese review document written into review-docs/. A local run has no GitHub inline comments, so every finding must carry a path:line anchor and a verbatim snippet, verified by a script. When the review passes (no Blocker and no Major), it also posts one strongly formatted, machine-readable PASS comment on the PR from the local gh account - review date, reviewed commit sha, status, model, and notes for maintainers - after showing the exact body to

2026-08-20

doris-debug-cloud

Use for Doris storage-compute separation (cloud mode) issues: meta-service latency, cache miss storms, object store throughput, and shared-nothing config conflicts in compute groups.

2026-07-24

doris-debug-compaction

Use for Doris -235 / too many versions and compaction lag. Error raised in RowsetBuilder::check_tablet_version_count when version_count > max_tablet_version_num (default 2000) or meta serialize size limit.

2026-07-24

View all from this repository

name	doris-debug
description	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.
version	0.3.0

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

doris-debug

Source facts

Install options

Review the source files

More from this repository

Doris Debug Router

How to use

Skill routing

Shared references

Companion skills

Methodology

Doris Debug Router

How to use

Skill routing

Shared references

Companion skills

Methodology

More from this repository