cockroachdb / cockroachdb/cockroach

Can't ALTER TABLE ALTER COLUMN

Open
#137,668 14 comments 0 reactions 0 assignees View on GitHub
branch-release-24.3 C-bug O-community T-sql-foundations X-blathers-triaged
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

Hello.

I'm running a CockroachDB 24.3.0 cluster and I'm trying to alter my table to change some columns from `INT8` to `INT4` or `INT2`.
See https://forum.cockroachlabs.com/t/question-about-int-data-type/6949.

In the UI the operation looks stuck
![image](https://github.com/user-attachments/assets/3215fe62-18da-4bc6-bbaa-ad699191af20)

and in the logs I can see the following:
```
I241218 06:30:50.208437 445440708 sql/conn_executor_ddl.go:104 ⋮ [T1,Vsystem,n2,client=127.0.0.1:40648,hostnossl,user=root] 38401 queued new schema change job 1030334218832871426 using the new schema changer
I241218 06:30:50.215675 445440708 jobs/wait.go:56 ⋮ [T1,Vsystem,n2,client=127.0.0.1:40648,hostnossl,user=root] 38402 waiting for 1 [1030334218832871426] queued jobs to complete
I241218 06:30:50.215781 445440577 jobs/adopt.go:242 ⋮ [T1,Vsystem,n2,client=127.0.0.1:40648,hostnossl,user=root] 38403 job 1030334218832871426: resuming execution
I241218 06:30:50.226729 445440709 sql/catalog/lease/descriptor_state.go:142 ⋮ [n2] 38404 new lease: tabledesc.immutable: {ID: 110, Version: 14, ModificationTime: "1734503450.166699572,0", ParentID: 100, ParentSchemaID: 101, State: PUBLIC, NextColumnID: 8, Columns: [{ID: 1, TypeID: 1082, Null: false, HasDefault: true}, {ID: 2, TypeID: 20, Null: false}, {ID: 3, TypeID: 20, Null: false}, {ID: 4, TypeID: 20, Null: false}, {ID: 5, TypeID: 20, Null: false}, {ID: 6, TypeID: 20, Null: false}, {ID: 7, TypeID: 1700, Null: false}], NextFamilyID: 2, Families: [{ID: 0, Columns: [4, 2, 3, 1, 5, 6]}, {ID: 1, Columns: [7]}], Mutations: [{MutationID: 1, Direction: ADD, State: WRITE_ONLY, ConstraintType: CHECK, Check: {Columns: [6], Validity: Validating, State: ADD, MutationID: 1}}, {MutationID: 1, Direction: ADD, State: WRITE_ONLY, ConstraintType: CHECK, Check: {Columns: [2], Validity: Validating, State: ADD, MutationID: 1}}, {MutationID: 1, Direction: ADD, State: WRITE_ONLY, ConstraintType: CHECK, Check: {Columns: [3], Validity: Validating, State: ADD, MutationID: 1}}, {MutationID: 1, Direction: ADD, State: WRITE_ONLY, ConstraintType: CHECK, Check: {Columns: [5], Validity: Validating, State: ADD, MutationID: 1}}], PrimaryIndex: 1, NextIndexID: 2, Indexes: [{ID: 1, Unique: true, KeyColumns: [{ID: 4, Dir: ASC}, {ID: 2, Dir: ASC}, {ID: 3, Dir: ASC}, {ID: 1, Dir: ASC}, {ID: 5, Dir: ASC}, {ID: 6, Dir: ASC}], StoreColumns: [7]}], Checks: [{Columns: [6], Validity: Validating}, {Columns: [2], Validity: Validating}, {Columns: [3], Validity: Validating}, {Columns: [5], Validity: Validating}]}
I241218 06:30:50.236237 445440623 jobs/registry.go:1599 ⋮ [T1,Vsystem,n2] 38405 NEW SCHEMA CHANGE job 1030334218832871426: stepping through state running
I241218 06:30:50.258583 445440623 1@jobs/structured_log.go:55 ⋮ [T1,Vsystem,n2] 38406 ={"Timestamp":1734503450258579583,"EventType":"status_change","JobID":1030334218832871426,"JobType":"NEW SCHEMA CHANGE","Description":"status changed to: running","PreviousStatus":"running","NewStatus":"running","RunNum":1}
I241218 06:30:50.277531 445440623 sql/schemachanger/scrun/scrun.go:306 ⋮ [T1,Vsystem,n2,job=NEW SCHEMA CHANGE id=1030334218832871426] 38407 rebuilding declarative schema change state from descriptors [110]
I241218 06:30:50.277726 445440623 sql/schemachanger/scplan/plan.go:96 ⋮ [T1,Vsystem,n2,job=NEW SCHEMA CHANGE id=1030334218832871426] 38408 building declarative schema changer plan in PostCommitPhase (rollback=false) for ALTER TABLE
I241218 06:30:50.281101 445440623 sql/schemachanger/scrun/scrun.go:179 ⋮ [T1,Vsystem,n2,job=NEW SCHEMA CHANGE id=1030334218832871426] 38409 executing declarative schema change PostCommitPhase stage 1 of 1 with 4 ValidationType ops (rollback=false) for ALTER TABLE
I241218 06:30:50.285162 445440623 sql/check.go:65 ⋮ [T1,Vsystem,n2,job=NEW SCHEMA CHANGE id=1030334218832871426] 38410 validating check constraint ‹"CAST(CAST(statistic_type AS INT2) AS INT8) = statistic_type"› with query ‹"SELECT date_logical_session, market_code, currency_code, valor_number, value_type, statistic_type, val FROM [110 AS t]@[1] WHERE NOT ((CAST(CAST(statistic_type AS INT2) AS INT8) = statistic_type)) LIMIT 1"›
I241218 06:34:06.297834 1340 sql/temporary_schema.go:488 ⋮ [T1,Vsystem,n2] 38411 skipping temporary object cleanup run as it is not the leaseholder
I241218 06:34:06.297894 1340 sql/temporary_schema.go:489 ⋮ [T1,Vsystem,n2] 38412 completed temporary object cleanup job
I241218 06:34:06.297907 1340 sql/temporary_schema.go:641 ⋮ [T1,Vsystem,n2] 38413 temporary object cleaner next scheduled to run at 2024-12-18 07:04:06.297396814 +0000 UTC m=+324049.477924154
I241218 06:34:17.605557 139 util/admission/work_queue.go:551 ⋮ [T1,Vsystem,n2] 38414 kv: FIFO threshold for tenant 1 is -128
I241218 06:34:18.305733 141 util/admission/work_queue.go:551 ⋮ [T1,Vsystem,n2] 38415 sql-kv-response: FIFO threshold for tenant 1 is -128
I241218 06:34:59.805181 1073 util/admission/work_queue.go:551 ⋮ [T1,Vsystem,n2] 38416 kv: FIFO threshold for tenant 1 is -128
I241218 06:39:17.605559 139 util/admission/work_queue.go:551 ⋮ [T1,Vsystem,n2] 38417 kv: FIFO threshold for tenant 1 is -128
I241218 06:39:18.305901 141 util/admission/work_queue.go:551 ⋮ [T1,Vsystem,n2] 38418 sql-kv-response: FIFO threshold for tenant 1 is -128
I241218 06:39:59.805597 1073 util/admission/work_queue.go:551 ⋮ [T1,Vsystem,n2] 38419 kv: FIFO threshold for tenant 1 is -128
W241218 06:43:16.936368 445440623 sql/schemachanger/scrun/scrun.go:137 ⋮ [T1,Vsystem,n2,job=NEW SCHEMA CHANGE id=1030334218832871426] 38420 failed executing declarative schema change PostCommitPhase stage 1 of 1 with 4 ValidationType ops (rollback=false) for ALTER TABLE with error: validate check constraint: batch timestamp 1734503450.284943318,0 must be after replica GC threshold 1734503451.322358857,0 (r4259: ‹/Table/110/1/48{31/4/333/18544/131/32-44/7/333/17210/206/6}›)
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 job 1030334218832871426: running execution encountered retriable error: validate check constraint: batch timestamp 1734503450.284943318,0 must be after replica GC threshold 1734503451.322358857,0 (r4259: ‹/Table/110/1/48{31/4/333/18544/131/32-44/7/333/17210/206/6}›)
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 +(1) forced error mark
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | ‹"retriable job error"›
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/errors/withstack/*withstack.withStack::
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 +Wraps: (2) attached stack trace
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + -- stack trace:
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).execInternal.func1.1
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/internal.go:1243
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.(*rowsIterator).Close
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/internal.go:604
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.(*rowsIterator).Next
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/internal.go:580
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).queryInternalBuffered
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/internal.go:689
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).queryRowExWithCols
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/internal.go:771
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).QueryRowExWithCols
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/internal.go:758
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).QueryRowEx
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/internal.go:731
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.validateCheckExpr
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/check.go:66
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.ValidateConstraint.func1.2
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/backfill.go:1564
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.(*InternalExecutor).WithSyntheticDescriptors
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/internal.go:161
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.ValidateConstraint.func1
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/backfill.go:1558
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scdeps.validator.makeHistoricalInternalExecTxnRunner.func1.1
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/schemachanger/scdeps/validator.go:134
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.(*InternalDB).DescsTxn.func1
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/internal.go:1927
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.(*InternalDB).txn.func4
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/internal.go:2024
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/kv.(*Txn).exec
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/kv/txn.go:1052
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/kv.runTxn
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/kv/db.go:1098
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/kv.(*DB).TxnWithAdmissionControl
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/kv/db.go:1061
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.(*InternalDB).txn.func2
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/internal.go:1997
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.(*InternalDB).txn
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/internal.go:2011
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.(*InternalDB).DescsTxn
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/internal.go:1925
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scdeps.validator.makeHistoricalInternalExecTxnRunner.func1
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/schemachanger/scdeps/validator.go:128
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.(*historicalInternalExecTxnRunner).Exec
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/catalog/descs/collection.go:1294
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql.ValidateConstraint
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/backfill.go:1545
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scdeps.validator.ValidateConstraint
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/schemachanger/scdeps/validator.go:118
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scexec.executeValidateConstraint
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/schemachanger/scexec/exec_validation.go:67
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scexec.executeValidationOp
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/schemachanger/scexec/exec_validation.go:122
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scexec.executeValidationOps
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/schemachanger/scexec/exec_validation.go:105
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scexec.ExecuteStage
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/schemachanger/scexec/executor.go:27
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scrun.executeStage
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/schemachanger/scrun/scrun.go:192
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scrun.RunSchemaChangesInJob.func1
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/schemachanger/scrun/scrun.go:137
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/schemachanger/scdeps.(*jobExecutionDeps).WithTxnInJob.func1
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/schemachanger/scdeps/run_deps.go:146
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 +Wraps: (3) validate check constraint
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 +Wraps: (4) attached stack trace
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + -- stack trace:
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/colflow/colrpc.(*Inbox).Next.func1
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/colflow/colrpc/inbox.go:319
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | runtime.gopanic
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | GOROOT/src/runtime/panic.go:770
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/colexecerror.ExpectedError
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/colexecerror/error.go:294
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/colflow/colrpc.(*Inbox).Next
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/colflow/colrpc/inbox.go:380
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/colexec.(*ParallelUnorderedSynchronizer).Init.(*ParallelUnorderedSynchronizer).Init.func1.func2
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/colexec/parallel_unordered_synchronizer.go:238
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/colexecerror/error.go:147
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | github.com/cockroachdb/cockroach/pkg/sql/colexec.(*ParallelUnorderedSynchronizer).init.func1
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | pkg/sql/colexec/parallel_unordered_synchronizer.go:299
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | runtime.goexit
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | src/runtime/asm_amd64.s:1695
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 +Wraps: (5)
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 +Wraps: (6) tags: [n2,job=‹NEW SCHEMA CHANGE id=1030334218832871426›,intExec=validate check constraint,f‹205f4220›,distsql.stmt=‹SELECT date_logical_session, market_code, currency_code, valor_number, value_type, statistic_type, val FROM [110 AS t]@[1] WHERE NOT ((CAST(CAST(statistic_type AS INT2) AS INT8) = statistic_type)) LIMIT _›,distsql.gateway=2,distsql.appname=‹$ internal-validate check constraint›,distsql.txn=‹0e08cde3-9388-4a12-b79a-c47fb8113605›,streamID=‹8›,received-error]
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 +Wraps: (7) tags: [n‹6›,f‹205f4220›,job=‹NEW SCHEMA CHANGE id=1030334218832871426›,distsql.stmt=‹SELECT date_logical_session, market_code, currency_code, valor_number, value_type, statistic_type, val FROM [110 AS t]@[1] WHERE NOT ((CAST(CAST(statistic_type AS INT2) AS INT8) = statistic_type)) LIMIT _›,distsql.gateway=‹2›,distsql.appname=‹$ internal-validate check constraint›,distsql.txn=‹0e08cde3-9388-4a12-b79a-c47fb8113605›,streamID=‹8›,sent-error=]
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 +Wraps: (8)
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | (opaque error wrapper)
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 + | type name: github.com/cockroachdb/cockroach/pkg/sql/colexecerror/*colexecerror.StorageError
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 +Wraps: (9) batch timestamp 1734503450.284943318,0 must be after replica GC threshold 1734503451.322358857,0 (r4259: ‹/Table/110/1/48{31/4/333/18544/131/32-44/7/333/17210/206/6}›)
E241218 06:43:16.938672 445440623 jobs/registry.go:1679 ⋮ [T1,Vsystem,n2] 38421 +Error types: (1) *markers.withMark (2) *withstack.withStack (3) *errutil.withPrefix (4) *withstack.withStack (5) *colexecerror.notInternalError (6) *contexttags.withContext (7) *contexttags.withContext (8) *errbase.opaqueWrapper (9) *kvpb.BatchTimestampBeforeGCError
E241218 06:43:16.938975 445440623 jobs/adopt.go:451 ⋮ [T1,Vsystem,n2] 38422 job 1030334218832871426: adoption completed with error validate check constraint: batch timestamp 1734503450.284943318,0 must be after replica GC threshold 1734503451.322358857,0 (r4259: ‹/Table/110/1/48{31/4/333/18544/131/32-44/7/333/17210/206/6}›)
```

Can you please provide some help?
Yesterday I tried the same, but changing only one column at time and it has also hanged for the entire night with no result.

Jira issue: CRDB-45689

Epic CRDB-44826

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.