Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Destination DB Instance Statuses/ Checking Whether There Are Enabled Triggers in an Existing Destination Database Table
Updated on 2025-02-17 GMT+08:00
View PDF
Share

Checking Whether There Are Enabled Triggers in an Existing Destination Database Table

GaussDB Serving as the Destination in Synchronization

Table 1 Checking whether there are enabled triggers in an existing destination database table

Check Item

Checking whether there are enabled triggers in an existing destination database table

Description

An existing table in the destination database contains valid triggers, which may cause data synchronization task failures.

Failure Cause and Handling Suggestion

Failure Cause: An existing table in the destination database contains valid triggers, which may cause data synchronization task failures.

Handling Suggestion: Use either of the following methods:

1. Disable triggers.

alter table table_name disable trigger all;

2. Set the session parameter.

set session_replication_role to replica;