← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1307266] Re: db util drop_unique_constraint doesn't work for sqlite

 

*** This bug is a duplicate of bug 1280055 ***
    https://bugs.launchpad.net/bugs/1280055

Victor, thanks, I've abandoned my oslo-incubator change and marked this
as a bug for nova, I'll probably make that change here:

https://review.openstack.org/#/c/79070/

** Changed in: oslo
       Status: In Progress => Invalid

** Also affects: nova
   Importance: Undecided
       Status: New

** This bug has been marked a duplicate of bug 1280055
   Replace nova.db.sqlalchemy.utils with openstack.common.db.sqlalchemy.utils

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1307266

Title:
  db util drop_unique_constraint doesn't work for sqlite

Status in OpenStack Compute (Nova):
  New
Status in Oslo - a Library of Common OpenStack Code:
  Invalid

Bug description:
  This patch adds the drop_unique_constraint db utility to oslo-
  incubator and says it comes from nova:

  https://review.openstack.org/#/c/37439/

  But that's not the same code that's in nova.db.sqlalchemy.utils:

  https://github.com/openstack/nova/blob/stable/havana/nova/db/sqlalchemy/utils.py#L168

  The version in nova handles sqlite differently by recreating the table
  since sqlite doesn't support 'alter table drop constraint' calls, as
  shown in this nova patch here using the oslo db utility:

  http://logs.openstack.org/47/69047/19/check/gate-nova-
  python27/ed044cc/testr_results.html.gz

  So the oslo-incubator version needs to be synced up with the latest
  version in nova.

  This is also going to block on my change to nova to remove the
  duplicate code from nova that's in oslo's db utils:

  https://review.openstack.org/#/c/79070/

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1307266/+subscriptions