TiDB DM同步報錯ErrCode 44006處理一例
TiDB DM同步ErrCode 44006錯誤一般是由於源端做了DDL變更導致的。
報錯資訊如下：
# tiup dmctl --master-addr 192.168.1.1:8261 query-status test
tiup is checking updates for component dmctl ...
A new version of dmctl is available:
The latest version: v6.0.0
Local installed version: v5.4.0
Update current component: tiup update dmctl
Update all components: tiup update --all
Starting component `dmctl`: /root/.tiup/components/dmctl/v5.4.0/dmctl/dmctl /root/.tiup/components/dmctl/v5.4.0/dmctl/dmctl --master-addr 192.168.1.1:8261 query-status test
{
"result": true,
"msg": "",
"sources": [
{
"result": true,
"msg": "",
"sourceStatus": {
"source": "mysql-replica-01",
"worker": "dm-192.168.1.1-8262",
"result": null,
"relayStatus": null
},
"subTaskStatus": [
{
"name": "test",
"stage": "Paused",
"unit": "Sync",
"result": {
"isCanceled": false,
"errors": [
{
"ErrCode": 44006,
"ErrClass": "schema-tracker",
"ErrScope": "internal",
"ErrLevel": "high",
"Message": "startLocation: [position: (mysql-bin.000387, 175542807), gtid-set: 2ae5ff08-749b-11ec-b0b8-043f72e4f03a:1-3128394,57830545-209f-11ea-94cf-b8599fb677d0:1-92442922], endLocation: [position: (mysql-bin.000387, 175543234), gtid-set: 2ae5ff08-749b-11ec-b0b8-043f72e4f03a:1-3128394,57830545-209f-11ea-94cf-b8599fb677d0:1-92442923], origin SQL: [ALTER TABLE `test_agent`.`tesst_copy` \r\nCHANGE COLUMN `name1` `regionName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `id`,\r\nCHANGE COLUMN `regionName` `countyName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `regionName`]: cannot track DDL: ALTER TABLE `test_agent`.`tesst_copy` CHANGE COLUMN `name1` `regionName` VARCHAR(255) CHARACTER SET UTF8MB4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `id`",
"RawCause": "[schema:1060]Duplicate column name 'regionName'",
"Workaround": ""
}
],
"detail": null
},
"unresolvedDDLLockID": "",
"sync": {
"totalEvents": "18713",
"totalTps": "148",
"recentTps": "0",
"masterBinlog": "(mysql-bin.000387, 292993160)",
"masterBinlogGtid": "2ae5ff08-749b-11ec-b0b8-043f72e4f03a:1-3128394,57830545-209f-11ea-94cf-b8599fb677d0:1-92594451",
"syncerBinlog": "(mysql-bin.000387, 175542732)",
"syncerBinlogGtid": "2ae5ff08-749b-11ec-b0b8-043f72e4f03a:1-3128394,57830545-209f-11ea-94cf-b8599fb677d0:1-92442922",
"blockingDDLs": [
],
"unresolvedGroups": [
],
"synced": false,
"binlogType": "remote",
"secondsBehindMaster": "0"
}
}
]
}
]
}
從RDS端匯出報錯的表：
# mysqldump -h xxxxx.rds.aliyuncs.com -u root -p'xxxxxx' --set-gtid-purged=OFF test_agent tesst_copy > tesst_copy.sql
TiDB端匯入
# mysql -uroot -p123456 -h 192.168.1.3 -P 4000 < tesst_copy.sql
跳過錯誤：
# tiup dmctl --master-addr 192.168.1.1:8261 handle-error test skip
tiup is checking updates for component dmctl ...
A new version of dmctl is available:
The latest version: v6.0.0
Local installed version: v5.4.0
Update current component: tiup update dmctl
Update all components: tiup update --all
Starting component `dmctl`: /root/.tiup/components/dmctl/v5.4.0/dmctl/dmctl /root/.tiup/components/dmctl/v5.4.0/dmctl/dmctl --master-addr 192.168.1.1:8261 handle-error test skip
{
"result": true,
"msg": "",
"sources": [
{
"result": true,
"msg": "",
"source": "mysql-replica-01",
"worker": "dm-192.168.1.1-8262"
}
]
}
再次檢視任務，已正常恢復同步:
# tiup dmctl --master-addr 192.168.1.1:8261 query-status test
tiup is checking updates for component dmctl ...
A new version of dmctl is available:
The latest version: v6.0.0
Local installed version: v5.4.0
Update current component: tiup update dmctl
Update all components: tiup update --all
Starting component `dmctl`: /root/.tiup/components/dmctl/v5.4.0/dmctl/dmctl /root/.tiup/components/dmctl/v5.4.0/dmctl/dmctl --master-addr 192.168.1.1:8261 query-status test
{
"result": true,
"msg": "",
"sources": [
{
"result": true,
"msg": "",
"sourceStatus": {
"source": "mysql-replica-01",
"worker": "dm-192.168.1.1-8262",
"result": null,
"relayStatus": null
},
"subTaskStatus": [
{
"name": "test",
"stage": "Running",
"unit": "Sync",
"result": null,
"unresolvedDDLLockID": "",
"sync": {
"totalEvents": "26165",
"totalTps": "694",
"recentTps": "0",
"masterBinlog": "(mysql-bin.000387, 294077175)",
"masterBinlogGtid": "2ae5ff08-749b-11ec-b0b8-043f72e4f03a:1-3128394,57830545-209f-11ea-94cf-b8599fb677d0:1-92594657",
"syncerBinlog": "(mysql-bin.000387, 175575178)",
"syncerBinlogGtid": "2ae5ff08-749b-11ec-b0b8-043f72e4f03a:1-3128394,57830545-209f-11ea-94cf-b8599fb677d0:1-92442942",
"blockingDDLs": [
],
"unresolvedGroups": [
],
"synced": false,
"binlogType": "remote",
"secondsBehindMaster": "240729"
}
}
]
}
]
}
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/15498/viewspace-2894379/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- tidb之dm叢集同步異常處理TiDB
- Mysql自動處理同步報錯MySql
- TIDB DM資料同步step by stepTiDB
- DM 是如何處理 DML 的丨TiDB 工具分享TiDB
- 線上MYSQL同步報錯故障處理總結MySql
- TIDB DM資料同步工具安裝部署TiDB
- 線上MYSQL同步報錯故障處理方法總結MySql
- oracle dataguard資料同步故障處理一例Oracle
- aix系統資料庫sqlplus登陸報錯處理一例AI資料庫SQL
- Extjs報錯處理JS
- DG報錯的處理
- errpt報錯處理
- OGG-00751錯誤處理一例
- Gulp壓縮報錯處理
- rails gem報錯的處理AI
- Javascript程式碼報錯處理JavaScript
- 各種報錯處理方法
- Redis4.0從庫複製報錯"master_link_status:down"處理一例RedisAST
- asm報錯一例-support 報錯rename failedASMAI
- OGG-01031錯誤處理一例
- DM 原始碼閱讀系列文章（三）資料同步處理單元介紹原始碼
- git review報錯一例GitView
- Too many open files報錯處理
- yum groupinstall報錯，處理方法
- ORA-02429 報錯處理
- mysql複製報錯案例處理MySql
- mysqlconnect bug 處理一例。MySql
- OGG 故障處理一例
- goldengate故障處理一例Go
- mysql,出現同步停止的錯誤的處理MySql
- Python 入門級報錯處理Python
- 批處理的聊天程式報錯求救！！！！！
- 【問題處理】Error accessing PRODUCT_USER_PROFILE錯誤一例Error
- ORA-04030處理一例
- ORA-00054 故障處理一例
- ORA-16038處理一例
- goldengate故障處理一例（續）Go
- database link故障處理一例Database