A little update, this can happen on port operations as well. Full log: https://7494b51f1867d83e2df3-c514cadbc1265d8f1c8d131346aa619b.ssl.cf5.rackcdn.com/748262/3/check/kuryr-kubernetes-e2e-np-containerized-ovn-provider-ovn/1a7daa6/controller/logs/screen-q-svc.txt Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation Traceback (most recent call last): Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation cursor, statement, parameters, context Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/default.py", line 593, in do_execute Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation cursor.execute(statement, parameters) Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pymysql/cursors.py", line 163, in execute Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation result = self._query(query) Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pymysql/cursors.py", line 321, in _query Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation conn.query(q) Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 505, in query Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation self._affected_rows = self._read_query_result(unbuffered=unbuffered) Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 724, in _read_query_result Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation result.read() Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 1069, in read Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation first_packet = self.connection._read_packet() Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 676, in _read_packet Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation packet.raise_for_error() Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pymysql/protocol.py", line 223, in raise_for_error Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation err.raise_mysql_exception(self._data) Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation raise errorclass(errno, errval) Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation pymysql.err.IntegrityError: (1452, 'Cannot add or update a child row: a foreign key constraint fails (`neutron`.`securitygroupportbindings`, CONSTRAINT `securitygroupportbindings_ibfk_1` FOREIGN KEY (`port_id`) REFERENCES `ports` (`id`) ON DELETE CASCADE)') Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation The above exception was the direct cause of the following exception: Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation Traceback (most recent call last): Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pecan/core.py", line 683, in __call__ Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation self.invoke_controller(controller, args, kwargs, state) Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pecan/core.py", line 574, in invoke_controller Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation result = controller(*args, **kwargs) Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/neutron_lib/db/api.py", line 139, in wrapped Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation setattr(e, '_RETRY_EXCEEDED', True) Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_utils/excutils.py", line 220, in __exit__ Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise() Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation six.reraise(self.type_, self.value, self.tb) Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/six.py", line 703, in reraise Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation raise value Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/neutron_lib/db/api.py", line 135, in wrapped Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation return f(*args, **kwargs) Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_db/api.py", line 154, in wrapper Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation ectxt.value = e.inner_exc Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_utils/excutils.py", line 220, in __exit__ Sep 03 09:17:29.978599 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise() Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation six.reraise(self.type_, self.value, self.tb) Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/six.py", line 703, in reraise Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation raise value Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_db/api.py", line 142, in wrapper Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation return f(*args, **kwargs) Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/neutron_lib/db/api.py", line 183, in wrapped Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation LOG.debug("Retry wrapper got retriable exception: %s", e) Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_utils/excutils.py", line 220, in __exit__ Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise() Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation six.reraise(self.type_, self.value, self.tb) Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/six.py", line 703, in reraise Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation raise value Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/neutron_lib/db/api.py", line 179, in wrapped Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation return f(*dup_args, **dup_kwargs) Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/pecan_wsgi/controllers/utils.py", line 76, in wrapped Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation return f(*args, **kwargs) Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/pecan_wsgi/controllers/resource.py", line 74, in put Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation return {self.resource: self.plugin_updater(*updater_args)} Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/common/utils.py", line 687, in inner Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation return f(self, context, *args, **kwargs) Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/neutron_lib/db/api.py", line 233, in wrapped Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation return method(*args, **kwargs) Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/neutron_lib/db/api.py", line 139, in wrapped Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation setattr(e, '_RETRY_EXCEEDED', True) Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_utils/excutils.py", line 220, in __exit__ Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise() Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation six.reraise(self.type_, self.value, self.tb) Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/six.py", line 703, in reraise Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation raise value Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/neutron_lib/db/api.py", line 135, in wrapped Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation return f(*args, **kwargs) Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_db/api.py", line 154, in wrapper Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation ectxt.value = e.inner_exc Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_utils/excutils.py", line 220, in __exit__ Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise() Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation six.reraise(self.type_, self.value, self.tb) Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/six.py", line 703, in reraise Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation raise value Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_db/api.py", line 142, in wrapper Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation return f(*args, **kwargs) Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/neutron_lib/db/api.py", line 183, in wrapped Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation LOG.debug("Retry wrapper got retriable exception: %s", e) Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_utils/excutils.py", line 220, in __exit__ Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise() Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation six.reraise(self.type_, self.value, self.tb) Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/six.py", line 703, in reraise Sep 03 09:17:29.982528 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation raise value Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/neutron_lib/db/api.py", line 179, in wrapped Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation return f(*dup_args, **dup_kwargs) Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/plugins/ml2/plugin.py", line 1673, in update_port Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation context, id, port, original_port, updated_port) Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/db/securitygroups_db.py", line 966, in update_security_group_on_port Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation sgs) Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/db/securitygroups_db.py", line 832, in _process_port_create_security_group Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation sg.id) Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/neutron_lib/db/api.py", line 233, in wrapped Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation return method(*args, **kwargs) Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/db/securitygroups_db.py", line 354, in _create_port_security_group_binding Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation context.session.add(db) Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python3.6/contextlib.py", line 88, in __exit__ Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation next(self.gen) Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1064, in _transaction_scope Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation yield resource Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python3.6/contextlib.py", line 88, in __exit__ Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation next(self.gen) Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 680, in _session Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation self.session.flush() Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/orm/session.py", line 2523, in flush Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation self._flush(objects) Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/orm/session.py", line 2664, in _flush Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation transaction.rollback(_capture_exception=True) Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/langhelpers.py", line 69, in __exit__ Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation exc_value, with_traceback=exc_tb, Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 182, in raise_ Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation raise exception Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/orm/session.py", line 2624, in _flush Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation flush_context.execute() Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation rec.execute(self) Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/orm/unitofwork.py", line 589, in execute Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation uow, Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation insert, Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/orm/persistence.py", line 1083, in _emit_insert_statements Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation c = cached_connections[connection].execute(statement, multiparams) Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1011, in execute Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation return meth(self, multiparams, params) Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation return connection._execute_clauseelement(self, multiparams, params) Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation distilled_params, Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1317, in _execute_context Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation e, statement, parameters, cursor, context Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1508, in _handle_dbapi_exception Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation util.raise_(newraise, with_traceback=exc_info[2], from_=e) Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 182, in raise_ Sep 03 09:17:29.989044 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation raise exception Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation cursor, statement, parameters, context Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/default.py", line 593, in do_execute Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation cursor.execute(statement, parameters) Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pymysql/cursors.py", line 163, in execute Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation result = self._query(query) Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pymysql/cursors.py", line 321, in _query Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation conn.query(q) Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 505, in query Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation self._affected_rows = self._read_query_result(unbuffered=unbuffered) Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 724, in _read_query_result Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation result.read() Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 1069, in read Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation first_packet = self.connection._read_packet() Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 676, in _read_packet Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation packet.raise_for_error() Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pymysql/protocol.py", line 223, in raise_for_error Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation err.raise_mysql_exception(self._data) Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.6/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation raise errorclass(errno, errval) Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation oslo_db.exception.DBReferenceError: (pymysql.err.IntegrityError) (1452, 'Cannot add or update a child row: a foreign key constraint fails (`neutron`.`securitygroupportbindings`, CONSTRAINT `securitygroupportbindings_ibfk_1` FOREIGN KEY (`port_id`) REFERENCES `ports` (`id`) ON DELETE CASCADE)') Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation [SQL: INSERT INTO securitygroupportbindings (port_id, security_group_id) VALUES (%(port_id)s, %(security_group_id)s)] Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation [parameters: {'port_id': '92e6800d-2472-4251-b928-acc8e45b972f', 'security_group_id': '49399f78-5df1-4619-8fdc-f94e7cc1c552'}] Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation (Background on this error at: http://sqlalche.me/e/13/gkpj) Sep 03 09:17:29.996697 ubuntu-bionic-rax-dfw-0019616233 neutron-server[10691]: ERROR neutron.pecan_wsgi.hooks.translation