** 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/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 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
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
