nova-manage database query issue

Asked by Guido Davide Dall'Olio on 2011-10-21

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

Question information

Language:
English Edit question
Status:
Solved
For:
OpenStack Compute (nova) Edit question
Assignee:
No assignee Edit question
Solved by:
Guido Davide Dall'Olio
Solved:
2011-10-23
Last query:
2011-10-23
Last reply:
2011-10-21
Vish Ishaya (vishvananda) said : #1

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/+question/175577
>
> 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).

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

what is is correct configuration ?

do we need to add this line

nova-manage --flagfile from the nova.conf ?