Help Center/ Data Replication Service/ Troubleshooting/ Failure Cases/ Real-Time Synchronization from PostgreSQL to PostgreSQL/ Full or Incremental Phase Error: temporary file size exceeds temp_file_limit
Updated on 2024-11-30 GMT+08:00
View PDF
Share

Full or Incremental Phase Error: temporary file size exceeds temp_file_limit

Scenarios

During a full or incremental synchronization, an error is reported, and the log information is as follows: retry structures failed events=the fail structures are [type=index, index=0, schema_name=fossbot, object_name=scan_mr5_file_union]reason:[ERROR: temporary file size exceeds temp_file_limit (20000000kB)]

Possible Causes

The size of the temporary table generated during SQL execution exceeds the upper limit of the temporary tablespace in the system.

Solution

  1. Increase the value of the temp_file_limit parameter in the destination database by referring to Modifying RDS for PostgreSQL Instance Parameters
  2. Restart the database to apply the change. Then, On the Data Synchronization Management page, locate the target task and click Resume in the Operation column. After the synchronization task is complete, change the value to the original value. Otherwise, the DB instance disk may be full due to large temporary tablespace.