You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "shahar1 (via GitHub)" <gi...@apache.org> on 2026/07/27 05:03:14 UTC
[PR] Breeze: Make postgres driver explicit in sql_alchemy_conn to silence FutureWarning [airflow]
shahar1 opened a new pull request, #70496:
URL: https://github.com/apache/airflow/pull/70496
Since #68314, the bare `postgresql://` scheme in `[database] sql_alchemy_conn` emits a `FutureWarning` at config load. Breeze's own `backend-postgres.yml` still used it, so every Breeze session with the postgres backend warned about it. Use `postgresql+psycopg://` explicitly, matching the celery result backend URL in the same file.
---
##### Was generative AI tooling used to co-author this PR?
- [X] Yes — Claude Code (Fable 5)
Generated-by: Claude Code (Fable 5) following [the guidelines](https://github.com/apache/airflow/blob/main/contributing-docs/05_pull_requests.rst#gen-ai-assisted-contributions)
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] Breeze: Make postgres driver explicit in sql_alchemy_conn to silence FutureWarning [airflow]
Posted by "potiuk (via GitHub)" <gi...@apache.org>.
potiuk commented on PR #70496:
URL: https://github.com/apache/airflow/pull/70496#issuecomment-5101614727
@Dev-iL - maybe you can take a look ?
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] Breeze: Make postgres driver explicit and version-aware [airflow]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #70496:
URL: https://github.com/apache/airflow/pull/70496#issuecomment-5123285507
### Backport failed to create: v3-3-test. View the failure log <a href='https://github.com/apache/airflow/actions/runs/30490248556'> Run details </a>
Note: As of [Merging PRs targeted for Airflow 3.X](https://github.com/apache/airflow/blob/main/dev/README_AIRFLOW3_DEV.md#merging-prs-targeted-for-airflow-3x)
the committer who merges the PR is responsible for backporting the PRs that are bug fixes (generally speaking) to the maintenance branches.
In matter of doubt please ask in [#release-management](https://apache-airflow.slack.com/archives/C03G9H97MM2) Slack channel.
<table>
<tr>
<th>Status</th>
<th>Branch</th>
<th>Result</th>
</tr>
<tr>
<td>❌</td>
<td>v3-3-test</td>
<td><a href="https://github.com/apache/airflow/commit/221da637bd2fe5da17e7c31df5fe751bc79ef53a"><img src='https://img.shields.io/badge/Commit-221da63-red' alt='Commit Link'></a></td>
</tr>
</table>
You can attempt to backport this manually by running:
```bash
cherry_picker 221da63 v3-3-test
```
This should apply the commit to the v3-3-test branch and leave the commit in conflict state marking
the files that need manual conflict resolution.
After you have resolved the conflicts, you can continue the backport process by running:
```bash
cherry_picker --continue
```
If you don't have cherry-picker installed, see the [installation guide](https://github.com/apache/airflow/blob/main/dev/README.md#how-to-backport-pr-with-cherry-picker-cli).
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] Breeze: Make postgres driver explicit in sql_alchemy_conn to silence FutureWarning [airflow]
Posted by "shahar1 (via GitHub)" <gi...@apache.org>.
shahar1 commented on PR #70496:
URL: https://github.com/apache/airflow/pull/70496#issuecomment-5106026053
> @shahar1 @potiuk merge?
I will merge, still investigating the root cause of the issue :)
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] Breeze: Make postgres driver explicit in sql_alchemy_conn to silence FutureWarning [airflow]
Posted by "Dev-iL (via GitHub)" <gi...@apache.org>.
Dev-iL commented on PR #70496:
URL: https://github.com/apache/airflow/pull/70496#issuecomment-5104111126
Ok so here's the deal:
- The warning fires on 2.11.0 which ships an older version of `airflow-core/src/airflow/configuration.py` that predates the psycopg v3 autodetection.
- It should be possible fix the old-airflow `breeze shell` invocations by specifying `--custom-db-url` as `"postgresql://postgres:airflow@postgres/airflow"`
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] Breeze: Make postgres driver explicit and version-aware [airflow]
Posted by "potiuk (via GitHub)" <gi...@apache.org>.
potiuk merged PR #70496:
URL: https://github.com/apache/airflow/pull/70496
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] Breeze: Make postgres driver explicit in sql_alchemy_conn to silence FutureWarning [airflow]
Posted by "Dev-iL (via GitHub)" <gi...@apache.org>.
Dev-iL commented on PR #70496:
URL: https://github.com/apache/airflow/pull/70496#issuecomment-5105895414
@shahar1 @potiuk merge?
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] Breeze: Make postgres driver explicit in sql_alchemy_conn to silence FutureWarning [airflow]
Posted by "potiuk (via GitHub)" <gi...@apache.org>.
potiuk commented on PR #70496:
URL: https://github.com/apache/airflow/pull/70496#issuecomment-5101609917
There are some errors to fix ?
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] Breeze: Make postgres driver explicit in sql_alchemy_conn to silence FutureWarning [airflow]
Posted by "Dev-iL (via GitHub)" <gi...@apache.org>.
Dev-iL commented on PR #70496:
URL: https://github.com/apache/airflow/pull/70496#issuecomment-5107853423
Huh, CI was green earlier
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] Breeze: Make postgres driver explicit in sql_alchemy_conn to silence FutureWarning [airflow]
Posted by "shahar1 (via GitHub)" <gi...@apache.org>.
shahar1 commented on PR #70496:
URL: https://github.com/apache/airflow/pull/70496#issuecomment-5108382043
> Huh, CI was green earlier
> Huh, CI was green earlier
Unrelated to this PR, main is currently broke. Trying to work on a fix :)
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] Breeze: Make postgres driver explicit in sql_alchemy_conn to silence FutureWarning [airflow]
Posted by "Dev-iL (via GitHub)" <gi...@apache.org>.
Dev-iL commented on PR #70496:
URL: https://github.com/apache/airflow/pull/70496#issuecomment-5104165115
In short:
```diff
diff --git a/.github/actions/migration_tests/action.yml b/.github/actions/migration_tests/action.yml
index f3e17b4..06cfc57 100644
--- a/.github/actions/migration_tests/action.yml
+++ b/.github/actions/migration_tests/action.yml
@@ -46,7 +46,11 @@ runs:
DB_RESET: "false"
DB_MANAGERS: "airflow.providers.fab.auth_manager.models.db.FABDBManager"
PYTHON_VERSION: "${{ inputs.python-version }}"
AIRFLOW_2_CMD: >-
+ export AIRFLOW__DATABASE__SQL_ALCHEMY_CONN=postgresql://postgres:airflow@postgres/airflow &&
airflow db reset --skip-init -y &&
airflow db migrate --to-revision heads
AIRFLOW_3_CMD: >-
@@ -80,7 +84,9 @@ runs:
DB_RESET: "false"
DB_MANAGERS: "airflow.providers.fab.auth_manager.models.db.FABDBManager"
PYTHON_VERSION: "${{ inputs.python-version }}"
AIRFLOW_2_CMD: >-
+ export AIRFLOW__DATABASE__SQL_ALCHEMY_CONN=postgresql://postgres:airflow@postgres/airflow &&
airflow db reset -y
AIRFLOW_3_CMD: >-
airflow db migrate --to-revision heads &&
```
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org