yahoo-eng-team team mailing list archive

[Sagar Waghmare <1815726@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

nova-manage db sync --version <version number> is failing with stack
trace as below,

[stack@hostname ~]$ nova-manage db sync --version 392
.
.
.
ERROR: Could not access cell0.
Has the nova_api database been created?
Has the nova_cell0 database been created?
Has "nova-manage api_db sync" been run?
Has "nova-manage cell_v2 map_cell0" been run?
Is [api_database]/connection set in nova.conf?
Is the cell0 database connection URL correct?
Error: "Database schema file with version 392 doesn't exist."
An error has occurred:
Traceback (most recent call last):
  File "/opt/stack/nova/nova/cmd/manage.py", line 2357, in main
    ret = fn(*fn_args, **fn_kwargs)
  File "/opt/stack/nova/nova/cmd/manage.py", line 490, in sync
    return migration.db_sync(version)
  File "/opt/stack/nova/nova/db/migration.py", line 26, in db_sync
    return IMPL.db_sync(version=version, database=database, context=context)
  File "/opt/stack/nova/nova/db/sqlalchemy/migration.py", line 61, in db_sync
    repository, version)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
    return _migrate(url, repository, version, upgrade=True, err=err, **opts)
  File "<decorator-gen-15>", line 2, in _migrate
  File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
    return f(*a, **kw)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 345, in _migrate
    changeset = schema.changeset(version)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 82, in changeset
    changeset = self.repository.changeset(database, start_ver, version)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/repository.py", line 225, in changeset
    changes = [self.version(v).script(database, op) for v in versions]
  File "/usr/lib/python2.7/site-packages/migrate/versioning/repository.py", line 189, in version
    return self.versions.version(*p, **k)
  File "/usr/lib/python2.7/site-packages/migrate/versioning/version.py", line 174, in version
    "exist.") % {'args': VerNum(vernum)})
VersionNotFoundError: "Database schema file with version 392 doesn't exist."


As, '--version' parameter was deprecated in the Pike cycle and will not be supported in future versions of nova, the expected error message is as below,

ERROR: Could not access cell0.
Has the nova_api database been created?
Has the nova_cell0 database been created?
Has "nova-manage api_db sync" been run?
Has "nova-manage cell_v2 map_cell0" been run?
Is [api_database]/connection set in nova.conf?
Is the cell0 database connection URL correct?
Error: "Database schema file with version 392 doesn't exist."


Openstack version: openstack 3.17.0 (Rocky)

** 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/1815726

Title:
  nova-manage db sync --version <version number>  command failed with
  stack trace.

Status in OpenStack Compute (nova):
  New

Bug description:
  nova-manage db sync --version <version number> is failing with stack
  trace as below,

  [stack@hostname ~]$ nova-manage db sync --version 392
  .
  .
  .
  ERROR: Could not access cell0.
  Has the nova_api database been created?
  Has the nova_cell0 database been created?
  Has "nova-manage api_db sync" been run?
  Has "nova-manage cell_v2 map_cell0" been run?
  Is [api_database]/connection set in nova.conf?
  Is the cell0 database connection URL correct?
  Error: "Database schema file with version 392 doesn't exist."
  An error has occurred:
  Traceback (most recent call last):
    File "/opt/stack/nova/nova/cmd/manage.py", line 2357, in main
      ret = fn(*fn_args, **fn_kwargs)
    File "/opt/stack/nova/nova/cmd/manage.py", line 490, in sync
      return migration.db_sync(version)
    File "/opt/stack/nova/nova/db/migration.py", line 26, in db_sync
      return IMPL.db_sync(version=version, database=database, context=context)
    File "/opt/stack/nova/nova/db/sqlalchemy/migration.py", line 61, in db_sync
      repository, version)
    File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade
      return _migrate(url, repository, version, upgrade=True, err=err, **opts)
    File "<decorator-gen-15>", line 2, in _migrate
    File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
      return f(*a, **kw)
    File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 345, in _migrate
      changeset = schema.changeset(version)
    File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 82, in changeset
      changeset = self.repository.changeset(database, start_ver, version)
    File "/usr/lib/python2.7/site-packages/migrate/versioning/repository.py", line 225, in changeset
      changes = [self.version(v).script(database, op) for v in versions]
    File "/usr/lib/python2.7/site-packages/migrate/versioning/repository.py", line 189, in version
      return self.versions.version(*p, **k)
    File "/usr/lib/python2.7/site-packages/migrate/versioning/version.py", line 174, in version
      "exist.") % {'args': VerNum(vernum)})
  VersionNotFoundError: "Database schema file with version 392 doesn't exist."

  
  As, '--version' parameter was deprecated in the Pike cycle and will not be supported in future versions of nova, the expected error message is as below,

  ERROR: Could not access cell0.
  Has the nova_api database been created?
  Has the nova_cell0 database been created?
  Has "nova-manage api_db sync" been run?
  Has "nova-manage cell_v2 map_cell0" been run?
  Is [api_database]/connection set in nova.conf?
  Is the cell0 database connection URL correct?
  Error: "Database schema file with version 392 doesn't exist."

  
  Openstack version: openstack 3.17.0 (Rocky)

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