yahoo-eng-team team mailing list archive

[Alan Pevec <1257815@xxxxxxxxxxxxxxxxxx>]

** Also affects: neutron/havana
   Importance: Undecided
       Status: New

** Changed in: neutron/havana
       Status: New => Fix Committed

** Changed in: neutron/havana
    Milestone: None => 2013.2.4

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1257815

Title:
  Internal server error while deleting subnet(can not find the rows  in
  ipavailabilityranges  table)

Status in OpenStack Neutron (virtual network service):
  Fix Released
Status in neutron havana series:
  Fix Committed
Status in Tempest:
  Invalid

Bug description:
  when trying to delete a subnet, sometimes the following error comes out.
  Icehouse, Database  in use is DB2, but I guess it might happen for other databases too.

  
  ================================
  2013-12-04 03:49:48.275 26604 TRACE neutron.plugins.ml2.plugin
  2013-12-04 03:49:48.277 26604 ERROR neutron.api.v2.resource [req-e8e78c50-25b0-4e19-b5f0-796041d7b464 f53f4f5b40154ad6b1ec1ac08f88ecf2 b93ff0
  8b44da407185a26033768101f5] NT-C3C9C57 delete failed
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource Traceback (most recent call last):
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource   File "/usr/lib/python2.6/site-packages/neutron/api/v2/resource.py", line 84, in resource
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource     result = method(request=request, **args)
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource   File "/usr/lib/python2.6/site-packages/neutron/api/v2/base.py", line 432, in delete
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource     obj_deleter(request.context, id, **kwargs)
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource   File "/usr/lib/python2.6/site-packages/neutron/plugins/ml2/plugin.py", line 443
  , in delete_network
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource     self.delete_subnet(context, subnet.id)
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource   File "/usr/lib/python2.6/site-packages/neutron/plugins/ml2/plugin.py", line 530, in delete_subnet
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource     break
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource   File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/session.py", line 449,in __exit__
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource     self.commit()
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource   File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/session.py", line 361, in commit
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource     self._prepare_impl()
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource   File "/usr/lib64/python2.6/site-packages/sqlalchemy/orm/session.py", line 340,in _prepare_impl
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource     self.session.flush()
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource   File "/usr/lib/python2.6/site-packages/neutron/openstack/common/db/sqlalchemy/session.py", line 545, in _wrap
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource     raise exception.DBError(e)
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource DBError: (Error) ibm_db_dbi::Error:
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource Error 1: [IBM][CLI Driver][DB2/LINUXX8664] SQL0100W  No row was found for FETCH,UPDATE or DELETE; or the result of a query is an empty table.  SQLSTATE=02000 SQLCODE=100
  2013-12-04 03:49:48.277 26604 TRACE neutron.api.v2.resource  'DELETE FROM ipavailabilityranges WHERE ipavailabilityranges.allocation_pool_id= ? AND ipavailabilityranges.first_ip = ? AND ipavailabilityranges.last_ip = ?' (('e376f33d-a224-4468-91eb-82191e158726', '10.100.0.2', '10.100.0.2'), ('e376f33d-a224-4468-91eb-82191e158726', '10.100.0.4', '10.100.0.14'))

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1257815/+subscriptions