Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Objects/ Checking Whether the Index Length of the Source Database Exceeds the Limit
Updated on 2022-09-21 GMT+08:00

Checking Whether the Index Length of the Source Database Exceeds the Limit

Oracle -> MySQL/Oracle -> GaussDB(for MySQL) Migration and Synchronization

Table 1 Checking whether the index length of the source database exceeds the limit

Check Item

Whether the index length of the source database exceeds the limit

Description

The migration fails because the index length of the source database exceeds the column length limit of the destination database.

Failure Cause and Handling Suggestion

Failure cause: There are indexes in the source database exceed the column length limit of the destination database.

Handling suggestion: 1. Delete the tables from the migration object. 2. Modify the index length.

MySQL Migration, Synchronization, and Disaster Recovery

Table 2 Checking whether the index length of the source database exceeds the column length limit

Check Item

Whether the index length of the source database exceeds the limit

Description

The migration fails because the index length of the source database exceeds the column length limit of the destination database.

Failure Cause and Handling Suggestion

Failure cause: There are indexes in the source database exceed the column length limit of the destination database.

Handling suggestion: Set innodb_large_prefix of the destination database to ON, or return to the previous step and select the table to be migrated again.