Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking the Additional Column of the Destination Database

Checking the Additional Column of the Destination Database

Updated on 2022-09-21 GMT+08:00

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;

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback