Hi, Felix Thank you for reply. I've encountered the same problems as you. After much googling I've managed to modify database and to find out how to modify db_migration script. However after upgrading openstack instances have not launched successfully so I've decided to install IceHouse from scratch. This was easy for me because my openstack setup consists of 2 nodes.
Later I've found the page http://openstack.redhat.com/Workarounds#nova:_instances_started_in_error which explains what to do in case when "instances started in error state" > 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@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 > _______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : openstack@lists.openstack.org Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack