yahoo-eng-team team mailing list archive

[melanie witt <1868037@xxxxxxxxxxxxxxxxxx>]

Mike Bayer informed us that these are bugs in alembic:

https://github.com/sqlalchemy/alembic/issues/671

which will be fixed in version 1.4.2

** Bug watch added: github.com/sqlalchemy/alembic/issues #671
   https://github.com/sqlalchemy/alembic/issues/671

** Changed in: nova
       Status: In Progress => Invalid

-- 
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):
  Invalid

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