Ask Your Question

Missing Glance metadef_resource_types table [closed]

asked 2016-11-17 11:05:46 -0600

sgaravat gravatar image


We have just done the update Kilo --> Liberty --> Mitaka update of our Cloud. We went through Liberty just for the migration of the databases.

In the updated (to Mitaka) installation, if I click "Update metadata" on a image, I am told:

Error: Unable to retrieve the namespaces.

In the glance api log file I see:

2016-11-17 15:33:30.313 11829 ERROR glance.api.v2.metadef_namespaces [req-81b31f76-f665-4933-805e-3fd1d5e7c045 a1f915a7a36c471d87d6702255016df4 36b1
ddb5dab8404dbe7fc359ec95ecf5 - - -] (pymysql.err.ProgrammingError) (1146, u"Table 'glance_prod.metadef_resource_types' doesn't exist") [SQL: u'SELECT AS metadef_resource_types_name, metadef_namespace_resource_types.namespace_id AS metadef_namespace_resource_types_name
space_id \nFROM metadef_resource_types INNER JOIN metadef_namespace_resource_types ON = metadef_namespace_resource_types.resource_type_id \nWHERE IN (%s)'] [parameters: (u'OS::Glance::Image',)]

Indeed I don't have this table in my glance database:

mysql> show tables;
| Tables_in_glance_prod |
| image_locations       |
| image_members         |
| image_properties      |
| image_tags            |
| images                |
| migrate_version       |
| task_info             |
| tasks                 |
8 rows in set (0.00 sec)

I didn't have any errors running db_sync, apart some deprecation messages (and the install guide says that they can be ignored):

su -s /bin/sh -c "glance-manage db_sync" glance
Option "verbose" from group "DEFAULT" is deprecated for removal.  Its value may be silently ignored in the future.
/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/ OsloDBDeprecationWarning: EngineFacade is deprecated; please use oslo_db.sqlalchemy.enginefacade
  expire_on_commit=expire_on_commit, _conf=conf)

Any hints ?

Thanks, Massimo

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by sgaravat
close date 2016-11-18 06:10:17.765843

1 answer

Sort by ยป oldest newest most voted

answered 2016-11-18 06:08:58 -0600

sgaravat gravatar image

Actually db-sync didn't print anything in stdout/stderr, but it printed an error message in the glance api log.

The problem was a table not converted to UTF-8

edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2016-11-17 11:05:46 -0600

Seen: 150 times

Last updated: Nov 18 '16