GitHub user prayaagmahajan created a discussion: Command airflow db clean is 
getting stuck while removing data from dag_version table

Hi, I am trying to run 

`airflow db clean --clean-before-timestamp 2026-01-19T11:51:59 --skip-archive 
--yes --tables 
asset_event,callback_request,celery_taskmeta,celery_tasksetmeta,dag,dag_run,deadline,import_error,job,log,sla_miss,task_instance,task_instance_history,task_reschedule,trigger,xcom`

but this command is getting stuck at 

`Checking table dag_version
Found 10349 rows meeting deletion criteria.
Performing Delete...
Moving data to table _airflow_deleted__dag_version__20260120123746`

with error `sqlalchemy.exc.InvalidRequestError: This session is in 'prepared' 
state; no further SQL can be emitted within this transaction.`

Seeking help with this issue.

GitHub link: https://github.com/apache/airflow/discussions/60822

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]

Reply via email to