agentsclimarketplace

Troubleshooting

Skill iceflower/agent-skills/troubleshooting

Agent Skills 오픈 표준 기반 AI 코딩 에이전트용 스킬 컬렉션 (Java, Kotlin, Spring, NestJS, K8s, Terraform, GraphQL, gRPC, OpenTelemetry, a11y, i18n 등 60개)

Install
npx -y skills add iceflower/agent-skills --skill troubleshooting

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • 0 stars0 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

General debugging and troubleshooting patterns for slow APIs, deployment rollback, connection issues, OOMKilled pods, CrashLoopBackOff, and debugging principles. Covers root cause analysis, incident triage workflows, error stack trace analysis, pod logs inspection, metrics anomaly detection, alert investigation, and systematic debugging methodologies. Use when diagnosing errors, performing root cause analysis on production incidents, investigating alert anomalies, or triaging deployment failures.

The file declares its own license as MIT. That is the author’s claim about this one file, and it is not the same thing as the license GitHub reports for the repository, which is listed with the other numbers below.

SKILL.md

6.4 KB, as published. Nobody here has run it

Troubleshooting Rules

1. Slow API Response

Bottleneck Identification

  1. Identify the bottleneck layer: Controller → Service → Repository → External API
  2. Check database queries: Enable query logging or check slow query log
  3. Check N+1 queries: Look for repeated similar queries in logs
  4. Check external API calls: Measure response time of downstream services
  5. Check thread/connection pool exhaustion: Monitor active thread count and pool usage

Common Causes and Fixes

CauseDiagnosisFix
N+1 queriesMultiple similar SQL in logsUse join fetch or batch loading
Missing indexSlow query log, full table scanAdd appropriate index
Large payload serializationHigh CPU during responseUse pagination, field selection
Synchronous external APIThread blocked waitingUse async call or timeout
Connection pool exhaustionRequests queued, pool warningsIncrease pool size or optimize query
No cachingSame expensive query repeatedAdd cache layer

2. Deployment Rollback

Rollback Criteria (any of the following)

  • Error rate exceeds baseline by 5x or more
  • P99 latency exceeds SLA threshold
  • Critical business flow is broken (login, payment, etc.)
  • Crash loop detected in pods
  • Data corruption observed

Kubernetes Rollback Procedure

# Rollback to previous revision
kubectl rollout undo deployment/<app-name> -n <namespace>

# Verify rollback status
kubectl rollout status deployment/<app-name> -n <namespace>

# Check pod health after rollback
kubectl get pods -n <namespace> -l app=<app-name>

Post-Rollback Checklist

  • Verify application health and metrics returned to normal
  • Notify team of rollback and reason
  • Create incident report if applicable
  • Root-cause analysis before re-deploying the change
  • Add test coverage for the failure scenario

3. Connection and Network Issues

See references/database-connection-troubleshooting.md for detailed HikariCP pool sizing, leak detection, and connection pool troubleshooting patterns.

Database Connection

SymptomCheckFix
Connection refusedIs DB running? Port open?Verify DB status and network/firewall
Connection timed outNetwork latency, firewallCheck security group, VPC peering
Too many connectionsPool size vs DB max connsTune pool size, check for leaks
Connection resetIdle conn killed by proxy/LBSet connection and idle timeouts

External API Connection

SymptomCheckFix
ConnectTimeoutExceptionTarget reachable?Verify DNS, firewall, service health
ReadTimeoutExceptionResponse too slowIncrease timeout or optimize upstream
SSLHandshakeExceptionCertificate issueCheck cert validity, trust store
429 Too Many RequestsRate limitedImplement backoff, request quota

4. General Debugging Principles

Do

  • Start with logs — check ERROR and WARN levels first
  • Reproduce the issue locally before investigating in production
  • Use traceId to follow a request across services
  • Check "what changed" — recent deployments, config changes, traffic spikes
  • Narrow down the scope: which endpoint, which user, which time window

Do Not

  • Make changes to production without understanding the root cause
  • Restart pods as the first response — investigate first
  • Ignore intermittent errors — they often indicate resource exhaustion
  • Debug with print statements — use structured logging
  • Chase symptoms without identifying the root cause

5. Anti-Patterns

  • Applying fixes without understanding root cause
  • No runbook for common failure scenarios
  • Missing alerting for critical business flows
  • No baseline metrics to compare against during incidents
  • Skipping post-mortem after production incidents

6. Related Skills

  • observability: System monitoring and alerting setup
  • logging: Log-based problem diagnosis
  • incident-response: Incident response processes

Additional References

Keep looking

Skills are one crate of 328,083. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.