check-neutron-dsvm-functional constantly fails with MySQL-python in test-requirements

[Ann Taraday]

In change https://review.openstack.org/76520 MySQL-python was added to test-requirements. After that check-neutron-dsvm-functional started to constantly fail with this error log: http://paste.openstack.org/show/88702/

[Eugene Nikanorov (enikanorov)]

That error indicates that a package libmysqlclient-dev is missing in the system where the test is being run.
I guess we need to file this for infra project (openstack-ci)

[Clark Boylan (cboylan)]

This was in the neutron function test job. Neutron (or possibly devstack) is responsible for installing the dependencies it needs on these nodes. These nodes are basically as simple as possible to test that the actual setup of tests works too.

You may need to update devstack or the neutron functional tests depending on how they are set up but this probably isn't an infra team thing (we provide the nodes to run the tests on, what you do with them is up to you).

[Henry Gessau (gessau)]

Some info from IRC discussion in #openstack-neutron:

<HenryG> marun: akamyshnikova: Usually the way to install a system package for the gate is to add it in devstack. Do we need to do this for libmysqlclient-dev?
<marun> HenryG: shouldn't be needed
<marun> HenryG: the fact that it works in the unit test jobs means its being pre-installed on the vm's
<marun> HenryG: why it's not showing up in the functional jobs is likely due to sudo and the changes it makes to the environment

[Clark Boylan (cboylan)]

This isn't quite true. Unit test nodes have lots of system packages installed to accommodate dependencies. Devstack nodes which this test run on do not in order to actually test that devstack works.

So these nodes are different and you can't assume things will be installed because unit tests work.

[Clark Boylan (cboylan)]

Maru and I sat down at the nova meetup and figured out that this is due to the job not telling devstack to install test only dependencies. Setting that flag in the job will install libmysqlclient-dev which will allow mysql-python to be built.

[Launchpad Janitor (janitor)]

[Expired for neutron because there has been no activity for 60 days.]

[Launchpad Janitor (janitor)]

[Expired for OpenStack Core Infrastructure because there has been no activity for 60 days.]