i still see mismatches on pgsql
** Changed in: neutron
Status: Fix Released => New
--
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:
New
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 : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
