cockroachdb / cockroachdb/cockroach
basalt-26.3: sql/sqlstats/sslocal: TestTransactionLatencies failed
- 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
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