WSREP deadlock is not properly wrapped

[Roman Podoliaka]

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.

I can see this on percona-xtradb-cluster-server version 5.7.14-26.17-1.jessie

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/oslo.db 4.13.5 release.

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/oslo.db 4.17.0 release.

[melanie witt (melwitt)]

For the records: this issue was fixed by https://review.opendev.org/c/openstack/oslo.db/+/409194