MogDB
Ecological Tools
Doc Menu

GAUSS-04701 – GAUSS-04800


GAUSS-04701 – GAUSS-04710


GAUSS-04706: "The parameter can not smaller than -1."

SQLSTATE: XX000

Description: The value of the prevbit parameter must be greater than or equal to -1 when the parameter is verified.

Solution:Contact technical support.

GAUSS-04708: "Column count in table definition does not match with ORC file %s."

SQLSTATE: 22000

Description: The column definition of the table is inconsistent with that of the ORC file.

Solution:Contact technical support.

GAUSS-04709: "Error occurs while read row index of orc file, detail can be found in dn log of %s."

SQLSTATE: 22000

Description: An error occurs when the index data in the ORC file on the DFS is read.

Solution:Contact technical support.

GAUSS-04710: "Unsupported orc type : %u."

SQLSTATE: 0A000

Description: The DFS table does not support this data type.

Solution:Contact technical support.


GAUSS-04711 – GAUSS-04720


GAUSS-04714: "Unsupported data type : %u."

SQLSTATE: 0A000

Description: The HDFS table does not support this data type.

Solution: Change the definition type to the type that the HDFS table supports based on the prompt.

GAUSS-04715: "Invalid string for 'COMPRESSION' option."

SQLSTATE: 22023

Description: The compression mode is invalid.

Solution: Set a correct compression mode when creating a table. The HDFS supports only the zlib or snappy compression algorithm.


GAUSS-04721 – GAUSS-04730


GAUSS-04721: "The start index is over the limit."

SQLSTATE: 22000

Description: The imported data exceeds the maximum data volume in the buffer process when the HDFS table is imported and the upper-layer data is written to the bottom data stream.

Solution: Check specific reason information in the corresponding DN logs.

GAUSS-04722: "DFS connector can not be NULL when loading data into dfs table."

SQLSTATE: 42704

Description: The HDFS connection to DFS is an invalid pointer when data is imported to the HDFS.

Solution:Contact technical support.

GAUSS-04726: "We only support pushing down opExpr and null test predicate."

SQLSTATE: 0A000

Description: The type of the filter predicates in the HDFS table is not supported.

Solution:Contact technical support.

GAUSS-04727: "could not find operator by oid %u"

SQLSTATE: 42704

Description: Internal system error. Failed to query the operation type through OID.

Solution:Contact technical support.

GAUSS-04728: "Not support pushing predicate with sublink param now!"

SQLSTATE: 0A000

Description: Internal system error. The predicate of the subquery cannot be pushed down.

Solution:Contact technical support.

GAUSS-04729: "Not support pushing predicate with non-const"

SQLSTATE: 0A000

Description: Internal system error. The non-constant predicate cannot be pushed down.

Solution:Contact technical support.

GAUSS-04730: "We only support pushing down opExpr and null test predicates."

SQLSTATE: 0A000

Description: Internal system error. Only the expression predicate and the null predicate can be pushed down.

Solution:Contact technical support.


GAUSS-04731 – GAUSS-04740


GAUSS-04731: "Data type %u has not been supported for predicate push down."

SQLSTATE: 0A000

Description: Internal system error. The error data type does not support dynamic predicate pushdown.

Solution:Contact technical support.

GAUSS-04732: "The maximum accuracy of decimal/numeric data type supported is %d bits."

SQLSTATE: 0A000

Description: The maximum precision supported by the decimal or numeric type exceeds 38 digits.

Solution: Define the precision of the decimal or numeric type to be less than or equal to 38 digits when creating a table.

GAUSS-04737: "There is an illegal character '%c' in the option %s."

SQLSTATE: 44000

Description: Invalid characters exist in the option of folder name or file name.

Solution: Check the path specification of the folder name or file name and rebuild the HDFS foreign table.

GAUSS-04738: "The option %s should not be end with '%c'."

SQLSTATE: 44000

Description: An error is reported when the option of the file name ends up with a slash (/).

