On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-02201 -- GAUSS-02300/ GAUSS-02281 -- GAUSS-02290

GAUSS-02281 -- GAUSS-02290

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

View PDF

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.

Parent topic: GAUSS-02201 -- GAUSS-02300

Previous topic: GAUSS-02271 -- GAUSS-02280

Next topic: GAUSS-02291 -- GAUSS-02300

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