Tidb同步的时候遇到的问题,求解

[code=10006:class=database:scope=downstream:level=high] run table schema failed - dbfile ./dumped_data.task_corehr_glpuat/corehr_glpuat.glpjobview_bak-schema.sql: execute statement failed: CREATE TABLE glpjobview_bak (JobCode varchar(50) NOT NULL DEFAULT ‘’ COMMENT ‘职务代码’,JobName varchar(200) NOT NULL DEFAULT ‘’ COMMENT ‘职务名称’,LastUpdateTime datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’) ENGINE=InnoDB DEFAULT CHARSET=utf8;: Error 1067: Invalid default value for ‘LastUpdateTime’
github.com/pingcap/dm/pkg/terror.(*Error).Delegate
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/terror/terror.go:267
github.com/pingcap/dm/pkg/conn.(*BaseConn).ExecuteSQLWithIgnoreError
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/conn/baseconn.go:159
github.com/pingcap/dm/pkg/conn.(*BaseConn).ExecuteSQL
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/conn/baseconn.go:174
github.com/pingcap/dm/loader.(*DBConn).executeSQL.func2
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/db.go:149
github.com/pingcap/dm/pkg/retry.(*FiniteRetryStrategy).Apply
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/retry/strategy.go:71
github.com/pingcap/dm/pkg/conn.(*BaseConn).ApplyRetryStrategy
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/conn/baseconn.go:180
github.com/pingcap/dm/loader.(*DBConn).executeSQL
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/db.go:144
github.com/pingcap/dm/loader.(*Loader).restoreStructure
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:964
github.com/pingcap/dm/loader.(*Loader).restoreTable
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:911
github.com/pingcap/dm/loader.(*Loader).restoreData
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:1064
github.com/pingcap/dm/loader.(*Loader).Restore
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:539
github.com/pingcap/dm/loader.(*Loader).Process
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:450
github.com/pingcap/dm/loader.(*Loader).Resume
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:618
runtime.goexit
\t/usr/local/go/src/runtime/asm_amd64.s:1337

  1. 您这边设置的 LastUpdateTime datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’) ,tidb 中的 sql_mode 应该是有严格模式
  2. 修改sql_mode ,取消 STRICT_TRANS_TABLES 或者 修改默认值为可以插入的值。

如何修改 sql_mode 参考以下帖子

感谢感谢 问题已解决

:handshake:

现在查询sql报错了

如何修复啊

执行 set global sql_mode = ''; 看是否可行。

mysql> set global sql_mode=‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’; 改成这个了 修复了

:clap:,如果有需要可以根据楼上设置以下,也可以先观察下,这样设置是否会重现开贴的报错。

好的好的 非常感谢 我新入行 可能事情多一点 希望多多包涵啊

:ok_hand:,可以根据文档和《TiDB in Action》 学习使用下 tidb,如果有深入学习的需求可以去官网报名 PingCAP University 的学习课程,有免费和付费区分。

https://book.tidb.io/session1/chapter1/tidb-architecture.html
https://university.pingcap.com/

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。