Bug 2042868

Summary: python-sqlalchemy fails to build with Python 3.11: TypeError: '<' not supported between instances of 'Mapper' and 'Mapper'
Product: [Fedora] Fedora Reporter: Tomáš Hrnčiar <thrnciar>
Component: python-sqlalchemyAssignee: Nils Philippsen <nphilipp>
Status: CLOSED RAWHIDE QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: rawhideCC: infra-sig, lewk, mbacovsk, mbayer, mhroncok, nphilipp, thrnciar
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: python-sqlalchemy-1.4.31-1.fc36 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2022-01-21 12:27:51 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 2016048, 2050081    

Description Tomáš Hrnčiar 2022-01-20 09:47:06 UTC
python-sqlalchemy fails to build with Python 3.11.0a4.

=================================== FAILURES ===================================
_________ BulkInsertUpdateTest.test_bulk_save_mappings_preserve_order __________
[gw0] linux -- Python 3.11.0 /usr/bin/python3
Traceback (most recent call last):
  File "/builddir/build/BUILD/SQLAlchemy-1.4.29/test/orm/test_bulk.py", line 169, in test_bulk_save_mappings_preserve_order
    s.bulk_save_objects(objects, preserve_order=False)
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/builddir/build/BUILD/SQLAlchemy-1.4.29/test/../lib/sqlalchemy/orm/session.py", line 3610, in bulk_save_objects
    obj_states = sorted(obj_states, key=key)
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^
TypeError: '<' not supported between instances of 'Mapper' and 'Mapper'
=========================== short test summary info ============================

https://docs.python.org/3.11/whatsnew/3.11.html

For the build logs, see:
https://copr-be.cloud.fedoraproject.org/results/@python/python3.11/fedora-rawhide-x86_64/03203186-python-sqlalchemy/

For all our attempts to build python-sqlalchemy with Python 3.11, see:
https://copr.fedorainfracloud.org/coprs/g/python/python3.11/package/python-sqlalchemy/

Testing and mass rebuild of packages is happening in copr. You can follow these instructions to test locally in mock if your package builds with Python 3.11:
https://copr.fedorainfracloud.org/coprs/g/python/python3.11/

Let us know here if you have any questions.

Python 3.11 is planned to be included in Fedora 37. To make that update smoother, we're building Fedora packages with all pre-releases of Python 3.11.
A build failure prevents us from testing all dependent packages (transitive [Build]Requires), so if this package is required a lot, it's important for us to get it fixed soon.
We'd appreciate help from the people who know this package best, but if you don't want to work on this now, let us know so we can try to work around it on our side.