fbertos commented on PR #19842:
URL: https://github.com/apache/airflow/pull/19842#issuecomment-2120101929
Dear all,
Looks like this is happening again as we are receiving the following
messages after upgrading to version Airflow 2.9.1 (we are using PostgreSQL
15.7.0):
2024-05-20 09:51:48.336 GMT [122] ERROR: could not obtain lock on row in
relation "dag_run"
2024-05-20 09:51:48.336 GMT [122] STATEMENT: SELECT dag_run.state AS
dag_run_state, dag_run.id AS dag_run_id, dag_run.dag_id AS dag_run_dag_id,
dag_run.queued_at AS dag_run_queued_at, dag_run.execution_date AS
dag_run_execution_date, dag_run.start_date AS dag_run_start_date,
dag_run.end_date AS dag_run_end_date, dag_run.run_id AS dag_run_run_id,
dag_run.creating_job_id AS dag_run_creating_job_id, dag_run.external_trigger AS
dag_run_external_trigger, dag_run.run_type AS dag_run_run_type, dag_run.conf AS
dag_run_conf, dag_run.data_interval_start AS dag_run_data_interval_start,
dag_run.data_interval_end AS dag_run_data_interval_end,
dag_run.last_scheduling_decision AS dag_run_last_scheduling_decision,
dag_run.dag_hash AS dag_run_dag_hash, dag_run.log_template_id AS
dag_run_log_template_id, dag_run.updated_at AS dag_run_updated_at,
dag_run.clear_number AS dag_run_clear_number
FROM dag_run
WHERE dag_run.dag_id = '******' AND dag_run.run_id =
'scheduled__2024-05-20T09:47:00+00:00' FOR UPDATE NOWAIT
Could anyone confirm if this issue is back for anybody else?
Thank you in advance!!!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
