Open Stack

Hi, Anatoly,
I am not sure if you solved this problem already, but I suffered the 
similar problem as yours when I upgraded openstack from havana to 
icehouse today.

There were two problems I suffered, and both related to msyql table 
character set.

Simply check, if you run: keystone-manage db_version, and the version 
stays at 37, you probably failed at db_sync as I did.


In my case, while I did keystone-manage db_sync, there was an error in 
/var/log/keystone/keystone.log:
2014-06-09 21:23:12.732 53481 CRITICAL keystone [-] ValueError: Tables 
"region" have non utf8 collation, please make sure all tables are 
CHARSET=utf8


So, the workaround was to go to mysql and change the CHARSET to utf8 for 
table: "region", for example, run following sql command in mysql:

  use keystone ;
  alter table region CHARACTER SET utf8 COLLATE utf8_general_ci;


And, the second problem was actually a bug of db_migration script which 
was already reported and fixed, but, unfortunately, it is not yet 
available in rdo release, so, you will have to apply patch by hand, 
please see detail:

https://git.openstack.org/cgit/openstack/keystone/commit/?id=4408625031bc9804fa4bd4a72988bf31375b7787


I hope this can be helpful, if you have not yet solved this problem.


Best regards,
Felix Lee ~


On 2014年05月29日 13:44, Anatoly Oreshkin wrote:
>
>
> Hello,
>
> I've upgraded Havana to IceHouse on  Scientific Linux 6.5 following  these steps:
>
> yum install http://rdo.fedorapeople.org/openstack-havana/rdo-release-havana.rpm
>
> yum -y update
>
> nova-manage db sync
> cinder-manage db sync
> glance-manage db_sync
> keystone-manage db_sync
>
> When I run command keystone tenenat-list
> I get
> uthorization Failed: An unexpected error prevented the server from fulfilling your
> request. (HTTP 500)
>
> /var/log/keystone  shows
>
> 2014-05-29 15:42:58.782 10638 TRACE keystone.common.wsgi ProgrammingError:
> (ProgrammingError) (1146, "Table 'keystone.assignment' doesn't exist") 'SELECT
> assignment.type AS assignment_type, assignment.actor_id AS assignment_actor_id,
> assignment.target_id AS assignment_target_id, assignment.role_id AS
> assignment_role_id, assignment.inherited AS assignment_inherited \nFROM assignment
> \nWHERE assignment.actor_id = %s AND assignment.target_id = %s'
> ('9436d6868f314fae81166cedf1769bed', '71d30105c083454398c9617cd15a9e4d')
> 2014-05-29 15:42:58.782 10638 TRACE keystone.common.wsgi
>
>
> Can anybody help me ?
>
>
>
>
> _______________________________________________
> Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> Post to     : openstack at lists.openstack.org
> Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>


-- 
Felix H.T Lee                           Academia Sinica Grid & Cloud.
Tel: +886-2-27898308
Office: Room P111, Institute of Physics, 128 Academia Road, Section 2, 
Nankang, Taipei 115, Taiwan