<h3 dir="auto">Apache Airflow version</h3>
<p dir="auto">2.3.0 (latest released)</p>
<h3 dir="auto">What happened</h3>
<p dir="auto">Dag processor failed to start if <code class="notranslate">[core] sql_alchemy_conn</code> not defined</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="airflow-local-airflow-dag-processor-1  | [2022-05-08 16:42:35,835] {configuration.py:494} WARNING - section/key [core/sql_alchemy_conn] not found in config
airflow-local-airflow-dag-processor-1  | Traceback (most recent call last):
airflow-local-airflow-dag-processor-1  |   File &quot;/home/airflow/.local/bin/airflow&quot;, line 8, in &lt;module&gt;
airflow-local-airflow-dag-processor-1  |     sys.exit(main())
airflow-local-airflow-dag-processor-1  |   File &quot;/home/airflow/.local/lib/python3.9/site-packages/airflow/__main__.py&quot;, line 38, in main
airflow-local-airflow-dag-processor-1  |     args.func(args)
airflow-local-airflow-dag-processor-1  |   File &quot;/home/airflow/.local/lib/python3.9/site-packages/airflow/cli/cli_parser.py&quot;, line 51, in command
airflow-local-airflow-dag-processor-1  |     return func(*args, **kwargs)
airflow-local-airflow-dag-processor-1  |   File &quot;/home/airflow/.local/lib/python3.9/site-packages/airflow/utils/cli.py&quot;, line 99, in wrapper
airflow-local-airflow-dag-processor-1  |     return f(*args, **kwargs)
airflow-local-airflow-dag-processor-1  |   File &quot;/home/airflow/.local/lib/python3.9/site-packages/airflow/cli/commands/dag_processor_command.py&quot;, line 53, in dag_processor
airflow-local-airflow-dag-processor-1  |     sql_conn: str = conf.get('core', 'sql_alchemy_conn').lower()
airflow-local-airflow-dag-processor-1  |   File &quot;/home/airflow/.local/lib/python3.9/site-packages/airflow/configuration.py&quot;, line 486, in get
airflow-local-airflow-dag-processor-1  |     return self._get_option_from_default_config(section, key, **kwargs)
airflow-local-airflow-dag-processor-1  |   File &quot;/home/airflow/.local/lib/python3.9/site-packages/airflow/configuration.py&quot;, line 496, in _get_option_from_default_config
airflow-local-airflow-dag-processor-1  |     raise AirflowConfigException(f&quot;section/key [{section}/{key}] not found in config&quot;)
airflow-local-airflow-dag-processor-1  | airflow.exceptions.AirflowConfigException: section/key [core/sql_alchemy_conn] not found in config"><pre class="notranslate"><code class="notranslate">airflow-local-airflow-dag-processor-1  | [2022-05-08 16:42:35,835] {configuration.py:494} WARNING - section/key [core/sql_alchemy_conn] not found in config
airflow-local-airflow-dag-processor-1  | Traceback (most recent call last):
airflow-local-airflow-dag-processor-1  |   File "/home/airflow/.local/bin/airflow", line 8, in &lt;module&gt;
airflow-local-airflow-dag-processor-1  |     sys.exit(main())
airflow-local-airflow-dag-processor-1  |   File "/home/airflow/.local/lib/python3.9/site-packages/airflow/__main__.py", line 38, in main
airflow-local-airflow-dag-processor-1  |     args.func(args)
airflow-local-airflow-dag-processor-1  |   File "/home/airflow/.local/lib/python3.9/site-packages/airflow/cli/cli_parser.py", line 51, in command
airflow-local-airflow-dag-processor-1  |     return func(*args, **kwargs)
airflow-local-airflow-dag-processor-1  |   File "/home/airflow/.local/lib/python3.9/site-packages/airflow/utils/cli.py", line 99, in wrapper
airflow-local-airflow-dag-processor-1  |     return f(*args, **kwargs)
airflow-local-airflow-dag-processor-1  |   File "/home/airflow/.local/lib/python3.9/site-packages/airflow/cli/commands/dag_processor_command.py", line 53, in dag_processor
airflow-local-airflow-dag-processor-1  |     sql_conn: str = conf.get('core', 'sql_alchemy_conn').lower()
airflow-local-airflow-dag-processor-1  |   File "/home/airflow/.local/lib/python3.9/site-packages/airflow/configuration.py", line 486, in get
airflow-local-airflow-dag-processor-1  |     return self._get_option_from_default_config(section, key, **kwargs)
airflow-local-airflow-dag-processor-1  |   File "/home/airflow/.local/lib/python3.9/site-packages/airflow/configuration.py", line 496, in _get_option_from_default_config
airflow-local-airflow-dag-processor-1  |     raise AirflowConfigException(f"section/key [{section}/{key}] not found in config")
airflow-local-airflow-dag-processor-1  | airflow.exceptions.AirflowConfigException: section/key [core/sql_alchemy_conn] not found in config
</code></pre></div>
<h3 dir="auto">What you think should happen instead</h3>
<p dir="auto">Since <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1169624280" data-permission-text="Title is private" data-url="https://github.com/apache/airflow/issues/22284" data-hovercard-type="pull_request" data-hovercard-url="/apache/airflow/pull/22284/hovercard" href="https://github.com/apache/airflow/pull/22284">#22284</a> <code class="notranslate">sql_alchemy_conn</code> moved to <code class="notranslate">[database]</code> section <code class="notranslate">dag-processor</code>  should use this configuration</p>
<h3 dir="auto">How to reproduce</h3>
<p dir="auto">Run <code class="notranslate">airflow dag-processor</code> without defined <code class="notranslate">[core] sql_alchemy_conn</code></p>
<p dir="auto"></p><div class="Box Box--condensed my-2">
  <div class="Box-header f6">
    <p class="mb-0 text-bold">
      <a href="https://github.com/apache/airflow/blob/6e5955831672c71bfc0424dd50c8e72f6fd5b2a7/airflow/cli/commands/dag_processor_command.py#L52-L53">airflow/airflow/cli/commands/dag_processor_command.py</a>
    </p>
    <p class="mb-0 color-fg-muted">
        Lines 52 to 53
      in
      <a data-pjax="true" class="commit-tease-sha" href="/apache/airflow/commit/6e5955831672c71bfc0424dd50c8e72f6fd5b2a7">6e59558</a>
    </p>
  </div>
  <div itemprop="text" class="Box-body p-0 blob-wrapper blob-wrapper-embedded data">
    <table class="highlight tab-size mb-0 js-file-line-container" data-tab-size="8" data-paste-markdown-skip="">

        <tbody><tr class="border-0">
          <td id="L52" class="blob-num border-0 px-3 py-0 color-bg-default" data-line-number="52"></td>
          <td id="LC52" class="blob-code border-0 px-3 py-0 color-bg-default blob-code-inner js-file-line">  </td>
        </tr>

        <tr class="border-0">
          <td id="L53" class="blob-num border-0 px-3 py-0 color-bg-default" data-line-number="53"></td>
          <td id="LC53" class="blob-code border-0 px-3 py-0 color-bg-default blob-code-inner js-file-line"> <span class="pl-s1">sql_conn</span>: <span class="pl-s1">str</span> <span class="pl-c1">=</span> <span class="pl-s1">conf</span>.<span class="pl-en">get</span>(<span class="pl-s">'core'</span>, <span class="pl-s">'sql_alchemy_conn'</span>).<span class="pl-en">lower</span>() </td>
        </tr>
    </tbody></table>
  </div>
