cockroachdb / cockroachdb/cockroach

Sentry: index_join.go:359: executing declarative schema change PostCommitPhase stage 1 of 3 with 1 ValidationType op (rollback=false) for ALTER TABLE: validate check constraint: expected to fetch 1 ro...

Closed
#175,051 3 comments 0 reactions 0 assignees View on GitHub
branch-release-26.2 C-bug O-sentry T-sql-foundations X-blathers-triaged
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

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/7726664843/?referrer=webhooks_plugin](https://cockroach-labs.sentry.io/issues/7726664843/?referrer=webhooks_plugin)

Panic Message:

```
index_join.go:359: executing declarative schema change PostCommitPhase stage 1 of 3 with 1 ValidationType op (rollback=false) for ALTER TABLE: validate check constraint: expected to fetch 1 rows, found 0
(1) plan gist: Ais=
Wraps: (2) while executing: ALTER TABLE _ ADD CONSTRAINT _ CHECK (_ BETWEEN _ AND _)
Wraps: (3) forced error mark
| ×
| github.com/cockroachdb/errors/withstack/*withstack.withStack::
Wraps: (4)
| (opaque error wrapper)
| type name: github.com/cockroachdb/errors/withstack/*withstack.withStack
| reportable 0:
|
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scerrors.EventLogger.HandlePanicAndLogError
| pkg/sql/schemachanger/scerrors/errors.go:82
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scrun.executeStage
| pkg/sql/schemachanger/scrun/scrun.go:212
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scrun.RunSchemaChangesInJob.func1
| pkg/sql/schemachanger/scrun/scrun.go:140
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scdeps.(*jobExecutionDeps).WithTxnInJob.func2
| pkg/sql/schemachanger/scdeps/run_deps.go:206
| github.com/cockroachdb/cockroach/pkg/sql.(*InternalDB).DescsTxn.func1
| pkg/sql/internal.go:1971
| github.com/cockroachdb/cockroach/pkg/sql.(*InternalDB).txn.func4
| pkg/sql/internal.go:2074
| github.com/cockroachdb/cockroach/pkg/kv.(*Txn).exec
| pkg/kv/txn.go:1172
| github.com/cockroachdb/cockroach/pkg/kv.runTxn
| pkg/kv/db.go:1165
| github.com/cockroachdb/cockroach/pkg/kv.(*DB).TxnWithAdmissionControl
| pkg/kv/db.go:1125
| github.com/cockroachdb/cockroach/pkg/kv.(*DB).Txn
| pkg/kv/db.go:1097
| github.com/cockroachdb/cockroach/pkg/sql.(*InternalDB).txn
| pkg/sql/internal.go:2061
| github.com/cockroachdb/cockroach/pkg/sql.(*InternalDB).DescsTxn
| pkg/sql/internal.go:1969
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scdeps.(*jobExecutionDeps).WithTxnInJob
| pkg/sql/schemachanger/scdeps/run_deps.go:135
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scrun.RunSchemaChangesInJob
| pkg/sql/schemachanger/scrun/scrun.go:136
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scjob.(*newSchemaChangeResumer).run
| pkg/sql/schemachanger/scjob/job.go:162
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scjob.(*newSchemaChangeResumer).Resume
| pkg/sql/schemachanger/scjob/job.go:60
| github.com/cockroachdb/cockroach/pkg/jobs.(*Registry).stepThroughStateMachine.func2
| pkg/jobs/registry.go:1661
| github.com/cockroachdb/cockroach/pkg/jobs.(*Registry).stepThroughStateMachine
| pkg/jobs/registry.go:1662
| github.com/cockroachdb/cockroach/pkg/jobs.(*Registry).runJob
| pkg/jobs/adopt.go:503
| github.com/cockroachdb/cockroach/pkg/jobs.(*Registry).resumeJob.func1
| pkg/jobs/adopt.go:350
| github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx.func1
| pkg/util/stop/stopper.go:447
| runtime.goexit
| src/runtime/asm_amd64.s:1693
Wraps: (5) executing declarative schema change PostCommitPhase stage 1 of 3 with 1 ValidationType op (rollback=false) for ALTER TABLE
Wraps: (6)
Wraps: (7)
| (opaque error wrapper)
| type name: github.com/cockroachdb/errors/withstack/*withstack.withStack
| reportable 0:
|
| github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).execInternal.func1.1
| pkg/sql/internal.go:1272
| github.com/cockroachdb/cockroach/pkg/sql.(*rowsIterator).Close
| pkg/sql/internal.go:604
| github.com/cockroachdb/cockroach/pkg/sql.(*rowsIterator).Next
| pkg/sql/internal.go:580
| github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).queryInternalBuffered
| pkg/sql/internal.go:689
| github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).queryRowExWithCols
| pkg/sql/internal.go:771
| github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).QueryRowExWithCols
| pkg/sql/internal.go:758
| github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).QueryRowEx
| pkg/sql/internal.go:731
| github.com/cockroachdb/cockroach/pkg/sql.validateCheckExpr
| pkg/sql/check.go:84
| github.com/cockroachdb/cockroach/pkg/sql.ValidateConstraint.func1.2
| pkg/sql/backfill.go:1636
| github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).WithSyntheticDescriptors
| pkg/sql/internal.go:164
| github.com/cockroachdb/cockroach/pkg/sql.ValidateConstraint.func1
| pkg/sql/backfill.go:1630
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scdeps.validator.makeHistoricalInternalExecTxnRunner.func1.1
| pkg/sql/schemachanger/scdeps/validator.go:142
| github.com/cockroachdb/cockroach/pkg/sql.(*InternalDB).DescsTxn.func1
| pkg/sql/internal.go:1971
| github.com/cockroachdb/cockroach/pkg/sql.(*InternalDB).txn.func4
| pkg/sql/internal.go:2074
| github.com/cockroachdb/cockroach/pkg/kv.(*Txn).exec
| pkg/kv/txn.go:1172
| github.com/cockroachdb/cockroach/pkg/kv.runTxn
| pkg/kv/db.go:1165
| github.com/cockroachdb/cockroach/pkg/kv.(*DB).TxnWithAdmissionControl
| pkg/kv/db.go:1125
| github.com/cockroachdb/cockroach/pkg/sql.(*InternalDB).txn.func2
| pkg/sql/internal.go:2047
| github.com/cockroachdb/cockroach/pkg/sql.(*InternalDB).txn
| pkg/sql/internal.go:2061
| github.com/cockroachdb/cockroach/pkg/sql.(*InternalDB).DescsTxn
| pkg/sql/internal.go:1969
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scdeps.validator.makeHistoricalInternalExecTxnRunner.func1
| pkg/sql/schemachanger/scdeps/validator.go:136
| github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.(*historicalInternalExecTxnRunner).Exec
| pkg/sql/catalog/descs/collection.go:1763
| github.com/cockroachdb/cockroach/pkg/sql.ValidateConstraint
| pkg/sql/backfill.go:1617
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scdeps.validator.ValidateConstraint
| pkg/sql/schemachanger/scdeps/validator.go:126
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scexec.executeValidateConstraint
| pkg/sql/schemachanger/scexec/exec_validation.go:110
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scexec.validationAccumulator.validate
| pkg/sql/schemachanger/scexec/exec_validation.go:205
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scexec.executeValidationOps
| pkg/sql/schemachanger/scexec/exec_validation.go:149
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scexec.ExecuteStage
| pkg/sql/schemachanger/scexec/executor.go:27
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scrun.executeStage
| pkg/sql/schemachanger/scrun/scrun.go:199
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scrun.RunSchemaChangesInJob.func1
| pkg/sql/schemachanger/scrun/scrun.go:140
| github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scdeps.(*jobExecutionDeps).WithTxnInJob.func2
| pkg/sql/schemachanger/scdeps/run_deps.go:206
| github.com/cockroachdb/cockroach/pkg/sql.(*InternalDB).DescsTxn.func1
| pkg/sql/internal.go:1971
Wraps: (8) validate check constraint
Wraps: (9) plan gist: AgGgCBwACQIAAhOgCAIGGA==
Wraps: (10) while executing: SELECT _, _, _, _, _, _, _, _, _, _, _, _ FROM [528 AS _] WHERE NOT (_ BETWEEN _:::INT8 AND _:::INT8) LIMIT _
Wraps: (11) assertion failure
Wraps: (12)
| (opaque error wrapper)
| type name: github.com/cockroachdb/errors/withstack/*withstack.withStack
| reportable 0:
|
| github.com/cockroachdb/cockroach/pkg/sql/colfetcher.(*ColIndexJoin).assertScanRowCounts
| pkg/sql/colfetcher/index_join.go:359
| github.com/cockroachdb/cockroach/pkg/sql/colfetcher.(*ColIndexJoin).Next
| pkg/sql/colfetcher/index_join.go:267
| github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecutils.(*CancelChecker).Next
| pkg/sql/colexec/colexecutils/cancel_checker.go:62
| github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).next
| pkg/sql/colflow/stats.go:122
| github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError
| pkg/sql/colexecerror/error.go:162
| github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Next
| pkg/sql/colflow/stats.go:130
| github.com/cockroachdb/cockroach/pkg/sql...
```

Stacktrace (expand for inline code snippets):

[src/runtime/asm_amd64.s#L1692-L1694](src/runtime/asm_amd64.s#L1692-L1694)
[pkg/util/stop/stopper.go#L446-L448](pkg/util/stop/stopper.go#L446-L448)
[pkg/jobs/adopt.go#L349-L351](pkg/jobs/adopt.go#L349-L351)
[pkg/jobs/adopt.go#L502-L504](pkg/jobs/adopt.go#L502-L504)
[pkg/jobs/registry.go#L1661-L1663](pkg/jobs/registry.go#L1661-L1663)
[pkg/jobs/registry.go#L1660-L1662](pkg/jobs/registry.go#L1660-L1662)
[pkg/sql/schemachanger/scjob/job.go#L59-L61](pkg/sql/schemachanger/scjob/job.go#L59-L61)
[pkg/sql/schemachanger/scjob/job.go#L161-L163](pkg/sql/schemachanger/scjob/job.go#L161-L163)
[pkg/sql/schemachanger/scrun/scrun.go#L135-L137](pkg/sql/schemachanger/scrun/scrun.go#L135-L137)
[pkg/sql/schemachanger/scdeps/run_deps.go#L134-L136](pkg/sql/schemachanger/scdeps/run_deps.go#L134-L136)
[pkg/sql/internal.go#L1968-L1970](pkg/sql/internal.go#L1968-L1970)
[pkg/sql/internal.go#L2060-L2062](pkg/sql/internal.go#L2060-L2062)
[pkg/kv/db.go#L1096-L1098](pkg/kv/db.go#L1096-L1098)
[pkg/kv/db.go#L1124-L1126](pkg/kv/db.go#L1124-L1126)
[pkg/kv/db.go#L1164-L1166](pkg/kv/db.go#L1164-L1166)
[pkg/kv/txn.go#L1171-L1173](pkg/kv/txn.go#L1171-L1173)
[pkg/sql/internal.go#L2073-L2075](pkg/sql/internal.go#L2073-L2075)
[pkg/sql/internal.go#L1970-L1972](pkg/sql/internal.go#L1970-L1972)
[pkg/sql/schemachanger/scdeps/run_deps.go#L205-L207](pkg/sql/schemachanger/scdeps/run_deps.go#L205-L207)
[pkg/sql/schemachanger/scrun/scrun.go#L139-L141](pkg/sql/schemachanger/scrun/scrun.go#L139-L141)
[pkg/sql/schemachanger/scrun/scrun.go#L211-L213](pkg/sql/schemachanger/scrun/scrun.go#L211-L213)
[pkg/sql/schemachanger/scerrors/errors.go#L81-L83](pkg/sql/schemachanger/scerrors/errors.go#L81-L83)
[pkg/sql/internal.go#L1970-L1972](pkg/sql/internal.go#L1970-L1972)
[pkg/sql/schemachanger/scdeps/run_deps.go#L205-L207](pkg/sql/schemachanger/scdeps/run_deps.go#L205-L207)
[pkg/sql/schemachanger/scrun/scrun.go#L139-L141](pkg/sql/schemachanger/scrun/scrun.go#L139-L141)
[pkg/sql/schemachanger/scrun/scrun.go#L198-L200](pkg/sql/schemachanger/scrun/scrun.go#L198-L200)
[pkg/sql/schemachanger/scexec/executor.go#L26-L28](pkg/sql/schemachanger/scexec/executor.go#L26-L28)
[pkg/sql/schemachanger/scexec/exec_validation.go#L148-L150](pkg/sql/schemachanger/scexec/exec_validation.go#L148-L150)
[pkg/sql/schemachanger/scexec/exec_validation.go#L204-L206](pkg/sql/schemachanger/scexec/exec_validation.go#L204-L206)
[pkg/sql/schemachanger/scexec/exec_validation.go#L109-L111](pkg/sql/schemachanger/scexec/exec_validation.go#L109-L111)
[pkg/sql/schemachanger/scdeps/validator.go#L125-L127](pkg/sql/schemachanger/scdeps/validator.go#L125-L127)
[pkg/sql/backfill.go#L1616-L1618](pkg/sql/backfill.go#L1616-L1618)
[pkg/sql/catalog/descs/collection.go#L1762-L1764](pkg/sql/catalog/descs/collection.go#L1762-L1764)
[pkg/sql/schemachanger/scdeps/validator.go#L135-L137](pkg/sql/schemachanger/scdeps/validator.go#L135-L137)
[pkg/sql/internal.go#L1968-L1970](pkg/sql/internal.go#L1968-L1970)
[pkg/sql/internal.go#L2060-L2062](pkg/sql/internal.go#L2060-L2062)
[pkg/sql/internal.go#L2046-L2048](pkg/sql/internal.go#L2046-L2048)
[pkg/kv/db.go#L1124-L1126](pkg/kv/db.go#L1124-L1126)
[pkg/kv/db.go#L1164-L1166](pkg/kv/db.go#L1164-L1166)
[pkg/kv/txn.go#L1171-L1173](pkg/kv/txn.go#L1171-L1173)
[pkg/sql/internal.go#L2073-L2075](pkg/sql/internal.go#L2073-L2075)
[pkg/sql/internal.go#L1970-L1972](pkg/sql/internal.go#L1970-L1972)
[pkg/sql/schemachanger/scdeps/validator.go#L141-L143](pkg/sql/schemachanger/scdeps/validator.go#L141-L143)
[pkg/sql/backfill.go#L1629-L1631](pkg/sql/backfill.go#L1629-L1631)
[pkg/sql/internal.go#L163-L165](pkg/sql/internal.go#L163-L165)
[pkg/sql/backfill.go#L1635-L1637](pkg/sql/backfill.go#L1635-L1637)
[pkg/sql/check.go#L83-L85](pkg/sql/check.go#L83-L85)
[pkg/sql/internal.go#L730-L732](pkg/sql/internal.go#L730-L732)
[pkg/sql/internal.go#L757-L759](pkg/sql/internal.go#L757-L759)
[pkg/sql/internal.go#L770-L772](pkg/sql/internal.go#L770-L772)
[pkg/sql/internal.go#L688-L690](pkg/sql/internal.go#L688-L690)
[pkg/sql/internal.go#L579-L581](pkg/sql/internal.go#L579-L581)
[pkg/sql/internal.go#L603-L605](pkg/sql/internal.go#L603-L605)
[pkg/sql/internal.go#L1271-L1273](pkg/sql/internal.go#L1271-L1273)
[pkg/sql/internal.go#L253-L255](pkg/sql/internal.go#L253-L255)
[pkg/sql/conn_executor.go#L2393-L2395](pkg/sql/conn_executor.go#L2393-L2395)
[pkg/sql/conn_executor.go#L2485-L2487](pkg/sql/conn_executor.go#L2485-L2487)
[pkg/sql/conn_executor.go#L2480-L2482](pkg/sql/conn_executor.go#L2480-L2482)
[pkg/sql/conn_executor_exec.go#L181-L183](pkg/sql/conn_executor_exec.go#L181-L183)
[pkg/sql/conn_executor_exec.go#L4733-L4735](pkg/sql/conn_executor_exec.go#L4733-L4735)
[pkg/sql/conn_executor_exec.go#L182-L184](pkg/sql/conn_executor_exec.go#L182-L184)
[pkg/sql/conn_executor_exec.go#L1121-L1123](pkg/sql/conn_executor_exec.go#L1121-L1123)
[pkg/sql/conn_executor_exec.go#L3145-L3147](pkg/sql/conn_executor_exec.go#L3145-L3147)
[pkg/sql/conn_executor_exec.go#L3661-L3663](pkg/sql/conn_executor_exec.go#L3661-L3663)
[pkg/sql/distsql_running.go#L2098-L2100](pkg/sql/distsql_running.go#L2098-L2100)
[pkg/sql/distsql_running.go#L2095-L2097](pkg/sql/distsql_running.go#L2095-L2097)
[pkg/sql/distsql_running.go#L2396-L2398](pkg/sql/distsql_running.go#L2396-L2398)
[pkg/sql/distsql_running.go#L1086-L1088](pkg/sql/distsql_running.go#L1086-L1088)
[pkg/sql/colflow/vectorized_flow.go#L301-L303](pkg/sql/colflow/vectorized_flow.go#L301-L303)
[pkg/sql/flowinfra/flow.go#L583-L585](pkg/sql/flowinfra/flow.go#L583-L585)
[pkg/sql/execinfra/processorsbase.go#L770-L772](pkg/sql/execinfra/processorsbase.go#L770-L772)
[pkg/sql/execinfra/base.go#L192-L194](pkg/sql/execinfra/base.go#L192-L194)
[pkg/sql/colflow/flow_coordinator.go#L142-L144](pkg/sql/colflow/flow_coordinator.go#L142-L144)
[pkg/sql/colexecerror/error.go#L161-L163](pkg/sql/colexecerror/error.go#L161-L163)
[pkg/sql/colflow/flow_coordinator.go#L137-L139](pkg/sql/colflow/flow_coordinator.go#L137-L139)
[pkg/sql/colflow/flow_coordinator.go#L120-L122](pkg/sql/colflow/flow_coordinator.go#L120-L122)
[pkg/sql/colexec/materializer.go#L281-L283](pkg/sql/colexec/materializer.go#L281-L283)
[pkg/sql/colexecerror/error.go#L161-L163](pkg/sql/colexecerror/error.go#L161-L163)
[pkg/sql/colexec/materializer.go#L275-L277](pkg/sql/colexec/materializer.go#L275-L277)
[pkg/sql/colexec/materializer.go#L247-L249](pkg/sql/colexec/materializer.go#L247-L249)
[pkg/sql/colflow/stats.go#L129-L131](pkg/sql/colflow/stats.go#L129-L131)
[pkg/sql/colexecerror/error.go#L161-L163](pkg/sql/colexecerror/error.go#L161-L163)
[pkg/sql/colflow/stats.go#L121-L123](pkg/sql/colflow/stats.go#L121-L123)
[pkg/sql/colexec/colexecutils/cancel_checker.go#L61-L63](pkg/sql/colexec/colexecutils/cancel_checker.go#L61-L63)
[pkg/sql/colfetcher/index_join.go#L266-L268](pkg/sql/colfetcher/index_join.go#L266-L268)
[pkg/sql/colfetcher/index_join.go#L358-L360](pkg/sql/colfetcher/index_join.go#L358-L360)

```
src/runtime/asm_amd64.s in runtime.goexit at line 1693
pkg/util/stop/stopper.go in pkg/util/stop.(*Stopper).RunAsyncTaskEx.func1 at line 447
pkg/jobs/adopt.go in pkg/jobs.(*Registry).resumeJob.func1 at line 350
pkg/jobs/adopt.go in pkg/jobs.(*Registry).runJob at line 503
pkg/jobs/registry.go in pkg/jobs.(*Registry).stepThroughStateMachine at line 1662
pkg/jobs/registry.go in pkg/jobs.(*Registry).stepThroughStateMachine.func2 at line 1661
pkg/sql/schemachanger/scjob/job.go in pkg/sql/schemachanger/scjob.(*newSchemaChangeResumer).Resume at line 60
pkg/sql/schemachanger/scjob/job.go in pkg/sql/schemachanger/scjob.(*newSchemaChangeResumer).run at line 162
pkg/sql/schemachanger/scrun/scrun.go in pkg/sql/schemachanger/scrun.RunSchemaChangesInJob at line 136
pkg/sql/schemachanger/scdeps/run_deps.go in pkg/sql/schemachanger/scdeps.(*jobExecutionDeps).WithTxnInJob at line 135
pkg/sql/internal.go in pkg/sql.(*InternalDB).DescsTxn at line 1969
pkg/sql/internal.go in pkg/sql.(*InternalDB).txn at line 2061
pkg/kv/db.go in pkg/kv.(*DB).Txn at line 1097
pkg/kv/db.go in pkg/kv.(*DB).TxnWithAdmissionControl at line 1125
pkg/kv/db.go in pkg/kv.runTxn at line 1165
pkg/kv/txn.go in pkg/kv.(*Txn).exec at line 1172
pkg/sql/internal.go in pkg/sql.(*InternalDB).txn.func4 at line 2074
pkg/sql/internal.go in pkg/sql.(*InternalDB).DescsTxn.func1 at line 1971
pkg/sql/schemachanger/scdeps/run_deps.go in pkg/sql/schemachanger/scdeps.(*jobExecutionDeps).WithTxnInJob.func2 at line 206
pkg/sql/schemachanger/scrun/scrun.go in pkg/sql/schemachanger/scrun.RunSchemaChangesInJob.func1 at line 140
pkg/sql/schemachanger/scrun/scrun.go in pkg/sql/schemachanger/scrun.executeStage at line 212
pkg/sql/schemachanger/scerrors/errors.go in pkg/sql/schemachanger/scerrors.EventLogger.HandlePanicAndLogError at line 82
pkg/sql/internal.go in pkg/sql.(*InternalDB).DescsTxn.func1 at line 1971
pkg/sql/schemachanger/scdeps/run_deps.go in pkg/sql/schemachanger/scdeps.(*jobExecutionDeps).WithTxnInJob.func2 at line 206
pkg/sql/schemachanger/scrun/scrun.go in pkg/sql/schemachanger/scrun.RunSchemaChangesInJob.func1 at line 140
pkg/sql/schemachanger/scrun/scrun.go in pkg/sql/schemachanger/scrun.executeStage at line 199
pkg/sql/schemachanger/scexec/executor.go in pkg/sql/schemachanger/scexec.ExecuteStage at line 27
pkg/sql/schemachanger/scexec/exec_validation.go in pkg/sql/schemachanger/scexec.executeValidationOps at line 149
pkg/sql/schemachanger/scexec/exec_validation.go in pkg/sql/schemachanger/scexec.validationAccumulator.validate at line 205
pkg/sql/schemachanger/scexec/exec_validation.go in pkg/sql/schemachanger/scexec.executeValidateConstraint at line 110
pkg/sql/schemachanger/scdeps/validator.go in pkg/sql/schemachanger/scdeps.validator.ValidateConstraint at line 126
pkg/sql/backfill.go in pkg/sql.ValidateConstraint at line 1617
pkg/sql/catalog/descs/collection.go in pkg/sql/catalog/descs.(*historicalInternalExecTxnRunner).Exec at line 1763
pkg/sql/schemachanger/scdeps/validator.go in pkg/sql/schemachanger/scdeps.validator.makeHistoricalInternalExecTxnRunner.func1 at line 136
pkg/sql/internal.go in pkg/sql.(*InternalDB).DescsTxn at line 1969
pkg/sql/internal.go in pkg/sql.(*InternalDB).txn at line 2061
pkg/sql/internal.go in pkg/sql.(*InternalDB).txn.func2 at line 2047
pkg/kv/db.go in pkg/kv.(*DB).TxnWithAdmissionControl at line 1125
pkg/kv/db.go in pkg/kv.runTxn at line 1165
pkg/kv/txn.go in pkg/kv.(*Txn).exec at line 1172
pkg/sql/internal.go in pkg/sql.(*InternalDB).txn.func4 at line 2074
pkg/sql/internal.go in pkg/sql.(*InternalDB).DescsTxn.func1 at line 1971
pkg/sql/schemachanger/scdeps/validator.go in pkg/sql/schemachanger/scdeps.validator.makeHistoricalInternalExecTxnRunner.func1.1 at line 142
pkg/sql/backfill.go in pkg/sql.ValidateConstraint.func1 at line 1630
pkg/sql/internal.go in pkg/sql.(*InternalExecutor).WithSyntheticDescriptors at line 164
pkg/sql/backfill.go in pkg/sql.ValidateConstraint.func1.2 at line 1636
pkg/sql/check.go in pkg/sql.validateCheckExpr at line 84
pkg/sql/internal.go in pkg/sql.(*InternalExecutor).QueryRowEx at line 731
pkg/sql/internal.go in pkg/sql.(*InternalExecutor).QueryRowExWithCols at line 758
pkg/sql/internal.go in pkg/sql.(*InternalExecutor).queryRowExWithCols at line 771
pkg/sql/internal.go in pkg/sql.(*InternalExecutor).queryInternalBuffered at line 689
pkg/sql/internal.go in pkg/sql.(*rowsIterator).Next at line 580
pkg/sql/internal.go in pkg/sql.(*rowsIterator).Close at line 604
pkg/sql/internal.go in pkg/sql.(*InternalExecutor).execInternal.func1.1 at line 1272
pkg/sql/internal.go in pkg/sql.(*InternalExecutor).runWithEx.func2 at line 254
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 2394
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 2486
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd.func1 at line 2481
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt at line 182
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithProfiling at line 4734
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt.func2 at line 183
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 1122
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 3146
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithDistSQLEngine at line 3662
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRunAll at line 2099
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRunAll.func3 at line 2096
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRun at line 2397
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).Run at line 1087
pkg/sql/colflow/vectorized_flow.go in pkg/sql/colflow.(*vectorizedFlow).Run at line 302
pkg/sql/flowinfra/flow.go in pkg/sql/flowinfra.(*FlowBase).Run at line 584
pkg/sql/execinfra/processorsbase.go in pkg/sql/execinfra.(*ProcessorBaseNoHelper).Run at line 771
pkg/sql/execinfra/base.go in pkg/sql/execinfra.Run at line 193
pkg/sql/colflow/flow_coordinator.go in pkg/sql/colflow.(*FlowCoordinator).Next at line 143
pkg/sql/colexecerror/error.go in pkg/sql/colexecerror.CatchVectorizedRuntimeError at line 162
pkg/sql/colflow/flow_coordinator.go in pkg/sql/colflow.(*FlowCoordinator).nextAdapter at line 138
pkg/sql/colflow/flow_coordinator.go in pkg/sql/colflow.(*FlowCoordinator).next at line 121
pkg/sql/colexec/materializer.go in pkg/sql/colexec.(*Materializer).Next at line 282
pkg/sql/colexecerror/error.go in pkg/sql/colexecerror.CatchVectorizedRuntimeError at line 162
pkg/sql/colexec/materializer.go in pkg/sql/colexec.(*Materializer).nextAdapter at line 276
pkg/sql/colexec/materializer.go in pkg/sql/colexec.(*Materializer).next at line 248
pkg/sql/colflow/stats.go in pkg/sql/colflow.(*batchInfoCollector).Next at line 130
pkg/sql/colexecerror/error.go in pkg/sql/colexecerror.CatchVectorizedRuntimeError at line 162
pkg/sql/colflow/stats.go in pkg/sql/colflow.(*batchInfoCollector).next at line 122
pkg/sql/colexec/colexecutils/cancel_checker.go in pkg/sql/colexec/colexecutils.(*CancelChecker).Next at line 62
pkg/sql/colfetcher/index_join.go in pkg/sql/colfetcher.(*ColIndexJoin).Next at line 267
pkg/sql/colfetcher/index_join.go in pkg/sql/colfetcher.(*ColIndexJoin).assertScanRowCounts at line 359
```

### Tags

| Tag | Value |
| --- | --- |
| Command | start-single-node |
| Environment | v26.2.5 |
| Go Version | go1.25.5 |
| Platform | linux amd64 |
| Distribution | CCL |
| Cockroach Release | v26.2.5 |
| Cockroach SHA | c8455423826d0c4ba75a9ae78eb2dbd7e11648bb |
| # of CPUs | 20 |
| # of Goroutines | 639 |

Jira issue: CRDB-68193

Contributor guide

Open the contributing guide

Research direction

Start at pkg/sql/colfetcher/index_join.go:359, then follow the validation path through pkg/sql/check.go, pkg/sql/backfill.go, and pkg/sql/schemachanger/scexec/exec_validation.go. Reproduce the reported ALTER TABLE CHECK constraint validation failure if possible and trace why zero rows are returned where one is expected; done means the assertion no longer occurs and the schema change completes, with a regression test.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Active
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.