DBNonExistenceDatabase: Unknown database "nova_cell0"

[Digambar]

When we run "nova list" or "openstack server list", we get this error.
I have installed fresh devstack and then I am getting this error.

openstack server list

- go to n-api screen

2017-03-06 11:30:56.894 TRACE nova.api.openstack.extensions packet.check_error()
2017-03-06 11:30:56.894 TRACE nova.api.openstack.extensions File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2017-03-06 11:30:56.894 TRACE nova.api.openstack.extensions err.raise_mysql_exception(self._data)
2017-03-06 11:30:56.894 TRACE nova.api.openstack.extensions File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
2017-03-06 11:30:56.894 TRACE nova.api.openstack.extensions raise errorclass(errno, errval)
2017-03-06 11:30:56.894 TRACE nova.api.openstack.extensions DBNonExistentDatabase: (pymysql.err.InternalError) (1049, u"Unknown database 'nova_cell0'")
2017-03-06 11:30:56.894 TRACE nova.api.openstack.extensions
2017-03-06 11:30:56.897 INFO nova.api.openstack.wsgi [req-cd845e73-f456-4120-b5c4-f274e054d300 admin admin] HTTP exception thrown: Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible.
<class 'oslo_db.exception.DBNonExistentDatabase'>

[Digambar (digambarpatil15)]

I think 'nova_cell0' db is not created through devstack.

[jichenjc (jichenjc)]

maybe you need check you devstack first, I can see my devstack has this nova_cell0 db

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cinder |
| glance |
| keystone |
| mysql |
| neutron |
| nova |
| nova_api |
| nova_cell0 |
| performance_schema |
| sys |
+--------------------+

[Matt Riedemann (mriedem)]

The nova_cell0 database is created here by devstack:

https://github.com/openstack-dev/devstack/blob/8fe48af1625cd2deca496de81dd72573e78b3ef2/lib/nova#L709

I'm assuming you have the n-api service enabled?