Updated on 2023-12-22 GMT+08:00

GAUSS-02031 -- GAUSS-02040

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.