Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-04301 -- GAUSS-04400/ GAUSS-04351 -- GAUSS-04360
Updated on 2023-12-22 GMT+08:00
View PDF
Share

GAUSS-04351 -- GAUSS-04360

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.