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
相关产品推荐
相关产品推荐

