Incremental Synchronization Error: dn_: column contains null values

Scenarios

During incremental synchronization, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: table %s execute the ddl failed ERROR: dn_ %s_ %s: column ' %s' contains null values.

Possible Causes

The destination GaussDB(DWS) database has the NOT NULL constraint, so the default value needs to be set.

Solution

Modify the DDL statement and manually run it in the destination database. Then contact Huawei engineers to skip the synchronization of this DDL statement.

Parent topic: Real-Time Synchronization from MySQL to GaussDB(DWS)

Previous topic: Full or Incremental Phase Error: The binlog fetch connection may be interrupted

Next topic: Incremental Synchronization Error: source has more columns than target