havana icehouse neutron db migration

asked 2014-07-18 04:24:39 -0600

foexle gravatar image

Hi guys,

i'm testing upgrade from Havana to Icehouse. I've read all Release Notes and the Upgrade hints and in addition the upgrade doc but i get every time a db migration error:

neutron-db-manage --config-file /etc/neutron/neutron.conf   --config-file /etc/neutron/plugins/ml2/ml2_conf.ini upgrade icehouse
No handlers could be found for logger "neutron.common.legacy"
INFO  [alembic.migration] Context impl PostgresqlImpl.
INFO  [alembic.migration] Will assume transactional DDL.
INFO  [alembic.migration] Running upgrade havana -> e197124d4b9, add unique constraint to members
INFO  [alembic.migration] Running upgrade e197124d4b9 -> 1fcfc149aca4, Add a unique constraint on (agent_type, host) columns to prevent a race
condition when an agent entry is 'upserted'.
INFO  [alembic.migration] Running upgrade 1fcfc149aca4 -> 50e86cb2637a, nsx_mappings
INFO  [alembic.migration] Running upgrade 50e86cb2637a -> ed93525fd003, bigswitch_quota
INFO  [alembic.migration] Running upgrade ed93525fd003 -> 8f682276ee4, ryu plugin quota
INFO  [alembic.migration] Running upgrade 8f682276ee4 -> 1421183d533f, NSX DHCP/metadata support
INFO  [alembic.migration] Running upgrade 1421183d533f -> 3d3cb89d84ee, nsx_switch_mappings
INFO  [alembic.migration] Running upgrade 3d3cb89d84ee -> 4ca36cfc898c, nsx_router_mappings
INFO  [alembic.migration] Running upgrade 4ca36cfc898c -> 27cc183af192, ml2_vnic_type
INFO  [alembic.migration] Running upgrade 27cc183af192 -> 50d5ba354c23, ml2 binding:vif_details
Traceback (most recent call last):
  File "/usr/bin/neutron-db-manage", line 10, in <module>

sqlalchemy.exc.ProgrammingError: (ProgrammingError) column "cap_port_filter" does not exist
LINE 1: ...s SET vif_details = '{"port_filter": true}' WHERE cap_port_f...

What's wrong ? I'm using the official cloud-archive packages of Ubuntu. I tried to run again with a fresh database, but i get the same error. Is there any solution ?

Cheers and Thanks Heiko

edit retag flag offensive close merge delete


I've add these column manually with

ALTER TABLE ml2_port_bindings ADD COLUMN cap_port_filter BOOLEAN DEFAULT 'false' NOT NULL;

but what's happend ? Why is these not present ?

foexle gravatar imagefoexle ( 2014-07-18 04:35:32 -0600 )edit