dm开启 safe mode ，报错 Failed to read auto-increment value from storage engine，关闭 safe mode同步正常

foxchan · 2024 年8 月 13 日 03:14

【 TiDB 使用环境】生产环境

开启safe-mode

dmctl --master-addr 192.168.1.42:8261 query-status dealermanager_to_20
{
“result”: true,
“msg”: “”,
“sources”: [
{
“result”: true,
“msg”: “”,
“sourceStatus”: {
“source”: “mysql-replica-036dealermgr”,
“worker”: “dm-192.168.1.41-8262”,
“result”: null,
“relayStatus”: null
},
“subTaskStatus”: [
{
“name”: “dealermanager_to_20”,
“stage”: “Paused”,
“unit”: “Sync”,
“result”: {
“isCanceled”: false,
“errors”: [
{
“ErrCode”: 10006,
“ErrClass”: “database”,
“ErrScope”: “not-set”,
“ErrLevel”: “high”,
“Message”: “startLocation: [position: (mysql-bin.016294, 687642180), gtid-set: 00000000-0000-0000-0000-000000000000:0], endLocation: [position: (mysql-bin.016294, 688983675), gtid-set: 00000000-0000-0000-0000-000000000000:0]: execute statement failed: REPLACE INTO dealermanager.notify_send_log (id,notify_instance_id,notify_status,notify_content,notify_user_type,notify_user_collection,notify_type,notify_topic,exception_name,exception_msg,notify_time) VALUES (?,?,?,?,?,?,?,?,?,?,?)”,
“RawCause”: “Error 1467 (HY000): Failed to read auto-increment value from storage engine”,