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

[CDC:ErrSnapshotSchemaNotFound] schema 41766 not found in schema snapshot #9476

Closed
CharlesCheung96 opened this issue Aug 2, 2023 · 5 comments · Fixed by #9471
Closed

[CDC:ErrSnapshotSchemaNotFound] schema 41766 not found in schema snapshot #9476

CharlesCheung96 opened this issue Aug 2, 2023 · 5 comments · Fixed by #9471
Assignees
Labels
affects-5.4 This bug affects the 5.4.x(LTS) versions. affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.3 area/ticdc Issues or PRs related to TiCDC. report/community The community has encountered this bug. report/customer Customers have encountered this bug. severity/major type/bug The issue is confirmed as a bug.

Comments

@CharlesCheung96
Copy link
Contributor

What did you do?

  1. create changefeed with the following config:
[filter]
rules = ['*.*', '!ignore1.*']
  1. create database ignore1; create table a and a_new;
  2. USE ignore1; RENAME TABLE a TO a_bak, a_new TO a;

What did you expect to see?

cdc skip the rename tables ddl

What did you see instead?

[CDC:ErrSnapshotSchemaNotFound] schema 41766 not found in schema snapshot

Versions of the cluster

Upstream TiDB cluster version (execute SELECT tidb_version(); in a MySQL client):

(paste TiDB cluster version here)

Upstream TiKV version (execute tikv-server --version):

(paste TiKV version here)

TiCDC version (execute cdc version):

(paste TiCDC version here)
@CharlesCheung96 CharlesCheung96 added type/bug The issue is confirmed as a bug. area/ticdc Issues or PRs related to TiCDC. labels Aug 2, 2023
@fubinzh
Copy link

fubinzh commented Aug 2, 2023

/label affects-7.1

@ti-chi-bot ti-chi-bot bot added the affects-7.1 This bug affects the 7.1.x(LTS) versions. label Aug 2, 2023
@fubinzh
Copy link

fubinzh commented Aug 2, 2023

/label affects-6.5

@ti-chi-bot ti-chi-bot bot added the affects-6.5 This bug affects the 6.5.x(LTS) versions. label Aug 2, 2023
@fubinzh
Copy link

fubinzh commented Aug 2, 2023

/severity major

@seiya-annie
Copy link

/found customer

@ti-chi-bot ti-chi-bot bot added the report/customer Customers have encountered this bug. label Jun 4, 2024
@seiya-annie
Copy link

/found community

@ti-chi-bot ti-chi-bot bot added the report/community The community has encountered this bug. label Jun 13, 2024
@jebter jebter added affects-5.4 This bug affects the 5.4.x(LTS) versions. affects-6.1 This bug affects the 6.1.x(LTS) versions. labels Dec 25, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-5.4 This bug affects the 5.4.x(LTS) versions. affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.3 area/ticdc Issues or PRs related to TiCDC. report/community The community has encountered this bug. report/customer Customers have encountered this bug. severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

5 participants