basalt-26.3.2-rc-20260908: pkg/sql/schemachanger/schemachanger_test: TestDropJobCancelable failed

pkg/sql/schemachanger/schemachanger_test.TestDropJobCancelable [failed](https://mesolite.cluster.engflow.com/invocations/default/f0916551-4348-4015-a964-7d1ed87aeec5?testReportRun=2&testReportShard=9&testReportAttempt=1#targets-Ly9wa2cvc3FsL3NjaGVtYWNoYW5nZXI6c2NoZW1hY2hhbmdlcl90ZXN0) on basalt-26.3.2-rc-20260908 @ [807558e5e81666af257c811e925e4cae570abc28](https://github.com/cockroachdb/cockroach/commits/807558e5e81666af257c811e925e4cae570abc28):

```
=== RUN TestDropJobCancelable
test_log_scope.go:172: test logs captured to: outputs.zip/logTestDropJobCancelable4071699232
test_log_scope.go:82: use -show-logs to present logs inline
schemachanger_test.go:408: -- test log scope end --
test logs left over in: outputs.zip/logTestDropJobCancelable4071699232
--- FAIL: TestDropJobCancelable (49.87s)
=== RUN TestDropJobCancelable/simple_drop_sequence
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.
schemachanger_test.go:368:
Error Trace: pkg/sql/schemachanger/schemachanger_test.go:368
Error: Received unexpected error:
pq: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_ASYNC_WRITE_FAILURE - missing intent on: /Tenant/10/Table/109/1/0/0): "sql txn" meta={id=854528a2 key=/Tenant/10/Table/109/1/0/0 iso=Serializable pri=0.00489606 epo=0 ts=1789124828.385567601,2 min=1789124827.472371441,0 seq=4} lock=true stat=PENDING rts=1789124828.385567601,2 gul=1789124827.972371441,0 obs={n1@1789124827.472371441,0}
Test: TestDropJobCancelable/simple_drop_sequence
--- FAIL: TestDropJobCancelable/simple_drop_sequence (33.01s)
```

Parameters:
- attempt=1
- race=true
- run=2
- shard=9
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:.*TestDropJobCancelable.*&sort=title+created&display=lastcommented+project) | [Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)

Start with pkg/sql/schemachanger/schemachanger_test.go, focusing on TestDropJobCancelable/simple_drop_sequence, and reproduce it with the reported race configuration. Inspect the captured outputs.zip test log and the RETRY_ASYNC_WRITE_FAILURE, then confirm the test completes without the unexpected transaction-retry error.

Written by the indexing model from the issue text.