Your message dated Fri, 28 Jun 2019 13:34:03 +0000
with message-id <e1hgr0t-00097r...@fasolo.debian.org>
and subject line Bug#930996: fixed in cloudkitty 8.0.0-5
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-5

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
Binary: cloudkitty-api cloudkitty-common cloudkitty-doc cloudkitty-processor 
python3-cloudkitty
Architecture: source all
Version: 8.0.0-5
Distribution: unstable
Urgency: medium
Maintainer: Debian OpenStack <team+openst...@tracker.debian.org>
Changed-By: Thomas Goirand <z...@debian.org>
Description:
 cloudkitty-api - OpenStack Rating as a Service - API server
 cloudkitty-common - OpenStack Rating as a Service - common files
 cloudkitty-doc - OpenStack Rating as a Service - Documentation
 cloudkitty-processor - OpenStack Rating as a Service - processor
 python3-cloudkitty - OpenStack Rating as a Service - Python library
Closes: 930996
Changes:
 cloudkitty (8.0.0-5) unstable; 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:
 3b7871fe94739c7a910a0c5135c604d196b48948 3198 cloudkitty_8.0.0-5.dsc
 3e5d9b261464a01268846d2041e0e9bad0a3b949 8204 cloudkitty_8.0.0-5.debian.tar.xz
 27be7c2dd6ef4d9f1d46b5d521873c78be684b15 21720 cloudkitty-api_8.0.0-5_all.deb
 6287414614e4560db5596f1136ab5b7973f95794 36004 
cloudkitty-common_8.0.0-5_all.deb
 075dae36c876af13dd1f1a78629dccabd5e6f53a 955888 cloudkitty-doc_8.0.0-5_all.deb
 2a085d89e64142547793527030b8ead8a7201dee 6256 
cloudkitty-processor_8.0.0-5_all.deb
 c1ab8d210d23c9c5d7c08827fb06aaa484ce290e 14966 
cloudkitty_8.0.0-5_amd64.buildinfo
 d9c1950e58a6d5d5dad05a2b88596812f054b21c 105280 
python3-cloudkitty_8.0.0-5_all.deb
Checksums-Sha256:
 48de9026390b4e86368a174926ebbf5f9fde71157e2f21a29fe94ee27c6d31a3 3198 
cloudkitty_8.0.0-5.dsc
 122e4c74d19b48b583ed7e7edb133672e27c42ee45cae251261bdd63f57138ac 8204 
cloudkitty_8.0.0-5.debian.tar.xz
 2584e87662d96078f300cbdd02c6845e88dcd847c4c6a17647244cec2eb67cbc 21720 
cloudkitty-api_8.0.0-5_all.deb
 fb5486fc1c65c631473f6d970ef2474c12d8ce3001c9e5123364cc9940bd7da5 36004 
cloudkitty-common_8.0.0-5_all.deb
 72b2a6d1df4d54d988c3385c630d7ad6268beb896814a07ec190b20a6b39eeb6 955888 
cloudkitty-doc_8.0.0-5_all.deb
 dcec55b7eacdcc64ec9c90560c5591461c58effff71220ecad8627fe2707ee26 6256 
cloudkitty-processor_8.0.0-5_all.deb
 9c2b999c645bb909ff0f41a220ec8aada81cbab0d6a82ecd0eff92acb9b67e5c 14966 
cloudkitty_8.0.0-5_amd64.buildinfo
 243ca2aea9712bb4de872678043f7380ca6f8598ece95a3df2375313feccdf02 105280 
python3-cloudkitty_8.0.0-5_all.deb
Files:
 795f5c9255d868ed6643d8fda590e0f1 3198 net optional cloudkitty_8.0.0-5.dsc
 08a398de61a187cf10ece7edc419c387 8204 net optional 
cloudkitty_8.0.0-5.debian.tar.xz
 a22362f03bed598026f39ba5d4eac3de 21720 net optional 
cloudkitty-api_8.0.0-5_all.deb
 863de872a09c96bce19fbcdcff94745d 36004 net optional 
cloudkitty-common_8.0.0-5_all.deb
 f7c4534c062229dd4cb94e48e79dd859 955888 doc optional 
cloudkitty-doc_8.0.0-5_all.deb
 3d1adead74818fcc3826bce55db05207 6256 net optional 
cloudkitty-processor_8.0.0-5_all.deb
 09af70a342d26e8039cddc2d792e46f2 14966 net optional 
cloudkitty_8.0.0-5_amd64.buildinfo
 35691881b8e4169dbf1c4896850e56eb 105280 python optional 
python3-cloudkitty_8.0.0-5_all.deb

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

iQIzBAEBCAAdFiEEtKCq/KhshgVdBnYUq1PlA1hod6YFAl0WEdoACgkQq1PlA1ho
d6bmBw//cTROtlqfnjAhz0XLTQUoBFozUul7hGm6oPsw0Rp5akFG32wiOzWdT8hj
5DuQbRL1zO36ice8oylENG0UfAgbpNcK+EITsUedtYMcekzLrDHL/BkXBE/HOX5p
7xxKZqvMB+xyzZYkxO65MEqS+IAsnYMpUp5eByz8qqCFu+6BWAkLrh0ty9rTZZvj
j8PGxwZwht9G3xd61VxmS3pZPVGxgLM7KSF08Nn5fUV2/DWTbl+VG/0GBU7xOyhO
ynR4zyfIrjE7qytlGfImNZT2886tIh83IgCvtaWbqICIpV4aivYFbv6418jAKu4S
uiBC9Qic/ADBv6eYfWuefJ5CRtWL5nfm627yM+/A4ZRSK5IELINwXDYXKM5PO7yc
JEvJqYgh+nOnlGjkILriuTSUrLmF/fTul97nNzkJ+EjNhJ5h+E8XdIvQ4RKsHwpI
RN6h3M7x57ikbUuAbdMiX6c9S9SVLmxJ1aNbX+aR8zGIxFjyqW9bxi1mHnsdkgBC
VoSywY3+90XrnPiLsIQDEFjdlg1vV81XUexKC/GXMgNR74oTYzBxBNApAjONOIuv
oTYfF3QCXulvbMYWeRB4073j1PHCp5qBljxl9WBqT9KEUKGsqXlqia/GB3J/7miq
w7XUWkHWxntVuYQGIvACAlkXo6uS01GGF9CuJvZBuKIfzZ7wVO8=
=2T38
-----END PGP SIGNATURE-----

--- End Message ---

Reply via email to