Updated on 2023-01-17 GMT+08:00

Full Phase Error: failed to create new session

Scenarios

During a full migration or synchronization, an error is reported, and the log information is as follows: service DATAMOVE failed, cause by: com.continuent.tungsten.replicator.ReplicatorException: Unable to connect to DBMS: url=jdbc:mysql://*** user=***, Caused by: failed to create new session.

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 instance and the source or destination database is normal.
  3. Check whether the whitelist of the source or destination database allows access from the IP address of the DRS instance.