MogDB
Ecological Tools
Doc Menu

GAUSS-01901 – GAUSS-02000


GAUSS-01901 – GAUSS-01910


GAUSS-01901: "language 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 language format does not exist.

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

GAUSS-01904: "text search dictionary with OID %u does not exist"

SQLSTATE: 42704

Description: The result of checking user rights indicates that the corresponding file search path does not exist.

Solution: Check all file search paths in the pg_ts_dict system catalog.

GAUSS-01905: "text search configuration with OID %u does not exist"

SQLSTATE: 42704

Description: The result of checking user rights indicates that the corresponding file search composition does not exist.

Solution: Check all file search compositions in the pg_ts_config system catalog.

GAUSS-01906: "collation with OID %u does not exist"

SQLSTATE: 42704

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

Solution: Check all character sets in the pg_collation system catalog.

GAUSS-01907: "conversion with OID %u does not exist"

SQLSTATE: 42704

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

Solution: Check all conversions in the pg_collation system catalog.

GAUSS-01908: "extension with OID %u does not exist"

SQLSTATE: 42704

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

Solution: Check all extensions in the pg_extension system catalog.

GAUSS-01909: "relation '%s' has relchecks = 0"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-01911 – GAUSS-01920


GAUSS-01911: "constraint '%s' for domain %s already exists"

SQLSTATE: 42710

Description: The constraint name already exists in the current table.

Solution: Ensure that the constraint name is unique.

GAUSS-01912: "table '%s' has multiple constraints named '%s'"

SQLSTATE: 42710

Description: The table has at least two duplicate constraints.

Solution: Ensure that each constraint has a unique name within one table.

GAUSS-01913: "constraint '%s' for table '%s' does not exist"

SQLSTATE: 42704

Description: The constraint does not exist in the current table.

Solution: Ensure that the constraint exists in the current table. Alternatively, check all constraints in the table.

GAUSS-01914: "domain '%s' has multiple constraints named '%s'"

SQLSTATE: 42710

Description: The domain has at least two duplicate constraints.

Solution: Ensure that each constraint has a unique name within one domain.

GAUSS-01915: "constraint '%s' for domain '%s' does not exist"

SQLSTATE: 42704

Description: The constraint does not exist in the current domain.

Solution: Check all constraints in the domain.

GAUSS-01916: "null conkey for constraint %u"

SQLSTATE: XX005

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01917: "conkey is not a 1-D smallint array"

SQLSTATE: 42804

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01918: "no aggregate name supplied"

SQLSTATE: XX000

Description: The aggregate name is not provided.

Solution: Provide an aggregate name.

GAUSS-01919: "aggregate must have a transition function"

SQLSTATE: XX000

Description: The aggregate does not have a transition function.

Solution: Provide a transition function.

GAUSS-01920: "cannot determine transition data type"

SQLSTATE: 42P13

Description: The conversion type for the composite type cannot be determined during aggregate function creation.

Solution: Set a conversion type for the composite type.


GAUSS-01921 – GAUSS-01930


GAUSS-01921: "return type of transition function %s is not %s"

SQLSTATE: 42804

Description: The return type generated based on transfn is inconsistent with that as specified.

Solution: Ensure that the return type for the composite type is consistent with that as specified.

GAUSS-01922: "must not omit initial value when transition function is strict and transition type is not compatible with input type"

SQLSTATE: 42P13

Description: When the conversion function is strict and inconsistent with the input type, pay attention to the type of the initial value.

Solution: Ensure that the type of the initial value is consistent with that of the conversion type. Alternatively, it must be at least compatible with binary data.

GAUSS-01923: "return type of collection function %s is not %s"

SQLSTATE: 42804

Description: The return type of the collection function is different from the expected aggTreanType.

Solution: Call the correct collection function.

GAUSS-01924: "cannot determine result data type"

SQLSTATE: 42804

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

Solution: Check and correct the parameter input type.

GAUSS-01925: "sort operator can only be specified for single-argument aggregates"

SQLSTATE: 42P13

