** Also affects: neutron/havana Importance: Undecided Status: New
** Changed in: neutron/havana Status: New => Fix Committed ** Changed in: neutron/havana Importance: Undecided => High ** Changed in: neutron/havana Assignee: (unassigned) => Armando Migliaccio (armando-migliaccio) ** Changed in: neutron Assignee: Robert Kukura (rkukura) => Armando Migliaccio (armando-migliaccio) ** Changed in: neutron Milestone: 2013.2.1 => icehouse-2 ** Changed in: neutron/havana Milestone: None => 2013.2.1 ** Changed in: neutron Milestone: icehouse-2 => icehouse-1 ** Changed in: neutron Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1235486 Title: Integrity violation on delete network Status in OpenStack Neutron (virtual network service): Fix Released Status in neutron havana series: Fix Committed Bug description: Found while running tests for bug 1224001. Full logs here: http://logs.openstack.org/24/49424/13/check/check-tempest-devstack-vm-neutron-pg-isolated/405d3b4 Keeping to medium priority for now. Will raise priority if we found more occurrences. 2013-10-04 21:20:46.888 31438 ERROR neutron.api.v2.resource [-] delete failed 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource Traceback (most recent call last): 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource File "/opt/stack/new/neutron/neutron/api/v2/resource.py", line 84, in resource 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource result = method(request=request, **args) 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource File "/opt/stack/new/neutron/neutron/api/v2/base.py", line 432, in delete 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource obj_deleter(request.context, id, **kwargs) 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource File "/opt/stack/new/neutron/neutron/plugins/ml2/plugin.py", line 411, in delete_network 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource break 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 456, in __exit__ 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource self.commit() 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 368, in commit 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource self._prepare_impl() 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 347, in _prepare_impl 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource self.session.flush() 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource File "/opt/stack/new/neutron/neutron/openstack/common/db/sqlalchemy/session.py", line 542, in _wrap 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource raise exception.DBError(e) 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource DBError: (IntegrityError) update or delete on table "networks" violates foreign key constraint "ports_network_id_fkey" on table "ports" 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource DETAIL: Key (id)=(c63057f4-8d8e-497c-95d6-0d93d2cc83f5) is still referenced from table "ports". 2013-10-04 21:20:46.888 31438 TRACE neutron.api.v2.resource 'DELETE FROM networks WHERE networks.id = %(id)s' {'id': u'c63057f4-8d8e-497c-95d6-0d93d2cc83f5'} To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1235486/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp