odoo.sh can't resolve pymssql

[creativenetwork-dev]

breaks possibly a lot of odoo.sh environments

Originally posted by @creativenetwork-dev in 986547b

[CRogos]

I agree

2025-11-28T20:43:55,797 Created temporary directory: /tmp/pip-unpack-1mizrxmt
2025-11-28T20:43:55,797 Building wheels for collected packages: pymssql
2025-11-28T20:43:55,798   Created temporary directory: /tmp/pip-wheel-w7ibvrc5
2025-11-28T20:43:55,798   Destination directory: /tmp/pip-wheel-w7ibvrc5
2025-11-28T20:43:55,798   Building wheel for pymssql (pyproject.toml): started
2025-11-28T20:43:55,798   Running command Building wheel for pymssql (pyproject.toml)
2025-11-28T20:43:56,213   <string>:32: SetuptoolsDeprecationWarning: The test command is disabled and references to it are deprecated.
2025-11-28T20:43:56,213   !!

2025-11-28T20:43:56,213           ********************************************************************************
2025-11-28T20:43:56,213           Please remove any references to `setuptools.command.test` in all supported versions of the affected package.

2025-11-28T20:43:56,213           This deprecation is overdue, please update your project and remove deprecated
2025-11-28T20:43:56,213           calls to avoid build errors in the future.
2025-11-28T20:43:56,213           ********************************************************************************

2025-11-28T20:43:56,213   !!
2025-11-28T20:43:56,300   /tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/_distutils/dist.py:289: UserWarning: Unknown distribution option: 'tests_require'
2025-11-28T20:43:56,300     warnings.warn(msg)
2025-11-28T20:43:56,309   /tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools_scm/_integration/version_inference.py:51: UserWarning: version of pymssql already set
2025-11-28T20:43:56,310     warnings.warn(self.message)
2025-11-28T20:43:56,311   /tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/dist.py:759: SetuptoolsDeprecationWarning: License classifiers are deprecated.
2025-11-28T20:43:56,311   !!

2025-11-28T20:43:56,311           ********************************************************************************
2025-11-28T20:43:56,311           Please consider removing the following classifiers in favor of a SPDX license expression:

2025-11-28T20:43:56,311           License :: OSI Approved :: GNU Library or Lesser General Public License (LGPL)

2025-11-28T20:43:56,311           See https://packaging.python.org/en/latest/guides/writing-pyproject-toml/#license for details.
2025-11-28T20:43:56,311           ********************************************************************************

2025-11-28T20:43:56,311   !!
2025-11-28T20:43:56,311     self._finalize_license_expression()
2025-11-28T20:43:56,340   setup.py: platform.system() => Linux
2025-11-28T20:43:56,340   setup.py: platform.architecture() => ('64bit', 'ELF')
2025-11-28T20:43:56,340   setup.py: platform.libc_ver() => ('glibc', '2.39')
2025-11-28T20:43:56,340   setup.py: include_dirs => []
2025-11-28T20:43:56,340   setup.py: library_dirs => []
2025-11-28T20:43:56,340   running bdist_wheel
2025-11-28T20:43:56,344   running build
2025-11-28T20:43:56,344   running build_py
2025-11-28T20:43:56,346   creating build/lib.linux-x86_64-cpython-312/pymssql
2025-11-28T20:43:56,346   copying src/pymssql/__init__.py -> build/lib.linux-x86_64-cpython-312/pymssql
2025-11-28T20:43:56,347   warning: build_py: byte-compiling is disabled, skipping.

