GitHub user raoakmal55 added a comment to the discussion: Airflow 3.1.3 – API
Server returns 500 Internal Server Error on /login once per day (session
invalidation / PendingRollbackError)
I am also facing this issue and i have tried to add pgbouncer as well but no
luck so far. By Adding those parameters we can just reducued the frequency of
the issue but its still there. Here are my configs
```yaml
extraEnv: |
- name: AIRFLOW__DATABASE__SQL_ALCHEMY_POOL_PRE_PING
value: "True"
- name: AIRFLOW__DATABASE__SQL_ALCHEMY_POOL_RESET_ON_RETURN
value: "rollback"
- name: AIRFLOW__DATABASE__SQL_ALCHEMY_POOL_RECYCLE
value: "300"
- name: AIRFLOW__DATABASE__SQL_ALCHEMY_POOL_TIMEOUT
value: "30"
- name: AIRFLOW__DATABASE__SQL_ALCHEMY_ENGINE_ARGS
value: '{"pool_pre_ping": true}'
```
GitHub link:
https://github.com/apache/airflow/discussions/59487#discussioncomment-16570238
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
