airflow踩坑记录

最新推荐文章于 2022-01-04 23:59:32 发布

joninie_一只肉圆

最新推荐文章于 2022-01-04 23:59:32 发布

阅读量2.2k

点赞数

分类专栏：使用总结

本文链接：https://blog.csdn.net/weixin_42130167/article/details/95218555

版权

在初始化Airflow后，尝试将数据库从SQLite切换到PostgreSQL时遇到问题，错误提示仍然指向SQLite。解决方法包括删除默认的airflow.cfg文件，更新自定义配置文件路径，并设置AIRFLOW_HOME环境变量。最终通过修改unittests.cfg文件实现配置生效。

摘要由CSDN通过智能技术生成

参考链接：https://www.cnblogs.com/jimtheman/p/8465754.html

1、初始化airflow后，链接数据库改为postgresql，但是测试task时总是报错：

(env) ××@pc:~/workspace/airflow$ airflow test example_bash_operator run_after_loop 2019-07-06
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: task_instance [SQL: u'SELECT task_instance.try_number AS task_instance_try_number, task_instance.task_id AS task_instance_task_id, task_instance.dag_id AS task_instance_dag_id, task_instance.execution_date AS task_instance_execution_date, task_instance.start_date AS task_instance_start_date, task_instance.end_date AS task_instance_end_date, task_instance.duration AS task_instance_duration, task_instance.state AS task_instance_state, task_instance.max_tries AS task_instance_max_tries, task_instance.hostname AS task_instance_hostname, task_instance.unixname AS task_instanc