upstream tripleo jobs using os_tempest failing with ERROR: No matching distribution found for oslo.db===7.0.0

[chandan kumar]

upstream tripleo jobs using os_tempest failing with ERROR: No matching distribution found for oslo.db===7.0.0 while installing stackviz.

https://github.com/openstack/openstack-ansible-os_tempest/blob/master/defaults/main.yml#L331 is enabled by default and https://opendev.org/openstack/tripleo-quickstart-extras/src/branch/master/playbooks/tempest.yml#L55 is installed in venv.

It is pulling pip deps from upstream constriants and upstream has removed python2 support form oslo.db leading to failure.

https://8b9b13e3efb7f9665607-81643e490252b5c512a6329ac6b46eb6.ssl.cf2.rackcdn.com/703580/1/gate/tripleo-ci-centos-7-standalone/7f1dc5e/job-output.txt

2020-02-06 05:57:34.042892 | primary | Downloading http://mirror.regionone.limestone.openstack.org/pypifiles/packages/af/47/35edeb0f86c0b44934c05d961c893e223ef27e79e1f53b5e6f14820ff553/SQLAlchemy-1.3.13.tar.gz (6.0 MB)
2020-02-06 05:57:34.042931 | primary |
2020-02-06 05:57:34.043274 | primary | :stderr: DEPRECATION: Python 2.7 reached the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 is no longer maintained. A future version of pip will drop support for Python 2.7. More details about Python 2 support in pip, can be found at https://pip.pypa.io/en/latest/development/release-process/#python-2-support
2020-02-06 05:57:34.044234 | primary | ERROR: Could not find a version that satisfies the requirement oslo.db===7.0.0 (from -c https://releases.openstack.org/constraints/upper/master (line 621)) (from versions: 0.1.0, 0.2.0, 0.3.0, 0.4.0, 0.5.0, 1.0.0, 1.0.1, 1.0.2, 1.0.3, 1.1.0, 1.2.0, 1.3.0, 1.4.0, 1.4.1, 1.5.0, 1.6.0, 1.7.0, 1.7.1, 1.7.2, 1.7.3, 1.7.4, 1.7.5, 1.8.0, 1.9.0, 1.10.0, 1.11.0, 1.12.0, 2.0.0, 2.1.0, 2.2.0, 2.3.0, 2.4.0, 2.4.1, 2.5.0, 2.6.0, 3.0.0, 3.1.0, 3.2.0, 4.0.0, 4.1.0, 4.2.0, 4.3.0, 4.3.1, 4.4.0, 4.5.0, 4.6.0, 4.7.0, 4.7.1, 4.8.0, 4.9.0, 4.10.0, 4.11.0, 4.12.0, 4.13.0, 4.13.1, 4.13.2, 4.13.3, 4.13.4, 4.13.5, 4.13.6, 4.14.0, 4.15.0, 4.16.0, 4.17.0, 4.17.1, 4.18.0, 4.19.0, 4.20.0, 4.21.0, 4.21.1, 4.22.0, 4.23.0, 4.24.0, 4.24.1, 4.25.0, 4.25.1, 4.25.2, 4.26.0, 4.27.0, 4.28.0, 4.29.0, 4.30.0, 4.31.0, 4.32.0, 4.33.0, 4.33.1, 4.33.2, 4.33.3, 4.33.4, 4.34.0, 4.35.0, 4.36.0, 4.37.0, 4.38.0, 4.39.0, 4.40.0, 4.40.1, 4.40.2, 4.41.0, 4.41.1, 4.42.0, 4.43.0, 4.44.0, 4.45.0, 4.46.0, 5.0.0, 5.0.1, 5.0.2, 5.1.0, 5.1.1, 6.0.0)
2020-02-06 05:57:34.044406 | primary | ERROR: No matching distribution found for oslo.db===7.0.0 (from -c https://releases.openstack.org/constraints/upper/master (line 621))

Disabling it for centos7 jobs will fix the issue temprorly.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.opendev.org/706196

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/706196
Committed: https://git.openstack.org/cgit/openstack/tripleo-quickstart-extras/commit/?id=bb5afff49caa54a9eb67a9ab88d71b94bcc4a39b
Submitter: Clark Boylan (<email address hidden>)
Branch: master

commit bb5afff49caa54a9eb67a9ab88d71b94bcc4a39b
Author: Pavel Sedlák <email address hidden>
Date: Thu Feb 6 09:28:57 2020 +0100

    Disable stackviz for tempest on python2

    stackviz installed for tempest in virtualenv pulls
    it's dependencies also from upstream constrains,
    but that already dropped python2 support
    and it then fails e.g. on unable to find proper version of oslo.db

    Since os_tempest is installed from master, upstream requirements is
    used and that's why it is also breaking train jobs.

    https://bugs.launchpad.net/tripleo/+bug/1862134

    Change-Id: I13050fef0e2b10ed5c6585d2b7ee88929e7199a4
    Closes-Bug: 1862134