MogDB
Ecological Tools
Doc Menu

GAUSS-01701 – GAUSS-01800


GAUSS-01701 – GAUSS-01710


GAUSS-01702: "permission denied to create '%s.%s'"

SQLSTATE: 42501

Description: Creating a heap table failed because the creating mode or the database namespace is not allowed by the system.

Solution: Ensure that the creating mode or the database namespace is correct.

GAUSS-01703: "column name '%s' specified more than once"

SQLSTATE: 42701

Description: Duplicate attribute names exist.

Solution: Ensure that the attribute name is unique.

GAUSS-01704: "column '%s' has pseudo-type %s"

SQLSTATE: 42P16

Description: Attribute check failed because unknown attribute types exist.

Solution: Ensure that the current attribute type is supported by the system.

GAUSS-01705: "composite type %s cannot be made a member of itself"

SQLSTATE: 42P16

Description: The name of the composite type is the same as that of the current type, which is not allowed.

Solution: Ensure that the name of the composite data type is unique.

GAUSS-01706: "no collation was derived for column '%s' with collatable type %s"

SQLSTATE: 42P16

Description: Creating a heap table failed because the attribute column supports attcollation but the attcollation is invalid.

Solution: Ensure that the collation definition in the attribute column is valid when the table is created.

GAUSS-01707: "Invalid distribution column specified"

SQLSTATE: 42P16

Description: The attribute names used to mark distribution status is not contained in the attribute column. As a result, the number of attribute columns is equal to or less than 0.

Solution: Ensure that the attribute name in the DISTRIBUTE BY statement exists in the attribute column defined in the table.

GAUSS-01708: "Column %s is not a hash distributable data type"

SQLSTATE: 42809

Description: The data type cannot be distributed in hash mode.

Solution: Ensure that the data used in the current column can be distributed in hash mode.

GAUSS-01709: "Column %s is not modulo distributable data type"

SQLSTATE: 42809

Description: The data type cannot be distributed in modulo mode.

Solution: Ensure that the data used in the current column can be distributed in modulo mode.

GAUSS-01710: "Invalid distribution type"

SQLSTATE: 42P16

Description: The system does not support the specified distribution type.

Solution: Ensure that the distribution type in use is supported by the system.


GAUSS-01711 – GAUSS-01720


GAUSS-01712: "PGXC node %s: not a Datanode"

SQLSTATE: 42601

Description: The node specified by this name is not a DN.

Solution: Ensure that the node ID is correct and the system runs properly.

GAUSS-01713: "PGXC Group %s: group not defined"

SQLSTATE: 42704

Description: The node group corresponding to group_name does not exist.

Solution: Check whether the group_name called is correct, or whether the group is correctly created.

GAUSS-01714: "shared relations must be placed in pg_global tablespace"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01715: "could not find attrdef tuple for relation %u attnum %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01716: "could not find tuple for attrdef %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01717: "could not remove file '%s': %m"

SQLSTATE: XX000

Description: Failed to delete the corresponding error message table.

Solution: Check whether you have that permission.

GAUSS-01718: "cache lookup failed for foreign table %u"

SQLSTATE: XX000

Description: Failed to find the required foreign-data wrapper.

Solution: Check whether the settings of GDS, HDFS foreign tables, Roach, and OBS are correct.

GAUSS-01719: "cache lookup failed for partitioned table %u in pg_partition"

SQLSTATE: XX000

Description: The corresponding tuple cannot be found in a partitioned table.

Solution: Ensure that the object corresponding to relid is a partitioned table. If it is, check the status of its tuples.

GAUSS-01720: "check constraint '%s' already exists"

SQLSTATE: 42710

Description: The constraint to be added already exists.

Solution: Ensure that the constraint to be added is unique.


GAUSS-01721 – GAUSS-01730


GAUSS-01721: "null conbin for rel %s"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01722: "constraint '%s' conflicts with non-inherited constraint on relation '%s'"

SQLSTATE: 42P17

Description: The new constraint conflicts with non-inherent constraints in the table.

Solution: Ensure that the type of the new constraint and that of the existing ones are consistent.

