Full Phase Error: Temporary file write failure.

Scenarios

During a full migration or synchronization, an error is reported, and the log information is as follows: service DATAMOVE failed, cause by: retry structures failed events=the fail structures are [type=constraint_data, index=0, schema_name= %s, object_name= %s]reason:[Temporary file write failure.]

Possible Causes

The temporary space of the destination database is insufficient when DRS migrates indexes.

Solution

1. Adjust the temporary space of the destination database.
   • If an RDS for MySQL instance is used, perform the following operations to adjust the temporary space:
     1. Scale up the space by referring to RDS for MySQL Performance Tuning.
     2. Check whether the temporary space increases.
        • If yes, go to 2.
        • If no, in the upper right corner of the management console, choose Service Tickets > Create Service Tickets and contact RDS customer service to adjust the temporary space of the destination database.
   • If an on-premises MySQL database or a MySQL database built on another cloud is used, contact database O&M engineers to check and adjust the destination database temporary space.

2. After the adjustment is complete, click Resume in the Operation column to resume the task.
3. If the fault persists, choose Service Tickets > Create Service Ticket in the upper right corner of the management console and contact DRS customer service.