cockroachdb / cockroachdb/cockroach

changefeedccl: resume after truncate looks like it repeatedly hits the same boundary

Open
#98,506 1 comment 1 reaction 0 assignees View on GitHub
A-cdc C-bug T-cdc
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

On master:

```sql
CREATE TABLE foo...
INSERT INTO foo ...
CREATE CHANGEFEED FOR foo INTO 'null://sink' WITH on_error='pause';
-- wait for changefeed to checkpoint
TRUNCATE TABLE foo;
-- Changefeed pauses, correctly.
RESUME JOB ;
-- Changefeed claims to be running
INSERT INTO foo...
-- Changefeed pauses again with the same error
```

Motivated by [this support issue](https://github.com/cockroachlabs/support/issues/2127), but it seems likely we have multiple issues around resuming a job on a truncated table (or any table whose primary index has changed?).

Jira issue: CRDB-25302

Epic CRDB-28883

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.