GAUSS-01723: "cannot use column references in default expression"

SQLSTATE: 42P10

Description: The default expression contains table attribute variables.

Solution: Ensure that the default expression in the SQL statement does not contain attribute variables.

GAUSS-01724: "default expression must not return a set"

SQLSTATE: 42804

Description: The default expression returns a set, which is not allowed.

Solution: Ensure that the default expression in the SQL statement does not return a set.

GAUSS-01725: "cannot use subquery in default expression"

SQLSTATE: 0A000

Description: The default expression contains subquery expressions, which is not allowed.

Solution: Ensure that the default expression in the SQL statement does not contain subquery expressions.

GAUSS-01727: "cannot use window function in default expression"

SQLSTATE: 42P20

Description: The default expression contains window functions, which is not allowed.

Solution: Ensure that the default expression in the SQL statement does not contain window functions.

GAUSS-01728: "column '%s' is of type %s but default expression is of type %s"

SQLSTATE: 42804

Description: The type of the column attribute is different from that of the value returned by the corresponding default expression.

Solution: Ensure that the expression is correct. If not, rewrite the expression.

GAUSS-01729: "only table '%s' can be referenced in check constraint"

SQLSTATE: 42P10

Description: Only the constraint of a specific table can be checked. Cross-table check is unsupported.

Solution: Ensure that the table name corresponding to the constraint is correct. Alternatively, ensure that the table specified in the expression resolved is consistent with the actual one.

GAUSS-01730: "unsupported ON COMMIT and foreign key combination"

SQLSTATE: 0A000

Description: The foreign key of Table 2 is the primary key of Table 1, indicating that Table 2 references Table 1. However, their COMMIT settings are different.

Solution: Ensure that their COMMIT settings are consistent.


GAUSS-01731 – GAUSS-01740


GAUSS-01731: "cannot truncate a table referenced in a foreign key constraint"

SQLSTATE: 0A000

Description: The table referenced by a foreign key constraint cannot be truncated.

Solution: Ensure that the current table to be truncated is referenced by another table. If it is, delete both of them.

GAUSS-01732: "buildPartitionKey(): partKeys specified NONE IS found'"

SQLSTATE: 22015

Description: The partKeys corresponding to attributes of the table is not found.

Solution: Ensure that the correct partKeys is provided when the partitioned table is created.

GAUSS-01733: "cache lookup failed for partition %u"

SQLSTATE: XX000

Description: Failed to find the partition in the cache.

Solution: Ensure that the partition is valid.

GAUSS-01734: "missing definition for new partition"

SQLSTATE: XX000

Description: The new partition is not defined.

Solution: Ensure that the partition is correctly defined before it is added.

GAUSS-01735: "boundary not defined for new partition"

SQLSTATE: XX000

Description: The boundary is not defined in the new partition.

Solution: Ensure that the boundary is correctly defined in the new partition.

GAUSS-01736: "too many partition keys, allowed is %d"

SQLSTATE: XX000

Description: The number of partitions added exceeds the maximum.

Solution: Ensure that the number of newly added partitions does not exceed the maximum.

GAUSS-01737: "number of partition key columns MUST less or equal than 4"

SQLSTATE: XX000

Description: The number of attribute columns of a partition must be equal to or less than 4.

Solution: Ensure that the number of attribute (partition key) columns of the original partitioned table is within the allowed range.

GAUSS-01738: "inserted partition key does not map to any table partition"

SQLSTATE: XX000

Description: The partition key of the inserted tuple does not map to any existing partition.

Solution: Check whether the data inserted is out of the partition range of the partitioned table.

GAUSS-01739: "Inserted partition key does not map to any table partition"

SQLSTATE: XX000

Description: The newly inserted partition key cannot be recognized.

Solution: Ensure that the inserted partition key maps to the current partition.


GAUSS-01741 – GAUSS-01750


GAUSS-01742: "cannot have more than %d keys in a cluster key"

SQLSTATE: 54011

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01743: "partial cluster key constraint does not support row/timeseries store"

SQLSTATE: 42P16

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01744: "'%s' is not a valid operator name"

SQLSTATE: 42602

Description: The operator name to be created is invalid.

