dm 如何删除数据源？使worker进程变成free状态

[rona]

为提高效率，请提供以下信息，问题描述清晰能够更快得到解决：

【TiDB 版本】v5.0 dm 2.0

【问题描述】

[root@ip-192-168-0-186 soft]# tiup dmctl --master-addr 192.168.0.186:8261 operate-source show
Starting component dmctl: /root/.tiup/components/dmctl/v2.0.2/dmctl/dmctl --master-addr 192.168.0.186:8261 operate-source show
{
“result”: true,
“msg”: “”,
“sources”: [
{
“result”: true,
“msg”: “source is added but there is no free worker to bound”,
“source”: “mysql-replica-ylboss”,
“worker”: “”
},
{
“result”: true,
“msg”: “”,
“source”: “mysql-replica-k2boss”,
“worker”: “dm-192.168.0.186-8262”
}
]
}

dm系统里面有两个数据源，现在想清空里面的信息，重新添加新的数据源，避免worker提示bound的错误问题，请问该如何操作？

[root@ip-192-168-0-186 soft]# tiup dmctl --master-addr 192.168.0.186:8261 operate-source stop ./source-mysql-k2boss.yaml
Starting component dmctl: /root/.tiup/components/dmctl/v2.0.2/dmctl/dmctl --master-addr 192.168.0.186:8261 operate-source stop ./source-mysql-k2boss.yaml
{
“result”: false,
“msg”: “[code=10001:class=database:scope=not-set:level=high], Message: database driver error, RawCause: dial tcp 52.71.211.165:3306: connect: connection timed out, Workaround: Please check the database connection and the database config in configuration file.”,
“sources”: [
]
}

尝试这样操作报错

[HHHHHHULK (好好学习，天天向上)]

可以把 source.yaml 配置文件里不需要的数据源停掉。

tiup dmctl --master-addr XXX.XXX.XXX.XXX:8261 operate-source stop source.yaml

[rona]

原来的mysql源服务器没有了，导致操作提示连不上服务器，有其它办法能强制删除吗

[root@ip-192-168-0-186 data]# tiup dmctl --master-addr 192.168.0.186:8261 operate-source stop /data/soft/source-mysql-k2boss.yaml
Starting component dmctl: /root/.tiup/components/dmctl/v2.0.2/dmctl/dmctl --master-addr 192.168.0.186:8261 operate-source stop /data/soft/source-mysql-k2boss.yaml
{
“result”: false,
“msg”: “[code=10001:class=database:scope=not-set:level=high], Message: database driver error, RawCause: dial tcp 52.71.211.165:3306: connect: connection timed out, Workaround: Please check the database connection and the database config in configuration file.”,
“sources”: [
]
}

[lance6716]

感谢反馈，这个问题会在这几天的 2.0.3 修复 https://github.com/pingcap/dm/issues/1561

[rona]

大约需要几天？ 除了更新版本之外，有临时的解决办法吗

[rona]

我们有个项目想尽快迁移到tidb集群里面

[yilong (yi888long)]

目前没什么办法，或者就是删除重建了。 应该这两天就能发布新版本。

[rona]

好吧，我们再等两天

[yilong (yi888long)]

抱歉，感谢

[yilong (yi888long)]

您好，DM 2.0.3 已经发布，多谢。

[rona]

好的，我测试下，辛苦了

[rona]

测试，现在能清除数据源信息了，非常感谢

[yilong (yi888long)]