Open Stack

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 at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20140409/a6a8c537/attachment.html>