Segmentation fault when using pyodbc.connect #1190

alascorz · 2023-03-24T00:31:45Z

alascorz
Mar 24, 2023

Environment

Python: Python 3.7.14
pyodbc: Tested versions from 4.0.25 to 4.0.35
OS: Debian GNU/Linux 10 (buster)
DB: sql.azuresynapse.net
driver: Tested ODBC Driver 17 and 18 for SQL Server

Issue

I am trying to connect to an Azure Synapse database, using the following code snippet:

    conn_str = (
        f'DRIVER={{ODBC Driver 18 for SQL Server}};'
        f'SERVER={self.database_host};'
        f'DATABASE={self.database_name};'
        f'UID={self.database_user};'
        f'PWD={self.database_password};'
        f'Encrypt=yes;'
        f'TrustServerCertificate=no;'
    )

    conn = pyodbc.connect(conn_str)
    return conn.cursor()

The expected output would be a successful connection to the database and for the code to continue executing.
However, the output obtained is a Segmentation Fault:

    Fatal Python error: Segmentation fault

For extra information, I've run some commands I've seen referenced in other threads:

   $ odbcinst -j
   unixODBC 2.3.11
   DRIVERS............: /etc/odbcinst.ini
   SYSTEM DATA SOURCES: /etc/odbc.ini
   FILE DATA SOURCES..: /etc/ODBCDataSources
   USER DATA SOURCES..: /root/.odbc.ini
   SQLULEN Size.......: 8
   SQLLEN Size........: 8
   SQLSETPOSIROW Size.: 8

   $ ldd which odbcinst
   linux-vdso.so.1 (0x00007fff5f2d4000)
   libodbcinst.so.2 => /usr/lib/x86_64-linux-gnu/libodbcinst.so.2 (0x00007fa496620000)
   libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007fa4965ff000)
   libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fa49643f000)
   libltdl.so.7 => /usr/lib/x86_64-linux-gnu/libltdl.so.7 (0x00007fa496434000)
   /lib64/ld-linux-x86-64.so.2 (0x00007fa49683d000)
   libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007fa49642f000)


   $ ldd pyodbc.cpython-37m-x86_64-linux-gnu.so
   linux-vdso.so.1 (0x00007fff2e598000)
   libodbc.so.2 => /usr/lib/x86_64-linux-gnu/libodbc.so.2 (0x00007f5fbd841000)
   libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f5fbd6bd000)
   libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f5fbd53a000)
   libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f5fbd520000)
   libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f5fbd4ff000)
   libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f5fbd33f000)
   libltdl.so.7 => /usr/lib/x86_64-linux-gnu/libltdl.so.7 (0x00007f5fbd332000)
   /lib64/ld-linux-x86-64.so.2 (0x00007f5fbdae4000)
   libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f5fbd32d000)

Any help will be greatly appreciated

Answered by kklein

Jun 23, 2023

I found what makes the difference: Downgrading libgcc-ng from 13.0.1 to 12.0.1 makes the segfault disappear! Pinning it looks like a feasible solution for me (for now). Thanks a lot for your help and patience.

View full answer

v-chojas · 2023-03-24T14:43:11Z

v-chojas
Mar 24, 2023

Determine where the segfault is happening using gdb.

Please don't double-post, I already replied you in the other thread.

0 replies

gordthompson · 2023-03-24T17:18:19Z

gordthompson
Mar 24, 2023
Collaborator

FWIW, I am unable to reproduce your issue. As mentioned in other threads, output from strace might also help identify the problem.

0 replies

kklein · 2023-06-09T08:50:44Z

kklein
Jun 9, 2023

I have the same problem.

Environment
Python: 3.10.11
pyodbc: Tested 4.0.34 and 4.0.39; identical behaviour
OS: Ubuntu 20.04.5 LTS
DB: Impala
driver: Cloudera ODBC driver for Impala, 2.6.16.1022-2

0 replies

gordthompson · 2023-06-13T01:02:47Z

gordthompson
Jun 13, 2023
Collaborator

@kklein - Does the segfault occur immediately upon executing pyodbc.connect(…) ?

9 replies

gordthompson Jun 21, 2023
Collaborator

Line #4 seems to indicate errors like

<error: Cannot access memory at address 0x804861714eb5538>

happening in

Simba::Support::DMCharacteristics::DetectDriverManager()

which is in

/opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so

Can you connect from outside Python using the isql or iusql command-line utilities?

kklein Jun 21, 2023

Apologies - the backtrace was the wrong one, I edited it.

Yes, I can connect to Impala via isql with exactly the same dsn string I use for pyodbc.connect.

v-chojas Jun 21, 2023

/opt/conda/envs/hf2/lib/python3.10/site-packages/../../libodbc.so.2

That's not the system DM. odbcinst -j will only show the version of DM that it happens to link to, which is not necessarily what your application is using. Remove/rename that file and see if your application then starts working.

Are you using pyODBC 4.0.34? That version came with its own very old unixODBC and has caused multiple issues in the past.

gordthompson Jun 21, 2023
Collaborator

I have very little experience with gdb so I may be missing something obvious, but I still don't see any evidence of a segfault. When I force one using FreeTDS ODBC, it looks like this:

$ cat zzz.py 
import pyodbc

cnxn = pyodbc.connect(
    "Driver=FreeTDS;"
    "Server=192.168.0.199;Port=1433;"
    "UID=scott;PWD=tiger^5HHH;"
    "Database=test;",
    autocommit=True
)
crsr = cnxn.cursor()
crsr.execute("CREATE TABLE #tmp (id int)")
crsr.fast_executemany = True
crsr.executemany(
    "INSERT INTO #tmp (id) VALUES (?)",
    [(1,), (2,)]
)
$ gdb python3
GNU gdb (Ubuntu 9.2-0ubuntu1~20.04.1) 9.2
Copyright (C) 2020 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
Type "show copying" and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
    <http://www.gnu.org/software/gdb/documentation/>.

For help, type "help".
Type "apropos word" to search for commands related to "word"...
Reading symbols from python3...
(No debugging symbols found in python3)
(gdb) run zzz.py
Starting program: /usr/bin/python3 zzz.py
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".

Program received signal SIGSEGV, Segmentation fault.
0x00007ffff6d5ec43 in ?? () from /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
(gdb)

kklein Jun 21, 2023

@gordthompson Unfortunately I'm not a gdb expert either. Previously I clipped the backtrace. Here is more information:

$ cat segfault.py 
import pyodbc 

node = "cbd00417"
dsn_hostname = node + ".lan.OBFUSCATED.com"
dsn_driver = "Cloudera ODBC Driver for Impala"
dsn_port = "21050"
dsn_krbRealm = "LAN.OBFUSCATED.COM"
dsn_krbFQDN = "_HOST"
dsn_krbServiceName = "impala"

