python-sqlalchemy ubuntu conflicts

[Eduardo Gonzalez]

Kolla master CI for ubuntu binary images has been broken for a few weeks.

Finally managed to find the root cause.

python-neutron-vpnaas and python-rally packages depend in python-sqlalchemy.

Both packages hardpin to python-sqlalchemy (<< 1.1) causing unresolvable dependencies while installing.

python-sqlalchemy package provided by ubuntu pike repository [0] is 1.1.9+ds1-0ubuntu1~cloud0

Sample gates logs [1]

[0] http://ubuntu-cloud.archive.canonical.com/ubuntu/dists/xenial-updates/pike/main/binary-amd64/Packages

[1 http://logs.openstack.org/77/469077/1/check/gate-kolla-dsvm-build-ubuntu-binary-ubuntu-xenial-nv/a6bcd77/logs/build/neutron-server.txt.gz

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/471285

[Eduardo Gonzalez (egonzalez90)]

Hi James, how long use to take ubuntu packaging to be published into xenial-updates/pike repository?. Still seeing rally failing.

Regards

[James Page (james-page)]

Should be there today.

[Eduardo Gonzalez (egonzalez90)]

Same issue found with ironic-inspector

[Launchpad Janitor (janitor)]

This bug was fixed in the package rally - 0.9.1-0ubuntu2

---------------
rally (0.9.1-0ubuntu2) artful; urgency=medium

  * d/p/drop-upper-bounds.patch: Drop upper bounds for six and sqla,
    resolving installability issues.

 -- James Page <email address hidden> Fri, 16 Jun 2017 10:20:15 +0100

[OpenStack Infra (hudson-openstack)]

Change abandoned by Eduardo Gonzalez (<email address hidden>) on branch: master
Review: https://review.openstack.org/471285
Reason: yep, was fixed in ubuntu repositoriees

[Eduardo Gonzalez (egonzalez90)]

Kolla is not affected by this issue by any of the packages. Marking as released