</div>
<p></p>
<h3 dir="auto">Operating System</h3>
<p dir="auto">Arch Linux</p>
<h3 dir="auto">Versions of Apache Airflow Providers</h3>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="apache-airflow-providers-amazon==3.3.0
apache-airflow-providers-celery==2.1.4
apache-airflow-providers-cncf-kubernetes==4.0.1
apache-airflow-providers-docker==2.6.0
apache-airflow-providers-elasticsearch==3.0.3
apache-airflow-providers-ftp==2.1.2
apache-airflow-providers-google==6.8.0
apache-airflow-providers-grpc==2.0.4
apache-airflow-providers-hashicorp==2.2.0
apache-airflow-providers-http==2.1.2
apache-airflow-providers-imap==2.2.3
apache-airflow-providers-microsoft-azure==3.8.0
apache-airflow-providers-mysql==2.2.3
apache-airflow-providers-odbc==2.0.4
apache-airflow-providers-postgres==4.1.0
apache-airflow-providers-redis==2.0.4
apache-airflow-providers-sendgrid==2.0.4
apache-airflow-providers-sftp==2.6.0
apache-airflow-providers-slack==4.2.3
apache-airflow-providers-snowflake==2.6.0
apache-airflow-providers-sqlite==2.1.3
apache-airflow-providers-ssh==2.4.3"><pre class="notranslate"><code class="notranslate">apache-airflow-providers-amazon==3.3.0
apache-airflow-providers-celery==2.1.4
apache-airflow-providers-cncf-kubernetes==4.0.1
apache-airflow-providers-docker==2.6.0
apache-airflow-providers-elasticsearch==3.0.3
apache-airflow-providers-ftp==2.1.2
apache-airflow-providers-google==6.8.0
apache-airflow-providers-grpc==2.0.4
apache-airflow-providers-hashicorp==2.2.0
apache-airflow-providers-http==2.1.2
apache-airflow-providers-imap==2.2.3
apache-airflow-providers-microsoft-azure==3.8.0
apache-airflow-providers-mysql==2.2.3
apache-airflow-providers-odbc==2.0.4
apache-airflow-providers-postgres==4.1.0
apache-airflow-providers-redis==2.0.4
apache-airflow-providers-sendgrid==2.0.4
apache-airflow-providers-sftp==2.6.0
apache-airflow-providers-slack==4.2.3
apache-airflow-providers-snowflake==2.6.0
apache-airflow-providers-sqlite==2.1.3
apache-airflow-providers-ssh==2.4.3
</code></pre></div>
<h3 dir="auto">Deployment</h3>
<p dir="auto">Docker-Compose</p>
<h3 dir="auto">Deployment details</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">Anything else</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">Are you willing to submit PR?</h3>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> Yes I am willing to submit a PR!</li>
</ul>
<h3 dir="auto">Code of Conduct</h3>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> I agree to follow this project's <a href="https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md">Code of Conduct</a></li>
</ul>
<h3 dir="auto">Apache Airflow version</h3>
<p dir="auto">2.3.0 (latest released)</p>
<h3 dir="auto">What happened</h3>
<p dir="auto">Running a standalone Dag Processor instance with <code class="notranslate">airflow dag-processor</code> throws the following exception:</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="Standalone DagProcessor is not supported when using sqlite."><pre class="notranslate"><code class="notranslate">Standalone DagProcessor is not supported when using sqlite.
</code></pre></div>
<h3 dir="auto">What you think should happen instead</h3>
<p dir="auto">The <code class="notranslate">airflow dag-processor</code> should start without an exception in case of Postgres database</p>
<h3 dir="auto">How to reproduce</h3>
<p dir="auto">The error is in the following line: </p><div class="Box Box--condensed my-2">
  <div class="Box-header f6">
    <p class="mb-0 text-bold">
      <a href="https://github.com/apache/airflow/blob/6f146e721c81e9304bf7c0af66fc3d203d902dab/airflow/cli/commands/dag_processor_command.py#L53">airflow/airflow/cli/commands/dag_processor_command.py</a>
    </p>
    <p class="mb-0 color-fg-muted">
         Line 53
      in
      <a data-pjax="true" class="commit-tease-sha" href="/apache/airflow/commit/6f146e721c81e9304bf7c0af66fc3d203d902dab">6f146e7</a>
    </p>
  </div>
  <div itemprop="text" class="Box-body p-0 blob-wrapper blob-wrapper-embedded data">
    <table class="highlight tab-size mb-0 js-file-line-container" data-tab-size="8" data-paste-markdown-skip="">

        <tbody><tr class="border-0">
          <td id="L53" class="blob-num border-0 px-3 py-0 color-bg-default" data-line-number="53"></td>
          <td id="LC53" class="blob-code border-0 px-3 py-0 color-bg-default blob-code-inner js-file-line"> <span class="pl-s1">sql_conn</span>: <span class="pl-s1">str</span> <span class="pl-c1">=</span> <span class="pl-s1">conf</span>.<span class="pl-en">get</span>(<span class="pl-s">'core'</span>, <span class="pl-s">'sql_alchemy_conn'</span>).<span class="pl-en">lower</span>() </td>
        </tr>
    </tbody></table>
  </div>
