🐞 Investigate test failure for ExceptionTest_exasol+pyodbc_7_1_17.test_integrity_error

[tkilias]

Summary

My current guess is this actually a problem either with the ODBC driver or the new version of sqlalchemy. However, this blocks currently the dependency update, such that we investigate this later.

___________ ExceptionTest_exasol+pyodbc_7_1_17.test_integrity_error ____________
Traceback (most recent call last):
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/_pytest/runner.py", line 341, in from_call
    result: Optional[TResult] = func()
                                ~~~~^^
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/_pytest/runner.py", line 262, in <lambda>
    lambda: ihook(item=item, **kwds), when=when, reraise=reraise
            ~~~~~^^^^^^^^^^^^^^^^^^^
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/pluggy/_hooks.py", line 513, in __call__
    return self._hookexec(self.name, self._hookimpls.copy(), kwargs, firstresult)
           ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/pluggy/_manager.py", line 120, in _hookexec
    return self._inner_hookexec(hook_name, methods, kwargs, firstresult)
           ~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/pluggy/_callers.py", line 182, in _multicall
    return outcome.get_result()
           ~~~~~~~~~~~~~~~~~~^^
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/pluggy/_result.py", line 100, in get_result
    raise exc.with_traceback(exc.__traceback__)
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/pluggy/_callers.py", line 103, in _multicall
    res = hook_impl.function(*args)
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/_pytest/runner.py", line 177, in pytest_runtest_call
    raise e
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/_pytest/runner.py", line 169, in pytest_runtest_call
    item.runtest()
    ~~~~~~~~~~~~^^
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/_pytest/python.py", line 1792, in runtest
    self.ihook.pytest_pyfunc_call(pyfuncitem=self)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/pluggy/_hooks.py", line 513, in __call__
    return self._hookexec(self.name, self._hookimpls.copy(), kwargs, firstresult)
           ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/pluggy/_manager.py", line 120, in _hookexec
    return self._inner_hookexec(hook_name, methods, kwargs, firstresult)
           ~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/pluggy/_callers.py", line 139, in _multicall
    raise exception.with_traceback(exception.__traceback__)
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/pluggy/_callers.py", line 103, in _multicall
    res = hook_impl.function(*args)
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/_pytest/python.py", line 194, in pytest_pyfunc_call
    result = testfunction(**testargs)
  File "<string>", line 2, in test_integrity_error
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/sqlalchemy/testing/exclusions.py", line 104, in decorate
    return self._do(config._current, fn, *args, **kw)
           ~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/sqlalchemy/testing/exclusions.py", line 134, in _do
    self._expect_failure(cfg, ex, name=fn.__name__)
    ~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/sqlalchemy/testing/exclusions.py", line 156, in _expect_failure
    util.raise_(ex, with_traceback=sys.exc_info()[2])
    ~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
    raise exception
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/sqlalchemy/testing/exclusions.py", line 132, in _do
    return_value = fn(*args, **kw)
  File "/home/runner/work/sqlalchemy-exasol/sqlalchemy-exasol/test/integration/sqlalchemy/test_suite.py", line 278, in test_integrity_error
    assert_raises(
    ~~~~~~~~~~~~~^
        exc.IntegrityError,
        ^^^^^^^^^^^^^^^^^^^
    ...<2 lines>...
        {"id": 1, "data": "d1"},
        ^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/sqlalchemy/testing/assertions.py", line 370, in assert_raises
    return _assert_raises(except_cls, callable_, args, kw, check_context=True)
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/sqlalchemy/testing/assertions.py", line 427, in _assert_raises
    with _expect_raises(except_cls, msg, check_context) as ec:
         ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/hostedtoolcache/Python/3.13.2/x64/lib/python3.13/contextlib.py", line 148, in __exit__
    next(self.gen)
    ~~~~^^^^^^^^^^
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/sqlalchemy/testing/assertions.py", line 472, in _expect_raises
    assert success, "Callable did not raise an exception"
AssertionError: Callable did not raise an exception
assert False
------------------------------ Captured log call -------------------------------
ERROR    sqlalchemy.pool.impl.QueuePool:base.py:2008 Error closing cursor
Traceback (most recent call last):
  File "/home/runner/.cache/pypoetry/virtualenvs/sqlalchemy-exasol-6DrQJffl-py3.13/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 2005, in _safe_close_cursor
    cursor.close()
    ~~~~~~~~~~~~^^
pyodbc.Error: ('HY000', 'The driver did not supply an error!')

https://github.com/exasol/sqlalchemy-exasol/actions/runs/13325929234/job/37219147395?pr=538