Ask Your Question
1

Table 'nova.migrate_version' doesn't exist

asked 2014-03-19 09:11:04 -0500

cees gravatar image

Hi All,

i'm installing my first openstack controller (icehouse) on centos 6.5 and am using this tutorial to do so; http://docs.openstack.org/trunk/install-guide/install/yum/content/ch_preface.html (http://docs.openstack.org/trunk/insta...)

It seems i've managed to get keystone and glance up and running without issues, but when i try to create de nova database i get stuck.

When i run openstack-db --init --service nova --password $NOVA_DBPASS ($NOVA_DBPASS is set) the user and the database get created, but no tables are created. It displays this error:

Initializing the nova database, please wait...

Traceback (most recent call last):
  File "/usr/bin/nova-manage", line 10, in <module>
    sys.exit(main())
  File "/usr/lib/python2.6/site-packages/nova/cmd/manage.py", line 1321, in main
    config.parse_args(sys.argv)
  File "/usr/lib/python2.6/site-packages/nova/config.py", line 36, in parse_args
    rpc.init(cfg.CONF)
  File "/usr/lib/python2.6/site-packages/nova/rpc.py", line 63, in init
    aliases=TRANSPORT_ALIASES)
TypeError: get_transport() got an unexpected keyword argument 'aliases'
ERROR 1146 (42S02) at line 1: Table 'nova.migrate_version' doesn't exist
Final sanity check failed.

I've tried different settings in /etc/nova/nova.conf, dropped the db and retried without success. I would think the user credentials should be ok, since the database is created right?

Anyone who has experienced the same or can point me in the right direction of what it is i'm doing wrong?

edit retag flag offensive close merge delete

Comments

Recreate the DB. Make sure you have the DB connection information in Nova. Then run:

nova-manage db sync

That will create the databases if you are having issues with the script. Then restart the services and see if you have any issues.

mpetason gravatar imagempetason ( 2014-03-19 09:12:26 -0500 )edit

Ok, this is what i've done: openstack-db --drop --service nova |=> database and user is gone. in /etc/nova/nova.conf checkd this line: connection=mysql://nova:123passwd@controller/nova manually recreated the user and database and have given rights ran: nova-manage db sync |=> Same result.

cees gravatar imagecees ( 2014-03-19 09:23:53 -0500 )edit

When you go into mysql are you able to view tables under the nova database? Is it creating the other tables? You could manually create the table if there is still an issue. I usually stay away from the openstack-db init, but my database server isn't the same as the controller.

mpetason gravatar imagempetason ( 2014-03-19 09:33:07 -0500 )edit

So drop nova; create database nova; grant all on nova.* to 'nova'@'%' identified by '123passwd'; then nova-manage db sync You would think that with the sync outside of using openstack-db -init, wouldn't return the same errors.

mpetason gravatar imagempetason ( 2014-03-19 09:36:34 -0500 )edit

that's exactly what i've done. There stil are no tables created in the database. Could centos 6.5 be the blame? More googling suggested that maybe "aliases" are not supported in phyton 2.x?

cees gravatar imagecees ( 2014-03-19 09:50:33 -0500 )edit

1 answer

Sort by ยป oldest newest most voted
2

answered 2014-03-19 11:48:27 -0500

zkrapavickas gravatar image

Hello, you need to update python-oslo-messaging package.

Install rpm-build

yum install rpm-build

Download never version

wget http://repos.fedorapeople.org/repos/openstack/openstack-icehouse/epel-7/python-oslo-messaging-1.3.0-0.1.a7.el7.src.rpm (http://repos.fedorapeople.org/repos/o...)

Install dependencies

yum install python2-devel python-pbr python-d2to1

Build package

rpmbuild --rebuild python-oslo-messaging-1.3.0-0.1.a7.el7.src.rpm

Remove old version

rpm --nodeps -e python-oslo-messaging-1.3.0-0.1.a2.el6.noarch

Install new version

rpm -i ~/rpmbuild/RPMS/noarch/python-oslo-messaging-1.3.0-0.1.a7.el6.noarch.rpm

Probably i forgot something

edit flag offensive delete link more

Comments

Thank you so much! Spent hours fighting with this exact issue.

rnorton gravatar imagernorton ( 2014-03-19 22:54:21 -0500 )edit

Thank you!

Sorry for the late reply, been busy last couple of days. You didn't forget anything, works like a charm!

cees gravatar imagecees ( 2014-03-25 09:11:42 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2014-03-19 09:11:04 -0500

Seen: 1,309 times

Last updated: Mar 19 '14