Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

changefeedccl: core changefeed fails in high data volume throughput test #134425

Open
asg0451 opened this issue Nov 6, 2024 · 2 comments
Open
Labels
A-cdc Change Data Capture branch-master Failures and bugs on the master branch. C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. T-cdc

Comments

@asg0451
Copy link
Contributor

asg0451 commented Nov 6, 2024

I observed and reproduced a core changefeed fail with a batch timestamp error while testing something unrelated.

Reproduction:

Given ./cockroach start-single-node --insecure running.

In 2 terminals, A and B:

A (in ./cockroach sql --insecure):

create table stuff2 (a int primary key);

B:

./cockroach sql --insecure -e "EXPERIMENTAL CHANGEFEED FOR TABLE stuff2 WITH OPTIONS (updated, resolved)" | grep -v stuff2 # start a changefeed but discard the data so it doesnt spam your terminal

A:

insert into stuff2 (a)  select i from generate_series(0, 10000) as g(i);
insert into stuff2 (a)  select i from generate_series(10001, 50000) as g(i);
insert into stuff2 (a)  select i from generate_series(50001, 100000) as g(i);
insert into stuff2 (a)  select i from generate_series(100001, 500000) as g(i);
insert into stuff2 (a)  select i from generate_series(500001, 1000000) as g(i);
insert into stuff2 (a)  select i from generate_series(1000001, 5000000) as g(i);
insert into stuff2 (a)  select i from generate_series(5000001, 10000000) as g(i);

..And then wait.. after a minute or so, the core changefeed in B will fail with:

(error encountered after some results were delivered)
ERROR: batch timestamp 1730910286.954309999,0 must be after replica GC threshold 1730910298.890121000,0 (r140: /Table/105/4/{3384343-5848963})

(table 105 here is stuff2; you can check that with SHOW RANGES FROM DATABASE defaultdb WITH TABLES)

@asg0451 asg0451 added the C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. label Nov 6, 2024
Copy link

blathers-crl bot commented Nov 6, 2024

Hi @asg0451, please add branch-* labels to identify which branch(es) this C-bug affects.

🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.

@asg0451 asg0451 changed the title core changefeedccl: core changefeed fails in high data volume throughput test Nov 6, 2024
@asg0451 asg0451 added A-cdc Change Data Capture branch-master Failures and bugs on the master branch. T-cdc labels Nov 6, 2024
Copy link

blathers-crl bot commented Nov 6, 2024

cc @cockroachdb/cdc

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-cdc Change Data Capture branch-master Failures and bugs on the master branch. C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. T-cdc
Projects
None yet
Development

No branches or pull requests

1 participant