Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-00501 -- GAUSS-00600/ GAUSS-00511 -- GAUSS-00520
Updated on 2023-12-22 GMT+08:00
View PDF
Share

GAUSS-00511 -- GAUSS-00520

GAUSS-00511: "source database '%s' is being accessed by other users"

SQLSTATE: 55006

Description: The current accessed database is being accessed by other users.

Solution: Ensure that the currently accessed database is not being accessed by other users. If it is being accessed, the data is inconsistent. In this case, ensure that other accessed users log out of the database and attempt to log in to the database again.

GAUSS-00512: "encoding '%s' does not match locale '%s'"

SQLSTATE: 22023

Description: The character encoding specified by the currently created database does not match that obtained from a specified character type.

Solution: Ensure that the character encoding specified by the currently created database matches that obtained from a specified character type. If they are inconsistent, specify them to be the same when creating data again.

GAUSS-00513: "database '%s' does not exist"

SQLSTATE: 3D000

Description: When the DROP DATABASE syntax is used to delete a database, this database does not exist or is invalid.

Solution: Ensure that the deleted database is a valid one that has been created when the DROP DATABASE syntax is used to delete a database.

GAUSS-00514: "cannot drop a template database"

SQLSTATE: 42809

Description: Attempting to delete the template database template0 or template1 is an invalid operation.

Solution: Specify a database to be deleted again because the default template database template0 or template1 cannot be deleted.

GAUSS-00515: "cannot drop the currently open database"

SQLSTATE: 55006

Description: The database to be deleted is being accessed by other users and cannot be deleted.

Solution: Ensure that the database to be deleted is not being accessed by other users and instruct the users to log out of the database and then delete the database again.

GAUSS-00516: "cannot drop the default database"

SQLSTATE: 42809

Description: Attempting to delete the default database postgres is an invalid operation.

Solution: Do not delete the default database postgres and ensure that the operation is correct.

GAUSS-00517: "database '%s' is being accessed by other users"

SQLSTATE: 55006

Description: The database to be deleted is being accessed by other users.

Solution: Ensure that the database to be deleted is not being accessed by other users. If it is being accessed, the data is inconsistent. In this case, ensure that other accessed users log out of the database and attempt to delete the database again.

GAUSS-00518: "Deletion of sequences on database %s not completed"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00519: "permission denied to rename database"

SQLSTATE: 42501

Description: The current user does not have the permission to change the database name.

Solution: Ensure that the user who changes the database name is a database owner or an administrator user.

GAUSS-00520: "current database cannot be renamed"

SQLSTATE: 0A000

Description: Invalid operation: The name of a database in use cannot be changed.

Solution: Do not change the name of the database in use.