[aodh][master] "Could not find a version that satisfies the requirement sqlalchemy<1.1.0,>=0.9.7 (from versions: 1.1.9)"

[Miguel Alejandro Cantu]

The os_aodh role sets constraints for the SQLAlchemy pacakge in defaults/main.yml[1]. However, because the upper constraint "sqlalchemy===1.1.9" is set in the OpenStack Requirements project, it fails trying to find the version aodh requires.

"Could not find a version that satisfies the requirement sqlalchemy<1.1.0,>=0.9.7 (from versions: 1.1.9)"

[1] https://github.com/openstack/openstack-ansible-os_aodh/blob/master/defaults/main.yml#L122

[Miguel Alejandro Cantu (miguel-cantu)]

UPDATE:
I've created an upstream patch to loosen up the sqlalchemy requirements within the aodh project:
https://review.openstack.org/#/c/460256/1

[Miguel Alejandro Cantu (miguel-cantu)]

Once (if) the upstream patch merges, the constraint in the os_aodh role will need to be updated to reflect the changes.

[Miguel Alejandro Cantu (miguel-cantu)]

UPDATE:
https://review.openstack.org/#/c/460256 has merged. Moving on to changing the constraints in the os_aodh role now...

[bhujay kumar (bhatta)]

I am stuck up with the same problem . This error is coming during the venv create stage of repo build. First the error was coming for designate . I disabled them from the inventory - openstack_user_config.yml. Then it is for aodh . Disabled it too and now it is coming for ceilometer.

Can you please help ?

Log from repo containers repo_venv_builder.log :

Collecting SQLAlchemy<1.1.0,>=1.0.10 (from ceilometer)
  0 location(s) to search for versions of SQLAlchemy:
  Found link file:///var/www/repo/os-releases/master/ubuntu-16.04-x86_64/sqlalchemy-1.1.9-cp27-cp27mu-linux_x86_64.whl, version: 1.1.9
  Local files found: /var/www/repo/os-releases/master/ubuntu-16.04-x86_64/sqlalchemy-1.1.9-cp27-cp27mu-linux_x86_64.whl
  Could not find a version that satisfies the requirement SQLAlchemy<1.1.0,>=1.0.10 (from ceilometer) (from versions: 1.1.9)
Cleaning up...
No matching distribution found for SQLAlchemy<1.1.0,>=1.0.10 (from ceilometer)
Exception information:
Traceback (most recent call last):
  File "/tmp/openstack-venv-builder/venvs/ceilometer/lib/python2.7/site-packages/pip/basecommand.py", line 215, in main
    status = self.run(options, args)
  File "/tmp/openstack-venv-builder/venvs/ceilometer/lib/python2.7/site-packages/pip/commands/install.py", line 335, in run
    wb.build(autobuilding=True)
  File "/tmp/openstack-venv-builder/venvs/ceilometer/lib/python2.7/site-packages/pip/wheel.py", line 749, in build
    self.requirement_set.prepare_files(self.finder)
  File "/tmp/openstack-venv-builder/venvs/ceilometer/lib/python2.7/site-packages/pip/req/req_set.py", line 380, in prepare_files
    ignore_dependencies=self.ignore_dependencies))
  File "/tmp/openstack-venv-builder/venvs/ceilometer/lib/python2.7/site-packages/pip/req/req_set.py", line 554, in _prepare_file
    require_hashes
  File "/tmp/openstack-venv-builder/venvs/ceilometer/lib/python2.7/site-packages/pip/req/req_install.py", line 278, in populate_link
    self.link = finder.find_requirement(self, upgrade)
  File "/tmp/openstack-venv-builder/venvs/ceilometer/lib/python2.7/site-packages/pip/index.py", line 514, in find_requirement
    'No matching distribution found for %s' % req
DistributionNotFound: No matching distribution found for SQLAlchemy<1.1.0,>=1.0.10 (from ceilometer)

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/461127
Committed: https://git.openstack.org/cgit/openstack/openstack-ansible-os_aodh/commit/?id=109ad46201172f5e83f330fc15de714e55f61fea
Submitter: Jenkins
Branch: master

commit 109ad46201172f5e83f330fc15de714e55f61fea
Author: alextricity25 <email address hidden>
Date: Fri Apr 28 13:55:18 2017 -0500

    Update sqlalchemy constraints to match upstream

    The sqlalchemy upper constraint has recently been removed in
    https://review.openstack.org/#/c/460256/4. This commit changes
    the constraint in the role default to match the change.

    Closes-Bug: #1686483
    Change-Id: I22228de6e29c3cf6ad3afa459ae29d3f76c00a28

[Miguel Alejandro Cantu (miguel-cantu)]

The above patch set should have fixed this problem. I'm now running through the telemetry stack to make sure there aren't any other looming issues that need to be fixed.

[Miguel Alejandro Cantu (miguel-cantu)]

Bah..turns out ceilometer also has a constraint that conflicts with the upper-constraints defined in OpenStack Requirements:
https://github.com/openstack/ceilometer/blob/master/requirements.txt#L42

I'm going to have to either 1) change that in the ceilometer code base or 2) define an upper constraint override in OpenStack-Ansible.

[Miguel Alejandro Cantu (miguel-cantu)]

I've opened a separate bug report for the ceilometer sqlalchemy constraint conflict: https://bugs.launchpad.net/openstack-ansible/+bug/1687641

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/openstack-ansible-os_aodh 16.0.0.0b2 development milestone.