2025-11-28T20:43:56,347   running build_ext
2025-11-28T20:43:57,001   warning: src/pymssql/_mssql.pyx:82:0: The 'IF' statement is deprecated and will be removed in a future Cython version. Consider using runtime conditions or C macros instead. See https://github.com/cython/cython/issues/4310
2025-11-28T20:43:57,003   warning: src/pymssql/_mssql.pyx:264:4: The 'IF' statement is deprecated and will be removed in a future Cython version. Consider using runtime conditions or C macros instead. See https://github.com/cython/cython/issues/4310
2025-11-28T20:43:57,004   warning: src/pymssql/_mssql.pyx:333:4: The 'IF' statement is deprecated and will be removed in a future Cython version. Consider using runtime conditions or C macros instead. See https://github.com/cython/cython/issues/4310
2025-11-28T20:43:57,010   warning: src/pymssql/_mssql.pyx:830:8: The 'IF' statement is deprecated and will be removed in a future Cython version. Consider using runtime conditions or C macros instead. See https://github.com/cython/cython/issues/4310
2025-11-28T20:43:57,012   warning: src/pymssql/_mssql.pyx:918:8: The 'IF' statement is deprecated and will be removed in a future Cython version. Consider using runtime conditions or C macros instead. See https://github.com/cython/cython/issues/4310
2025-11-28T20:43:57,013   warning: src/pymssql/_mssql.pyx:1004:12: The 'IF' statement is deprecated and will be removed in a future Cython version. Consider using runtime conditions or C macros instead. See https://github.com/cython/cython/issues/4310
2025-11-28T20:43:57,018   warning: src/pymssql/_mssql.pyx:1378:16: The 'IF' statement is deprecated and will be removed in a future Cython version. Consider using runtime conditions or C macros instead. See https://github.com/cython/cython/issues/4310
2025-11-28T20:43:57,022   warning: src/pymssql/_mssql.pyx:1712:8: The 'IF' statement is deprecated and will be removed in a future Cython version. Consider using runtime conditions or C macros instead. See https://github.com/cython/cython/issues/4310

2025-11-28T20:43:57,192   Error compiling Cython file:
2025-11-28T20:43:57,192   ------------------------------------------------------------
2025-11-28T20:43:57,192   ...

2025-11-28T20:43:57,192           elif dbtype == SQLINT4:
2025-11-28T20:43:57,192               return int(<int>(<DBINT *>data)[0])

2025-11-28T20:43:57,192           elif dbtype == SQLINT8:
2025-11-28T20:43:57,192               return long(<PY_LONG_LONG>(<PY_LONG_LONG *>data)[0])
2025-11-28T20:43:57,192                      ^
2025-11-28T20:43:57,192   ------------------------------------------------------------
2025-11-28T20:43:57,192   src/pymssql/_mssql.pyx:846:19: undeclared name not builtin: long

2025-11-28T20:43:57,226   Error compiling Cython file:
2025-11-28T20:43:57,226   ------------------------------------------------------------
2025-11-28T20:43:57,226   ...

2025-11-28T20:43:57,226   cdef void init_mssql():
2025-11-28T20:43:57,226       if dbinit() == FAIL:
2025-11-28T20:43:57,226           raise MSSQLDriverException("dbinit() failed")

2025-11-28T20:43:57,226       dberrhandle(err_handler)
2025-11-28T20:43:57,226                   ^
2025-11-28T20:43:57,226   ------------------------------------------------------------
2025-11-28T20:43:57,226 src/pymssql/_mssql.pyx:2172:16: Cannot assign type 'int (DBPROCESS *, int, int, int, char *, char *) except? -1 nogil' to 'EHANDLEFUNC' (alias of 'int (*)(DBPROCESS *, int, int, int, char *, char *) noexcept'). Exception values are incompatible. Suggest adding 'noexcept' to the type of 'err_handler'.

2025-11-28T20:43:57,226   Error compiling Cython file:
2025-11-28T20:43:57,226   ------------------------------------------------------------
2025-11-28T20:43:57,226   ...
2025-11-28T20:43:57,226   cdef void init_mssql():
2025-11-28T20:43:57,226       if dbinit() == FAIL:
2025-11-28T20:43:57,226           raise MSSQLDriverException("dbinit() failed")