dsn = (
    f"Host={dsn_hostname};"
    f"DRIVER={dsn_driver};"
    f"PORT={dsn_port};"
    f"KrbRealm={dsn_krbRealm};"
    f"KrbFQDN={dsn_krbFQDN};"
    f"KrbServiceName={dsn_krbServiceName};"
    "AUTHMECH=1;"
    "SSL=1;"
    "AllowSelfSignedServerCert=1"
)

$ python segfault.py
Segmentation fault (core dumped)

$ gdb python
GNU gdb (GDB) 12.1
Copyright (C) 2022 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <[http://gnu.org/licenses/gpl.html>](http://gnu.org/licenses/gpl.html%3E)
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
Type "show copying" and "show warranty" for details.
This GDB was configured as "x86_64-conda-linux-gnu".
...
(gdb) run segfault.py
Starting program: /opt/conda/envs/hf2/bin/python segfault.py
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".

Program received signal SIGSEGV, Segmentation fault.
linear_search_fdes (ob=ob@entry=0x7ffffffe75a0, this_fde=0x0, pc=pc@entry=0x7ffff41dd6b1 <Simba::Support::DMCharacteristics::DetectDriverManager()+325>) at ../../../libgcc/unwind-dw2-fde.c:969
969     ../../../libgcc/unwind-dw2-fde.c: No such file or directory.

(gdb) thread apply all bt full

 

Thread 1 (Thread 0x7ffff7c42740 (LWP 868673) "python"):
#0  linear_search_fdes (ob=ob@entry=0x7ffffffe75a0, this_fde=0x0, pc=pc@entry=0x7ffff41dd6b1 <Simba::Support::DMCharacteristics::DetectDriverManager()+325>) at ../../../libgcc/unwind-dw2-fde.c:969
        last_cie = <optimized out>
        encoding = 0
        base = 0
#1  0x00007ffff766908a in find_fde_tail (dbase=4, bases=0x7ffffffe7718, hdr=0x7ffff660dc90, pc=140737288984241) at ../../../libgcc/unwind-dw2-fde-dip.c:519
        p = <optimized out>
        eh_frame = 0
        ob = {pc_begin = 0x0, tbase = 0x0, dbase = 0x4, u = {single = 0x0, array = 0x0, sort = 0x0}, s = {b = {sorted = 0, from_array = 0, mixed_encoding = 1, encoding = 0, count = 0}, i = 4}, next = 0x0}
        entry = <optimized out>
#2  _Unwind_Find_FDE (pc=<optimized out>, bases=bases@entry=0x7ffffffe7718) at ../../../libgcc/unwind-dw2-fde-dip.c:573
        data = {pc = 140737288984241, hdr = 0x7ffff660dc90, check_cache = 1}
        ret = <optimized out>
        dbase = 0
#3  0x00007ffff7665bcd in uw_frame_state_for (context=context@entry=0x7ffffffe7670, fs=fs@entry=0x7ffffffe7760) at ../../../libgcc/unwind-dw2.c:1005
        fde = <optimized out>
        cie = <optimized out>
        aug = <optimized out>
        insn = <optimized out>
        end = <optimized out>
#4  0x00007ffff7666f65 in _Unwind_Backtrace (trace=0x7ffff7d71f20, trace_argument=0x7ffffffe78a0) at ../../../libgcc/unwind.inc:303
        fs = {regs = {reg = {{loc = {reg = 93824997991552, offset = 93824997991552, exp = 0x555555ad2480 "\030\347\347\366\377\177"}}, {loc = {reg = 93824997703064, offset = 93824997703064, exp = 0x555555a8bd98 ""}}, {loc = {reg = 12852552221001614737, offset = -5594191852707936879, exp = 0xb25d702635f58591 <error: Cannot access memory at address 0xb25d702635f58591>}}, {loc = {reg = 6714437289852539392, offset = 6714437289852539392, exp = 0x5d2e7923f84c1200 <error: Cannot access memory at address 0x5d2e7923f84c1200>}}, {loc = {reg = 140737488254960, offset = 140737488254960, exp = 0x7ffffffe77f0 ""}}, {loc = {reg = 140737351670259, offset = 140737351670259, exp = 0x7ffff7da59f3 <_dl_catch_error+51> "H\213\024$I\211\024$H\213T$\bH9T$\020H\211U"}}, {loc = {reg = 18446744073709551600, offset = -16, exp = 0xfffffffffffffff0 <error: Cannot access memory at address 0xfffffffffffffff0>}}, {loc = {reg = 0, offset = 0, exp = 0x0}}, {loc = {reg = 0, offset = 0, exp = 0x0}}, {loc = {reg = 6714437289852539392, offset = 6714437289852539392, exp = 0x5d2e7923f84c1200 <error: Cannot access memory at address 0x5d2e7923f84c1200>}}, {loc = {reg = 140737351458720, offset = 140737351458720, exp = 0x7ffff7d71fa0 "\363\017\036\372U\276\002"}}, {loc = {reg = 140737488255040, offset = 140737488255040, exp = 0x7ffffffe7840 ""}}, {loc = {reg = 140737488255056, offset = 140737488255056, exp = 0x7ffffffe7850 ""}}, {loc = {reg = 140737351666378, offset = 140737351666378, exp = 0x7ffff7da4aca <__libc_dlsym+106> "\205\300uJH\203|$("}}, {loc = {reg = 140737488255056, offset = 140737488255056, exp = 0x7ffffffe7850 ""}}, {loc = {reg = 140737352024025, offset = 140737352024025, exp = 0x7ffff7dfbfd9 "_Unwind_GetCFA"}}, {loc = {reg = 18446744073709551608, offset = -8, exp = 0xfffffffffffffff8 <error: Cannot access memory at address 0xfffffffffffffff8>}}, {loc = {reg = 85138638363169280, offset = 85138638363169280, exp = 0x12e7923f84c1200 <error: Cannot access memory at address 0x12e7923f84c1200>}}}, how = '\000' <repeats 17 times>, cfa_how = CFA_UNSET, prev = 0x0, cfa_offset = 0, cfa_reg = 0, cfa_exp = 0x0}, pc = 0x0, personality = 0x0, data_align = 0, code_align = 0, retaddr_column = 0, fde_encoding = 0 '\000', lsda_encoding = 0 '\000', saw_z = 0 '\000', signal_frame = 0 '\000', eh_ptr = 0x0}
        context = {reg = {0x0, 0x0, 0x0, 0x7ffffffe7868, 0x0, 0x0, 0x7ffffffe78c0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x7ffffffe7870, 0x7ffffffe7878, 0x7ffffffe7880, 0x7ffffffe7888, 0x7ffffffe78c8, 0x0}, cfa = 0x7ffffffe78d0, ra = 0x7ffff41dd6b2 <Simba::Support::DMCharacteristics::DetectDriverManager()+326>, lsda = 0x0, bases = {tbase = 0x0, dbase = 0x5ed0, func = 0x7ffff7d72040 <backtrace>}, flags = 4611686018427387904, version = 0, args_size = 0, by_value = '\000' <repeats 17 times>}
        code = <optimized out>
#5  0x00007ffff7d720a6 in backtrace () from /lib/x86_64-linux-gnu/libc.so.6
No symbol table info available.
#6  0x00007ffff41dd6b2 in Simba::Support::DMCharacteristics::DetectDriverManager() () from /opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so
No symbol table info available.
#7  0x00007ffff400591f in Simba::Support::DMCharacteristics::DMCharacteristics() () from /opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so
No symbol table info available.
#8  0x00007ffff3f790ac in Simba::DSI::SharedSingletonManager::Initialize(bool) () from /opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so
No symbol table info available.
#9  0x00007ffff3d8ad8f in Simba::ODBC::Driver::InitializeSingletons() () from /opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so
No symbol table info available.
#10 0x00007ffff3d8c14b in Simba::ODBC::Driver::Initialize() () from /opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so
No symbol table info available.
#11 0x00007ffff3d8d059 in Simba::ODBC::Driver::Driver() () from /opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so
No symbol table info available.
#12 0x00007ffff3d8d537 in Simba::ODBC::DriverSingleton::DoCreateInstance() () from /opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so
No symbol table info available.
#13 0x00007ffff3d8d124 in Simba::Support::ThreadSafeLazy<Simba::ODBC::Driver, Simba::ODBC::DriverSingleton, Simba::Support::NonDeleter<Simba::ODBC::Driver>, void>::DoCreateInstance(Simba::Support::ThreadSafeLazy<Simba::ODBC::Driver, Simba::ODBC::DriverSingleton, Simba::Support::NonDeleter<Simba::ODBC::Driver>, void> const&) () from /opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so
No symbol table info available.
#14 0x00007ffff3d8b1bb in Simba::ODBC::Driver::GetDriver() () from /opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so
No symbol table info available.
#15 0x00007ffff3d056c4 in SQLAllocHandle () from /opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so
No symbol table info available.
#16 0x00007ffff786168b in __connect_part_one () from /opt/conda/envs/hf2/lib/python3.10/site-packages/../../libodbc.so.2
No symbol table info available.
#17 0x00007ffff7882e3a in SQLDriverConnectW () from /opt/conda/envs/hf2/lib/python3.10/site-packages/../../libodbc.so.2
No symbol table info available.
#18 0x00007ffff78cd8e3 in Connection_New(_object*, bool, bool, long, bool, _object*, Object&) () from /opt/conda/envs/hf2/lib/python3.10/site-packages/pyodbc.cpython-310-x86_64-linux-gnu.so
No symbol table info available.
#19 0x00007ffff78d7fb0 in mod_connect(_object*, _object*, _object*) () from /opt/conda/envs/hf2/lib/python3.10/site-packages/pyodbc.cpython-310-x86_64-linux-gnu.so
No symbol table info available.
#20 0x00005555556912d7 in cfunction_call (func=<built-in method connect of module object at remote 0x7ffff7999f80>, args=<optimized out>, kwargs=<optimized out>) at /usr/local/src/conda/python-3.10.11/Objects/methodobject.c:543
        tstate = 0x5555559082a0
        flags = <optimized out>
        meth = <optimized out>
        self = <optimized out>
        result = <optimized out>
#21 0x000055555568abdb in _PyObject_MakeTpCall (tstate=0x5555559082a0, callable=<built-in method connect of module object at remote 0x7ffff7999f80>, args=<optimized out>, nargs=<optimized out>, keywords=('autocommit',)) at /usr/local/src/conda/python-3.10.11/Objects/call.c:215
        call = <optimized out>
        argstuple = ('Host=cbd00417.lan.huk-coburg.de;DRIVER=Cloudera ODBC Driver for Impala;PORT=21050;KrbRealm=LAN.HUK-COBURG.DE;KrbFQDN=_HOST;KrbServiceName=impala;AUTHMECH=1;SSL=1;AllowSelfSignedServerCert=1',)
        kwdict = {'autocommit': True}
--Type <RET> for more, q to quit, c to continue without paging--
        result = 0x0
#22 0x00005555556870ce in _PyObject_VectorcallTstate (kwnames=('autocommit',), nargsf=<optimized out>, args=<optimized out>, callable=<built-in method connect of module object at remote 0x7ffff7999f80>, tstate=0x5555559082a0) at /usr/local/src/conda/python-3.10.11/Include/cpython/abstract.h:112
        nargs = <optimized out>
        func = <optimized out>
        res = <optimized out>
        func = <optimized out>
        res = <optimized out>
        nargs = <optimized out>
#23 _PyObject_VectorcallTstate (kwnames=('autocommit',), nargsf=<optimized out>, args=<optimized out>, callable=<built-in method connect of module object at remote 0x7ffff7999f80>, tstate=0x5555559082a0) at /usr/local/src/conda/python-3.10.11/Include/cpython/abstract.h:99
        func = <optimized out>
        res = <optimized out>
        func = <optimized out>
        res = <optimized out>
        nargs = <optimized out>
#24 PyObject_Vectorcall (kwnames=('autocommit',), nargsf=<optimized out>, args=<optimized out>, callable=<built-in method connect of module object at remote 0x7ffff7999f80>) at /usr/local/src/conda/python-3.10.11/Include/cpython/abstract.h:123
        tstate = 0x5555559082a0
        tstate = <optimized out>
#25 call_function (kwnames=('autocommit',), oparg=<optimized out>, pp_stack=<synthetic pointer>, trace_info=0x7ffffffeb430, tstate=<optimized out>) at /usr/local/src/conda/python-3.10.11/Python/ceval.c:5893
        func = <built-in method connect of module object at remote 0x7ffff7999f80>
        w = <optimized out>
        nkwargs = <optimized out>
        nargs = <optimized out>
        pfunc = 0x7ffff7b39ba0
        x = <optimized out>
        stack = <optimized out>
        pfunc = <optimized out>
        func = <optimized out>
        x = <optimized out>
        w = <optimized out>
        nkwargs = <optimized out>
        nargs = <optimized out>
        stack = <optimized out>
#26 _PyEval_EvalFrameDefault (tstate=<optimized out>, f=Frame 0x7ffff7b39a40, for file /home/ubuntu/apis-analysis/segfault.py, line 25, in <module> (), throwflag=<optimized out>) at /usr/local/src/conda/python-3.10.11/Python/ceval.c:4231
        sp = 0x7ffff7b39bb8
        res = <optimized out>
        names = ('autocommit',)
        stack_pointer = 0x7ffff7b39bb8
        next_instr = <optimized out>
        opcode = <optimized out>
        oparg = <optimized out>
        fastlocals = 0x7ffff7b39ba0
        freevars = 0x7ffff7b39ba0
        retval = 0x0
        eval_breaker = 0x5555558ec464
        co = 0x7ffff799c240
        first_instr = 0x7ffff7a6b540
        names = ('pyodbc', 'node', 'dsn_hostname', 'dsn_driver', 'dsn_port', 'dsn_krbRealm', 'dsn_krbFQDN', 'dsn_krbServiceName', 'dsn', 'connect', 'conn', 'cursor')
        consts = (0, None, 'cbd00417', '.lan.huk-coburg.de', 'Cloudera ODBC Driver for Impala', '21050', 'LAN.HUK-COBURG.DE', '_HOST', 'impala', 'Host=', ';DRIVER=', ';PORT=', ';KrbRealm=', ';KrbFQDN=', ';KrbServiceName=', ';AUTHMECH=1;SSL=1;AllowSelfSignedServerCert=1', True, ('autocommit',))
        co_opcache = <optimized out>
        trace_info = {code = 0x0, bounds = {ar_start = -137511285, ar_end = 32767, ar_line = 1435533984, opaque = {computed_line = 0, lo_next = 0x7ffff7b4df00 "\001", limit = 0x100000010 <error: Cannot access memory at address 0x100000010>}}, cframe = {use_tracing = 0, previous = 0x5555559083a8}}
        prev_cframe = <optimized out>
        main_loop = <optimized out>
        tracing_dispatch = <optimized out>
        dispatch_opcode = <optimized out>
        __func__ = "_PyEval_EvalFrameDefault"
        opcode_targets = {0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x55555568209f <_PyEval_EvalFrameDefault+2879>, 0x555555682e3f <_PyEval_EvalFrameDefault+6367>, 0x555555682d2a <_PyEval_EvalFrameDefault+6090>, 0x5555556826fc <_PyEval_EvalFrameDefault+4508>, 0x555555683cfa <_PyEval_EvalFrameDefault+10138>, 0x5555556856b7 <_PyEval_EvalFrameDefault+16727>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x5555556835b4 <_PyEval_EvalFrameDefault+8276>, 0x555555684fc2 <_PyEval_EvalFrameDefault+14946>, 0x55555568387b <_PyEval_EvalFrameDefault+8987>, 0x555555683c1a <_PyEval_EvalFrameDefault+9914>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x55555568564c <_PyEval_EvalFrameDefault+16620>, 0x55555568502c <_PyEval_EvalFrameDefault+15052>, 0x5555555bc4b5 <_PyEval_EvalFrameDefault-807083>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x555555682c19 <_PyEval_EvalFrameDefault+5817>, 0x5555556821fe <_PyEval_EvalFrameDefault+3230>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x5555556833a0 <_PyEval_EvalFrameDefault+7744>, 0x555555682399 <_PyEval_EvalFrameDefault+3641>, 0x55555568242b <_PyEval_EvalFrameDefault+3787>, 0x5555556820f1 <_PyEval_EvalFrameDefault+2961>, 0x5555556835f4 <_PyEval_EvalFrameDefault+8340>, 0x555555682d83 <_PyEval_EvalFrameDefault+6179>, 0x555555683fd5 <_PyEval_EvalFrameDefault+10869>, 0x55555568465a <_PyEval_EvalFrameDefault+12538>, 0x555555684d65 <_PyEval_EvalFrameDefault+14341>, 0x555555685bbc <_PyEval_EvalFrameDefault+18012>, 0x555555685b4f <_PyEval_EvalFrameDefault+17903>, 0x55555568489a <_PyEval_EvalFrameDefault+13114>, 0x5555556847ec <_PyEval_EvalFrameDefault+12940>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712> <repeats 14 times>, 0x5555556850b3 <_PyEval_EvalFrameDefault+15187>, 0x5555555bbf1e <_PyEval_EvalFrameDefault-808514>, 0x5555555bbd84 <_PyEval_EvalFrameDefault-808924>, 0x5555555bbcc4 <_PyEval_EvalFrameDefault-809116>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x5555555bba43 <_PyEval_EvalFrameDefault-809757>, 0x555555682b88 <_PyEval_EvalFrameDefault+5672>, 0x5555556843af <_PyEval_EvalFrameDefault+11855>, 0x55555568406f <_PyEval_EvalFrameDefault+11023>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x5555556845d4 <_PyEval_EvalFrameDefault+12404>, 0x55555568274d <_PyEval_EvalFrameDefault+4589>, 0x555555683ecc <_PyEval_EvalFrameDefault+10604>, 0x5555556838e6 <_PyEval_EvalFrameDefault+9094>, 0x5555556831de <_PyEval_EvalFrameDefault+7294>, 0x555555682f28 <_PyEval_EvalFrameDefault+6600>, 0x555555683f4f <_PyEval_EvalFrameDefault+10735>, 0x5555556837d8 <_PyEval_EvalFrameDefault+8824>, 0x555555685d63 <_PyEval_EvalFrameDefault+18435>, 0x555555682cbd <_PyEval_EvalFrameDefault+5981>, 0x5555556855c1 <_PyEval_EvalFrameDefault+16481>, 0x5555556846e0 <_PyEval_EvalFrameDefault+12672>, 0x5555556859df <_PyEval_EvalFrameDefault+17535>, 0x5555556830cc <_PyEval_EvalFrameDefault+7020>, 0x5555556852ba <_PyEval_EvalFrameDefault+15706>, 0x555555684583 <_PyEval_EvalFrameDefault+12323>, 0x5555556834a1 <_PyEval_EvalFrameDefault+8001>, 0x555555685cdc <_PyEval_EvalFrameDefault+18300>, 0x5555556844f9 <_PyEval_EvalFrameDefault+12185>, 0x555555684448 <_PyEval_EvalFrameDefault+12008>, 0x555555684766 <_PyEval_EvalFrameDefault+12806>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x555555685df0 <_PyEval_EvalFrameDefault+18576>, 0x555555681aed <_PyEval_EvalFrameDefault+1421>, 0x555555685719 <_PyEval_EvalFrameDefault+16825>, 0x555555684bb5 <_PyEval_EvalFrameDefault+13909>, 0x555555682ae3 <_PyEval_EvalFrameDefault+5507>, 0x5555556826a9 <_PyEval_EvalFrameDefault+4425>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x555555683a39 <_PyEval_EvalFrameDefault+9433>, 0x555555683b90 <_PyEval_EvalFrameDefault+9776>, 0x5555556851db <_PyEval_EvalFrameDefault+15483>, 0x5555556824c5 <_PyEval_EvalFrameDefault+3941>, 0x555555681f5d <_PyEval_EvalFrameDefault+2557>, 0x55555568534a <_PyEval_EvalFrameDefault+15850>, 0x555555682303 <_PyEval_EvalFrameDefault+3491>, 0x55555568353b <_PyEval_EvalFrameDefault+8155>, 0x55555568515d <_PyEval_EvalFrameDefault+15357>, 0x5555555bb802 <_PyEval_EvalFrameDefault-810334>, 0x55555568553c <_PyEval_EvalFrameDefault+16348>, 0x55555568175a <_PyEval_EvalFrameDefault+506>, 0x555555683b09 <_PyEval_EvalFrameDefault+9641>, 0x5555556829f0 <_PyEval_EvalFrameDefault+5264>, 0x555555683063 <_PyEval_EvalFrameDefault+6915>, 0x5555556854c4 <_PyEval_EvalFrameDefault+16228>, 0x555555682e8b <_PyEval_EvalFrameDefault+6443>, 0x555555681d3e <_PyEval_EvalFrameDefault+2014>, 0x555555681ecf <_PyEval_EvalFrameDefault+2415>, 0x555555684e5b <_PyEval_EvalFrameDefault+14587>, 0x555555684dd1 <_PyEval_EvalFrameDefault+14449>, 0x5555556825cb <_PyEval_EvalFrameDefault+4203>, 0x555555683272 <_PyEval_EvalFrameDefault+7442>, 0x55555568368a <_PyEval_EvalFrameDefault+8490>, 0x55555568204f <_PyEval_EvalFrameDefault+2799>, 0x555555681a08 <_PyEval_EvalFrameDefault+1192>, 0x555555681fcc <_PyEval_EvalFrameDefault+2668>, 0x55555568193b <_PyEval_EvalFrameDefault+987>, 0x55555568217c <_PyEval_EvalFrameDefault+3100>, 0x5555556827e4 <_PyEval_EvalFrameDefault+4740>, 0x5555556853d3 <_PyEval_EvalFrameDefault+15987>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x55555568397c <_PyEval_EvalFrameDefault+9244>, 0x555555682630 <_PyEval_EvalFrameDefault+4304>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x5555556816f6 <_PyEval_EvalFrameDefault+406>, 0x5555556817b4 <_PyEval_EvalFrameDefault+596>, 0x5555556858d7 <_PyEval_EvalFrameDefault+17271>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x55555568370a <_PyEval_EvalFrameDefault+8618>, 0x55555568593d <_PyEval_EvalFrameDefault+17373>, 0x55555568181c <_PyEval_EvalFrameDefault+700>, 0x5555556832d2 <_PyEval_EvalFrameDefault+7538>, 0x555555682fbf <_PyEval_EvalFrameDefault+6751>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x555555683449 <_PyEval_EvalFrameDefault+7913>, 0x555555681a88 <_PyEval_EvalFrameDefault+1320>, 0x555555683c97 <_PyEval_EvalFrameDefault+10039>, 0x555555684f58 <_PyEval_EvalFrameDefault+14840>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x5555556828a3 <_PyEval_EvalFrameDefault+4931>, 0x55555568423b <_PyEval_EvalFrameDefault+11483>, 0x555555683d5c <_PyEval_EvalFrameDefault+10236>, 0x55555568260e <_PyEval_EvalFrameDefault+4270>, 0x555555682291 <_PyEval_EvalFrameDefault+3377>, 0x55555568315f <_PyEval_EvalFrameDefault+7167>, 0x5555556841a9 <_PyEval_EvalFrameDefault+11337>, 0x555555685c29 <_PyEval_EvalFrameDefault+18121>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x555555684a55 <_PyEval_EvalFrameDefault+13557>, 0x5555555bb688 <_PyEval_EvalFrameDefault-81071--Type <RET> for more, q to quit, c to continue without paging--
2>, 0x5555555b9ce9 <_PyEval_EvalFrameDefault-817271>, 0x5555556840f5 <_PyEval_EvalFrameDefault+11157>, 0x5555556849be <_PyEval_EvalFrameDefault+13406>, 0x555555685a54 <_PyEval_EvalFrameDefault+17652>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712>, 0x555555681b71 <_PyEval_EvalFrameDefault+1553>, 0x555555681c05 <_PyEval_EvalFrameDefault+1701>, 0x555555684ce4 <_PyEval_EvalFrameDefault+14212>, 0x555555684c6c <_PyEval_EvalFrameDefault+14092>, 0x55555568375f <_PyEval_EvalFrameDefault+8703>, 0x555555685243 <_PyEval_EvalFrameDefault+15587>, 0x5555555bb688 <_PyEval_EvalFrameDefault-810712> <repeats 90 times>}
        PyId_displayhook = {string = 0x5555557b5000 "displayhook", index = -1}
        PyId_send = {string = 0x5555557bcf6c "send", index = -1}
        PyId___build_class__ = {string = 0x5555557bcbaa "__build_class__", index = 18}
        PyId___annotations__ = {string = 0x5555557b5aaf "__annotations__", index = -1}
        PyId___aenter__ = {string = 0x5555557c040b "__aenter__", index = -1}
        PyId___aexit__ = {string = 0x5555557c0401 "__aexit__", index = -1}
        PyId___enter__ = {string = 0x5555557bd6a8 "__enter__", index = 40}
        PyId___exit__ = {string = 0x5555557bd6b2 "__exit__", index = 41}
#27 0x0000555555729852 in _PyEval_EvalFrame (throwflag=0, f=Frame 0x7ffff7b39a40, for file /home/ubuntu/apis-analysis/segfault.py, line 25, in <module> (), tstate=0x5555559082a0) at /usr/local/src/conda/python-3.10.11/Include/internal/pycore_ceval.h:46
No locals.
#28 _PyEval_Vector (tstate=0x5555559082a0, con=<optimized out>, locals=<optimized out>, args=<optimized out>, argcount=<optimized out>, kwnames=<optimized out>) at /usr/local/src/conda/python-3.10.11/Python/ceval.c:5067
        f = Frame 0x7ffff7b39a40, for file /home/ubuntu/apis-analysis/segfault.py, line 25, in <module> ()
        retval = <optimized out>
#29 0x0000555555729797 in PyEval_EvalCode (co=co@entry=<code at remote 0x7ffff799c240>, globals=globals@entry={'__name__': '__main__', '__doc__': None, '__package__': None, '__loader__': <SourceFileLoader(name='__main__', path='/home/ubuntu/apis-analysis/segfault.py') at remote 0x7ffff7a461a0>, '__spec__': None, '__annotations__': {}, '__builtins__': <module at remote 0x7ffff7ba8900>, '__file__': '/home/ubuntu/apis-analysis/segfault.py', '__cached__': None, 'pyodbc': <module at remote 0x7ffff7999f80>, 'node': 'cbd00417', 'dsn_hostname': 'cbd00417.lan.huk-coburg.de', 'dsn_driver': 'Cloudera ODBC Driver for Impala', 'dsn_port': '21050', 'dsn_krbRealm': 'LAN.HUK-COBURG.DE', 'dsn_krbFQDN': '_HOST', 'dsn_krbServiceName': 'impala', 'dsn': 'Host=cbd00417.lan.huk-coburg.de;DRIVER=Cloudera ODBC Driver for Impala;PORT=21050;KrbRealm=LAN.HUK-COBURG.DE;KrbFQDN=_HOST;KrbServiceName=impala;AUTHMECH=1;SSL=1;AllowSelfSignedServerCert=1'}, locals=locals@entry={'__name__': '__main__', '__doc__': None, '__package__': None, '__loader__': <SourceFileLoader(name='__main__', path='/home/ubuntu/apis-analysis/segfault.py') at remote 0x7ffff7a461a0>, '__spec__': None, '__annotations__': {}, '__builtins__': <module at remote 0x7ffff7ba8900>, '__file__': '/home/ubuntu/apis-analysis/segfault.py', '__cached__': None, 'pyodbc': <module at remote 0x7ffff7999f80>, 'node': 'cbd00417', 'dsn_hostname': 'cbd00417.lan.huk-coburg.de', 'dsn_driver': 'Cloudera ODBC Driver for Impala', 'dsn_port': '21050', 'dsn_krbRealm': 'LAN.HUK-COBURG.DE', 'dsn_krbFQDN': '_HOST', 'dsn_krbServiceName': 'impala', 'dsn': 'Host=cbd00417.lan.huk-coburg.de;DRIVER=Cloudera ODBC Driver for Impala;PORT=21050;KrbRealm=LAN.HUK-COBURG.DE;KrbFQDN=_HOST;KrbServiceName=impala;AUTHMECH=1;SSL=1;AllowSelfSignedServerCert=1'}) at /usr/local/src/conda/python-3.10.11/Python/ceval.c:1134
        tstate = 0x5555559082a0
        builtins = <optimized out>
        desc = {fc_globals = {'__name__': '__main__', '__doc__': None, '__package__': None, '__loader__': <SourceFileLoader(name='__main__', path='/home/ubuntu/apis-analysis/segfault.py') at remote 0x7ffff7a461a0>, '__spec__': None, '__annotations__': {}, '__builtins__': <module at remote 0x7ffff7ba8900>, '__file__': '/home/ubuntu/apis-analysis/segfault.py', '__cached__': None, 'pyodbc': <module at remote 0x7ffff7999f80>, 'node': 'cbd00417', 'dsn_hostname': 'cbd00417.lan.huk-coburg.de', 'dsn_driver': 'Cloudera ODBC Driver for Impala', 'dsn_port': '21050', 'dsn_krbRealm': 'LAN.HUK-COBURG.DE', 'dsn_krbFQDN': '_HOST', 'dsn_krbServiceName': 'impala', 'dsn': 'Host=cbd00417.lan.huk-coburg.de;DRIVER=Cloudera ODBC Driver for Impala;PORT=21050;KrbRealm=LAN.HUK-COBURG.DE;KrbFQDN=_HOST;KrbServiceName=impala;AUTHMECH=1;SSL=1;AllowSelfSignedServerCert=1'}, fc_builtins = {'__name__': 'builtins', '__doc__': "Built-in functions, exceptions, and other objects.\n\nNoteworthy: None is the `nil' object; Ellipsis represents `...' in slices.", '__package__': '', '__loader__': <type at remote 0x55555591c650>, '__spec__': <ModuleSpec(name='builtins', loader=<type at remote 0x55555591c650>, origin='built-in', loader_state=None, submodule_search_locations=None, _set_fileattr=False, _cached=None) at remote 0x7ffff7b164d0>, '__build_class__': <built-in method __build_class__ of module object at remote 0x7ffff7ba8900>, '__import__': <built-in method __import__ of module object at remote 0x7ffff7ba8900>, 'abs': <built-in method abs of module object at remote 0x7ffff7ba8900>, 'all': <built-in method all of module object at remote 0x7ffff7ba8900>, 'any': <built-in method any of module object at remote 0x7ffff7ba8900>, 'ascii': <built-in method ascii of module object at remote 0x7ffff7ba8900>, 'bin': <built-in method bin of module object at remote 0x7ffff7ba8900>, 'breakpoint': <built-in method...(truncated), fc_name = '<module>', fc_qualname = '<module>', fc_code = <code at remote 0x7ffff799c240>, fc_defaults = 0x0, fc_kwdefaults = 0x0, fc_closure = 0x0}
#30 0x000055555575aeec in run_eval_code_obj (tstate=0x5555559082a0, co=0x7ffff799c240, globals={'__name__': '__main__', '__doc__': None, '__package__': None, '__loader__': <SourceFileLoader(name='__main__', path='/home/ubuntu/apis-analysis/segfault.py') at remote 0x7ffff7a461a0>, '__spec__': None, '__annotations__': {}, '__builtins__': <module at remote 0x7ffff7ba8900>, '__file__': '/home/ubuntu/apis-analysis/segfault.py', '__cached__': None, 'pyodbc': <module at remote 0x7ffff7999f80>, 'node': 'cbd00417', 'dsn_hostname': 'cbd00417.lan.huk-coburg.de', 'dsn_driver': 'Cloudera ODBC Driver for Impala', 'dsn_port': '21050', 'dsn_krbRealm': 'LAN.HUK-COBURG.DE', 'dsn_krbFQDN': '_HOST', 'dsn_krbServiceName': 'impala', 'dsn': 'Host=cbd00417.lan.huk-coburg.de;DRIVER=Cloudera ODBC Driver for Impala;PORT=21050;KrbRealm=LAN.HUK-COBURG.DE;KrbFQDN=_HOST;KrbServiceName=impala;AUTHMECH=1;SSL=1;AllowSelfSignedServerCert=1'}, locals={'__name__': '__main__', '__doc__': None, '__package__': None, '__loader__': <SourceFileLoader(name='__main__', path='/home/ubuntu/apis-analysis/segfault.py') at remote 0x7ffff7a461a0>, '__spec__': None, '__annotations__': {}, '__builtins__': <module at remote 0x7ffff7ba8900>, '__file__': '/home/ubuntu/apis-analysis/segfault.py', '__cached__': None, 'pyodbc': <module at remote 0x7ffff7999f80>, 'node': 'cbd00417', 'dsn_hostname': 'cbd00417.lan.huk-coburg.de', 'dsn_driver': 'Cloudera ODBC Driver for Impala', 'dsn_port': '21050', 'dsn_krbRealm': 'LAN.HUK-COBURG.DE', 'dsn_krbFQDN': '_HOST', 'dsn_krbServiceName': 'impala', 'dsn': 'Host=cbd00417.lan.huk-coburg.de;DRIVER=Cloudera ODBC Driver for Impala;PORT=21050;KrbRealm=LAN.HUK-COBURG.DE;KrbFQDN=_HOST;KrbServiceName=impala;AUTHMECH=1;SSL=1;AllowSelfSignedServerCert=1'}) at /usr/local/src/conda/python-3.10.11/Python/pythonrun.c:1291
        v = <optimized out>
#31 0x0000555555755fa4 in run_mod (mod=<optimized out>, filename=<optimized out>, globals={'__name__': '__main__', '__doc__': None, '__package__': None, '__loader__': <SourceFileLoader(name='__main__', path='/home/ubuntu/apis-analysis/segfault.py') at remote 0x7ffff7a461a0>, '__spec__': None, '__annotations__': {}, '__builtins__': <module at remote 0x7ffff7ba8900>, '__file__': '/home/ubuntu/apis-analysis/segfault.py', '__cached__': None, 'pyodbc': <module at remote 0x7ffff7999f80>, 'node': 'cbd00417', 'dsn_hostname': 'cbd00417.lan.huk-coburg.de', 'dsn_driver': 'Cloudera ODBC Driver for Impala', 'dsn_port': '21050', 'dsn_krbRealm': 'LAN.HUK-COBURG.DE', 'dsn_krbFQDN': '_HOST', 'dsn_krbServiceName': 'impala', 'dsn': 'Host=cbd00417.lan.huk-coburg.de;DRIVER=Cloudera ODBC Driver for Impala;PORT=21050;KrbRealm=LAN.HUK-COBURG.DE;KrbFQDN=_HOST;KrbServiceName=impala;AUTHMECH=1;SSL=1;AllowSelfSignedServerCert=1'}, locals={'__name__': '__main__', '__doc__': None, '__package__': None, '__loader__': <SourceFileLoader(name='__main__', path='/home/ubuntu/apis-analysis/segfault.py') at remote 0x7ffff7a461a0>, '__spec__': None, '__annotations__': {}, '__builtins__': <module at remote 0x7ffff7ba8900>, '__file__': '/home/ubuntu/apis-analysis/segfault.py', '__cached__': None, 'pyodbc': <module at remote 0x7ffff7999f80>, 'node': 'cbd00417', 'dsn_hostname': 'cbd00417.lan.huk-coburg.de', 'dsn_driver': 'Cloudera ODBC Driver for Impala', 'dsn_port': '21050', 'dsn_krbRealm': 'LAN.HUK-COBURG.DE', 'dsn_krbFQDN': '_HOST', 'dsn_krbServiceName': 'impala', 'dsn': 'Host=cbd00417.lan.huk-coburg.de;DRIVER=Cloudera ODBC Driver for Impala;PORT=21050;KrbRealm=LAN.HUK-COBURG.DE;KrbFQDN=_HOST;KrbServiceName=impala;AUTHMECH=1;SSL=1;AllowSelfSignedServerCert=1'}, flags=<optimized out>, arena=<optimized out>) at /usr/local/src/conda/python-3.10.11/Python/pythonrun.c:1312
        tstate = 0x5555559082a0
        co = 0x7ffff799c240
        v = <optimized out>
#32 0x00005555555e99ed in pyrun_file (fp=0x5555558eb370, filename='/home/ubuntu/apis-analysis/segfault.py', start=<optimized out>, globals={'__name__': '__main__', '__doc__': None, '__package__': None, '__loader__': <SourceFileLoader(name='__main__', path='/home/ubuntu/apis-analysis/segfault.py') at remote 0x7ffff7a461a0>, '__spec__': None, '__annotations__': {}, '__builtins__': <module at remote 0x7ffff7ba8900>, '__file__': '/home/ubuntu/apis-analysis/segfault.py', '__cached__': None, 'pyodbc': <module at remote 0x7ffff7999f80>, 'node': 'cbd00417', 'dsn_hostname': 'cbd00417.lan.huk-coburg.de', 'dsn_driver': 'Cloudera ODBC Driver for Impala', 'dsn_port': '21050', 'dsn_krbRealm': 'LAN.HUK-COBURG.DE', 'dsn_krbFQDN': '_HOST', 'dsn_krbServiceName': 'impala', 'dsn': 'Host=cbd00417.lan.huk-coburg.de;DRIVER=Cloudera ODBC Driver for Impala;PORT=21050;KrbRealm=LAN.HUK-COBURG.DE;KrbFQDN=_HOST;KrbServiceName=impala;AUTHMECH=1;SSL=1;AllowSelfSignedServerCert=1'}, locals={'__name__': '__main__', '__doc__': None, '__package__': None, '__loader__': <SourceFileLoader(name='__main__', path='/home/ubuntu/apis-analysis/segfault.py') at remote 0x7ffff7a461a0>, '__spec__': None, '__annotations__': {}, '__builtins__': <module at remote 0x7ffff7ba8900>, '__file__': '/home/ubuntu/apis-analysis/segfault.py', '__cached__': None, 'pyodbc': <module at remote 0x7ffff7999f80>, 'node': 'cbd00417', 'dsn_hostname': 'cbd00417.lan.huk-coburg.de', 'dsn_driver': 'Cloudera ODBC Driver for Impala', 'dsn_port': '21050', 'dsn_krbRealm': 'LAN.HUK-COBURG.DE', 'dsn_krbFQDN': '_HOST', 'dsn_krbServiceName': 'impala', 'dsn': 'Host=cbd00417.lan.huk-coburg.de;DRIVER=Cloudera ODBC Driver for Impala;PORT=21050;KrbRealm=LAN.HUK-COBURG.DE;KrbFQDN=_HOST;KrbServiceName=impala;AUTHMECH=1;SSL=1;AllowSelfSignedServerCert=1'}, closeit=1, flags=0x7ffffffeb728) at /usr/local/src/conda/python-3.10.11/Python/pythonrun.c:1208
        arena = 0x7ffff7b13b70
        mod = 0x5555559dcea0
        ret = <optimized out>
#33 0x00005555557501d5 in _PyRun_SimpleFileObject (fp=0x5555558eb370, filename='/home/ubuntu/apis-analysis/segfault.py', closeit=1, flags=0x7ffffffeb728) at /usr/local/src/conda/python-3.10.11/Python/pythonrun.c:456
        m = <module at remote 0x7ffff7a715d0>
        d = {'__name__': '__main__', '__doc__': None, '__package__': None, '__loader__': <SourceFileLoader(name='__main__', path='/home/ubuntu/apis-analysis/segfault.py') at remote 0x7ffff7a461a0>, '__spec__': None, '__annotations__': {}, '__builtins__': <module at remote 0x7ffff7ba8900>, '__file__': '/home/ubuntu/apis-analysis/segfault.py', '__cached__': None, 'pyodbc': <module at remote 0x7ffff7999f80>, 'node': 'cbd00417', 'dsn_hostname': 'cbd00417.lan.huk-coburg.de', 'dsn_driver': 'Cloudera ODBC Driver for Impala', 'dsn_port': '21050', 'dsn_krbRealm': 'LAN.HUK-COBURG.DE', 'dsn_krbFQDN': '_HOST', 'dsn_krbServiceName': 'impala', 'dsn': 'Host=cbd00417.lan.huk-coburg.de;DRIVER=Cloudera ODBC Driver for Impala;PORT=21050;KrbRealm=LAN.HUK-COBURG.DE;KrbFQDN=_HOST;KrbServiceName=impala;AUTHMECH=1;SSL=1;AllowSelfSignedServerCert=1'}
        v = <optimized out>
        set_file_name = 1
        ret = -1
        done = <optimized out>
        pyc = <optimized out>
#34 0x000055555574fd43 in _PyRun_AnyFileObject (fp=0x5555558eb370, filename='/home/ubuntu/apis-analysis/segfault.py', closeit=1, flags=0x7ffffffeb728) at /usr/local/src/conda/python-3.10.11/Python/pythonrun.c:90
        decref_filename = 0
        res = <optimized out>
#35 0x000055555574ceb9 in pymain_run_file_obj (skip_source_first_line=0, filename='/home/ubuntu/apis-analysis/segfault.py', program_name='/opt/conda/envs/hf2/bin/python') at /usr/local/src/conda/python-3.10.11/Modules/main.c:357
        fp = <optimized out>
        sb = {st_dev = 2097275, st_ino = 780332454, st_nlink = 1, st_mode = 33188, st_uid = 12574, st_gid = 12574, __pad0 = 0, st_rdev = 0, st_size = 726, st_blksize = 4096, st_blocks = 8, st_atim = {tv_sec = 1687355043, tv_nsec = 500612683}, st_mtim = {tv_sec = 1687354882, tv_nsec = 945128709}, st_ctim = {tv_sec = 1687354882, tv_nsec = 945128709}, __unused = {0, 0, 0}}
        cf = {cf_flags = 0, cf_feature_version = 10}
        run = <optimized out>
        fp = <optimized out>
        sb = <optimized out>
        cf = <optimized out>
        run = <optimized out>
        ch = <optimized out>
--Type <RET> for more, q to quit, c to continue without paging--

 

#36 pymain_run_file (config=0x5555558ec7d0) at /usr/local/src/conda/python-3.10.11/Modules/main.c:376
        filename = '/home/ubuntu/apis-analysis/segfault.py'
        program_name = '/opt/conda/envs/hf2/bin/python'
        res = <optimized out>
        filename = <optimized out>
        program_name = <optimized out>
        res = <optimized out>
#37 pymain_run_python (exitcode=0x7ffffffeb720) at /usr/local/src/conda/python-3.10.11/Modules/main.c:591
        interp = 0x5555558ec420
        config = 0x5555558ec7d0
        main_importer_path = <optimized out>
        interp = <optimized out>
        config = <optimized out>
        main_importer_path = <optimized out>
        error = <optimized out>
        done = <optimized out>
        path0 = <optimized out>
        res = <optimized out>
#38 Py_RunMain () at /usr/local/src/conda/python-3.10.11/Modules/main.c:670
        exitcode = 0
#39 0x000055555571be09 in Py_BytesMain (argc=<optimized out>, argv=<optimized out>) at /usr/local/src/conda/python-3.10.11/Modules/main.c:1090
        args = {argc = 2, use_bytes_argv = 1, bytes_argv = 0x7ffffffeb938, wchar_argv = 0x0}
#40 0x00007ffff7c69083 in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6
No symbol table info available.
#41 0x000055555571bd01 in _start ()
No symbol table info available.

@v-chojas While I've tried lower version of pyodbc, this uses 4.0.39.

$ conda list | grep odbc
pyodbc                    4.0.39          py310heca2aa9_0    conda-forge
unixodbc                  2.3.10               h583eb01_0    conda-forge

v-chojas · 2023-06-21T16:37:25Z

v-chojas
Jun 21, 2023

Remove/rename /opt/conda/envs/hf2/lib/python3.10/site-packages/../../libodbc.so.2 and see if it works.

16 replies

kklein Jun 23, 2023

Not sure whether the strace comment got lost or was intentionally removed.
strace_out.txt

gordthompson Jun 23, 2023
Collaborator

(I removed it as it wouldn't tell us much more than we already know.)

Can you try using pyodbc.connect(connection_string, ansi=True) ?

kklein Jun 23, 2023

Still the same:

$ python segfault.py
Segmentation fault (core dumped)

Curiously, I found that using a different (system pre-installed) conda environment doesn't produce a segmentation fault for the exact same piece of code. I checked that environment's dependencies:

$ conda list | grep odbc
pyodbc                    4.0.32          py310h122e73d_1    conda-forge
unixodbc                  2.3.10               h583eb01_0    conda-forge

I then downgraded the version of pyodbc in my environment to exactly equal the above, i.e. down from 4.0.39 to 4.0.32. I also double-checked that the build number was equal. The version of unixodbc has been the same anyway. Moreover, the Python version is exactly equal. Any ideas as to what this discrepancy could be due to?

kklein Jun 23, 2023

I found what makes the difference: Downgrading libgcc-ng from 13.0.1 to 12.0.1 makes the segfault disappear! Pinning it looks like a feasible solution for me (for now). Thanks a lot for your help and patience.

Answer selected by gordthompson

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Segmentation fault when using pyodbc.connect #1190

{{title}}

Replies: 5 comments 25 replies

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

Segmentation fault when using pyodbc.connect #1190

Environment

Issue

Replies: 5 comments · 25 replies

gordthompson Mar 24, 2023 Collaborator

gordthompson Jun 13, 2023 Collaborator

gordthompson Jun 21, 2023 Collaborator

gordthompson Jun 21, 2023 Collaborator

gordthompson Jun 23, 2023 Collaborator

Replies: 5 comments 25 replies

gordthompson
Mar 24, 2023
Collaborator

gordthompson
Jun 13, 2023
Collaborator

gordthompson Jun 21, 2023
Collaborator

gordthompson Jun 21, 2023
Collaborator

gordthompson Jun 23, 2023
Collaborator