Description: Sort operators can only appear in an aggregate function with a single parameter.

Solution: Check the number of parameters and whether to call sort operators.

GAUSS-01926: "function %s returns a set"

SQLSTATE: 42804

Description: The aggregate function can return only single value but cannot return a set.

Solution: Check whether the aggregate function is correct.

GAUSS-01927: "function %s requires run-time type coercion"

SQLSTATE: 42804

Description: The function requires type coercion during execution but the type coercion is not performed in the nodeAgg.c file.

Solution: Ensure that type conversion does not occur during execution.

GAUSS-01928: "cannot drop %s because %s requires it"

SQLSTATE: 2BP01

Description: This object cannot be deleted because other objects depend on it.

Solution: Remove the dependency relationship. Alternatively, delete the depending objects.

GAUSS-01929: "incorrect use of PIN dependency with %s"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01930: "unrecognized dependency type '%c' for %s"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-01931 – GAUSS-01940


GAUSS-01931: "cannot drop %s because other objects depend on it"

SQLSTATE: 2BP01

Description: This object cannot be deleted because other objects depend on it.

Solution: Remove the dependency relationship. Alternatively, delete the depending objects.

GAUSS-01932: "cannot drop desired object(s) because other objects depend on them"

SQLSTATE: 2BP01

Description: These objects cannot be deleted because other objects depend on them.

Solution: Use drop cascade to delete the depending objects.

GAUSS-01933: "invalid varlevelsup %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01934: "invalid varno %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01935: "already-planned subqueries not supported"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01936: "invalid resultRelation %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01937: "invalid objectSubId 0 for object class %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01938: "could not find tuple for rule %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01939: "no namespace name supplied"

SQLSTATE: XX000

Description: The namespace name is not provided while it is created.

Solution: Provide a namespace name.

GAUSS-01940: "primary keys cannot be expressions"

SQLSTATE: 0A000

Description: Primary keys cannot be expressions.

Solution: Reselect the primary key.


GAUSS-01941 – GAUSS-01950


GAUSS-01942: "too few entries in colnames list"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01943: "must index at least one column"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01944: "user-defined indexes on system catalog tables are not supported"

SQLSTATE: 0A000

Description: User-defined indexes cannot be created in system catalogs.

Solution: Do not create indexes in system catalogs.

GAUSS-01945: "concurrent index creation on system catalog tables is not supported"

SQLSTATE: 0A000

Description: Indexes cannot be concurrently created in system catalogs.

Solution: Do not concurrently create indexes in system catalogs.

GAUSS-01946: "shared indexes cannot be created after gs_initdb"

SQLSTATE: 55000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01947: "constraint must be PRIMARY, UNIQUE or EXCLUDE"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01948: "constraints cannot have index expressions"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01949: "DROP INDEX CONCURRENTLY must be first action in transaction"

SQLSTATE: 0A000

Description:DROP INDEX CONCURRENTLY must be the first statement in a transaction block.

Solution: Move DROP INDEX CONCURRENTLY to the first statement in a transition block.

GAUSS-01950: "invalid indnatts %d for index %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-01951 – GAUSS-01960


GAUSS-01951: "could not find tuple for partition %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01952: "cannot reindex temporary tables of other sessions"

SQLSTATE: 0A000

Description: Indexes in temporary tables of other sessions cannot be reorganized.

Solution: Do not reorganize indexes in temporary tables of other sessions.

GAUSS-01953: "cannot reindex while reindexing"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01954: "cache lookup failed for partitioned index %u"

SQLSTATE: XX000

Description: Failed to find the partitioned indexes in the system catalog cache.

Solution: Check whether partitioned indexes exist.

GAUSS-01955: "Memory alloc failed for indexInfo"

SQLSTATE: XX000

Description: Failed to generate the IndexInfo structure.

Solution: Ensure that the memory is sufficient.

GAUSS-01956: "cache lookup failed for index %u"

SQLSTATE: XX000

Description: Failed to find the index in the system catalog cache.

Solution: Ensure that the index name is correct.