2025-11-28T20:43:57,227       dberrhandle(err_handler)
2025-11-28T20:43:57,227       dbmsghandle(msg_handler)
2025-11-28T20:43:57,227                   ^
2025-11-28T20:43:57,227   ------------------------------------------------------------
2025-11-28T20:43:57,227   src/pymssql/_mssql.pyx:2173:16: Cannot assign type 'int (DBPROCESS *, DBINT, int, int, char *, char *, char *, LINE_T) except? -1 nogil' to 'MHANDLEFUNC' (alias of 'int (*)(DBPROCESS *, DBINT, int, int, char *, char *, char *, int) noexcept'). Exception values are incompatible. Suggest adding 'noexcept' to the type of 'msg_handler'.
2025-11-28T20:43:57,274   Compiling src/pymssql/_mssql.pyx because it changed.
2025-11-28T20:43:57,274   [1/1] Cythonizing src/pymssql/_mssql.pyx
2025-11-28T20:43:57,274   Traceback (most recent call last):
2025-11-28T20:43:57,274     File "/usr/lib/python3/dist-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 353, in <module>
2025-11-28T20:43:57,274       main()
2025-11-28T20:43:57,274     File "/usr/lib/python3/dist-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 335, in main
2025-11-28T20:43:57,274       json_out['return_val'] = hook(**hook_input['kwargs'])
2025-11-28T20:43:57,274                                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-11-28T20:43:57,274     File "/usr/lib/python3/dist-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 251, in build_wheel
2025-11-28T20:43:57,274       return _build_backend().build_wheel(wheel_directory, config_settings,
2025-11-28T20:43:57,274              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-11-28T20:43:57,274     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/build_meta.py", line 435, in build_wheel
2025-11-28T20:43:57,274       return _build(['bdist_wheel', '--dist-info-dir', str(metadata_directory)])
2025-11-28T20:43:57,274              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-11-28T20:43:57,274     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/build_meta.py", line 423, in _build
2025-11-28T20:43:57,274       return self._build_with_temp_dir(
2025-11-28T20:43:57,274              ^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-11-28T20:43:57,274     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/build_meta.py", line 404, in _build_with_temp_dir
2025-11-28T20:43:57,274       self.run_setup()
2025-11-28T20:43:57,274     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/build_meta.py", line 512, in run_setup
2025-11-28T20:43:57,274       super().run_setup(setup_script=setup_script)
2025-11-28T20:43:57,274     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/build_meta.py", line 317, in run_setup
2025-11-28T20:43:57,274       exec(code, locals())
2025-11-28T20:43:57,274     File "<string>", line 287, in <module>
2025-11-28T20:43:57,274     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/__init__.py", line 115, in setup
2025-11-28T20:43:57,274       return distutils.core.setup(**attrs)
2025-11-28T20:43:57,274              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-11-28T20:43:57,274     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/_distutils/core.py", line 186, in setup
2025-11-28T20:43:57,274       return run_commands(dist)
2025-11-28T20:43:57,274              ^^^^^^^^^^^^^^^^^^
2025-11-28T20:43:57,274     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/_distutils/core.py", line 202, in run_commands
2025-11-28T20:43:57,274       dist.run_commands()
2025-11-28T20:43:57,274     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/_distutils/dist.py", line 1002, in run_commands
2025-11-28T20:43:57,275       self.run_command(cmd)
2025-11-28T20:43:57,275     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/dist.py", line 1102, in run_command
2025-11-28T20:43:57,275       super().run_command(command)
2025-11-28T20:43:57,275     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/_distutils/dist.py", line 1021, in run_command
2025-11-28T20:43:57,275       cmd_obj.run()
2025-11-28T20:43:57,275     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/command/bdist_wheel.py", line 370, in run
2025-11-28T20:43:57,275       self.run_command("build")
2025-11-28T20:43:57,275     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/_distutils/cmd.py", line 357, in run_command
2025-11-28T20:43:57,275       self.distribution.run_command(command)
2025-11-28T20:43:57,275     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/dist.py", line 1102, in run_command
2025-11-28T20:43:57,275       super().run_command(command)
2025-11-28T20:43:57,275     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/_distutils/dist.py", line 1021, in run_command
2025-11-28T20:43:57,275       cmd_obj.run()
2025-11-28T20:43:57,275     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/_distutils/command/build.py", line 135, in run
2025-11-28T20:43:57,275       self.run_command(cmd_name)
2025-11-28T20:43:57,275     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/_distutils/cmd.py", line 357, in run_command
2025-11-28T20:43:57,275       self.distribution.run_command(command)
2025-11-28T20:43:57,275     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/dist.py", line 1102, in run_command
2025-11-28T20:43:57,275       super().run_command(command)
2025-11-28T20:43:57,275     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/_distutils/dist.py", line 1021, in run_command
2025-11-28T20:43:57,276       cmd_obj.run()
2025-11-28T20:43:57,276     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/_distutils/command/build_ext.py", line 368, in run
2025-11-28T20:43:57,276       self.build_extensions()
2025-11-28T20:43:57,276     File "<string>", line 179, in build_extensions
2025-11-28T20:43:57,276     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/_distutils/command/build_ext.py", line 484, in build_extensions
2025-11-28T20:43:57,276       self._build_extensions_serial()
2025-11-28T20:43:57,276     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/setuptools/_distutils/command/build_ext.py", line 510, in _build_extensions_serial
2025-11-28T20:43:57,276       self.build_extension(ext)
2025-11-28T20:43:57,276     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/Cython/Distutils/build_ext.py", line 131, in build_extension
2025-11-28T20:43:57,276       new_ext = cythonize(
2025-11-28T20:43:57,276                 ^^^^^^^^^^
2025-11-28T20:43:57,276     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/Cython/Build/Dependencies.py", line 1153, in cythonize
2025-11-28T20:43:57,276       cythonize_one(*args)
2025-11-28T20:43:57,276     File "/tmp/pip-build-env-2oikye7p/overlay/local/lib/python3.12/dist-packages/Cython/Build/Dependencies.py", line 1297, in cythonize_one
2025-11-28T20:43:57,276       raise CompileError(None, pyx_file)
2025-11-28T20:43:57,276   Cython.Compiler.Errors.CompileError: src/pymssql/_mssql.pyx
2025-11-28T20:43:57,426   ERROR: Building wheel for pymssql (pyproject.toml) exited with 1
2025-11-28T20:43:57,429   [bold magenta]full command[/]: [blue]/usr/bin/python3 /usr/lib/python3/dist-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py build_wheel /tmp/tmp4kg55dpt[/]
2025-11-28T20:43:57,429   [bold magenta]cwd[/]: /tmp/pip-install-059ct5b2/pymssql_070442447a9048b08c4c9b20c3717926
2025-11-28T20:43:57,429   Building wheel for pymssql (pyproject.toml): finished with status 'error'
2025-11-28T20:43:57,430   ERROR: Failed building wheel for pymssql
2025-11-28T20:43:57,430 Failed to build pymssql
2025-11-28T20:43:57,430 ERROR: Could not build wheels for pymssql, which is required to install pyproject.toml-based projects
2025-11-28T20:43:57,430 Exception information:
2025-11-28T20:43:57,430 Traceback (most recent call last):
2025-11-28T20:43:57,430   File "/usr/lib/python3/dist-packages/pip/_internal/cli/base_command.py", line 180, in exc_logging_wrapper
2025-11-28T20:43:57,430     status = run_func(*args)
2025-11-28T20:43:57,430              ^^^^^^^^^^^^^^^
2025-11-28T20:43:57,430   File "/usr/lib/python3/dist-packages/pip/_internal/cli/req_command.py", line 245, in wrapper
2025-11-28T20:43:57,430     return func(self, options, args)
2025-11-28T20:43:57,430            ^^^^^^^^^^^^^^^^^^^^^^^^^
2025-11-28T20:43:57,430   File "/usr/lib/python3/dist-packages/pip/_internal/commands/install.py", line 429, in run
2025-11-28T20:43:57,430     raise InstallationError(
2025-11-28T20:43:57,430 pip._internal.exceptions.InstallationError: Could not build wheels for pymssql, which is required to install pyproject.toml-based projects
2025-11-28T20:43:57,432 Removed build tracker: '/tmp/pip-build-tracker-2fx6z31n'

[miikanissi]

Same issue and does not only affect odoo.sh. Any environment running Python 3.11 to 3.13, which are officially supported for version 18 by Odoo.
Why does it require pymssql<=2.2.5 when that release is over 3 years old and doesn't even support Python 3.11 ? The library version should be bumped up to at least 2.3.2 which supports Python 3.13.

[emedinamts]

I can confirm that it can't be installed in odoo.sh environments due to this.

[CRogos]

@christian-ramos-tecnativa are you working on this? The PR which causes this issue was created by you.

[christian-ramos-tecnativa]

@CRogos not really, we don't have any client in odoo.sh to test which version should be used

[CRogos]

@christian-ramos-tecnativa if the module is working with newer versions, why not removing the version constraint?

I am not using the module and have no possibility to test the module with a newer version of this library.

[PieterPaulussen]

Seen the same issue on odoo.sh. I've proposed a fix here: #401