On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-00501 -- GAUSS-00600/ GAUSS-00581 -- GAUSS-00590

GAUSS-00581 -- GAUSS-00590

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

View PDF

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.

Parent topic: GAUSS-00501 -- GAUSS-00600

Previous topic: GAUSS-00571 -- GAUSS-00580

Next topic: GAUSS-00591 -- GAUSS-00600

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