cockroachdb / cockroachdb/cockroach

basalt-26.3: sql/sqlstats/sslocal: TestTransactionLatencies failed

Open
#173,941 6 comments 0 reactions 0 assignees View on GitHub
branch-basalt-26.3 C-test-failure O-robot release-blocker T-observability
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

sql/sqlstats/sslocal.TestTransactionLatencies [failed](https://mesolite.cluster.engflow.com/invocations/default/759a4d1d-20e2-453c-b574-58d043b8afcb?testReportRun=1&testReportShard=1&testReportAttempt=1#targets-Ly9wa2cvc3FsL3NxbHN0YXRzL3NzbG9jYWw6c3Nsb2NhbF90ZXN0) on basalt-26.3 @ [00b50017bbdd3b9a2c1b295df16c2c85c7ce8ab2](https://github.com/cockroachdb/cockroach/commits/00b50017bbdd3b9a2c1b295df16c2c85c7ce8ab2):

```
=== RUN TestTransactionLatencies
test_log_scope.go:172: test logs captured to: outputs.zip/logTestTransactionLatencies2056012269
test_log_scope.go:82: use -show-logs to present logs inline
test_server_shim.go:168: automatically injected a shared process virtual cluster under test; see comment at top of test_server_shim.go for details.
sql_stats_test.go:1923: -- test log scope end --
test logs left over in: outputs.zip/logTestTransactionLatencies2056012269
--- FAIL: TestTransactionLatencies (25.71s)
=== RUN TestTransactionLatencies/simple_statements
sql_stats_test.go:1878: error executing query="COMMIT" args=[]: pq: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_ASYNC_WRITE_FAILURE - missing intent on: /Tenant/10/Table/104/1/1204778633967599617/0): "sql txn" meta={id=3f187098 key=/Tenant/10/Table/104/1/1204778626246279169/0 iso=Serializable pri=0.00556661 epo=0 ts=1787739659.540266659,2 min=1787739658.387824748,0 seq=11} lock=true stat=PENDING rts=1787739659.540266659,2 gul=1787739658.887824748,0 obs={n1@1787739658.387824748,0}
HINT: See: https://www.cockroachlabs.com/docs/v26.3/transaction-retry-error-reference.html#retry_async_write_failure
--- FAIL: TestTransactionLatencies/simple_statements (4.43s)
```

Parameters:
- attempt=1
- race=true
- run=1
- shard=1
Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

/cc @cockroachlabs/obs-prs

[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*TestTransactionLatencies.*&sort=title+created&display=lastcommented+project) | [Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)

Jira issue: CRDB-67240

Contributor guide

Open the contributing guide

Research direction

Start with sql/sqlstats/sslocal.TestTransactionLatencies and the failing path at sql_stats_test.go:1878; rerun the test with the reported race and shard parameters, then inspect the captured logs at outputs.zip/logTestTransactionLatencies2056012269. Done means the test no longer fails with the transaction retry error and the regression is covered by the relevant test behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sql
Domain
databases, testing
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Needs clarification
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.