Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Source Table Replication Attribute Is Correct
Updated on 2022-09-21 GMT+08:00

Checking Whether the Source Table Replication Attribute Is Correct

GaussDB(for openGauss)->GaussDB(for openGauss), GaussDB(for openGauss)->Kafka, PostgreSQL->PostgreSQL and PostgreSQL- >Kafka Synchronization

Table 1 Checking whether the source table replication attribute is correct

Check Item

Whether the source table replication attribute is correct

Description

The replica identity attribute of the source database table must be full.

Item to Be Confirmed and Handling Suggestion

Item to be confirmed: The selected source database table contains the primary key column, but the replication attribute is not FULL.

Handling suggestion: Change the replication attribute of the preceding tables to FULL. Run the following statement in the source database:

alter table table_name replica identity full;

Failure Cause and Handling Suggestion

Failure cause: The source database contains tables whose replication attribute is not Full. As a result, incremental synchronization may fail.

Handling suggestion: Change the replication attribute of the table to FULL. Run the following statement in the source database:

alter table table_name replica identity full;