← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1526762] [NEW] test_models_sync fails with TestNovaMigrationsSQLite unti test

 

Public bug reported:

{0}
nova.tests.unit.db.test_migrations.TestNovaMigrationsSQLite.test_models_sync
[2.360350s] ... FAILED

Captured traceback:
~~~~~~~~~~~~~~~~~~~
    Traceback (most recent call last):
      File "/backup/nova/.tox/py27/lib/python2.7/site-packages/oslo_db/sqlalchemy/test_migrations.py", line 603, in test_models_sync
        "Models and migration scripts aren't in sync:\n%s" % msg)
      File "/backup/nova/.tox/py27/lib/python2.7/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,
          'bw_usage_cache',
          'bw_in',
          { 'existing_nullable': True,
            'existing_server_default': False},
          INTEGER(),
          BigInteger())],
      [ ( 'modify_type',
          None,
          'bw_usage_cache',
          'bw_out',
          { 'existing_nullable': True,
            'existing_server_default': False},
          INTEGER(),
          BigInteger())],
      [ ( 'modify_type',
          None,
          'bw_usage_cache',
          'last_ctr_in',
          { 'existing_nullable': True,
            'existing_server_default': False},
          INTEGER(),
          BigInteger())],
      [ ( 'modify_type',
          None,
          'bw_usage_cache',
          'last_ctr_out',
          { 'existing_nullable': True,
            'existing_server_default': False},
          INTEGER(),
          BigInteger())],
      [ ( 'modify_type',
          None,
          'volume_usage_cache',
          'curr_read_bytes',
          { 'existing_nullable': True,
            'existing_server_default': False},
          INTEGER(),
          BigInteger())],
      [ ( 'modify_type',
          None,
          'volume_usage_cache',
          'curr_reads',
          { 'existing_nullable': True,
            'existing_server_default': False},
          INTEGER(),
          BigInteger())],
      [ ( 'modify_type',
          None,
          'volume_usage_cache',
          'curr_write_bytes',
          { 'existing_nullable': True,
            'existing_server_default': False},
          INTEGER(),
          BigInteger())],
      [ ( 'modify_type',
          None,
          'volume_usage_cache',
          'curr_writes',
          { 'existing_nullable': True,
            'existing_server_default': False},
          INTEGER(),
          BigInteger())],
      [ ( 'modify_type',
          None,
          'volume_usage_cache',
          'tot_read_bytes',
          { 'existing_nullable': True,
            'existing_server_default': False},
          INTEGER(),
          BigInteger())],
      [ ( 'modify_type',
          None,
          'volume_usage_cache',
          'tot_reads',
          { 'existing_nullable': True,
            'existing_server_default': False},
          INTEGER(),
          BigInteger())],
      [ ( 'modify_type',
          None,
          'volume_usage_cache',
          'tot_write_bytes',
          { 'existing_nullable': True,
            'existing_server_default': False},
          INTEGER(),
          BigInteger())],
      [ ( 'modify_type',
          None,
          'volume_usage_cache',
          'tot_writes',
          { 'existing_nullable': True,
            'existing_server_default': False},
          INTEGER(),
          BigInteger())]]
    

