Thanks Actually I have just realized that db_sync prints an error in the api.log:
2016-11-17 17:20:21.895 43516 CRITICAL glance [-] ValueError: Tables "task_info,tasks" have non utf8 collation, please make sure all tables are CHARSET=utf8 2016-11-17 18:21 GMT+01:00 Abel Lopez <[email protected]>: > 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 < > [email protected]> 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 > > [email protected] > > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators > >
_______________________________________________ OpenStack-operators mailing list [email protected] http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
