On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-04701 -- GAUSS-04800/ GAUSS-04771 -- GAUSS-04780

GAUSS-04771 -- GAUSS-04780

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

View PDF

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.

Parent topic: GAUSS-04701 -- GAUSS-04800

Previous topic: GAUSS-04761 -- GAUSS-04770

Next topic: GAUSS-04781 -- GAUSS-04790

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