ocata installation fails for aodh,ceilometer and designate when sqlalchemy version is 1.1.9 version

[bhujay kumar]

Related bug for aodh has been reported here https://bugs.launchpad.net/openstack-ansible/+bug/1686483?comments=all . I have provided the error logs there.

However the bug affected ceilometer and designate during the repo build venv creation stage. I tried overriding the sqlalchecmy required version to 1.1.9 in user_var.yml but repo build fails with lot of sytax error messages.

Finally i have done the following overrides in user_variables.yml to complete the repo build

repo_build_upper_constraints_overrides:
# # Due to bug https://bugs.launchpad.net/openstack-ansible/+bug/1686483?comments=all
# # trying with
  - "sqlalchemy<1.1.0"

Not sure where it will create problem later.

[Jean-Philippe Evrard (jean-philippe-evrard)]

I'm not sure to understand the difference with the other bug. Could this be a duplicate?

[bhujay kumar (bhatta)]

Hi Jean while the other bug refers to only aodh , i am listing this for ceilometer and designate as well .

[Jimmy McCrory (jimmy-mccrory)]

The upper constraint for sqlalchemy in ocata is 1.0.17
https://github.com/openstack/requirements/blob/stable/ocata/upper-constraints.txt#L24

Are you attempting to install services from both the master and ocata branches?

[bhujay kumar (bhatta)]

Thanks Jimmy for your reply. Looks like that could be the issue .

I followed the osa deployment guidelines to clone the repo using
tag 16.0.0.0b1 . Today I crosschecked the doc and found the doc suggests clone with tag 15.1.2 :

https://docs.openstack.org/project-deploy-guide/openstack-ansible/ocata/deploymenthost.html#configure-ssh-keys

May be it was my mistake or the doc has been updated . Will try to reinstall as per this hints .

Thanks again for your help.