anavrotski commented on issue #60542:
URL: https://github.com/apache/airflow/issues/60542#issuecomment-3750992092

   I was able to repeat the same error with a shorter api-server log:
   ```
   wait-for-airflow-migrations 
   wait-for-airflow-migrations 
/home/airflow/.local/lib/python3.12/site-packages/airflow/providers/common/compat/security/permissions.py:30
 RemovedInAirflow4Warning: The airflow.security.permissions module is 
deprecated; please see 
https://airflow.apache.org/docs/apache-airflow/stable/security/deprecated_permissions.html
   wait-for-airflow-migrations 2026-01-14T18:01:02.397778Z [info     [] Context 
impl MySQLImpl.        [alembic.runtime.migration] loc=migration.py:211
   wait-for-airflow-migrations 2026-01-14T18:01:02.398078Z [info     [] Will 
assume non-transactional DDL. [alembic.runtime.migration] loc=migration.py:214
   stream closed: EOF for airflow/airflow-api-server-7bd64fcfb9-vmzk4 
(wait-for-airflow-migrations)
   api-server     +------------------------------------
   api-server INFO:     172.25.124.36:33794 - "GET /api/v2/version HTTP/1.1" 
200 OK
   api-server INFO:     172.25.124.36:33792 - "GET /api/v2/version HTTP/1.1" 
200 OK
   api-server INFO:     172.25.116.81:58858 - "GET 
/api/v2/dagTags?limit=10&offset=0&order_by=name&tag_name_pattern= HTTP/1.1" 200 
OK
   api-server INFO:     172.25.120.74:53294 - "GET 
/ui/dags?dag_runs_limit=1&limit=50&offset=0&exclude_stale=true&order_by=next_dagrun
 HTTP/1.1" 200 OK
   api-server INFO:     172.25.116.81:58858 - "GET 
/api/v2/assets/events?limit=6&order_by=-timestamp&timestamp_gte=2026-01-13T18%3A20%3A04.482Z&timestamp_lte=2026-01-14T18%3A20%3A04.482Z
 HTTP/1.1" 200 OK
   api-server INFO:     172.25.120.74:53294 - "GET 
/ui/dashboard/historical_metrics_data?start_date=2026-01-13T18%3A20%3A04.482Z 
HTTP/1.1" 200 OK
   api-server INFO:     172.25.120.74:53294 - "GET /api/v2/auth/logout 
HTTP/1.1" 307 Temporary Redirect
   api-server INFO:     172.25.120.74:53294 - "GET /auth/logout HTTP/1.1" 307 
Temporary Redirect
   api-server INFO:     172.25.120.74:53294 - "GET /auth/login/ HTTP/1.1" 200 OK
   api-server INFO:     172.25.124.36:55600 - "GET /api/v2/version HTTP/1.1" 
200 OK
   api-server INFO:     172.25.120.74:53294 - "GET 
/auth/static/appbuilder/css/bootstrap.min.css HTTP/1.1" 200 OK
   api-server INFO:     172.25.116.81:41322 - "GET 
/auth/static/appbuilder/css/fontawesome/regular.min.css HTTP/1.1" 200 OK
   api-server INFO:     172.25.124.36:55602 - "GET /api/v2/version HTTP/1.1" 
200 OK
   api-server INFO:     172.25.120.74:53316 - "GET 
/auth/static/appbuilder/css/fontawesome/brands.min.css HTTP/1.1" 200 OK
   api-server INFO:     172.25.116.81:55368 - "GET 
/auth/static/appbuilder/css/fontawesome/solid.min.css HTTP/1.1" 200 OK
   api-server INFO:     172.25.116.81:58858 - "GET 
/auth/static/appbuilder/css/fontawesome/fontawesome.min.css HTTP/1.1" 200 OK
   api-server INFO:     172.25.120.74:53304 - "GET 
/auth/static/appbuilder/css/fontawesome/v4-shims.min.css HTTP/1.1" 200 OK
   api-server INFO:     172.25.116.81:58858 - "GET 
/auth/static/appbuilder/css/bootstrap-datepicker/bootstrap-datepicker3.min.css 
HTTP/1.1" 200 OK
   api-server INFO:     172.25.116.81:55368 - "GET 
/auth/static/appbuilder/css/select2/select2.min.css HTTP/1.1" 200 OK
   api-server INFO:     172.25.120.74:53304 - "GET 
/auth/static/appbuilder/css/select2/select2-bootstrap.min.css HTTP/1.1" 200 OK
   api-server INFO:     172.25.120.74:53304 - "GET 
/auth/static/appbuilder/css/flags/flags16.css HTTP/1.1" 200 OK
   api-server INFO:     172.25.116.81:55368 - "GET 
/auth/static/appbuilder/css/ab.css HTTP/1.1" 200 OK
   api-server INFO:     172.25.116.81:55368 - "GET 
/auth/static/dist/airflowDefaultTheme.ef6fc04c9b6920cd75c9.css HTTP/1.1" 200 OK
   api-server INFO:     172.25.116.81:55368 - "GET 
/auth/static/dist/materialIcons.ad07a489b2f0fc1a96bf.css HTTP/1.1" 200 OK
   api-server INFO:     172.25.120.74:53304 - "GET 
/auth/static/dist/main.bc1f701c3d133e2a3bab.css HTTP/1.1" 200 OK
   api-server INFO:     172.25.120.74:53294 - "GET 
/auth/static/dist/loadingDots.76f4332c0a932c3dc08f.css HTTP/1.1" 200 OK
   api-server INFO:     172.25.120.74:53294 - "GET 
/auth/static/dist/jquery-ui.min.css HTTP/1.1" 200 OK
   api-server INFO:     172.25.116.81:55368 - "GET 
/auth/static/dist/flash.eaaf777ec1b3628cf7be.css HTTP/1.1" 200 OK
   api-server INFO:     172.25.116.81:58858 - "GET 
/auth/static/appbuilder/js/bootstrap.min.js HTTP/1.1" 200 OK
   api-server INFO:     172.25.116.81:55368 - "GET 
/auth/static/appbuilder/js/ab_filters.js HTTP/1.1" 200 OK
   api-server INFO:     172.25.120.74:53304 - "GET 
/auth/static/appbuilder/js/ab_actions.js HTTP/1.1" 200 OK
   api-server INFO:     172.25.120.74:53316 - "GET 
/auth/static/appbuilder/js/bootstrap-datepicker/bootstrap-datepicker.min.js 
HTTP/1.1" 200 OK
   api-server INFO:     172.25.120.74:53294 - "GET 
/auth/static/appbuilder/js/jquery-latest.js HTTP/1.1" 200 OK
   api-server INFO:     172.25.116.81:55368 - "GET 
/auth/static/appbuilder/js/select2/select2.min.js HTTP/1.1" 200 OK
   api-server INFO:     172.25.116.81:58858 - "GET 
/auth/static/appbuilder/js/ab.js HTTP/1.1" 200 OK
   api-server INFO:     172.25.120.74:53316 - "GET 
/auth/static/dist/moment.5b85b4f6be2fe9c405ac.js HTTP/1.1" 200 OK
   api-server INFO:     172.25.120.74:53294 - "GET 
/auth/static/dist/jquery-ui.min.js HTTP/1.1" 200 OK
   api-server INFO:     172.25.116.81:55368 - "GET 
/auth/static/dist/main.bc1f701c3d133e2a3bab.js HTTP/1.1" 200 OK
   api-server INFO:     172.25.120.74:53294 - "GET 
/auth/static/appbuilder/css/webfonts/fa-brands-400.woff2 HTTP/1.1" 304 Not 
Modified
   api-server INFO:     172.25.120.74:53294 - "GET /auth/login/azure?next= 
HTTP/1.1" 302 Found
   api-server 2026-01-14T18:20:17.764084Z [error    [] Exception on 
/oauth-authorized/azure [GET[] [airflow.providers.fab.www.app] loc=app.py:1744
   api-server Traceback (most recent call last):
   api-server   File 
"/home/airflow/.local/lib/python3.12/site-packages/flask/app.py", line 2529, in 
wsgi_app
   api-server     response = self.full_dispatch_request()
   api-server                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   api-server   File 
"/home/airflow/.local/lib/python3.12/site-packages/flask/app.py", line 1825, in 
full_dispatch_request
   api-server     rv = self.handle_user_exception(e)
   api-server          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   api-server   File 
"/home/airflow/.local/lib/python3.12/site-packages/flask/app.py", line 1823, in 
full_dispatch_request
   api-server     rv = self.dispatch_request()
   api-server          ^^^^^^^^^^^^^^^^^^^^^^^
   api-server   File 
"/home/airflow/.local/lib/python3.12/site-packages/flask/app.py", line 1799, in 
dispatch_request
   api-server     return 
self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
   api-server            
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   api-server   File 
"/home/airflow/.local/lib/python3.12/site-packages/flask_appbuilder/security/views.py",
 line 713, in oauth_authorized
   api-server     user = self.appbuilder.sm.auth_user_oauth(userinfo)
   api-server            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   api-server   File 
"/home/airflow/.local/lib/python3.12/site-packages/airflow/providers/fab/auth_manager/security_manager/override.py",
 line 2042, in auth_user_oauth
   api-server     user = self.find_user(username=username)
   api-server            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   api-server   File 
"/home/airflow/.local/lib/python3.12/site-packages/airflow/providers/fab/auth_manager/security_manager/override.py",
 line 1437, in find_user
   api-server     return self.session.scalars(
   api-server            ^^^^^^^^^^^^^^^^^^^^^
   api-server   File 
"/home/airflow/.local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", 
line 2459, in scalars
   api-server     return self._execute_internal(
   api-server            ^^^^^^^^^^^^^^^^^^^^^^^
   api-server   File 
"/home/airflow/.local/lib/python3.12/site-packages/sqlalchemy/orm/session.py", 
line 2249, in _execute_internal
   api-server     result: Result[Any] = compile_state_cls.orm_execute_statement(
   api-server                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   api-server   File 
"/home/airflow/.local/lib/python3.12/site-packages/sqlalchemy/orm/context.py", 
line 306, in orm_execute_statement
   api-server     result = conn.execute(
   api-server              ^^^^^^^^^^^^^
   api-server   File 
"/home/airflow/.local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", 
line 1419, in execute
   api-server     return meth(
   api-server            ^^^^^
   api-server   File 
"/home/airflow/.local/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", 
line 527, in _execute_on_connection
   api-server     return connection._execute_clauseelement(
   api-server            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   api-server   File 
"/home/airflow/.local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", 
line 1641, in _execute_clauseelement
   api-server     ret = self._execute_context(
   api-server           ^^^^^^^^^^^^^^^^^^^^^^
   api-server   File 
"/home/airflow/.local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", 
line 1813, in _execute_context
   api-server     conn = self._revalidate_connection()
   api-server            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   api-server   File 
"/home/airflow/.local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", 
line 673, in _revalidate_connection
   api-server     self._invalid_transaction()
   api-server   File 
"/home/airflow/.local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", 
line 663, in _invalid_transaction
   api-server     raise exc.PendingRollbackError(
   api-server sqlalchemy.exc.PendingRollbackError: Can't reconnect until 
invalid transaction is rolled back.  Please rollback() fully before proceeding 
(Background on this error at: https://sqlalche.me/e/20/8s2b)
   api-server INFO:     172.25.120.74:53294 - "GET 
/auth/oauth-authorized/azure?code=1.AQMA9K...fqA&state=eyJhbG...&session_state=009a7329-bd24-d99e-9121-bb58dacd5d2b
 HTTP/1.1" 500 Internal Server Error
   api-server INFO:     172.25.120.74:53294 - "GET /favicon.ico HTTP/1.1" 200 OK
   api-server INFO:     172.25.124.36:50180 - "GET /api/v2/version HTTP/1.1" 
200 OK
   api-server INFO:     172.25.124.36:50178 - "GET /api/v2/version HTTP/1.1" 
200 OK
   api-server INFO:     172.25.124.36:37666 - "GET /api/v2/version HTTP/1.1" 
200 OK
   api-server INFO:     172.25.124.36:37680 - "GET /api/v2/version HTTP/1.1" 
200 OK
   api-server INFO:     172.25.124.36:49732 - "GET /api/v2/version HTTP/1.1" 
200 OK
   api-server INFO:     172.25.124.36:49734 - "GET /api/v2/version HTTP/1.1" 
200 OK
   api-server INFO:     172.25.124.36:44858 - "GET /api/v2/version HTTP/1.1" 
200 OK
   api-server INFO:     172.25.124.36:44860 - "GET /api/v2/version HTTP/1.1" 
200 OK
   api-server INFO:     172.25.124.36:35950 - "GET /api/v2/version HTTP/1.1" 
200 OK
   api-server INFO:     172.25.124.36:35944 - "GET /api/v2/version HTTP/1.1" 
200 OK
   
   ```


-- 
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