On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-04301 -- GAUSS-04400/ GAUSS-04351 -- GAUSS-04360

GAUSS-04351 -- GAUSS-04360

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

View PDF

GAUSS-04351: "IGNORE_EXTRA_DATA only available on READ ONLY foreign table"

SQLSTATE: 42601

Description: IGNORE_EXTRA_DATA is used in OPTIONS when creating an external editable table.

Solution: Do not use IGNORE_EXTRA_DATA for OPTIONS.

GAUSS-04352: "Permission denied to drop resource pools."

SQLSTATE: 42501

Description: Common users are not allowed to delete resource pool objects.

Solution: Only system users can delete resource pools. Common users do not have the permission to delete resource pools.

GAUSS-04354: "ON COMMIT only support PRESERVE ROWS option"

SQLSTATE: 42P16

Description: The ON COMMIT DELETE ROWS or ON COMMIT DROP option is specified when creating a temporary table. The current version does not support the two options.

Solution: The current version does not support the two options. Delete them.

GAUSS-04355: "internal error, rename partitioned table failed"

SQLSTATE: XX000

Description: Failed to rename the partitioned table.

Solution: Ensure that the table_name and new_table_name are correctly specified in the ALTER TABLE [ IF EXISTS ] table_name RENAME TO new_table_name; syntax.

GAUSS-04356: "internal error, rename partition failed"

SQLSTATE: XX000

Description: Failed to rename the table partition.

Solution: Verify that partition_name and partition_new_name in the ALTER TABLE..RENAME PARTITION partition_name TO partition_new_name; syntax does not indicate an existing partition.

GAUSS-04357: "internal error, rename partition index failed"

SQLSTATE: XX000

Description: Failed to rename the partition index.

Solution: Ensure that the partition index specified in the ALTER INDEX [ IF EXISTS ] index_name RENAME PARTITION partition_name TO new_partition_name syntax exists.

GAUSS-04358: "statistics percent valid value is between 0 and 100"

SQLSTATE: 22023

Description: The set percentage value does not range from 0 to 100.

Solution: Set the percentage to a value ranging from 0 to 100.

GAUSS-04359: "PSort %u should depend on only one index relation but not %lu"

SQLSTATE: XX000

Description: The dependency of the column-store index is incorrect.

Solution: Contact technical support.

GAUSS-04360: "Partition cache lookup failed for index partition %u"

SQLSTATE: XX000

Description: The cache data is refreshed instantaneously, and the partition index fails to be queried.

Solution: Perform the operation again.

Parent topic: GAUSS-04301 -- GAUSS-04400

Previous topic: GAUSS-04341 -- GAUSS-04350

Next topic: GAUSS-04361 -- GAUSS-04370

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