yahoo-eng-team team mailing list archive

[melanie witt <1868037@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Seen in a proposed patch to openstack/requirements to bump alembic to
version 1.4.1 [1]:

ft1.2: nova.tests.unit.db.test_migrations.TestNovaMigrationsMySQL.test_models_synctesttools.testresult.real._StringException: pythonlogging:'': {{{
2020-03-18 16:14:19,329 INFO [oslo_db.sqlalchemy.provision] CREATE BACKEND mysql+pymysql://openstack_citest:openstack_citest@localhost/ TOKEN mrqueplpat
2020-03-18 16:14:25,702 INFO [248_add_expire_reservations_index] Skipped adding reservations_deleted_expire_idx because an equivalent index already exists.
2020-03-18 16:14:35,890 INFO [oslo_db.sqlalchemy.provision] DROP ALL OBJECTS, BACKEND mysql+pymysql://openstack_citest:openstack_citest@localhost/mrqueplpat
2020-03-18 16:14:35,898 INFO [oslo_db.sqlalchemy.provision] DROP BACKEND Engine(mysql+pymysql://openstack_citest:***@localhost/) TOKEN mrqueplpat
2020-03-18 16:14:35,901 INFO [oslo_db.sqlalchemy.provision] DISPOSE ENGINE Engine(mysql+pymysql://openstack_citest:***@localhost/)
}}}

Traceback (most recent call last):
  File "/home/zuul/src/opendev.org/openstack/nova/.tox/py36/lib/python3.6/site-packages/oslo_db/sqlalchemy/test_migrations.py", line 598, in test_models_sync
    "Models and migration scripts aren't in sync:\n%s" % msg)
  File "/home/zuul/src/opendev.org/openstack/nova/.tox/py36/lib/python3.6/site-packages/unittest2/case.py", line 690, in fail
    raise self.failureException(msg)
AssertionError: Models and migration scripts aren't in sync:
[ [ ( 'modify_type',
      None,
      'instance_type_extra_specs',
      'key',
      { 'existing_comment': None,
        'existing_nullable': True,
        'existing_server_default': False},
      VARCHAR(collation='utf8_bin', length=255),
      String(length=255))],
  [ ( 'modify_type',
      None,
      'instance_type_extra_specs',
      'value',
      { 'existing_comment': None,
        'existing_nullable': True,
        'existing_server_default': False},
      VARCHAR(collation='utf8_bin', length=255),
      String(length=255))],
  [ ( 'modify_type',
      None,
      'resource_providers',
      'name',
      { 'existing_comment': None,
        'existing_nullable': True,
        'existing_server_default': False},
      VARCHAR(charset='utf8', length=200),
      Unicode(length=200))]]

[1] https://review.opendev.org/708706

** Affects: nova
     Importance: Low
     Assignee: melanie witt (melwitt)
         Status: In Progress


** Tags: testing

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1868037

Title:
  nova.tests.unit.db.test_migrations.TestNovaMigrationsMySQL.test_models_sync
  fails with alembic 1.4.1

Status in OpenStack Compute (nova):
  In Progress

Bug description:
  Seen in a proposed patch to openstack/requirements to bump alembic to
  version 1.4.1 [1]:

  ft1.2: nova.tests.unit.db.test_migrations.TestNovaMigrationsMySQL.test_models_synctesttools.testresult.real._StringException: pythonlogging:'': {{{
  2020-03-18 16:14:19,329 INFO [oslo_db.sqlalchemy.provision] CREATE BACKEND mysql+pymysql://openstack_citest:openstack_citest@localhost/ TOKEN mrqueplpat
  2020-03-18 16:14:25,702 INFO [248_add_expire_reservations_index] Skipped adding reservations_deleted_expire_idx because an equivalent index already exists.
  2020-03-18 16:14:35,890 INFO [oslo_db.sqlalchemy.provision] DROP ALL OBJECTS, BACKEND mysql+pymysql://openstack_citest:openstack_citest@localhost/mrqueplpat
  2020-03-18 16:14:35,898 INFO [oslo_db.sqlalchemy.provision] DROP BACKEND Engine(mysql+pymysql://openstack_citest:***@localhost/) TOKEN mrqueplpat
  2020-03-18 16:14:35,901 INFO [oslo_db.sqlalchemy.provision] DISPOSE ENGINE Engine(mysql+pymysql://openstack_citest:***@localhost/)
  }}}

  Traceback (most recent call last):
    File "/home/zuul/src/opendev.org/openstack/nova/.tox/py36/lib/python3.6/site-packages/oslo_db/sqlalchemy/test_migrations.py", line 598, in test_models_sync
      "Models and migration scripts aren't in sync:\n%s" % msg)
    File "/home/zuul/src/opendev.org/openstack/nova/.tox/py36/lib/python3.6/site-packages/unittest2/case.py", line 690, in fail
      raise self.failureException(msg)
  AssertionError: Models and migration scripts aren't in sync:
  [ [ ( 'modify_type',
        None,
        'instance_type_extra_specs',
        'key',
        { 'existing_comment': None,
          'existing_nullable': True,
          'existing_server_default': False},
        VARCHAR(collation='utf8_bin', length=255),
        String(length=255))],
    [ ( 'modify_type',
        None,
        'instance_type_extra_specs',
        'value',
        { 'existing_comment': None,
          'existing_nullable': True,
          'existing_server_default': False},
        VARCHAR(collation='utf8_bin', length=255),
        String(length=255))],
    [ ( 'modify_type',
        None,
        'resource_providers',
        'name',
        { 'existing_comment': None,
          'existing_nullable': True,
          'existing_server_default': False},
        VARCHAR(charset='utf8', length=200),
        Unicode(length=200))]]

  [1] https://review.opendev.org/708706

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1868037/+subscriptions