You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "Komalpawar22 (via GitHub)" <gi...@apache.org> on 2026/01/08 05:02:55 UTC

[I] JWT token is not valid: Signature has expired + sqlalchemy.exc.PendingRollbackError: Can't reconnect until invalid transaction is rolled back [airflow]

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

   ### Apache Airflow version
   
   3.1.5
   
   ### If "Other Airflow 3 version" selected, which one?
   
   _No response_
   
   ### What happened?
   
   We are using airflow 3.1.5 and my providers are as follows 
   
   ```bash
   RUN pip install --no-cache-dir mysqlclient==2.2.7
   RUN pip install --no-cache-dir aiomysql
   # Airflow 3.1 required provider for KubernetesExecutor
   RUN pip install --no-cache-dir apache-airflow-providers-cncf-kubernetes==10.8.2
   RUN pip install --no-cache-dir connexion[flask]>=3.0
   RUN pip install --no-cache-dir "flask-appbuilder<=5.0.0"
   RUN pip install --no-cache-dir apache-airflow-providers-fab==3.0.1
   RUN pip install --no-cache-dir apache-airflow-providers-google
   RUN pip install --no-cache-dir apache-airflow-providers-celery
   RUN pip install --no-cache-dir apache-airflow-providers-slack==9.6.1
   ```
   
   We are consistently facing the issue, almost daily. And we need to rollout our deployment everytime we face this isse. The issue start from `JWT token is not valid: Signature has expired [airflow.api_fastapi.auth.managers.base_auth_manager` then goes till `sqlalchemy.exc.PendingRollbackError: Can't reconnect until invalid transaction is rolled back` 
   
   auth manager i am using is `auth_manager: "airflow.providers.fab.auth_manager.fab_auth_manager.FabAuthManager"` but in error i see `[airflow.api_fastapi.auth.managers.base_auth_manager` can anybody help me with this
   
   ### What you think should happen instead?
   
   Maybe I am using the auth manager incorrectly, like if we are using fab, then why is it going for `base_auth_manager` here? We have the jmt token configured in our helm as well. We get this daily; can anyone help us with this on a priority basis?
   
   ### How to reproduce
   
   I am not sure how to do that, it's totally related to the auth manager.
   
   ### Operating System
   
   linux
   
   ### Versions of Apache Airflow Providers
   
   RUN pip install --no-cache-dir mysqlclient==2.2.7
   RUN pip install --no-cache-dir aiomysql
   # Airflow 3.1 required provider for KubernetesExecutor
   RUN pip install --no-cache-dir apache-airflow-providers-cncf-kubernetes==10.8.2
   RUN pip install --no-cache-dir connexion[flask]>=3.0
   RUN pip install --no-cache-dir "flask-appbuilder<=5.0.0"
   RUN pip install --no-cache-dir apache-airflow-providers-fab==3.0.1
   RUN pip install --no-cache-dir apache-airflow-providers-google
   RUN pip install --no-cache-dir apache-airflow-providers-celery
   RUN pip install --no-cache-dir apache-airflow-providers-slack==9.6.1
   
   ### Deployment
   
   Official Apache Airflow Helm Chart
   
   ### Deployment details
   
   We have deployed it on standard GKE cluster with celery executors and kuberenetes executors.
   
   ### Anything else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [x] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [x] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
   


-- 
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: commits-unsubscribe@airflow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] JWT token is not valid: Signature has expired + sqlalchemy.exc.PendingRollbackError: Can't reconnect until invalid transaction is rolled back [airflow]

Posted by "devgonvarun (via GitHub)" <gi...@apache.org>.
devgonvarun commented on issue #60250:
URL: https://github.com/apache/airflow/issues/60250#issuecomment-3728386668

   https://github.com/apache/airflow/issues/59349 tracks this issue. I am on airflow 3.1.3 and fab 3.0.2 and havent seen this error once. Until the next fab release i suggest using v3.0.2. 


-- 
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: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] JWT token is not valid: Signature has expired + sqlalchemy.exc.PendingRollbackError: Can't reconnect until invalid transaction is rolled back [airflow]

Posted by "suii2210 (via GitHub)" <gi...@apache.org>.
suii2210 commented on issue #60250:
URL: https://github.com/apache/airflow/issues/60250#issuecomment-3730381773

   I’d like to help investigate this further and work on a fix,  especially around proper rollback/cleanup when JWT validation fails.


-- 
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: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] JWT token is not valid: Signature has expired + sqlalchemy.exc.PendingRollbackError: Can't reconnect until invalid transaction is rolled back [airflow]

Posted by "leju-uhao (via GitHub)" <gi...@apache.org>.
leju-uhao commented on issue #60250:
URL: https://github.com/apache/airflow/issues/60250#issuecomment-3727846361

   Same issue. Is there any solution?


-- 
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: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] JWT token is not valid: Signature has expired + sqlalchemy.exc.PendingRollbackError: Can't reconnect until invalid transaction is rolled back [airflow]

Posted by "vincbeck (via GitHub)" <gi...@apache.org>.
vincbeck closed issue #60250: JWT token is not valid: Signature has expired + sqlalchemy.exc.PendingRollbackError: Can't reconnect until invalid transaction is rolled back
URL: https://github.com/apache/airflow/issues/60250


-- 
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: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] JWT token is not valid: Signature has expired + sqlalchemy.exc.PendingRollbackError: Can't reconnect until invalid transaction is rolled back [airflow]

Posted by "vincbeck (via GitHub)" <gi...@apache.org>.
vincbeck commented on issue #60250:
URL: https://github.com/apache/airflow/issues/60250#issuecomment-3756276108

   Duplicate of https://github.com/apache/airflow/issues/59349


-- 
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: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] JWT token is not valid: Signature has expired + sqlalchemy.exc.PendingRollbackError: Can't reconnect until invalid transaction is rolled back [airflow]

Posted by "arjav1528 (via GitHub)" <gi...@apache.org>.
arjav1528 commented on issue #60250:
URL: https://github.com/apache/airflow/issues/60250#issuecomment-3731793182

   Hi, I would like to work on this issue


-- 
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: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org