cockroachdb / cockroachdb/cockroach
Transaction with ID { } waited on section displays unrelated contention row
- 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`
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:

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`:
**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
Assessment
This issue has not been assessed yet.