oslo.db

"create/drop_named_database" fail with SQLAlchemy 2.0

Bug #2015225 reported by Rodolfo Alonso
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
oslo.db
Fix Released
High
Stephen Finucane

Bug Description

This error was found in the Neutron CI: https://8224a02f6279ed506e3a-6176f3344d2541229da3be8329641f28.ssl.cf1.rackcdn.com/874778/5/experimental/neutron-functional-with-sqlalchemy-master/d1aa539/testr_results.html

Snippet: https://paste.opendev.org/show/bUEkv88d4t9Xsae3kDPi/

This error looks related (not caused) by [1]: now these methods start a transaction regardless of the connection status.

[1]https://review.opendev.org/c/openstack/oslo.db/+/802587

Revision history for this message
Rodolfo Alonso (rodolfo-alonso-hernandez) wrote :

It seems that when checking [1], it calls "database_exists" and initiates a transaction. The context created by "conn.beging()" should be before this call.

[1]https://github.com/openstack/oslo.db/blob/da4f13e7345653eba8aab5b8aceeaeff7367989e/oslo_db/sqlalchemy/provision.py#L519

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to oslo.db (master)

Fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/oslo.db/+/879445

Changed in oslo.db:
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on oslo.db (master)

Change abandoned by "Rodolfo Alonso <email address hidden>" on branch: master
Review: https://review.opendev.org/c/openstack/oslo.db/+/879445
Reason: Superseded by https://review.opendev.org/c/openstack/oslo.db/+/875986/12

Revision history for this message
Stephen Finucane (stephenfinucane) wrote :

Fixed by https://review.opendev.org/c/openstack/oslo.db/+/875986/12

Changed in oslo.db:
status: In Progress → Fix Released
importance: Undecided → High
assignee: nobody → Stephen Finucane (stephenfinucane)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.