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

GAUSS-04401 -- GAUSS-04410

GAUSS-04401: "The local index %u on the partition %u not exist."

SQLSTATE: 42704

Description: When partitions and indexes are concurrently dropped, an index may be dropped with a partition and may not exist when drop index is executed.

Solution: Adjust concurrent operations.

GAUSS-04402: "Path can not include whitespace"

SQLSTATE: 22023

Description: The specified path cannot contain spaces.

Solution: Specify a path that does not contain spaces.

GAUSS-04403: "Can only access temp objects of the current session."

SQLSTATE: 0A000

Description: Temporary objects of other sessions are accessed.

Solution: Access only the temporary objects in the local session.

GAUSS-04404: "cache lookup failed for role %u"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-04405: "temp relation is invalid because of cluster resizing"

SQLSTATE: 0A000

Description: The original temporary table becomes invalid after capacity expansion or reduction.

Solution:

  1. Exit the current session, reconnect to the session, and create a temporary table.
  2. Use DROP SCHEMA %s and %s CASCADE to delete the temporary schema and recreate a temporary table.

GAUSS-04406: "internal relation doesn't allow DELETE"

SQLSTATE: XX000

Description: The internal table object cannot be deleted.

Solution: Modify the SQL statement.

GAUSS-04407: "Not allowed to insert into relation pg_auth_history."

SQLSTATE: XX000

Description: pg_auth_history is used to audit user name and password changes. Related changes are recorded only when the user name and password in pg_authid are changed. Any changes on the record will affect the auditing.

Solution: Do not use the INSERT INTO statement to insert records into pg_auth_history.

GAUSS-04408: "do not support create non-temp table like temp table"

SQLSTATE: 0A000

Description: When a common table is created, the like temporary table language is used. This method is not supported.

Solution: Do not use the like temporary table syntax to create a non-temporary table. If you want to use it, specify the to-be-created table as a temporary table.

GAUSS-04409: "Only the primary key, unique, not null and null will be supported."

SQLSTATE: 0A000

Description: Only the primary key, unique, not null, and null constraints can be created.

Solution: Create primary key, unique, not null, and null constraints first.

GAUSS-04410: "Only 'NOT ENFORCED' clause is supported for HDFS foreign table informational constraint."

SQLSTATE: 0A000

Description: Currently, HDFS foreign tables support only the NOT ENFORCED clause.

Solution: Add the not enforced attribute when a specified row is created for a foreign table.