cockroachdb / cockroachdb/cockroach

Transaction with ID { } waited on section displays unrelated contention row

Open
#104,118 2 comments 0 reactions 0 assignees View on GitHub
C-bug
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

**Describe the problem**

`Transaction with ID { } waited on` section displays unrelated contention row.

In the example where this issue was encountered, there are 2 transactions that experienced `High Contention`:
`e15ae857-0f76-446d-97a8-8b8f6ac019a5` and `942cc9bb-99a4-4ef3-9533-7ffe0ce1bee8`

Screenshot 2023-05-30 at 3 50 59 PM

When I click on Transaction Execution ID `e15ae857-0f76-446d-97a8-8b8f6ac019a5`, the one correct blocking statement is displayed in the `Transaction with ID { } waited on` section:

![screencapture-localhost-8080-2023-05-30-15_51_55](https://github.com/cockroachdb/cockroach/assets/58752716/cf719c22-ce7a-42ee-875c-fc9fb1e6a638)

When I click on Transaction Execution ID `942cc9bb-99a4-4ef3-9533-7ffe0ce1bee86`, there are 2 blocking statements displayed in the `Transaction with ID { } waited on` section. The first blocking statement is the correct blocking statement. The second blocking statement displayed is not correct; it is the blocking statement from Transaction Execution ID `e15ae857-0f76-446d-97a8-8b8f6ac019a5`:

Screenshot 2023-05-30 at 3 56 07 PM

**To Reproduce**
I will add simpler repro steps later

**Expected behavior**
Only the related blocking statement is displayed.

**Environment:**
- CockroachDB version 23.1.2
- Server OS: Mac arm
- Client app `cockroach sql`

Jira issue: CRDB-28360

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.