Help Center> Data Replication Service> Troubleshooting> Failure Cases> Real-Time Synchronization from MySQL to GaussDB(DWS)> Incremental Synchronization Errors: Connection to *.*.*.98:8000 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections
Updated on 2023-01-17 GMT+08:00
View PDF

Incremental Synchronization Errors: Connection to *.*.*.98:8000 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections

Scenarios

During incremental synchronization, an error is reported, and the log information is as follows: 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

Possible Causes

The connection to the source or destination database fails to be established.

Solution

  1. Check whether the source or destination database is running properly.
  2. Check whether the network connection between the DRS replication instance and the source or destination database is normal.
  3. Check whether the IP address of the DRS instance is allowed to access the source or destination database.