MogDB
Ecological Tools
Doc Menu

GAUSS-02901 – GAUSS-03000


GAUSS-02901 – GAUSS-02910


GAUSS-02901: "invalid external 'cidr' value"

SQLSTATE: 22P03

Description: The network address is invalid.

Solution: Check whether the format of the entered network address is correct.

GAUSS-02902: "invalid inet bit length: %d"

SQLSTATE: 22023

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02903: "invalid mask length: %d"

SQLSTATE: 22023

Description: The network address is invalid.

Solution: Check whether the format of the entered network address is correct.

GAUSS-02904: "could not format cidr value: %m"

SQLSTATE: 22P03

Description: Failed to format the network address to the CIDR format.

Solution: Check whether the data to be formatted is a valid network address.

GAUSS-02905: "unsupported type: %u"

SQLSTATE: 0A000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02906: "cannot AND inet values of different sizes"

SQLSTATE: 22023

Description: IPv4 addresses and IPv6 addresses cannot be used as AND operands at the same time.

Solution: Check whether the left and right operands of AND are the same IP address family.

GAUSS-02907: "cannot OR inet values of different sizes"

SQLSTATE: 22023

Description: IPv4 addresses and IPv6 addresses cannot be used as OR operands at the same time.

Solution: Check whether the left and right operands of OR are the same IP address family.

GAUSS-02908: "result is out of range"

SQLSTATE: 22003

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02909: "cannot subtract inet values of different sizes"

SQLSTATE: 22023

Description: IPv4 addresses and IPv6 addresses cannot be used as SUBTRACT operands at the same time.

Solution: Check whether the left and right operands of SUBTRACT are the same IP address family.

GAUSS-02910: "arraycontsel called for unrecognized operator %u"

SQLSTATE: XX000

Description: The array operation is incorrect.

Solution: Contact technical support. Alternatively, check the statement or data.


GAUSS-02911 – GAUSS-02920


GAUSS-02911: "suppress_redundant_updates_trigger: must be called as trigger"

SQLSTATE: 39P01

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02912: "suppress_redundant_updates_trigger: must be called on update"

SQLSTATE: 39P01

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02913: "suppress_redundant_updates_trigger: must be called before update"

SQLSTATE: 39P01

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02914: "suppress_redundant_updates_trigger: must be called for each row"

SQLSTATE: 39P01

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02915: "could not determine input data types"

SQLSTATE: 22023

Description: The data type is incorrect.

Solution: Contact technical support. Alternatively, check the statement or data.

GAUSS-02916: "neither input type is an array"

SQLSTATE: 42804

Description: The array data is incorrect.

Solution: Contact technical support. Alternatively, check the statement or data.

GAUSS-02917: "argument must be empty or one-dimensional array"

SQLSTATE: 22000

Description: The parameter is incorrect.

Solution: Contact technical support. Alternatively, check the statement or data.

GAUSS-02918: "cannot concatenate incompatible arrays"

SQLSTATE: 42804

Description: The array data is incorrect.

Solution: Contact technical support. Alternatively, check the statement or data.

GAUSS-02919: "cannot concatenate incompatible arrays"

SQLSTATE: 2202E

Description: The array data is incorrect.

Solution: Contact technical support. Alternatively, check the statement or data.

GAUSS-02920: "invalid number of dimensions: %d"

SQLSTATE: 22023

Description: The array dimension is less than zero.

Solution: Check the input parameter.


GAUSS-02921 – GAUSS-02930


GAUSS-02921: "could not determine input data type"

SQLSTATE: 22023

Description: The data type is incorrect.

Solution: Contact technical support. Alternatively, check the statement or data.

GAUSS-02922: "array_agg_transfn called in non-aggregate context"

SQLSTATE: XX000

Description: The array_agg function is used in non-aggregation operations.

Solution: Modify the use of array_agg in the query.

GAUSS-02924: "no active snapshot set"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02925: "invalid snapshot data"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02926: "SPI_connect failed"

SQLSTATE: SP001

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02927: "SPI_finish failed"

SQLSTATE: SP002

Description: Internal system error.

Solution:Contact technical support.

GAUSS-02928: "insert or update on table '%s' violates foreign key constraint '%s'"

SQLSTATE: 23503

Description: The insertion or update operation violates the foreign key constraint.

Solution: Check whether the foreign key constraint meets the current insertion or update operation.

GAUSS-02929: "invalid confmatchtype"

SQLSTATE: 42804

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02930: "unrecognized match type: %d"

SQLSTATE: 42804

Description:Internal system error.

Solution:Contact technical support.


GAUSS-02931 – GAUSS-02940


GAUSS-02931: "SPI_prepare returned %d for %s"

SQLSTATE: SP003

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02932: "SPI_execute_snapshot returned %d"

SQLSTATE: SP005

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02933: "function '%s' must be fired for INSERT"

SQLSTATE: 39P01

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02934: "function '%s' must be fired for UPDATE"

