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

Reply via email to