basalt-26.3: pkg/sql/catalog/schematelemetry/schematelemetry_test: TestSchemaTelemetryJob failed

pkg/sql/catalog/schematelemetry/schematelemetry_test.TestSchemaTelemetryJob [failed](https://mesolite.cluster.engflow.com/invocations/default/376fcf97-274a-4e7c-ad0a-4aafab7d24f7?testReportRun=3&testReportShard=1&testReportAttempt=1#targets-Ly9wa2cvc3FsL2NhdGFsb2cvc2NoZW1hdGVsZW1ldHJ5OnNjaGVtYXRlbGVtZXRyeV90ZXN0) on basalt-26.3 @ [c6d01ae4be9708178b248a49819b505daf713377](https://github.com/cockroachdb/cockroach/commits/c6d01ae4be9708178b248a49819b505daf713377):

```
=== RUN TestSchemaTelemetryJob
test_log_scope.go:172: test logs captured to: outputs.zip/logTestSchemaTelemetryJob1054966195
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.
test_server_shim.go:639: DRPC is enabled (via testserver factory defaults)
schema_telemetry_test.go:119: error executing query="\nCREATE DATABASE t;\nCREATE TABLE t.test (k INT8);\nCREATE TABLE fktbl (id INT8 PRIMARY KEY);\nCREATE TABLE tbl (\n\tcustomer INT8 NOT NULL REFERENCES fktbl (id)\n);\nCREATE TABLE nojob (k INT8);\n\t" args=[]: pq: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_ASYNC_WRITE_FAILURE - missing intent on: /Tenant/10/NamespaceTable/30/1/100/101/"nojob"/4/1): "sql txn" meta={id=33487986 key=/Tenant/10/Table/3/1/109/2/1 iso=Serializable pri=0.05943580 epo=0 ts=1788948318.011231586,2 min=1788948318.005528860,0 seq=3} lock=true stat=PENDING rts=1788948318.011231586,2 gul=1788948318.505528860,0 obs={n1@1788948318.005528860,0}
HINT: See: https://www.cockroachlabs.com/docs/v26.3/transaction-retry-error-reference.html#retry_async_write_failure
panic.go:694: -- test log scope end --
test logs left over in: outputs.zip/logTestSchemaTelemetryJob1054966195
--- FAIL: TestSchemaTelemetryJob (47.00s)
```

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)

/cc @cockroachlabs/sql-foundations

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

Jira issue: CRDB-68092

Start in pkg/sql/catalog/schematelemetry/schema_telemetry_test.go around the failing CREATE statements at line 119, then reproduce TestSchemaTelemetryJob with the reported race configuration and inspect the linked test report. Done means the test no longer fails with the transaction retry error and the relevant test run passes.

Written by the indexing model from the issue text.