Bug 2098753

Summary: F37FailsToInstall: python3-mycli+ssh, mycli
Product: [Fedora] Fedora Reporter: Miro Hrončok <mhroncok>
Component: mycliAssignee: Terje Røsten <terje.rosten>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 37CC: me, terje.rosten
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: mycli-1.26.1-1.fc37 mycli-1.26.1-1.fc36 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2022-09-18 00:17:50 UTC Type: ---
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, 2045102, 2117176    

Description Miro Hrončok 2022-06-20 09:31:43 UTC
Hello,

Please note that this comment was generated automatically. If you feel that this output has mistakes, please contact me via email (mhroncok).

Your package (mycli) Fails To Install in Fedora 37:

can't install python3-mycli+ssh:
  - nothing provides python3.10dist(paramiko) needed by python3-mycli+ssh-1.25.0-1.fc37.noarch
  - nothing provides python(abi) = 3.10 needed by python3-mycli+ssh-1.25.0-1.fc37.noarch
  
can't install mycli:
  - nothing provides python(abi) = 3.10 needed by mycli-1.25.0-1.fc37.noarch
  - nothing provides python3.10dist(pygments) >= 1.6 needed by mycli-1.25.0-1.fc37.noarch
  - nothing provides python3.10dist(click) >= 7 needed by mycli-1.25.0-1.fc37.noarch
  - nothing provides python3.10dist(configobj) >= 5.0.5 needed by mycli-1.25.0-1.fc37.noarch
  - nothing provides python3.10dist(sqlparse) >= 0.3 needed by mycli-1.25.0-1.fc37.noarch
  - nothing provides python3.10dist(cli-helpers) >= 2.0.1 needed by mycli-1.25.0-1.fc37.noarch
  - nothing provides python3.10dist(cli-helpers[styles]) >= 2.0.1 needed by mycli-1.25.0-1.fc37.noarch
  - nothing provides python3.10dist(cryptography) >= 1 needed by mycli-1.25.0-1.fc37.noarch
  - nothing provides python3.10dist(prompt-toolkit) >= 3.0.5 needed by mycli-1.25.0-1.fc37.noarch
  - nothing provides python3.10dist(pyaes) >= 1.6.1 needed by mycli-1.25.0-1.fc37.noarch
  - nothing provides python3.10dist(pymysql) >= 0.9.2 needed by mycli-1.25.0-1.fc37.noarch
  - nothing provides python3.10dist(pyperclip) >= 1.8 needed by mycli-1.25.0-1.fc37.noarch
  
If you know about this problem and are planning on fixing it, please acknowledge so by setting the bug status to ASSIGNED. If you don't have time to maintain this package, consider orphaning it, so maintainers of dependent packages realize the problem.


If you don't react accordingly to the policy for FTBFS/FTI bugs (https://docs.fedoraproject.org/en-US/fesco/Fails_to_build_from_source_Fails_to_install/), your package may be orphaned in 8+ weeks.


P.S. The data was generated solely from koji buildroot, so it might be newer than the latest compose or the content on mirrors. To reproduce, use the koji/local repo only, e.g. in mock:

    $ mock -r fedora-37-x86_64 --disablerepo='*' --enablerepo=local install python3-mycli+ssh mycli


P.P.S. If this bug has been reported in the middle of upgrading multiple dependent packages, please consider using side tags: https://docs.fedoraproject.org/en-US/fesco/Updates_Policy/#updating-inter-dependent-packages

Thanks!

Comment 1 Miro Hrončok 2022-06-20 10:03:46 UTC
This bugzilla is likely a fallout from the Python 3.11 rebuild.

If your package (or some of the dependencies it has) failed to rebuild during the Python 3.11 rebuild, they now fail to install. To fix this, packages need to be rebuilt in Rawhide.

We will slowly triage the bugzillas, but we'd appreciate your help.

If you know this is blocked by an existing reported build failure or another package not yet rebuilt with Python 3.11, please mark it as such by using the "Depends On"/"Blocks" bugzilla fields. That will help us determine what failures to prioritize.

If this is not Python 3.11 related, please remove the PYTHON3.11 blocking tracker.

Thank you and sorry for the inconvenience. Let me know if you need any help.

Comment 2 Miro Hrončok 2022-06-27 14:49:36 UTC
______________________ test_simple_select_multiple_tables ______________________
    def test_simple_select_multiple_tables():
        tables = extract_tables('select * from abc, def')
