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-12-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:

1. Disable triggers.

alter table table_name disable trigger all;

2. After the synchronization is complete, enable the triggers.

alter table table_name enable trigger all;