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

GAUSS-00881 -- GAUSS-00890

GAUSS-00881: "adding partition name conflict with existing partitions"

SQLSTATE: XX000

Description: In a relational table, new partitions and old partitions share the same names.

Solution: Set unique names for new partitions.

GAUSS-00882: "upper boundary of adding partition MUST overtop last existing partition"

SQLSTATE: XX000

Description: In a relational table, the upper boundary value of a new partition is smaller than that of the last partition.

Solution: Modify the upper boundary value of the new partition.

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

SQLSTATE: XX000

Description: The AccessExclusiveLock of the partition is not obtained.

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

GAUSS-00884: "Cannot drop the only partition of a partitioned table"

SQLSTATE: XX000

Description: When the statement on deleting partitions is executed, the last partition cannot be deleted from a relational table.

Solution: Cancel this operation.

GAUSS-00886: "no local index defined on partition %u"

SQLSTATE: XX000

Description: No local index is found in a partition.

Solution: Check whether the partition and index names to be queried exist. If they do not exist, cancel this query.

GAUSS-00887: "can not set unusable index for relation %s , as it is not a index"

SQLSTATE: XX000

Description: The index for setting a relational table is found invalid during index validity check.

Solution: Check validity of the index and use a valid index.

GAUSS-00888: "could not find tuple for relation %u"

SQLSTATE: XX000

Description: When ModifyRowMovement is executed, the tuple of a relational table cannot be obtained.

Solution: Check the tuple attribute of the relational table, or cancel this operation.

GAUSS-00889: "cannot truncate a partition owned by partitioned table which is referenced in a foreign key constraint"

SQLSTATE: XX000

Description: The statement on truncating partitions is run for a partitioned table referenced in a foreign key constraint.

Solution: Cancel the reference of the foreign key constraint, or cancel this operation.

GAUSS-00890: "can not merge index partition %s bacause it is unusable local index"

SQLSTATE: XX000

Description: The statement on merging index partitions is run for an unusable local index.

Solution: Ensure the local index is usable, or cancel this operation.