Help Center/ Data Replication Service/ Real-Time Synchronization/ Task Management/ Task Life Cycle/ Skipping DDL Statements
Updated on 2024-09-25 GMT+08:00
View PDF
Share

Skipping DDL Statements

In a synchronization task, if the destination is a GaussDB(DWS) instance, DDL operations that are performed on the source database in the incremental synchronization phase will also be performed on the GaussDB(DWS) instance. If the destination GaussDB(DWS) instance does not support the DDL statement, the synchronization task becomes faulty.

To solve this problem, you can skip the DDL statement to continue the synchronization task after rectifying the fault based on the synchronization log information.

Procedure

  1. Contact GaussDB(DWS) technical support to execute this statement with the same semantics in the destination database and the statement must comply with the syntax of the destination database.
  2. On the Data Synchronization Management page, locate the task you want to skip and click Skip DDL in the Operation column.

    Figure 1 Skip DDL

  3. After confirming that statement was executed on the destination database, click Yes to skip the error and continue the synchronization task.
Parent topic: Task Life Cycle