Help Center> GaussDB(DWS)> 8.2.0 and earlier versions> Data Warehouse Service Error Codes> GAUSS-02201 -- GAUSS-02300> GAUSS-02281 -- GAUSS-02290
Updated on 2023-12-22 GMT+08:00
View PDF

GAUSS-02281 -- GAUSS-02290

GAUSS-02281: "unrecognized mergejoin state: %d"

SQLSTATE: XX000

Description: An execution error occurs. The execution policy chosen by mergejoin is incorrect.

Solution: Internal system error. Contact technical support.

GAUSS-02282: "RIGHT JOIN is only supported with merge-joinable join conditions"

SQLSTATE: 0A000

Description: A plan error occurs. The merge right join condition is not supported.

Solution: Internal system error. Contact technical support.

GAUSS-02283: "FULL JOIN is only supported with merge-joinable join conditions"

SQLSTATE: 0A000

Description: The full join connection mode of the mergejoin algorithm can process only constant joinclauses.

Solution: Check whether the joinclauses of full join called by the SQL statement is a constant.

GAUSS-02284: "non-MVCC snapshots are not supported in index-only scans"

SQLSTATE: 0A000

Description: The index-only scan does not support MVCC snapshots.

Solution: Contact technical support.

GAUSS-02285: "EvalPlanQual recheck is not supported in index-only scans"

SQLSTATE: 0A000

Description: The index-only scan does not support recheck during concurrent update.

Solution: Contact technical support.

GAUSS-02286: "can'nt initialize index-only scans using unusable index '%s'"

SQLSTATE: XX000

Description: The index-only scan fails to be initialized because the index is unavailable.

Solution: Modify the index in the system catalog.

GAUSS-02287: "can'nt initialize index-only scans using unusable local index '%s'"

SQLSTATE: XX000

Description: The index-only scan fails to be initialized because the index is unavailable.

Solution: Modify the index in the system catalog.

GAUSS-02288: "could not find hash function for hash operator %u"

SQLSTATE: 42883

Description: The corresponding hash function cannot be found.

Solution: Check whether the data type supports hash.

GAUSS-02290: "cursor '%s' is held from a previous transaction"

SQLSTATE: 24000

Description: The cursor is held by the previous transaction.

Solution: Check the status of the cursor.