Bug 892892

Summary:	games-board/pychess-1.0.3-r2 fails to compile (LIBARCHIVE-SYSTEM): sqlalchemy.exc.ArgumentError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.functions.count at 0x7fe9f6734760; count>] Did you mean to say
Product:	Gentoo Linux	Reporter:	Agostino Sarubbo <ago>
Component:	Current packages	Assignee:	Gentoo Games <games>
Status:	RESOLVED FIXED
Severity:	normal	CC:	ionen, sping
Priority:	Normal
Version:	unspecified
Hardware:	All
OS:	Linux
URL:	https://github.com/pychess/pychess/issues/1961
Whiteboard:
Package list:		Runtime testing required:	---
Bug Depends on:
Bug Blocks:	896956
Attachments:	build.log

Description Agostino Sarubbo gentoo-dev

2023-02-02 07:50:18 UTC

https://blogs.gentoo.org/ago/2020/07/04/gentoo-tinderbox/

Issue: games-board/pychess-1.0.3-r2 fails to compile (LIBARCHIVE-SYSTEM).
Discovered on: amd64 (internal ref: libarchive_tinderbox)

NOTE:
(LIBARCHIVE-SYSTEM) in the summary means that the bug was found on a machine that runs app-alternatives/tar and app-alternatives/cpio with [-gnu,+libarchive] but this bug MAY or MAY NOT BE related to the tar/cpio implementation.

Comment 1 Agostino Sarubbo gentoo-dev

2023-02-02 07:50:20 UTC

Created attachment 849676 [details]
build.log

build log and emerge --info

Comment 2 Sebastian Pipping gentoo-dev

2023-03-08 03:57:21 UTC

I have taken this upstream now, let's see what we get.

Comment 3 Ionen Wolkens gentoo-dev

2023-03-08 04:30:31 UTC

(In reply to Sebastian Pipping from comment #2)
> I have taken this upstream now, let's see what we get.
Thanks, and yeah sqlalchemy-2 broke several packages. Unsure how trivial these are to fix (never looked). It's not great but feel free to add a upper bound like a dev-python/agate-sql did for now.

Comment 4 Larry the Git Cow gentoo-dev

2023-03-08 04:39:35 UTC

The bug has been closed via the following commit(s):

https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=698a74ba9328cdc06c3526f41984d2c186f5ccb6

commit 698a74ba9328cdc06c3526f41984d2c186f5ccb6
Author:     Sebastian Pipping <sping@gentoo.org>
AuthorDate: 2023-03-08 04:27:20 +0000
Commit:     Sebastian Pipping <sping@gentoo.org>
CommitDate: 2023-03-08 04:38:46 +0000

    games-board/pychess: Python 3.11 + require <dev-python/sqlalchemy-2
    
    Closes: https://bugs.gentoo.org/892892
    Closes: https://bugs.gentoo.org/896956
    Signed-off-by: Sebastian Pipping <sping@gentoo.org>

 games-board/pychess/pychess-1.0.3-r3.ebuild | 47 +++++++++++++++++++++++++++++
 1 file changed, 47 insertions(+)