The 4 failing tests:
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.
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.
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)
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.