Updated on 2025-03-26 GMT+08:00

GAUSS-00891 -- GAUSS-00900

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

SQLSTATE: XX000

Description: MergePartition cannot be performed because the number of raw partitions is less than 2.

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 unusable index relation \''%s\''"

SQLSTATE: XX000

Description: MergePartition cannot be performed because unavailable local indexes are detected.

Solution: Check the usability of local indexes. Run this statement only when local indexes are available.

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

SQLSTATE: XX000

Description: MergePartition cannot be performed because unavailable local indexes are detected.

Solution: Check the usability of local indexes. Run this statement only when local indexes are available.

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

SQLSTATE: XX000

Description: MergePartition cannot be performed because the raw partitions do not meet the necessary continuity and boundary value conditions in ascending order.

Solution: Run this statement only after ensuring that the raw partitions satisfy both the continuity and boundary increment requirements.

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

SQLSTATE: 42710

Description: MergePartition is not allowed because the target partition name 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: ExchangePartition cannot be run because 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 cannot be run because the table is not an ordinary table.

Solution: Run this statement only for ordinary tables.