How to solve error "sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: session" when running Airflow

Question

I've installed Apache Airflow version 2.2.4 on my system Ubuntu 20.0.4 LTS and I'm using these steps

export AIRFLOW_HOME=~/airflow
pip3 install apache-airflow
airflow db init
airflow users create --username admin --firstname XXXX --lastname XXX --role Admin --email [email protected]

When I'm running my server using this command

airflow webserver -p 8080

I've got an error saying

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: session

How can I solve this error?

yes you can see in step 3 airflow db init

iamhimanshu0
– iamhimanshu0

2022-03-06 13:20:43 +00:00
Commented Mar 6, 2022 at 13:20 — iamhimanshu0
– iamhimanshu0, Commented Mar 6, 2022 at 13:20

tsveti_iko · Accepted Answer · 2022-05-31 10:31:24Z

5

For me the issue was that I have set the AIRFLOW_HOME on one tab of my terminal, but on the other tab (from where I was running the webserver) I forgot to set it. So the solution is to do the following in ALL TERMINAL TABS that you're using for Airflow:

Activate the virtual environment where your Airflow is installed
```
source your_airflow_venv/bin/activate
```
Navigate to the directory where your Airflow project is
```
cd /path_to_your_airflow_dir
```
Update your AIRFLOW_HOME environment variable
```
export AIRFLOW_HOME=$(pwd)
```
Initialize the Airflow database
```
airflow db init
```
Start the Airflow Web Server or the Airflow Scheduler (depending on which terminal tab you currently are)
```
airflow scheduler
airflow webserver
```

answered May 31, 2022 at 10:31

tsveti_iko

8,1705 gold badges56 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ouflak · Accepted Answer · 2022-03-12 19:28:25Z

0

Before running webserver using command airflow webserver, make sure to set AIRFLOW_HOME using below command:

 export AIRFLOW_HOME="your_airflow_directory"

edited Mar 12, 2022 at 19:28

ouflak

2,56310 gold badges46 silver badges53 bronze badges

answered Mar 12, 2022 at 16:34

ANURAG BISHT

212 bronze badges

10 Comments

iamhimanshu0 Over a year ago

i did try this still getting the same error?

ANURAG BISHT Over a year ago

Then try doing a db reset using command : airflow db reset after setting the above. variable. and try doing the airflow db init. Also. make sure to set same AIRFLOW_HOME before running these commands

iamhimanshu0 Over a year ago

it's not working geeting the same result again seems like there is some problem with session id?

[SQL: SELECT session.id AS session_id_1, session.session_id AS session_session_id, session.data AS session_data, session.expiry AS session_expiry  FROM session  WHERE session.session_id = ?  LIMIT ? OFFSET ?] [parameters: ('347fde8a-01bc-4074-9f3c-87f1dc7ec4de', 1, 0)] (Background on this error at: http://sqlalche.me/e/13/e3q8)

ANURAG BISHT Over a year ago

try a fresh installation, that would be last resort

iamhimanshu0 Over a year ago

I did I installed it again using a different directory but still getting the same error? I don't know what when wrong? I can't even find solution online

|

Sebastian Sätzler · Accepted Answer · 2022-07-22 00:56:48Z

0

I had the same error message. I made the mistake and naively installed airflow through pip.

I fixed the issue by deleting the directory AIRFLOW_HOME points to and reinstalling airflow through pip with a constraint. Then I initiated the automated airflow setup with the airflow standalone command.

answered Jul 22, 2022 at 0:56

Sebastian Sätzler

112 bronze badges

Collectives™ on Stack Overflow

How to solve error "sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: session" when running Airflow

3 Answers 3

Comments

10 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

10 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related