Error installing MySQL-python - EnvironmentError: mysql_config not found

[Mark McLoughlin]

http://logs.openstack.org/80/101880/3/gate/gate-nova-python27/648be2a/console.html

2014-07-01 00:55:16.004 | Downloading/unpacking MySQL-python (from -r /home/jenkins/workspace/gate-nova-python27/test-requirements.txt (line 8))
...
2014-07-01 00:55:16.006 |
2014-07-01 00:55:16.006 | File "/home/jenkins/workspace/gate-nova-python27/.tox/py27/build/MySQL-python/setup.py", line 17, in <module>
2014-07-01 00:55:16.006 |
2014-07-01 00:55:16.006 | metadata, options = get_config()
2014-07-01 00:55:16.006 |
2014-07-01 00:55:16.006 | File "setup_posix.py", line 43, in get_config
2014-07-01 00:55:16.007 |
2014-07-01 00:55:16.007 | libs = mysql_config("libs_r")
2014-07-01 00:55:16.007 |
2014-07-01 00:55:16.007 | File "setup_posix.py", line 25, in mysql_config
2014-07-01 00:55:16.007 |
2014-07-01 00:55:16.007 | raise EnvironmentError("%s not found" % (mysql_config.path,))
2014-07-01 00:55:16.008 |
2014-07-01 00:55:16.008 | EnvironmentError: mysql_config not found

I can't tell from the logs, but the error suggests that libmysqlclient-dev isn't installed?

This seems like a very rare error. It's happend 3 times in the last 7 days - once in nova's py27 unit tests, and once each in nova and trove's docs jobs

[OpenStack Infra (hudson-openstack)]

Related fix proposed to branch: master
Review: https://review.openstack.org/103746

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/103746
Committed: https://git.openstack.org/cgit/openstack-infra/elastic-recheck/commit/?id=e73ee91ea12afac0c8a5de8adc8a64ae901853b0
Submitter: Jenkins
Branch: master

commit e73ee91ea12afac0c8a5de8adc8a64ae901853b0
Author: Mark McLoughlin <email address hidden>
Date: Tue Jul 1 07:18:27 2014 +0100

    Add query for rare MySQL-Python install failure

    This has only happened 3 times in the past 7 days, in nova's py27
    unit tests and nova/trove docs jobs.

    Change-Id: Ieceecc1632b0259d12a5ca46be3eba915651dcd5
    Related-Bug: #1336161

[Tim Kuhlman (timkuhlman)]

I am also experiencing this bug, https://review.openstack.org/#/c/107762/
On ubuntu having the libmysqlclient-dev package installed allows the pip install to work correctly.

[Mike Bayer (zzzeek)]

63 fails in 24 hrs, guess this isn't rare now :)

[Jeremy Stanley (fungi)]

Apparently security.ubuntu.com was missing new MySQL 5.5.38-0ubuntu0.14.04.1 related packages mentioned in its Packages file around 1400 UTC yesterday when nodepool images were being updated, and roughly a dozen images in hpcloud ended up missing libmysqlcient-dev. I have deleted the offending images which should have the effect of rolling back to launching further nodes from the previous day's images, but of course the bigger question is how do we prevent further occurrence in the future. That's where Clark's https://review.openstack.org/107946 change comes in.

[Joshua Harlow (harlowja)]

Seen on http://logs.openstack.org/97/107897/2/check/gate-taskflow-python27/db3df74/console.html as well.

[Alan Pevec (apevec)]

We need to reopen this http://lists.openstack.org/pipermail/openstack-dev/2015-January/thread.html#54729

[Alan Pevec (apevec)]

Regression fixed in https://review.openstack.org/#q,I96e2bce655dbf036358ee2c485ce549a33fc2b9f,n,z