GitHub user bufubaoni added a comment to the discussion: Airflow scheduler crashes with a psycopg2.errors.GroupingError due to an incorrect SQL query when detecting orphaned datasets
I think you might be encountering the same issue as I did, but I've identified the root cause. It turns out that incorrect indexes on the dataset table can lead to this query error. You can check the indexes on the dataset table by running the command \d+ dataset in the Airflow database. I suspect that during the data migration, only the data was restored, and the table indexes were not correctly migrated, which led to this issue. FYI @q121212 GitHub link: https://github.com/apache/airflow/discussions/51886#discussioncomment-13509587 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
