开发者社区> 问答> 正文

TableMeta 报错

看到之前有问题的回答说已经在v1.1.1版本解决该Bug。 而我当前的版本就是v1.1.1,依然出现该问题

2018-11-20 17:25:19.708 [[scheduler-table-meta-snapshot]] ERROR c.a.o.canal.parse.inbound.mysql.tsdb.DatabaseTableMeta - pls submit github issue, show create table ddl:CREATE TABLE vs_order_goods_hold ( pk_id int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', fk_order_id int(11) NOT NULL COMMENT '订单ID(表:vs_order)', fk_store_id int(11) NOT NULL COMMENT '店铺ID(表:vs_store)', fk_goods_id int(11) NOT NULL COMMENT '商品ID(表:vs_store_goods)', fk_specgds_id int(11) NOT NULL COMMENT '规格ID(表:esl_gds_specgds)', hold_num int(10) NOT NULL COMMENT '订单规格商品数量', is_archiving int(1) NOT NULL COMMENT '是否归档;0:false ,1:true', collage_order int(1) DEFAULT NULL COMMENT '是否拼团订单商品(0:否,1:是)', fk_collage_act_id int(11) DEFAULT NULL COMMENT '拼团活动ID(表:esl_sale_activity)', remark varchar(50) DEFAULT NULL COMMENT '备注', create_user int(11) NOT NULL COMMENT '创建者用户ID(表:vs_member)', create_time datetime NOT NULL COMMENT '创建时间', update_user int(11) DEFAULT NULL COMMENT '更新者用户ID(表:vs_member)', update_time datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (pk_id) ) ENGINE=InnoDB AUTO_INCREMENT=3540 DEFAULT CHARSET=utf8 COMMENT='订单占有商品库存' , compare failed . db : TableMeta [schema=phs_erp_test, table=vs_order_goods_hold, fileds= FieldMeta [columnName=pk_id, columnType=int(11), nullable=false, key=true, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=fk_order_id, columnType=int(11), nullable=false, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=fk_store_id, columnType=int(11), nullable=false, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=fk_goods_id, columnType=int(11), nullable=false, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=fk_specgds_id, columnType=int(11), nullable=false, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=hold_num, columnType=int(10), nullable=false, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=is_archiving, columnType=int(1), nullable=false, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=collage_order, columnType=int(1), nullable=true, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=fk_collage_act_id, columnType=int(11), nullable=true, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=remark, columnType=varchar(50), nullable=true, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=create_user, columnType=int(11), nullable=false, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=create_time, columnType=datetime, nullable=false, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=update_user, columnType=int(11), nullable=true, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=update_time, columnType=datetime, nullable=true, key=false, defaultValue=null, extra=null, unique=false] ] mem : TableMeta [schema=phs_erp_test, table=vs_order_goods_hold, fileds= FieldMeta [columnName=pk_id, columnType=int(11), nullable=false, key=true, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=fk_order_id, columnType=int(11), nullable=false, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=fk_store_id, columnType=int(11), nullable=false, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=fk_goods_id, columnType=int(11), nullable=false, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=fk_specgds_id, columnType=int(11), nullable=false, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=hold_num, columnType=int(10), nullable=false, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=is_archiving, columnType=int(1), nullable=false, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=remark, columnType=varchar(50), nullable=true, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=create_user, columnType=int(11), nullable=false, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=create_time, columnType=datetime, nullable=false, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=update_user, columnType=int(11), nullable=true, key=false, defaultValue=null, extra=null, unique=false] FieldMeta [columnName=update_time, columnType=datetime, nullable=true, key=false, defaultValue=null, extra=null, unique=false] ]

原提问者GitHub用户wongminbin

展开
收起
Java工程师 2023-05-08 17:44:33 124 0
1 条回答
写回答
取消 提交回答
  • collage_order, fk_collage_act_id 少了这两个列,得找找DDL的变更记录

    原回答者GitHub用户agapple

    2023-05-09 18:43:36
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
低代码开发师(初级)实战教程 立即下载
冬季实战营第三期:MySQL数据库进阶实战 立即下载
阿里巴巴DevOps 最佳实践手册 立即下载