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

GAUSS-00891 -- GAUSS-00900

GAUSS-00891: "source partitions must be at least two partitions"

SQLSTATE: XX000

Description: When MergePartition is run, the number of raw partitions of a table is less than two.

Solution: Check the number of raw partitions of the table. Run this statement when the number of raw partitions is greater than or equal to two.

GAUSS-00892: "merge partitions of relation '%s', source partitions must be no more than %d partitions"

SQLSTATE: XX000

Description: The number of partitions to be combined exceeds the maximum.

Solution: Reduce the partitions to be combined.

GAUSS-00893: "merge partitions cannot process inusable index relation \''%s\''"

SQLSTATE: XX000

Description: When MergePartition is run for a table, the table contains an unusable local index.

Solution: Check the usability of local indexes. Run this statement when the table contains usable local indexes.

GAUSS-00894: "cann't merge partition bacause partition %s has unusable local index"

SQLSTATE: XX000

Description: When MergePartition is run for a table, the table contains an unusable local index.

Solution: Check the usability of local indexes. Run this statement when the table contains usable local indexes.

GAUSS-00895: "source partitions must be continuous and in ascending order of boundary"

SQLSTATE: XX000

Description: When MergePartition is run, raw partitions do not meet the requirements on continuity and boundary values listed in ascending order.

Solution: Run this statement when raw partitions meet the requirements.

GAUSS-00896: "target partition's name '%s' already exists"

SQLSTATE: 42710

Description: When MergePartition is run, the name of a target partition already exists.

Solution: Ensure the name of the target partition is unique.

GAUSS-00897: "could not acquire AccessExclusiveLock on dest index partition '%s', MERGE PARTITIONS failed"

SQLSTATE: XX000

Description: The AccessExclusiveLock of the partition is not obtained during partition merging.

Solution: This problem may be caused by concurrency conflicts. Try again later.

GAUSS-00898: "could not acquire AccessExclusiveLock on dest table partition '%s', MERGE PARTITIONS failed"

SQLSTATE: XX000

Description: Failed to obtain the exclusive lock of combined partitions.

Solution: Ensure no other operation is performed on the combined partitions.

GAUSS-00899: "Specified partition does not exist"

SQLSTATE: 42P01

Description: When ExchangePartition is run, the specified partition does not exist.

Solution: Run this statement after confirming the name of the specified partition.

GAUSS-00900: "ALTER TABLE EXCHANGE requires an ordinary table"

SQLSTATE: 0A000

Description: ALTER TABLE EXCHANGE is run for a non-ordinary table.

Solution: Run this statement only for ordinary tables.