failed to resume changefeed when meet error

[wk989898]

What did you do?

1. create a changefeed with mysql sink
2. create a table
3. changefeed meet error [CDC:ErrMySQLTxnError]MySQL txn error: Execute DDL failed, Query info: CREATE TABLE `t` (`id` INT PRIMARY KEY); : Error 1049 (42000): Unknown database 'test'"
4. creat database in downstream
5. pause/resume changefeed

What did you expect to see?

No response

What did you see instead?

Resume changefeed failed and meet error

Error: [CDC:ErrMySQLTxnError]MySQL txn error: Execute DDL failed, Query info: CREATE TABLE `t` (`id` INT PRIMARY KEY); : Error 1049 (42000): Unknown database 'test'

the changefeed state is normal but checkpointTs increase

cdc log:

cdc.log

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)