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

GAUSS-05171 -- GAUSS-05180

GAUSS-05171: "Abnormal data package received, package length is %d, input buffer length is %d"

SQLSTATE: None

Description: An abnormal data packet is received. The lengths of the data packet and the received buffer are displayed.

Solution: Ensure that the data file is correct.

GAUSS-05180: "encoding '%s' not supported by collation '%s'"

Description: The collation does not support the encoding of the current database.

Solution: Check the product documentation and select a sorting rule that supports the current encoding.

Example:

1
2
3
4
5
6
7
8
9
postgres=# CREATE DATABASE test_db ENCODING 'eucjis2004' LC_CTYPE='C' LC_COLLATE='C' template = template0;
CREATE DATABASE
postgres=# \c test_db
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "test_db" as user "jack".
test_db=# select 'a' collate case_insensitive;
ERROR:  encoding "EUC_JIS_2004" not supported by collation "case_insensitive"
LINE 1: select 'a' collate case_insensitive;
                   ^