migration vs model mismatches

[YAMAMOTO Takashi]

======================================================================
FAIL: midonet.neutron.tests.unit.db.test_migrations.TestModelsMigrationsPostgresql.test_models_sync
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/oslo_db/sqlalchemy/test_migrations.py", line 615, in test_models_sync
    "Models and migration scripts aren't in sync:\n%s" % msg)
  File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/unittest2/case.py", line 690, in fail
    raise self.failureException(msg)
AssertionError: Models and migration scripts aren't in sync:
[ ( 'remove_table',
    Table('midonet_gateway_overlay_router_devices', MetaData(bind=None), Column('device_id', VARCHAR(length=36), ForeignKey(u'midonet_gateway_devices.id'), table=<midonet_gateway_overlay_router_devices>, nullable=False), Column('resource_id', VARCHAR(length=36), ForeignKey(u'routers.id'), table=<midonet_gateway_overlay_router_devices>, nullable=False), schema=None)),
  ( 'remove_table',
    Table('midonet_logging_resources', MetaData(bind=None), Column('id', VARCHAR(length=36), table=<midonet_logging_resources>, primary_key=True, nullable=False), Column('name', VARCHAR(length=255), table=<midonet_logging_resources>), Column('description', VARCHAR(length=1024), table=<midonet_logging_resources>), Column('tenant_id', VARCHAR(length=255), table=<midonet_logging_resources>), Column('enabled', BOOLEAN(), table=<midonet_logging_resources>, nullable=False), schema=None)),
  ( 'remove_table',
    Table('firewall_router_associations', MetaData(bind=None), Column('fw_id', VARCHAR(length=36), ForeignKey(u'firewalls.id'), table=<firewall_router_associations>, primary_key=True, nullable=False), Column('router_id', VARCHAR(length=36), ForeignKey(u'routers.id'), table=<firewall_router_associations>, primary_key=True, nullable=False), schema=None)),
  ( 'remove_table',
    Table('bgp_speaker_router_associations', MetaData(bind=None), Column('bgp_speaker_id', VARCHAR(length=36), ForeignKey(u'bgp_speakers.id'), table=<bgp_speaker_router_associations>, primary_key=True, nullable=False), Column('router_id', VARCHAR(length=36), ForeignKey(u'routers.id'), table=<bgp_speaker_router_associations>, nullable=False), schema=None)),
  ( 'remove_table',
    Table('lbaas_loadbalanceragentbindings', MetaData(bind=None), Column('loadbalancer_id', VARCHAR(length=36), ForeignKey(u'lbaas_loadbalancers.id'), table=<lbaas_loadbalanceragentbindings>, primary_key=True, nullable=False), Column('agent_id', VARCHAR(length=36), ForeignKey(u'agents.id'), table=<lbaas_loadbalanceragentbindings>, nullable=False), schema=None)),
  ( 'remove_table',
    Table('midonet_firewall_logs', MetaData(bind=None), Column('id', VARCHAR(length=36), table=<midonet_firewall_logs>, primary_key=True, nullable=False), Column('logging_resource_id', VARCHAR(length=36), ForeignKey(u'midonet_logging_resources.id'), table=<midonet_firewall_logs>, nullable=False), Column('tenant_id', VARCHAR(length=255), table=<midonet_firewall_logs>), Column('description', VARCHAR(length=1024), table=<midonet_firewall_logs>), Column('fw_event', VARCHAR(length=255), table=<midonet_firewall_logs>, nullable=False), Column('firewall_id', VARCHAR(length=36), ForeignKey(u'firewalls.id'), table=<midonet_firewall_logs>, nullable=False), schema=None)),
  ( 'remove_table',
    Table('midonet_gateway_tunnel_ips', MetaData(bind=None), Column('device_id', VARCHAR(length=36), ForeignKey(u'midonet_gateway_devices.id'), table=<midonet_gateway_tunnel_ips>, nullable=False), Column('tunnel_ip', VARCHAR(length=64), table=<midonet_gateway_tunnel_ips>, nullable=False), schema=None)),
  ( 'remove_table',
    Table('vpn_endpoint_groups', MetaData(bind=None), Column('id', VARCHAR(length=36), table=<vpn_endpoint_groups>, primary_key=True, nullable=False), Column('tenant_id', VARCHAR(length=255), table=<vpn_endpoint_groups>), Column('name', VARCHAR(length=255), table=<vpn_endpoint_groups>), Column('description', VARCHAR(length=255), table=<vpn_endpoint_groups>), Column('endpoint_type', ENUM(u'subnet', u'cidr', u'vlan', u'network', u'router', name='endpoint_type'), table=<vpn_endpoint_groups>, nullable=False), schema=None)),
  ( 'remove_table',
    Table('vpn_endpoints', MetaData(bind=None), Column('endpoint', VARCHAR(length=255), table=<vpn_endpoints>, primary_key=True, nullable=False), Column('endpoint_group_id', VARCHAR(length=36), ForeignKey(u'vpn_endpoint_groups.id'), table=<vpn_endpoints>, primary_key=True, nullable=False), schema=None)),
  ( 'remove_table',
    Table('lbaas_loadbalancer_statistics', MetaData(bind=None), Column('loadbalancer_id', VARCHAR(length=36), ForeignKey(u'lbaas_loadbalancers.id'), table=<lbaas_loadbalancer_statistics>, primary_key=True, nullable=False), Column('bytes_in', BIGINT(), table=<lbaas_loadbalancer_statistics>, nullable=False), Column('bytes_out', BIGINT(), table=<lbaas_loadbalancer_statistics>, nullable=False), Column('active_connections', BIGINT(), table=<lbaas_loadbalancer_statistics>, nullable=False), Column('total_connections', BIGINT(), table=<lbaas_loadbalancer_statistics>, nullable=False), schema=None)),
  ( 'remove_table',
    Table('lbaas_loadbalancers', MetaData(bind=None), Column('tenant_id', VARCHAR(length=255), table=<lbaas_loadbalancers>), Column('id', VARCHAR(length=36), table=<lbaas_loadbalancers>, primary_key=True, nullable=False), Column('name', VARCHAR(length=255), table=<lbaas_loadbalancers>), Column('description', VARCHAR(length=255), table=<lbaas_loadbalancers>), Column('vip_port_id', VARCHAR(length=36), ForeignKey(u'ports.id'), table=<lbaas_loadbalancers>), Column('vip_subnet_id', VARCHAR(length=36), table=<lbaas_loadbalancers>, nullable=False), Column('vip_address', VARCHAR(length=36), table=<lbaas_loadbalancers>), Column('admin_state_up', BOOLEAN(), table=<lbaas_loadbalancers>, nullable=False), Column('provisioning_status', VARCHAR(length=16), table=<lbaas_loadbalancers>, nullable=False), Column('operating_status', VARCHAR(length=16), table=<lbaas_loadbalancers>, nullable=False), Column('flavor_id', VARCHAR(length=36), ForeignKey(u'flavors.id'), table=<lbaas_loadbalancers>), schema=None)),
  ( 'remove_table',
    Table('lbaas_members', MetaData(bind=None), Column('tenant_id', VARCHAR(length=255), table=<lbaas_members>), Column('id', VARCHAR(length=36), table=<lbaas_members>, primary_key=True, nullable=False), Column('pool_id', VARCHAR(length=36), ForeignKey(u'lbaas_pools.id'), table=<lbaas_members>, nullable=False), Column('subnet_id', VARCHAR(length=36), table=<lbaas_members>), Column('address', VARCHAR(length=64), table=<lbaas_members>, nullable=False), Column('protocol_port', INTEGER(), table=<lbaas_members>, nullable=False), Column('weight', INTEGER(), table=<lbaas_members>), Column('admin_state_up', BOOLEAN(), table=<lbaas_members>, nullable=False), Column('provisioning_status', VARCHAR(length=16), table=<lbaas_members>, nullable=False), Column('operating_status', VARCHAR(length=16), table=<lbaas_members>, nullable=False), Column('name', VARCHAR(length=255), table=<lbaas_members>), schema=None)),
  ( 'remove_table',
    Table('lbaas_sessionpersistences', MetaData(bind=None), Column('pool_id', VARCHAR(length=36), ForeignKey(u'lbaas_pools.id'), table=<lbaas_sessionpersistences>, primary_key=True, nullable=False), Column('type', ENUM(u'SOURCE_IP', u'HTTP_COOKIE', u'APP_COOKIE', name='sesssionpersistences_typev2'), table=<lbaas_sessionpersistences>, nullable=False), Column('cookie_name', VARCHAR(length=1024), table=<lbaas_sessionpersistences>), schema=None)),
  ( 'remove_table',
    Table('lbaas_pools', MetaData(bind=None), Column('tenant_id', VARCHAR(length=255), table=<lbaas_pools>), Column('id', VARCHAR(length=36), table=<lbaas_pools>, primary_key=True, nullable=False), Column('name', VARCHAR(length=255), table=<lbaas_pools>), Column('description', VARCHAR(length=255), table=<lbaas_pools>), Column('protocol', ENUM(u'HTTP', u'HTTPS', u'TCP', name='pool_protocolsv2'), table=<lbaas_pools>, nullable=False), Column('lb_algorithm', ENUM(u'ROUND_ROBIN', u'LEAST_CONNECTIONS', u'SOURCE_IP', name='lb_algorithmsv2'), table=<lbaas_pools>, nullable=False), Column('healthmonitor_id', VARCHAR(length=36), ForeignKey(u'lbaas_healthmonitors.id'), table=<lbaas_pools>), Column('admin_state_up', BOOLEAN(), table=<lbaas_pools>, nullable=False), Column('provisioning_status', VARCHAR(length=16), table=<lbaas_pools>, nullable=False), Column('operating_status', VARCHAR(length=16), table=<lbaas_pools>, nullable=False), Column('loadbalancer_id', VARCHAR(length=36), ForeignKey(u'lbaas_loadbalancers.id'), table=<lbaas_pools>), schema=None)),
  ( 'remove_table',
    Table('midonet_gateway_devices', MetaData(bind=None), Column('id', VARCHAR(length=36), table=<midonet_gateway_devices>, primary_key=True, nullable=False), Column('name', VARCHAR(length=255), table=<midonet_gateway_devices>), Column('type', VARCHAR(length=255), table=<midonet_gateway_devices>, nullable=False), Column('tenant_id', VARCHAR(length=255), table=<midonet_gateway_devices>), schema=None)),
  ( 'remove_table',
    Table('midonet_gateway_hw_vtep_devices', MetaData(bind=None), Column('device_id', VARCHAR(length=36), ForeignKey(u'midonet_gateway_devices.id'), table=<midonet_gateway_hw_vtep_devices>, nullable=False), Column('management_ip', VARCHAR(length=64), table=<midonet_gateway_hw_vtep_devices>, nullable=False), Column('management_port', INTEGER(), table=<midonet_gateway_hw_vtep_devices>, nullable=False), Column('management_protocol', VARCHAR(length=255), table=<midonet_gateway_hw_vtep_devices>, nullable=False), schema=None)),
  ( 'remove_table',
    Table('lbaas_healthmonitors', MetaData(bind=None), Column('tenant_id', VARCHAR(length=255), table=<lbaas_healthmonitors>), Column('id', VARCHAR(length=36), table=<lbaas_healthmonitors>, primary_key=True, nullable=False), Column('type', ENUM(u'PING', u'TCP', u'HTTP', u'HTTPS', name='healthmonitors_typev2'), table=<lbaas_healthmonitors>, nullable=False), Column('delay', INTEGER(), table=<lbaas_healthmonitors>, nullable=False), Column('timeout', INTEGER(), table=<lbaas_healthmonitors>, nullable=False), Column('max_retries', INTEGER(), table=<lbaas_healthmonitors>, nullable=False), Column('http_method', VARCHAR(length=16), table=<lbaas_healthmonitors>), Column('url_path', VARCHAR(length=255), table=<lbaas_healthmonitors>), Column('expected_codes', VARCHAR(length=64), table=<lbaas_healthmonitors>), Column('admin_state_up', BOOLEAN(), table=<lbaas_healthmonitors>, nullable=False), Column('provisioning_status', VARCHAR(length=16), table=<lbaas_healthmonitors>, nullable=False), Column('name', VARCHAR(length=255), table=<lbaas_healthmonitors>), schema=None)),
  ( 'remove_table',
    Table('midonet_gateway_network_vlan_devices', MetaData(bind=None), Column('device_id', VARCHAR(length=36), ForeignKey(u'midonet_gateway_devices.id'), table=<midonet_gateway_network_vlan_devices>, primary_key=True, nullable=False), Column('resource_id', VARCHAR(length=36), ForeignKey(u'networks.id'), table=<midonet_gateway_network_vlan_devices>, nullable=False), schema=None)),
  ( 'remove_table',
    Table('midonet_gateway_remote_mac_tables', MetaData(bind=None), Column('id', VARCHAR(length=36), table=<midonet_gateway_remote_mac_tables>, primary_key=True, nullable=False), Column('device_id', VARCHAR(length=36), ForeignKey(u'midonet_gateway_devices.id'), table=<midonet_gateway_remote_mac_tables>, nullable=False), Column('mac_address', VARCHAR(length=32), table=<midonet_gateway_remote_mac_tables>, nullable=False), Column('vtep_address', VARCHAR(length=64), table=<midonet_gateway_remote_mac_tables>, nullable=False), Column('segmentation_id', INTEGER(), table=<midonet_gateway_remote_mac_tables>), schema=None))]

