neutron

Functional MySQL sync test failing with oslo/sqlalchemy master branch

Bug #2025126 reported by Slawek Kaplonski on 2023-06-27

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	neutron	Fix Released	Critical	Rodolfo Alonso

Bug Description

Since some time, periodic jobs neutron-functional-with-oslo-master and neutron-functional-with-sqlalchemy-master are failing with one test failed:

neutron.tests.functional.db.test_migrations.TestModelsMigrationsMySQL.test_models_sync

Stacktrace:

ft1.4: neutron.tests.functional.db.test_migrations.TestModelsMigrationsMySQL.test_models_synctesttools.testresult.real._StringException: Traceback (most recent call last):
  File "/home/zuul/src/opendev.org/openstack/neutron/neutron/tests/base.py", line 178, in func
    return f(self, *args, **kwargs)
  File "/home/zuul/src/opendev.org/openstack/neutron/neutron/tests/functional/db/test_migrations.py", line 382, in test_models_sync
    super(TestModelsMigrationsMySQL, self).test_models_sync()
  File "/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-functional-gate/lib/python3.10/site-packages/oslo_db/sqlalchemy/test_migrations.py", line 284, in test_models_sync
    self.fail(
  File "/usr/lib/python3.10/unittest/case.py", line 675, in fail
    raise self.failureException(msg)
AssertionError: Models and migration scripts aren't in sync:
[ [ ( 'modify_default',
      None,
      'ml2_distributed_port_bindings',
      'vif_details',
      { 'existing_comment': None,
        'existing_nullable': False,
        'existing_type': VARCHAR(length=4095)},
      DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f875a14ae30>, for_update=False),
      DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f875eff4640>, for_update=False))],
  [ ( 'modify_default',
      None,
      'ml2_distributed_port_bindings',
      'profile',
      { 'existing_comment': None,
        'existing_nullable': False,
        'existing_type': VARCHAR(length=4095)},
      DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f87599f8a90>, for_update=False),
      DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f875eff4640>, for_update=False))],
  [ ( 'modify_default',
      None,
      'ml2_port_bindings',
      'profile',
      { 'existing_comment': None,
        'existing_nullable': False,
        'existing_type': VARCHAR(length=4095)},
      DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f87598e9a20>, for_update=False),
      DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f875eff4640>, for_update=False))],
  [ ( 'modify_default',
      None,
      'ml2_port_bindings',
      'vif_details',
      { 'existing_comment': None,
        'existing_nullable': False,
        'existing_type': VARCHAR(length=4095)},
      DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f87598e9ae0>, for_update=False),
      DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f875eff4640>, for_update=False))],
  [ ( 'modify_default',
      None,
      'portdnses',
      'dns_domain',
      { 'existing_comment': None,
        'existing_nullable': False,
        'existing_type': VARCHAR(length=255)},
      DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f8759dc6f20>, for_update=False),
      DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f875eff4640>, for_update=False))],
  [ ( 'modify_default',
      None,
      'subnetpools',
      'hash',
      { 'existing_comment': None,
        'existing_nullable': False,
        'existing_type': VARCHAR(length=36)},
      DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7f875aab60b0>, for_update=False),