Hi,
Have you looked at
https://github.com/openstack/neutron/blob/master/neutron/db/migration/README
?
Itzik
On 08/04/2014 23:41, Paul Ward wrote:
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!
_______________________________________________
OpenStack-dev mailing list
OpenStack-dev@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
_______________________________________________
OpenStack-dev mailing list
OpenStack-dev@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
