Updated on 2023-11-30 GMT+08:00

Checking Whether Tables Structures Are Consistent

MySQL -> CSS/ES Synchronization

Table 1 Checking whether tables structures are consistent

Check Item

Whether tables structures are consistent

Description

Check whether the table structures at the source end and destination are consistent.

Failure Cause and Handling Suggestion

Failure cause: The source table columns are not a subset of the destination indexes.

Handling suggestion: Return to the Set Synchronization Task page, select the tables that meet the requirements. Alternatively, create indexes required in the destination table.

Statement for querying the destination database:

GET /<index>/_mapping?include_type_name

MySQL -> GaussDB(DWS) Synchronization

Table 2 Checking whether tables structures are consistent

Check Item

Whether tables structures are consistent

Description

Check whether the table structures at the source end and destination are consistent.

Failure Cause and Handling Suggestion

Failure cause: The destination table does not contain all columns of the source table or the not-null constraints of the columns are inconsistent.

The possible causes are as follows:

  1. The number of columns in the destination table is less than that in the source table.
  2. If the source and destination databases are different, the column names in the source table are converted to lowercase letters for comparison with those in the destination table.
  3. Column names contain spaces or special characters.

Handling suggestion: Return to the Set Synchronization Task page, select the tables that meet the requirements. Alternatively, modify columns required in the destination table. Ensure that the source table columns are a subset of the destination columns.