Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-04701 -- GAUSS-04800/ GAUSS-04771 -- GAUSS-04780
Updated on 2023-12-22 GMT+08:00
View PDF
Share

GAUSS-04771 -- GAUSS-04780

GAUSS-04771: "Snapshot too old."

SQLSTATE: XX000

Description: The queried snap is the old snap.

Solution: Try again.

GAUSS-04772: "Load CU failed in adio! spcNode(%u), dbNode(%u), relNode(%u), columnId(%d), cuid(%u)"

SQLSTATE: XX000

Description: The column-store data file failed to be read.

Solution: Ensure that the data file status is normal. If it is abnormal, restore the data from the standby server or the backup data.

GAUSS-04773: "Prefetch the CU data(%u) file of column(%d) of relation id(%s) contains incorrect checksum"

SQLSTATE: XX000

Description: The CRC verification fails and the data file is damaged.

Solution: Restore the cluster data file from the standby server or the backup data.

GAUSS-04774: "Sync load the CU data(%u) file of column(%d) of relation(%s) contains incorrect checksum"

SQLSTATE: XX000

Description: The CRC verification fails and the data file is damaged.

Solution: Restore the cluster data file from the standby server or the backup data.

GAUSS-04776: "The relation '%s' has no distribute type."

SQLSTATE: 0A000

Description: The queried table has no distribution type, for example, query the desc table on the CN.

Solution: This type of table can be queried only on the DN.

GAUSS-04777: "This operation is not supported"

SQLSTATE: XX000

Description: The enable_cluster_resize parameter of the guc is set to true, and the current DML operation subplan is not matched on the CN.

Solution: Set enable_cluster_resize to false when the subplan of the DML operation is executed only on the CN.

GAUSS-04778: "cache lookup failed for relation %u."

SQLSTATE: 42P01

Description: The table fails to be found in the cache.

Solution: Internal system error. Contact technical support.

GAUSS-04779: "Upper-level GROUPING found where not expected"

SQLSTATE: XX000

Description: The upper-layer grouping cannot exist in the subplan.

Solution: Rewrite the SQL statements which have the same meanings.

GAUSS-04780: "GROUPING found where not expected"

SQLSTATE: XX000

Description: grouping cannot be found in the where statement.

Solution: Modify the SQL statement.