Fuel for OpenStack

Assign floating ip failed with mysql_exceptions.OperationalError

Bug #1531130 reported by Tatyanka on 2016-01-05

This bug report is a duplicate of: Bug #1546224: OSTF test fail to remove floating IP: "ClientException: Unexpected API Error. <class 'oslo_db.exception.DBDeadlock'> (HTTP 500)". Edit Remove

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Fuel for OpenStack	Confirmed	Medium	MOS Nova	Fuel for OpenStack 9.0

Bug Description

Deploy cluster in HA mode with Neutron GRE

Scenario:
1. Create cluster
2. Add 3 nodes with controller role
3. Add 2 nodes with compute role
4. Deploy the cluster
5. Run network verification
6. Run OSTF

ACTUAL RESULT:
OStf test failed with:
fuel_health.common.test_mixins: INFO: STEP:3, verify action: 'floating IP creation'
fuel_health.common.test_mixins: INFO: STEP:3, verify action: 'floating IP assignment'
fuel_health.nmanager: DEBUG: Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/fuel_health/nmanager.py", line 740, in _assign_floating_ip_to_instance
    client.servers.add_floating_ip(server, floating_ip)
  File "/usr/lib/python2.7/site-packages/novaclient/v2/servers.py", line 651, in add_floating_ip
    self._action('addFloatingIp', server, {'address': address})
  File "/usr/lib/python2.7/site-packages/novaclient/v2/servers.py", line 1279, in _action
    return self.api.client.post(url, body=body)
  File "/usr/lib/python2.7/site-packages/novaclient/client.py", line 449, in post
    return self._cs_request(url, 'POST', **kwargs)
  File "/usr/lib/python2.7/site-packages/novaclient/client.py", line 424, in _cs_request
    resp, body = self._time_request(url, method, **kwargs)
  File "/usr/lib/python2.7/site-packages/novaclient/client.py", line 397, in _time_request
    resp, body = self.request(url, method, **kwargs)
  File "/usr/lib/python2.7/site-packages/novaclient/client.py", line 391, in request
    raise exceptions.from_response(resp, body, url, method)
BadRequest: Unable to associate floating ip 10.109.15.131 to fixed ip 10.109.16.5 for instance 8d6103c6-acc0-4102-a810-9146589e6291. Error: (_mysql_exceptions.OperationalError) (1213, 'Deadlock found when trying to get lock; try restarting transaction')

VERSION:
  feature_groups:
    - mirantis
  production: "docker"
  release: "8.0"
  api: "1.0"
  build_number: "396"
  build_id: "396"
  fuel-nailgun_sha: "c4ce9832b299a23f7b5399dde4b0ee33ad87dc5f"
  python-fuelclient_sha: "4f234669cfe88a9406f4e438b1e1f74f1ef484a5"
  fuel-agent_sha: "df16d41cd7a9445cf82ad9fd8f0d53824711fcd8"
  fuel-nailgun-agent_sha: "92ebd5ade6fab60897761bfa084aefc320bff246"
  astute_sha: "c7ca63a49216744e0bfdfff5cb527556aad2e2a5"
  fuel-library_sha: "4b88706dd871af9e33251d8d0a99ac6e3d5fecad"
  fuel-ostf_sha: "42341825fca3ca5cc00ae7207fba0e77ea4bd760"
  fuel-mirror_sha: "8bb8c70efc61bcf633e02d6054dbf5ec8dcf6699"
  fuelmenu_sha: "43c9c2c0a60d70c311e9107ea2e4ea5fcbe3bb80"
  shotgun_sha: "63645dea384a37dde5c01d4f8905566978e5d906"
  network-checker_sha: "9f0ba4577915ce1e77f5dc9c639a5ef66ca45896"
  fuel-upgrade_sha: "616a7490ec7199f69759e97e42f9b97dfc87e85b"
  fuelmain_sha: "b4196a448a68be81e1bda73617f4b83643392b67"

I re-run tests and its passed

Tags:

Revision history for this message

Tatyanka (tatyana-leontovich) wrote on 2016-01-05:

fail_error_deploy_neutron_gre_ha-fuel-snapshot-2016-01-04_22-56-55.tar.xz Edit (73.6 MiB, application/octet-stream)

Artem Roma (aroma-x) on 2016-01-05

tags:	added: area-mos
Changed in fuel:
status:	New → Confirmed
assignee:	nobody → MOS Nova (mos-nova)

Revision history for this message

Bug Checker Bot (bug-checker) wrote on 2016-03-28: Autochecker

(This check performed automatically)
Please, make sure that bug description contains the following sections filled in with the appropriate data related to the bug you are describing:

expected result

steps to reproduce

For more detailed information on the contents of each of the listed sections see https://wiki.openstack.org/wiki/Fuel/How_to_contribute#Here_is_how_you_file_a_bug