[Bug]: mo_cdc: drop cdc task error

[heni02]

Is there an existing issue for the same bug?

• [X] I have checked the existing issues.

Branch Name

main

Commit ID

326c9fb

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

创建一个cdc任务到下游mysql，日志报表不存在，之后drop该任务成功，再创建同名的cdc任务（表存在的），mo日志还是报之前的表不存在

然后新创建的同步任务后下游有同步数据

Expected Behavior

No response

Steps to Reproduce

创建下游表不存在的任务（下游表名是大写，上游表是小写）
./mo_cdc task create --task-name "cdc_orders" --source-uri="mysql://dump:111@10.222.6.6:6001" --sink-type="mysql" --sink-uri="mysql://dump:111@10.222.1.129:3306"    --tables='tpch_100g.orders' --level="account"  --account="sys"

./mo_cdc task pause --task-name "cdc_orders" --source-uri="mysql://dump:111@10.222.6.6:6001"

./mo_cdc task show --task-name "cdc_orders" --source-uri="mysql://dump:111@10.222.6.6:6001"

./mo_cdc task drop --task-name "cdc_orders" --source-uri="mysql://dump:111@10.222.6.6:6001"

创建下游正确的表名同步任务：
./mo_cdc task create --task-name "cdc_orders" --source-uri="mysql://dump:111@10.222.6.6:6001" --sink-type="mysql" --sink-uri="mysql://dump:111@10.222.1.129:3306"    --tables='tpch_100g.orders:tpch_100g.ORDERS' --level="account"  --account="sys"

Additional information

No response

[ck89119]

找到问题原因，是删除cdc任务的时候，没有停止对下游的写入，仍在不停重试。

处理中

[heni02]

confirm,closed commit:f9b8368