skills.rest
cockroachdb
cockroachdbOFFICIAL
Explore all skills by this author →
WebsiteGitHub

reduce-unoptimized-query-oracle

Reduce CockroachDB roachtest failure logs to minimal SQL reproduction scripts.

32.4k|4.1k|Updated Feb 6, 2014
Search Tags:#performance#debugging#sql#cockroachdb#test reduction#roachtest
One-click install
npx skills add https://github.com/cockroachdb/cockroach --skill reduce-unoptimized-query-oracle
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: reduce-unoptimized-query-oracle
Source: https://github.com/cockroachdb/cockroach/tree/main/.claude/skills/reduce-unoptimized-query-oracle
Command: npx skills add https://github.com/cockroachdb/cockroach --skill reduce-unoptimized-query-oracle

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps pinpoint the exact SQL statements causing a specific type of test failure in CockroachDB, making bug reproduction and debugging much faster.

Core Features & Use Cases

  • Log Analysis: Parses detailed roachtest logs (.log files) to identify the root cause of unoptimized-query-oracle failures.
  • SQL Reduction: Utilizes a specialized tool (./bin/reduce) to distill large SQL logs into the smallest possible script that still triggers the failure.
  • Use Case: When a unoptimized-query-oracle test fails, use this Skill to get a concise SQL script that reliably reproduces the bug, allowing developers to quickly fix it.

Quick Start

Use the reduce-unoptimized-query-oracle skill to reduce the failure log found in the /path/to/artifacts directory.

Frequently Asked Questions about reduce-unoptimized-query-oracle

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

FAQPage Schema
How do I reduce CockroachDB roachtest failure logs to a minimal SQL reproduction case?▼

To reduce CockroachDB roachtest failure logs, analyze the unoptimized-query-oracle test parameters and failure details to distill large SQL logs into the smallest executable script that reliably triggers the bug.

What is the best way to debug unoptimized-query-oracle test failures in CockroachDB?▼

Debugging unoptimized-query-oracle test failures involves parsing roachtest logs to identify the root cause, then isolating the exact SQL statements and cluster configurations that trigger the query execution discrepancy.

How do I identify the exact SQL statements causing a CockroachDB roachtest failure?▼

Identify the exact SQL statements causing a CockroachDB roachtest failure by analyzing test failure logs to extract the specific query optimization or execution discrepancies and generating a concise reproduction script.

Can I extract a concise SQL script from unoptimized-query-oracle test logs?▼

Yes, you can extract a concise SQL script from unoptimized-query-oracle test logs by analyzing the failure details and utilizing a specialized reduction tool to distill the logs into an executable reproduction case.

Does reducing roachtest logs require specific cluster configurations or test parameters?▼

Reducing roachtest logs requires analyzing the specific test parameters and cluster configurations present in the failure logs to accurately identify the conditions that trigger the query optimization discrepancy.

Why are my CockroachDB unoptimized-query-oracle tests failing with query execution discrepancies?▼

Unoptimized-query-oracle tests fail due to query execution or optimization discrepancies, which require parsing the failure logs to pinpoint the exact SQL statements and cluster setup triggering the bug.

Related Skills

Explore More Software Engineering Skills→
ArabelaTsoArabelaTso
142

test-case-reducer

Reduce failing test cases to minimal reproducible forms using delta debugging.

Community
Advanced
santosomarsantosomar
1

test-case-reducer

Reduce large failing test inputs to minimal forms using delta debugging.

Community
Intermediate
cockroachdbcockroachdb
3

configuring-sso-and-scim

Configure SSO and SCIM integration for CockroachDB across Cloud Console, DB Console, and SQL/Cluster.

Official
Advanced
89jobrien89jobrien
4

debugging

Parse logs and analyze stack traces to diagnose errors across languages.

Community
Advanced