Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-01401 -- GAUSS-01500/ GAUSS-01421 -- GAUSS-01430
Updated on 2025-03-26 GMT+08:00
View PDF
Share

GAUSS-01421 -- GAUSS-01430

GAUSS-01421: "could not obtain lock on relation '%s'"

SQLSTATE: 55P03

Description: The statement is LOCK TABLE NOWAIT. The table cannot obtain the lock.

Solution: Modify the statement as LOCK TABLE.

GAUSS-01422: "cache lookup failed for access method %u"

SQLSTATE: 22P06

Description: Internal system error.

Solution:contact technical support

GAUSS-01423: "operator family '%s' does not exist for access method '%s'"

SQLSTATE: 42704

Description: During ALTER OPERATOR FAMILY execution, the access method for the specified OPERATOR FAMILY does not exist.

Solution: View the existing OPERATOR FAMILY and ensure that the access method in the failed ALTER OPERATOR FAMILY statement matches the specified OPERATOR FAMILY.

GAUSS-01424: "operator family '%s' for access method '%s' already exists"

SQLSTATE: 42710

Description: During CREATE OPERATOR FAMILY execution, the OPERATOR FAMILY already exists.

Solution: Ensure that the name of the OPERATOR FAMILY to be created is unique.

GAUSS-01425: "must be system admin to create an operator class"

SQLSTATE: 42501

Description: A non-administrator user executes the CREATE OPERATOR FAMILY statement.

Solution: Execute the CREATE OPERATOR FAMILY statement as a system administrator.

GAUSS-01426: "invalid operator number %d, must be between 1 and %d"

SQLSTATE: 42P17

Description: The strategy_number parameter of the OPERATOR clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement is less than 1, or is greater than the maximum value of strategy_number in index_method.

Solution: Ensure that the strategy_number parameter of the OPERATOR clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement ranges from 1 to the maximum value of strategy_number in index_method.

GAUSS-01427: "invalid procedure number %d, must be between 1 and %d"

SQLSTATE: 42P17

Description: The support_number parameter of the FUNCTION clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement is less than 1, or is greater than the maximum value of support_number in index_method.

Solution: Ensure that the support_number parameter of the FUNCTION clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement ranges from 1 to the maximum value of support_number in index_method.

GAUSS-01428: "storage type specified more than once"

SQLSTATE: 42P17

Description: The CREATE OPERATOR CLASS statement contains multiple STORAGE clauses that are the same.

Solution: Ensure that STORAGE clauses contained in CREATE OPERATOR CLASS are different.

GAUSS-01429: "unrecognized item type: %d"

SQLSTATE: XX000

Description: The system does not support custom operators.

Solution: Do not create custom operators using the CREATE OPERATOR syntax.

GAUSS-01430: "storage type cannot be different from data type for access method '%s'"

SQLSTATE: 42P17

Description: The column_type does not match the storage_type defined in the STORAGE clause of the CREATE OPERATOR CLASS statement. However, the access_method requires them to be the same.

Solution: Ensure that the storage_type specified by the STORAGE clause of the CREATE OPERATOR CLASS statement is the same as the column_type of the access_method.