Reviewed: https://review.openstack.org/358914 Committed: https://git.openstack.org/cgit/openstack/neutron-fwaas/commit/?id=228d93de381443808ebc755337fbff02963a0abb Submitter: Jenkins Branch: master
commit 228d93de381443808ebc755337fbff02963a0abb Author: YAMAMOTO Takashi <yamam...@midokura.com> Date: Tue Aug 23 09:42:13 2016 +0900 Fix db vs migration mismatches Fix the following mismatch found by test_migrations test. AssertionError: Models and migration scripts aren't in sync: [ ( 'remove_constraint', UniqueConstraint(Column('firewall_policy_id', VARCHAR(length=36), Foreig nKey(u'firewall_policies_v2.id'), ForeignKey(u'firewall_policies_v2.id'), table= <firewall_policy_rule_associations_v2>, primary_key=True, nullable=False))), ( 'remove_constraint', UniqueConstraint(Column('firewall_rule_id', VARCHAR(length=36), ForeignK ey(u'firewall_rules_v2.id'), ForeignKey(u'firewall_rules_v2.id'), table=<firewal l_policy_rule_associations_v2>, primary_key=True, nullable=False)))] Closes-Bug: #1615572 Change-Id: I3d53e715c73739dbb1cb351d92c417e540492a65 ** Changed in: neutron Status: In Progress => Fix Released -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1615572 Title: db vs migration mismatch in fwaas tables Status in networking-midonet: Invalid Status in neutron: Fix Released Bug description: AssertionError: Models and migration scripts aren't in sync: [ ( 'remove_index', Index('firewall_group_id', Column('firewall_group_id', VARCHAR(length=36), ForeignKey(u'firewall_groups_v2.id'), ForeignKey(u'firewall_groups_v2.id'), table=<firewall_group_port_associations_v2>, nullable=False), unique=True)), ( 'remove_index', Index('port_id', Column('port_id', VARCHAR(length=36), ForeignKey(u'ports.id'), ForeignKey(u'ports.id'), table=<firewall_group_port_associations_v2>, nullable=False), unique=True)), ( 'remove_fk', ForeignKeyConstraint(<sqlalchemy.sql.base.ColumnCollection object at 0x7fbfdd488ed0>, None, name=u'firewall_group_port_associations_v2_ibfk_2', ondelete=u'CASCADE', table=Table('firewall_group_port_associations_v2', MetaData(bind=None), Column('firewall_group_id', VARCHAR(length=36), ForeignKey(u'firewall_groups_v2.id'), ForeignKey(u'firewall_groups_v2.id'), table=<firewall_group_port_associations_v2>, nullable=False), Column('port_id', VARCHAR(length=36), ForeignKey(u'ports.id'), ForeignKey(u'ports.id'), table=<firewall_group_port_associations_v2>, nullable=False), schema=None))), ( 'remove_fk', ForeignKeyConstraint(<sqlalchemy.sql.base.ColumnCollection object at 0x7fbfdd488dd0>, None, name=u'firewall_group_port_associations_v2_ibfk_1', ondelete=u'CASCADE', table=Table('firewall_group_port_associations_v2', MetaData(bind=None), Column('firewall_group_id', VARCHAR(length=36), ForeignKey(u'firewall_groups_v2.id'), ForeignKey(u'firewall_groups_v2.id'), table=<firewall_group_port_associations_v2>, nullable=False), Column('port_id', VARCHAR(length=36), ForeignKey(u'ports.id'), ForeignKey(u'ports.id'), table=<firewall_group_port_associations_v2>, nullable=False), schema=None))), ( 'add_fk', ForeignKeyConstraint(<sqlalchemy.sql.base.ColumnCollection object at 0x7fbfdf29da10>, None, table=Table('firewall_group_port_associations_v2', MetaData(bind=None), Column('firewall_group_id', String(length=36), ForeignKey('firewall_groups_v2.id'), table=<firewall_group_port_associations_v2>, primary_key=True, nullable=False), Column('port_id', String(length=36), ForeignKey('ports.id'), table=<firewall_group_port_associations_v2>, primary_key=True, nullable=False), schema=None))), ( 'add_fk', ForeignKeyConstraint(<sqlalchemy.sql.base.ColumnCollection object at 0x7fbfdf29da90>, None, table=Table('firewall_group_port_associations_v2', MetaData(bind=None), Column('firewall_group_id', String(length=36), ForeignKey('firewall_groups_v2.id'), table=<firewall_group_port_associations_v2>, primary_key=True, nullable=False), Column('port_id', String(length=36), ForeignKey('ports.id'), table=<firewall_group_port_associations_v2>, primary_key=True, nullable=False), schema=None))), [ ( 'modify_type', None, 'firewall_groups_v2', 'project_id', { 'existing_nullable': True, 'existing_server_default': False}, VARCHAR(length=36), String(length=255))], [ ( 'modify_type', None, 'firewall_groups_v2', 'status', { 'existing_nullable': True, 'existing_server_default': False}, VARCHAR(length=255), String(length=16))], ( 'add_fk', ForeignKeyConstraint(<sqlalchemy.sql.base.ColumnCollection object at 0x7fbfdf29d250>, None, table=Table('firewall_groups_v2', MetaData(bind=None), Column('project_id', String(length=255), table=<firewall_groups_v2>), Column('id', String(length=36), table=<firewall_groups_v2>, primary_key=True, nullable=False, default=ColumnDefault(<function <lambda> at 0x7fbfe03bc758>)), Column('name', String(length=255), table=<firewall_groups_v2>), Column('description', String(length=1024), table=<firewall_groups_v2>), Column('public', Boolean(), table=<firewall_groups_v2>), Column('ingress_firewall_policy_id', String(length=36), ForeignKey('firewall_policies_v2.id'), table=<firewall_groups_v2>), Column('egress_firewall_policy_id', String(length=36), ForeignKey('firewall_policies_v2.id'), table=<firewall_groups_v2>), Column('admin_state_up', Boolean(), table=<firewall_groups_v2>), Column('status', String(length=16), table=<firewall_groups_v2>), schema=None))), ( 'add_fk', ForeignKeyConstraint(<sqlalchemy.sql.base.ColumnCollection object at 0x7fbfdf29d310>, None, table=Table('firewall_groups_v2', MetaData(bind=None), Column('project_id', String(length=255), table=<firewall_groups_v2>), Column('id', String(length=36), table=<firewall_groups_v2>, primary_key=True, nullable=False, default=ColumnDefault(<function <lambda> at 0x7fbfe03bc758>)), Column('name', String(length=255), table=<firewall_groups_v2>), Column('description', String(length=1024), table=<firewall_groups_v2>), Column('public', Boolean(), table=<firewall_groups_v2>), Column('ingress_firewall_policy_id', String(length=36), ForeignKey('firewall_policies_v2.id'), table=<firewall_groups_v2>), Column('egress_firewall_policy_id', String(length=36), ForeignKey('firewall_policies_v2.id'), table=<firewall_groups_v2>), Column('admin_state_up', Boolean(), table=<firewall_groups_v2>), Column('status', String(length=16), table=<firewall_groups_v2>), schema=None))), [ ( 'modify_type', None, 'firewall_policies_v2', 'project_id', { 'existing_nullable': True, 'existing_server_default': False}, VARCHAR(length=36), String(length=255))], [ ( 'modify_nullable', None, 'firewall_rules_v2', 'ip_version', { 'existing_server_default': False, 'existing_type': INTEGER(display_width=11)}, False, True)], [ ( 'modify_type', None, 'firewall_rules_v2', 'project_id', { 'existing_nullable': True, 'existing_server_default': False}, VARCHAR(length=36), String(length=255))]] To manage notifications about this bug go to: https://bugs.launchpad.net/networking-midonet/+bug/1615572/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp