Nova issue - InternalError: (1049, u"Unknown database 'nova_api'")

[Tung Doan]

Hi all,

I run stack.sh with devstack today. Devstack is still installed successfully but when I tracked stack.sh log I found an error:

InternalError: (1049, u"Unknown database 'nova_api'")

The detailed log is attached here: http://paste.openstack.org/show/566648/

and full stack.sh log:
https://drive.google.com/file/d/0B7Fzz6EvT2F9T0tVUHUtdk55SVE/view

Thanks

[Sylvain Bauza (sylvain-bauza)]

Not sure how you ended up with that, but I'd recommend you to ./unstack.sh, ./clean.sh, do a fresh devstack git pull to get the latest master, wipe the /opt/stack repositories, ./stack.sh again and see whether you have a 2nd DB being created as "nova_api".

The stack.sh log you mention doesn't look having any problem at all.

[Lenny (lennyb)]

I am also getting this error

http://13.69.151.247/Nova-ML2-Sriov/6310_cloudx-23/logs/stack.sh.log.gz line 9847

016-09-05 08:14:13.229 | 2016-09-05 11:14:13.225 26996 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 115, in _check_mysql_exception
2016-09-05 08:14:13.229 | 2016-09-05 11:14:13.225 26996 ERROR oslo_db.sqlalchemy.exc_filters raise InternalError(errno, errorvalue)
2016-09-05 08:14:13.230 | 2016-09-05 11:14:13.225 26996 ERROR oslo_db.sqlalchemy.exc_filters InternalError: (1049, u"Unknown database 'nova_api'")

[Erlon R. Cruz (sombrafam)]

Im getting this error in a gate job: http://logs.openstack.org/16/369516/6/check/gate-tempest-dsvm-full-devstack-plugin-nfs-nv/cd3409a/logs/devstacklog.txt.gz

gerrit link: https://review.openstack.org/#/c/369516/

[Markus Zoeller (markus_z) (mzoeller)]

It's pretty often ("count per 1h | (50447 hits)") in logstash: http://logstash.openstack.org/#dashboard/file/logstash.json?query=message%3A%5C%22Unknown%20database%20'nova_api'%5C%22

[Diana Clarke (diana-clarke)]

I think the following patch might fix this bug:

  lib/nova: create api db first
  https://review.openstack.org/#/c/384916/

[Roman Podoliaka (rpodolyaka)]

I think it's a duplicate of https://bugs.launchpad.net/nova/+bug/1631033 , the traceback will be gone with new release of oslo.db - 4.14.0