Solution: Do not end up the option of the file name with a slash (/).


GAUSS-04741 – GAUSS-04750


GAUSS-04741: "The path '%s' must be an absolute path."

SQLSTATE: 42P17

Description: The path of the file name or folder name is not an absolute path.

Solution: The folder name or file name specified for an HDFS table must be an absolute path.

GAUSS-04742: "The address option exists illegal character: '%c'"

SQLSTATE: 44000

Description: Invalid spaces exist in the address option of the server on the HDFS.

Solution: Remove the invalid spaces.

GAUSS-04744: "The count of address '%s' must be not greater than %d."

SQLSTATE: 44000

Description: The number of the addresses cannot exceed 2.

Solution: Ensure that the number of addresses specified during DFS server creation does not exceed 2.

GAUSS-04745: "Unsupport ipv6 foramt"

SQLSTATE: 44000

Description: The address of the DFS server does not support the IPv6 address format.

Solution: Change the address of the DFS server to the IPv4 address format.

GAUSS-04746: "The incorrect address format"

SQLSTATE: 44000

Description: The address format is incorrect.

Solution: View the correct address description.

GAUSS-04747: "Failed to create DfsInsert handler when updating table."

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-04748: "build global dfs space cache hash table failed"

SQLSTATE: 42704

Description: Internal system error. Failed to create a global cache for HDFS connections.

Solution:Contact technical support.

GAUSS-04749: "The number of files exceeds the limit %d."

SQLSTATE: 22000

Description: The number of files arrives the upper limit.

Solution:Contact technical support.

GAUSS-04750: "could not initialize DFS space hash table"

SQLSTATE: 42704

Description: Do not create the hash table used for caching the file sequence number.

Solution:Contact technical support.


GAUSS-04751 – GAUSS-04760


GAUSS-04752: "could not initialize partition pruning result cache."

SQLSTATE: XX000

Description: Failed to create the cache used for searching for partition when the partitioned table is imported.

Solution: Check whether the server has sufficient memory to create the cache used for searching for partition.

GAUSS-04753: "Unsupported data type on column:%s when forming partition signature"

SQLSTATE: XX000

Description: The data type of the partition key is not supported when the partitioned table is imported.

Solution: Check whether data in the system directory table is consistent and determine whether the created partitioned table and partition column are supported by the partition type.

GAUSS-04756: "could not rewind DFS Partition Loading temporary file: %m"

SQLSTATE: XX000

Description: The cache file fails to move the file cursor when the partitioned table is imported.

Solution: Check whether the temporary files are damaged.

GAUSS-04758: "Only ORC is supported for now."

SQLSTATE: 0A000

Description: Internal system error. The HDFS table in the manual supports only the ORC format.

Solution:Contact technical support.

GAUSS-04759: "DfsStore: unrecognized heap_update status: %u"

SQLSTATE: XX000

Description: The delete and update operations of the DESC table conflict with each other.

Solution:Contact technical support.

GAUSS-04760: "type '%s' is not supported in DFS ORC format column store"

SQLSTATE: 0A000

Description: The data type is not supported by the HDFS table.

Solution: Use other data types when creating the HDFS table.


GAUSS-04761 – GAUSS-04770


GAUSS-04761: "Value '%s' of option 'compression' is invalid for row table"

SQLSTATE: 0A000

Description: The column-store table compression parameters are incorrectly specified.

Solution: Change the compression parameters to yes or no.

GAUSS-04762: "Invalid string for 'filesystem' option."

SQLSTATE: 22023

Description: An error is reported because the value of the filesystem is incorrect when a tablespace is created.

Solution: Set filesystem to general or hdfs when creating a tablespace.

GAUSS-04764: "No storepath is specified for a DFS server."

SQLSTATE: XX000

Description: The store path is not specified when the HDFS tablespace is created.

Solution: Specify a store path when creating the HDFS tablespace.

GAUSS-04765: "current text search configuration doesnot support options"

SQLSTATE: 22023

