table not exist in db - Githubissues

tangweichun commented 3 years ago

canal1.1.5，表删除后报错如下，请教如何定位处理此类问题： 2021-08-18 11:31:22.268 [[scheduler-table-meta-snapshot]] ERROR c.a.o.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta - table not exist in db , pls check :lgw.t_wq_temp , mem : TableMeta [schema=lgw, table=t_wq_temp, fileds= FieldMeta [columnName=WQ_TEMP_ID, columnType=int, nullable=false, key=true, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=PROJECT_NAME, columnType=varchar(256), nullable=true, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=TEAM_NAME, columnType=varchar(128), nullable=true, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=IS_DEL, columnType=tinyint, nullable=false, key=false, defaultValue=0, extra=null, unique=false] FieldMeta [columnName=CREATED_TIME, columnType=datetime, nullable=false, key=false, defaultValue=CURRENT_TIMESTAMP, extra=null, unique=false] FieldMeta [columnName=LAST_MODIFIED_TIME, columnType=datetime, nullable=false, key=false, defaultValue=CURRENT_TIMESTAMP, extra=null, unique=false] FieldMeta [columnName=NOTE, columnType=varchar(512), nullable=true, key=false, defaultValue=null, extra=null, unique=false] ] 2021-08-18 11:31:22.268 [[scheduler-table-meta-snapshot]] ERROR c.a.o.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta - compare failed , check log

gongzh021 commented 1 year ago

我遇到了同样的问题 , 大侠你是如何解决的, 望指教

tangweichun commented 1 year ago

时间太长了我也记不清了，我后来改用tsdb，DDL变更都保存在后台MySQL数据库

杲 @.***

------------------ 原始邮件 ------------------ 发件人: "alibaba/canal" @.>; 发送时间: 2023年3月25日(星期六) 中午1:56 @.>; @.**@.>; 主题: Re: [alibaba/canal] table not exist in db (#3734)

我遇到了同样的问题 , 大侠你是如何解决的, 望指教

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: @.***>

alibaba / canal

table not exist in db #3734