arjunanan6 commented on issue #31184:
URL: https://github.com/apache/airflow/issues/31184#issuecomment-1562883547

   @ephraimbuddy I have some updates on this. I think I might have misled you 
here to begin with because the DAG(s) aren't deleted. Just some tags are 
deleted.
   
   On one of our dev environments, we have just about 10 DAGs, and the dag_tag 
table had 18 rows. I took a backup of it and truncated the dag_tag table, which 
was almost instantly refilled (I guess logs are DEBUG level on that, so I saw 
nothing). This did not initially fix the sorting problem, but after a couple of 
truncates, things got weird, and all the tags were sorted as expected, and the 
row count in the dag_tag table was now just 15, so 3 rows were removed in all. 
We also added a new DAG in there with a tag "arjun", which also got listed 
first - so all sorted on that environment.
   
   Unfortunately, on our other environment with about 160 DAGs, there is no 
difference after attempting the above process barring the fact that the row 
count is reduced. We started off with 431 tags in the dag_tag table, now 
reduced to 307 after a truncate and automatic "refill". I've attempted to 
truncate the table a couple of times, and after a few minutes, it has the 307 
rows - which look correct. The only problem remaining is that the tags are 
still not sorted in the Filter DAGs by tag.
   
   


-- 
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]

Reply via email to