newton - nova_api table flavors is empty
When populating the nova and nova_api databases, it turns out that the flavors table remains empty. Why?
First time here? Check out the FAQ!
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
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
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.
Asked: 2016-11-20 15:21:03 -0500
Seen: 86 times
Last updated: Nov 21 '16