Solution: Ensure that the name length is correct and the name contains invalid characters or identifiers. For details, see the validOperatorName function.

GAUSS-01745: "only binary operators can have commutators"

SQLSTATE: 42P13

Description: In the event of left and right variables in an expression, only binary operators can contain commutators.

Solution: Ensure that the operators to be created are binary ones.

GAUSS-01746: "only binary operators can have join selectivity"

SQLSTATE: 42P13

Description: In the event of left and right variables in an expression, only the return values of binary operators can be used to calculate the join selectivity.

Solution: Ensure that the operators to be created are binary ones.

GAUSS-01748: "only binary operators can hash"

SQLSTATE: 42P13

Description: If left and right variables exist in an expression, only binary operators can be used for the merge join path.

Solution: Ensure that the operators to be created are binary ones.

GAUSS-01749: "only boolean operators can have negators"

SQLSTATE: 42P13

Description: Only Boolean operators support negators.

Solution: Ensure that the operators to be created are Boolean ones.

GAUSS-01750: "only boolean operators can have restriction selectivity"

SQLSTATE: 42P13

Description: Only the return values of Boolean operators can be used to calculate the join selectivity.

Solution: Ensure that the operators to be created are Boolean ones.


GAUSS-01751 – GAUSS-01760


GAUSS-01751: "only boolean operators can have join selectivity"

SQLSTATE: 42P13

Description: Only the return values of Boolean operators can be used to calculate the join selectivity.

Solution: Ensure that the operators to be created are Boolean ones.

GAUSS-01753: "only boolean operators can hash"

SQLSTATE: 42P13

Description: Only the return values of Boolean operators can be used to generate the hash path.

Solution: Ensure that the operators to be created are Boolean ones.

GAUSS-01754: "operator %s already exists"

SQLSTATE: 42723

Description: The operator already exists.

Solution: Ensure that the operator to be created is unique.

GAUSS-01755: "operator cannot be its own negator or sort operator"

SQLSTATE: 42P13

Description:Internal system error.

Solution:Contact technical support.

G

GAUSS-01758: "large object %u does not exist"

SQLSTATE: 42704

Description: The current large object name cannot be mapped to an actual object.

Solution: Ensure that a large object of the same name has already been created, and the object is dropped during execution.

GAUSS-01759: "unrecognized objtype: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01760: "must specify relation and object name"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-01761 – GAUSS-01770


GAUSS-01761: "column name must be qualified"

SQLSTATE: 42601

Description: The attribute name in the object must be specified and described.

Solution:Contact technical support.

GAUSS-01762: "must be owner of large object %u"

SQLSTATE: 42501

Description: The ownership of the large object data is incorrect.

Solution: Run get_object_address to obtain the object ID and ensure that the ownership is correct.

GAUSS-01763: "must be system admin"

SQLSTATE: 42501

Description: You are not an initial user.

Solution: Ensure that the user rights are correctly inherited when the object is defined.

GAUSS-01764: "must have CREATEROLE privilege"

SQLSTATE: 42501

Description: Obtain the permission to create objects.

Solution: Check the rights of the user that owns the object data and ensure that the object is valid.

GAUSS-01765: "unrecognized object type: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01766: "cache lookup failed for cache %d oid %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01767: "unrecognized class id: %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01768: "temporary tables cannot specify a schema name"

SQLSTATE: 42P16

Description: The current temporary table is not in the original temporary tablespace.

Solution: Ensure that the temporary tablespace is correctly created and that the tablespace OID is correct.


GAUSS-01771 – GAUSS-01780


GAUSS-01771: "cannot create relations in temporary schemas of other sessions"

SQLSTATE: 42P16

Description: Creating tables in the temporary tablespace of other sessions is not allowed.

Solution: Do not create tables in the temporary tablespace of other sessions.

GAUSS-01772: "cannot create temporary relation in non-temporary schema"

SQLSTATE: 42P16

Description: Temporary tables cannot be created in non-temporary tablespace.

Solution: Check the tablespace name before creating a table.

GAUSS-01773: "only temporary relations may be created in temporary schemas"

SQLSTATE: 42P16

