search

AJNOURI / COA

Openstack Foundation Openstack Certified Administrator exam Preparation
MIT License
45 stars 37 forks source link

Error: Unable to retrieve volume/instance attachment information #51

Closed AJNOURI closed 7 years ago

AJNOURI commented 7 years ago

Error: Unable to retrieve volume/instance attachment information Error: Unable to retrieve attachment information.

selection_670

openstack server list

Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible. <class 'sqlalchemy.exc.ProgrammingError'> (HTTP 500) (Request-ID: req-fda10458-1347-4965-9ca4-a6b3d35ed1fe)

AJNOURI commented 7 years ago

This is the result of messing (intentionally) with the database:

mysql> SET FOREIGN_KEY_CHECKS=0; 
mysql> DROP TABLE instances;
mysql> SET FOREIGN_KEY_CHECKS=1;

Which means that the instances database instances is not available for some reason

In this case restore the backed up (hopefully) database:

mysql -u root -h localhost nova < nova-02-01.sql