[sqlalchemy-20] "test_has_alive_neutron_server" failing with SQLAlchemy 2.0

[Rodolfo Alonso]

Logs: https://27be34998be95aa1f8d7-93a8141b9f45324a3b85293f1fcfbf55.ssl.cf2.rackcdn.com/879743/7/check/cross-neutron-py310/8cc136d/testr_results.html

Error: https://paste.opendev.org/show/bG4Xv1wc1xXX0NgEBwEa/

[Rodolfo Alonso (rodolfo-alonso-hernandez)]

Patch: https://review.opendev.org/c/openstack/neutron/+/891691

[OpenStack Infra (hudson-openstack)]

Related fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/neutron/+/892134

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/neutron/+/891691
Committed: https://opendev.org/openstack/neutron/commit/429559826135df06eb348bc0de40e8b1f8955ee5
Submitter: "Zuul (22348)"
Branch: master

commit 429559826135df06eb348bc0de40e8b1f8955ee5
Author: Rodolfo Alonso Hernandez <email address hidden>
Date: Wed Aug 16 19:45:29 2023 +0000

    Use SQLAlchemy expression "select"

    The expresion "select 1;" can be replaced using the
    ``expression.select`` method.

    Closes-Bug: #2031646

    Change-Id: I7d82d5c399de5c3fb320f130a5c5f65abf147cbd

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/neutron/+/892134
Committed: https://opendev.org/openstack/neutron/commit/7848eb0bf925ae872012e08012e15fed9ab32af1
Submitter: "Zuul (22348)"
Branch: master

commit 7848eb0bf925ae872012e08012e15fed9ab32af1
Author: Rodolfo Alonso Hernandez <email address hidden>
Date: Mon Aug 21 11:04:59 2023 +0000

    Add "openstack-tox-py310-with-sqlalchemy-master" to check queue

    This job will help us during the SQLAlchemy 2.0 migration.

    Related-Bug: #2031646
    Change-Id: I53c339d8a55b6f1cebb411821478bf19da4b5cba

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/neutron 23.0.0.0b3 development milestone.