unable to find host for instance http 500

Asked by pramod

while trying to bring launch an instnace I am getting an error in nova-api.log "unable to find host for instance "<Instnace id>" and http 500.

Plz help

Question information

Language:
English Edit question
Status:
Solved
For:
OpenStack Compute (nova) Edit question
Assignee:
No assignee Edit question
Solved by:
pramod
Solved:
Last query:
Last reply:
Revision history for this message
pramod (p-rathor) said :
#1

Cleanning up nova db helped

Revision history for this message
Afef (afef-mdhaffar) said :
#2

I got the same error and could not solve it.
How to clean up nova db? Do I have to delete the content of all tables? Is there any method to do it automatically?
Actually, I tried to delete the content of the "instances" table. I could not delete any row because of the existence of a foreign key. So, I set all "deleted" fileds to "1". But, this does not solve the problem.
Need an urgent help, please.