MogDB
Ecological Tools
Doc Menu

GAUSS-01801 – GAUSS-01900


GAUSS-01801 – GAUSS-01810


GAUSS-01801: "cannot drop objects owned by %s because they are required by the database system"

SQLSTATE: 2BP01

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01802: "unexpected dependency type"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01803: "cannot reassign ownership of objects owned by %s because they are required by the database system"

SQLSTATE: 2BP01

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01804: "unexpected shared pin"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01805: "unexpected classid %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01806: "smgr_redo: unknown op code %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-01811 – GAUSS-01820


GAUSS-01811: "could not access file '%s': %m"

SQLSTATE: XX000

Description: The dynamic library file must be copied to another physical node but fails to be found.

Solution: Check whether the dynamic library file exists and whether its address and link are correct.

GAUSS-01815: "The name of dynamic library is too long"

SQLSTATE: 42622

Description: The dynamic library name is too long.

Solution: Ensure that the name length does not exceed 1000 characters.

GAUSS-01816: "allParameterTypes is not a 1-D Oid array"

SQLSTATE: XX000

Description: Invalid input parameter. An exception occurs when the procedure is created.

Solution: Ensure that the input parameter allParameterTypes is valid.

GAUSS-01817: "parameterModes is not a 1-D char array"

SQLSTATE: XX000

Description: Invalid input parameter. An exception occurs when the procedure is created.

Solution: Ensure that the input parameter parameterModes is valid.

GAUSS-01818: "cannot determine result data type"

SQLSTATE: 42P13

Description: The result data type cannot be determined because no parameter input exists.

Solution: Check and correct the parameter input type.

GAUSS-01819: "unsafe use of pseudo-type 'internal'"

SQLSTATE: 42P13

Description: The internal return type may be unavailable because no internal parameter exists.

Solution: Ensure that the internal parameter exists.

GAUSS-01820: "'%s' is already an attribute of type %s"

SQLSTATE: 42701

Description: The composite type name and the attribute type are the same during function creation.

Solution: Ensure that any name used during function creation is different from existing attribute names.


GAUSS-01821 – GAUSS-01830


GAUSS-01821: "variadic parameter must be last"

SQLSTATE: XX000

Description: When a procedure is created, the variadic parameter is abnormal.

Solution: Ensure that only the last parameter is a variadic parameter.

GAUSS-01822: "variadic parameter is not an array"

SQLSTATE: XX000

Description: When a procedure is created, the variadic parameter is not an array.

Solution: Ensure that the variadic parameter is normal.

GAUSS-01823: "invalid parameter mode '%c'"

SQLSTATE: XX000

Description: When a procedure is created, the proargmode parameter is invalid.

Solution: Ensure that the proargmode parameter is normal.

GAUSS-01824: "more than one function '%s' already exist, please drop function first"

SQLSTATE: 42723

Description: A duplicate function name already exists.

Solution: Ensure that a new function is given a different name from that of any other function in the schema.

GAUSS-01825: "function '%s' already exists with same argument types"

SQLSTATE: 42723

Description: A duplicate function name already exists, and parameters of the function being created are the same as those of the original function.

Solution: Ensure that the function is new.

GAUSS-01826: "cannot change return type of existing function"

SQLSTATE: 42P13

Description: The return type of an existing function cannot be changed.

Solution: Change the return type of a new function or drop the existing function.

GAUSS-01827: "cannot change name of input parameter '%s'"

SQLSTATE: 42P13

Description: The type of input parameter cannot be changed during function creation.

Solution: Check whether the function parameter is changed and drop the existing function.

GAUSS-01828: "function '%s' is an aggregate function"

SQLSTATE: 42809

Description: Internal error. The function being created is an aggregate function whose status cannot be changed.

Solution:Contact technical support.

GAUSS-01829: "function '%s' is not an aggregate function"

SQLSTATE: 42809

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01830: "function '%s' is a window function"

SQLSTATE: 42809

Description: The function being created is a window function whose status cannot be changed.

Solution:Contact technical support.


GAUSS-01831 – GAUSS-01840


GAUSS-01831: "function '%s' is not a window function"

SQLSTATE: 42809

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01832: "null prosrc"

SQLSTATE: XX005

Description: Failed to obtain a customized function.

Solution: Ensure that the function name is correct.

GAUSS-01833: "there is no built-in function named '%s'"

SQLSTATE: 42883

Description: No built-in function is found based on the function name provided.

Solution: Check whether the pg_proc table contains the corresponding function name.

GAUSS-01834: "null prosrc for C function %u"

SQLSTATE: XX005

Description: Failed to obtain a customized C function.

Solution: Ensure that the function name is correct.

GAUSS-01835: "null probin for C function %u"

SQLSTATE: XX005

Description: Failed to obtain a built-in C function.

Solution: Ensure that the function name is correct.

GAUSS-01836: "SQL functions cannot return type %s"

SQLSTATE: 42P13

Description: SQL functions cannot return format_type_be(proc->prorettype) data.

