Open Stack

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 <alopgeek at gmail.com>:

> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20161117/f35971f0/attachment.html>