kolla-mesos

nova-api -- No sql_connection parameter is established

Bug #1540579 reported by Sam Yaple on 2016-02-01

This bug affects 5 people

Affects		Status	Importance	Assigned to	Milestone
	kolla	Fix Released	Undecided	Unassigned
	kolla-mesos	New	Undecided	Unassigned

Bug Description

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/lib/python2.7/site-packages/nova/compute/api.py", line 926, in _provision_instances
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions req_spec.create()
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_versionedobjects/base.py", line 221, in wrapper
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions return fn(self, *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/objects/request_spec.py", line 425, in create
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions db_spec = self._create_in_db(self._context, updates)
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_db/sqlalchemy/enginefacade.py", line 708, in wrapper
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions with self._transaction_scope(context):
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions return self.gen.next()
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_db/sqlalchemy/enginefacade.py", line 759, in _transaction_scope
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions allow_async=self._allow_async) as resource:
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions return self.gen.next()
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_db/sqlalchemy/enginefacade.py", line 491, in _session
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions bind=self.connection, mode=self.mode)
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_db/sqlalchemy/enginefacade.py", line 272, in _create_session
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions self._start()
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_db/sqlalchemy/enginefacade.py", line 338, in _start
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions engine_args, maker_args)
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_db/sqlalchemy/enginefacade.py", line 360, in _setup_for_connection
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions "No sql_connection parameter is established")
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions CantStartEngineError: No sql_connection parameter is established
2016-02-01 20:44:49.332 20 ERROR nova.api.openstack.extensions
2016-02-01 20:44:49.336 20 INFO nova.api.openstack.wsgi [req-12cc46b8-a455-49f8-80a5-2db8d2a66d03 1775a293ae9d452c8111ad38bbea76bc 8bd56badba9b400eb9ac6ff7ebee01ee - - -] 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.CantStartEngineError'>

Sam Yaple (s8m) on 2016-02-01

summary:

- nova-api sql_database
+ nova-api -- No sql_connection parameter is established

Revision history for this message

OpenStack Infra (hudson-openstack) wrote on 2016-02-03: Fix merged to kolla (master)

Reviewed: https://review.openstack.org/274928
Committed: https://git.openstack.org/cgit/openstack/kolla/commit/?id=e7dfd63bfc5cfba0117c410d418feaff0f7999f3
Submitter: Jenkins
Branch: master

commit e7dfd63bfc5cfba0117c410d418feaff0f7999f3
Author: SamYaple <email address hidden>
Date: Mon Feb 1 23:01:59 2016 +0000

Create nova-api database

This is a required patch.

Kilo introduced a nova-api database but didn't use it. [1]
Mitaka now uses it and has broken booting instances. [2]

[1] https://wiki.openstack.org/wiki/ReleaseNotes/Kilo#OpenStack_Compute_.28Nova.29
[2] https://github.com/openstack/nova/blob/df0fca62cf5324f5b6eae0fed1f88c6c9ed61c71/releasenotes/notes/request-spec-api-db-b9cc6e0624d563c5.yaml

Change-Id: If0a7f4ba4937fab8d60f5236ca00db06faa768c7
Closes-Bug: #1540579

Changed in kolla:
status:	New → Fix Released

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.