tamersalama
commented
2 years ago print_library_info() fails on the second cursor.fetchone() call (trying to fetch getTypeInfo for a SQL type.
import sys, os, platform, time
import pyodbc
def print_library_info(cnx):
print('python: %s' % sys.version)
print('pyodbc: %s %s' % (pyodbc.version, os.path.abspath(pyodbc.__file__)))
print('odbc: %s' % cnx.getinfo(pyodbc.SQL_ODBC_VER))
print('driver: %s %s' % (cnx.getinfo(pyodbc.SQL_DRIVER_NAME), cnx.getinfo(pyodbc.SQL_DRIVER_VER)))
print(' supports ODBC version %s' % cnx.getinfo(pyodbc.SQL_DRIVER_ODBC_VER))
print('os: %s' % platform.system())
print('unicode: Py_Unicode=%s SQLWCHAR=%s' % (pyodbc.UNICODE_SIZE, pyodbc.SQLWCHAR_SIZE))
cursor = cnx.cursor()
for typename in ['VARCHAR', 'WVARCHAR', 'BINARY']:
t = getattr(pyodbc, 'SQL_' + typename)
cursor.getTypeInfo(t)
row = cursor.fetchone()
print('Max %s = %s' % (typename, row and row[2] or '(not supported)'))
connection = {
'driver': '{composite85_x64}',
'server': '<server>',
'port': '9401',
'dataSource': 'fds',
'domain': 'hq',
'TREATCHARASUNICODE': 'true',
'uid': '<username>',
'pwd': '<password>',
'traceFile': f'/home/<user>/logs/trace_{time.time()}.log',
'traceLevel': 'all'
}
connection_str = ';'.join(['='.join(kv) for kv in connection.items()])
conn = pyodbc.connect(connection_str, autocommit=True)
conn.setencoding(encoding='utf-8')
conn.setdecoding(pyodbc.SQL_CHAR, encoding='utf-8')
conn.setdecoding(pyodbc.SQL_WCHAR, encoding='utf-8')
print_library_info(conn)Seg Faults after partial printing
python: 3.9.9 | packaged by conda-forge | (main, Dec 20 2021, 02:40:17)
[GCC 9.4.0]
pyodbc: 4.0.32 /home/<user>/miniforge3/envs/<env>/lib/python3.9/site-packages/pyodbc.cpython-39-x86_64-linux-gnu.so
odbc: 03.52
driver: TIBCO(R) Data Virtualization ODBC Driver 8.5.0.00
supports ODBC version 03.50
os: Linux
unicode: Py_Unicode=4 SQLWCHAR=2
Max VARCHAR = 256
Segmentation faultThe segmentation fault happens on the second call to cursor.fetchone()
v-chojas
gordthompson
Environment
Partial
print_library_info()output (more further below)not quite clear why unixODBC is not displaying the /etc/odbcinst.ini file - but the driver is defined there.
Issue
Expected Behavior:
call to
cursor.fetchall()or multiple calls tocursor.fetchone()to not cause segmentation fault and return appropriate data. I'm not clear on where the segmentation fault is returned, from a failedSQLFetchor from a subsequent attempt at reading the message returned by the driver.Observed Behavior:
Python segmentation fault caused when calling
cursor.fetchall()or multiple calls tocursor.fetchone(). The first call tocursor.fetchone()succeeds and returns expected records.Sample Code
The above causes segmentation fault on
cur.fetchall()lineLOGS
driver_trace.log unixODBC.log