yahoo-eng-team team mailing list archive

Thread
Date
[Bug 2025126] [NEW] Functional MySQL sync test failing with oslo/sqlalchemy master branch

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Slawek Kaplonski <2025126@xxxxxxxxxxxxxxxxxx>
Date: Tue, 27 Jun 2023 08:11:09 -0000
Reply-to: Bug 2025126 <2025126@xxxxxxxxxxxxxxxxxx>
Sender: noreply@xxxxxxxxxxxxx
Public bug reported:

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),

Failure examples:
* https://zuul.openstack.org/build/55a065238b784ac28e91469d2acce3da
* https://zuul.openstack.org/build/2d8d000b62a1448d984eab7059d677a7

** Affects: neutron
     Importance: Critical
         Status: Confirmed


** Tags: db functional-tests gate-failure

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/2025126

Title:
  Functional MySQL sync test failing with oslo/sqlalchemy master branch

Status in neutron:
  Confirmed

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),

  Failure examples:
  * https://zuul.openstack.org/build/55a065238b784ac28e91469d2acce3da
  * https://zuul.openstack.org/build/2d8d000b62a1448d984eab7059d677a7

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/2025126/+subscriptions
Follow ups

[Bug 2025126] Re: Functional MySQL sync test failing with oslo/sqlalchemy master branch
From: Rodolfo Alonso, 2023-07-04