barbican-manage db upgrade failed

[Wu Chih Hang]

I following the installation guide from openstack (https://docs.openstack.org/barbican/latest/install/install-ubuntu.html) to install barbican on my service.
But "barbican-manage db upgrade" fails with below error:
--------------------------------------------------------------------------------
Option "verbose" from group "DEFAULT" is deprecated for removal. Its value may be silently ignored in the future.
2017-12-29 13:49:07.151 14959 INFO alembic.runtime.migration [-] Context impl MySQLImpl.
2017-12-29 13:49:07.151 14959 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.
2017-12-29 13:49:07.437 14959 INFO alembic.runtime.migration [-] Running upgrade -> 1a0c2cdafb38, create test table
2017-12-29 13:49:07.452 14959 INFO alembic.runtime.migration [-] Running upgrade 1a0c2cdafb38 -> juno, juno_initial
/usr/lib/python2.7/dist-packages/pymysql/cursors.py:158: Warning: Specified key was too long; max key length is 767 bytes
  result = self._query(query)
2017-12-29 13:49:10.461 14959 INFO alembic.runtime.migration [-] Running upgrade juno -> 13d127569afa, create_secret_store_metadata_table
2017-12-29 13:49:10.678 14959 INFO alembic.runtime.migration [-] Running upgrade 13d127569afa -> 1e86c18af2dd, add new columns type meta containerId
2017-12-29 13:49:11.550 14959 INFO alembic.runtime.migration [-] Running upgrade 1e86c18af2dd -> cd4106a1a0, add-cert-to-container-type
2017-12-29 13:49:11.625 14959 INFO alembic.runtime.migration [-] Running upgrade cd4106a1a0 -> 47b69e523451, Made plugin names in kek datum non nullable
2017-12-29 13:49:11.692 14959 INFO alembic.runtime.migration [-] Running upgrade 47b69e523451 -> 4070806f6972, Add orders plugin metadata table and relationships
2017-12-29 13:49:11.951 14959 INFO alembic.runtime.migration [-] Running upgrade 4070806f6972 -> 2ab3f5371bde, dsa in container type modelbase_to
2017-12-29 13:49:15.745 14959 INFO alembic.runtime.migration [-] Running upgrade 2ab3f5371bde -> 2843d6469f25, add sub status info for orders
2017-12-29 13:49:16.545 14959 INFO alembic.runtime.migration [-] Running upgrade 2843d6469f25 -> 254495565185, removing redundant fields from order
2017-12-29 13:49:18.154 14959 INFO alembic.runtime.migration [-] Running upgrade 254495565185 -> 795737bb3c3, Change tenants to projects
ERROR: (pymysql.err.InternalError) (1025, u"Error on rename of './barbican/#sql-881_1f54' to './barbican/orders' (errno: 150)") [SQL: u'ALTER TABLE orders CHANGE tenant_id project_id VARCHAR(36) NULL']
---------------------------------------------------------------------------------

I have checked sql_connection parameter is correct, and set db_auto_create=false.
When I try to re run "barbican-manage db upgrade" , It comes up another error message:
---------------------------------------------------------------------------------
Option "verbose" from group "DEFAULT" is deprecated for removal. Its value may be silently ignored in the future.
2017-12-29 14:32:48.112 12322 INFO alembic.runtime.migration [-] Context impl MySQLImpl.
2017-12-29 14:32:48.112 12322 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.
2017-12-29 14:32:48.117 12322 INFO alembic.runtime.migration [-] Running upgrade 254495565185 -> 795737bb3c3, Change tenants to projects
ERROR: (pymysql.err.ProgrammingError) (1146, u"Table 'barbican.tenant_secret' doesn't exist") [SQL: u'ALTER TABLE tenant_secret DROP FOREIGN KEY tenant_secret_ibfk_1']
---------------------------------------------------------------------------------

I would appreciate it if anyone could solve my problem.

My env:
Ubuntu server 14.04
Openstack Mitaka running on KVM
MariaDB-5.5.57

[Jeremy Liu (liujiong)]

Hi there!

Please check if [1][2] solves the problem!

[1] https://bugs.launchpad.net/barbican/+bug/1556256
[2] https://review.openstack.org/292523

[Grzegorz Grasza (xek)]

Closing out bugs created before migration to StoryBoard. Please re-open if you are of the opinion it is still current.