[9.0][BVT] Task verify_networks fails with 400 Bad Request

[Roman Podoliaka]

9.0 BVT build ( https://ci.fuel-infra.org/job/9.0-community.main.ubuntu.bvt_2/767/ ) failed with:

Traceback (most recent call last):
  File "/home/jenkins/venv-nailgun-tests-2.9/local/lib/python2.7/site-packages/proboscis/case.py", line 296, in testng_method_mistake_capture_func
    compatability.capture_type_error(s_func)
  File "/home/jenkins/venv-nailgun-tests-2.9/local/lib/python2.7/site-packages/proboscis/compatability/exceptions_2_6.py", line 27, in capture_type_error
    func()
  File "/home/jenkins/venv-nailgun-tests-2.9/local/lib/python2.7/site-packages/proboscis/case.py", line 350, in func
    func(test_case.state.get_state())
  File "/home/jenkins/workspace/9.0-community.main.ubuntu.bvt_2/fuelweb_test/helpers/decorators.py", line 120, in wrapper
    result = func(*args, **kwargs)
  File "/home/jenkins/workspace/9.0-community.main.ubuntu.bvt_2/fuelweb_test/tests/test_ceph.py", line 510, in ceph_rados_gw
    self.fuel_web.verify_network(cluster_id)
  File "/home/jenkins/workspace/9.0-community.main.ubuntu.bvt_2/fuelweb_test/helpers/decorators.py", line 362, in wrapper
    return func(*args, **kwargs)
  File "/home/jenkins/workspace/9.0-community.main.ubuntu.bvt_2/core/helpers/log_helpers.py", line 215, in wrapped
    result = func(*args, **kwargs)
  File "/home/jenkins/workspace/9.0-community.main.ubuntu.bvt_2/fuelweb_test/models/fuel_web_client.py", line 1703, in verify_network
    task = self.run_network_verify(cluster_id)
  File "/home/jenkins/workspace/9.0-community.main.ubuntu.bvt_2/core/helpers/log_helpers.py", line 215, in wrapped
    result = func(*args, **kwargs)
  File "/home/jenkins/workspace/9.0-community.main.ubuntu.bvt_2/fuelweb_test/models/fuel_web_client.py", line 1346, in run_network_verify
    return self.client.verify_networks(cluster_id)
  File "/home/jenkins/workspace/9.0-community.main.ubuntu.bvt_2/core/helpers/log_helpers.py", line 215, in wrapped
    result = func(*args, **kwargs)
  File "/home/jenkins/workspace/9.0-community.main.ubuntu.bvt_2/fuelweb_test/models/nailgun_client.py", line 84, in verify_networks
    json=self.get_networks(cluster_id)
  File "/home/jenkins/workspace/9.0-community.main.ubuntu.bvt_2/fuelweb_test/models/nailgun_client.py", line 61, in _put
    return self.session.put(url=url, connect_retries=1, **kwargs)
  File "/home/jenkins/venv-nailgun-tests-2.9/local/lib/python2.7/site-packages/keystoneauth1/session.py", line 683, in put
    return self.request(url, 'PUT', **kwargs)
  File "/home/jenkins/venv-nailgun-tests-2.9/local/lib/python2.7/site-packages/positional/__init__.py", line 101, in inner
    return wrapped(*args, **kwargs)
  File "/home/jenkins/venv-nailgun-tests-2.9/local/lib/python2.7/site-packages/keystoneauth1/session.py", line 570, in request
    raise exceptions.from_response(resp, method, url)
BadRequest: Bad Request (HTTP 400)

[Oleksiy Molchanov (omolchanov)]

2017-01-01T12:30:17.825911+00:00 err: 2017-01-01 12:30:17.807 28387 ERROR keystone.common.wsgi [req-3627c6c9-e1b5-441e-bd7a-c5db3e5b4d81 - - - - -] (_mysql_exceptions.OperationalError) (1047, 'WSREP has not yet prepared node for application use') [SQL: u'SELECT local_user.id AS local_user_id, local_user.user_id AS local_user_user_id, local_user.domain_id AS local_user_domain_id, local_user.name AS local_user_name, anon_1.user_id AS anon_1_user_id \nFROM (SELECT user.id AS user_id \nFROM user \nWHERE user.id = %s) AS anon_1 INNER JOIN local_user ON anon_1.user_id = local_user.user_id ORDER BY anon_1.user_id'] [parameters: ('1ef2d18daa894a63bad8c441cbe46e80',)]
2017-01-01 12:30:17.807 28387 ERROR keystone.common.wsgi Traceback (most recent call last):
2017-01-01 12:30:17.807 28387 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/keystone/common/wsgi.py", line 249, in __call__
2017-01-01 12:30:17.807 28387 ERROR keystone.common.wsgi result = method(context, **params)
2017-01-01 12:30:17.807 28387 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/oslo_log/versionutils.py", line 165, in wrapped
2017-01-01 12:30:17.807 28387 ERROR keystone.common.wsgi return func_or_cls(*args, **kwargs)
2017-01-01 12:30:17.807 28387 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/keystone/token/controllers.py", line 100, in authenticate
2017-01-01 12:30:17.807 28387 ERROR keystone.common.wsgi context, auth)
2017-01-01 12:30:17.807 28387 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/keystone/token/controllers.py", line 303, in _authenticate_local
2017-01-01 12:30:17.807 28387 ERROR keystone.common.wsgi password=password)
2017-01-01 12:30:17.807 28387 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/keystone/common/manager.py", line 124, in wrapped
2017-01-01 12:30:17.807 28387 ERROR keystone.common.wsgi __ret_val = __f(*args, **kwargs)
2017-01-01 12:30:17.807 28387 ERROR keystone.common.wsgi File "/usr/lib/python