Sentry: txn_interceptor_seq_num_allocator.go:182: read sequence number 0 but sequence number is ignored [{0 0}] after savepoint rollback (1) assertion failure Wraps: (2) | (opaque error wrapper) |...

This issue was auto filed by Sentry. It represents a crash or reported error on a live cluster with telemetry enabled.

Sentry Link: [https://cockroach-labs.sentry.io/issues/7322636851/?referrer=webhooks_plugin](https://cockroach-labs.sentry.io/issues/7322636851/?referrer=webhooks_plugin)

Panic Message:

```
txn_interceptor_seq_num_allocator.go:182: read sequence number 0 but sequence number is ignored [{0 0}] after savepoint rollback
(1) assertion failure
Wraps: (2)
| (opaque error wrapper)
| type name: github.com/cockroachdb/errors/withstack/*withstack.withStack
| reportable 0:
|
| github.com/cockroachdb/cockroach/pkg/kv/kvclient/kvcoord.(*txnSeqNumAllocator).checkReadSeqNotIgnoredLocked
| pkg/kv/kvclient/kvcoord/txn_interceptor_seq_num_allocator.go:182
| github.com/cockroachdb/cockroach/pkg/kv/kvclient/kvcoord.(*txnSeqNumAllocator).SendLocked
| pkg/kv/kvclient/kvcoord/txn_interceptor_seq_num_allocator.go:81
| github.com/cockroachdb/cockroach/pkg/kv/kvclient/kvcoord.(*txnHeartbeater).SendLocked
| pkg/kv/kvclient/kvcoord/txn_interceptor_heartbeater.go:265
| github.com/cockroachdb/cockroach/pkg/kv/kvclient/kvcoord.(*TxnCoordSender).Send
| pkg/kv/kvclient/kvcoord/txn_coord_sender.go:534
| github.com/cockroachdb/cockroach/pkg/kv.(*DB).sendUsingSender
| pkg/kv/db.go:1133
| github.com/cockroachdb/cockroach/pkg/kv.(*Txn).Send
| pkg/kv/txn.go:1295
| github.com/cockroachdb/cockroach/pkg/kv.sendAndFill
| pkg/kv/db.go:965
| github.com/cockroachdb/cockroach/pkg/kv.(*Txn).Run
| pkg/kv/txn.go:805
| github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv.catalogQuery.query
| pkg/sql/catalog/internal/catkv/catalog_query.go:54
| github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv.catalogReader.GetByNames
| pkg/sql/catalog/internal/catkv/catalog_reader.go:404
| github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv.(*cachedCatalogReader).GetByNames
| pkg/sql/catalog/internal/catkv/catalog_reader_cached.go:403
| github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.(*Collection).getNonVirtualDescriptorID.func7
| pkg/sql/catalog/descs/descriptor.go:594
| github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.(*Collection).getNonVirtualDescriptorID
| pkg/sql/catalog/descs/descriptor.go:615
| github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.getDescriptorByName
| pkg/sql/catalog/descs/descriptor.go:393
| github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.ByNameGetter.Table
| pkg/sql/catalog/descs/getters.go:296
| github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.PrefixAndTable
| pkg/sql/catalog/descs/helpers.go:133
| github.com/cockroachdb/cockroach/pkg/sql.(*schemaResolver).LookupObject
| pkg/sql/schema_resolver.go:168
| github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver.ResolveExisting
| pkg/sql/catalog/resolver/resolver.go:375
| github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver.ResolveExistingObject
| pkg/sql/catalog/resolver/resolver.go:179
| github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver.ResolveExistingTableObject
| pkg/sql/catalog/resolver/resolver.go:103
| github.com/cockroachdb/cockroach/pkg/sql.(*optCatalog).ResolveDataSource
| pkg/sql/opt_catalog.go:256
| github.com/cockroachdb/cockroach/pkg/sql/opt.(*Metadata).CheckDependencies
| pkg/sql/opt/metadata.go:387
| github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*Memo).IsStale
| pkg/sql/opt/memo/memo.go:476
| github.com/cockroachdb/cockroach/pkg/sql.(*planner).prepareUsingOptimizer
| pkg/sql/plan_opt.go:142
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).populatePrepared
| pkg/sql/conn_executor_prepare.go:339
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).prepare.func2
| pkg/sql/conn_executor_prepare.go:279
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).prepare
| pkg/sql/conn_executor_prepare.go:284
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).addPreparedStmt
| pkg/sql/conn_executor_prepare.go:117
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execPrepare
| pkg/sql/conn_executor_prepare.go:78
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd
| pkg/sql/conn_executor.go:2472
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run
| pkg/sql/conn_executor.go:2263
| github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn
| pkg/sql/conn_executor.go:963
Wraps: (3) read sequence number 0 but sequence number is ignored [{0 0}] after savepoint rollback
Error types: (1) *assert.withAssertionFailure (2) *errbase.opaqueWrapper (3) *errutil.leafError
-- report composition:
*errutil.leafError: read sequence number 0 but sequence number is ignored [{0 0}] after savepoint rollback
txn_interceptor_seq_num_allocator.go:182: *withstack.withStack (top exception)
*assert.withAssertionFailure
```

Stacktrace (expand for inline code snippets):

[pkg/sql/conn_executor.go#L962-L964](pkg/sql/conn_executor.go#L962-L964)
[pkg/sql/conn_executor.go#L2262-L2264](pkg/sql/conn_executor.go#L2262-L2264)
[pkg/sql/conn_executor.go#L2471-L2473](pkg/sql/conn_executor.go#L2471-L2473)
[pkg/sql/conn_executor_prepare.go#L77-L79](pkg/sql/conn_executor_prepare.go#L77-L79)
[pkg/sql/conn_executor_prepare.go#L116-L118](pkg/sql/conn_executor_prepare.go#L116-L118)
[pkg/sql/conn_executor_prepare.go#L283-L285](pkg/sql/conn_executor_prepare.go#L283-L285)
[pkg/sql/conn_executor_prepare.go#L278-L280](pkg/sql/conn_executor_prepare.go#L278-L280)
[pkg/sql/conn_executor_prepare.go#L338-L340](pkg/sql/conn_executor_prepare.go#L338-L340)
[pkg/sql/plan_opt.go#L141-L143](pkg/sql/plan_opt.go#L141-L143)
[pkg/sql/opt/memo/memo.go#L475-L477](pkg/sql/opt/memo/memo.go#L475-L477)
[pkg/sql/opt/metadata.go#L386-L388](pkg/sql/opt/metadata.go#L386-L388)
[pkg/sql/opt_catalog.go#L255-L257](pkg/sql/opt_catalog.go#L255-L257)
[pkg/sql/catalog/resolver/resolver.go#L102-L104](pkg/sql/catalog/resolver/resolver.go#L102-L104)
[pkg/sql/catalog/resolver/resolver.go#L178-L180](pkg/sql/catalog/resolver/resolver.go#L178-L180)
[pkg/sql/catalog/resolver/resolver.go#L374-L376](pkg/sql/catalog/resolver/resolver.go#L374-L376)
[pkg/sql/schema_resolver.go#L167-L169](pkg/sql/schema_resolver.go#L167-L169)
[pkg/sql/catalog/descs/helpers.go#L132-L134](pkg/sql/catalog/descs/helpers.go#L132-L134)
[pkg/sql/catalog/descs/getters.go#L295-L297](pkg/sql/catalog/descs/getters.go#L295-L297)
[pkg/sql/catalog/descs/descriptor.go#L392-L394](pkg/sql/catalog/descs/descriptor.go#L392-L394)
[pkg/sql/catalog/descs/descriptor.go#L614-L616](pkg/sql/catalog/descs/descriptor.go#L614-L616)
[pkg/sql/catalog/descs/descriptor.go#L593-L595](pkg/sql/catalog/descs/descriptor.go#L593-L595)
[pkg/sql/catalog/internal/catkv/catalog_reader_cached.go#L402-L404](pkg/sql/catalog/internal/catkv/catalog_reader_cached.go#L402-L404)
[pkg/sql/catalog/internal/catkv/catalog_reader.go#L403-L405](pkg/sql/catalog/internal/catkv/catalog_reader.go#L403-L405)
[pkg/sql/catalog/internal/catkv/catalog_query.go#L53-L55](pkg/sql/catalog/internal/catkv/catalog_query.go#L53-L55)
[pkg/kv/txn.go#L804-L806](pkg/kv/txn.go#L804-L806)
[pkg/kv/db.go#L964-L966](pkg/kv/db.go#L964-L966)
[pkg/kv/txn.go#L1294-L1296](pkg/kv/txn.go#L1294-L1296)
[pkg/kv/db.go#L1132-L1134](pkg/kv/db.go#L1132-L1134)
[pkg/kv/kvclient/kvcoord/txn_coord_sender.go#L533-L535](pkg/kv/kvclient/kvcoord/txn_coord_sender.go#L533-L535)
[pkg/kv/kvclient/kvcoord/txn_interceptor_heartbeater.go#L264-L266](pkg/kv/kvclient/kvcoord/txn_interceptor_heartbeater.go#L264-L266)
[pkg/kv/kvclient/kvcoord/txn_interceptor_seq_num_allocator.go#L80-L82](pkg/kv/kvclient/kvcoord/txn_interceptor_seq_num_allocator.go#L80-L82)
[pkg/kv/kvclient/kvcoord/txn_interceptor_seq_num_allocator.go#L181-L183](pkg/kv/kvclient/kvcoord/txn_interceptor_seq_num_allocator.go#L181-L183)

```
pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn at line 963
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 2263
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 2472
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).execPrepare at line 78
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).addPreparedStmt at line 117
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).prepare at line 284
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).prepare.func2 at line 279
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).populatePrepared at line 339
pkg/sql/plan_opt.go in pkg/sql.(*planner).prepareUsingOptimizer at line 142
pkg/sql/opt/memo/memo.go in pkg/sql/opt/memo.(*Memo).IsStale at line 476
pkg/sql/opt/metadata.go in pkg/sql/opt.(*Metadata).CheckDependencies at line 387
pkg/sql/opt_catalog.go in pkg/sql.(*optCatalog).ResolveDataSource at line 256
pkg/sql/catalog/resolver/resolver.go in pkg/sql/catalog/resolver.ResolveExistingTableObject at line 103
pkg/sql/catalog/resolver/resolver.go in pkg/sql/catalog/resolver.ResolveExistingObject at line 179
pkg/sql/catalog/resolver/resolver.go in pkg/sql/catalog/resolver.ResolveExisting at line 375
pkg/sql/schema_resolver.go in pkg/sql.(*schemaResolver).LookupObject at line 168
pkg/sql/catalog/descs/helpers.go in pkg/sql/catalog/descs.PrefixAndTable at line 133
pkg/sql/catalog/descs/getters.go in pkg/sql/catalog/descs.ByNameGetter.Table at line 296
pkg/sql/catalog/descs/descriptor.go in pkg/sql/catalog/descs.getDescriptorByName at line 393
pkg/sql/catalog/descs/descriptor.go in pkg/sql/catalog/descs.(*Collection).getNonVirtualDescriptorID at line 615
pkg/sql/catalog/descs/descriptor.go in pkg/sql/catalog/descs.(*Collection).getNonVirtualDescriptorID.func7 at line 594
pkg/sql/catalog/internal/catkv/catalog_reader_cached.go in pkg/sql/catalog/internal/catkv.(*cachedCatalogReader).GetByNames at line 403
pkg/sql/catalog/internal/catkv/catalog_reader.go in pkg/sql/catalog/internal/catkv.catalogReader.GetByNames at line 404
pkg/sql/catalog/internal/catkv/catalog_query.go in pkg/sql/catalog/internal/catkv.catalogQuery.query at line 54
pkg/kv/txn.go in pkg/kv.(*Txn).Run at line 805
pkg/kv/db.go in pkg/kv.sendAndFill at line 965
pkg/kv/txn.go in pkg/kv.(*Txn).Send at line 1295
pkg/kv/db.go in pkg/kv.(*DB).sendUsingSender at line 1133
pkg/kv/kvclient/kvcoord/txn_coord_sender.go in pkg/kv/kvclient/kvcoord.(*TxnCoordSender).Send at line 534
pkg/kv/kvclient/kvcoord/txn_interceptor_heartbeater.go in pkg/kv/kvclient/kvcoord.(*txnHeartbeater).SendLocked at line 265
pkg/kv/kvclient/kvcoord/txn_interceptor_seq_num_allocator.go in pkg/kv/kvclient/kvcoord.(*txnSeqNumAllocator).SendLocked at line 81
pkg/kv/kvclient/kvcoord/txn_interceptor_seq_num_allocator.go in pkg/kv/kvclient/kvcoord.(*txnSeqNumAllocator).checkReadSeqNotIgnoredLocked at line 182
```

### Tags

| Tag | Value |
| --- | --- |
| Command | start-single-node |
| Environment | v24.3.8 |
| Go Version | go1.22.8 X:nocoverageredesign |
| Platform | linux arm64 |
| Distribution | CCL |
| Cockroach Release | v24.3.8 |
| Cockroach SHA | e7075d1804ff5c11139ff5456e178f9561536fd3 |
| # of CPUs | 6 |
| # of Goroutines | 857 |

Jira issue: CRDB-61291