Error when installing oracledb 1.3.2

[FlorentClarret]

Hello team!

Sorry if this is a stupid question or if this has already been reported. I'm facing some issues trying to install oracledb. I get the following error running pip install oracledb==1.3.2:

Error:
    error: subprocess-exited-with-error
  
  × Building wheel for oracledb (pyproject.toml) did not run successfully.
  │ exit code: 1
  ╰─> [763 lines of output]
      /tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/config/expand.py:132: SetuptoolsWarning: File '/tmp/pip-install-1t633h7g/oracledb_cb42007d9d434ca59c01e28d9666d535/README.md' cannot be found
        return '\n'.join(
      running bdist_wheel
      running build
      running build_py
      creating build
      creating build/lib.linux-x86_64-cpython-39
      creating build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/constructors.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/aq.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/version.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/pool.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/errors.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/soda.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/constants.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/__init__.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/cursor.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/pool_params.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/driver_mode.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/connection.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/lob.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/utils.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/dsn.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/subscr.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/dbobject.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/var.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/exceptions.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/connect_params.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/defaults.py -> build/lib.linux-x86_64-cpython-39/oracledb
      copying src/oracledb/py.typed -> build/lib.linux-x86_64-cpython-39/oracledb
      running build_ext
      Compiling src/oracledb/base_impl.pyx because it changed.
      [1/1] Cythonizing src/oracledb/base_impl.pyx
      building 'oracledb.base_impl' extension
      creating build/temp.linux-x86_64-cpython-39
      creating build/temp.linux-x86_64-cpython-39/src
      creating build/temp.linux-x86_64-cpython-39/src/oracledb
      /opt/rh/devtoolset-1.1/root/usr/bin/gcc -Wno-unused-result -Wsign-compare -DNDEBUG -g -fwrapv -O3 -Wall -I/opt/datadog-agent/embedded/include -O2 -g -pipe -I/opt/datadog-agent/embedded/include -O2 -g -pipe -I/opt/datadog-agent/embedded/include -I/opt/mqm/inc -std=c99 -fPIC -I/opt/datadog-agent/embedded/include/python3.9 -c src/oracledb/base_impl.c -o build/temp.linux-x86_64-cpython-39/src/oracledb/base_impl.o
      /opt/rh/devtoolset-1.1/root/usr/bin/gcc -shared -Wl,-rpath,/opt/datadog-agent/embedded/lib -L/opt/datadog-agent/embedded/lib -Wl,-rpath,/opt/datadog-agent/embedded/lib -L/opt/datadog-agent/embedded/lib -L/opt/datadog-agent/embedded/lib -L/opt/mqm/lib64 -L/opt/mqm/lib -I/opt/datadog-agent/embedded/include -I/opt/mqm/inc -std=c99 build/temp.linux-x86_64-cpython-39/src/oracledb/base_impl.o -L/opt/datadog-agent/embedded/lib -o build/lib.linux-x86_64-cpython-39/oracledb/base_impl.cpython-39-x86_64-linux-gnu.so
      warning: src/oracledb/impl/thin/constants.pxi:33:0: The 'DEF' statement is deprecated and will be removed in a future Cython version. Consider using global variables, constants, and in-place literals instead. See https://github.com/cython/cython/issues/4310
      Compiling src/oracledb/thin_impl.pyx because it changed.
      [1/1] Cythonizing src/oracledb/thin_impl.pyx
      building 'oracledb.thin_impl' extension
      /opt/rh/devtoolset-1.1/root/usr/bin/gcc -Wno-unused-result -Wsign-compare -DNDEBUG -g -fwrapv -O3 -Wall -I/opt/datadog-agent/embedded/include -O2 -g -pipe -I/opt/datadog-agent/embedded/include -O2 -g -pipe -I/opt/datadog-agent/embedded/include -I/opt/mqm/inc -std=c99 -fPIC -I/opt/datadog-agent/embedded/include/python3.9 -c src/oracledb/thin_impl.c -o build/temp.linux-x86_64-cpython-39/src/oracledb/thin_impl.o
      /opt/rh/devtoolset-1.1/root/usr/bin/gcc -shared -Wl,-rpath,/opt/datadog-agent/embedded/lib -L/opt/datadog-agent/embedded/lib -Wl,-rpath,/opt/datadog-agent/embedded/lib -L/opt/datadog-agent/embedded/lib -L/opt/datadog-agent/embedded/lib -L/opt/mqm/lib64 -L/opt/mqm/lib -I/opt/datadog-agent/embedded/include -I/opt/mqm/inc -std=c99 build/temp.linux-x86_64-cpython-39/src/oracledb/thin_impl.o -L/opt/datadog-agent/embedded/lib -o build/lib.linux-x86_64-cpython-39/oracledb/thin_impl.cpython-39-x86_64-linux-gnu.so
      
      Error compiling Cython file:
      ------------------------------------------------------------
      ...
                  session_callback_bytes = params.session_callback.encode()
                  create_params.plsqlFixupCallback = session_callback_bytes
                  create_params.plsqlFixupCallbackLength = \
                          <uint32_t> len(session_callback_bytes)
              if params.access_token_callback is not None:
                  create_params.accessTokenCallback = _token_callback_handler
                                                      ^
      ------------------------------------------------------------
      
      src/oracledb/impl/thick/pool.pyx:116:48: Cannot assign type 'int (void *, dpiAccessToken *) except? -1 nogil' to 'dpiAccessTokenCallback'
      
      Error compiling Cython file:
      ------------------------------------------------------------
      ...
              params.portNumber = self.port
              params.timeout = self.timeout
              params.name = name_buf.ptr
              params.nameLength = name_buf.length
              if self.callback is not None:
                  params.callback = _callback_handler
                                    ^
      ------------------------------------------------------------
      
      src/oracledb/impl/thick/subscr.pyx:159:30: Cannot assign type 'void (void *, dpiSubscrMessage *) except * nogil' to 'dpiSubscrCallback'
      Compiling src/oracledb/thick_impl.pyx because it changed.
      [1/1] Cythonizing src/oracledb/thick_impl.pyx
      Traceback (most recent call last):
        File "/opt/datadog-agent/embedded/lib/python3.9/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 353, in <module>
          main()
        File "/opt/datadog-agent/embedded/lib/python3.9/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 335, in main
          json_out['return_val'] = hook(**hook_input['kwargs'])
        File "/opt/datadog-agent/embedded/lib/python3.9/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 251, in build_wheel
          return _build_backend().build_wheel(wheel_directory, config_settings,
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/build_meta.py", line 416, in build_wheel
          return self._build_with_temp_dir(['bdist_wheel'], '.whl',
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/build_meta.py", line 401, in _build_with_temp_dir
          self.run_setup()
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/build_meta.py", line 338, in run_setup
          exec(code, locals())
        File "<string>", line 81, in <module>
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/__init__.py", line 107, in setup
          return distutils.core.setup(**attrs)
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/_distutils/core.py", line 185, in setup
          return run_commands(dist)
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/_distutils/core.py", line 201, in run_commands
          dist.run_commands()
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/_distutils/dist.py", line 969, in run_commands
          self.run_command(cmd)
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/dist.py", line 1234, in run_command
          super().run_command(command)
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/_distutils/dist.py", line 988, in run_command
          cmd_obj.run()
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/wheel/bdist_wheel.py", line 343, in run
          self.run_command("build")
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/_distutils/cmd.py", line 318, in run_command
          self.distribution.run_command(command)
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/dist.py", line 1234, in run_command
          super().run_command(command)
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/_distutils/dist.py", line 988, in run_command
          cmd_obj.run()
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/_distutils/command/build.py", line 131, in run
          self.run_command(cmd_name)
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/_distutils/cmd.py", line 318, in run_command
          self.distribution.run_command(command)
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/dist.py", line 1234, in run_command
          super().run_command(command)
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/_distutils/dist.py", line 988, in run_command
          cmd_obj.run()
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/command/build_ext.py", line 84, in run
          _build_ext.run(self)
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/_distutils/command/build_ext.py", line 345, in run
          self.build_extensions()
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/_distutils/command/build_ext.py", line 467, in build_extensions
          self._build_extensions_serial()
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/_distutils/command/build_ext.py", line 493, in _build_extensions_serial
          self.build_extension(ext)
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/setuptools/command/build_ext.py", line 246, in build_extension
          _build_ext.build_extension(self, ext)
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/Cython/Distutils/build_ext.py", line 122, in build_extension
          new_ext = cythonize(
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/Cython/Build/Dependencies.py", line 1134, in cythonize
          cythonize_one(*args)
        File "/tmp/pip-build-env-rwvpelhz/overlay/lib/python3.9/site-packages/Cython/Build/Dependencies.py", line 1301, in cythonize_one
          raise CompileError(None, pyx_file)
      Cython.Compiler.Errors.CompileError: src/oracledb/thick_impl.pyx
      [end of output]
  
  note: This error originates from a subprocess, and is likely not a problem with pip.

My build started to fail yesterday, right after the new Cython version 3.0.0 was released: https://pypi.org/project/Cython/

I can reproduce it building the wheel locally from the source. I managed to get it working modifying the pyproject.toml file to have cython<3.0.0 and it worked just fine.

Is there anything I'm doing wrong? If not, do you think it would be possible to release a new version of oracledb with this issue fixed?

Thanks a lot!

[nielspardon]

Seems this issue is related: #204

[FlorentClarret]

Yes it is! Waiting for the release now to close the discussion

[FlorentClarret]

#204 (comment)