之前通过dm新建过任务,从mysql导入tidb,后来tidb重新部署了一下,所有数据清空,再重启dm导入数据的时候报错:
{
“result”: false,
“msg”: “[code=26005:class=dm-master:scope=internal:level=medium], Message: fail to check synchronization configuration with type: check was failed, please see detail
detail: {
“results”: [
{
“id”: 7,
“name”: “table structure compatibility check”,
“desc”: “check compatibility of table structure”,
“state”: “fail”,
“errors”: [
{
“severity”: “warn”,
“short_error”: “table TPCD2G
.customer
Foreign Key customer_ibfk_1 is parsed but ignored by TiDB.”,
“instruction”: “please ref document: https://docs.pingcap.com/tidb/stable/mysql-compatibility#unsupported-features”
},
{
“severity”: “fail”,
“short_error”: “table TPCD2G
.dm_test
primary/unique key does not exist”,
“instruction”: “please set primary/unique key for the table”
},
{
“severity”: “warn”,
“short_error”: “table TPCD2G
.lineitem
Foreign Key lineitem_ibfk_1 is parsed but ignored by TiDB.”,
“instruction”: “please ref document: https://docs.pingcap.com/tidb/stable/mysql-compatibility#unsupported-features”
},
{
“severity”: “warn”,
“short_error”: “table TPCD2G
.lineitem
Foreign Key lineitem_ibfk_2 is parsed but ignored by TiDB.”,
“instruction”: “please ref document: https://docs.pingcap.com/tidb/stable/mysql-compatibility#unsupported-features”
},
{
“severity”: “warn”,
“short_error”: “table TPCD2G
.nation
Foreign Key nation_ibfk_1 is parsed but ignored by TiDB.”,
“instruction”: “please ref document: https://docs.pingcap.com/tidb/stable/mysql-compatibility#unsupported-features”
},
{
“severity”: “warn”,
“short_error”: “table TPCD2G
.orders
Foreign Key orders_ibfk_1 is parsed but ignored by TiDB.”,
“instruction”: “please ref document: https://docs.pingcap.com/tidb/stable/mysql-compatibility#unsupported-features”
},
{
“severity”: “warn”,
“short_error”: “table TPCD2G
.partsupp
Foreign Key partsupp_ibfk_1 is parsed but ignored by TiDB.”,
“instruction”: “please ref document: https://docs.pingcap.com/tidb/stable/mysql-compatibility#unsupported-features”
},
{
“severity”: “warn”,
“short_error”: “table TPCD2G
.partsupp
Foreign Key partsupp_ibfk_2 is parsed but ignored by TiDB.”,
“instruction”: “please ref document: https://docs.pingcap.com/tidb/stable/mysql-compatibility#unsupported-features”
},
{
“severity”: “warn”,
“short_error”: “table TPCD2G
.supplier
Foreign Key supplier_ibfk_1 is parsed but ignored by TiDB.”,
“instruction”: “please ref document: https://docs.pingcap.com/tidb/stable/mysql-compatibility#unsupported-features”
}
],
“extra”: “address of db instance - 10.5.63.101:3306”
}
],
“summary”: {
“passed”: false,
“total”: 8,
“successful”: 7,
“failed”: 1,
“warning”: 0
}
}”,
“sources”: [
]
}
找到问题了,好像是因为外建的表还没建立引起的。
此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。