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.
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 api.v2. resource first_packet = self.connection ._read_ packet( ) api.v2. resource File "/var/lib/ microservices/ venv/local/ lib/python2. 7/site- packages/ pymysql/ connections. py", line 966, in _read_packet api.v2. resource packet. check_error( ) api.v2. resource File "/var/lib/ microservices/ venv/local/ lib/python2. 7/site- packages/ pymysql/ connections. py", line 394, in check_error api.v2. resource err.raise_ mysql_exception (self._ data) api.v2. resource File "/var/lib/ microservices/ venv/local/ lib/python2. 7/site- packages/ pymysql/ err.py" , line 120, in raise_mysql_ exception api.v2. resource _check_ mysql_exception (errinfo) api.v2. resource File "/var/lib/ microservices/ venv/local/ lib/python2. 7/site- packages/ pymysql/ err.py" , line 115, in _check_ mysql_exception api.v2. resource raise InternalError( errno, errorvalue) api.v2. resource DBError: (pymysql. err.InternalErr or) (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-c9c41782d6 d2'}]
2016-12-09 11:23:38.206 34 ERROR neutron.
2016-12-09 11:23:38.206 34 ERROR neutron.
2016-12-09 11:23:38.206 34 ERROR neutron.
2016-12-09 11:23:38.206 34 ERROR neutron.
2016-12-09 11:23:38.206 34 ERROR neutron.
2016-12-09 11:23:38.206 34 ERROR neutron.
2016-12-09 11:23:38.206 34 ERROR neutron.
2016-12-09 11:23:38.206 34 ERROR neutron.
2016-12-09 11:23:38.206 34 ERROR neutron.
2016-12-09 11:23:38.206 34 ERROR neutron.
^ which basically means InternalError was not properly wrapped for this MySQL/Galera version.