[
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)
