Can't find SQLAlchemy<=0.8.99,<=0.9.99,>=0.8.4,>=0.9.7

[Derek Higgins]

Since the release of pip 6.0.X, all CI tests are failing, we cant install SQLAlchemy (from ceilometer/requirements.txt )

http://logs.openstack.org/17/98817/11/check-tripleo/check-tripleo-ironic-overcloud-f20-nonha/ae39aa3/console.html#_2014-12-23_08_13_33_100

2014-12-23 08:13:33.041 | Collecting SQLAlchemy<=0.8.99,<=0.9.99,>=0.8.4,>=0.9.7 (from -r /opt/stack/ceilometer/requirements.txt (line 44))
2014-12-23 08:13:33.042 | DEPRECATION: Failed to find 'SQLAlchemy' at http://127.0.0.1:8765/sqlalchemy/. It is suggested to upgrade your index to support normalized names as the name in /simple/{name}.
2014-12-23 08:13:33.042 | This repository located at 192.168.1.101 is not a trusted host, if this repository is available via HTTPS it is recommend to use HTTPS instead, otherwise you may silence this warning with '--trusted-host 192.168.1.101'.
2014-12-23 08:13:33.100 | Could not find a version that satisfies the requirement SQLAlchemy<=0.8.99,<=0.9.99,>=0.8.4,>=0.9.7 (from -r /opt/stack/ceilometer/requirements.txt (line 44)) (from versions: 0.4.2p3, 0.4.7p1, 0.5.4p1, 0.5.4p2, 0.1.0, 0.1.1, 0.1.2, 0.1.3, 0.1.4, 0.1.5, 0.1.6, 0.1.7, 0.2.0, 0.2.1, 0.2.2, 0.2.3, 0.2.4, 0.2.5, 0.2.6, 0.2.7, 0.2.8, 0.3.0, 0.3.1, 0.3.2, 0.3.3, 0.3.4, 0.3.5, 0.3.6, 0.3.7, 0.3.8, 0.3.9, 0.3.10, 0.3.11, 0.4.0b1, 0.4.0b2, 0.4.0b3, 0.4.0b4, 0.4.0b5, 0.4.0b6, 0.4.0, 0.4.1, 0.4.2a0, 0.4.2b0, 0.4.2, 0.4.3, 0.4.4, 0.4.5, 0.4.6, 0.4.7, 0.4.8, 0.5.0b1, 0.5.0b2, 0.5.0b3, 0.5.0rc1, 0.5.0rc2, 0.5.0rc3, 0.5.0rc4, 0.5.0, 0.5.1, 0.5.2, 0.5.3, 0.5.4, 0.5.5, 0.5.6, 0.5.7, 0.5.8, 0.6b1, 0.6b2, 0.6b3, 0.6.0, 0.6.1, 0.6.2, 0.6.3, 0.6.4, 0.6.5, 0.6.6, 0.6.7, 0.6.8, 0.6.9, 0.7.0, 0.7.1, 0.7.2, 0.7.3, 0.7.4, 0.7.5, 0.7.6, 0.7.7, 0.7.8, 0.7.9, 0.7.10, 0.8.0b2, 0.8.0, 0.8.1, 0.8.2, 0.8.3, 0.8.4, 0.8.5, 0.8.6, 0.8.7, 0.9.0, 0.9.1, 0.9.2, 0.9.3, 0.9.4, 0.9.5, 0.9.6, 0.9.7, 0.9.8)
2014-12-23 08:13:33.100 | Some externally hosted files were ignored as access to them may be unreliable (use --allow-external to allow).
2014-12-23 08:13:33.112 | No distributions matching the version for SQLAlchemy<=0.8.99,<=0.9.99,>=0.8.4,>=0.9.7 (from -r /opt/stack/ceilometer/requirements.txt (line 44))
2014-12-23 08:13:33.980 | + get_state_from_hosts

To reproduce (with pip 6.0.2)
rm -rf venv ; virtualenv venv ; . venv/bin/activate ; pip install "SQLAlchemy>=0.8.4,<=0.8.99,>=0.9.7,<=0.9.99"

[Derek Higgins (derekh)]

Ok, the version specifier is being changed in ceilometer

https://review.openstack.org/#/c/143580/1

should be merged soon

[Vikram Hosakote (vhosakot)]

The following work-around resolved the issue for me.

1. Delete the Ubuntu 14.04 VM.

2. Recreate a new Ubuntu 14.04 VM.

3. Clone a new Kilo DevStack tree.

4. Run ./stack.sh, and it will pass.