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

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 parameter strategy_number of the OPERATOR clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement is less than 1, or is greater than strategy_number of the parameter index_method.

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

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

SQLSTATE: 42P17

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

Solution: Ensure that the parameter support_number of the FUNCTION clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement ranges from 1 to support_number of the parameter 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 the CREATE OPERATOR CLASS are different.

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

SQLSTATE: XX000

Description: The system does not support customized operators.

Solution: Do not create customized 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 differs from the storage_type specified by the STORAGE clause of the CREATE OPERATOR CLASS statement. However, the access_method requires that the two should 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.