Solution: Check the SQL statement.

GAUSS-01837: "SQL functions cannot have arguments of type %s"

SQLSTATE: 42P13

Description: The types of parameters cannot be format_type_be(proc->proargtypes.values[i]).

Solution: Check the types of parameters in SQL functions.

GAUSS-01838: "In XC, SQL functions cannot contain utility statements"

SQLSTATE: 42601

Description: SQL functions cannot contain utility statements.

Solution: Check the content in SQL functions.

GAUSS-01840: "no conversion name supplied"

SQLSTATE: XX000

Description: While a conversion is created, the conversion name is not provided.

Solution: Ensure that the conversion name is not empty.


GAUSS-01841 – GAUSS-01850


GAUSS-01841: "conversion '%s' already exists"

SQLSTATE: 42710

Description: A conversion named conname already exists.

Solution: Ensure that the conversion name is unique.

GAUSS-01842: "default conversion for %s to %s already exists"

SQLSTATE: 42710

Description: A conversion from conforencoding to contoencoding already exists.

Solution: Do not create a conversion with the same function.

GAUSS-01843: "could not find tuple for conversion %u"

SQLSTATE: XX000

Description: Failed to find the tuple to be deleted from pg_conversion.

Solution: Ensure that the tuple OID is correct.

GAUSS-01844: "pgxc class relid invalid."

SQLSTATE: XX000

Description:relid is invalid while pgxc_class is created.

Solution: Ensure that relid is valid.

GAUSS-01845: "pgxc_group should have at least one default node group"

SQLSTATE: XX000

Description:pgxc_group is null.

Solution: Ensure that the pgxc_group status is normal while pgxc_class is created.

GAUSS-01847: "could not obtain lock on partition '%s'"

SQLSTATE: 55P03

Description: Locks cannot be obtained for the current partition.

Solution: Check whether the resource utilization and the current partition status are normal.

GAUSS-01848: "partition '%s' does not exist"

SQLSTATE: 42P01

Description: A partition named partitionName does not exist.

Solution: Ensure that the partition name corresponding to the table is correct.

GAUSS-01849: "the object with oid %u is not a partitioned object"

SQLSTATE: 42P17

Description: The current object is not a partitioned object.

Solution: Check the object attribute or check whether it needs to be partitioned as required.

GAUSS-01850: "object with oid %u is not a partition object"

SQLSTATE: 42704

Description: The current object is not a partitioned object.

Solution: Check the object attribute or check whether it needs to be partitioned as required.


GAUSS-01851 – GAUSS-01860


GAUSS-01851: "invalid input parameters when searching for local index under some index"

SQLSTATE: 42704

Description: Input parameters are invalid when index OIDs are checked.

Solution: Ensure that input parameters are valid.

GAUSS-01852: "%u is not a partitioned index"

SQLSTATE: 42704

Description: The object corresponding to the parameter OID is not a partitioned index.

Solution: Search the system catalog to check whether the attribute of the parameter introduced during execution process is correct.

GAUSS-01853: "%u not found in pg_class"

SQLSTATE: 42704

Description: The object corresponding to the parameter OID cannot be found in the pg_class system catalog.

Solution: Ensure that the object OID to be found is correct and that the object is analyzed and imported to the system catalog.

GAUSS-01854: "not found local index %u in pg_partition"

SQLSTATE: 42704

Description: The corresponding local index cannot be found in the pg_partition system catalog.

Solution: Ensure that the local index is valid and that the attribute of the parameter upon creation is correct.

GAUSS-01855: "none is the son local index of index %u"

SQLSTATE: 42704

Description: No local index is found in the indexes of partitionedIndexid.

Solution: Ensure that the local index to be searched for is correct.

GAUSS-01859: "cache lookup failed for index partition %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01860: "more than one item satisfied parttype is %c, parentOid is %u"

SQLSTATE: 0A000

Description: Two partitions in one table are of the same type.

Solution: Ensure that all partitions are of different types.


GAUSS-01861 – GAUSS-01870


GAUSS-01861: "'%s' does not require a toast table"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01862: "shared tables cannot be toasted after gs_initdb"

SQLSTATE: 55000

Description: After database initialization is complete, shared tables do not support TOAST.

Solution: Do not implement TOAST on shared tables if the initialization is complete.

GAUSS-01863: "cache lookup failed for relation or partition %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01864: "grant options can only be granted to roles"

SQLSTATE: 0LP01

Description: Only private users can be granted permissions.

Solution: Check whether the user has permission. If the user does not have permission, contact the administrator.

GAUSS-01865: "unrecognized object kind: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01866: "unrecognized GrantStmt.targtype: %d"

SQLSTATE: XX000

Description: Internal system error.

Solution:Contact technical support.

GAUSS-01867: "unrecognized GrantStmt.objtype: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01868: "column privileges are only valid for relations"

SQLSTATE: 0LP01

Description: Only table objects have the column storage feature.

