On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-00801 -- GAUSS-00900/ GAUSS-00891 -- GAUSS-00900

GAUSS-00891 -- GAUSS-00900

Updated on 2024-03-15 GMT+08:00

View PDF

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.

Parent topic: GAUSS-00801 -- GAUSS-00900

Previous topic: GAUSS-00881 -- GAUSS-00890

Next topic: GAUSS-00901 -- GAUSS-01000

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel