yahoo-eng-team team mailing list archive

[Launchpad Bug Tracker <1257815@xxxxxxxxxxxxxxxxxx>]

You have been subscribed to a public bug:

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

-- 
Internal server error while deleting subnet(can not find the rows  in ipavailabilityranges  table)
https://bugs.launchpad.net/bugs/1257815
You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron.