Airflow v3 - Issue with FAB Auth – Missing "session" Table After Fresh Install #55549
Answered
by
zoomingrocket
zoomingrocket
asked this question in
General
-
|
Hi All, I'm a first-time Airflow user and could use some help. We set up Airflow using the PyPI method with version 3.0.4 and constraints, following the official docs: pip install "apache-airflow[celery]==3.0.4" --no-cache-dir --constraint "https://raw.githubusercontent.com/apache/airflow/constraints-3.0.4/constraints-3.9.txt"We also installed: pip install psycopg2 asyncpg apache-airflow-providers-fabAfter updating Later, we switched to FAB authentication by updating: auth_manager = airflow.providers.fab.auth_manager.fab_auth_manager.FabAuthManagerOn first startup, roles were provisioned and we added a user via 
Logs indicate the "session" table is missing, which is confusing since this is a fresh install and we ran Any guidance on what we might have missed or common gotchas would be greatly appreciated! Thanks in advance! |
Beta Was this translation helpful? Give feedback.
Answered by
zoomingrocket
Sep 15, 2025
Replies: 3 comments 5 replies
-
|
Look at fab docs. If you migrated Airflow without FAB, you need to use FAB specific CLI to setup/migrate fab database https://airflow.apache.org/docs/apache-airflow-providers-fab/stable/upgrading.html# |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
@potiuk - Thanks for the input. Since v3 segregated FAB required to run the |
Beta Was this translation helpful? Give feedback.
3 replies
-
|
No idea, to be honest. It should work (and it does work in the environments we check). Not sure what you have done wrong, but I would strongly recommend you to start from the scratch, install airflow with fab provider first, configure FabAuthManager and run Of course if you can provide exact reproducible steps what to do to get to the point you are at - you are absolutely free to open an issue, but make sure you do it step-by-step starting from scratch as well. |
Beta Was this translation helpful? Give feedback.
-
|
@potiuk - Thanks, will attempt a fresh install. Found similar-looking bug opened in the last 3 days, not sure if related #55555 |
Beta Was this translation helpful? Give feedback.
-
|
Not related. |
Beta Was this translation helpful? Give feedback.
-
|
@potiuk - So here is my observation, if we setup basic Airflow with SimpleAuth first Post initial setup update airflow.cfg to move to FAB, run High Level sequence followed Hope this helps someone, if a direct v3 install is attempted step by step using PyPI method and then subsequent enablement of FAB. |
Beta Was this translation helpful? Give feedback.
2 replies
-
|
Cool! |
Beta Was this translation helpful? Give feedback.
-
|
been stuck here for a few days, and can confirm this fix worked for me also. |
Beta Was this translation helpful? Give feedback.
Answer selected by
zoomingrocket
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
@potiuk - So here is my observation, if we setup basic Airflow with SimpleAuth first
airflow db migrateis done without any FAB reference even though the provider is installed,airflow db migratewill not create session table which is expected.Post initial setup update airflow.cfg to move to FAB, run
airflow db migrateorairflow fab-db migrate-> These will only provision ab_* tables, but session table will be missing.I finally did
airflow db reset-> This provisioned the only missing session tableThen do
airflow create userto provision the first user and all also seed the base roles, permissions, etc. for FABHigh Level sequence followed
Update airflow.cfg:
external_db_managers = ai…