[PKG-Openstack-devel] ERROR nova.api.openstack.extensions CantStartEngineError: No sql_connection parameter is established
Turbo Fredriksson
turbo at bayour.com
Mon Jun 13 19:10:50 UTC 2016
Sorry for the crosspost, but this looks like a bug (and from
what I've seen on the 'Net, it is), but because I have very
little knowledge in OS, it could just as well be my inability
to configure it correctly..
I'm trying to launch my first instance, but I'm getting
Error: Unable to create the server.
in the web UI and in the log:
----- s n i p -----
==> /var/log/nova/nova-api.log <==
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions [req-fed50cd6-81a7-4049-a827-18694b586033 0b160915426049f9a95f2857ee3c1bfd dd30640571db4298a0bca8c35359d263 - - -] Unexpected exception in API method
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions Traceback (most recent call last):
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/nova/api/openstack/extensions.py", line 478, in wrapped
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions return f(*args, **kwargs)
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/nova/api/validation/__init__.py", line 73, in wrapper
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions return func(*args, **kwargs)
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/nova/api/validation/__init__.py", line 73, in wrapper
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions return func(*args, **kwargs)
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/nova/api/validation/__init__.py", line 73, in wrapper
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions return func(*args, **kwargs)
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/nova/api/openstack/compute/servers.py", line 629, in create
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions **create_kwargs)
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/nova/hooks.py", line 154, in inner
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions rv = f(*args, **kwargs)
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 1556, in create
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions check_server_group_quota=check_server_group_quota)
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 1169, in _create_instance
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions instance_group, check_server_group_quota, filter_properties)
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 1027, in _provision_instances
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions quotas.rollback()
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions self.force_reraise()
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions six.reraise(self.type_, self.value, self.tb)
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 969, in _provision_instances
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions req_spec.create()
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/oslo_versionedobjects/base.py", line 223, in wrapper
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions return fn(self, *args, **kwargs)
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/nova/objects/request_spec.py", line 432, in create
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions db_spec = self._create_in_db(self._context, updates)
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 708, in wrapper
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions with self._transaction_scope(context):
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions return self.gen.next()
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 759, in _transaction_scope
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions allow_async=self._allow_async) as resource:
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions return self.gen.next()
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 491, in _session
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions bind=self.connection, mode=self.mode)
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 272, in _create_session
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions self._start()
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 338, in _start
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions engine_args, maker_args)
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 360, in _setup_for_connection
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions "No sql_connection parameter is established")
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions CantStartEngineError: No sql_connection parameter is established
2016-06-13 19:51:30.422 3582 ERROR nova.api.openstack.extensions
2016-06-13 19:51:30.428 3582 INFO nova.api.openstack.wsgi [req-fed50cd6-81a7-4049-a827-18694b586033 0b160915426049f9a95f2857ee3c1bfd dd30640571db4298a0bca8c35359d263 - - -] 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'>
2016-06-13 19:51:30.431 3582 INFO nova.osapi_compute.wsgi.server [req-fed50cd6-81a7-4049-a827-18694b586033 0b160915426049f9a95f2857ee3c1bfd dd30640571db4298a0bca8c35359d263 - - -] 10.0.4.1 "POST /v2/dd30640571db4298a0bca8c35359d263/os-volumes_boot HTTP/1.1" status: 500 len: 443 time: 1.4813468
----- s n i p -----
This is Openstack on Debian GNU/Linux Sid, nova v2:13.0.0-3.
The /etc/nova/nova.conf file say that "sql_connection" is deprecated,
and [instead] the "connection" is enabled instead. And apparently that
works for everything else (as far as I can tell):
connection = mysql+pymysql://user:r00tme@control.domain.tld/db
Using this in the shell with the "mysql" command works just fine,
from the whole network. I see no information of any kind on the
Compute (only have two hosts at the moment - the Control with
everything except Compute on and the Compute node with, well,
Nova compute on):
Control node:
bladeA01b:~# dpkg -l nova\* | grep ^ii
ii nova-api 2:13.0.0-3 all OpenStack Compute - compute API frontend
ii nova-common 2:13.0.0-3 all OpenStack Compute - common files
ii nova-scheduler 2:13.0.0-3 all OpenStack Compute - virtual machine scheduler
ii nova-volume 2:13.0.0-3 all OpenStack Compute - storage metapackage
Compute note:
bladeA03b:~# dpkg -l nova\* | grep ^ii
ii nova-common 2:13.0.0-3 all OpenStack Compute - common files
ii nova-compute 2:13.0.0-3 all OpenStack Compute - compute node
ii nova-compute-kvm 2:13.0.0-3 all OpenStack Compute - compute node (KVM)
ii nova-console 2:13.0.0-3 all OpenStack Compute - console
--
Turbo Fredriksson
turbo at bayour.com
More information about the Openstack-devel
mailing list