数据仓库服务 GAUSSDB(DWS)-连接GaussDB(DWS)数据库时,提示客户端连接数太多:问题现象

时间:2024-05-07 20:29:47

问题现象

连接GaussDB(DWS) 数据库时报错,提示客户端连接数太多。

  • 使用gsql等SQL客户端工具连接数据库时,出现如下所示的报错信息:
    1
    FATAL:  Already too many clients, active/non-active/reserved: 5/508/3.
    
  • 使用客户端并发连接数据库时,出现如下所示的报错信息:
    1
    2
    [2019/12/25 08:30:35] [ERROR] ERROR: pooler: failed to create connections in parallel mode for thread 140530192938752, Error Message: FATAL:  dn_6001_6002: Too many clients already, active/non-active: 468/63.
    FATAL:  dn_6001_6002: Too many clients already, active/non-active: 468/63.
    
support.huaweicloud.com/trouble-dws/dws_09_0038.html