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

Reply via email to