HAProxy in pfSense - TCP Connection craches after pfSense update from 24.11. to 25.07.01
-
Detailed Problem Description: Postgres server connection crashes in our environment. We have a Patroni cluster in a self-build network at Hetzner data centers. pgBouncer is used as connection pooler. A B2B web app connects to the cluster via the bouncer. Everything is managed and secured by redundant pfSense firewalls with HAProxy configuration. Since the last update of pfSense from version 24.11. to version 25.07.01, we get Postgres server connection crashes. Here is an excerpt from the pgBouncer logs:
2025-12-08 16:07:04.652 UTC [812] WARNING tls_sbufio_recv: read failed: error:0A000126:SSL routines::unexpected eof while reading 2025-12-08 16:07:04.652 UTC [812] LOG S-0x7aa64290fae0: oc_testeurope01_property_fc1640606c9144ca8426de04bc633567/backup@10.100.30.9:7432 closing because: server conn crashed? (age=6s) 2025-12-08 16:07:04.652 UTC [812] LOG C-0x5905f700e420: oc_testeurope01_property_fc1640606c9144ca8426de04bc633567/backup@10.100.30.19:62334 closing because: server conn crashed? (age=6s) 2025-12-08 16:07:04.652 UTC [812] WARNING C-0x5905f700e420: oc_testeurope01_property_fc1640606c9144ca8426de04bc633567/backup@10.100.30.19:62334 pooler error: server conn crashed?
This relates to our production systems (Fairmas offers B2B SaaS products for the Hotel Industry) and effects our user base. So this is business critical for us and we would really appreciate if you can help out here!
Platform: Whitebox/Other
Software Platform: pfSense
Software Version: pfSense Plus 25.07.1