romanzdk opened a new issue, #60974: URL: https://github.com/apache/airflow/issues/60974
### Apache Airflow version Other Airflow 3 version (please specify below) ### If "Other Airflow 3 version" selected, which one? 3.1.5 ### What happened? When I manually trigger Dag run it works for the first attempt but when I want to run it again (e.g. with different config parameters) it does not work - it shows DB error - unique constraint: ``` 409 Conflict reason: Unique constraint violationstatement: INSERT INTO dag_run (dag_id, queued_at, logical_date, start_date, end_date, state, run_id, creating_job_id, run_type, triggered_by, triggering_user_name, conf, data_interval_start, data_interval_end, run_after, last_scheduling_decision, log_template_id, updated_at, clear_number, backfill_id, bundle_version, scheduled_by_job_id, context_carrier, created_dag_version_id) VALUES (%(dag_id)s, %(queued_at)s, %(logical_date)s, %(start_date)s, %(end_date)s, %(state)s, %(run_id)s, %(creating_job_id)s, %(run_type)s, %(triggered_by)s, %(triggering_user_name)s, %(conf)s::JSONB, %(data_interval_start)s, %(data_interval_end)s, %(run_after)s, %(last_scheduling_decision)s, %(log_template_id)s, %(updated_at)s, %(clear_number)s, %(backfill_id)s, %(bundle_version)s, %(scheduled_by_job_id)s, %(context_carrier)s::JSONB, %(created_dag_version_id)s::UUID) RETURNING dag_run.id, dag_run.span_statusorig_error: duplicate key value violates unique constraint "dag _run_dag_id_run_id_key" DETAIL: Key (dag_id, run_id)=(calendar-data, manual__2026-01-23T00:00:00+00:00) already exists. message: Serious error when handling your request. Check logs for more details - you will find it in api server when you look for ID jElXJa2Y ``` ### What you think should happen instead? It should create new manual dag run. ### How to reproduce Take any dag, click Trigger (Play) button in the top right corner, run it. Then do the same again. It shows an error. ### Operating System Debian ### Versions of Apache Airflow Providers _No response_ ### Deployment Other Docker-based deployment ### Deployment details _No response_ ### Anything else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md) -- 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]
