gate-networking-midonet-python27 failure due to migration model mismatch in lbaas

[YAMAMOTO Takashi]

http://logs.openstack.org/87/199387/19/check/gate-networking-midonet-python27/ca59d1c/

2016-03-01 13:40:44.994 | Captured traceback:
2016-03-01 13:40:44.994 | ~~~~~~~~~~~~~~~~~~~
2016-03-01 13:40:44.994 | Traceback (most recent call last):
2016-03-01 13:40:44.995 | File "/home/jenkins/workspace/gate-networking-midonet-python27/.tox/py27/local/lib/python2.7/site-packages/oslo_db/sqlalchemy/test_migrations.py", line 615, in test_models_sync
2016-03-01 13:40:44.995 | "Models and migration scripts aren't in sync:\n%s" % msg)
2016-03-01 13:40:44.995 | File "/home/jenkins/workspace/gate-networking-midonet-python27/.tox/py27/local/lib/python2.7/site-packages/unittest2/case.py", line 690, in fail
2016-03-01 13:40:44.995 | raise self.failureException(msg)
2016-03-01 13:40:44.995 | AssertionError: Models and migration scripts aren't in sync:
2016-03-01 13:40:44.995 | [ ( 'add_index',
2016-03-01 13:40:44.995 | Index('ix_lbaas_l7policies_tenant_id', Column('tenant_id', String(length=255), table=<lbaas_l7policies>))),
2016-03-01 13:40:44.996 | ( 'add_index',
2016-03-01 13:40:44.996 | Index('ix_lbaas_l7rules_tenant_id', Column('tenant_id', String(length=255), table=<lbaas_l7rules>)))]

[YAMAMOTO Takashi (yamamoto)]

i added neutron as it looks like a bug in neutron-lbaas repo.

[YAMAMOTO Takashi (yamamoto)]

let me take a look.

see also https://bugs.launchpad.net/neutron/+bug/1549699

[OpenStack Infra (hudson-openstack)]

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

