py27 unit tests failing due to psycopg2 warnings

[Matt Riedemann]

Seen here:

http://logs.openstack.org/64/623564/6/check/openstack-tox-py27/04e4072/testr_results.html.gz

2019-01-15 15:27:49.148748 | ubuntu-xenial | {0} migrate.tests.versioning.test_shell.TestShellDatabase.test_command_test [16.159900s] ... FAILED
2019-01-15 15:27:49.148789 | ubuntu-xenial |
2019-01-15 15:27:49.148853 | ubuntu-xenial | Captured traceback:
2019-01-15 15:27:49.148915 | ubuntu-xenial | ~~~~~~~~~~~~~~~~~~~
2019-01-15 15:27:49.149008 | ubuntu-xenial | Traceback (most recent call last):
2019-01-15 15:27:49.149148 | ubuntu-xenial | File "<decorator-gen-185>", line 2, in test_command_test
2019-01-15 15:27:49.149296 | ubuntu-xenial | File "migrate/tests/fixture/database.py", line 109, in dec
2019-01-15 15:27:49.149372 | ubuntu-xenial | six.reraise(*fail)
2019-01-15 15:27:49.149509 | ubuntu-xenial | File "migrate/tests/fixture/database.py", line 96, in dec
2019-01-15 15:27:49.149580 | ubuntu-xenial | f(self, *a, **kw)
2019-01-15 15:27:49.149749 | ubuntu-xenial | File "migrate/tests/versioning/test_shell.py", line 389, in test_command_test
2019-01-15 15:27:49.149927 | ubuntu-xenial | result = self.env.run('migrate version_control %s %s' % (self.url, repos_path))
2019-01-15 15:27:49.150221 | ubuntu-xenial | File "/home/zuul/src/git.openstack.org/openstack/sqlalchemy-migrate/.tox/py27/local/lib/python2.7/site-packages/scripttest.py", line 275, in run
2019-01-15 15:27:49.150331 | ubuntu-xenial | result.assert_no_stderr(quiet)
2019-01-15 15:27:49.150646 | ubuntu-xenial | File "/home/zuul/src/git.openstack.org/openstack/sqlalchemy-migrate/.tox/py27/local/lib/python2.7/site-packages/scripttest.py", line 437, in assert_no_stderr
2019-01-15 15:27:49.150777 | ubuntu-xenial | raise AssertionError("stderr output not expected")
2019-01-15 15:27:49.150891 | ubuntu-xenial | AssertionError: stderr output not expected

Because of this warning:

2019-01-15 15:27:48.852830 | ubuntu-xenial | Script result: migrate version_control postgresql://openstack_citest:openstack_citest@localhost/openstack_citest /tmp/tmpRb6e80/hk8Qrq
2019-01-15 15:27:48.854782 | ubuntu-xenial | -- stderr: --------------------
2019-01-15 15:27:48.878414 | ubuntu-xenial | /home/zuul/src/git.openstack.org/openstack/sqlalchemy-migrate/.tox/py27/local/lib/python2.7/site-packages/psycopg2/__init__.py:144: UserWarning: The psycopg2 wheel package will be renamed from release 2.8; in order to keep installing from binary please use "pip install psycopg2-binary" instead. For details see: <http://initd.org/psycopg/docs/install.html#binary-install-from-pypi>.

[Matt Riedemann (mriedem)]

Fix proposed here: https://review.openstack.org/#/c/623956/

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/623956
Committed: https://git.openstack.org/cgit/openstack/sqlalchemy-migrate/commit/?id=f44d07956a2827484cddeee161cbd7724229f92f
Submitter: Zuul
Branch: master

commit f44d07956a2827484cddeee161cbd7724229f92f
Author: Chih-Hsuan Yen <email address hidden>
Date: Mon Dec 10 00:23:08 2018 +0800

    Get rid of psycopg2 warnings by disabling wheels

    The psycopg2 wheel package warnings are causing some tests
    to fail which expect there to be no stderr output. This fixes
    the problem by not using the wheel binary for that package.

    Closes-Bug: #1811876

    Change-Id: Id43e74d8d343ab4e80d1d246543bada1ed4d06ad

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/sqlalchemy-migrate 0.12.0 release.