Bug 1302416

Summary: nova unable to delete floating-ip with neutron server error AttributeError: 'Query' object has no attribute 'one_or_none'
Product: [Community] RDO Reporter: David Moreau Simard <dmsimard>
Component: openstack-neutronAssignee: Ihar Hrachyshka <ihrachys>
Status: CLOSED CURRENTRELEASE QA Contact: Ofer Blaut <oblaut>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: trunkCC: apevec, chrisw, yeylon
Target Milestone: ---   
Target Release: trunk   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-03-30 23:04:28 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
/var/log/nova/nova-api.log
none
/var/log/neutron/server.log none

Description David Moreau Simard 2016-01-27 19:39:41 UTC 
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.
Comment 1 David Moreau Simard 2016-01-27 19:40:04 UTC 
Created attachment 1118861 [details]
/var/log/nova/nova-api.log
Comment 2 David Moreau Simard 2016-01-27 19:40:32 UTC 
Created attachment 1118862 [details]
/var/log/neutron/server.log
Comment 3 David Moreau Simard 2016-01-28 20:46:56 UTC 
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/
Comment 4 Ihar Hrachyshka 2016-03-24 14:58:49 UTC 
Patch in question was merged in rpm-master.