[Python-modules-team] Bug#906334: alembic: FTBFS in buster/sid (failing tests)

[Santiago Vila]

Package: src:alembic
Version: 0.9.7-1
Severity: serious
Tags: ftbfs

Dear maintainer:

I tried to build this package in buster but it failed:

--------------------------------------------------------------------------------
[...]
 debian/rules build-indep
dh build-indep --with python2,python3,sphinxdoc --buildsystem=pybuild
   dh_update_autotools_config -i -O--buildsystem=pybuild
   dh_autoreconf -i -O--buildsystem=pybuild
   dh_auto_configure -i -O--buildsystem=pybuild
I: pybuild base:217: python2.7 setup.py config 
running config
I: pybuild base:217: python3.6 setup.py config 
running config
   dh_auto_build -i -O--buildsystem=pybuild
I: pybuild base:217: /usr/bin/python setup.py build 
running build
running build_py
creating /<<PKGBUILDDIR>>/.pybuild/cpython2_2.7_alembic/build/alembic

[... snipped ...]

Traceback (most recent call last):
  File "/<<PKGBUILDDIR>>/.pybuild/cpython2_2.7_alembic/build/tests/test_op.py", line 355, in test_alter_column_schema_schema_type_unnamed
    'ALTER TABLE foo.t ADD CHECK (c IN (0, 1))'
  File "/<<PKGBUILDDIR>>/.pybuild/cpython2_2.7_alembic/build/alembic/testing/fixtures.py", line 130, in assert_
    eq_(buf.lines, list(sql))
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/testing/assertions.py", line 222, in eq_
    assert a == b, msg or "%r != %r" % (a, b)
AssertionError: [u'ALTER TABLE foo.t ALTER COLUMN c BIT'] != ['ALTER TABLE foo.t ALTER COLUMN c BIT', 'ALTER TABLE foo.t ADD CHECK (c IN (0, 1))']
______________ OpTest.test_alter_column_schema_type_existing_type ______________
Traceback (most recent call last):
  File "/<<PKGBUILDDIR>>/.pybuild/cpython2_2.7_alembic/build/tests/test_op.py", line 380, in test_alter_column_schema_type_existing_type
    'ALTER TABLE t ALTER COLUMN c VARCHAR(10)'
  File "/<<PKGBUILDDIR>>/.pybuild/cpython2_2.7_alembic/build/alembic/testing/fixtures.py", line 130, in assert_
    eq_(buf.lines, list(sql))
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/testing/assertions.py", line 222, in eq_
    assert a == b, msg or "%r != %r" % (a, b)
AssertionError: [u'ALTER TABLE t ALTER COLUMN c VARCHAR(10)'] != ['ALTER TABLE t DROP CONSTRAINT xyz', 'ALTER TABLE t ALTER COLUMN c VARCHAR(10)']
__________________ OpTest.test_alter_column_schema_type_named __________________
Traceback (most recent call last):
  File "/<<PKGBUILDDIR>>/.pybuild/cpython2_2.7_alembic/build/tests/test_op.py", line 363, in test_alter_column_schema_type_named
    'ALTER TABLE t ADD CONSTRAINT xyz CHECK (c IN (0, 1))'
  File "/<<PKGBUILDDIR>>/.pybuild/cpython2_2.7_alembic/build/alembic/testing/fixtures.py", line 130, in assert_
    eq_(buf.lines, list(sql))
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/testing/assertions.py", line 222, in eq_
    assert a == b, msg or "%r != %r" % (a, b)
AssertionError: [u'ALTER TABLE t ALTER COLUMN c BIT'] != ['ALTER TABLE t ALTER COLUMN c BIT', 'ALTER TABLE t ADD CONSTRAINT xyz CHECK (c IN (0, 1))']
_________________ OpTest.test_alter_column_schema_type_unnamed _________________
Traceback (most recent call last):
  File "/<<PKGBUILDDIR>>/.pybuild/cpython2_2.7_alembic/build/tests/test_op.py", line 347, in test_alter_column_schema_type_unnamed
    'ALTER TABLE t ADD CHECK (c IN (0, 1))'
  File "/<<PKGBUILDDIR>>/.pybuild/cpython2_2.7_alembic/build/alembic/testing/fixtures.py", line 130, in assert_
    eq_(buf.lines, list(sql))
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/testing/assertions.py", line 222, in eq_
    assert a == b, msg or "%r != %r" % (a, b)
AssertionError: [u'ALTER TABLE t ALTER COLUMN c BIT'] != ['ALTER TABLE t ALTER COLUMN c BIT', 'ALTER TABLE t ADD CHECK (c IN (0, 1))']
=========================== short test summary info ============================
FAIL tests/test_op.py::OpTest::()::test_alter_column_schema_schema_type_existing_type
FAIL tests/test_op.py::OpTest::()::test_alter_column_schema_schema_type_named
FAIL tests/test_op.py::OpTest::()::test_alter_column_schema_schema_type_unnamed
FAIL tests/test_op.py::OpTest::()::test_alter_column_schema_type_existing_type
FAIL tests/test_op.py::OpTest::()::test_alter_column_schema_type_named
FAIL tests/test_op.py::OpTest::()::test_alter_column_schema_type_unnamed
============== 6 failed, 885 passed, 213 skipped in 7.83 seconds ===============
E: pybuild pybuild:338: test: plugin distutils failed with: exit code=1: cd /<<PKGBUILDDIR>>/.pybuild/cpython2_2.7_alembic/build; python2.7 -m pytest tests
dh_auto_test: pybuild --test --test-pytest -i python{version} -p 2.7 returned exit code 13
make: *** [debian/rules:9: build-indep] Error 25
dpkg-buildpackage: error: debian/rules build-indep subprocess returned exit status 2
--------------------------------------------------------------------------------

The build was made with "dpkg-buildpackage -A" in my autobuilder.
Most probably, it also fails here in reproducible builds:

https://tests.reproducible-builds.org/debian/rb-pkg/unstable/amd64/alembic.html

where you can get a full build log if you need it.

If this is really a bug in one of the build-depends, please use reassign and affects,
so that this is still visible in the BTS web page for this package.

Thanks.