basalt-26.3.2-rc-20260908: sql/sqlstats/sslocal: TestTransactionLatencies failed

sql/sqlstats/sslocal.TestTransactionLatencies [failed](https://mesolite.cluster.engflow.com/invocations/default/3e6250f1-ec23-4556-b888-ca3350756d3b?testReportRun=3&testReportShard=1&testReportAttempt=1#targets-Ly9wa2cvc3FsL3NxbHN0YXRzL3NzbG9jYWw6c3Nsb2NhbF90ZXN0) on basalt-26.3.2-rc-20260908 @ [807558e5e81666af257c811e925e4cae570abc28](https://github.com/cockroachdb/cockroach/commits/807558e5e81666af257c811e925e4cae570abc28):

```
=== RUN TestTransactionLatencies
test_log_scope.go:172: test logs captured to: outputs.zip/logTestTransactionLatencies3989966944
test_log_scope.go:82: use -show-logs to present logs inline
test_server_shim.go:168: automatically injected an external process virtual cluster under test; see comment at top of test_server_shim.go for details.
test_server_shim.go:639: DRPC is enabled (via testserver factory defaults)
sql_stats_test.go:1923: -- test log scope end --
test logs left over in: outputs.zip/logTestTransactionLatencies3989966944
--- FAIL: TestTransactionLatencies (29.83s)
=== 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/1209586181306220545/0): "sql txn" meta={id=e2a266e2 key=/Tenant/10/Table/104/1/1209586167697965057/0 iso=Serializable pri=0.03691153 epo=0 ts=1789206806.387379521,2 min=1789206803.482828864,0 seq=11} lock=true stat=PENDING rts=1789206806.387379521,2 gul=1789206803.982828864,0 obs={n1@1789206803.717312199,0}
HINT: See: https://www.cockroachlabs.com/docs/v26.3/transaction-retry-error-reference.html#retry_async_write_failure
--- FAIL: TestTransactionLatencies/simple_statements (8.51s)
```

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

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

Same failure on other branches

- #173941 basalt-26.3: sql/sqlstats/sslocal: TestTransactionLatencies failed [C-test-failure O-robot T-observability branch-basalt-26.3 release-blocker]

/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)

Start by reproducing sql/sqlstats/sslocal.TestTransactionLatencies, focusing on the simple_statements failure reported in sql_stats_test.go:1878. Read the surrounding test and the test_server_shim.go notes, then inspect the linked test logs. Done means identifying and addressing the transaction retry failure so the test passes reliably.

Written by the indexing model from the issue text.