[Openstack-operators] Missing Glance metadef_resource_types table

Massimo Sgaravatto massimo.sgaravatto at gmail.com
Thu Nov 17 17:12:57 UTC 2016


We have just done the update Kilo --> Liberty --> Mitaka  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
ddb5dab8404dbe7fc359ec95ecf5 - - -] (pymysql.err.ProgrammingError) (1146,
u"Table 'glance_prod.metadef_resource_types' doesn't exist") [SQL: u'SELECT
metadef_resource_types.name AS metadef_resource_types_name,
metadef_namespace_resource_types.namespace_id AS
space_id \nFROM metadef_resource_types INNER JOIN
metadef_namespace_resource_types ON metadef_resource_types.id =
metadef_namespace_resource_types.resource_type_id \nWHERE
metadef_resource_types.name 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.
OsloDBDeprecationWarning: EngineFacade is deprecated; please use
  expire_on_commit=expire_on_commit, _conf=conf)

Any hints ?

Thanks, Massimo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20161117/56a538f4/attachment.html>

More information about the OpenStack-operators mailing list