Skip to content

sql: TestBackfillWithProtectedTS failed #142339

@cockroach-teamcity

Description

@cockroach-teamcity

sql.TestBackfillWithProtectedTS failed with artifacts on release-25.1 @ 146bb4be87605230b3a6286fd6a73f19d2850217:

=== RUN   TestBackfillWithProtectedTS
    test_log_scope.go:165: test logs captured to: /artifacts/tmp/_tmp/ebab9da743cf8d3e9fbccfacc75c4814/logTestBackfillWithProtectedTS874100712
    test_log_scope.go:76: use -show-logs to present logs inline
    test_server_shim.go:139: cluster virtualization disabled in global scope due to issue: #76378 (expected label: C-bug)
    backfill_protected_timestamp_test.go:551: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/ebab9da743cf8d3e9fbccfacc75c4814/logTestBackfillWithProtectedTS874100712
--- FAIL: TestBackfillWithProtectedTS (196.02s)
=== RUN   TestBackfillWithProtectedTS/create_materialized_view
    backfill_protected_timestamp_test.go:502: 2025-03-05T15:58:04Z running backfill with PTS not setup early enough
    backfill_protected_timestamp_test.go:437: 2025-03-05T15:58:04Z i=0 begin running operations in the middle of backfill
    backfill_protected_timestamp_test.go:442: 2025-03-05T15:58:42Z i=0 finished running operations in the middle of backfill. retErr: failed to enqueue replica for GC: pq: crdb_internal.kv_enqueue_replica(): failed to set GC thresholds: key range /Table/104/1/101001-/Table/105 outside of bounds of range /Table/104/1/101001-/Table/104/1/194001; suggested ranges: [desc: r78:/Table/104/1/1{01001-94001} [(n1,s1):1, next=2, gen=5, sticky=1741190603.238387945,0], lease: repl=(n1,s1):1 seq=1 start=0,0 exp=1741190325.799872764,0 pro=1741190319.799872764,0 acq=Request, closed_timestamp_policy: LAG_BY_CLUSTER_SETTING]
    backfill_protected_timestamp_test.go:500: 2025-03-05T15:59:27Z backfill goroutine finished. retErr: could not read jobs table: context canceled
    backfill_protected_timestamp_test.go:540: 
        	Error Trace:	pkg/sql/backfill_protected_timestamp_test.go:540
        	Error:      	Received unexpected error:
        	            	failed to enqueue replica for GC: pq: crdb_internal.kv_enqueue_replica(): failed to set GC thresholds: key range /Table/104/1/101001-/Table/105 outside of bounds of range /Table/104/1/101001-/Table/104/1/194001; suggested ranges: [desc: r78:/Table/104/1/1{01001-94001} [(n1,s1):1, next=2, gen=5, sticky=1741190603.238387945,0], lease: repl=(n1,s1):1 seq=1 start=0,0 exp=1741190325.799872764,0 pro=1741190319.799872764,0 acq=Request, closed_timestamp_policy: LAG_BY_CLUSTER_SETTING]
        	            	(1) attached stack trace
        	            	  -- stack trace:
        	            	  | github.com/cockroachdb/cockroach/pkg/sql_test.TestBackfillWithProtectedTS.func7.2.1
        	            	  | 	pkg/sql/backfill_protected_timestamp_test.go:476
        	            	  | github.com/cockroachdb/cockroach/pkg/sql_test.TestBackfillWithProtectedTS.func7.2
        	            	  | 	pkg/sql/backfill_protected_timestamp_test.go:490
        	            	  | github.com/cockroachdb/cockroach/pkg/sql_test.TestBackfillWithProtectedTS.func7.Group.GoCtx.4
        	            	  | 	pkg/util/ctxgroup/ctxgroup.go:189
        	            	  | golang.org/x/sync/errgroup.(*Group).Go.func1
        	            	  | 	external/org_golang_x_sync/errgroup/errgroup.go:78
        	            	  | runtime.goexit
        	            	  | 	src/runtime/asm_arm64.s:1222
        	            	Wraps: (2) failed to enqueue replica for GC
        	            	Wraps: (3) pq: crdb_internal.kv_enqueue_replica(): failed to set GC thresholds: key range /Table/104/1/101001-/Table/105 outside of bounds of range /Table/104/1/101001-/Table/104/1/194001; suggested ranges: [desc: r78:/Table/104/1/1{01001-94001} [(n1,s1):1, next=2, gen=5, sticky=1741190603.238387945,0], lease: repl=(n1,s1):1 seq=1 start=0,0 exp=1741190325.799872764,0 pro=1741190319.799872764,0 acq=Request, closed_timestamp_policy: LAG_BY_CLUSTER_SETTING]
        	            	Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *pq.Error
        	Test:       	TestBackfillWithProtectedTS/create_materialized_view
    --- FAIL: TestBackfillWithProtectedTS/create_materialized_view (86.79s)
Help

See also: How To Investigate a Go Test Failure (internal)

Same failure on other branches

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-48287

Metadata

Metadata

Assignees

Labels

C-test-failureBroken test (automatically or manually discovered).O-robotOriginated from a bot.P-2Issues/test failures with a fix SLA of 3 monthsT-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)branch-release-25.1

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions