[Openstack-operators] Openstack and mysql galera with haproxy

Abel Lopez alopgeek at gmail.com
Thu Sep 18 16:40:20 UTC 2014

I’ve seen that error, but not specifically with HAProxy (I was using an F5 at the time)

IIRC, the problem was with my connection checking.
I assume you’re doing something similar to this:

On Sep 18, 2014, at 9:29 AM, Sławek Kapłoński <slawek at kaplonski.pl> wrote:

> Hello,
> Is anyone here using openstack with mysql galera and haproxy? Have You got any 
> problems with that?
> I was today installed such ha infra for database (two mysql servers in galera 
> cluster and haproxy on controller and neutron node, this haproxy is connecting 
> to one of galera servers with round robin algorithm). Generally all is working 
> fine but I have few problems:
> 1. I have a lot of messages like: 
> WARNING neutron.openstack.common.db.sqlalchemy.session [-] Got mysql server 
> has gone away: (2006, 'MySQL server has gone away')
> 2. I have (most on neutron) many errors like:
> OperationalError: (OperationalError) (2013, 'Lost connection to MySQL server 
> during query') 'UPDATE ml2_port_bindings SET vif_type=%s, driver=%s, 
> segment=%s WHERE ml2_port_bindings.port_id =
> 3. Also errors:
> StaleDataError: UPDATE statement on table 'ports' expected to update 1 row(s); 
> 0 were matched.
> 4. and errors:
> DBDeadlock: (OperationalError) (1213, 'Deadlock found when trying to get lock; 
> try restarting transaction') 'UPDATE ipavailabilityranges SET first_ip=%s WHERE 
> ipavailabilityranges.allocation_pool_id =
> Sql queries in examples are "accidental" and same problem is with other 
> queries also (like deleting ports).
> Strange think is that those problems are not happend when I have one mysql 
> server and all was connecting to that one server. Do You have maybe same 
> problems? Do You know what can be a reason and solution for it?
> ---
> Best regards
> Sławek Kapłoński
> slawek at kaplonski.pl_______________________________________________
> OpenStack-operators mailing list
> OpenStack-operators at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 496 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20140918/6a7cfce4/attachment.pgp>

More information about the OpenStack-operators mailing list