初始化气流时出错。2.3.3 "Table 'airflow.ab_permission_id_seq' doesn't exist"

Question

刚刚安装apache-airflow 2.3.3，并设置了airflow.cfg指向mysql

sql_alchemy_conn = mysql://airflow:airflow@<<apphost>>:<<port>>/airflow

气流DB检查成功

>airflow db check
{db.py:1605} INFO - Connection successful.

当db初始化低于

时

>airflow db init
_mysql.connection.query(self, query)
sqlalchemy.exc.StatementError: (sqlalchemy.exc.ProgrammingError) (MySQLdb.ProgrammingError) (1146, "Table 'airflow.ab_permission_id_seq' doesn't exist")
[SQL: INSERT INTO ab_permission (id, name) VALUES (%s, %s)]
[parameters: [{'name': 'can_read'}]]

我已经指出mysql数据库，但仍然在db初始化期间试图执行一个序列并在初始化中失败。

请帮

Answer 1

您可能使用的是MariaDB，它不是由气流正式支持的。支持的db列表:https://airflow.apache.org/docs/apache-airflow/stable/installation/prerequisites.html?highlight=mariadb

关于MariaDB的官方声明:https://github.com/apache/airflow/issues/24247