[Python-apps-team] Bug#917489: buildbot: FTBFS (name 'sqlite3' is not defined)

[Santiago Vila]

Package: src:buildbot
Version: 1.6.0-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 python3,bash-completion,sphinxdoc
   dh_update_autotools_config -i
   dh_autoreconf -i
   debian/rules override_dh_auto_configure
make[1]: Entering directory '/<<PKGBUILDDIR>>'
dh_auto_configure --buildsystem=pybuild --sourcedirectory=master \
	--package=python3-buildbot -- --name=buildbot
	pybuild --configure -i python{version} -p 3.7 --name=buildbot --dir master
I: pybuild base:217: python3.7 setup.py config 
running config
/usr/lib/python3/dist-packages/setuptools/dist.py:470: UserWarning: Normalizing '1.6.0-1' to '1.6.0.post1'
  normalized_version,
dh_auto_configure --buildsystem=pybuild --sourcedirectory=worker \

[... snipped ...]

  File "/<<PKGBUILDDIR>>/debian/python3-buildbot/usr/lib/python3.7/dist-packages/buildbot/db/migrate/versions/050_cascading_deletes_all.py", line 58, in upgrade
    fk.drop()
  File "/usr/lib/python3/dist-packages/migrate/changeset/constraint.py", line 59, in drop
    self.__do_imports('constraintdropper', *a, **kw)
  File "/usr/lib/python3/dist-packages/migrate/changeset/constraint.py", line 32, in __do_imports
    run_single_visitor(engine, visitorcallable, self, *a, **kw)
  File "/usr/lib/python3/dist-packages/migrate/changeset/databases/visitor.py", line 85, in run_single_visitor
    fn(element, **kwargs)
  File "/usr/lib/python3/dist-packages/migrate/changeset/databases/sqlite.py", line 211, in visit_migrate_foreign_key_constraint
    self.recreate_table(p[0].table, omit_constraints=[p[0].name])
  File "/usr/lib/python3/dist-packages/migrate/changeset/databases/sqlite.py", line 99, in recreate_table
    tup = sqlite3.sqlite_version_info
builtins.NameError: name 'sqlite3' is not defined

buildbot.test.unit.test_db_migrate_versions_050_cascading_deletes_all.Migration.test_update
-------------------------------------------------------------------------------
Ran 5578 tests in 56.221s

FAILED (skips=303, errors=16, successes=5267)
/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py:374: DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
  args = inspect.formatargspec(*spec)
/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py:384: DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
  spec[2], None, spec[4])
/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py:405: DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
  formatvalue=lambda x: '=' + x)
/usr/lib/python3/dist-packages/sqlalchemy/engine/result.py:182: DeprecationWarning: Using or importing the ABCs from 'collections' instead of from 'collections.abc' is deprecated, and in 3.8 it will stop working
  from collections import Sequence
/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py:374: DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
  args = inspect.formatargspec(*spec)
/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py:384: DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
  spec[2], None, spec[4])
/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py:405: DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
  formatvalue=lambda x: '=' + x)
Exception ignored in: <generator object BuildStep.run at 0x7f9af8c03318>
RuntimeError: generator ignored GeneratorExit
Exception ignored in: <generator object BuildStep.run at 0x7f9af8c035e8>
RuntimeError: generator ignored GeneratorExit
Exception ignored in: <generator object BuildStep.run at 0x7f9af8c03750>
RuntimeError: generator ignored GeneratorExit
Exception ignored in: <_io.FileIO name='/dev/null' mode='rb' closefd=True>
ResourceWarning: unclosed file <_io.TextIOWrapper name='/dev/null' mode='r' encoding='UTF-8'>
E: pybuild pybuild:338: test: plugin custom failed with: exit code=1: PYTHONPATH=/<<PKGBUILDDIR>>/pkg:/<<PKGBUILDDIR>>/debian/python3-buildbot//usr/lib/python3.7/dist-packages:/<<PKGBUILDDIR>>/debian/python3-buildbot-worker//usr/lib/python3.7/dist-packages LC_ALL=C.UTF-8 trial3 --reporter=text buildbot.test buildbot_worker.test
dh_auto_test: pybuild --test -i python{version} -p 3.7 --system=custom "--test-args=PYTHONPATH=/<<PKGBUILDDIR>>/pkg:/<<PKGBUILDDIR>>/debian/python3-buildbot/{install_dir}:/<<PKGBUILDDIR>>/debian/python3-buildbot-worker/{install_dir} LC_ALL=C.UTF-8 trial3 --reporter=text buildbot.test buildbot_worker.test" returned exit code 13
make[1]: *** [debian/rules:31: override_dh_auto_install] Error 25
make[1]: Leaving directory '/<<PKGBUILDDIR>>'
make: *** [debian/rules:55: binary-indep] Error 2
dpkg-buildpackage: error: fakeroot debian/rules binary-indep subprocess returned exit status 2
--------------------------------------------------------------------------------

The build was made in my autobuilder with "dpkg-buildpackage -A"
but it also fails here:

https://tests.reproducible-builds.org/debian/rb-pkg/unstable/amd64/buildbot.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.