Thin mode - Segmentation Fault when using oracledb.CURSOR #368
Description
- What versions are you using?
Oracle 19
Also run Python and show the output of:
>>> import sys
>>> import platform
>>>
>>> print("platform.platform:", platform.platform())
platform.platform: Linux-4.18.0-372.76.1.el8_6.x86_64-x86_64-with-glibc2.28
>>> 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.4
And:
>>> import oracledb
>>> print("oracledb.__version__:", oracledb.__version__)
oracledb.__version__: 2.2.1
-->
- Is it an error or a hang or a crash?
Crash
- What error(s) or behavior you are seeing?
Segmentation Fault
Cut and paste text showing the command you ran. No screenshots.
Use a gist for long screen output and logs: see https://gist.github.com/
-->
- Does your application call init_oracle_client()?
This bug only occurs in thin mode.
I cannot replicate it in thick mode.
- Include a runnable Python script that shows the problem.
import oracledb
conn = oracledb.connect(...)
cur = conn.cursor()
cursor_var = cur.var(oracledb.CURSOR)
cur.execute(
'''
DECLARE
l_cursor SYS_REFCURSOR;
BEGIN
OPEN l_cursor FOR
SELECT 1 foo
FROM dual
;
:cursor := l_cursor;
END;
''',
dict(
cursor=cursor_var
)
)
cursor = cursor_var.getvalue()
rows = cursor.fetchall()
assert rows == [(1,)]
cursor.close()
# Recalling cur.execute with the same cursor_var will result in the segmentation fault.
cur.execute(
'''
DECLARE
l_cursor SYS_REFCURSOR;
BEGIN
OPEN l_cursor FOR
SELECT 1 foo
FROM dual
;
:cursor := l_cursor;
END;
''',
dict(
cursor=cursor_var
)
)
Segmentation fault (core dumped)
No segfault offcurs when I instead instantiate a new cursor_var:
cursor.close()
cursor_var = cur.var(oracledb.CURSOR)
cur.execute(..., dict(cursor=cursor_var))
In thick mode, it works as expected.