search

oracle / python-oracledb

Python driver for Oracle Database conforming to the Python DB API 2.0 specification. This is the renamed, new major release of cx_Oracle
https://oracle.github.io/python-oracledb
Other
342 stars 69 forks source link

Connections remain in busy connection list and can't be reused in pool #392

Closed golubovai closed 2 weeks ago

golubovai commented 2 months ago
  1. What versions are you using? Oracle Database 19c 
    >>> import sys
>>> import platform
>>>
>>> print("platform.platform:", platform.platform())
platform.platform: Windows-10-10.0.19045-SP0
>>> print("sys.maxsize > 2**32:", sys.maxsize > 2**32)
sys.maxsize > 2**32: True
>>> print("platform.python_version:", platform.python_version())
platform.python_version: 3.12.3
>>>
    >>> import oracledb
>>> print("oracledb.__version__:", oracledb.__version__)
oracledb.__version__: 2.4.1
    1. Does your application call init_oracle_client()? Thin mode.
anthony-tuininga commented 2 months ago

With some tweaks to the timing I was able to replicate the issue intermittently. I am looking at the best way to address the issue. Thanks for the report and the suggested fix!

anthony-tuininga commented 1 month ago

I have pushed a patch that corrects this issue and have initated a build from which you can download pre-built development wheels once it completes. You can also build from source if you prefer. If you are able to confirm that the patch corrects the issue for you that would be appreciated!

anthony-tuininga commented 2 weeks ago

This was included in python-oracledb 2.5.0 which was just released.