看到之前有问题的回答说已经在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
collage_order, fk_collage_act_id 少了这两个列,得找找DDL的变更记录
原回答者GitHub用户agapple
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。