为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
-
【TiDB 版本】:Release Version: v4.0.0-alpha-1119-g41c7d7e94
-
【DM版本】:Release Version: v1.0.2
-
【问题描述】: load数据时报错,错误码10006。 ################报错代码####################
“Type”: “UnknownError”, “msg”: “[code=10006:class=database:scope=downstream:level=high] run table schema failed - dbfile ./dumped_data.tidb/app_book.wn_leader_board_bak-schema.sql: execute statement failed: CREATE TABLE
wn_leader_board_bak
(id
int(11) NOT NULL AUTO_INCREMENT COMMENT ‘排行榜id’,nid
int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘书籍id==fiction.id’,cat_id
smallint(3) NOT NULL DEFAULT ‘0’ COMMENT ‘男频/女频: 1/2’,channel
smallint(3) NOT NULL,editor_id
int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘内容商id’,shelf_time
timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’ COMMENT ‘书籍上架时间,来自fiction表’,hot_num
int(11) NOT NULL DEFAULT ‘100’ COMMENT ‘书籍人气’,favorite_num
int(11) NOT NULL DEFAULT ‘10’ COMMENT ‘书籍收藏数’,update_status
int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘是否完结:1是,0否’,evaluate
float(4,1) NOT NULL DEFAULT ‘7.5’ COMMENT ‘书籍评分,默认7.5分’,reward_num
int(11) DEFAULT ‘5’ COMMENT ‘赞赏次数’,create_time
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘当前行创建时间’,PRIMARY KEY (id
),KEYcreate_time_index
(create_time
),KEYnid_index
(nid
),KEYidx_nid
(nid
) USING BTREE,KEYidx_cat_id
(cat_id
…: Error 1067: Invalid default value for ‘shelf_time’ngithub.com/pingcap/dm/pkg/terror.(*Error).Delegate /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/terror/terror.go:267ngithub.com/pingcap/dm/pkg/conn.(*BaseConn).ExecuteSQLWithIgnoreError /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/conn/baseconn.go:159ngithub.com/pingcap/dm/pkg/conn.(*BaseConn).ExecuteSQL /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/conn/baseconn.go:174ngithub.com/pingcap/dm/loader.(*DBConn).executeSQL.func2 /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/db.go:149ngithub.com/pingcap/dm/pkg/retry.(*FiniteRetryStrategy).Apply /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/retry/strategy.go:71ngithub.com/pingcap/dm/pkg/conn.(*BaseConn).ApplyRetryStrategy /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/conn/baseconn.go:180ngithub.com/pingcap/dm/loader.(*DBConn).executeSQL /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/db.go:144ngithub.com/pingcap/dm/loader.(*Loader).restoreStructure /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:964ngithub.com/pingcap/dm/loader.(*Loader).restoreTable /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:911ngithub.com/pingcap/dm/loader.(*Loader).restoreData /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:1064ngithub.com/pingcap/dm/loader.(*Loader).Restore /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:539ngithub.com/pingcap/dm/loader.(*Loader).Process /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:450ngithub.com/pingcap/dm/loader.(*Loader).Resume /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:618 runtime.goexit /usr/local/go/src/runtime/asm_amd64.s:1337”