ENGINE = InnoDB [schema]mysql [table]ha_health_check [current pos](mysql-bin.000033, 123222941) [next pos](mysql-bin.000033, 123223229) [current gtid set]786c3598-a60c-11ea-9912-1c34da499298:1-2467973 [next gtid set]
2020/09/24 10:06:08 syncer.go:1018: [info] flush all jobs meta = syncer-binlog = (mysql-bin.000033, 123237088), syncer-binlog-gtid = 786c3598-a60c-11ea-9912-1c34da499298:1-2467973
2020/09/24 10:06:08 meta.go:135: [info] save position to file, binlog-name:mysql-bin.000033 binlog-pos:123237088 binlog-gtid:786c3598-a60c-11ea-9912-1c34da499298:1-2467973
2020/09/24 10:06:08 main.go:79: [error] /home/jenkins/agent/workspace/build_tidb_enterprise_tools_master/go/src/github.com/pingcap/tidb-enterprise-tools/syncer/syncer.go:688: gen insert sqls failed: insert columns and data mismatch in length: 2 vs 3, schema: mxxd, table: sale_goods_attribute_name_category
/home/jenkins/agent/workspace/build_tidb_enterprise_tools_master/go/src/github.com/pingcap/tidb-enterprise-tools/syncer/syncer.go:193:
2020/09/24 10:06:08 syncer.go:928: [info] print status exits, err:context canceled
/*****************************************/
/ DatabaseName = mxxd-master /
/ TableName = sale_goods_attribute_name_category /
/*****************************************/
CREATE TABLE sale_goods_attribute_name_category
(
sale_goods_attribute_name_id
varchar(64) NOT NULL COMMENT ‘关联属性’,
sale_goods_category_inside_id
varchar(64) NOT NULL COMMENT ‘关联内部分类’,
KEY index_sale_goods_attribute_name_id
(sale_goods_attribute_name_id
),
KEY index_sale_goods_category_inside_id
(sale_goods_category_inside_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘商品分类属性关联表’
;