GAUSS-01111 -- GAUSS-01120

GAUSS-01111: “cannot cluster on invalid index '%s'”

SQLSTATE: 0A000

Description: The specified indexes are invalid and remain after CREATE INDEX CONCURRENTLY failed to be run.

Solution: Do not cluster invalid indexes.

GAUSS-01112: “cannot cluster on invalid index %u”

SQLSTATE: XX000

Description: Invalid index.

Solution: The system catalog is abnormal. Contact technical support.

GAUSS-01113: “CLUSTER does not support lossy index conditions”

SQLSTATE: XX000

Description: Lossy index conditions cannot be used during CLUSTER execution.

Solution: Do not use hash and gist indexes.

GAUSS-01114: “unexpected HeapTupleSatisfiesVacuum result”

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01115: “can not cluster partition %s using %s bacause of unusable local index”

SQLSTATE: XX000

Description: The clustered partitioned table cannot use the local index, because it is unavailable.

Solution: Rebuild the partitioned table.

GAUSS-01117: “cannot swap mapped relation '%s' with non-mapped relation”

SQLSTATE: XX000

Description: During scale-out and redistribution, the physical files of two tables fail to be exchanged using the gs_switch_relfilenode function, because the physical file in a table is invalid.

Solution: Check whether the physical file in the table specified in the gs_switch_relfilenode function is valid. If it is invalid, delete the table and rebuild the table using CREATE TABLE. Then, rebuild its physical file.

GAUSS-01118: “cannot change tablespace of mapped relation '%s'”

SQLSTATE: XX000

Description: During scale-out and redistribution, the tablespaces of two tables are inconsistent and fail to be exchanged using the gs_switch_relfilenode function.

Solution: Delete the current table, rebuild tablespace using CREATE TABLESPACE, and rebuild the table using CREATE TABLE.

GAUSS-01119: “cannot swap toast by links for mapped relation '%s'”

SQLSTATE: XX000

Description: During scale-out and redistribution, the physical files of two tables fail to be exchanged using the gs_switch_relfilenode function, because the toast table in one of the tables is empty.

Solution: Delete the current table, rebuild it using CREATE TABLE, and rebuild its physical file.

GAUSS-01120: “could not find relation mapping for relation '%s', OID %u”

SQLSTATE: XX000

Description: During scale-out, the physical files of two tables fail to be exchanged using the gs_switch_relfilenode function, because the physical file in a table is invalid.

Solution: Check whether the physical file in the table specified in the gs_switch_relfilenode function is valid. If it is invalid, delete the table and rebuild the table using CREATE TABLE. Then, rebuild its physical file.

Feedback
编组 3备份
    openGauss 2024-05-06 00:44:54
    cancel