django use oracledb and enable thick mode，but sometimes Aborted, Please help me,thanks~

[HeroZ09]

Issue: django use oracledb and enable thick mode，but sometimes Aborted,Please help me,thanks~

1、django 5.0.X, python 3.11.X ,daphne asgi run service
DATABASES in setting.py:
DATABASES = {
"default": {
"ENGINE": "django.db.backends.oracle",
"NAME": XX,
"USER": XX,
"PASSWORD": XX,
"HOST": XX,
"PORT": XX,
}
}

oracledb.init_oracle_client()

2、OS : debian linux
3、oracle: instantclient_21_13
4、python-oracledb : 2.1.1
5、log：
double free or corruption (out)
Fatal Python error: Aborted

Current thread 0x00007f6470cfd6c0 (most recent call first):
  File "/opt/conda/envs/cn_venv/lib/python3.11/site-packages/oracledb/connection.py", line 544 in __init__
  File "/opt/conda/envs/cn_venv/lib/python3.11/site-packages/oracledb/connection.py", line 1158 in connect
  File "/opt/conda/envs/cn_venv/lib/python3.11/site-packages/django/db/backends/oracle/base.py", line 252 in get_new_connection
  File "/opt/conda/envs/cn_venv/lib/python3.11/site-packages/django/utils/asyncio.py", line 26 in inner
  File "/opt/conda/envs/cn_venv/lib/python3.11/site-packages/django/db/backends/base/base.py", line 256 in connect
  File "/opt/conda/envs/cn_venv/lib/python3.11/site-packages/django/utils/asyncio.py", line 26 in inner
  File "/opt/conda/envs/cn_venv/lib/python3.11/site-packages/django/db/backends/base/base.py", line 275 in ensure_connection
  File "/opt/conda/envs/cn_venv/lib/python3.11/site-packages/django/utils/asyncio.py", line 26 in inner
  File "/opt/conda/envs/cn_venv/lib/python3.11/site-packages/django/db/backends/base/base.py", line 292 in _cursor
  File "/opt/conda/envs/cn_venv/lib/python3.11/site-packages/django/db/backends/base/base.py", line 316 in cursor
  File "/opt/conda/envs/cn_venv/lib/python3.11/site-packages/django/utils/asyncio.py", line 26 in inner

[anthony-tuininga]

Looking at the last item in the traceback you provided (which looks like it is truncated) it would seem you are trying to use asyncio with thick mode? That isn't going to work for you! If you are able to supply a small test case in Django that demonstrates the issue, though, I'll take a look. You shouldn't get a double free or corruption error!

[HeroZ09]

You're welcome. Have you tried thin mode already? That might work better for you?

@anthony-tuininga Our oracle db server not support with thin mode，because the oracledb check the password version need 10G above~ BTW, how to setting the V$SESSION.program with oracledb

[HeroZ09]

@HeroZ09 just remove the call to oracledb.init_oracle_client() and try again. This will use Thin mode python-oracledb.

What are you trying to test? I read that Django's asynchio support is effectively experimental. From https://docs.djangoproject.com/en/5.0/topics/async/:

We’re still working on async support for the ORM and other parts of Django

@cjbj thanks for your information，Our oracle db server not support with thin mode，because the oracledb check the password version need 10G above~ I now try with other DB(not oracle), any result will share to you
BTW, how to setting the V$SESSION.program with oracledb in django?

[cjbj]

If your DB is 12c or later, review https://python-oracledb.readthedocs.io/en/latest/user_guide/troubleshooting.html#dpy-3015 about resetting the password verifier. That would let you use Thin mode.

There is no API to change the 'program' value - our team doesn't think this should be changed. The suggested alternative is to use one of the many other attributes such as module, action etc. Thick mode additionally can set the DRIVER_NAME, see https://python-oracledb.readthedocs.io/en/latest/api_manual/module.html#oracledb.init_oracle_client. Adding support to change this in Thin mode is on our task list.

Let us know how you go.

[HeroZ09]

If your DB is 12c or later, review https://python-oracledb.readthedocs.io/en/latest/user_guide/troubleshooting.html#dpy-3015 about resetting the password verifier. That would let you use Thin mode.

There is no API to change the 'program' value - our team doesn't think this should be changed. The suggested alternative is to use one of the many other attributes such as module, action etc. Thick mode additionally can set the DRIVER_NAME, see https://python-oracledb.readthedocs.io/en/latest/api_manual/module.html#oracledb.init_oracle_client. Adding support to change this in Thin mode is on our task list.

Let us know how you go.

Hi cjbj @cjbj ，
thanks for your reply~
First ：Return to our original topic， I try with sql server with no other code modfiy,and the crash issue no longer occurs.
Second：
1、Ensure that the database initialization parameter sec_case_sensitive_logon is not FALSE
-> I already read the dpy-3015 before,it need init db,and I can't push our dba to do anything~ so I can only use thick mode~
2、Can provide any sample code about modify "module" or "clientinfo"？thanks very much~~
3、Adding support to change this in Thin mode is on our task list. -> That's great~
and I'll have a try with DRIVER_NAME

[cjbj]

Regarding setting V$SESSION.program, the Thin mode of the future python-oracledb 2.5 will support this.