Description of problem:
gnocchi-upgrade fails during Newton -> Ocata overcloud upgrade:
2017-02-08 11:14:45.269 936196 INFO alembic.runtime.migration [-] Running upgrade aba5a217ca9b -> 397987e38570, Remove slashes from original resource IDs, recompute their id with creator
2017-02-08 11:14:45.333 936196 CRITICAL gnocchi [-] DBNonExistentConstraint: (pymysql.err.InternalError) (1091, u"Can't DROP 'fk_metric_resource_id_resource_id'; check that column/key exists") [SQL: u'ALTER TABLE metric DROP FOREIGN KEY fk_metric_resource_id_resource_id']
Version-Release number of selected component (if applicable):
openstack-gnocchi-metricd-3.1.1-0.20170212020154.024ebe4.2.el7ost.noarch
openstack-gnocchi-statsd-3.1.1-0.20170212020154.024ebe4.2.el7ost.noarch
openstack-gnocchi-indexer-sqlalchemy-3.1.1-0.20170212020154.024ebe4.2.el7ost.noarch
openstack-gnocchi-api-3.1.1-0.20170212020154.024ebe4.2.el7ost.noarch
openstack-gnocchi-common-3.1.1-0.20170212020154.024ebe4.2.el7ost.noarch
How reproducible:
100%
Additional info:
We need the following patches in the downstream packages:
https://review.openstack.org/#/c/431101/https://review.openstack.org/#/c/432431/
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.
For information on the advisory, and where to find the updated
files, follow the link below.
If the solution does not work for you, open a new bug report.
https://access.redhat.com/errata/RHEA-2017:1245