Captured pythonlogging:
~~~~~~~~~~~~~~~~~~~~~~~
    2015-12-16 13:56:50,022 WARNING [oslo_reports.guru_meditation_report] Guru mediation now registers SIGUSR1 and SIGUSR2 by default for backward compatibility. SIGUSR1 will no longer be registered in a future release, so please use SIGUSR2 to generate reports.
    2015-12-16 13:56:50,160 INFO [oslo_db.sqlalchemy.provision] CREATE BACKEND sqlite:// TOKEN lcrzkzzinb
    2015-12-16 13:56:51,211 INFO [248_add_expire_reservations_index] Skipped adding reservations_deleted_expire_idx because an equivalent index already exists.
    2015-12-16 13:56:52,058 INFO [alembic.runtime.migration] Context impl SQLiteImpl.
    2015-12-16 13:56:52,058 INFO [alembic.runtime.migration] Will assume non-transactional DDL.
    2015-12-16 13:56:52,242 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'bw_usage_cache.bw_in'
    2015-12-16 13:56:52,243 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'bw_usage_cache.bw_out'
    2015-12-16 13:56:52,243 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'bw_usage_cache.last_ctr_in'
    2015-12-16 13:56:52,243 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'bw_usage_cache.last_ctr_out'
    2015-12-16 13:56:52,264 INFO [alembic.autogenerate.compare] Detected removed column 'instances.scheduled_at'
    2015-12-16 13:56:52,280 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'volume_usage_cache.curr_read_bytes'
    2015-12-16 13:56:52,280 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'volume_usage_cache.curr_reads'
    2015-12-16 13:56:52,280 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'volume_usage_cache.curr_write_bytes'
    2015-12-16 13:56:52,280 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'volume_usage_cache.curr_writes'
    2015-12-16 13:56:52,281 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'volume_usage_cache.tot_read_bytes'
    2015-12-16 13:56:52,281 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'volume_usage_cache.tot_reads'
    2015-12-16 13:56:52,281 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'volume_usage_cache.tot_write_bytes'
    2015-12-16 13:56:52,281 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'volume_usage_cache.tot_writes'
    2015-12-16 13:56:52,376 INFO [oslo_db.sqlalchemy.provision] DROP ALL OBJECTS, BACKEND sqlite://
    2015-12-16 13:56:52,377 INFO [oslo_db.sqlalchemy.provision] DROP BACKEND Engine(sqlite://) TOKEN lcrzkzzinb


Reproducible with latest master

A bit similar like this one in Neutron:
Bug #1526675

** Affects: nova
     Importance: Undecided
         Status: New

-- 
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/1526762

Title:
   test_models_sync fails with TestNovaMigrationsSQLite unti test

Status in OpenStack Compute (nova):
  New

Bug description:
  {0}
  nova.tests.unit.db.test_migrations.TestNovaMigrationsSQLite.test_models_sync
  [2.360350s] ... FAILED

  Captured traceback:
  ~~~~~~~~~~~~~~~~~~~
      Traceback (most recent call last):
        File "/backup/nova/.tox/py27/lib/python2.7/site-packages/oslo_db/sqlalchemy/test_migrations.py", line 603, in test_models_sync
          "Models and migration scripts aren't in sync:\n%s" % msg)
        File "/backup/nova/.tox/py27/lib/python2.7/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,
            'bw_usage_cache',
            'bw_in',
            { 'existing_nullable': True,
              'existing_server_default': False},
            INTEGER(),
            BigInteger())],
        [ ( 'modify_type',
            None,
            'bw_usage_cache',
            'bw_out',
            { 'existing_nullable': True,
              'existing_server_default': False},
            INTEGER(),
            BigInteger())],
        [ ( 'modify_type',
            None,
            'bw_usage_cache',
            'last_ctr_in',
            { 'existing_nullable': True,
              'existing_server_default': False},
            INTEGER(),
            BigInteger())],
        [ ( 'modify_type',
            None,
            'bw_usage_cache',
            'last_ctr_out',
            { 'existing_nullable': True,
              'existing_server_default': False},
            INTEGER(),
            BigInteger())],
        [ ( 'modify_type',
            None,
            'volume_usage_cache',
            'curr_read_bytes',
            { 'existing_nullable': True,
              'existing_server_default': False},
            INTEGER(),
            BigInteger())],
        [ ( 'modify_type',
            None,
            'volume_usage_cache',
            'curr_reads',
            { 'existing_nullable': True,
              'existing_server_default': False},
            INTEGER(),
            BigInteger())],
        [ ( 'modify_type',
            None,
            'volume_usage_cache',
            'curr_write_bytes',
            { 'existing_nullable': True,
              'existing_server_default': False},
            INTEGER(),
            BigInteger())],
        [ ( 'modify_type',
            None,
            'volume_usage_cache',
            'curr_writes',
            { 'existing_nullable': True,
              'existing_server_default': False},
            INTEGER(),
            BigInteger())],
        [ ( 'modify_type',
            None,
            'volume_usage_cache',
            'tot_read_bytes',
            { 'existing_nullable': True,
              'existing_server_default': False},
            INTEGER(),
            BigInteger())],
        [ ( 'modify_type',
            None,
            'volume_usage_cache',
            'tot_reads',
            { 'existing_nullable': True,
              'existing_server_default': False},
            INTEGER(),
            BigInteger())],
        [ ( 'modify_type',
            None,
            'volume_usage_cache',
            'tot_write_bytes',
            { 'existing_nullable': True,
              'existing_server_default': False},
            INTEGER(),
            BigInteger())],
        [ ( 'modify_type',
            None,
            'volume_usage_cache',
            'tot_writes',
            { 'existing_nullable': True,
              'existing_server_default': False},
            INTEGER(),
            BigInteger())]]
      

  Captured pythonlogging:
  ~~~~~~~~~~~~~~~~~~~~~~~
      2015-12-16 13:56:50,022 WARNING [oslo_reports.guru_meditation_report] Guru mediation now registers SIGUSR1 and SIGUSR2 by default for backward compatibility. SIGUSR1 will no longer be registered in a future release, so please use SIGUSR2 to generate reports.
      2015-12-16 13:56:50,160 INFO [oslo_db.sqlalchemy.provision] CREATE BACKEND sqlite:// TOKEN lcrzkzzinb
      2015-12-16 13:56:51,211 INFO [248_add_expire_reservations_index] Skipped adding reservations_deleted_expire_idx because an equivalent index already exists.
      2015-12-16 13:56:52,058 INFO [alembic.runtime.migration] Context impl SQLiteImpl.
      2015-12-16 13:56:52,058 INFO [alembic.runtime.migration] Will assume non-transactional DDL.
      2015-12-16 13:56:52,242 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'bw_usage_cache.bw_in'
      2015-12-16 13:56:52,243 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'bw_usage_cache.bw_out'
      2015-12-16 13:56:52,243 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'bw_usage_cache.last_ctr_in'
      2015-12-16 13:56:52,243 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'bw_usage_cache.last_ctr_out'
      2015-12-16 13:56:52,264 INFO [alembic.autogenerate.compare] Detected removed column 'instances.scheduled_at'
      2015-12-16 13:56:52,280 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'volume_usage_cache.curr_read_bytes'
      2015-12-16 13:56:52,280 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'volume_usage_cache.curr_reads'
      2015-12-16 13:56:52,280 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'volume_usage_cache.curr_write_bytes'
      2015-12-16 13:56:52,280 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'volume_usage_cache.curr_writes'
      2015-12-16 13:56:52,281 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'volume_usage_cache.tot_read_bytes'
      2015-12-16 13:56:52,281 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'volume_usage_cache.tot_reads'
      2015-12-16 13:56:52,281 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'volume_usage_cache.tot_write_bytes'
      2015-12-16 13:56:52,281 INFO [alembic.autogenerate.compare] Detected type change from INTEGER() to BigInteger() on 'volume_usage_cache.tot_writes'
      2015-12-16 13:56:52,376 INFO [oslo_db.sqlalchemy.provision] DROP ALL OBJECTS, BACKEND sqlite://
      2015-12-16 13:56:52,377 INFO [oslo_db.sqlalchemy.provision] DROP BACKEND Engine(sqlite://) TOKEN lcrzkzzinb

  
  Reproducible with latest master

  A bit similar like this one in Neutron:
  Bug #1526675

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