Full Phase Error: Unknown collation: 'utf8mb4_0900_ai_ci'

Scenarios

During a full migration or synchronization, an error is reported, and the log information is as follows: retry structures failed events=the fail structures are [type=table_structure, index=0, schema_name=m825, object_name=t1]reason:[Unknown collation: 'utf8mb4_0900_ai_ci']

Possible Causes

The source database version is later than the destination database version, or the source database is of a special type and supports the utf8mb4_0900_ai_ci collation, but the destination MySQL database does not support this collation. The DRS task fails to synchronize the table structure because the destination database does not support the collation.

Solution

1. Manually create a table structure in the destination database and modify the collation rule.
2. Create a DRS task again, deselect the table structure for synchronization, and perform full synchronization again.