Help Center/ GaussDB(DWS)/ Troubleshooting/ Data Import and Export/ Error Message "out of memory" Is Displayed When GDS Is Used to Import Data
Updated on 2024-03-08 GMT+08:00

Error Message "out of memory" Is Displayed When GDS Is Used to Import Data

Symptom

When GDS is used to import data, the error message "out of memory" is displayed during script execution.

Possible Causes

  1. When the COPY command is executed or data is imported, the size of a single row exceeds 1 GB.
  2. The source file format is incorrect. For example, the quotation marks are unpaired. As a result, the size of a single row identified by the system exceeds 1 GB.

Handling Procedure

  1. Ensure that the quotation marks in the source file appear in pairs.
  2. Check whether the parameter values and formats in the commands for creating a foreign table are proper.
  3. Check whether the size of the row in the error report exceeds 1 GB. If it does, manually adjust or delete the row.