settingsLogin | Registersettings

[Openstack] ERROR nova.api.openstack.extensions CantStartEngineError: No sql_connection parameter is established

0 votes

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.

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@bayour.com


Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
asked Jun 13, 2016 in openstack by Turbo_Fredriksson (8,980 points)   7 13 19

4 Responses

0 votes

On Jun 13, 2016, at 8:10 PM, Turbo Fredriksson wrote:

Error: Unable to create the server.

Googling a lot more, it occurred to me that the
"Availability Zone" in the

Project -> Compute -> Instances -> Launch Instance

"creator" is empty!

I have:

bladeA01b:~# openstack availability zone list
+-----------+-------------+
| Zone Name | Zone Status |
+-----------+-------------+
| internal | available |
| nova | available |
+-----------+-------------+

and I've double checked that there's config options
"*_availability_zone = nova" everywhere setup. All
services where I uncommented these have been restarted,
and still have no "Availability Zone"!

Trying to start the instance from the shell (and I'm
only winging it regarding to options!):

bladeA01b:~# openstack server create --volume da4918ff-3f82-4a8e-9efe-79e484ae3530 \
--flavor d18e3be3-ff6e-4cca-b3ad-64a1626ba12d --security-group cd662f83-b203-48d6-beea-79299cbaaefb \
--key-name turbo --availability-zone nova testing
The requested availability zone is not available (HTTP 400) (Request-ID: req-f62e314e-e1b4-4482-84fb-543c73bdab0f)

and without the "--availability-zone nova" option:

Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible.
(HTTP 500) (Request-ID: req-abeb791b-4cb9-4b1a-82a8-d180d0817b3b)

Running the former command with "--debug" I see:

bootargs: ['testing', None, ]
boot
kwargs: {'files': {}, 'userdata': None, 'availabilityzone': 'nova', 'nics': [], 'blockdevicemapping': {'vda': u'da4918ff-3f82-4a8e-9efe-79e484ae3530'}, 'maxcount': 1, 'meta': None, 'keyname': 'turbo', 'mincount': 1, 'schedulerhints': {}, 'reservationid': None, 'securitygroups': ['cd662f83-b203-48d6-beea-79299cbaaefb'], 'configdrive': None}
REQ: curl -g -i -X POST http://10.0.4.1:8774/v2/dd30640571db4298a0bca8c35359d263/os-volumes_boot -H "User-Agent: python-novaclient" -H "Content-Type: application/json" -H "Accept: application/json" -H "X-Auth-Token: {SHA1}2220fcfd7e2b423c2310319625a761ca87e92878" -d '{"server": {"name": "testing", "imageRef": "", "availabilityzone": "nova", "keyname": "turbo", "flavorRef": "d18e3be3-ff6e-4cca-b3ad-64a1626ba12d", "blockdevicemapping": [{"volumeid": "da4918ff-3f82-4a8e-9efe-79e484ae3530", "devicename": "vda"}], "maxcount": 1, "mincount": 1, "securitygroups": [{"name": "cd662f83-b203-48d6-beea-79299cbaaefb"}]}}'
"POST /v2/dd30640571db4298a0bca8c35359d263/os-volumes
boot HTTP/1.1" 400 92
RESP: [400] Content-Type: application/json; charset=UTF-8 Content-Length: 92 X-Compute-Request-Id: req-f377eaa8-8f15-4f1a-b50f-4698966a874f Date: Mon, 13 Jun 2016 21:01:58 GMT Connection: keep-alive
RESP BODY: {"badRequest": {"message": "The requested availability zone is not available", "code": 400}}

See http://bayour.com/misc/openstack_server_create-log.txt for
the full debug output. Hopefully I've cleaned it enough! :)

responded Jun 13, 2016 by Turbo_Fredriksson (8,980 points)   7 13 19
0 votes

On Jun 13, 2016, at 10:06 PM, Turbo Fredriksson wrote:

Project -> Compute -> Instances -> Launch Instance

Looking further in the GUI, I see

Admin -> System -> Host Aggregates

Availability Zone Name Hosts Available
internal * bladeA03b (Services Up) Yes
* bladeA01b (Services Up)
Displaying 1 item

That is the two nodes that I have created at the
moment (more Computes will come as soon as I get
this working).

BladeA01b is the Controller and BladeA03b is
the Compute node.

I created earlier a Host Aggregates:

Name Availability Zone Hosts Metadata Actions
domain internal * availability_zone = internal Edit Host Aggregate

But there is no place that I can see where I can
create a AZ..

responded Jun 13, 2016 by Turbo_Fredriksson (8,980 points)   7 13 19
0 votes

Never mind.

Apparently I've missed to install the nova-conductor package.

Sorry for the voice.

responded Jun 13, 2016 by Turbo_Fredriksson (8,980 points)   7 13 19
0 votes

Don't I feel stupid! I was a little to quick there.

There's now a AZ in the create GUI, but I still the "No sql_connection parameter
is established" error in the log.

bootargs: ['testing', , ]
boot
kwargs: {'files': {}, 'userdata': None, 'availabilityzone': 'nova', 'nics': [], 'blockdevicemapping': {}, 'maxcount': 1, 'meta': None, 'keyname': 'turbo', 'mincount': 1, 'schedulerhints': {}, 'reservationid': None, 'securitygroups': ['cd662f83-b203-48d6-beea-79299cbaaefb'], 'configdrive': None}
REQ: curl -g -i -X POST http://10.0.4.1:8774/v2/dd30640571db4298a0bca8c35359d263/servers -H "User-Agent: python-novaclient" -H "Content-Type: application/json" -H "Accept: application/json" -H "X-Auth-Token: {SHA1}130bfc0c0ab494d743cd2fe140a5d3594901ea72" -d '{"server": {"name": "testing", "imageRef": "4652eafd-0ea6-4313-9d69-03c55d1ff561", "availabilityzone": "nova", "keyname": "turbo", "flavorRef": "d18e3be3-ff6e-4cca-b3ad-64a1626ba12d", "maxcount": 1, "mincount": 1, "security_groups": [{"name": "cd662f83-b203-48d6-beea-79299cbaaefb"}]}}'
"POST /v2/dd30640571db4298a0bca8c35359d263/servers HTTP/1.1" 500 212
RESP: [500] Content-Type: application/json; charset=UTF-8 Content-Length: 212 X-Compute-Request-Id: req-e95e974b-1cfb-4ba6-b52c-d53ce8106e4a Date: Mon, 13 Jun 2016 23:41:38 GMT Connection: keep-alive
RESP BODY: {"computeFault": {"message": "Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/and attach the Nova API log if possible.\n", "code": 500}}

See http://bayour.com/misc/openstack_server_create-log-2.txt for the full log.


Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
responded Jun 13, 2016 by Turbo_Fredriksson (8,980 points)   7 13 19
...