Your message dated Sun, 04 Aug 2019 14:12:34 +0000
with message-id <e1huhfs-0006b8...@fasolo.debian.org>
and subject line Bug#930996: fixed in cloudkitty 8.0.0-4+deb10u1
has caused the Debian Bug report #930996,
regarding cloudkitty: FTBFS in buster (Can't resolve label reference for ORDER 
BY / GROUP BY)
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)


-- 
930996: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=930996
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
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.

--- End Message ---
--- Begin Message ---
Source: cloudkitty
Source-Version: 8.0.0-4+deb10u1

We believe that the bug you reported is fixed in the latest version of
cloudkitty, which is due to be installed in the Debian FTP archive.

A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 930...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Thomas Goirand <z...@debian.org> (supplier of updated cloudkitty package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmas...@ftp-master.debian.org)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Format: 1.8
Date: Fri, 28 Jun 2019 15:01:45 +0200
Source: cloudkitty
Architecture: source
Version: 8.0.0-4+deb10u1
Distribution: buster
Urgency: medium
Maintainer: Debian OpenStack <team+openst...@tracker.debian.org>
Changed-By: Thomas Goirand <z...@debian.org>
Closes: 930996
Changes:
 cloudkitty (8.0.0-4+deb10u1) buster; urgency=medium
 .
   * Add upstream patch to fix FTBFS after we updated SQLAlchemy to fix
     CVE-2019-7164 CVE-2019-7548 (SQL injection) (see debian bug 922669 and
     929321 for more info) (Closes: #930996).
Checksums-Sha1:
 36969979c5376b5e1e842a24adfe1b1752c9dec4 3230 cloudkitty_8.0.0-4+deb10u1.dsc
 6887412a8e77443ada31ca182d0116643b264011 8224 
cloudkitty_8.0.0-4+deb10u1.debian.tar.xz
 df5a4064eb5549572214e13432038db9c104abdf 15081 
cloudkitty_8.0.0-4+deb10u1_amd64.buildinfo
Checksums-Sha256:
 44aa0fac5466facefc976218d83b570c922b925f2ca31128d16564d98218b234 3230 
cloudkitty_8.0.0-4+deb10u1.dsc
 81128c6f9626699a87785c27a716af7cfe60905607d1aaac2cdbc11b5664445c 8224 
cloudkitty_8.0.0-4+deb10u1.debian.tar.xz
 a611ec858e6e18b64db750c7a26e32678e030e7cf5bfda15122c2be4944007e2 15081 
cloudkitty_8.0.0-4+deb10u1_amd64.buildinfo
Files:
 5cdfc885613bf2646a81627fed5413d2 3230 net optional 
cloudkitty_8.0.0-4+deb10u1.dsc
 3606f6a0fe153bd2fb440dc7c74aef2d 8224 net optional 
cloudkitty_8.0.0-4+deb10u1.debian.tar.xz
 840be9e9f18869ab5f84265901f64747 15081 net optional 
cloudkitty_8.0.0-4+deb10u1_amd64.buildinfo

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCAAdFiEEoLGp81CJVhMOekJc1BatFaxrQ/4FAl0++PkACgkQ1BatFaxr
Q/4Euw//WTKxKIbUgs71I0OpYHGswzg4MIc6ka3W+vSx988m8RZ/3nzqNzNiRVOY
2KTdi0H3a0arX561G92PX+uempHzfbKJhgC+5p82mmpqQufPE4CcppB92NmP3/Fw
orN2RKQdPVcohF2bWTQaulIgQBhmLWWlkF+hwcxVjMcGEuo1iflKbdH/Q+Rzb2mZ
m61JBpef8RmW3EMupTExR0oAkbRl0anbUB7lTpRFRLWlahd9pWcz2T6Z4On10Ywm
xes8tWn6Y8vyT1hEf4zPzqmdEwL2ClBHO1BDPOxYK9mloPzFheBkokHTuodUwicf
0fTCf1wR4NQgyxieXWUwrDgaeCj//ygWm5i5c8Yojbg2goGuMYm1Ht3aq9lfScOn
Jgen9Alcr5ru9cvreQTiQ6dnfX6NSPtdARuWOnmkNR+jknVutqXQb6/EGaLC85gE
FQkS2q20eO6v/54+vbgOIlh2CzZCT56aoMdF+SdULdtUCaenKm/erNnpkCYTR/Rm
cVwYuJjlVs1MmoWzTcX0ylJP9Kc35ulXUyT35WuWKeNB/a1P7+vznuX23/pWHjIU
4FWiANjtjZjCKayruebpFWM6Kc1LLyV+8jFWrHSd5dBWQInVrDEPxun0rW7R1FUy
++KL1ln3QLB1Ay191K54w3U3iEgRHw+gx3zm3Qf6ZkX/mCfqXsE=
=++5c
-----END PGP SIGNATURE-----

--- End Message ---

Reply via email to