cockroachdb / cockroachdb/cockroach

sql/kv: additional testing for XA distributed transactions

Open
#137,636 0 comments 0 reactions 0 assignees View on GitHub
A-kv-transactions A-sql-executor A-sql-pgcompat A-testing C-enhancement
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

Follow-up to https://github.com/cockroachdb/cockroach/issues/22329.

We should expand testing for XA transactions. See https://github.com/cockroachdb/cockroach/pull/129449 for inspiration, where we added support for prepared transactions to:
- [ ] kvnemesis: https://github.com/cockroachdb/cockroach/pull/129449/commits/a0184cd3315caa53280079c2e86282432a144005
- [ ] sqlsmith: https://github.com/cockroachdb/cockroach/pull/129449/commits/a0d04b6a17f12d2632287eee013ae48408092e06

Jira issue: CRDB-45680

Contributor guide

Open the contributing guide

Research direction

Start by reading the linked prepared-transactions work in kvnemesis and sqlsmith, then trace how those tools currently exercise transaction behavior. Expand the XA transaction coverage in both entry points, using the referenced pull request for context. Done means the added tests run successfully and cover the intended XA transaction cases.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sql
Domain
databases, distributed-systems, testing
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.