[
https://issues.apache.org/jira/browse/AIRFLOW-1703?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ash Berlin-Taylor resolved AIRFLOW-1703.
----------------------------------------
Resolution: Fixed
That was possibly the problem, and we now don't allow sqlite with anything
other than the Sequential Executor.
> 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)
