Hi, > Hello, > > I'm maintain postgresql cluster with streaming replication for > php-based webapp. And for a few days I'm trying to get rid of errors in > my setup: > > Application server DB server > | PHP -> pgbouncer -> haproxy | -> | postgresql | > > pgbouncer pools connections from php (session-based) and haproxy > load-balance and failovering 3 backend postgresql servers. Every ~10 > min haproxy drops connection and pgbouncer reports: > > application logs: failed to execute the SQL statement: SQLSTATE[08P01]: > <<Unknown error>>: 7 ERROR: server conn crashed? > syslog: Mar 4 22:16:12 app1 pgbouncer[15572]: C-0x1d0c130: > mydb/pgsql@unix:5432 Pooler Error: server conn crashed? > > When I remove haproxy from this setup or change balancer to any other > tcp-balancer: balancer-ng for example everything works fine! > > I tried almost everything I can imagine: > - changing connection between php, pgbouncer and haproxy to tcp/ip or > unix-socket > - changing timeouts, conn lifetimes, keepalive, addition tcp options, > pool modes > - downgrading to older versions of pgbouncer and haproxy > - reduced number of TW-sockets by changing connectivity of other > components to unix-socket where possible > > Any ideas what to look for? > > software versions: > php5 5.4.23 > pgbouncer 1.5.4 > haproxy 1.5dev22
Whats the kernel release? > option splice-auto Try without splice. Enable logging and catch a failed request. Regards, Lukas
