python-3.6 - AttributeError：模块“pgdb”没有属性“paramstyle”

Question

出现以下错误：AttributeError：模块“pgdb”在气流网络服务器中没有属性“paramstyle”。使用气流：2.1.2 和 python：3.6

日志

Traceback (most recent call last):
File "/home/airflow/.local/bin/airflow", line 5, in <module>
from airflow.__main__ import main
File "/home/airflow/.local/lib/python3.6/site-packages/airflow/__init__.py", line 46, in <module>
settings.initialize()
File "/home/airflow/.local/lib/python3.6/site-packages/airflow/settings.py", line 447, in initialize
configure_orm()
File "/home/airflow/.local/lib/python3.6/site-packages/airflow/settings.py", line 222, in configure_orm
engine = create_engine(SQL_ALCHEMY_CONN, connect_args=connect_args, **engine_args)
File "/home/airflow/.local/lib/python3.6/site-packages/sqlalchemy/engine/__init__.py", line 525, in create_engine
return strategy.create(*args, **kwargs)
File "/home/airflow/.local/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py", line 95, in create
dialect = dialect_cls(**dialect_args)
File "/home/airflow/.local/lib/python3.6/site-packages/sqlalchemy/dialects/postgresql/pygresql.py", line 215, in __init__
super(PGDialect_pygresql, self).__init__(**kwargs)
File "/home/airflow/.local/lib/python3.6/site-packages/sqlalchemy/dialects/postgresql/base.py", line 2648, in __init__
default.DefaultDialect.__init__(self, **kwargs)
File "<string>", line 2, in __init__
File "/home/airflow/.local/lib/python3.6/site-packages/sqlalchemy/util/deprecations.py", line 139, in warned
return fn(*args, **kwargs)
File "/home/airflow/.local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 234, in __init__
self.paramstyle = self.dbapi.paramstyle
AttributeError: module 'pgdb' has no attribute 'paramstyle'
+ airflow initdb
WARNING: You are using pip version 21.1.2; however, version 21.2.4 is available.
You should consider upgrading via the '/usr/local/bin/python3 -m pip install --upgrade pip' command.
Successfully installed pgdb-0.0.Installing collected packages: pgdb
Successfully built pgdb
Created wheel for pgdb: filename=pgdb-0.0.11-py3-none-any.whl size=2800 sha256=17fb8b3a0a7b13827e3c9738c6502afa3c68cd37c9189fdb76e59fa5f90fdeStored in directory: /home/airflow/.cache/pip/wheels/8d/c9/61/d91992b717c1bb3e8eaa5871c86833e1dedfe8ff6f8c911aBuilding wheel for pgdb (setup.py): finished with status 'done'
Building wheel for pgdb (setup.py): started
Building wheels for collected packages: pgdb
Requirement already satisfied: psycopg2-binary>=2.8.2 in /home/airflow/.local/lib/python3.6/site-packages (from pgdb) (2.9.1)
Downloading pgdb-0.0.11.tar.gz (2.7 kB)
Collecting pgdb
+ python3 -m pip install pgdb

标签： python-3.6airflow-2.x