barbican-manage db upgrade failed

Bug #1740466 reported by Wu Chih Hang
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Barbican
Won't Fix
Undecided
Unassigned

Bug Description

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

description: updated
description: updated
description: updated
Revision history for this message
Jeremy Liu (liujiong) wrote :

Hi there!

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

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

Revision history for this message
Grzegorz Grasza (xek) wrote :

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

Changed in barbican:
status: New → Won't Fix
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.