Package: src:cloudkitty Version: 8.0.0-4 Severity: serious Tags: ftbfs Dear maintainer:
I tried to build this package in buster but it failed: -------------------------------------------------------------------------------- [...] debian/rules build-indep pyversions: missing X(S)-Python-Version in control file, fall back to debian/pyversions pyversions: missing debian/pyversions file, fall back to supported versions py3versions: no X-Python3-Version in control file, using supported versions dh build-indep --buildsystem=python_distutils --with python3,sphinxdoc,systemd dh_update_autotools_config -i -O--buildsystem=python_distutils dh_autoreconf -i -O--buildsystem=python_distutils dh_auto_configure -i -O--buildsystem=python_distutils dh_auto_configure: Please use the third-party "pybuild" build system instead of python-distutils dh_auto_configure: This feature will be removed in compat 12. debian/rules override_dh_auto_build make[1]: Entering directory '/<<PKGBUILDDIR>>' pyversions: missing X(S)-Python-Version in control file, fall back to debian/pyversions pyversions: missing debian/pyversions file, fall back to supported versions [... snipped ...] INFO [alembic.runtime.migration] Running upgrade 464e951dc3b8 -> 2ac2217dcbd9, Added support for meta collector INFO [alembic.runtime.migration] Running upgrade 2ac2217dcbd9 -> 385e33fef139, Added priority to modules_state. cloudkitty.tests.transformers.test_gnocchi.GnocchiTransformerTest.test_strip_gnocchi_volume(sqlite) cloudkitty.tests.transformers.test_gnocchi.GnocchiTransformerTest.test_strip_gnocchi_volume(sqlite) ... ok ====================================================================== FAIL: cloudkitty.tests.storage.v1.test_storage.StorageTotalTest.test_get_total_groupby_tenant_and_restype(sqlite,sqlalchemy,sqlalchemy) cloudkitty.tests.storage.v1.test_storage.StorageTotalTest.test_get_total_groupby_tenant_and_restype(sqlite,sqlalchemy,sqlalchemy) ---------------------------------------------------------------------- _StringException: Traceback (most recent call last): File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 758, in visit_textual_label_reference col = with_cols[element.element] KeyError: 'res_type,tenant_id' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/<<PKGBUILDDIR>>/cloudkitty/tests/storage/v1/test_storage.py", line 249, in test_get_total_groupby_tenant_and_restype groupby=['project_id', 'type']) File "/<<PKGBUILDDIR>>/cloudkitty/storage/__init__.py", line 122, in total groupby=storage_gby) File "/<<PKGBUILDDIR>>/cloudkitty/storage/v1/sqlalchemy/__init__.py", line 134, in get_total results = q.all() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 2925, in all return list(self) File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 3081, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 3106, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 980, in execute return meth(self, multiparams, params) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 273, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1090, in _execute_clauseelement else None, File "<string>", line 1, in <lambda> File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 448, in compile return self._compiler(dialect, bind=bind, **kw) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 454, in _compiler return dialect.statement_compiler(dialect, self, **kw) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 553, in __init__ Compiled.__init__(self, dialect, statement, **kwargs) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 310, in __init__ self.string = self.process(self.statement, **compile_kwargs) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 341, in process return obj._compiler_dispatch(self, **kwargs) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch return meth(self, **kw) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 2068, in visit_select text, select, inner_columns, froms, byfrom, kwargs File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 2172, in _compose_select_body text += self.group_by_clause(select, **kwargs) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 2230, in group_by_clause group_by = select._group_by_clause._compiler_dispatch(self, **kw) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch return meth(self, **kw) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 961, in visit_clauselist c._compiler_dispatch(self, **kw) for c in clauselist.clauses File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 959, in <genexpr> s File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 961, in <genexpr> c._compiler_dispatch(self, **kw) for c in clauselist.clauses File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch return meth(self, **kw) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 763, in visit_textual_label_reference "Can't resolve label reference for ORDER BY / GROUP BY.", File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 4441, in _no_text_coercion "extra": "%s " % extra if extra else "", sqlalchemy.exc.CompileError: Can't resolve label reference for ORDER BY / GROUP BY. Textual SQL expression 'res_type,tenant_id' should be explicitly declared as text('res_type,tenant_id') ====================================================================== FAIL: cloudkitty.tests.storage.v1.test_storage.StorageTotalTest.test_get_total_groupby_tenant_and_restype(sqlite,hybrid,sqlalchemy) cloudkitty.tests.storage.v1.test_storage.StorageTotalTest.test_get_total_groupby_tenant_and_restype(sqlite,hybrid,sqlalchemy) ---------------------------------------------------------------------- _StringException: Traceback (most recent call last): File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 758, in visit_textual_label_reference col = with_cols[element.element] KeyError: 'res_type,tenant_id' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/<<PKGBUILDDIR>>/cloudkitty/tests/storage/v1/test_storage.py", line 249, in test_get_total_groupby_tenant_and_restype groupby=['project_id', 'type']) File "/<<PKGBUILDDIR>>/cloudkitty/storage/__init__.py", line 122, in total groupby=storage_gby) File "/<<PKGBUILDDIR>>/cloudkitty/storage/v1/sqlalchemy/__init__.py", line 134, in get_total results = q.all() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 2925, in all return list(self) File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 3081, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 3106, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 980, in execute return meth(self, multiparams, params) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 273, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1090, in _execute_clauseelement else None, File "<string>", line 1, in <lambda> File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 448, in compile return self._compiler(dialect, bind=bind, **kw) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 454, in _compiler return dialect.statement_compiler(dialect, self, **kw) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 553, in __init__ Compiled.__init__(self, dialect, statement, **kwargs) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 310, in __init__ self.string = self.process(self.statement, **compile_kwargs) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 341, in process return obj._compiler_dispatch(self, **kwargs) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch return meth(self, **kw) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 2068, in visit_select text, select, inner_columns, froms, byfrom, kwargs File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 2172, in _compose_select_body text += self.group_by_clause(select, **kwargs) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 2230, in group_by_clause group_by = select._group_by_clause._compiler_dispatch(self, **kw) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch return meth(self, **kw) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 961, in visit_clauselist c._compiler_dispatch(self, **kw) for c in clauselist.clauses File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 959, in <genexpr> s File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 961, in <genexpr> c._compiler_dispatch(self, **kw) for c in clauselist.clauses File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 90, in _compiler_dispatch return meth(self, **kw) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/compiler.py", line 763, in visit_textual_label_reference "Can't resolve label reference for ORDER BY / GROUP BY.", File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 4441, in _no_text_coercion "extra": "%s " % extra if extra else "", sqlalchemy.exc.CompileError: Can't resolve label reference for ORDER BY / GROUP BY. Textual SQL expression 'res_type,tenant_id' should be explicitly declared as text('res_type,tenant_id') ---------------------------------------------------------------------- Ran 209 tests in 32.057s FAILED (failures=2) make[1]: *** [debian/rules:36: override_dh_install] Error 1 make[1]: Leaving directory '/<<PKGBUILDDIR>>' make: *** [debian/rules:6: binary-indep] Error 2 dpkg-buildpackage: error: fakeroot debian/rules binary-indep subprocess returned exit status 2 -------------------------------------------------------------------------------- (The above is just how the build ends and not necessarily the most relevant part) The build was made in my autobuilder with "dpkg-buildpackage -A" and it also fails here: https://tests.reproducible-builds.org/debian/rb-pkg/unstable/amd64/cloudkitty.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.