Skip to content

[Bug/错误]: 使用 Postgres SQL 作为数据库在闲置页面一段时间后再次使用时似乎会连接池超限 #1459

Closed
Closed
[Bug/错误]: 使用 Postgres SQL 作为数据库在闲置页面一段时间后再次使用时似乎会连接池超限#1459
Labels
bugSomething isn't working
@Doraemonsan

Description

@Doraemonsan
Doraemonsan
opened on Apr 23, 2026

Pre-submission Checklist / 提交前检查

  • I have searched the existing issues and this bug has not been reported / 我已搜索现有 issues，此 Bug 尚未被报告
  • I have read the documentation / 我已阅读文档
  • I am using the latest version of AxonHub / 我正在使用 AxonHub 的最新版本

Bug Description / Bug 描述

闲置浏览器页面一段时间后再次回到页面中时 (请求页面似乎最容易出现，其他页面暂时不清楚)，页面下方中间位置会短暂弹出“内部服务器错误”，查看日志提示“server error: 致命错误: 对不起, 已经有太多的客户 (SQLSTATE 53300)”；实际上似乎并没有影响程序使用，短暂等待后尝试进入各个功能项目也都可以正常使用。考虑可能是数据库连接池设置的问题。

Steps to Reproduce / 复现步骤

  1. 打开 AxonHub 浏览器页面
  2. 切到其他标签页后闲置一段时间
  3. 再次回到 AxonHub 页面
  4. 页面下方中间位置会弹出一个气泡提示“内部服务器错误”

Expected Behavior / 期望行为

正常回到后台时页面以及后端不应该提示错误

Error Message / 错误消息

内部服务器错误

Operating System / 操作系统

Linux (Other) / Linux（其他）

AxonHub Version / AxonHub 版本

v0.9.35

Usage Scenario / 使用场景

Other / 其他

API Format / API 格式

N/A / 不适用

Channel Type / 渠道类型

N/A / 不适用

Logs / 日志

AxonHub：
4月 23 20:54:32 AxonHub axonhub[426660]: {"level":"INFO","time":"2026-04-23T20:54:32+08:00","logger":"axonhub","message":"cache refreshed","name":"axonhub:enabled_prompt_protection_rules","update_time":"0001-01-01T00:00:00Z","context_deadline":"2026-04-23T20:55:02+08:00"}
4月 23 20:54:35 AxonHub axonhub[426660]: {"level":"ERROR","time":"2026-04-23T20:54:35+08:00","logger":"axonhub","message":"[ACCESS]","status":200,"method":"POST","path":"/admin/graphql","latency":0.265850945,"client_ip":"2408:8266:3:7a62:2d78:9322:4dfc:13c4","operation":"GetRequests","errors":["input: requests.edges[45].node.executions.edges[0].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: 对不起, 已经有太多的客户 (SQLSTATE 53300)","input: requests.edges[33].node.executions.edges[0].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: 对不起, 已经有太多的客户 (SQLSTATE 53300)","input: requests.edges[39].node.executions.edges[1].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: 对不起, 已经有太多的客户 (SQLSTATE 53300)","input: requests.edges[41].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: remaining connection slots are reserved for roles with the SUPERUSER attribute (SQLSTATE 53300)","input: requests.edges[17].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: remaining connection slots are reserved for roles with the SUPERUSER attribute (SQLSTATE 53300)","input: requests.edges[46].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: 对不起, 已经有太多的客户 (SQLSTATE 53300)","input: requests.edges[27].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: remaining connection slots are reserved for roles with the SUPERUSER attribute (SQLSTATE 53300)","input: requests.edges[8].node.executions.edges[0].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: 对不起, 已经有太多的客户 (SQLSTATE 53300)","input: requests.edges[45].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: 对不起, 已经有太多的客户 (SQLSTATE 53300)","input: requests.edges[28].node.executions.edges[0].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: remaining connection slots are reserved for roles with the SUPERUSER attribute (SQLSTATE 53300)","input: requests.edges[12].node.executions.edges[0].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: remaining connection slots are reserved for roles with the SUPERUSER attribute (SQLSTATE 53300)","input: requests.edges[42].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: remaining connection slots are reserved for roles with the SUPERUSER attribute (SQLSTATE 53300)","input: requests.edges[35].node.executions.edges[0].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: 对不起, 已经有太多的客户 (SQLSTATE 53300)","input: requests.edges[39].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: 对不起, 已经有太多的客户 (SQLSTATE 53300)","input: requests.edges[37].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: 对不起, 已经有太多的客户 (SQLSTATE 53300)","input: requests.edges[13].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: remaining connection slots are reserved for roles with the SUPERUSER attribute (SQLSTATE 53300)","input: requests.edges[13].node.executions.edges[0].node.channel failed to load channel: failed to connect to `user=axonhub database=axonhub`:\n\t**.**.**.**:5432 (**.**.**.**): tls error: server refused TLS connection\n\t**.**.**.**:5432 (**.**.**.**): server error: 致命错误: remaining connection slots are reserved for roles with the SUPERUSER attribute (SQLSTATE 53300)"],"context_error":"context canceled","context_deadline":"2026-04-23T20:55:05+08:00","trace_id":"at-5b608c9b-8e33-40ad-8a3c-a72d65c4184a","request_id":"ar-f7a17b1f-6f80-4905-8cdd-ef5626e9b0cf","operation_name":"GetRequests"}
4月 23 20:55:02 AxonHub axonhub[426660]: {"level":"INFO","time":"2026-04-23T20:55:02+08:00","logger":"axonhub","message":"cache refreshed","name":"axonhub:enabled_prompt_protection_rules","update_time":"0001-01-01T00:00:00Z","context_deadline":"2026-04-23T20:55:32+08:00"}

