Looks like I still could find it in one of the most recent CI runs we have [1]: Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation [None req-2317595a-64d5-47a0-9d4a-ba0f86acfbbf service kuryr] PUT failed.: 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)') Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: [SQL: INSERT INTO securitygroupportbindings (port_id, security_group_id) VALUES (%(port_id)s, %(security_group_id)s)] Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: [parameters: {'port_id': '5ee85680-0d39-4d40-b9c3-56179d1a27eb', 'security_group_id': '2ea191c7-588e-46b5-bd45-50447815cbd0'}] Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: (Background on this error at: https://sqlalche.me/e/14/gkpj) Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation Traceback (most recent call last): Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1771, in _execute_context Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation self.dialect.do_execute( Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 717, in do_execute Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation cursor.execute(statement, parameters) Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation result = self._query(query) Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation conn.query(q) Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation self._affected_rows = self._read_query_result(unbuffered=unbuffered) Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation result.read() Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation first_packet = self.connection._read_packet() Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation packet.raise_for_error() Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation err.raise_mysql_exception(self._data) Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation raise errorclass(errno, errval) Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: 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)') Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation The above exception was the direct cause of the following exception: Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation Traceback (most recent call last): Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pecan/core.py", line 683, in __call__ Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation self.invoke_controller(controller, args, kwargs, state) Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pecan/core.py", line 574, in invoke_controller Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation result = controller(*args, **kwargs) Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/neutron_lib/db/api.py", line 139, in wrapped Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation setattr(e, '_RETRY_EXCEEDED', True) Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_utils/excutils.py", line 227, in __exit__ Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise() Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_utils/excutils.py", line 200, in force_reraise Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation raise self.value Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/neutron_lib/db/api.py", line 135, in wrapped Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation return f(*args, **kwargs) Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_db/api.py", line 154, in wrapper Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation ectxt.value = e.inner_exc Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_utils/excutils.py", line 227, in __exit__ Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise() Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_utils/excutils.py", line 200, in force_reraise Aug 25 05:45:12.146325 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation raise self.value Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_db/api.py", line 142, in wrapper Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation return f(*args, **kwargs) Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/neutron_lib/db/api.py", line 183, in wrapped Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation LOG.debug("Retry wrapper got retriable exception: %s", e) Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_utils/excutils.py", line 227, in __exit__ Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise() Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_utils/excutils.py", line 200, in force_reraise Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation raise self.value Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/neutron_lib/db/api.py", line 179, in wrapped Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation return f(*dup_args, **dup_kwargs) Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/pecan_wsgi/controllers/utils.py", line 65, in wrapped Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation return f(*args, **kwargs) Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/pecan_wsgi/controllers/resource.py", line 74, in put Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation return {self.resource: self.plugin_updater(*updater_args)} Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/common/utils.py", line 686, in inner Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation return f(self, context, *args, **kwargs) Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/neutron_lib/db/api.py", line 218, in wrapped Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation return method(*args, **kwargs) Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/neutron_lib/db/api.py", line 139, in wrapped Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation setattr(e, '_RETRY_EXCEEDED', True) Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_utils/excutils.py", line 227, in __exit__ Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise() Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_utils/excutils.py", line 200, in force_reraise Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation raise self.value Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/neutron_lib/db/api.py", line 135, in wrapped Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation return f(*args, **kwargs) Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_db/api.py", line 154, in wrapper Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation ectxt.value = e.inner_exc Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_utils/excutils.py", line 227, in __exit__ Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise() Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_utils/excutils.py", line 200, in force_reraise Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation raise self.value Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_db/api.py", line 142, in wrapper Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation return f(*args, **kwargs) Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/neutron_lib/db/api.py", line 183, in wrapped Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation LOG.debug("Retry wrapper got retriable exception: %s", e) Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_utils/excutils.py", line 227, in __exit__ Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise() Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_utils/excutils.py", line 200, in force_reraise Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation raise self.value Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/neutron_lib/db/api.py", line 179, in wrapped Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation return f(*dup_args, **dup_kwargs) Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/plugins/ml2/plugin.py", line 1749, in update_port Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation need_port_update_notify |= self.update_security_group_on_port( Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/db/securitygroups_db.py", line 1042, in update_security_group_on_port Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation self._process_port_create_security_group( Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/db/securitygroups_db.py", line 904, in _process_port_create_security_group Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation self._create_port_security_group_binding(context, port['id'], Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/neutron_lib/db/api.py", line 218, in wrapped Aug 25 05:45:12.156812 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation return method(*args, **kwargs) Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/db/securitygroups_db.py", line 369, in _create_port_security_group_binding Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation context.session.add(db) Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python3.8/contextlib.py", line 120, in __exit__ Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation next(self.gen) Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1060, in _transaction_scope Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation yield resource Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python3.8/contextlib.py", line 120, in __exit__ Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation next(self.gen) Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 676, in _session Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation self.session.flush() Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 3298, in flush Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation self._flush(objects) Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 3438, in _flush Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation transaction.rollback(_capture_exception=True) Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation compat.raise_( Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 207, in raise_ Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation raise exception Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 3398, in _flush Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation flush_context.execute() Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation rec.execute(self) Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation util.preloaded.orm_persistence.save_obj( Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/persistence.py", line 242, in save_obj Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation _emit_insert_statements( Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/persistence.py", line 1094, in _emit_insert_statements Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation c = connection._execute_20( Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1583, in _execute_20 Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation return meth(self, args_10style, kwargs_10style, execution_options) Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation return connection._execute_clauseelement( Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1452, in _execute_clauseelement Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation ret = self._execute_context( Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1814, in _execute_context Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation self._handle_dbapi_exception( Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1993, in _handle_dbapi_exception Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation util.raise_(newraise, with_traceback=exc_info[2], from_=e) Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/compat.py", line 207, in raise_ Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation raise exception Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 1771, in _execute_context Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation self.dialect.do_execute( Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 717, in do_execute Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation cursor.execute(statement, parameters) Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 148, in execute Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation result = self._query(query) Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pymysql/cursors.py", line 310, in _query Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation conn.query(q) Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 548, in query Aug 25 05:45:12.165143 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation self._affected_rows = self._read_query_result(unbuffered=unbuffered) Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 775, in _read_query_result Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation result.read() Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 1156, in read Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation first_packet = self.connection._read_packet() Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pymysql/connections.py", line 725, in _read_packet Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation packet.raise_for_error() Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pymysql/protocol.py", line 221, in raise_for_error Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation err.raise_mysql_exception(self._data) Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/local/lib/python3.8/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation raise errorclass(errno, errval) Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: 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)') Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation [SQL: INSERT INTO securitygroupportbindings (port_id, security_group_id) VALUES (%(port_id)s, %(security_group_id)s)] Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation [parameters: {'port_id': '5ee85680-0d39-4d40-b9c3-56179d1a27eb', 'security_group_id': '2ea191c7-588e-46b5-bd45-50447815cbd0'}] Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation (Background on this error at: https://sqlalche.me/e/14/gkpj) Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: ERROR neutron.pecan_wsgi.hooks.translation Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: DEBUG neutron.pecan_wsgi.hooks.notifier [None req-2317595a-64d5-47a0-9d4a-ba0f86acfbbf service kuryr] No notification will be sent due to unsuccessful status code: 500 {{(pid=106098) after /opt/stack/neutron/neutron/pecan_wsgi/hooks/notifier.py:78}} Aug 25 05:45:12.187996 ubuntu-focal-inap-mtl01-0026083996 neutron-server[106098]: INFO neutron.wsgi [None req-2317595a-64d5-47a0-9d4a-ba0f86acfbbf service kuryr] 198.72.124.82,198.72.124.82 "PUT /v2.0/ports/5ee85680-0d39-4d40-b9c3-56179d1a27eb HTTP/1.1" status: 500 len: 368 time: 0.5060453 [1] https://storage.gra.cloud.ovh.net/v1/AUTH_dcaab5e32b234d56b626f72581e3644c/zuul_opendev_logs_0b6/803870/13/check/kuryr-kubernetes-e2e-np-ovn-provider-ovn/0b66322/controller/logs/screen-q-svc.txt