SQLSTATE: 39P01

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02935: "function '%s' must be fired for DELETE"

SQLSTATE: 39P01

Description: Failed to trigger the function when the delete operation is performed.

Solution: Ensure that the triggering logic is normal.

GAUSS-02936: "no pg_constraint entry for trigger '%s' on table '%s'"

SQLSTATE: 42P17

Description: No corresponding constraint exists for the trigger on the table.

Solution: Delete the trigger related to the integrity constraint and add a constraint.

GAUSS-02937: "wrong pg_constraint entry for trigger '%s' on table '%s'"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02938: "null confkey for constraint %u"

SQLSTATE: XX005

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02939: "confkey is not a 1-D smallint array"

SQLSTATE: 42804

Description:Internal system error.

Solution:Contact technical support.


GAUSS-02941 – GAUSS-02950


GAUSS-02941: "conppeqop is not a 1-D Oid array"

SQLSTATE: 42804

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02943: "conffeqop is not a 1-D Oid array"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02944: "referential integrity query on '%s' from constraint '%s' on '%s' gave unexpected result"

SQLSTATE: XX000

Description: An error occurred when checking the primary and foreign key constraints of the two tables.

Solution: Check whether the data in the tables related to the primary and foreign key constraints is correct.

GAUSS-02945: "update or delete on table '%s' violates foreign key constraint '%s' on table '%s'"

SQLSTATE: 23503

Description: Update or delete operations violate the foreign key constraint.

Solution: Check whether the updated or deleted foreign-key values are recorded in the primary key.

GAUSS-02946: "no conversion function from %s to %s"

SQLSTATE: 42883

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02948: "unrecognized bytea_output setting: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02949: "Node id out of range"

SQLSTATE: XX001

Description: The number of node IDs is out of range.

Solution: A maximum of 4096 DNs is supported. If the number of node IDs is greater than 4096 or smaller than 0, it is out of range. Correct the number of node IDs.

GAUSS-02950: "Node id is too long"

SQLSTATE: XX001

Description: The length of the node ID exceeds the maximum length.

Solution: A maximum of 4096 DNs is supported. If the length of the node ID is greater than or equal to 5 characters, it exceeds the maximum length. Correct the length of node ID.


GAUSS-02951 – GAUSS-02960


GAUSS-02951: "invalid backend encoding: encoding max length < 1"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02952: "could not determine which collation to use for string comparison"

SQLSTATE: 42P22

Description: The parser cannot parse the implicit conversion mode.

Solution: Check whether multiple collations are compared in the current string.

GAUSS-02953: "could not convert string to UTF-16: error code %lu"

SQLSTATE: XX000

Description: Failed to convert the string to the UTF-16 format.

Solution: Solve the issue based on the error code.

GAUSS-02954: "could not compare Unicode strings: %m"

SQLSTATE: XX000

Description: Failed to convert the string to the Unicode format.

Solution: Correct the string error.

GAUSS-02955: "index %d out of valid range, 0..%d"

SQLSTATE: 2202E

Description: The entered index value is out of the length range of the bytea string.

Solution: Ensure that the index value is within the valid length range of a bytea string.

GAUSS-02956: "invalid name syntax"

SQLSTATE: 42602

Description: Failed to divide strings into delimited string groups.

Solution: Check the input strings.

GAUSS-02957: "regular expression failed: %s"

SQLSTATE: 2201B

Description: An error occurs because a queried string is empty or an incorrect querying mode is used.

Solution: Check the input parameter for querying the string.

GAUSS-02958: "field position must be greater than zero"

SQLSTATE: 22023

Description: The field position is less than 1.

Solution: The field position must be greater than 0 and at least be 1.

GAUSS-02959: "string_agg_transfn called in non-aggregate context"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02960: "could not determine data type of concat() input"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-02961 – GAUSS-02970


GAUSS-02961: "unterminated conversion specifier"

SQLSTATE: 22023

Description: The formatted string does not have a terminator.

Solution: Check whether the formatted string is correct.

GAUSS-02962: "argument number is out of range"

SQLSTATE: 22003

Description: Excessive parameters for schema matching exist. The number of parameters is out of range.

Solution: Redefine the string for schema matching and reduce the number of parameters.

GAUSS-02964: "too few arguments for format"

SQLSTATE: 22023

Description: The number of parameters is insufficient.

Solution: Ensure that the number of formatted strings matches the number of formatted variables.

GAUSS-02965: "unrecognized conversion specifier '%c'"

SQLSTATE: 22023

Description: The mode used for converting text to string is incorrect.

Solution: Check the mode used of converting text to string. The value can only be '%s', '%I', or '%L'.

GAUSS-02966: "null values cannot be formatted as an SQL identifier"

SQLSTATE: 22004

Description: When '%I' is used to convert text to string, the input data cannot be NULL.

Solution: Check whether the conversion mode is correct.

GAUSS-02969: "invalid Datum pointer"

