MySQL->MySQL，表修改字段长度的时候出现报错

[红薯]

报错内容

2022-04-18 13:28:32.831 [incre-apply-disruptor-5-thd-5] ERROR c.c.c.task.applier.incre.IncreDisruptorExceptionHandler - disruptor process increment event error,msg:SQLException: Can’t find file: ‘./hexing/tp_2576625_ogt_driver_apply.frm’ (errno: 2 - No such file or directory)
com.clougence.cloudcanal.base.service.task.exception.runtime.ApplierHandlerException: DDL error.context:{“db”:“hexing”,“table”:“tp_2576625_del_driver_apply”,“sql”:"[RENAME TABLE hexing.driver_apply TO hexing.tp_2576625_del_driver_apply,hexing.tp_2576625_ogt_driver_apply TO hexing.driver_apply]",“isDdl”:true,“pks”:[]},msg:SQLException: Can’t find file: ‘./hexing/tp_2576625_ogt_driver_apply.frm’ (errno: 2 - No such file or directory)
at com.clougence.cloudcanal.base.service.task.applier.AbstractRdbIncreDDLExecutor.doDDL(AbstractRdbIncreDDLExecutor.java:67)
at com.clougence.cloudcanal.mysql.worker.writer.incre.AbstractMySQLIncreApplyHandler.processDdl(AbstractMySQLIncreApplyHandler.java:108)
at com.clougence.cloudcanal.mysql.worker.writer.incre.MyIncreBatchApplyNoTxHandler.handleWithDdl(MyIncreBatchApplyNoTxHandler.java:180)
at com.clougence.cloudcanal.mysql.worker.writer.incre.MyIncreBatchApplyNoTxHandler.handle(MyIncreBatchApplyNoTxHandler.java:131)
at com.clougence.cloudcanal.mysql.worker.writer.incre.MyIncreBatchApplyNoTxHandler.handle(MyIncreBatchApplyNoTxHandler.java:37)
at com.clougence.cloudcanal.task.applier.incre.IncrementDisruptorApplyHandler.onEvent(IncrementDisruptorApplyHandler.java:25)
at com.clougence.cloudcanal.task.applier.incre.IncrementDisruptorApplyHandler.onEvent(IncrementDisruptorApplyHandler.java:12)
at com.lmax.disruptor.BatchEventProcessor.processEvents(BatchEventProcessor.java:168)
at com.lmax.disruptor.BatchEventProcessor.run(BatchEventProcessor.java:125)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Can’t find file: ‘./hexing/tp_2576625_ogt_driver_apply.frm’ (errno: 2 - No such file or directory)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:762)
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:646)
at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:632)
at com.clougence.cloudcanal.mysql.worker.writer.incre.MySqlIncreDdlExecutor.executeSqls(MySqlIncreDdlExecutor.java:40)
at com.clougence.cloudcanal.base.service.task.applier.AbstractRdbIncreDDLExecutor.doDDL(AbstractRdbIncreDDLExecutor.java:61)
… 9 common frames omitted
2022-04-18 13:28:32.847 [Thread-2] INFO com.clougence.cl

执行的SQL
ALTER TABLE driver_apply
MODIFY COLUMN vehicle_belong varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT ‘xxxxx’ AFTER plate_num

[junyu-cloudcanal]

@红薯 Can’t find file: ‘./hexing/tp_2576625_ogt_driver_apply.frm’ (errno: 2 - No such file or directory) 这个看上去数据库有点问题–阿里云问问？

[红薯]

我现在的处理方法就是修改订阅，把问题表下掉同步，然后修改同步表的字段后再修改订阅，把问题表加入到同步任务中

[红薯]

主库用的是polardb，在阿里云的DMS上执行的SQL，是不是DMS的机制导致的