>       assert sorted(tables) == [(None, 'abc', None), (None, 'def', None)]
E       TypeError: '<' not supported between instances of 'NoneType' and 'NoneType'
test/test_parseutils.py:24: TypeError
_________________ test_simple_select_with_cols_multiple_tables _________________
    def test_simple_select_with_cols_multiple_tables():
        tables = extract_tables('select a,b from abc, def')
>       assert sorted(tables) == [(None, 'abc', None), (None, 'def', None)]
E       TypeError: '<' not supported between instances of 'NoneType' and 'NoneType'
test/test_parseutils.py:44: TypeError
________________ test_select_with_hanging_comma_multiple_tables ________________
    def test_select_with_hanging_comma_multiple_tables():
        tables = extract_tables('select a, from abc, def')
>       assert sorted(tables) == [(None, 'abc', None), (None, 'def', None)]
E       TypeError: '<' not supported between instances of 'NoneType' and 'NoneType'
test/test_parseutils.py:59: TypeError
_______________ test_select_with_hanging_period_multiple_tables ________________
    def test_select_with_hanging_period_multiple_tables():
        tables = extract_tables('SELECT t1. FROM tabl1 t1, tabl2 t2')
>       assert sorted(tables) == [(None, 'tabl1', 't1'), (None, 'tabl2', 't2')]
E       TypeError: '<' not supported between instances of 'NoneType' and 'NoneType'
test/test_parseutils.py:64: TypeError
_______________________________ test_join_table ________________________________
    def test_join_table():
        tables = extract_tables('SELECT * FROM abc a JOIN def d ON a.id = d.num')
>       assert sorted(tables) == [(None, 'abc', 'a'), (None, 'def', 'd')]
E       TypeError: '<' not supported between instances of 'NoneType' and 'NoneType'
test/test_parseutils.py:93: TypeError

Comment 3 Miro Hrončok 2022-06-27 14:55:39 UTC
Hello,

This is the first reminder (step 3 from https://docs.fedoraproject.org/en-US/fesco/Fails_to_build_from_source_Fails_to_install/#_package_removal_for_long_standing_ftbfs_and_fti_bugs).

If you know about this problem and are planning on fixing it, please acknowledge so by setting the bug status to ASSIGNED. If you don't have time to maintain this package, consider orphaning it, so maintainers of dependent packages realize the problem.

Comment 4 Terje Røsten 2022-06-29 17:00:59 UTC
Fixed by disabling tests for now.

 https://koji.fedoraproject.org/koji/taskinfo?taskID=88891756

Comment 5 Miro Hrončok 2022-06-29 17:09:13 UTC
Disabling all of the tests (or rather ignoring the results of %pytest) is not a fix :(

Could you at least deselect the 5 failing tests instead and let the remaining 223 actually matter?

Comment 6 Terje Røsten 2022-06-29 17:22:29 UTC
I know, but without access to rawhide system, how to fix?  

For now I have verified in koji logs, it's only those 5 failures.

Fixing random test failures in the way too rapid Python 3.N+1 release cycles is low prio, 
having installable package in next Fedora release is more important.

As noted, this very bug is still open.

Comment 7 Ben Cotton 2022-08-09 13:39:22 UTC
This bug appears to have been reported against 'rawhide' during the Fedora Linux 37 development cycle.
Changing version to 37.

Comment 8 Fedora Update System 2022-09-13 18:26:08 UTC
FEDORA-2022-4d37677024 has been submitted as an update to Fedora 37. https://bodhi.fedoraproject.org/updates/FEDORA-2022-4d37677024

Comment 9 Fedora Update System 2022-09-13 18:26:10 UTC
FEDORA-2022-833a7b7364 has been submitted as an update to Fedora 36. https://bodhi.fedoraproject.org/updates/FEDORA-2022-833a7b7364

Comment 10 Fedora Update System 2022-09-14 01:52:46 UTC
FEDORA-2022-4d37677024 has been pushed to the Fedora 37 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --refresh --advisory=FEDORA-2022-4d37677024`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2022-4d37677024

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 11 Fedora Update System 2022-09-14 02:40:22 UTC
FEDORA-2022-833a7b7364 has been pushed to the Fedora 36 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --refresh --advisory=FEDORA-2022-833a7b7364`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2022-833a7b7364

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 12 Fedora Update System 2022-09-18 00:17:50 UTC
FEDORA-2022-4d37677024 has been pushed to the Fedora 37 stable repository.
If problem still persists, please make note of it in this bug report.

Comment 13 Fedora Update System 2022-09-22 01:17:03 UTC
FEDORA-2022-833a7b7364 has been pushed to the Fedora 36 stable repository.
If problem still persists, please make note of it in this bug report.