Comment 3 for bug 1490595

Revision history for this message
Roman Podoliaka (rpodolyaka) wrote : Re: Floating ip assigning failed with Error: (OperationalError) (1213, 'Deadlock found when trying to get lock; try restarting transaction') None None (HTTP 400)

Having said that, I think we should fix this on two sides:

1) on the OpenStack side we should make the services ready for Galera multi-master mode (i.e. retry all write on a potential deadlock error). Ideally we should achieve this by updating all the projects to use EngineFacade and implement this in oslo.db, rather then decorating every single DB API method

2) on the Fuel side we should figure out the best health check settings, so that HAProxy does not use one of the backup MySQL nodes, when the active node is really online (i.e. all existing connections remain opened and operational)

Also, this does not seems to be of High importance to me, as this is kind of an exceptional situation, which must be rare.