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

GAUSS-00581 -- GAUSS-00590

GAUSS-00581: "role name '%s' is reserved"

SQLSTATE: 42939

Description: A user name is a reserved keyword.

Solution: Ensure that the user name is not the reserved keyword, for example, public or none.

GAUSS-00582: "role '%s' already exists"

SQLSTATE: 42710

Description: The user to be created already exists.

Solution: Use a new user name.

GAUSS-00583: "Failed to Generate the random number"

SQLSTATE: XX000

Description: The random number cannot be generated.

Solution: Contact technical support.

GAUSS-00584: "The password does not satisfy the complexity requirement"

SQLSTATE: XX000

Description: The password does not meet the complexity requirements.

Solution: Ensure the password: 1. Differs from the user name. 2. Contains at least three of the following four character types: uppercase letters, lowercase letters, digits, and special characters, including: ~!@#$%^&*()-_=+\|[{}];:,<.>/?. If you use characters other than the four types, a warning is displayed and you can modify the password. 3. Contains at least eight characters. This is the default length.

GAUSS-00585: "password md5 encryption failed"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00586: "password sha256 encryption failed"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00587: "Password_encryption_type is not 0, 1, 2"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00588: "The password could not be NULL."

SQLSTATE: XX000

Description: The password is empty.

Solution: Ensure that the password is not empty.

GAUSS-00589: "unacceptable user name: fail to create same name schema for user '%s'"

SQLSTATE: 42939

Description: If the name of a user is invalid, a schema with the same name as the user cannot be created.

Solution: Ensure that the user name does not start with pg_ which is used to name system modes.

GAUSS-00590: "the relation pg_user_status is invalid"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.