zed/antelope ubuntu focal jobs fails at dbcounter installation with TypeError: canonicalize_version() got an unexpected keyword argument 'strip_trailing_zero'

[yatin]

With setuptools>=71.0.0 jobs running on ubuntu-focal(python3.8) where dbcounter is being installed fails as:-
2024-07-19 08:01:16.491799 | controller | Getting requirements to build wheel: started
2024-07-19 08:01:17.387981 | controller | Getting requirements to build wheel: finished with status 'error'
2024-07-19 08:01:17.388246 | controller | ERROR: Command errored out with exit status 1:
2024-07-19 08:01:17.388313 | controller | command: /usr/bin/python3.8 /tmp/tmpmbuwxtfh get_requires_for_build_wheel /tmp/tmpw239ccg4
2024-07-19 08:01:17.388359 | controller | cwd: /tmp/pip-req-build-f7wp4715
2024-07-19 08:01:17.388427 | controller | Complete output (47 lines):
2024-07-19 08:01:17.388477 | controller | running egg_info
2024-07-19 08:01:17.388538 | controller | creating dbcounter.egg-info
2024-07-19 08:01:17.388601 | controller | writing dbcounter.egg-info/PKG-INFO
2024-07-19 08:01:17.388661 | controller | writing dependency_links to dbcounter.egg-info/dependency_links.txt
2024-07-19 08:01:17.388723 | controller | writing entry points to dbcounter.egg-info/entry_points.txt
2024-07-19 08:01:17.388784 | controller | writing top-level names to dbcounter.egg-info/top_level.txt
2024-07-19 08:01:17.388866 | controller | writing manifest file 'dbcounter.egg-info/SOURCES.txt'
2024-07-19 08:01:17.388916 | controller | reading manifest file 'dbcounter.egg-info/SOURCES.txt'
2024-07-19 08:01:17.389003 | controller | /tmp/pip-build-env-b8quib_j/overlay/lib/python3.8/site-packages/_distutils_hack/__init__.py:55: UserWarning: Reliance on distutils from stdlib is deprecated. Users must rely on setuptools to provide the distutils module. Avoid importing distutils or import setuptools first, and avoid setting SETUPTOOLS_USE_DISTUTILS=stdlib. Register concerns at https://github.com/pypa/setuptools/issues/new?template=distutils-deprecation.yml
2024-07-19 08:01:17.389040 | controller | warnings.warn(
2024-07-19 08:01:17.389111 | controller | Traceback (most recent call last):
2024-07-19 08:01:17.389160 | controller | File "/tmp/tmpmbuwxtfh", line 280, in <module>
2024-07-19 08:01:17.389221 | controller | main()
2024-07-19 08:01:17.389271 | controller | File "/tmp/tmpmbuwxtfh", line 263, in main
2024-07-19 08:01:17.389333 | controller | json_out['return_val'] = hook(**hook_input['kwargs'])
2024-07-19 08:01:17.389396 | controller | File "/tmp/tmpmbuwxtfh", line 114, in get_requires_for_build_wheel
2024-07-19 08:01:17.389446 | controller | return hook(config_settings)
2024-07-19 08:01:17.389516 | controller | File "/tmp/pip-build-env-b8quib_j/overlay/lib/python3.8/site-packages/setuptools/build_meta.py", line 327, in get_requires_for_build_wheel
2024-07-19 08:01:17.389565 | controller | return self._get_build_requires(config_settings, requirements=[])
2024-07-19 08:01:17.389631 | controller | File "/tmp/pip-build-env-b8quib_j/overlay/lib/python3.8/site-packages/setuptools/build_meta.py", line 297, in _get_build_requires
2024-07-19 08:01:17.389680 | controller | self.run_setup()
2024-07-19 08:01:17.389745 | controller | File "/tmp/pip-build-env-b8quib_j/overlay/lib/python3.8/site-packages/setuptools/build_meta.py", line 313, in run_setup
2024-07-19 08:01:17.389794 | controller | exec(code, locals())
2024-07-19 08:01:17.389857 | controller | File "<string>", line 1, in <module>
2024-07-19 08:01:17.389919 | controller | File "/tmp/pip-build-env-b8quib_j/overlay/lib/python3.8/site-packages/setuptools/__init__.py", line 108, in setup
2024-07-19 08:01:17.389980 | controller | return distutils.core.setup(**attrs)
2024-07-19 08:01:17.390040 | controller | File "/usr/lib/python3.8/distutils/core.py", line 148, in setup
2024-07-19 08:01:17.390089 | controller | dist.run_commands()
2024-07-19 08:01:17.390151 | controller | File "/usr/lib/python3.8/distutils/dist.py", line 966, in run_commands
2024-07-19 08:01:17.390200 | controller | self.run_command(cmd)
2024-07-19 08:01:17.390264 | controller | File "/tmp/pip-build-env-b8quib_j/overlay/lib/python3.8/site-packages/setuptools/dist.py", line 974, in run_command
2024-07-19 08:01:17.390326 | controller | super().run_command(command)
2024-07-19 08:01:17.390374 | controller | File "/usr/lib/python3.8/distutils/dist.py", line 985, in run_command
2024-07-19 08:01:17.390448 | controller | cmd_obj.run()
2024-07-19 08:01:17.390511 | controller | File "/tmp/pip-build-env-b8quib_j/overlay/lib/python3.8/site-packages/setuptools/command/egg_info.py", line 321, in run
2024-07-19 08:01:17.390559 | controller | self.find_sources()
2024-07-19 08:01:17.390624 | controller | File "/tmp/pip-build-env-b8quib_j/overlay/lib/python3.8/site-packages/setuptools/command/egg_info.py", line 329, in find_sources
2024-07-19 08:01:17.390673 | controller | mm.run()
2024-07-19 08:01:17.390734 | controller | File "/tmp/pip-build-env-b8quib_j/overlay/lib/python3.8/site-packages/setuptools/command/egg_info.py", line 555, in run
2024-07-19 08:01:17.390782 | controller | self.prune_file_list()
2024-07-19 08:01:17.390846 | controller | File "/tmp/pip-build-env-b8quib_j/overlay/lib/python3.8/site-packages/setuptools/command/egg_info.py", line 621, in prune_file_list
2024-07-19 08:01:17.390895 | controller | base_dir = self.distribution.get_fullname()
2024-07-19 08:01:17.390957 | controller | File "/tmp/pip-build-env-b8quib_j/overlay/lib/python3.8/site-packages/setuptools/_core_metadata.py", line 266, in get_fullname
2024-07-19 08:01:17.391007 | controller | return _distribution_fullname(self.get_name(), self.get_version())
2024-07-19 08:01:17.391069 | controller | File "/tmp/pip-build-env-b8quib_j/overlay/lib/python3.8/site-packages/setuptools/_core_metadata.py", line 284, in _distribution_fullname
2024-07-19 08:01:17.391118 | controller | canonicalize_version(version, strip_trailing_zero=False),
2024-07-19 08:01:17.391179 | controller | TypeError: canonicalize_version() got an unexpected keyword argument 'strip_trailing_zero'

Example failure:- https://storage.bhs.cloud.ovh.net/v1/AUTH_dcaab5e32b234d56b626f72581e3644c/zuul_opendev_logs_a11/924471/1/check/neutron-ovn-tempest-ovs-release-ubuntu-old/a11b101/job-output.txt

Setuptools issue:- https://github.com/pypa/setuptools/issues/4496

[Rodolfo Alonso (rodolfo-alonso-hernandez)]

Hello:

I think we should do the same: to pin setuptools to the last version no implementing [1], that is v70.1.1. The change done in setuptools [1] requires the change in packaging [2]. But we enforce the max version of packaging===21.3 in 2023.1.

Regards.

[1]https://github.com/pypa/setuptools/commit/555f7db16aad8eaf121c464eae76df871c825fd1
[2]https://github.com/pypa/packaging/commit/cc938f984bbbe43c5734b9656c9837ab3a28191f

[Rodolfo Alonso (rodolfo-alonso-hernandez)]

Patch (2023.1): https://review.opendev.org/c/openstack/requirements/+/924494