更新时间:2024-01-16 GMT+08:00

GAUSS-05171 -- GAUSS-05180

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

SQLSTATE:无

错误原因:接收到异常的数据包,数据包的长度为xx,接收buffer的长度为xx。

解决办法:请检查数据文件,确保数据文件没有问题。

GAUSS-05180: “encoding ‘%s’ not supported by collation ‘%s’”

错误原因:排序规则不支持当前数据库的字符编码。

解决办法:查阅产品文档,选择支持当前字符编码的排序规则。

示例:

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;
                   ^