[YAMAMOTO Takashi (yamamoto)]

it seems that many of them are due to inconsistent imports,
which should be fixed by https://review.openstack.org/#/c/308784/

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/334317

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/334317
Committed: https://git.openstack.org/cgit/openstack/networking-midonet/commit/?id=30665683f0b69f927ffcad1052f24507bc08740e
Submitter: Jenkins
Branch: master

commit 30665683f0b69f927ffcad1052f24507bc08740e
Author: YAMAMOTO Takashi <email address hidden>
Date: Mon Jun 27 16:27:13 2016 +0900

    Update test_migrations

    Partial-Bug: #1596423
    Change-Id: Ie101493f13d9dfe0d3ccc730048fbcc0c3eadd22

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/mitaka
Review: https://review.openstack.org/375479

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/375479
Committed: https://git.openstack.org/cgit/openstack/networking-midonet/commit/?id=9d5274d5ff1fa1d723b3a6dc5317d9feccd16e8d
Submitter: Jenkins
Branch: stable/mitaka

commit 9d5274d5ff1fa1d723b3a6dc5317d9feccd16e8d
Author: YAMAMOTO Takashi <email address hidden>
Date: Mon Jun 27 16:27:13 2016 +0900

    Update test_migrations

    Partial-Bug: #1596423
    Change-Id: Ie101493f13d9dfe0d3ccc730048fbcc0c3eadd22
    (cherry picked from commit 30665683f0b69f927ffcad1052f24507bc08740e)