Incremental Synchronization Error: Table *** not found in target database

Scenarios

During incremental synchronization, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: Check table structure consistency fail! Table %s not found in target database

Possible Causes

• The filter conditions of DDL statements for creating tables in the source database are not synchronized to the destination database.
• As a result, tables are deleted from the destination database.
• Some DDL statements (such as rename) are filtered out during online DDL.

Solution

• For the first two causes, create a table in the destination database based on the table structure in the source database.
• If some DDLs are filtered out, rename the temporary table to the correct table name in the destination database.