Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking the Additional Column of the Destination Database
Updated on 2022-07-19 GMT+08:00

Checking the Additional Column of the Destination Database

MySQL to GaussDB(for MySQL) Synchronization

Table 1 Checking the additional column of the destination database

Check Item

Additional column check

Description

Check whether the additional column is added to the additional column list of the destination database. If no additional column is added, the incremental synchronization task fails.

Failure Cause and Handling Suggestion

Failure cause: Some columns are missing in the additional column processing table in the destination database.

Handling suggestion: Add the missing additional columns to the destination database tables. Reference statement:

ALTER TABLE ` database `.` table ` ADD COLUMN ` column_name ` column_definition;