On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-02901 -- GAUSS-03000/ GAUSS-02951 -- GAUSS-02960

GAUSS-02951 -- GAUSS-02960

Updated on 2024-03-15 GMT+08:00

View PDF

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:

   
      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.

Parent topic: GAUSS-02901 -- GAUSS-03000

Previous topic: GAUSS-02941 -- GAUSS-02950

Next topic: GAUSS-02961 -- GAUSS-02970

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel