[ https://issues.apache.org/jira/browse/AIRFLOW-1703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16700393#comment-16700393 ]
jack commented on AIRFLOW-1703: ------------------------------- SQLite with local executor? This doesn't make a lot of sense > 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: 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)