yahoo-eng-team team mailing list archive

[Roman Podolyaka <rpodolyaka@xxxxxxxxxxxx>]

Sure, I'll make a patch for migrate soon.

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

-- 
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/1200265

Title:
  Monkey-patch SQLAlchemy-Migrate to fix unique constraints bugs in
  SQLite

Status in OpenStack Compute (Nova):
  Invalid

Bug description:
  Nova and other projects use SQLAlchemy-Migrate for DB schema
  migrations. Unfortunately, this project looks like to be dead, but
  have some important bugs which makes lives of OpenStack developers
  harder (e. g. creation of a new unique constraint in SQLite leads to
  deletion of all existing unique constraints).

  A monkey-patching util has been recently merged to Oslo (https://review.openstack.org/#/c/31016/). If it's used in Nova, it will allow us to:
  1) use the unified drop_unique_constraint() function for SQLite backend
  2) fix a bug in SQLAlchemy-Migrate that leads to deletion of existing unique constraints of a table when a new one is added  (SQLite backend)

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