External DAG processor not working

[allebacco]

Apache Airflow version

2.3.0 (latest released)

What happened

Running a standalone Dag Processor instance with airflow dag-processor throws the following exception:

Standalone DagProcessor is not supported when using sqlite.

What you think should happen instead

The airflow dag-processor should start without an exception in case of Postgres database

How to reproduce

The error is in the following line:

airflow/airflow/cli/commands/dag_processor_command.py

Line 53 in 6f146e7

sql_conn: str = conf.get('core', 'sql_alchemy_conn').lower()

It should be

sql_conn: str = conf.get('database', 'sql_alchemy_conn').lower() 

due to the change in the configuration file done in #22284

Operating System

Ubuntu 20.04

Versions of Apache Airflow Providers

No response

Deployment

Virtualenv installation

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

• I agree to follow this project's Code of Conduct

[boring-cyborg]

Thanks for opening your first issue here! Be sure to follow the issue template!

[eladkal]

Duplicate of #23408

[allebacco]

@eladkal are you sure that thias issue is a duplicate? In this case I am not using AIRFLOW__CORE__SQL_ALCHEMY_CONN_CMD.

The line mentioned in the description of the issue is reading the sql alchemy connection string from the core section instead of the database one. Maybe I am missing some detail of the configuration mechanism.

[potiuk]

@mhenc - can you take a look please?

[tirkarthi]

I guess this can be closed now with #23575 merged .

[potiuk]

Indeed.