codehaus


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Galera and haproxy fail; keystone error 'Lost connection to MySQL server during query'


If I run galera without haproxy and point everything to 1 server, it seems to work fine, but we want to load-balance it with haproxy. After setting up haproxy we had lots of errors in nova, neutron and keystone, but I got rid of those by setting haproxy timeout values to 10 minutes. The remaining errors are in keystone. In /var/log/keystone/keystone-wsgi-public.log I see "Loaded 2 Fernet keys" every 5 minutes and this is frequently accompanied by a mysql error 'Lost connection to MySQL server during query'

I tried changing various config items in haproxy, galera and keystone, but nothing seems to help. How can I fix these errors?

Errors:
https://f.perl.bot/p/pbq26k
https://f.perl.bot/p/1tnh78
https://f.perl.bot/p/fuxmwo

Haproxy config:
https://f.perl.bot/p/gu2lil

Mysql timeout values:
https://f.perl.bot/p/i6l7tn

Keystone config (minus commented lines):
https://f.perl.bot/p/o6fdht
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20200207/cb037c5b/attachment.html>