airflow-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kirill Dubovikov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (AIRFLOW-1703) Airflow LocalExecutor crashes after 3 hours of work. Database is locked
Date Wed, 11 Oct 2017 13:03:00 GMT
Kirill Dubovikov created AIRFLOW-1703:
-----------------------------------------

             Summary: Airflow LocalExecutor crashes after 3 hours of work. Database is locked
                 Key: AIRFLOW-1703
                 URL: https://issues.apache.org/jira/browse/AIRFLOW-1703
             Project: Apache Airflow
          Issue Type: Bug
          Components: db, worker
    Affects Versions: Airflow 1.8
         Environment: Single CentOS virtual server
            Reporter: Kirill Dubovikov
         Attachments: nohup.out

Airflow consistently crashes after working several hours on a single node when using SQLite
DB. Our DAG is scheduled to run {{@daily}}. We launch airflow using the following commands

{code:sh}
airflow scheduler
airflow webserver -p 8080
{code}

After a while worker and webserver crash with the following error: {{sqlalchemy.exc.OperationalError:
(sqlite3.OperationalError) database is locked [SQL: 'SELECT connection.conn_id AS connection_conn_id
\nFROM connection GROUP BY connection.conn_id']}}

I've attached full logs for further investigation



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message