</div>
<p></p>
<p dir="auto">It should be</p>
<div class="highlight highlight-source-python notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="sql_conn: str = conf.get('database', 'sql_alchemy_conn').lower() "><pre class="notranslate"><span class="pl-s1">sql_conn</span>: <span class="pl-s1">str</span> <span class="pl-c1">=</span> <span class="pl-s1">conf</span>.<span class="pl-en">get</span>(<span class="pl-s">'database'</span>, <span class="pl-s">'sql_alchemy_conn'</span>).<span class="pl-en">lower</span>() </pre></div>
<p dir="auto">due to the change in the configuration file done in <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1169624280" data-permission-text="Title is private" data-url="https://github.com/apache/airflow/issues/22284" data-hovercard-type="pull_request" data-hovercard-url="/apache/airflow/pull/22284/hovercard" href="https://github.com/apache/airflow/pull/22284">#22284</a></p>
<h3 dir="auto">Operating System</h3>
<p dir="auto">Ubuntu 20.04</p>
<h3 dir="auto">Versions of Apache Airflow Providers</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">Deployment</h3>
<p dir="auto">Virtualenv installation</p>
<h3 dir="auto">Deployment details</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">Anything else</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">Are you willing to submit PR?</h3>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox"> Yes I am willing to submit a PR!</li>
</ul>
<h3 dir="auto">Code of Conduct</h3>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> I agree to follow this project's <a href="https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md">Code of Conduct</a></li>
</ul>