Open Stack

This is a manual step to load them. If your installation was complete, you should have a bunch of json files in /etc/glance/metadefs.
You need to load them with glance-manage db_load_metadefs

> On Nov 17, 2016, at 9:12 AM, Massimo Sgaravatto <massimo.sgaravatto at gmail.com> wrote:
> 
> Hi
> 
> 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 36b1
> 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 metadef_namespace_resource_types_name
> 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.
> /usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py:1056: OsloDBDeprecationWarning: EngineFacade is deprecated; please use oslo_db.sqlalchemy.enginefacade
>   expire_on_commit=expire_on_commit, _conf=conf)
> 
> Any hints ?
> 
> Thanks, Massimo
> _______________________________________________
> OpenStack-operators mailing list
> OpenStack-operators at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators