On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-02001 -- GAUSS-02100/ GAUSS-02031 -- GAUSS-02040

GAUSS-02031 -- GAUSS-02040

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

View PDF

GAUSS-02031: "must be system admin or replication role to use replication slots"

SQLSTATE: 42501

Description: Only system administrators or replication roles can create or delete replication slots.

Solution: Check whether the current operation role is correct. Theoretically, manually deleting or modifying replication slot is not allowed.

GAUSS-02032: "syntax error: unexpected character '%s'"

SQLSTATE: 42601

Description: A syntax error occurs. The character is unrecognizable.

Solution: Record error information. Contact technical support.

GAUSS-02033: "all replication slots are in use"

SQLSTATE: 53400

Description: All replication slots that have been configured are in use.

Solution: Adjust the max_replication_slots parameter in the postgresql.conf file under the instance directory.

GAUSS-02034: "replication slot '%s' does not exist"

SQLSTATE: 42704

Description: The replication slot does not exist.

Solution: If the replication slot is required, create one.

GAUSS-02035: "replication slot '%s' is already active"

SQLSTATE: 55006

Description: The replication slot has been activated.

Solution: Check whether the object in which the slot is activated is valid.

GAUSS-02036: "could not rename '%s' to '%s': %m"

SQLSTATE: XX000

Description: The instance slot directory cannot be renamed.

Solution: Resolve the problem based on concrete error codes.

GAUSS-02037: "replication slots can only be used if max_replication_slots > 0"

SQLSTATE: 55000

Description: The replication slots can be used only when the max_replication_slots parameter is configured.

Solution: Adjust the max_replication_slots parameter in the postgresql.conf file under the instance directory.

GAUSS-02038: "replication slots can only be used if wal_level >= archive"

SQLSTATE: 55000

Description: The replication slots are used when the wal_level parameter is configured below archive.

Solution: Adjust the wal_level as archive or hot_standby in the postgresql.conf file under the instance directory.

GAUSS-02039: "could not rename file '%s' to '%s': %m"

SQLSTATE: XX000

Description: The file cannot be renamed.

Solution: Resolve the problem based on concrete error codes.

GAUSS-02040: "could not unlink file '%s': %m"

SQLSTATE: XX000

Description: The file cannot be removed.

Solution: Resolve the problem based on concrete error codes.

Parent topic: GAUSS-02001 -- GAUSS-02100

Previous topic: GAUSS-02021 -- GAUSS-02030

Next topic: GAUSS-02041 -- GAUSS-02050

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