增量同步失败报错，关键词“Connection to *.*.*.98:8000 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections”

场景描述

增量同步期间DRS任务报错，同步日志界面提示：service INCREMENT failed, cause by: Unable to connect to DBMS: url=jdbc:dws://*.*.*.115:8000,*.*.*.98:8000,*.*.*.133:8000/tanzhou_prod?client_encoding=UTF-8&loadBalanceHosts=true&targetServerType=any&reWriteBatchedInserts=true&socketTimeout=600&connectTimeout=300&binaryTransfer=true&ssl=false&sslmode=prefer user=dbadmin, Caused by: Connection to *.*.*.98:8000 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections

可能原因

访问源库或目标库时建立连接失败。

解决方案

1. 检查源库或目标库运行状态是否正常。
2. 检查DRS迁移实例和源库或目标库之间的网络是否能够连通。
3. 检查源库或目标库远程访问或者访问白名单是否对DRS实例的IP放通。