postgresql的相关服务端问题及解决方法

Caused by: org.postgresql.util.PSQLException: ERROR: connection to the remote node 10.20.30.195:5435 failed with the following error: could not fork new process for connection: Resource temporarily unavailable

服务器资源不足,可能是内存、linux共享内存段配置太低、overcommit超了或进程数。如:

CommitLimit:    199412136 kB
Committed_AS:   199564684 kB  # 接近limit时就可能提示资源临时不可用
### Cause: org.postgresql.util.PSQLException: ERROR: out of memory
  Detail: Failed on request of size 40364 in memory context "CacheMemoryContext".
  Where: while executing command on 10.20.30.217:5437
; SQL []; ERROR: out of memory

内存不足、linux共享内存段配置太低、overcommit超了。

2021-12-31 14:03:21.441691C [unknown] lightdb@findptdis 10.20.30.193(12146) client backend SELECT 57P01[2021-12-31 13:45:14 UTC] 0 [71437] ERROR:  terminating connection due to administrator command

服务器进程被正常或异常重启或停止或kill,包括具体的某个backend进程。

2PC未成功,回滚响应未收到,第二次重复回滚导致。

原文地址:https://www.cnblogs.com/zhjh256/p/15755773.html