You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

pgBouncer 1.17升级至1.18后查询取消触发致命错误求助

pgBouncer 1.18取消查询触发致命崩溃问题

将pgBouncer从1.17版本升级至1.18版本后,未修改任何配置,但执行取消查询操作时会触发致命错误导致服务崩溃,错误日志如下:

2023-02-23 03:29:32.097 UTC [27246] LOG started sending cancel request
2023-02-23 03:29:32.098 UTC [27246] FATAL @src/server.c:583 in function server_proto(): server_proto: server in bad state: 14

复现步骤

  • 通过psql连接pgBouncer
  • 执行长查询后发送取消请求

未修改的pgbouncer.ini配置文件

[databases]
%include /etc/pgbouncer/hosts.ini

[users]

[pgbouncer]
syslog = 1
ignore_startup_parameters = extra_float_digits ssl_renegotiation_limit
logfile = /var/log/postgresql/pgbouncer.log
pidfile = /var/run/postgresql/pgbouncer.pid
listen_addr = *
listen_port = 6432
unix_socket_dir = /var/run/postgresql
client_tls_sslmode=allow
client_tls_key_file =  /etc/letsencrypt/live/x/privkey.pem
client_tls_cert_file =  /etc/letsencrypt/live/x/fullchain.pem
server_tls_sslmode = verify-ca
server_tls_ca_file = /etc/azure.postgresql.pem
auth_type = plain
auth_file = /etc/pgbouncer/userlist.txt
admin_users = swpgbouncer
pool_mode = transaction
max_client_conn = 995
default_pool_size = 20

补充信息

  • pgBouncer 1.18运行在Ubuntu 18.04.6 LTS虚拟机上
  • Postgres版本为11,部署在Azure Database for PostgreSQL单服务器上

已查阅pgBouncer 1.18版本更新日志,但未找到相关原因,请问是否有遗漏的关键点?

内容的提问来源于stack exchange,提问作者dumbchemistry

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.07.30 22:45:29