Automates the reduction of complex CockroachDB SQL test failure logs into minimal, reproducible test cases.
This skill assists developers in debugging CockroachDB by automating the extraction and simplification of SQL statements from unoptimized-query-oracle test failures. It guides users through the entire lifecycle of bug isolation, from locating test artifacts and configuring specific build environments (including metamorphic settings and runtime assertions) to using specialized reduction tools. By iteratively narrowing down failing SQL sequences, it helps developers quickly identify the root cause of 'oracle' failures, assertion errors, and panics in distributed database environments.
Key Features
01Integration with the CockroachDB 'reduce' tool for automated query simplification
02Automated SQL log cleaning and reproduction verification
03Automated identification of git commits and test configurations from logs
04Specialized workflows for handling nondeterministic failures and multi-region setups
05Step-by-step guidance for building specific CockroachDB test binaries
0631,961 GitHub stars
Use Cases
01Reducing massive random SQL logs to minimal code for bug reports
02Isolating 'oracle' failures where optimized and unoptimized queries return different results
03Debugging distributed SQL panics and assertion failures in CockroachDB
