Ask Your Question
0

newton - nova_api table flavors is empty

asked 2016-11-20 15:21:03 -0500

gertje gravatar image

When populating the nova and nova_api databases, it turns out that the flavors table remains empty. Why?

edit retag flag offensive close merge delete

2 answers

Sort by ยป oldest newest most voted
0

answered 2016-11-21 02:37:00 -0500

gertje gravatar image

Bernd, thanks for your answer. I created and populated the nova_api database as you indicated. The table flavors is in the nova_api database, but empty. Table description looks OK. I will have a closer look at the log files and the python flavor creation script. Keep you informed. rgds, -g

edit flag offensive delete link more
0

answered 2016-11-21 00:43:14 -0500

Bernd Bausch gravatar image

How do you populate the databases? Flavors are in the API DB. If you are following one of the installation guides, you do this:

mysql> CREATE DATABASE nova_api;
mysql> GRANT ALL PRIVILEGES ON nova_api.* TO 'nova'@'localhost' IDENTIFIED BY 'NOVA_DBPASS';
mysql> GRANT ALL PRIVILEGES ON nova_api.* TO 'nova'@'%' IDENTIFIED BY 'NOVA_DBPASS';

# su -s /bin/sh -c "nova-manage api_db sync" nova

If flavors are not in the API DB after that, your configuration is incorrect. Of course, a bug can't be excluded.

Does your nova-manage logs to log files? If so, perhaps these commands provide clues:

# nova-manage logs errors
# nova-manage logs syslog

Or run nova-manage api_db sync again (should be idempotent?), looking for errors in stderr.

Or another suggestion: Flavors are created by /opt/stack/nova/nova/db/sqlalchemy/api_migrations/migrate_repo/versions/005_flavors.py (the first few path components are devstack specific and may be different on your installation). Add prints to this file to understand what's going out.

edit flag offensive delete link more

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: 2016-11-20 15:21:03 -0500

Seen: 86 times

Last updated: Nov 21 '16