Skip to main content

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/doris-skills
최근 소스 활동
2026년 7월 24일 23:41
감지된 SKILL.md 언어
영어
스타
46
포크
15

설치 방법

기본적으로 소스를 먼저 확인하는 Prompt가 선택됩니다. 직접 명령으로 전환하거나 로컬 사본을 다운로드할 수도 있습니다.

소스 파일 검토

설치 여부를 결정하기 전에 SKILL.md와 SkillsMP에 표시된 보조 파일을 읽어 보세요.

파일 탐색기
34 개 파일

SKILL.md 표시 중

SKILL.md
소스 지침 · 읽기 전용 미리보기
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 1. 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. ## Methodology 1. Client → FE → BE → Disk/Network top-down investigation 2. Logs / Metrics / Profile / `SHOW PROC` evidence first 3. Stop the bleeding (throttle, kill, `reset_rpc_channel`) before root cause 4. Verify hypotheses against Doris source code (`02-source-map.md`) 5. Match known case patterns (`03-case-index.md`) to avoid rediscovery
GitHub에서 보기