The GitHub Actions job "Tests" on airflow.git has succeeded.
Run started by GitHub user ephraimbuddy (triggered by ephraimbuddy).

Head commit for run:
d836721c0e62cb75f34a96b0b0bd31bd4a61edf4 / Ephraim Anierobi 
<[email protected]>
Fix SQLALchemy warning about conflicting relationships

Running airflow commands print out warnings about conflicting relationships.

SAWarning: relationship 'DagRun.serialized_dag' will copy column 
serialized_dag.dag_id
 to column dag_run.dag_id, which conflicts with relationship(s): 
'RenderedTaskInstanceFields.dag_run'
 (copies rendered_task_instance_fields.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.   The 'overlaps' parameter 
may be used to remove
 this warning. (Background on this error at: http://sqlalche.me/e/14/qzyx)
/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/relationships.py:3463 
SAWarning:
relationship 'SerializedDagModel.dag_runs' will copy column 
serialized_dag.dag_id to
column dag_run.dag_id, which conflicts with relationship(s): 
'RenderedTaskInstanceFields.dag_run'
(copies rendered_task_instance_fields.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.   The 'overlaps' parameter may be 
used to remove this warning.
 (Background on this error at: http://sqlalche.me/e/14/qzyx)

Since the RenderedTaskInstanceFields.dag_run is only used in loading up the 
execution_date, we mark it as
viewonly which fixes the above warning

Report URL: https://github.com/apache/airflow/actions/runs/2103438384

With regards,
GitHub Actions via GitBox


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to