[YAMAMOTO Takashi (yamamoto)]

    AssertionError: Models and migration scripts aren't in sync:
    [ ( 'add_index', Index('ix_lbaas_l7policies_tenant_id', Column('tenant_id', String(length=255), table=<lbaas_l7policies>))), ( 'add_index', Index('ix_lbaas_l7rules_tenant_id', Column('tenant_id', String(length=255), table=<lbaas_l7rules>))), ( 'remove_fk', ForeignKeyConstraint(<sqlalchemy.sql.base.ColumnCollection object at 0x7f86b807e8d0>, None, name=u'nsxv_edge_monitor_mappings_ibfk_1', ondelete=u'CASCADE', table=Table('nsxv_edge_monitor_mappings', MetaData(bind=None), Column('monit
or_id', VARCHAR(length=36), ForeignKey(u'healthmonitors.id'), ForeignKey(u'healt
hmonitors.id'), table=<nsxv_edge_monitor_mappings>, primary_key=True, nullable=False), Column('edge_id', VARCHAR(length=36), table=<nsxv_edge_monitor_mappings>, nullable=False), Column('edge_monitor_id', VARCHAR(length=36), table=<nsxv_edge_monitor_mappings>, nullable=False), schema=None))), ( 'add_fk', ForeignKeyConstraint(<sqlalchemy.sql.base.ColumnCollection object at 0x7f86b92e1550>, None, table=Table('nsxv_edge_monitor_mappings', MetaData(bind=None), Column('monitor_id', String(length=36), ForeignKey('healthmonitors.id'), table=<nsxv_edge_monitor_mappings>, primary_key=True, nullable=False), Column('edge_
id', String(length=36), table=<nsxv_edge_monitor_mappings>, primary_key=True, nu
llable=False), Column('edge_monitor_id', String(length=36), table=<nsxv_edge_mon
itor_mappings>, nullable=False), schema=None))),
      ( 'remove_fk',
        ForeignKeyConstraint(<sqlalchemy.sql.base.ColumnCollection object at 0x7
f86b807ec90>, None, name=u'nsxv_edge_pool_mappings_ibfk_1', ondelete=u'CASCADE',
 table=Table('nsxv_edge_pool_mappings', MetaData(bind=None), Column('pool_id', V
ARCHAR(length=36), ForeignKey(u'pools.id'), ForeignKey(u'pools.id'), table=<nsxv
_edge_pool_mappings>, primary_key=True, nullable=False), Column('edge_id', VARCH
AR(length=36), table=<nsxv_edge_pool_mappings>, nullable=False), Column('edge_po
ol_id', VARCHAR(length=36), table=<nsxv_edge_pool_mappings>, nullable=False), sc
hema=None))),
      ( 'add_fk',
        ForeignKeyConstraint(<sqlalchemy.sql.base.ColumnCollection object at 0x7
f86b92c8a50>, None, table=Table('nsxv_edge_pool_mappings', MetaData(bind=None),
Column('pool_id', String(length=36), ForeignKey('pools.id'), table=<nsxv_edge_po
ol_mappings>, primary_key=True, nullable=False), Column('edge_id', String(length
=36), table=<nsxv_edge_pool_mappings>, nullable=False), Column('edge_pool_id', S
tring(length=36), table=<nsxv_edge_pool_mappings>, nullable=False), schema=None)
)),
      ( 'remove_fk',
        ForeignKeyConstraint(<sqlalchemy.sql.base.ColumnCollection object at 0x7f86b80890d0>, None, name=u'nsxv_edge_vip_mappings_ibfk_1', ondelete=u'CASCADE', table=Table('nsxv_edge_vip_mappings', MetaData(bind=None), Column('pool_id', VARCHAR(length=36), ForeignKey(u'pools.id'), ForeignKey(u'pools.id'), table=<nsxv_edge_vip_mappings>, primary_key=True, nullable=False), Column('edge_id', VARCHAR(length=36), table=<nsxv_edge_vip_mappings>, nullable=False), Column('edge_app_profile_id', VARCHAR(length=36), table=<nsxv_edge_vip_mappings>, nullable=False...

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

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

[Henry Gessau (gessau)]

I targeted to Mitaka-RC1 as this is a serious bug,

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/287014
Committed: https://git.openstack.org/cgit/openstack/neutron-lbaas/commit/?id=9af74e56b9c93c60aa21b2af72ec1aae6f0b7664
Submitter: Jenkins
Branch: master

commit 9af74e56b9c93c60aa21b2af72ec1aae6f0b7664
Author: YAMAMOTO Takashi <email address hidden>
Date: Wed Mar 2 04:08:00 2016 +0900

    Fix model vs migration mismatches for L7 rules and policies

    Partial-Bug: #1552063
    Change-Id: I8888d42bc986fd71665526bd99ae2053ef5473e8

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/287015
Committed: https://git.openstack.org/cgit/openstack/neutron-lbaas/commit/?id=a7d195ad70896bc09578ebb35c8a152938708446
Submitter: Jenkins
Branch: master

commit a7d195ad70896bc09578ebb35c8a152938708446
Author: YAMAMOTO Takashi <email address hidden>
Date: Wed Mar 2 04:28:13 2016 +0900

    Fix model vs migration mismatches in nsxv tables

    Closes-Bug: #1552063
    Change-Id: I258b7b5ac9d9c09fa382b5673f6790dfc148b274

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/287000
Committed: https://git.openstack.org/cgit/openstack/networking-midonet/commit/?id=8767af3ba436a8400e35d6cdbe56b41deb74cd4a
Submitter: Jenkins
Branch: master

commit 8767af3ba436a8400e35d6cdbe56b41deb74cd4a
Author: YAMAMOTO Takashi <email address hidden>
Date: Wed Mar 2 14:55:39 2016 +0900

    test_migrations: Exclude a few LBaaS tables

    They seem to have migration vs model mismatches and
    there's no reason to test them in networking-midonet.

    Closes-Bug: #1552063
    Change-Id: I4a63e64062589d278e5b69e61e6be367c5bc900a

[Thierry Carrez (ttx)]

This issue was fixed in the openstack/neutron-lbaas 8.0.0.0rc1 release candidate.