potiuk opened a new issue, #46430:
URL: https://github.com/apache/airflow/issues/46430

   Sometimes our tests fail with this error that indicates mismatch between 
libSSL that is embedded in psycopg2 and the one available in the system. Given 
that this appears very rarely and randomly, and that we are using containers 
for all the runs, it looks like it is environmental and likely related to 
Kernel Version used at the Github Runners we get.
   
   It should eventually go away (hopefully) - it's hard to think about 
remediation if that's the real root cause.
   
   ```python
   ==================================== ERRORS 
====================================
   ____ ERROR collecting tests/provider_tests/postgres/assets/test_postgres.py 
____
   ImportError while importing test module 
'/opt/airflow/providers/postgres/tests/provider_tests/postgres/assets/test_postgres.py'.
   Hint: make sure your test modules/packages have valid Python names.
   Traceback:
   /usr/local/lib/python3.12/importlib/__init__.py:90: in import_module
       return _bootstrap._gcd_import(name[level:], package, level)
   providers/postgres/tests/provider_tests/postgres/assets/test_postgres.py:24: 
in <module>
       from airflow.providers.postgres.assets.postgres import sanitize_uri
   airflow/__init__.py:78: in <module>
       settings.initialize()
   airflow/settings.py:642: in initialize
       configure_orm()
   airflow/settings.py:366: in configure_orm
       engine = create_engine(SQL_ALCHEMY_CONN, connect_args=connect_args, 
**engine_args, future=True)
   /usr/local/lib/python3.12/site-packages/sqlalchemy/util/deprecations.py:309: 
in warned
       return fn(*args, **kwargs)
   /usr/local/lib/python3.12/site-packages/sqlalchemy/engine/create.py:560: in 
create_engine
       dbapi = dialect_cls.dbapi(**dbapi_args)
   
/usr/local/lib/python3.12/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py:782:
 in dbapi
       import psycopg2
   /usr/local/lib/python3.12/site-packages/psycopg2/__init__.py:51: in <module>
       from psycopg2._psycopg import (                     # noqa
   E   ImportError: 
/usr/local/lib/python3.12/site-packages/psycopg2/_psycopg.cpython-312-x86_64-linux-gnu.so:
 undefined symbol: GENERAL_NAME_free
   ___ ERROR collecting tests/provider_tests/postgres/dialects/test_postgres.py 
___
   /usr/local/lib/python3.12/logging/config.py:105: in _resolve
       found = getattr(found, n)
   E   AttributeError: partially initialized module 'airflow' has no attribute 
'utils' (most likely due to a circular import)
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to