Ask Your Question
0

nova-manage database query issue

asked 2011-10-21 12:20:21 -0500

guidodavide-dallolio gravatar image

Hello. I'm having a problem using nova-mange commands. My sql server is active and all nova services are running correctly. I can run instances, terminate them, networking with them with no problems. But every time I try to use nova-manage it gives me this error, an example:

"nova-manage instance_type list Command failed, please check log for more info 2011-10-21 14:15:00,915 CRITICAL nova [-] (OperationalError) no such table: instance_types u'SELECT instance_types.created_at AS instance_types_created_at, instance_types.updated_at AS instance_types_updated_at, instance_types.deleted_at AS instance_types_deleted_at, instance_types.deleted AS instance_types_deleted, instance_types.id AS instance_types_id, instance_types.name AS instance_types_name, instance_types.memory_mb AS instance_types_memory_mb, instance_types.vcpus AS instance_types_vcpus, instance_types.local_gb AS instance_types_local_gb, instance_types.flavorid AS instance_types_flavorid, instance_types.swap AS instance_types_swap, instance_types.rxtx_quota AS instance_types_rxtx_quota, instance_types.rxtx_cap AS instance_types_rxtx_cap \nFROM instance_types \nWHERE instance_types.deleted = ? ORDER BY name' (False,)"

I entered in mysql DB and all tables are there, values too. instance_types table has correct values..but nova-manage is not working. I cannot find the issue.. Please an help! Thank you

edit retag flag offensive close merge delete

2 answers

Sort by ยป oldest newest most voted
0

answered 2011-10-21 20:49:44 -0500

vishvananda gravatar image

nova-manage probably isn't able to read the logfile. Try sudo. If that doesn't work you may have to specify the flagfile manually: nova-manage --flagfile-/etc/nova/nova.conf

On Oct 21, 2011, at 5:20 AM, Guido Davide Dall'Olio wrote:

New question #175577 on OpenStack Compute (nova): https://answers.launchpad.net/nova/+q...

Hello. I'm having a problem using nova-mange commands. My sql server is active and all nova services are running correctly. I can run instances, terminate them, networking with them with no problems. But every time I try to use nova-manage it gives me this error, an example:

"nova-manage instance_type list Command failed, please check log for more info 2011-10-21 14:15:00,915 CRITICAL nova [-] (OperationalError) no such table: instance_types u'SELECT instance_types.created_at AS instance_types_created_at, instance_types.updated_at AS instance_types_updated_at, instance_types.deleted_at AS instance_types_deleted_at, instance_types.deleted AS instance_types_deleted, instance_types.id AS instance_types_id, instance_types.name AS instance_types_name, instance_types.memory_mb AS instance_types_memory_mb, instance_types.vcpus AS instance_types_vcpus, instance_types.local_gb AS instance_types_local_gb, instance_types.flavorid AS instance_types_flavorid, instance_types.swap AS instance_types_swap, instance_types.rxtx_quota AS instance_types_rxtx_quota, instance_types.rxtx_cap AS instance_types_rxtx_cap \nFROM instance_types \nWHERE instance_types.deleted = ? ORDER BY name' (False,)"

I entered in mysql DB and all tables are there, values too. instance_types table has correct values..but nova-manage is not working. I cannot find the issue.. Please an help! Thank you


You received this question notification because you are a member of Nova Core, which is an answer contact for OpenStack Compute (nova).

edit flag offensive delete link more
0

answered 2011-10-23 13:50:14 -0500

guidodavide-dallolio gravatar image

Thank you!! adding --flagfile-/etc/nova/nova.conf it worked!! Many thanks!

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: 2011-10-21 12:20:21 -0500

Seen: 12 times

Last updated: Oct 23 '11