SQLSTATE: 22000

Description: The input data cannot be empty.

Solution: Check the input data.

GAUSS-02970: "invalid typLen: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-02971 – GAUSS-02980


GAUSS-02971: "value out of range: overflow"

SQLSTATE: 22003

Description: Overflows occur when the number of floating points exceeds the upper limit.

Solution: Ensure that the input data does not exceed the upper limit. For the data value range, see en-us_topic_0237121926.html.

GAUSS-02972: "invalid input syntax for type real: '%s'"

SQLSTATE: 22P02

Description: The format of the string to be converted to the real type is incorrect.

Solution: Check the input data.

GAUSS-02973: "'%s' is out of range for type real"

SQLSTATE: 22003

Description: Overflows occur when the input string is converted to the real type.

Solution: Check the input data.

GAUSS-02974: "'%s' is out of range for type double precision"

SQLSTATE: 22003

Description: Overflows occur when input string is converted to the double type.

Solution: Check the input data.

GAUSS-02975: "input is out of range"

SQLSTATE: 22003

Description: The input is out of range.

Solution: Ensure that the returned value of the parameter that causes this error is within the range. For the data value range, see en-us_topic_0237121926.html.

GAUSS-02976: "setseed parameter %f out of range [-1,1]"

SQLSTATE: XX000

Description: The setseed() function parameter is out of range.

Solution: Ensure that the setseed() function parameter ranges from –1 to 1.

GAUSS-02978: "lower and upper bounds must be finite"

SQLSTATE: 2201G

Description: Both the upper and lower limit values must be finite values.

Solution: Check the input data.

GAUSS-02979: "reference to parent directory ('..') not allowed"

SQLSTATE: 42501

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02980: "absolute path not allowed"

SQLSTATE: 42501

Description: Only the data and log directories support absolute paths.

Solution: Change the path to a relative path.


GAUSS-02981 – GAUSS-02990


GAUSS-02981: "path must be in or below the current directory"

SQLSTATE: 42501

Description: The input path must be included in the current path.

Solution: Change the input path.

GAUSS-02982: "could not stat file '%s': %m"

SQLSTATE: XX000

Description: Failed to obtain the file status information.

Solution: Check whether the file status is abnormal, for example, the file does not exist or you do not have the file read permission.

GAUSS-02983: "requested length too large"

SQLSTATE: 22023

Description: The length of the file to be read exceeds the maximum value.

Solution: Reduce the size of the file to be read to a value less than 1 GB.

GAUSS-02984: "could not seek in file '%s': %m"

SQLSTATE: XX000

Description: The file cannot be located based on the offset.

Solution: Ensure that the file status is normal.

GAUSS-02985: "could not read file '%s': %m"

SQLSTATE: XX000

Description: Only database system administrator can read the file.

Solution: Read the file as a system administrator.

GAUSS-02987: "requested length cannot be negative"

SQLSTATE: 22023

Description: Only database system administrator can obtain the file information.

Solution: Change to a system administrator.

GAUSS-02990: "requested length too large"

SQLSTATE: 54000

Description: The length of the file to be read exceeds the maximum value.

Solution: Reduce the size of the file to be read to a value less than 1 GB.


GAUSS-02991 – GAUSS-03000


GAUSS-02991: "requested character too large"

SQLSTATE: 54000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02992: "requested character too large for encoding: %d"

SQLSTATE: 54000

Description: The input string is too long.

Solution: Ensure that the input string is in Unicode format.

GAUSS-02993: "TIMESTAMP(%d)%s precision must not be negative"

SQLSTATE: 22023

Description: The precision of the timestamp type cannot be smaller than zero.

Solution: Check the precision of the timestamp type.

GAUSS-02994: "timestamp out of range: '%s'"

SQLSTATE: 22008

Description: The input timestamp value is out of range.

Solution: Check the timestamp value.

GAUSS-02995: "date/time value '%s' is no longer supported"

SQLSTATE: 0A000

Description: The string value to be converted to the timestamp type is incorrectly parsed.

Solution: Ensure that the format of the input string is correct. The string to be converted to the timestamp type must meet the format requirements in en-us_topic_0237121952.html. For details, see en-us_topic_0237121926.html.

GAUSS-02996: "unexpected dtype %d while parsing timestamp '%s'"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02997: "timestamp out of range"

SQLSTATE: 22008

Description: The input timestamp value is out of range.

Solution: Check whether the input timestamp value is valid. For the data value range, see en-us_topic_0237121926.html.

GAUSS-02998: "timestamp cannot be NaN"

SQLSTATE: 22008

Description: The data of timestamp type cannot be an unlimited value.

Solution: Check the input data.

GAUSS-02999: "smalldatetime out of range: '%s'"

SQLSTATE: 22008

Description: Data is out of range.

Solution: Check the input data.

GAUSS-03000: "unexpected dtype %d while parsing smalldatetime '%s'"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.