yahoo-eng-team team mailing list archive
-
yahoo-eng-team team
-
Mailing list archive
-
Message #07242
[Bug 1257815] Re: Internal server error while deleting subnet(can not find the rows in ipavailabilityranges table)
not a tempest bug
** Changed in: tempest
Status: Incomplete => Invalid
--
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):
In Progress
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
References