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
307 stars 59 forks source link

Async select not returning all rows #331

Open Subdued5455 opened 2 months ago

Subdued5455 commented 2 months ago
  1. What versions are you using? Oracle DB 19.22.0.0.0 platform.platform: Linux-6.5.0-28-generic-x86_64-with-glibc2.35 sys.maxsize > 2**32: True platform.python_version: 3.11.0rc1 oracledb.version: 2.1.2

  1. Is it an error or a hang or a crash? An error.

  2. What error(s) or behavior you are seeing? When using async mode, fetches seem to end early. The issue seems to occur on every execution, though the exact number of rows returned is inconsistent. It works properly when using synchronous mode. I am relatively new to python, but believe the basic test code is correct - would be happy if this is just a problem of me doing something dumb. I am connecting to a database I have no control over.

Here is my script call and output: python simple_test.py Password: async starting... async connection acquired... async cursor created... async getting count(1)... async getting rows... async Elapsed Time: 35.00 seconds async COUNT(1): 9375506 async total_fetched_rows: 32802 async cursor.rowcount: 32802

  1. Does your application call init_oracle_client()? No.