On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-02701 -- GAUSS-02800/ GAUSS-02791 -- GAUSS-02800

GAUSS-02791 -- GAUSS-02800

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

View PDF

GAUSS-02791: "invalid snapshot data in file '%s'"

SQLSTATE: 22P02

Description: An internal error occurs. Failed to access the file.

Solution: Contact technical support. Alternatively, ensure that the data directory is not modified externally.

GAUSS-02792: "SET TRANSACTION SNAPSHOT must be called before any query"

SQLSTATE: 25001

Description: SET TRANSACTION SNAPSHOT must be executed as the first statement.

Solution: Check whether the SQL script contains other statements placed prior to SET TRANSACTION SNAPSHOT.

GAUSS-02793: "a snapshot-importing transaction must have isolation level SERIALIZABLE or REPEATABLE READ"

SQLSTATE: 0A000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-02794: "invalid snapshot identifier: '%s'"

SQLSTATE: 22023

Description: An internal error occurs. The snapshot flag is invalid.

Solution: Contact technical support.

GAUSS-02795: "could not stat file '%s': %m"

SQLSTATE: XX000

Description: The file status information cannot be obtained.

Solution: Check whether the file status is abnormal, for example, the file does not exist or you do not have the file read permission.

GAUSS-02796: "could not read file '%s': %m"

SQLSTATE: XX000

Description: A non-administrator user reads the file.

Solution: Read the file as a system administrator.

GAUSS-02797: "a serializable transaction cannot import a snapshot from a non-serializable transaction"

SQLSTATE: 0A000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-02798: "a non-read-only serializable transaction cannot import a snapshot from a read-only transaction"

SQLSTATE: 0A000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-02799: "cannot import a snapshot from a different database"

SQLSTATE: 0A000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-02800: "unrecognized weight: %d"

SQLSTATE: XX000

Description: The type of the second parameter in the tsvector_setweight function cannot be recognized.

Solution: The second parameter only supports the following letters: A, a, B, b, C, c, D, d

Parent topic: GAUSS-02701 -- GAUSS-02800

Previous topic: GAUSS-02781 -- GAUSS-02790

Next topic: GAUSS-02801 -- GAUSS-02900

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