raphaelauv opened a new issue, #38176:
URL: https://github.com/apache/airflow/issues/38176
### Apache Airflow version
2.8.3
### If "Other Airflow 2 version" selected, which one?
_No response_
### What happened?
I want run multiple dag_run with the same execution date but it fail with
```log
sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate
key value violates unique constraint "dag_run_dag_id_execution_date_key"
DETAIL: Key (dag_id, execution_date)=(test_a, 2024-03-01 00:00:00+00)
already exists.
```
### What you think should happen instead?
_No response_
### How to reproduce
```python
from airflow.operators.python import PythonOperator
from airflow.operators.trigger_dagrun import TriggerDagRunOperator
from pendulum import today
from airflow import DAG
dag = DAG(
dag_id="test_a",
schedule_interval=None,
start_date=today("UTC").add(days=-1000)
)
with dag:
def toto(arg_1):
print(arg_1)
task_2 = PythonOperator(
task_id="task-two",
python_callable=toto,
op_kwargs={"arg_1": "1"})
dag = DAG(
dag_id="test_b",
schedule_interval=None,
start_date=today("UTC").add(days=-1)
)
with dag:
TriggerDagRunOperator.partial(
task_id="aaa",
trigger_dag_id="test_a",
reset_dag_run=True,
wait_for_completion=True,
deferrable=True
).expand_kwargs(
[{"execution_date": x, "trigger_run_id": y} for x, y in
[("2024-03-01", "NAME_a"), ("2024-03-01", "NAME_b")]])
```
### Operating System
ubuntu 22.04
### Versions of Apache Airflow Providers
_No response_
### Deployment
Docker-Compose
### 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]
