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
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
