[xena][barbican][scenario002] Fails with ERROR: 'Inspector' object has no attribute 'has_table'

[yatin]

Post barbican https://review.opendev.org/c/openstack/barbican/+/796284 patch, scenario002 promotion job fails with below:-
exec /usr/bin/bootstrap_host_exec barbican_api su barbican -s /bin/bash -c ''\''/usr/bin/barbican-manage' db upgrade \'
ERROR: 'Inspector' object has no attribute 'has_table'

The commit needs sqlalchemy >= 1.4.0, but we currently have 1.3.23 in RDO. barbican needs to be fixed in backward compatible way.

Logs:-
https://logserver.rdoproject.org/openstack-periodic-integration-main/opendev.org/openstack/tripleo-ci/master/periodic-tripleo-ci-centos-8-scenario002-standalone-master/e5c852b/logs/undercloud/home/zuul/standalone_deploy.log.txt.gz

Also seeing same failure in puppet promotion pipeline:-
https://logserver.rdoproject.org/ci.centos.org/weirdo-generic-puppet-openstack-scenario003/19684/weirdo-project/puppet.txt.gz

[yatin (yatinkarel)]

Proposed patch to pin barbican to working commit:- https://review.rdoproject.org/r/c/rdoinfo/+/34225.
As sqlalchemy update to 1.4.18 https://review.rdoproject.org/r/c/rdoinfo/+/34221 is not compatible with promoted barbican commits. Also watcher and gnocchi have issues with 1.4.18. So until barbican get's a backward compatible fix and watcher and gnocchi are adopted to 1.4.18 updated needs to be held.

[Douglas Mendizábal (dougmendizabal)]

This should fix barbican: https://review.opendev.org/c/openstack/barbican/+/796059

[wes hayutin (weshayutin)]

https://review.rdoproject.org/zuul/build/3881fe8da44041ffa80980f0f5d3f390 fixed

[yatin (yatinkarel)]

Jobs working post https://review.opendev.org/c/openstack/barbican/+/796059, unpinned in RDO https://review.rdoproject.org/r/c/rdoinfo/+/34135, both puppet and tripleo jobs green, closing it.