You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "Aizhamal Nurmamat kyzy (JIRA)" <ji...@apache.org> on 2019/05/17 20:03:03 UTC
[jira] [Updated] (AIRFLOW-1703) Airflow LocalExecutor crashes after
3 hours of work. Database is locked
[ https://issues.apache.org/jira/browse/AIRFLOW-1703?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aizhamal Nurmamat kyzy updated AIRFLOW-1703:
--------------------------------------------
Component/s: (was: worker)
(was: db)
database
> 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: database
> Affects Versions: 1.8.0
> Environment: Single CentOS virtual server
> Reporter: Kirill Dubovikov
> Priority: Major
> 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
(v7.6.3#76005)