启动Airflow Web服务器失败,sqlalchemy.exc.NoInspectionAvailable:没有可用



安装完成。数据库已正确启动,并且尝试启动Web服务器时显示以下错误。

我重新安装了所有东西,但仍然不起作用。

如果有人帮助我,我将不胜感激。

控制台输出:

$:~/airflow# airflow webserver -p 8080
____________       _____________
____    |__( )_________  __/__  /________      __
____  /| |_  /__  ___/_  /_ __  /_  __ _ | /| / /
___  ___ |  / _  /   _  __/ _  / / /_/ /_ |/ |/ /
_/_/  |_/_/  /_/    /_/    /_/  ____/____/|__/
[2020-04-08 13:14:20,573] {__init__.py:51} INFO - Using executor SequentialExecutor
[2020-04-08 13:14:20,574] {dagbag.py:403} INFO - Filling up the DagBag from /home/cato_service/airflow/dags
Traceback (most recent call last):
File "/usr/local/bin/airflow", line 37, in <module>
args.func(args)
File "/usr/local/lib/python3.6/dist-packages/airflow/utils/cli.py", line 75, in wrapper
return f(*args, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/airflow/bin/cli.py", line 900, in webserver
app = cached_app_rbac(None) if settings.RBAC else cached_app(None)
File "/usr/local/lib/python3.6/dist-packages/airflow/www/app.py", line 233, in cached_app
app = create_app(config, testing)
File "/usr/local/lib/python3.6/dist-packages/airflow/www/app.py", line 103, in create_app
models.Chart, Session, name="Charts", category="Data Profiling"))
File "/usr/local/lib/python3.6/dist-packages/flask_admin/contrib/sqla/view.py", line 330, in __init__
menu_icon_value=menu_icon_value)
File "/usr/local/lib/python3.6/dist-packages/flask_admin/model/base.py", line 818, in __init__
self._refresh_cache()
File "/usr/local/lib/python3.6/dist-packages/flask_admin/model/base.py", line 913, in _refresh_cache
self._search_supported = self.init_search()
File "/usr/local/lib/python3.6/dist-packages/flask_admin/contrib/sqla/view.py", line 581, in init_search
if tools.is_hybrid_property(self.model, name):
File "/usr/local/lib/python3.6/dist-packages/flask_admin/contrib/sqla/tools.py", line 209, in is_hybrid_property
return last_name in get_hybrid_properties(last_model)
File "/usr/local/lib/python3.6/dist-packages/flask_admin/contrib/sqla/tools.py", line 190, in get_hybrid_properties
for key, prop in inspect(model).all_orm_descriptors.items()
File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/inspection.py", line 72, in inspect
"available for object of type %s" % type_
sqlalchemy.exc.NoInspectionAvailable: No inspection system is available for object of type <class 'method'>

我自己动手吧。这是SQLAlchemy依赖的问题

为了修复,我做了以下操作:

pip3 uninstall SQLAlchemy
pip3 install SQLAlchemy==1.3.15

https://github.com/apache/airflow/issues/8211

在Dockerfile中包含指令pip install SQLAlchemy==1.3.15并重建映像就解决了这个问题。非常感谢@Java Guy!

我遇到了上述问题。我在Dockerfile中添加了以下行

&& pip install SQLAlchemy==1.3.15

将docker图像构建为

docker build --rm -t <tag> .

运行:

docker run -d -p 8080:8080 <tag>

相关内容

  • 没有找到相关文章

最新更新