GAUSS-01957: "mergingBtreeIndexes, zero or less than 2 or greater than 4 source index relations"

SQLSTATE: XX000

Description: During index merge, only one index is the source index or the number of indexes imported as source indexes exceeds the maximum number 300.

Solution:Contact technical support.

GAUSS-01958: "mergingBtreeIndexes, only btree indexes can be merged"

SQLSTATE: XX000

Description: Only B-tree indexes can be merged.

Solution:Contact technical support.

GAUSS-01959: "target merging index '%s' already contains data"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-01961 – GAUSS-01970


GAUSS-01961: "invalid enum label '%s'"

SQLSTATE: 42602

Description: Invalid enum type.

Solution: Check whether SQL statements contain the invalid enumerated type displayed in the system.

GAUSS-01962: "'%s' is not an existing enum label"

SQLSTATE: 22023

Description: Invalid enum type.

Solution: Check whether SQL statements contain the invalid enumerated type displayed in the system.

GAUSS-01963: "ALTER TYPE ADD BEFORE/AFTER is incompatible with binary upgrade"

SQLSTATE: 22023

Description: Enumerated type change is incompatible with binary upgrade.

Solution: Check whether the SQL statements contain enumerated type change information.

GAUSS-01965: "alignment '%c' is invalid for passed-by-value type of size %d"

SQLSTATE: 42P17

Description: The length of the pass-by-value type is invalid.

Solution: Check the type definition.

GAUSS-01966: "internal size %d is invalid for passed-by-value type"

SQLSTATE: 42P17

Description: The length of the pass-by-value type is invalid.

Solution: Check the type definition.

GAUSS-01967: "alignment '%c' is invalid for variable-length type"

SQLSTATE: 42P17

Description: The alignment is invalid for the variable-length type.

Solution: Check the type definition.

GAUSS-01969: "cannot assign new OID to existing shell type"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01970: "could not form array type name for type '%s'"

SQLSTATE: 42710

Description: The array type name is too long.

Solution: Check whether the array type length defined in the current create type definition statement exceeds the maximum number 63.


GAUSS-01971 – GAUSS-01980


GAUSS-01973: "could not stat file or directory '%s': %m"

SQLSTATE: XX000

Description: Files or directories to be accessed during program operation do not exist.

Solution: Manually create required files or directories. Alternatively, reinitialize the data directory.

GAUSS-01977: "could not open file '%s': %m"

SQLSTATE: XX000

Description: Failed to open a file.

Solution: Analyze the cause based on the error message. If the file does not exist, create one. If the permission is incorrect, change the permission. If the file is damaged, restore the file system or disk.


GAUSS-01981 – GAUSS-01990


GAUSS-01983: "cannot continue WAL streaming, recovery has already ended"

SQLSTATE: XX000

Description: The walreceiver does not need to be enabled on the primary server. If it is enabled, an error message is reported.

Solution: The error message reporting is normal and does not need to be handled.

GAUSS-01984: "invalid standby handshake message type %d"

SQLSTATE: 08P01

Description: The primary server receives an invalid handshake type from the standby server.

Solution: Check whether the primary and standby server environment is normal and whether packet loss occurs. If no such issues exist, an internal error occurs. Contact technical support.

GAUSS-01986: "invalid standby message type '%c'"

SQLSTATE: 08P01

Description: The primary server receives an invalid message type from the standby server.

Solution: Check whether the primary and standby server environment is normal and whether packet loss occurs. If no such issues exist, an internal error occurs. Contact technical support.

GAUSS-01987: "number of requested standby connections exceeds max_wal_senders (currently %d)"

SQLSTATE: 53300

Description: The number of connection requests from the standby server to the primary server exceeds the upper limit. The reason may be that the standby server attempts to connect to the primary server many times but fail. Also, the value of max_wal_senders for the primary server may be too small, especially when the build command is executed on the standby server, because two threads are started on the primary server to send data and logs.

Solution: Check whether the former connections are ended. If not, manually close them. Check whether the value of max_wal_senders is too small. If yes, increase the value.