← Back to team overview

yahoo-eng-team team mailing list archive

  1. yahoo-eng-team team
  2. Mailing list archive
  3. Message #06744

[Bug 1257815] [NEW] Internal server error while deleting subnet(can not find the rows in ipavailabilityranges table)

  Thread Previous • Date Previous • • Thread Next 
Public bug reported:

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'))

** Affects: neutron
     Importance: Undecided
         Status: New

-- 
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):
  New

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

Follow ups

References

  Thread Previous • Date Previous • • Thread Next