Skip to content

Failed queries in Postgres Logs #72020

Closed

Description

@alkismavridis

Under which category would you file this issue?

Airflow Core

Apache Airflow version

3.3.0

What happened and how to reproduce it?

I run airflow under docker. When I docker-logs my postgres container I see the following error message repeated every second:

2026-08-24 03:15:04.534 UTC [888555] STATEMENT:  SELECT count(*) AS count_1 
	FROM (SELECT base.* 
	FROM task_reschedule AS base 
	WHERE base.start_date < '2026-08-09T05:15:00+02:00'::timestamptz AND base.dag_id IN ('my', 'dag', 'ids', 'go', 'here')) AS anon_1
2026-08-24 03:15:10.822 UTC [888573] ERROR:  column base.dag_id does not exist at character 145
2026-08-24 03:15:10.822 UTC [888573] HINT:  Perhaps you meant to reference the column "base.dagrun_id".

Not sure which part of airflow generates this query what is the impact of this, but seems like a schema error. I though it is worth reporting.

What you think should happen instead?

No response

Operating System

No response

Deployment

Docker-Compose

Apache Airflow Provider(s)

No response

Versions of Apache Airflow Providers

No response

Official Helm Chart version

Not Applicable

Kubernetes Version

No response

Helm Chart configuration

No response

Docker Image customizations

Nothing special

Anything else?

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

Activity

  1. shahar1 commented on Nov 6, 2026

    @shahar1
    Contributor

    Solved by #73173

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    area:MetaDBMeta Database related issues.area:corekind:bugThis is a clearly a bugneeds-triagelabel for new issues that we didn't triage yet

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions