sqlalchemy-master jobs broken with ValueError: invalid literal for int() with base 10: '0b1'

[yatin]

Broken since https://github.com/sqlalchemy/sqlalchemy/commit/e93a5e89.

Fails like:-
2023-11-07 10:51:53.328284 | ubuntu-jammy | Failed to import test module: neutron.tests.unit.agent.common.test_ovs_lib
2023-11-07 10:51:53.328310 | ubuntu-jammy | Traceback (most recent call last):
2023-11-07 10:51:53.328335 | ubuntu-jammy | File "/usr/lib/python3.10/unittest/loader.py", line 436, in _find_test_path
2023-11-07 10:51:53.328360 | ubuntu-jammy | module = self._get_module_from_name(name)
2023-11-07 10:51:53.328385 | ubuntu-jammy | File "/usr/lib/python3.10/unittest/loader.py", line 377, in _get_module_from_name
2023-11-07 10:51:53.328411 | ubuntu-jammy | __import__(name)
2023-11-07 10:51:53.328436 | ubuntu-jammy | File "/home/zuul/src/opendev.org/openstack/neutron/neutron/tests/unit/agent/common/test_ovs_lib.py", line 18, in <module>
2023-11-07 10:51:53.328461 | ubuntu-jammy | from neutron_lib import exceptions
2023-11-07 10:51:53.328486 | ubuntu-jammy | File "/home/zuul/src/opendev.org/openstack/neutron/.tox/py310/lib/python3.10/site-packages/neutron_lib/__init__.py", line 17, in <module>
2023-11-07 10:51:53.328511 | ubuntu-jammy | from neutron_lib.db import api # noqa
2023-11-07 10:51:53.328537 | ubuntu-jammy | File "/home/zuul/src/opendev.org/openstack/neutron/.tox/py310/lib/python3.10/site-packages/neutron_lib/db/api.py", line 22, in <module>
2023-11-07 10:51:53.328569 | ubuntu-jammy | from oslo_db.sqlalchemy import enginefacade
2023-11-07 10:51:53.328916 | ubuntu-jammy | File "/home/zuul/src/opendev.org/openstack/neutron/.tox/py310/lib/python3.10/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 28, in <module>
2023-11-07 10:51:53.328952 | ubuntu-jammy | from oslo_db.sqlalchemy import engines
2023-11-07 10:51:53.328979 | ubuntu-jammy | File "/home/zuul/src/opendev.org/openstack/neutron/.tox/py310/lib/python3.10/site-packages/oslo_db/sqlalchemy/engines.py", line 36, in <module>
2023-11-07 10:51:53.329004 | ubuntu-jammy | from oslo_db.sqlalchemy import compat
2023-11-07 10:51:53.329030 | ubuntu-jammy | File "/home/zuul/src/opendev.org/openstack/neutron/.tox/py310/lib/python3.10/site-packages/oslo_db/sqlalchemy/compat/__init__.py", line 18, in <module>
2023-11-07 10:51:53.329055 | ubuntu-jammy | _vers = versionutils.convert_version_to_tuple(__version__)
2023-11-07 10:51:53.329080 | ubuntu-jammy | File "/home/zuul/src/opendev.org/openstack/neutron/.tox/py310/lib/python3.10/site-packages/oslo_utils/versionutils.py", line 90, in convert_version_to_tuple
2023-11-07 10:51:53.329105 | ubuntu-jammy | return tuple(int(part) for part in version_str.split('.'))
2023-11-07 10:51:53.329130 | ubuntu-jammy | File "/home/zuul/src/opendev.org/openstack/neutron/.tox/py310/lib/python3.10/site-packages/oslo_utils/versionutils.py", line 90, in <genexpr>
2023-11-07 10:51:53.329162 | ubuntu-jammy | return tuple(int(part) for part in version_str.split('.'))
2023-11-07 10:51:53.329469 | ubuntu-jammy | ValueError: invalid literal for int() with base 10: '0b1'

Example failure:- https://46050a1a8fa787c1d655-839a87b8a49ad5b15d7c39aaacbfa49e.ssl.cf5.rackcdn.com/900087/2/check/openstack-tox-py310-with-sqlalchemy-master/429b0c2/job-output.txt

Builds:- https://zuul.openstack.org/builds?job_name=openstack-tox-py310-with-sqlalchemy-master&job_name=neutron-functional-with-sqlalchemy-master&skip=0

[OpenStack Infra (hudson-openstack)]

Related fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/neutron/+/900322

[Lajos Katona (lajos-katona)]

related bug (dulicate?) in osloutils: https://bugs.launchpad.net/oslo.utils/+bug/2042886

[Brian Haley (brian-haley)]

Related to https://bugs.launchpad.net/oslo.utils/+bug/2042886

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/neutron/+/900322
Committed: https://opendev.org/openstack/neutron/commit/e1b4a065c73ef7a97ac5451a3d8f60ba30e086a1
Submitter: "Zuul (22348)"
Branch: master

commit e1b4a065c73ef7a97ac5451a3d8f60ba30e086a1
Author: Slawek Kaplonski <email address hidden>
Date: Tue Nov 7 15:29:39 2023 +0100

    Make job openstack-tox-py310-with-sqlalchemy-master non-voting temporary

    Related-bug: #2042939
    Change-Id: I3eee48af327687455453ab6b8d5afb9e137b547c

[yatin (yatinkarel)]

Being fixed in oslo.utils https://review.opendev.org/c/openstack/oslo.utils/+/900343, having release https://review.opendev.org/c/openstack/releases/+/900382, once it's in u-c we should be good.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/neutron/+/900466

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/neutron/+/900466
Committed: https://opendev.org/openstack/neutron/commit/618478d304660e5135169db591edc8fed8d64fee
Submitter: "Zuul (22348)"
Branch: master

commit 618478d304660e5135169db591edc8fed8d64fee
Author: yatin <email address hidden>
Date: Thu Nov 9 12:57:53 2023 +0000

    Revert "Make job openstack-tox-py310-with-sqlalchemy-master non-voting temporary"

    This reverts commit e1b4a065c73ef7a97ac5451a3d8f60ba30e086a1.

    Depends-On: https://review.opendev.org/c/openstack/requirements/+/900517
    Reason for revert: Issue fixed in oslo.utils 6.3.0
    Closes-Bug: #2042939

    Change-Id: Ia8e97c6dd2ae60ddfd180e580830a263c473c576

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/neutron 24.0.0.0b1 development milestone.