Red Hat Bugzilla – Bug 1302416
nova unable to delete floating-ip with neutron server error AttributeError: 'Query' object has no attribute 'one_or_none'
Last modified: 2016-04-26 19:55:59 EDT
This problem manifested itself in CI jobs in delorean current mitaka tempest tests.
When attempting to delete a floating IP, nova-api will throw an internal error:
2016-01-27 18:48:04.735 32619 ERROR nova.api.openstack.extensions InternalServerError: Request Failed: internal server error while processing your request
This error originates from neutron, however:
2016-01-27 18:51:53.680 2397 ERROR neutron.api.v2.resource AttributeError: 'Query' object has no attribute 'one_or_none'
After speaking with ihrachys, it looks like we need to update sqlalchemy. The openstack-neutron specfile has "python-sqlalchemy >= 0.9.7" while upstream reqs.txt has ">=1.0.10".
Complete logs and configurations are available at: https://ci.centos.org/artifacts/rdo/weirdo-promote-mitaka-puppet-openstack-scenario001/13/puppet-openstack/logs/
Relevant stack traces are in attachment.
Created attachment 1118861 [details]
Created attachment 1118862 [details]
An updated version of sqlalchemy made it to the deps repo. I have submitted a review for the bump: https://review.gerrithub.io/#/c/261546/
Patch in question was merged in rpm-master.