[Bug 1633576] [NEW] neutron-db-manage fails when old migrations are present

[Jon Proulx]

Public bug reported:

Ubuntu 14.04 using cloud-archive packages upgrading from kilo to liberty
python-neutron:
  Installed: 2:8.2.0-0ubuntu1~cloud0
  500 http://ubuntu-cloud.archive.canonical.com/ubuntu/ trusty-updates/mitaka/main amd64 Packages

neutron db migration error in prod kilo->liberty upgrade:

# neutron-db-manage upgrade head

/usr/lib/python2.7/dist-packages/alembic/util/messaging.py:69: UserWarning: Revision havana referenced from havana -> 1cbdb560f806 (head), empty message is not present
<snip details at http://pastebin.com/D8Pdsvn9 >
KeyError: 'havana'

packages are additive so system had migrations for 'havana' in
/usr/lib/python2.7/dist-packages/neutron/db/migration/alembic_migrations
but current neutron-db-manage doesn't know about 'havana' so freaks out.

solution: 
rm -r /usr/lib/python2.7/dist-packages/neutron/db/migration/alembic_migrations
apt-get install --reinstall python-neutron

then migrations work as expected.

I feel like this is a packaging bug and old migrations should be removed
on upgrade.  I could also see this as an upstream bug where code should
at least remember historic version names, but choosing to report here
...

** Affects: neutron (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
OpenStack, which is subscribed to neutron in Ubuntu.
https://bugs.launchpad.net/bugs/1633576

Title:
  neutron-db-manage fails when old migrations are present

Status in neutron package in Ubuntu:
  New

Bug description:
  Ubuntu 14.04 using cloud-archive packages upgrading from kilo to liberty
  python-neutron:
    Installed: 2:8.2.0-0ubuntu1~cloud0
    500 http://ubuntu-cloud.archive.canonical.com/ubuntu/ trusty-updates/mitaka/main amd64 Packages

  neutron db migration error in prod kilo->liberty upgrade:

  # neutron-db-manage upgrade head

  /usr/lib/python2.7/dist-packages/alembic/util/messaging.py:69: UserWarning: Revision havana referenced from havana -> 1cbdb560f806 (head), empty message is not present
  <snip details at http://pastebin.com/D8Pdsvn9 >
  KeyError: 'havana'

  packages are additive so system had migrations for 'havana' in
  /usr/lib/python2.7/dist-
  packages/neutron/db/migration/alembic_migrations but current neutron-
  db-manage doesn't know about 'havana' so freaks out.

  solution: 
  rm -r /usr/lib/python2.7/dist-packages/neutron/db/migration/alembic_migrations
  apt-get install --reinstall python-neutron

  then migrations work as expected.

  I feel like this is a packaging bug and old migrations should be
  removed on upgrade.  I could also see this as an upstream bug where
  code should at least remember historic version names, but choosing to
  report here ...

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/neutron/+bug/1633576/+subscriptions