[openstack-dev] [neutron] alembic migration not working? specifically in regards to ml2_port_bindings table

Paul Ward wpward at us.ibm.com
Tue Apr 8 20:41:33 UTC 2014



Is anyone else out there seeing failures that appear to be because alembic
is not upgrading db tables in neutron?  I'm seeing, on an upgrade, that
ml2_port_bindings is not being updated to remove column cap_port_filter or
add columns vnic_type, profile, or vif_details,  I'm also seeing the
subnets table not getting updated with the ipv6_ra_mode column.

I'm not intimately familiar with alembic so I'm not really sure what is
supposed to kick off the upgrade/downgrade or if the following revision
chains are ok.  Does merely starting neutron-server initiate the upgrade?
In perusing some of the ml2_port_bindings alembic files, I came up with
these revision chains:

32a65f71af51  (where ml2_port_bindings was first created)
^
14f24494ca31  (this is creating some arista tables... I don't know why it's
a down_revision for ml2_port_bindings table creation above)



157a5d299379  (adds profile column to ml2_port_bindings table....
apparently not called in my environment's upgrade)
^
50d5ba354c23  (adds vif_details column to ml2_port_bindings table and
removes cap_port_filter colume from ml2_port_bindings table.... apparently
not called in my environment's upgrade)
^
27cc183af192  (first file to add a column, vnic_type,  to
ml2_port_bindings.... apparently not called in my environment's upgrade)
^
4ca36cfc898c  (creates table neutron_nsx_router_mappings... don't see how
this is related to ml2_port_bindings other than similar foreign key
constraints)

Notice the chains do not connect with each other.  It seems to me that
27cc183af192 should actually call out 32a65f71af51 as the down_revision as
32a65f71af51 is where the ml2_port_bindings table was first created.
4ca36cfc898c just deals with the neutron_nsx_router_mappings table... I
don't see how that's related to ml2_port_bindings table other than having
some similar foreign key constraints.

Thanks in advance!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20140408/0dfefe11/attachment.html>


More information about the OpenStack-dev mailing list