Description: Only temporary tables can be created in temporary schemas (tablespace).

Solution: Check the tablespace name before creating an object. Create an object based on the characteristics of the tablespace.

GAUSS-01774: "text search parser '%s' does not exist"

SQLSTATE: 42704

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01775: "text search dictionary '%s' does not exist"

SQLSTATE: 42704

Description: The TS file directory cannot be found or does not exist.

Solution: Ensure that the file directory created in the database is correct.

GAUSS-01776: "text search template '%s' does not exist"

SQLSTATE: 42704

Description: The template database cannot be found. The file directory is invalid.

Solution: Ensure that the template database is correctly created at the initial stage of database creation and that the template database file directory is correct.

GAUSS-01777: "%s is already in schema '%s'"

SQLSTATE: 42P07

Description: The object already exists in the current tablespace.

Solution: Query the system catalog to check whether the object already exists in the schema.

GAUSS-01778: "cannot move objects into or out of temporary schemas"

SQLSTATE: 0A000

Description: Moving an object into or out of a temporary tablespace is not allowed.

Solution: Do not move the object into or out of a temporary tablespace.

GAUSS-01780: "cannot move objects into CSTORE schema"

SQLSTATE: 0A000

Description: Objects of other tablespaces cannot be moved into a column-store tablespace.

Solution: Ensure that the current tablespace is not a column-store one.


GAUSS-01781 – GAUSS-01790


GAUSS-01781: "cannot move objects into system schema"

SQLSTATE: 0A000

Description: Objects cannot be moved to the system tablespace.

Solution: Do not move objects to the system tablespace.

GAUSS-01782: "improper relation name (too many dotted names): %s"

SQLSTATE: 42601

Description: The name of an imported table is invalid.

Solution: The most complex table name supported in the database is catalogname.schemaname.relname.

GAUSS-01783: "unexpected node type in name list: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01784: "bogus PopOverrideSearchPath call"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01785: "collation '%s' for encoding '%s' does not exist"

SQLSTATE: 42704

Description: The encoding method obtained by executing GetDatabaseEncodingName() cannot be used with NameListToString(name).

Solution: For information about character sets and corresponding encoding methods supported by the system, see the Administrator Guide.

GAUSS-01786: "conversion '%s' does not exist"

SQLSTATE: 42704

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01787: "invalid list syntax"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01788: "permission denied to create temporary tables in database '%s'"

SQLSTATE: 42501

Description: You do not have permission to create temporary tables in the current database.

Solution: Ensure that you have that permission.

GAUSS-01789: "cannot create temporary tables during recovery"

SQLSTATE: 25006

Description: Temporary tables cannot be created because the database is under recovery.

Solution: Correct the status of the database first if creating a temporary table fails.

GAUSS-01790: "current user does not have privilege to role %s"

SQLSTATE: 42501

Description: You do not have permission to manage roles.

Solution: Manage roles as a system administrator.


GAUSS-01791 – GAUSS-01800


GAUSS-01791: "collation '%s' for encoding '%s' already exists"

SQLSTATE: 42710

Description: The character set corresponding to pg_encoding_to_char(collencoding) already exists.

Solution: Ensure that the character set space corresponding to the current encoding method is sufficient.

GAUSS-01792: "collation '%s' already exists"

SQLSTATE: 42710

Description: The character set already exists.

Solution: Ensure that the character set to be created is unique.

GAUSS-01793: "could not find tuple for collation %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01794: "multiple pg_shdepend entries for object %u/%u/%d deptype %c"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01795: "cannot drop %s because it is required by the database system"

SQLSTATE: 2BP01

Description: The current object cannot be dropped because other objects are dependent upon it.

Solution: Check the dependency relationship between the current object and other tables. Select cascade if you want to delete the object.

GAUSS-01797: "tablespace %u was concurrently dropped"

SQLSTATE: 42704

Description: The object needs to be locked before the system records dependency relationships of tablespaces. However, the tablespace cannot be found after the lock is obtained.

Solution: Query logs to check when the tablespace was dropped and ensure that the operation is logical.

GAUSS-01800: "unrecognized dependency type: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.