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

Turbo Fredriksson turbo at bayour.com
Mon Jun 13 21:06:50 UTC 2016


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.
  <class 'oslo_db.exception.CantStartEngineError'> (HTTP 500) (Request-ID: req-abeb791b-4cb9-4b1a-82a8-d180d0817b3b)

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

  boot_args: ['testing', None, <Flavor: m1.tiny>]
  boot_kwargs: {'files': {}, 'userdata': None, 'availability_zone': 'nova', 'nics': [], 'block_device_mapping': {'vda': u'da4918ff-3f82-4a8e-9efe-79e484ae3530'}, 'max_count': 1, 'meta': None, 'key_name': 'turbo', 'min_count': 1, 'scheduler_hints': {}, 'reservation_id': None, 'security_groups': ['cd662f83-b203-48d6-beea-79299cbaaefb'], 'config_drive': 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": "", "availability_zone": "nova", "key_name": "turbo", "flavorRef": "d18e3be3-ff6e-4cca-b3ad-64a1626ba12d", "block_device_mapping": [{"volume_id": "da4918ff-3f82-4a8e-9efe-79e484ae3530", "device_name": "vda"}], "max_count": 1, "min_count": 1, "security_groups": [{"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! :)





More information about the Openstack mailing list