yahoo-eng-team team mailing list archive

[Alan Pevec <1235486@xxxxxxxxxxxxxxxxxx>]

** 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