Hi, On Wed, Oct 15, Dennis Plöger | getit GmbH wrote: > Hi! > > > Hmm... I just understood, that we're probably talking about different things > > here. As you can see in my configuration, I haven't specify a maxconn value. > > From the configuration documentation I didn't understand, what the default > > value is. I just updated my configuration based on this tutorial and will > > try > > again: > > http://www.percona.com/doc/percona-xtradb-cluster/5.5/howtos/haproxy.html > > Same error (nothing in the logs however). My haproxy.cfg now looks like this: > option dontlognull
Are you using any kind of connection pool on hybis/jdbc ? (Hybris opens/keeps open multiple connections and reuses the open connection). Does the connection pool do any connection checking (periodically checks that the connection is still alive) ? (Maybe pool opens connections that sit idle for too long -> haproxy closes idle connection (50s?)) Maybe try with "no option dontlognull" ? Are all connections in logs logged with "normal --" session state ? http://cbonte.github.io/haproxy-dconv/configuration-1.5.html#8.5 -Jarno > retries 3 > option redispatch > maxconn 2000 > timeout connect 50000 > timeout client 50000 > timeout server 50000 > > listen mysql-cluster 127.0.0.1:3306 > mode tcp > balance roundrobin > option httpchk > server shopclusterdb1 10.10.42.82:3306 check port 9200 inter 12000 > rise 3 fall 3 > server shopclusterdb2 10.10.42.83:3306 check port 9200 inter 12000 > rise 3 fall 3 backup > > Kind regards > > Dennis > > -- > Dennis Plöger > Systemadministrator und Berater > > ------ > Besuchen Sie uns auf unseren nächsten Veranstaltungen: > - konaktiva, 11.11.2014, Halle 3 B / Stand G4 (Westfalenhallen), Dortmund > ------ > > getit - Gesellschaft für Technologie- und Informationstransfer mbH > Emil-Figge-Straße 76-80 > 44227 Dortmund > > Tel: +49.231.9742.355 > Fax: +49.231.9742.356 > http://www.getit.de > > Amtsgericht Dortmund, HRB-Nr. 26548 > > Geschäftsführung: > Dr. Thomas Krämerkämper (Vorsitzender) > Christoph Hecker -- Jarno Huuskonen
