Fuel 8.0 CI gate-fuel-web-python27 test is failing

[Alexey Stupnikov]

gate-fuel-web-python27 job is failing with several errors. It looks like there is some problem with prepare_database.sh and TLS connections. Please check the logs blow and investigate.

Example review: https://review.openstack.org/#/c/288477/1
Example job: http://logs.openstack.org/77/288477/1/check/gate-fuel-web-python27/0dfbcf9/

2016-03-07 11:53:06.326 | ERROR: InvocationError: '/bin/bash /home/jenkins/workspace/gate-fuel-web-python27/nailgun/tools/prepare_database.sh'
2016-03-07 11:53:06.326 | ___________________________________ summary ____________________________________
2016-03-07 11:53:06.327 | ERROR: py27: commands failed

2016-03-07 11:53:18.203 | + /usr/zuul-swift-logs-env/bin/python /usr/local/jenkins/slave_scripts/zuul_swift_upload.py --name logs '**/*nose_results.html' '**/*testr_results.html.gz' '.testrepository/tmp*' '**/*testrepository.subunit.gz' '.tox/*/log/*' /tmp/console.html
2016-03-07 11:53:19.138 | /usr/zuul-swift-logs-env/local/lib/python2.7/site-packages/requests/packages/urllib3/util/ssl_.py:315: SNIMissingWarning: An HTTPS request has been made, but the SNI (Subject Name Indication) extension to TLS is not available on this platform. This may cause the server to present an incorrect TLS certificate, which can cause validation failures. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#snimissingwarning.
2016-03-07 11:53:19.138 | SNIMissingWarning
2016-03-07 11:53:19.138 | /usr/zuul-swift-logs-env/local/lib/python2.7/site-packages/requests/packages/urllib3/util/ssl_.py:120: InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#insecureplatformwarning.
2016-03-07 11:53:19.138 | InsecurePlatformWarning
2016-03-07 11:53:19.138 | /usr/zuul-swift-logs-env/local/lib/python2.7/site-packages/requests/packages/urllib3/util/ssl_.py:120: InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#insecureplatformwarning.
2016-03-07 11:53:19.138 | InsecurePlatformWarning
2016-03-07 11:53:19.139 | /usr/zuul-swift-logs-env/local/lib/python2.7/site-packages/requests/packages/urllib3/util/ssl_.py:120: InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#insecureplatformwarning.
2016-03-07 11:53:19.139 | InsecurePlatformWarning
2016-03-07 11:53:19.139 | /usr/zuul-swift-logs-env/local/lib/python2.7/site-packages/requests/packages/urllib3/util/ssl_.py:120: InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#insecureplatformwarning.
2016-03-07 11:53:19.139 | InsecurePlatformWarning
2016-03-07 11:53:19.144 | /usr/zuul-swift-logs-env/local/lib/python2.7/site-packages/requests/packages/urllib3/util/ssl_.py:120: InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#insecureplatformwarning.
2016-03-07 11:53:19.144 | InsecurePlatformWarning
2016-03-07 11:53:19.182 | /usr/zuul-swift-logs-env/local/lib/python2.7/site-packages/requests/packages/urllib3/util/ssl_.py:120: InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#insecureplatformwarning.
2016-03-07 11:53:19.182 | InsecurePlatformWarning
2016-03-07 11:53:20.098 | http://logs.openstack.org/77/288477/1/check/gate-fuel-web-python27/0dfbcf9/
2016-03-07 11:53:20.198 | Finished: FAILURE

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/289429

[OpenStack Infra (hudson-openstack)]

Change abandoned by Igor Kalnitsky (<email address hidden>) on branch: master
Review: https://review.openstack.org/289429

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/289278
Committed: https://git.openstack.org/cgit/openstack/fuel-web/commit/?id=73dcf257d1dca89d2561084031b3b64c746925a2
Submitter: Jenkins
Branch: master

commit 73dcf257d1dca89d2561084031b3b64c746925a2
Author: Igor Kalnitsky <email address hidden>
Date: Mon Mar 7 13:21:50 2016 +0200

    Use PostgreSQL setup provided by OpenStack Infra

    Since commit Id65b7e106d62be92467c18bcb93c9d5da716242f we do not need to
    setup PostgreSQL for tests. Now OpenStack Infra provides ready to use
    PostgreSQL installation as well as MySQL. This commit stops running
    setup code and unblocks gate tests on OpenStack CI.

    Also, it fixes random failures of test_force_redeploy_changes. The test
    used to consume fake threads, and to check status of created task. That
    status might be different and depends on progress of fake threads
    (it might be pending, running or even ready). That commit removes usage
    of fake threads and improves its quality by checking not only task status,
    but actualy deployment data.

    Also, it fixes test_assign_given_vips_for_net_groups.

    The motivation behind that all-in-one commit is that it's almost
    impossible to fix CI due to random test failures. It's the only
    choice to get it work.

    Closes-Bug: #1554038
    Change-Id: I074a2cb4f0e6647c605c8e4449a5beca0c6e9bbc

[Alexey Stupnikov (astupnikov)]

Igor, you have committed a patch to master branch. Pls doublecheck this bug's status for 8.0.

[Nastya Urlapova (aurlapova)]

it works for 9.0 http://logs.openstack.org/85/293985/3/check/gate-fuel-web-python27/c12b1c3/console.html.gz

[Alexey Stupnikov (astupnikov)]

Fix was merged to 8.0 branch: https://review.openstack.org/#/c/290490/