【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】
【复现路径】做过哪些操作出现的问题
【遇到的问题:问题现象及影响】
【资源配置】
【附件:截图/日志/监控】
mysql8->mysql8 全量数据同步完成,上下游及task sql_mode 一致。
worker日志:
[2023/01/31 11:40:41.449 +08:00] [INFO] [streamer_controller.go:77] [“last slave connection”] [task=alydm] [unit=“binlog replication”] [“connection ID”=5178652]
[2023/01/31 11:40:41.449 +08:00] [INFO] [mode.go:101] [“change count”] [task=alydm] [unit=“binlog replication”] [“previous count”=0] [“new count”=0]
[2023/01/31 11:40:41.449 +08:00] [INFO] [mode.go:101] [“change count”] [task=alydm] [unit=“binlog replication”] [“previous count”=0] [“new count”=1]
[2023/01/31 11:40:41.449 +08:00] [INFO] [safe_mode.go:70] [“enable safe-mode because of task initialization”] [task=alydm] [unit=“binlog replication”] [“duration in seconds”=60]
[2023/01/31 11:40:41.465 +08:00] [INFO] [tracker.go:436] [“Downstream schema tracker init. “] [task=alydm] [unit=“binlog replication”] [tableID=]
[2023/01/31 11:40:41.469 +08:00] [ERROR] [baseconn.go:184] [“execute statement failed”] [task=alydm] [unit=“binlog replication”] [query=“SET SESSION SQL_MODE = ‘ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’”] [argument=””] [error=“Error 1231: Variable ‘sql_mode’ can’t be set to the value of ‘NO_AUTO_CREATE_USER’”]
跟这个问题一样