Bug 1721909

Summary:	[OSP-15] Some unit tests are failing in D/S CI
Product:	Red Hat OpenStack	Reporter:	Slawek Kaplonski <skaplons>
Component:	openstack-neutron	Assignee:	Bernard Cafarelli <bcafarel>
Status:	CLOSED ERRATA	QA Contact:	Eran Kuris <ekuris>
Severity:	urgent	Docs Contact:
Priority:	high
Version:	15.0 (Stein)	CC:	amuller, bcafarel, chrisw, scohen
Target Milestone:	beta	Keywords:	AutomationBlocker, Triaged
Target Release:	15.0 (Stein)
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	openstack-neutron-14.0.2-0.20190621000417.fc8861d.el8	Doc Type:	No Doc Update
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2019-09-21 11:23:21 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:
Embargoed:

Comment 2 Bernard Cafarelli 2019-06-20 10:41:18 UTC

The 4 failing tests:
neutron.tests.unit.extensions.test_extraroute.ExtraRouteDBIntTestCase.test_floatingip_via_router_interface_returns_201
neutron.tests.unit.extensions.test_extraroute.ExtraRouteDBSepTestCase.test_floatingip_via_router_interface_returns_201
neutron.tests.unit.extensions.test_l3.L3NatDBIntTestCase.test_floatingip_via_router_interface_returns_201
neutron.tests.unit.extensions.test_l3.L3NatDBSepTestCase.test_floatingip_via_router_interface_returns_201

Similar traceback: testtools.matchers._impl.MismatchError: 201 != 500'

Manually running them adds some logs, the actual issue is queries not working with sqlalchemy 1.3:
sqlalchemy.exc.InvalidRequestError: Can't determine which FROM clause to join from, there are multiple FROMS which can join to this entity. Try adding an explicit ON clause to help resolve the ambiguity.

Comment 4 Slawek Kaplonski 2019-06-20 10:51:18 UTC

Hi Bernard,

SQLAlchemy error which You saw looks very similar to what I recently fixed in bagpipe repo: https://review.opendev.org/#/c/665637/ - it's probably the same problem in Neutron.

Comment 5 Bernard Cafarelli 2019-06-20 11:23:38 UTC

Another sqlalchemy restriction actually, but Rodolfo already had it handled in neutron https://review.opendev.org/#/c/649681
Backport in progress, then we should be all good here (I manually tested the fix and these 4 UT pass again with it as expected)

Comment 12 errata-xmlrpc 2019-09-21 11:23:21 UTC

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHEA-2019:2811