Updated on 2023-12-22 GMT+08:00

GAUSS-04751 -- GAUSS-04760

GAUSS-04751: "could not write to partition staging temporary file while loading partition %s"

SQLSTATE: XX000

Description: The cache file fails to be created when the partition table is imported.

Solution: Check whether the number of current system files arrives the maximum value, and whether the current system has sufficient storage space to create the temporary files imported by the partitioning table.

GAUSS-04752: "error write temp file while loading partitioned DFS table, %lu bytes written but expected %lu"

SQLSTATE: XX000

Description: Failed to write to the cache file when the partition table is imported.

Solution: Check whether the number of current system files arrives the maximum value, and whether the current system has sufficient storage space to create the temporary files imported by the partitioning table.

GAUSS-04753: "could not rewind DFS Partition Loading temporary file: %m"

SQLSTATE: XX000

Description: The cache file fails to move the file cursor when the partitioning table is imported.

Solution: Check whether the temporary files are damaged.

GAUSS-04754: "error read staging temp file for partitioned table loading, expected:%u, actual read %lu"

SQLSTATE: XX000

Description: The cache file fails to move the file cursor when the partitioning table is imported.

Solution: Check whether the temporary files are damaged, that is, the file data written and read is inconsistent.

GAUSS-04755: "Only ORC is supported for now."

SQLSTATE: 0A000

Description: Internal system error. The HDFS table supports only the ORC format.

Solution: Contact technical support.

GAUSS-04756: "DfsStore: unrecognized heap_update status: %u"

SQLSTATE: XX000

Description: The deletion and update functions of the DESC table conflict with each other.

Solution: Contact technical support.

GAUSS-04757: "type '%s' is not supported in DFS ORC format column store"

SQLSTATE: 0A000

Description: The data type is not supported by the HDFS table.

Solution: Use other data types when creating the HDFS table.

GAUSS-04758: "Value '%s' of option 'compression' is invalid for row table"

SQLSTATE: 0A000

Description: The column-store table compression parameters are incorrectly specified.

Solution: Change the compression parameters to Yes or No.

GAUSS-04759: "Invalid string for 'filesystem' option."

SQLSTATE: 22023

Description: An error is reported because the value of the filesystem is incorrect when a tablespace is created.

Solution: Set filesystem to general or hdfs when creating a tablespace.

GAUSS-04760: "No cfgpath is specified for a DFS server."

SQLSTATE: XX000

Description: An error is reported because cfgpath is not specified when you create an HDFS table.

Solution: Specify cfgpath when creating the HDFS server.