[Solved] airflow Failed validating 'additionalProperties' in schema

🔥 Problem

👉 airflow Failed validating 'additionalProperties' in schema

`DB: sqlite:////Users/p/airflow/airflow.db
[2021-08-06 11:47:52,921] {db.py:678} INFO - Creating tables
/Users/p/opt/anaconda3/envs/airflow/lib/python3.8/site-packages/airflow/utils/db.py:613 SAWarning: relationship 'DagRun.serialized_dag' will copy column serialized_dag.dag_id to column dag_run.dag_id, which conflicts with relationship(s): 'DagRun.task_instances' (copies task_instance.dag_id to dag_run.dag_id), 'TaskInstance.dag_run' (copies task_instance.dag_id to dag_run.dag_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards. To silence this warning, add the parameter 'overlaps="dag_run,task_instances"' to the 'DagRun.serialized_dag' relationship.
/Users/p/opt/anaconda3/envs/airflow/lib/python3.8/site-packages/airflow/utils/db.py:613 SAWarning: relationship 'SerializedDagModel.dag_runs' will copy column serialized_dag.dag_id to column dag_run.dag_id, which conflicts with relationship(s): 'DagRun.task_instances' (copies task_instance.dag_id to dag_run.dag_id), 'TaskInstance.dag_run' (copies task_instance.dag_id to dag_run.dag_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards. To silence this warning, add the parameter 'overlaps="dag_run,task_instances"' to the 'SerializedDagModel.dag_runs' relationship.
INFO [alembic.runtime.migration] Context impl SQLiteImpl.
INFO [alembic.runtime.migration] Will assume non-transactional DDL.
Traceback (most recent call last):
File "/Users/p/opt/anaconda3/envs/airflow/bin/airflow", line 8, in
sys.exit(main())

☔ Cause of error

👉 To install Airflow, you should use a constraint file

🧙 Solution

👉 Please run the following commands on Linux Terminal

pip3 install apache-airflow[postgres,google]==2.1.2 \
 --constraint "https://raw.githubusercontent.com/apache/airflow/constraints-2.1.2/constraints-3.7.txt"

 

If I was of any help to you, please buy me coffee 😿😢😥

If you have any questions, please leave them in the comments

Buy me a coffee

▶ Youtube Sub

🧭 References

[1] reference : https://github.com/apache/airflow/discussions/17467

[2] Ads : https://play.google.com/store/apps/details?id=io.cordova.seoulfilter