Nova Mitaka requires a new nova_api database

[Dan Prince]

Per Nova Mitaka commit 8e8e839ef748be242fd0ad02e3ae233cc98da8b2

+upgrade:
+ - |
+ The commit with change-id Idd4bbbe8eea68b9e538fa1567efd304e9115a02a
+ requires that the nova_api database is setup and Nova is configured to use
+ it. Instructions on doing that are provided below.
+
+ Nova now requires that two databases are available and configured. The
+ existing nova database needs no changes, but a new nova_api database needs
+ to be setup. It is configured and managed very similarly to the nova
+ database. A new connection string configuration option is available in the
+ api_database group. An example::
+
+ [api_database]
+ connection = mysql+pymysql://user:secret@127.0.0.1/nova_api?charset=utf8
+
+ And a new nova-manage command has been added to manage db migrations for
+ this database. "nova-manage api_db sync" and "nova-manage api_db version"
+ are available and function like the parallel "nova-manage db ..." version.

[David Moreau Simard (dmsimard)]

This currently kills Mitaka CI for anything puppet related, needed ASAP.

[David Moreau Simard (dmsimard)]

For the record, the stack trace that is generated if the nova_api database is not created:
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions [req-12cc46b8-a455-49f8-80a5-2db8d2a66d03 1775a293ae9d452c8111ad38bbea76bc 8bd56badba9b400eb9ac6ff7ebee01ee - - -] Unexpected exception in API method
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions Traceback (most recent call last):
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/nova/api/openstack/extensions.py", line 478, in wrapped
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions return f(*args, **kwargs)
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/nova/api/validation/__init__.py", line 73, in wrapper
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions return func(*args, **kwargs)
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/nova/api/validation/__init__.py", line 73, in wrapper
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions return func(*args, **kwargs)
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/nova/api/validation/__init__.py", line 73, in wrapper
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions return func(*args, **kwargs)
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/nova/api/openstack/compute/servers.py", line 630, in create
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions **create_kwargs)
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/nova/hooks.py", line 149, in inner
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions rv = f(*args, **kwargs)
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/nova/compute/api.py", line 1497, in create
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions check_server_group_quota=check_server_group_quota)
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/nova/compute/api.py", line 1110, in _create_instance
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions instance_group, check_server_group_quota, filter_properties)
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/nova/compute/api.py", line 970, in _provision_instances
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions quotas.rollback()
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions File "/var/lib/kolla/venv/local/lib/python2.7/site-packages/oslo_utils/excutils.py", line 204, in __exit__
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions six.reraise(self.type_, self.value, self.tb)
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions File "/var/lib/kolla/venv/local/li...

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/274280
Committed: https://git.openstack.org/cgit/openstack/puppet-nova/commit/?id=1e12e9c45c5c567b3ae90c0d51875b20ef8b74a4
Submitter: Jenkins
Branch: master

commit 1e12e9c45c5c567b3ae90c0d51875b20ef8b74a4
Author: Dan Prince <email address hidden>
Date: Fri Jan 29 17:39:33 2016 -0500

    Classes to create and sync new nova_api DB

    Per Mitaka nova commit 8e8e839ef748be242fd0ad02e3ae233cc98da8b2
    we now need to create and sync the 'nova_api' database.

    Closes-bug: #1539793
    Co-Authored-By: Dan Prince <email address hidden>
    Co-Authored-By: Emilien Macchi <email address hidden>

    Change-Id: I234d2e9e219c6ea4235c3d3c5193b8924d6e6f8e

[wangolo (wangoloj)]

Am actually also being affected by this bug, when i try
nova-manage api_db --version or nova-manage api_db sync

I get the following Error, worse yet this is not the ip of the database i configured, i configured the database to run on 192.168.1.176, but for it connects on the very database which is locally on it.

Option "verbose" from group "DEFAULT" is deprecated for removal. Its value may be silently ignored in the future.
error: (pymysql.err.OperationalError) (1045, u"Access denied for user 'nova'@'192.168.1.181' (using password: YES)")

[Emilien Macchi (emilienm)]

You need to deploy this new class: https://github.com/openstack/puppet-nova/blob/master/manifests/db/mysql_api.pp