————————————————————————————————————————————————————————————————————————————————————————

PostgresSQL：
2026-04-23 20:46:21.131 CST [205] 日志:  checkpoint starting: time
2026-04-23 20:46:21.470 CST [205] 日志:  checkpoint complete: wrote 3 buffers (0.0%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.312 s, sync=0.009 s, total=0.340 s; sync files=4, longest=0.003 s, average=0.003 s; distance=7 kB, estimate=373 kB; lsn=0/66836330, redo lsn=0/668362D8
2026-04-23 20:54:35.756 CST [274056] 致命错误:  对不起, 已经有太多的客户
2026-04-23 20:54:35.757 CST [274036] 致命错误:  对不起, 已经有太多的客户
2026-04-23 20:54:35.757 CST [273996] 致命错误:  remaining connection slots are reserved for roles with the SUPERUSER attribute
2026-04-23 20:54:35.757 CST [274057] 致命错误:  对不起, 已经有太多的客户
2026-04-23 20:54:35.757 CST [273965] 致命错误:  remaining connection slots are reserved for roles with the SUPERUSER attribute
2026-04-23 20:54:35.758 CST [274022] 致命错误:  remaining connection slots are reserved for roles with the SUPERUSER attribute
2026-04-23 20:54:35.758 CST [274051] 致命错误:  对不起, 已经有太多的客户
2026-04-23 20:54:35.758 CST [274037] 致命错误:  对不起, 已经有太多的客户
2026-04-23 20:54:35.758 CST [274052] 致命错误:  对不起, 已经有太多的客户
2026-04-23 20:54:35.759 CST [274034] 致命错误:  对不起, 已经有太多的客户
2026-04-23 20:54:35.759 CST [274053] 致命错误:  对不起, 已经有太多的客户
2026-04-23 20:54:35.760 CST [274054] 致命错误:  对不起, 已经有太多的客户
2026-04-23 20:54:35.760 CST [274032] 致命错误:  remaining connection slots are reserved for roles with the SUPERUSER attribute
2026-04-23 20:54:35.762 CST [273980] 致命错误:  remaining connection slots are reserved for roles with the SUPERUSER attribute
2026-04-23 20:54:35.762 CST [274003] 致命错误:  remaining connection slots are reserved for roles with the SUPERUSER attribute
2026-04-23 20:54:35.766 CST [273985] 致命错误:  remaining connection slots are reserved for roles with the SUPERUSER attribute
2026-04-23 20:54:35.769 CST [273984] 致命错误:  remaining connection slots are reserved for roles with the SUPERUSER attribute

Additional Context / 其他补充信息

  1. 考虑到我的运行环境在同一个 PostgresSQL 实例中运行了多个数据库，实际可用的连接池可能比独立 PostgresSQL 实例更少
  2. 缓存配置为two-level

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions