oracledb2 hangs when getting connection from pool · Issue #275 · oracle/python-oracledb (original) (raw)

The same code worked just fine on oracledb<2, but after updating to oracledb==2.0.0, it just hangs during pool.acquire()

import oracledb dsn = oracledb.makedsn('XXX', 10121, service_name='XXX') print(dsn) pool = oracledb.create_pool(dsn=dsn, user='XXX', password='XXX', min=1, max=5, increment=1, ping_interval=2) print('created pool') with pool.acquire() as conn: print('connected!')

When I set the pool's getmode to nowait, it fails with "DPY-4005: timed out waiting for the connection pool to return a connection" instead of freezing.

A normal connection using oracledb.connect(dns=dns, user=..., password=...) works fine.

Version information:

platform.platform: Linux-5.15.88-gentoo-x86_64-AMD_Ryzen_5_3600X_6-Core_Processor-with-glibc2.37
sys.maxsize > 2**32: True
platform.python_version: 3.12.1
oracledb.__version__: 2.0.0