Description: The current configuration does not support options.

Solution: Modify the SQL statement based on the documentation.

GAUSS-04766: "CUListWrite: Cannot allocate memory"

SQLSTATE: XX000

Description: Failed to allocate the memory because the system memory is insufficient.

Solution: After the OS releases part of memory, allocate the memory again.

GAUSS-04767: "could not access status of transaction %lu, nextXid is %lu"

SQLSTATE: XX000

Description: The transaction on the node to be accessed does not exist.

Solution:

  • If the transaction status that does not exist is called actively, ignore it.
  • If it is a normal transaction and the node involves this transaction, contact technical support.

GAUSS-04770: "write cu failed, colid(%d) cuid(%u), offset(%lu), size(%d) : %m"

SQLSTATE: XX000

Description: An exception occurs when the data file is written in the asynchronization I/O mode.

Solution: Restore the cluster data file from the standby server or the backup data.


GAUSS-04771 – GAUSS-04780


GAUSS-04774: "Snapshot too old."

SQLSTATE: XX000

Description: The queried snapshot is the old snapshot.

Solution: Try again.

GAUSS-04778: "Unable to get store format for Dfs relation %s"

SQLSTATE: None

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04779: "The relation '%s' has no distribute type."

SQLSTATE: 0A000

Description: The queried table has no distribution type, for example, query the Desc table on the CN.

Solution: This type of table can be queried only on the DN.


GAUSS-04781 – GAUSS-04790


GAUSS-04781: "Upper-level GROUPING found where not expected"

SQLSTATE: XX000

Description: The upper-layer grouping cannot exist in the subplan.

Solution: Rewrite the SQL statement which has the same meanings.

GAUSS-04782: "GROUPING found where not expected"

SQLSTATE: XX000

Description: The WHERE statement cannot contain grouping.

Solution: Modify the SQL statement.

GAUSS-04783: "ORDER/GROUP BY expression not found in list"

SQLSTATE: XX000

Description: Failed to find the specified ORDER or GROUP reference in the ORDER BY or GROUP BY clause.

Solution:Contact technical support.

GAUSS-04784: "Relation with OID %u does not exist."

SQLSTATE: XX000

Description: The queried table does not exist.

Solution:Internal system error.Contact technical support.

GAUSS-04785: "get tablespace %u store path failed"

SQLSTATE: 42P01

Description: Internal system error.

Solution:Contact technical support.

AUSS-04786: "Un-support feature: HDFS"

SQLSTATE: 0A000

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04787: "cache lookup failed for bucket %u"

SQLSTATE: 29P01

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04788: "null bucket for tuple %u"

SQLSTATE: 22004

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04789: "got null for pgxc_class option %u"

SQLSTATE: 29P01

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04790: "should in restore mode"

SQLSTATE: 42602

Description: Internal system error.

Solution:Contact technical support.


GAUSS-04791 – GAUSS-04800


GAUSS-04791: "invalid hashbucketId syntax"

SQLSTATE: 42602

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04792: "Cannot drop all buckets"

SQLSTATE: D0011

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04793: "Invalid bucket id %u, max bucket id is %d"

SQLSTATE: 22023

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04794: "invalid relation file path %s for relpath_parse_rnode"

SQLSTATE: 22023

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04795: "Failed to write data to the dfs file list, error code: %d"

SQLSTATE: None

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04796: "grant to public operation is forbidden in security mode"

SQLSTATE: 0LP01

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04797: "Forbid grant language c to user with grant option."

SQLSTATE: 0A000

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04798: "Forbid grant language c to public."

SQLSTATE: 0A000

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04799: "WITH GRANT OPTION is not supported for NODE GROUP."

SQLSTATE: 0A000

Description: Internal system error.

Solution:Contact technical support.

GAUSS-04800: "Only roles with sysadmin or createdb privileges can do GRANT/REVOKE."

SQLSTATE: 0A000

Description: Internal system error.

Solution:Contact technical support.