Updated on 2023-12-22 GMT+08:00

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 %s", (%s can be comparison, hashing, or searching)

SQLSTATE: 42P22

Description: Collations conflict. The parser cannot determine which collation to use.

Solution: Check whether there are multiple collations in the current string for comparison. Manually specify COLLATE collation_name.

Example:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
postgres=# select a=b from t8;
ERROR:  could not determine which collation to use for string comparison
HINT:  Use the COLLATE clause to set the collation explicitly.
postgres=# select hashtext(ifnull(a,b)) from t8;
ERROR:  could not determine which collation to use for string hashing
HINT:  Use the COLLATE clause to set the collation explicitly.
CONTEXT:  referenced column: hashtext
postgres=# select instr(a,b) from t8;
ERROR:  could not determine which collation to use for string searching
HINT:  Use the COLLATE clause to set the collation explicitly.
CONTEXT:  referenced column: instr

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

SQLSTATE: XX000

Description: The string cannot be converted to the UTF-16 format.

Solution: Determine how to handle the problem based on the value of error code.

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

SQLSTATE: XX000

Description: The string cannot be converted to the Unicode format.

Solution: Check the incorrect string and correct it.

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 the index value is within the valid length range of a bytea string.

GAUSS-02956: "invalid name syntax"

SQLSTATE: 42602

Description: Strings cannot be divided into delimited string groups.

Solution: Check the input string.

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

SQLSTATE: 2201B

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

Solution: Check the input parameters for string search.

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.