WSREP deadlock is not properly wrapped

Bug #1648817 reported by Roman Podoliaka
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
oslo.db
Confirmed
Medium
Roman Podoliaka

Bug Description

Neutron fails with the following error:

2016-12-09 11:23:38.206 34 ERROR neutron.api.v2.resource File "/var/lib/microservices/venv/local/lib/python2.7/site-packages/pymysql/connections.py", line 1285, in read
2016-12-09 11:23:38.206 34 ERROR neutron.api.v2.resource first_packet = self.connection._read_packet()
2016-12-09 11:23:38.206 34 ERROR neutron.api.v2.resource File "/var/lib/microservices/venv/local/lib/python2.7/site-packages/pymysql/connections.py", line 966, in _read_packet
2016-12-09 11:23:38.206 34 ERROR neutron.api.v2.resource packet.check_error()
2016-12-09 11:23:38.206 34 ERROR neutron.api.v2.resource File "/var/lib/microservices/venv/local/lib/python2.7/site-packages/pymysql/connections.py", line 394, in check_error
2016-12-09 11:23:38.206 34 ERROR neutron.api.v2.resource err.raise_mysql_exception(self._data)
2016-12-09 11:23:38.206 34 ERROR neutron.api.v2.resource File "/var/lib/microservices/venv/local/lib/python2.7/site-packages/pymysql/err.py", line 120, in raise_mysql_exception
2016-12-09 11:23:38.206 34 ERROR neutron.api.v2.resource _check_mysql_exception(errinfo)
2016-12-09 11:23:38.206 34 ERROR neutron.api.v2.resource File "/var/lib/microservices/venv/local/lib/python2.7/site-packages/pymysql/err.py", line 115, in _check_mysql_exception
2016-12-09 11:23:38.206 34 ERROR neutron.api.v2.resource raise InternalError(errno, errorvalue)
2016-12-09 11:23:38.206 34 ERROR neutron.api.v2.resource DBError: (pymysql.err.InternalError) (1213, u'WSREP detected deadlock/conflict and aborted the transaction. Try restarting the transaction') [SQL: u'SELECT ml2_port_bindings.port_id AS ml2_port_bindings_port_id, ml2_port_bindings.host AS ml2_port_bindings_host, ml2_port_bindings.vnic_type AS ml2_port_bindings_vnic_type, ml2_port_bindings.profile AS ml2_port_bindings_profile, ml2_port_bindings.vif_type AS ml2_port_bindings_vif_type, ml2_port_bindings.vif_details AS ml2_port_bindings_vif_details \nFROM ml2_port_bindings \nWHERE ml2_port_bindings.port_id = %(port_id_1)s FOR UPDATE'] [parameters: {u'port_id_1': u'6484c7d0-71c8-48c2-9494-c9c41782d6d2'}]

^ which basically means InternalError was not properly wrapped for this MySQL/Galera version.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.