hket-ianchu opened a new issue, #56192:
URL: https://github.com/apache/airflow/issues/56192
### Apache Airflow version
3.1.0
### If "Other Airflow 2 version" selected, which one?
_No response_
### What happened?
Below command is used to clean up the recent records within 1 month
```airflow db clean --clean-before-timestamp "$(date -d "30 days ago"
+%Y-%m-%dT%H:%M)" --skip-archive --yes```
The error
```
Checking table dag_version
Found 155 rows meeting deletion criteria.
Performing Delete...
Moving data to table _airflow_deleted__dag_version__20250929024208
self.dialect.do_execute(
File
"/home/airflow/.local/lib/python3.12/site-packages/sqlalchemy/engine/default.py",
line 736, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.ForeignKeyViolation: update or delete on table "dag_version"
violates foreign key constraint "task_instance_dag_version_id_fkey" on table
"task_instance"
DETAIL: Key (id)=(0198edf9-f9f1-7d73-92c1-fac5359c10b7) is still referenced
from table "task_instance".
```
For the DAG Version ID `0198edf9-f9f1-7d73-92c1-fac5359c10b7`, I found :-
- 1 record in `dag_version` with `last_updated` = 2025-08-28 (more than 1
month ago, should be scoped)
- some records in `task_instance` with `updated_at` = 2025-09-02 (less than
1 month ago, should be not scoped)
Seem I can workaround by retrying it after 2025-10-02 so all mentioned
records will be scoped to remove.
### What you think should happen instead?
It should skip the problematic records / tables, or aggressively remove the
referencing records as well.
### How to reproduce
n/a
### Operating System
AlmaLinux release 9.6 (Sage Margay)
### Versions of Apache Airflow Providers
_No response_
### Deployment
Official Apache Airflow Helm Chart
### 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]
