[GitHub] [airflow] potiuk commented on issue #23453: airflow db upgrade: FOREIGN KEY constraint failed

[GitBox <gi...@apache.org>]

potiuk commented on issue #23453:
URL: https://github.com/apache/airflow/issues/23453#issuecomment-1379583329

   > Probably it should be reflected in the docs somewhere then.
   
   It is: https://airflow.apache.org/docs/apache-airflow/stable/howto/set-up-database.html 
   
   > SQLite database can be used to run Airflow for development purpose as it does not require any database server (the database is stored in a local file). There are many limitations of using the SQLite database (for example it only works with Sequential Executor) and it should NEVER be used for production.
   
   
   > This seems to be enough btw to make migrations work, just like the alembic [note](https://alembic.sqlalchemy.org/en/latest/batch.html#dealing-with-referencing-foreign-keys) linked by @Gollum999 says.
   batch_op.execute("PRAGMA foreign_keys = OFF;")
   
   By all means if you can make it works. PRs are most welcome. Airflow is created by > 2300 people who made aand becomeing contributor is cool, so if you think you can fix it this way - why don't you create a PR?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org