Solution: Check whether the object feature is correct, or whether the table object is granted the column storage feature.

GAUSS-01869: "AccessPriv node must specify privilege or columns"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01870: "default privileges cannot be set for columns"

SQLSTATE: 0LP01

Description: Default access rights cannot be set for attribute columns.

Solution: Check whether the object is an attribute column.


GAUSS-01871 – GAUSS-01880


GAUSS-01871: "AccessPriv node must specify privilege"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01872: "could not find tuple for default ACL %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01873: "unexpected default ACL type: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01875: "column number out of range"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01876: "'%s' is an index"

SQLSTATE: 42809

Description: Permissions cannot be granted to an index.

Solution: Ensure that all listed objects to be granted with permissions are tables.

GAUSS-01877: "invalid privilege type USAGE for table"

SQLSTATE: 0LP01

Description: The USAGE permission is valid only for sequences.

Solution: Check the table type.

GAUSS-01878: "invalid privilege type %s for column"

SQLSTATE: 0LP01

Description: The permission type is invalid for columns.

Solution: Check the permission description and object type in the context.

GAUSS-01879: "language '%s' is not trusted"

SQLSTATE: 42809

Description: The interface programming language is not trusted by the system.

Solution: Set the interface programming language to one trusted by the system.


GAUSS-01881 – GAUSS-01890


GAUSS-01881: "cache lookup failed for tablespace %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01882: "cannot set privileges of array types"

SQLSTATE: 0LP01

Description: Permissions cannot be granted to objects whose types are array.

Solution: Ensure that the object type is correct before you grant permissions.

GAUSS-01883: "unrecognized privilege type '%s'"

SQLSTATE: 42601

Description: The permission type is unrecognized.

Solution: Check the context to determine whether the type definition is correct or has been modified.

GAUSS-01886: "permission denied for column '%s' of relation '%s'"

SQLSTATE: 42501

Description: Permission operations are denied for attribute columns in a table.

Solution: Check whether the permission operation definition is correct.

GAUSS-01887: "role with OID %u does not exist"

SQLSTATE: 42704

Description: The user does not exist.

Solution: Search the user list to check whether the user exists.

GAUSS-01888: "unrecognized objkind: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01889: "attribute %d of relation with OID %u does not exist"

SQLSTATE: 42703

Description: The table does not contain an attribute access right list.

Solution: Check whether the access right list exists when the table is defined.

GAUSS-01890: "relation with OID %u does not exist"

SQLSTATE: 42P01

Description: The result of checking user access rights in the user exit program indicates that the corresponding table does not exist.

Solution: Search the pg_class system catalog to check whether the table with corresponding OID exists.


GAUSS-01891 – GAUSS-01900


GAUSS-01891: "database with OID %u does not exist"

SQLSTATE: 3D000

Description: The result of checking user access rights indicates that the corresponding database does not exist.

Solution: Check whether the database status in the pg_database system catalog is normal.

GAUSS-01892: "function with OID %u does not exist"

SQLSTATE: 42883

Description: The result of checking user access rights in the user exit program indicates that the corresponding function does not exist.

Solution: Check whether the function is defined in the pg_proc system catalog.

GAUSS-01893: "language with OID %u does not exist"

SQLSTATE: 42704

Description: The result of checking user access rights in the user exit program indicates that the corresponding language format does not exist.

Solution: Check whether the language is defined in the pg_language system catalog.

GAUSS-01894: "schema with OID %u does not exist"

SQLSTATE: 3F000

Description: The result of checking user access rights in the user exit program indicates that the corresponding schema space does not exist.

Solution: Check whether the corresponding space is defined in the pg_namespace system catalog.

GAUSS-01895: "tablespace with OID %u does not exist"

SQLSTATE: 42704

Description: The result of checking user access rights in the user exit program indicates that the corresponding tablespace does not exist.

Solution: Check whether the tablespace is defined in the pg_tablespace system catalog.

GAUSS-01896: "foreign-data wrapper with OID %u does not exist"

SQLSTATE: XX000

Description: The foreign-data wrapper does not exist.

Solution: Ensure that the foreign-data wrapper has been created.

GAUSS-01897: "foreign server with OID %u does not exist"

SQLSTATE: XX000

Description: The foreign server does not exist.

Solution: Ensure that the foreign server has been created.

GAUSS-01898: "type with OID %u does not exist"

SQLSTATE: XX000

Description: The result of checking user access rights in the user exit program indicates that the corresponding data type does not exist.

Solution: Check whether all types are defined in the pg_type system catalog.

GAUSS-01899: "type with OID %u does not exist"

SQLSTATE: 42704

Description: The result of checking user access rights in the user exit program indicates that the corresponding data type does not exist.

Solution: Check whether all types are defined in the pg_type system catalog.

GAUSS-01900: "operator with OID %u does not exist"

SQLSTATE: 42883

Description: The result of checking user rights indicates that the corresponding operator type does not exist.

Solution: Check whether the operator is defined in the pg_operator system catalog.